Healthcare Data Analyst - SQL, AWS, Power BI

Swetha Pothu

Data Analyst

MA, USA *************@*****.*** +1-508-***-**** LinkedIn Github Portfolio SUMMARY

Data Analyst with around 6 years of experience in healthcare analytics, Medicaid population health, and supply chain intelligence, specializing in claims analytics, EHR/EMR data, and payer-provider workflows.

Strong expertise in advanced SQL, Python, and AWS (S3, Glue, Redshift, Athena) for scalable ETL/ELT pipelines, data warehousing, and analytics engineering.

In-depth knowledge of healthcare data ecosystems, including claims adjudication, prior authorization, HEDIS quality metrics, ICD- 10/CPT coding, HIPAA/PHI compliance, and revenue cycle analytics.

Proficient in data modeling (star schema, dimensional modeling), data lakes, and distributed data processing, enabling high- performance, analytics-ready datasets.

Advanced expertise in Power BI (DAX), Tableau, and executive dashboarding, delivering KPI frameworks for utilization, cost of care, LOS, readmissions, and population health outcomes.

Strong foundation in statistical modeling, predictive analytics, cohort segmentation, risk stratification, and A/B testing, driving forecasting accuracy and care optimization strategies.

Expertise in data governance, data lineage, metadata management, and audit-ready reporting frameworks, ensuring regulatory compliance and enterprise data quality.

Knowledge of clinical data standards and interoperability (EHR/EMR systems, HL7, FHIR) and scalable cloud-based analytics architectures for healthcare data platforms.

PROFESSIONAL EXPERIENCE

McKesson Data Analyst USA Jul 2025 – Present

Analyzed and cleansed healthcare distribution data using advanced SQL and Python to build Power BI (DAX) dashboards tracking SKU demand, OTIF, SLA, and inventory turns, reducing stockouts by 18%.

Developed automated ETL pipelines with Python, Airflow, and AWS (S3, Redshift), implementing Star-schema dimensional modeling, data quality rules, and warehouse optimization, reducing manual data prep.

Collaborated with supply chain, finance, and product teams to translate business requirements into standardized KPIs and implement enterprise data governance (data lineage, MDM, metadata management) for regulatory-compliant reporting.

Applied statistical analysis, hypothesis testing, and predictive modeling using scikit-learn and R to improve forecast accuracy and optimize assortment planning across 23,000+ SKUs.

Executed SQL-driven cohort segmentation, A/B testing, and cost-to-serve analysis to evaluate channel performance, promotional lift, and margin variance, strengthening marketing ROI and executive decision-making. Aetna Health Data Analyst USA Feb 2023 – May 2025

Analyzed Medicaid claims and EHR datasets using SQL to assess preventive care utilization, prenatal visit adherence, and screening compliance across female member populations, identifying actionable gaps in maternal and reproductive health programs.

Designed ETL workflows leveraging AWS Glue and Amazon S3 to extract, transform, and standardize multi-source clinical and enrollment data, loading curated datasets into Amazon Redshift to support quality measurement and regulatory reporting.

Developed interactive Power BI dashboards with DAX-calculated healthcare KPIs to track HEDIS performance, maternal health outcomes, and demographic disparities, enabling data-driven outreach prioritization.

Performed exploratory data analysis and predictive modeling using Python (pandas, NumPy, scikit-learn) to engineer risk features and estimate likelihood of missed screenings and adverse maternal outcomes.

Implemented data governance controls including validation rules, metadata documentation, and lineage tracking to ensure Medicaid- compliant, audit-ready reporting for women’s health initiatives.

Conducted cohort stratification and A/B testing to evaluate effectiveness of targeted preventive care outreach campaigns, refining engagement strategies for high-risk member segments.

Collaborated with clinical operations and care coordination teams to convert program objectives into measurable analytical frameworks, delivering evidence-based insights to strengthen population health management. LTI Mindtree Data Analyst India Aug 2019 – June 2022

Executed enterprise data discovery using SQL and Alteryx across ERP, CRM, and digital datasets, performing data cleaning and exploratory data analysis (EDA) to identify inconsistencies and improve analytics reliability during transformation initiatives.

Built business intelligence solutions using Tableau by designing semantic data layers and structured KPI frameworks, enabling leadership to monitor revenue leakage, churn trends, and operational performance metrics.

Consolidated structured and unstructured data using Pandas and NumPy to develop customer 360 analytical views that strengthened segmentation precision and personalization strategies.

Translated business requirements into analytical roadmaps by documenting metric hierarchies, defining performance benchmarks, and aligning reporting logic with stakeholder objectives.

Constructed scenario-based forecasting models and sensitivity analyses using statistical methods and regression techniques to evaluate digital transformation impact and support investment planning decisions.

Communicated validated analytical findings through hypothesis testing and variance analysis, delivering executive-ready insights that encouraged data-driven decision-making across teams. CORE SKILLS

Data Analysis & Analytics: Data Analysis, Exploratory Data Analysis (EDA), Trend Analysis, Pattern Identification, Statistical Analysis, Predictive Analytics, Scenario Analysis, Cohort Analysis, A/B Testing, KPI Analysis, Performance Analysis, Risk Analysis, Client Segmentation

Programming & Scripting: Python, Pandas, NumPy, Statsmodels, Scikit-learn, R, SQL, Advanced SQL Databases & Querying: MySQL, MS SQL Server, Data Warehousing Concepts, Query Optimization, Data Joins, Aggregations ETL & Data Engineering: ETL (SSRS, SSIS, SSAS), Data Pipelines, Data Integration, Data Transformation, Dataset Engineering, Analysis- Ready Data Preparation

Data Visualization & BI: Power BI, DAX, Tableau, QlikView, Interactive Dashboards, Executive Reporting, Data Storytelling, KPI Dashboards, Visual Analytics

Statistics & Modeling: Regression Analysis, Random Forest, Time Series Analysis, Forecasting, Hypothesis Testing, Variance Analysis, Volatility Analysis

Cloud & Platforms: AWS Glue, AWS S3, Amazon Redshift, AWS Athena, Cloud Data Platforms, Distributed Data Processing, Scalable Analytics Environments

Data Governance & Quality: Data Governance, Data Validation, Data Quality Controls, Metric Standardization, Data Reconciliation, Regulatory & Compliance Reporting

Business & Decision Support: Data-Driven Decision Making, Business Insights, Advisory Support, Stakeholder Enablement, Operational Optimization

Tools & Productivity: Microsoft Excel (Advanced), Power Query, Jupyter Notebook Collaboration & Methodologies: Stakeholder Collaboration, Requirements Gathering, Cross-Functional Communication, Agile Analytics Support

PROJECTS

Marketing Campaign Performance Analysis – Airline In-Flight Catering Tools: Excel, Tableau, R, Survey Design, Statistical Analysis

Conducted survey-based analysis on airline passenger satisfaction and preferences

Built interactive dashboard comparing Delta and American Airlines across satisfaction, cultural, and sustainability metrics

Delivered insights on purchase intent, packaging preference, and dietary accommodation using Likert-scale visualizations Link: https://public.tableau.com/views/AirlineMarketingCampaignPassengerPreferencesSatisfaction/Dashboard1 Shopify E-Commerce Growth Strategy

Developed and managed a Shopify store, optimizing conversions and customer engagement

Implemented digital marketing strategies that increased website traffic by 40% within three months

Managed social media advertising and content creation, leading to a 25% increase in engagement Inventory Management System Dashboard

Tools: Tableau, Data Visualization, KPI Metric

Using simulated inventory data, created an interactive dashboard to monitor product stock levels, reorder thresholds, and category- specific distribution.

Visualized inventory data, including total stock value, in-stock product KPIs, and purchasing trends, to aid decision-making in inventory management.

Link: https://public.tableau.com/views/InventoryManagementSystemDashboard/InventoryManagementDashboard Bitcoin Price Strategy & Volatility Dashboard

Tools: Python, Pandas, Tableau, Time Series Analysis

Analyzed over 4.8 million minute-level Bitcoin trades from 2012–2021 to identify pricing patterns, volatility zones, and market behavior

Engineered calculated metrics to capture hourly volatility and constructed KPIs for maximum price and average trading volume

Developed an interactive Tableau dashboard with multi-level trend analysis, volatility heatmaps, and dynamic visual insights for trading strategy

Link: https://public.tableau.com/views/BitcoinPriceStrategyVolatilityDashboard20122021/Dashboard1 Airbnb NYC Price Prediction & Analytics

Tools: R, Tableau, Data Visualization, Random Forest, Linear Regression

Built predictive models using R to estimate Airbnb listing prices based on location, availability, and customer reviews

Achieved 93% model accuracy with Random Forest; performed data cleaning, dummy encoding, VIF checks

Designed and published an interactive Tableau dashboard featuring KPIs, heatmaps, scatter plots, and a NYC map Link: https://public.tableau.com/views/AirbnbNYCPricePredictionAnalytics/AirbnbNYCPriceAvailabilityListingInsights EDUCATION

Master of Science in Business Analytics Aug 2022 – May 2024 Clark University Graduate School of Management Worcester, MA CERTIFICATIONS

Google Analytics 4 Certification

Credentialed in GA4 reporting, user behavior analysis, and web traffic optimization

Responsible Conduct of Research (RCR) – CITI Program

Trained in ethical standards for research involving human data (IRB-certified)

Stukent Digital Marketing

Completed internship with practical projects in Google Ads, SEO, and campaign design

Contact this candidate