Dinesh Reddy Pattem

About Dinesh Reddy Pattem

As a Data Analyst with over 5 years of experience, I specialize in transforming complex datasets into clear, actionable insights that drive strategic business decisions. My expertise lies in analyzing and visualizing large datasets, building predictive models, and enhancing reporting accuracy to improve operational performance across industries such as healthcare, finance, and retail.Throughout my career, I’ve led initiatives to optimize data pipelines, validate data integrity, and create dashboards using tools like Power BI, Excel, Python, SQL, and Snowflake. At UnitedHealth Group, I helped reduce reporting time by 40% through automation and built over 30 dashboards that improved business decision-making. At Capgemini, I handled large-scale data transformations and contributed to analytics projects involving over 50TB of data.I’m proficient in predictive and prescriptive analytics, data storytelling, and root cause analysis, ensuring leadership has a clear view of performance metrics, customer behavior, and risk exposure. I\'m deeply committed to data governance and compliance (HIPAA, GDPR), and passionate about creating robust data solutions that are both scalable and business-aligned.Collaboration is central to my work—I’ve partnered with cross-functional teams in sales, operations, and engineering to uncover insights that boost efficiency and profitability. I also enjoy mentoring junior analysts and staying current with evolving tools and techniques in analytics and machine learning.If you\'re looking for a data-driven problem solver who can translate data into decisions, feel free to connect. I\'m always open to collaborating on exciting projects or discussing the latest in analytics and technology.Skills: SQL | Python | Power BI | Excel | Data Cleaning | Data Visualization | Predictive Analytics | Reporting Automation | ETL | Azure | Snowflake | Data Modeling | Business Intelligence | Root Cause Analysis | Data Validation | Data Governance

Experience

1. Data Analyst Healthcare Analytics, Sql, Tableau, Aws

   CVS Health

   Jan 2024 — Present · US

   Key Achievements:Transformed complex healthcare datasets into actionable insights, leading to a 45% improvement in data throughput by collaborating with engineering teams on over 30 ETL workflows using AWS Glue and Spark.Developed and maintained large-scale cloud-based data lakes on AWS Redshift, optimizing access to over 120TB of data and reducing query response time by 40% for reporting and analytics teams.Built and automated dynamic Tableau dashboards (including Gantt charts and geospatial views), resulting in a 30% faster delivery of clinical insights to key stakeholders.Leveraged SQL, Python, and Athena to clean, analyze, and visualize clinical and operational data, improving decision-making across business and care teams.Conducted predictive analysis using machine learning models to enhance forecasting accuracy of clinical outcomes by 35%, positively impacting care strategies for patients.Ensured HIPAA-compliant data practices by deploying secure metadata management with AWS Glue and Apache Atlas, reducing audit prep time by 25%.Supported incident response analytics by automating over 200 reporting workflows via Apache Airflow and monitoring with AWS CloudWatch, reducing alert resolution time by 28%.Partnered with data engineers, product managers, and clinical teams to define key KPIs, data definitions, and build scalable datasets aligned with stakeholder needs.

Education

• Illinois Institute of Technology

  Master

  2023 — 2024

• Sri Chandrsekharendra Saraswathi Vishwamahavidyala

  Bachelor of Technology

  2017 — 2021