data analyst

Lakshmi Suma Metpalli

Business Data Analyst

*******.************@*****.*** +1-660-***-**** Linkedin

SUMMARY

Results-driven Data Analyst with 5+ years of experience delivering healthcare analytics, clinical research

reporting, business intelligence solutions, ETL optimization, and enterprise reporting across healthcare and

analytics environments. Strong expertise in SQL, Python, SAS, Tableau, Power BI, Snowflake, Databricks, AWS,

and Azure with hands-on experience supporting clinical operations, healthcare KPI reporting, HIPAA-compliant

analytics ecosystems, and cloud-based data platforms. Proven success improving reporting accuracy,

troubleshooting production data issues, automating executive dashboards, optimizing ETL pipelines, and

translating complex datasets into actionable business insights that support operational efficiency and strategic

decision-making.

SKILLS

Clinical Research & Healthcare Systems: Experienced in supporting clinical research operations, regulatory

reporting, and healthcare data management workflows across enterprise clinical systems. Advarra

EDC/eSource/eReg, OnCore CTMS, REDCap, Electronic Data Capture (EDC), Clinical Trial Management Systems

(CTMS), Clinical Research Operations, Regulatory & IRB Reporting, Clinical Data Management, AE/SAE &

Deviation Reporting.

Programming, Analytics & Biostatistics: Skilled in statistical analysis, predictive analytics, and data validation

using SQL, Python, SAS, and R for healthcare and business reporting solutions. SQL, SAS, R, Python (Pandas,

NumPy), Biostatistics, Statistical Analysis, Data Validation, Data Cleaning, Predictive Analytics, Clinical Data

Analysis.

Business Intelligence & Reporting: Proficient in developing interactive dashboards, KPI reporting solutions, and

scalable BI platforms supporting enterprise analytics initiatives. Snowflake, Tableau, Power BI, Dashboard

Development, ETL/ELT Pipelines, Data Modeling, KPI Reporting, Ad Hoc Reporting, Healthcare Analytics,

Business Intelligence Reporting.

Healthcare & Research Knowledge: Strong understanding of healthcare analytics, clinical trial reporting, HIPAA

compliance, and enterprise research informatics environments. Clinical Trials, Healthcare Analytics, HIPAA

Compliance, Research Informatics, EHR/Epic Data Understanding, Data Governance, Research Reporting.

Cloud & Tools: Hands-on experience working with cloud platforms, enterprise databases, DevOps tools, and

collaborative analytics technologies. AWS (S3, EC2, RDS, Lambda), SQL Server, Oracle, Azure DevOps, Jira, Git.

Professional Skills: Adept at collaborating with cross-functional teams, gathering requirements, troubleshooting

issues, and supporting end-to-end analytics delivery. Stakeholder Communication, Cross-functional

Collaboration, Requirement Gathering, Documentation, Problem Solving, Process Improvement, UAT Testing,

Technical Support.

CERTIFICATIONS

GoogleDataAnalytics Professional Certificate Coursera

MicrosoftPL-300: Power BI DataAnalystAssociate

AIFor Everyone byAndrew Ng Coursera (Completed)

AWSCertifiedData Analytics Specialty (In Progress)

DatabricksCertified Data Engineer Associate (InProgress)

EXPERIENCE

Business Data Analyst, HCA Healthcare, USA Dec 2024 Present

Developed 20+ Power BI and Tableau dashboards supporting healthcare KPI reporting, patient outcome

analytics, and executive decision-making, reducing manual reporting effort by 68%.

Optimized SQL, Snowflake, and PostgreSQL queries using stored procedures, CTEs, and window functions,

improving dashboard refresh performance by 46%.

Integrated Epic Clarity, Epic Caboodle, REDCap, Advarra EDC, and OnCore CTMS datasets into centralized

healthcare reporting models supporting 500+ users.

Automated ETL and reporting workflows using Python, SAS, Azure Data Factory, and Apache Airflow,

decreasing reporting turnaround time by 75%.

Investigated production reporting discrepancies caused by ETL mapping failures and restored 100%

reporting accuracy within 24 hours.

Implemented HIPAA-compliant reporting solutions using row-level security (RLS), RBAC, and audit

validation processes, reducing compliance issues by 37%.

Business Data Analyst, Cigna Healthcare, USA Jan 2024 Dec 2024

Designed ETL/ELT pipelines using AWS Glue, SQL, Python, and Apache Airflow to process 20M+

healthcare records monthly with 39% improved efficiency.

Built Power BI dashboards supporting claims analytics, healthcare utilization reporting, and operational

KPI tracking across enterprise healthcare systems.

Diagnosed recurring reporting issues caused by inconsistent joins between claims and member datasets,

eliminating 25% variance in downstream reports.

Conducted statistical analysis and biostatistics reporting using SAS and R, supporting initiatives that

generated approximately $360K in annual savings.

Consolidated Oracle, SQL Server, and Snowflake datasets into governed semantic data models,

improving reporting consistency by 48%.

Validated EDC and CTMS datasets against regulatory and IRB reporting requirements, reducing

compliance-related reporting discrepancies by 31%.

Data Analyst, Tutorac Private Ltd, India July 2020 Nov 2022

Engineered Power BI and Tableau dashboards for operational analytics and KPI reporting, reducing

manual reporting efforts by 59%.

Streamlined SQL-based reporting workflows processing 6M+ records monthly, improving reporting

performance by 38%.

Automated recurring reports using Python and Pandas, reducing reporting turnaround time from 6

hours to under 40 minutes.

Diagnosed duplicate learner identifier issues during ETL ingestion and restored reporting accuracy within

48 hours.

Built predictive analytics models identifying learner engagement trends, improving campaign targeting

efficiency by 26%.

Consolidated MySQL and Oracle datasets into centralized reporting platforms, increasing data

accessibility for leadership teams by 42%.

Investigated missing transactional records affecting finance dashboards and corrected transformation

logic recovering approximately $95K in discrepancies.

Data Analyst, CloudRay Private Ltd, India Jun 2018 - Jul 2020

Developed SQL and Python-based reporting solutions that reduced monthly reporting effort by 64 hours

and improved reporting accuracy by 74%.

Created Tableau dashboards tracking customer behavior, revenue trends, and operational KPIs,

improving executive reporting visibility by 22%.

Implemented ETL validation and data cleansing workflows across MySQL and Oracle systems, improving

reporting consistency by 46%.

Diagnosed ETL pipeline failures caused by malformed source files and schema drift, restoring production

data loads 54% faster.

Built Apache Airflow workflows processing over 1.3M records daily, increasing pipeline availability to

99.4%.

Conducted root cause analysis on missing transactional data affecting executive dashboards and

restored reporting completeness to 100%.

EDUCATION

Master s in Computer Science, University of Central Missouri, Missouri, USA Jan 2023 - Dec 2024

Bachelor s in Computer Science, JNT University, India Jun 2014 - May 2018

Contact this candidate