Dinesh Reddy Pattem

Data Analyst | Healthcare Analytics, SQL, Tableau, AWS @ CVS Health

About

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

Country

United States

City

Chicago

Industry

Information Technology & Services

Skill

Data Cleaning & Transformation , Data Visualization , Reporting Automation , Anomaly Detection, Advanced Analytics & Modeling Statistical Analysis, Power BI / Tableau, Python , Azure Data Factory, Apache Spark, Data Architects, Data Architecture, Data Maintenance, Talend, FastLoad, BTEQ, Real-Time Data Processing, SQL Server Reporting Services (SSRS), Data Warehouse Design, Data Integration, Operating Systems: Windows, Linux

Experience

Data Analyst | Healthcare Analytics, SQL, Tableau, AWS

CVS Health

2024-1 - Present · 2 yrs 9 mos

United States

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 10,000+ 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.

Data Analyst | Azure Data Factory, SQL, Talend & Real-Time Analytics

Accenture

2019-7 - 2022-12 · 3 yrs 6 mos

India

Delivered campaign performance optimization for enterprise clients by leveraging Adobe Analytics, Tableau, and SQL, generating segmented insights that improved lead conversion rates by 20%. Developed A/B and incrementality (holdout) testing frameworks to measure true marketing ROI and improve audience targeting strategies. Automated multi-channel marketing reports using Fivetran, Alteryx, and Azure Data Factory, accelerating delivery of daily KPI dashboards to stakeholders. Built and deployed ETL pipelines using Talend and Apache NiFi for integrating Salesforce and ERP data into Snowflake and Redshift, enhancing campaign attribution analysis. Engineered secure and scalable data models using Star Schema design principles in Snowflake, increasing reporting accuracy and reducing query latency by 35%. Collaborated with marketing, sales, and product teams to define KPIs and build actionable dashboards in Tableau and Power BI. Developed fraud detection and credit risk models in Python (Scikit-learn, XGBoost), which reduced false positives by 25% and improved credit decision cycles. Supported the integration of data from legacy systems into AWS S3, Redshift, and Snowflake, ensuring continuous data delivery for operational and analytical use cases.