Data Analyst ETL, Dashboards, Automation

Harshada Daund

ï LinkedIn # ***************@*****.*** H +1-315-***-****

Summary

Data Analyst with 4+ years of experience in designing ETL pipelines, building interactive dashboards, and optimizing data workflows. Skilled in leveraging Python, SQL, Power BI, Tableau, and cloud platforms (Azure, Databricks, Snowflake) to deliver actionable insights and support data-driven decision-making. Strong background in data cleaning, validation, predictive analytics, and automation, with a proven track record of reducing reporting effort, enhancing data quality, and improving process efficiency in cross-functional, agile environments. Work Experience

Data Analyst Feb 2025 - Present

HCA Healthcare, USA

• Designed and orchestrated end-to-end ETL pipelines in Azure Data Factory and Databricks, integrating EHR/EMR datasets (Epic Clarity, Cerner) and leveraging Linked Services with parameterized workflows to reduce data processing latency by 40% through optimized scheduling and parallelized workloads.

• Developed interactive Tableau dashboards with drill-down reports and dynamic filters, visualizing patient admissions, claims data, and readmission rates, which improved stakeholder self-service analytics and increased adoption by 30%.

• Automated Excel-based reporting templates using Pivot Tables, Power Query, and dynamic charts to standardize pre- sentation of clinical KPIs, ICD-10/CPT-coded claims, and quality metrics, reducing manual effort by 35% and improving compliance tracking.

• Implemented complex SQL queries and stored procedures for multi-source data extraction and transformation across HL7 feeds, payer claims, and hospital billing systems, enhancing reporting accuracy and reducing reconciliation errors by 25%.

• Built Python automation scripts for repetitive clinical data validation and patient outcome tracking, saving the team 12+ hours per week and ensuring higher data consistency across regulatory submissions and HIPAA compliant datasets.

• Optimized Snowflake data warehouse schemas and query execution plans to handle large-scale healthcare utilization data, provider performance metrics, and compliance audits, improving query performance by 45% and enabling seamless integration with Tableau dashboards.

Data Analyst Jan 2023 - Jul 2023

Streebo Inc, India

• Extracted, cleaned, and transformed multi-source data using SQL and Python, building ETL pipelines that streamlined reporting workflows and improved data flow efficiency.

• Developed and automated Power BI dashboards with KPIs on demographics, shopping trends, and cart abandonment, reducing manual reporting effort by 40% and enabling real-time business insights.

• Leveraged Excel (Pivot Tables, advanced formulas) and Python trend analysis to segment customer data, forecast demand, and improve inventory planning accuracy by 15%.

• Conducted A/B testing and campaign analysis, optimizing promotional strategies and increasing customer conversion rates by 12%.

Data Analyst (Assistant System Engineer) Jul 2021 - Dec 2022 Tata Consultancy Services (TCS), India

• Collected, cleaned, and transformed financial datasets using SQL and Python (Pandas, NumPy) to support accurate reporting and analysis.

• Built interactive dashboards and reports in Power BI and Excel to visualize key performance metrics and trends for business stakeholders.

• Performed exploratory data analysis (EDA) and statistical modeling to identify anomalies, patterns, and process ineffi- ciencies in financial data.

• Developed SQL scripts and stored procedures for data extraction, transformation, and reconciliation across multiple financial systems.

• Automated recurring reporting tasks with Python and Excel Macros, reducing manual effort and improving productivity by 40%.

• Partnered with cross-functional agile teams to define data requirements, ensure accuracy, and support decision making across projects.

• Conducted ad-hoc analysis and prepared insights-driven presentations for leadership, enabling data-backed strategic planning.

Data Analyst Jan 2020 - Jun 2021

Hexaware Technologies, India

• Developed a Healthcare Claims Analytics Platform to analyze patient claims, clinical data, and treatment history, improving operational efficiency and enabling data-driven decisions for healthcare administrators.

• Extracted, cleaned, and transformed large-scale datasets using Python (Pandas, NumPy) and SQL, ensuring data accu- racy and compliance with HIPAA standards.

• Designed and implemented ETL pipelines to integrate data from claims systems, EHR databases, and provider logs into a centralized PostgreSQL data warehouse, supporting reporting and advanced analytics.

• Conducted exploratory data analysis (EDA) and statistical profiling to identify trends in treatment costs, claim denials, and patient utilization patterns, providing actionable insights for care management teams.

• Created interactive dashboards and visualizations using Power BI, displaying KPIs such as claim processing times,denial rates, and patient outcomes, improving reporting efficiency for stakeholders.

• Collaborated with senior data scientists to develop predictive models using scikit-learn, forecasting high-cost claims and enabling preventive care interventions, reducing unnecessary expenditures by 10–12%.

• Documented data workflows, transformation logic, and visual standards; contributed to stakeholder meetings to ensure analytics solutions aligned with business and regulatory requirements. Technical Skills

Programming & Scripting: Python (Pandas, NumPy, scikit-learn, Automation Scripts), SQL (Advanced Queries, Stored Proce- dures), Excel (Pivot Tables, Power Query, Advanced Formulas, Macros) ETL Development & Optimization: Azure Data Factory (Pipelines, Linked Services, Parameterized Workflows), Databricks, Snowflake (Schema Optimization, Query Tuning), PostgreSQL, HL7 Feeds, ETL Development, Data Quality Checks Data Visualization & BI: Tableau (Interactive Dashboards, Drill-Down Reports, Dynamic Filters), Power BI (KPIs, Interactive Reports), Excel (Charts, Reports)

Data Analysis & Statistics: Exploratory Data Analysis (EDA), Statistical Modeling, Trend Analysis, Forecasting, A/B Testing, Campaign Analysis, Regression Modeling (scikit-learn) Healthcare & Domain Data: EHR/EMR Data (Epic Clarity, Cerner), Claims Data (ICD-10, CPT Codes, Payer Claims), Provider Performance Metrics, Hospital Billing Systems, HIPAA Compliance Automation & Productivity: Python Automation Scripts, Excel Macros, Automated Reporting Templates, Process Optimization, Data Validation Scripts

Collaboration & Tools: Jira, Confluence, Agile/Scrum Practices, Requirement Gathering Workshops, Documentation (Data Work- flows, Transformation Logic, Visualization Guidelines) Education

Masters of Science in Applied Data Science

Syracuse University, Syracuse, New York Aug 2023 - May 2025 Bachelors of Engineering in Computer Engineering

University of Mumbai, Mumbai, India Aug 2017 - Jun 2021

Contact this candidate