Data Analyst Senior

Harsha Pyla

Senior Data Analyst +1-314-***-**** Email: *************@*****.*** LinkedIn

Professional Summary

Business & Data Analyst with 4+ years of experience in data engineering, analytics, and financial systems, specializing in PL, Oracle Exadata, KYC onboarding, and wholesale credit products. Proven ability to design robust ETL pipelines, perform complex data analysis, and deliver tested, business-ready solutions in healthcare, finance, and supply chain. Adept at requirements refinement, risk identification, and stakeholder communication across technical and executive levels. Skilled in SQL, Python, Power BI, Tableau, and cloud platforms. Technical Skills & Certifications

• Languages: PL, SQL, Python, R, Scala, JavaScript

• Databases: Oracle Exadata, MySQL, PostgreSQL, MongoDB, Redshift, Teradata

• BI & Reporting: Power BI, Tableau, Looker, Excel

• ETL & Orchestration: Informatica, SSIS, Alteryx, Airflow, DBT

• Cloud Platforms: AWS, Azure, GCP, Snowflake, Databricks

• Techniques: Data Profiling, Data Mapping, Forecasting, Statistical Testing, Regression, KPI Analysis, Test Scenarios

• Certifications: Power BI Data Methods, Data Visualization Specialist, Google Analytics

• Soft Skills: Analytical Thinking, Attention to Detail, Problem Solving, Communication, Agile Collaboration Professional Experience

Senior Data Analyst Garmin — Remote

Jan 2024 – Present

• Designed PL/SQL-based ETL pipelines integrated with Oracle Exadata, enabling accurate ingestion and transformation of supply chain datasets, reducing manual intervention by 40%.

• Partnered with business teams on requirements gathering, story refinement, and test scenario design, ensuring 100% alignment of analytics solutions with operational KPIs.

• Developed and deployed Tableau/Power BI dashboards tracking inventory and wholesale credit performance, boosting visibility into demand fluctuations by 35%.

• Automated reporting and reconciliation using Python and SQL stored procedures, reducing reporting cycle time by 45% and ensuring error-free outputs.

• Conducted data mapping and profiling to support KYC onboarding and compliance reporting, improving client onboarding turnaround time by 20%.

• Facilitated sprint planning and estimation sessions in Agile, influencing prioritization and achieving 95% on-time delivery rate.

• Integrated predictive forecasting models with AWS Lambda, delivering scalable insights for proactive decision-making and minimizing stockouts by 18%.

• Coordinated cross-functional workshops translating technical details into executive summaries, improving stakeholder adoption of analytics solutions by 30%.

Senior Data Analyst HCA Midwest Health — Kansas, USA May 2023 – Dec 2023

• Built Oracle PL/SQL queries and automated pipelines to process clinical/financial data, improving turnaround time for compliance reporting by 25%.

• Designed end-to-end test scenarios and validations for healthcare ETL workflows, ensuring 98% accuracy in patient admission forecasts.

• Partnered with stakeholders on requirement definition and KPI identification, producing actionable Tableau dashboards for executive teams.

• Implemented Alteryx workflows with embedded data quality checkpoints, reducing transformation errors by 30%.

• Contributed to HIPAA-compliant governance frameworks by documenting data lineage and mappings, improving audit readiness scores by 20%.

• Facilitated sprint reviews and backlog prioritization in Agile teams, ensuring effective delivery of analytics features for clinical users.

Data Analyst American Family Insurance — Mumbai, India Sep 2021 – Dec 2022

• Modeled wholesale credit trends using Tableau/Looker dashboards, enabling business teams to track seasonal insurance policy demand with 90% forecast accuracy.

• Developed and optimized PL stored procedures for regulatory reporting, improving execution efficiency by 40%.

• Conducted A/B testing to evaluate pricing changes, influencing premium strategies and increasing profitability by 12%.

• Migrated ETL workflows to DBT and GCP, reducing data pipeline latency by 25%.

• Supported credit risk analysis by performing complex joins, CTEs, and window functions in Oracle 10g SQL.

• Collaborated with compliance teams on KYC and onboarding processes, ensuring adherence to regulatory timelines and improving client satisfaction metrics.

Programmer Analyst Truist Bank — Mumbai, India

Mar 2020 – Aug 2021

• Automated ETL workflows using SSIS, Informatica, and SQL Server, cutting manual processing time by 35%.

• Wrote complex Oracle SQL queries and stored procedures supporting regulatory reporting, ensuring 100% compliance accuracy.

• Partnered with financial analysts to design reporting dashboards in Power BI, improving visibility into credit risk metrics by 25%.

• Contributed to data migration from on-premise Oracle to Azure Data Lake, ensuring seamless transfer with zero downtime.

Education

Master of Science, Computing & Information Science Saint Louis University MO, USA Jan 2023 – Dec 2024

Contact this candidate