Open to opportunities

Bharath Pathi

@bharathpathi

Message

Senior data analyst transforming multi-source data into actionable insights using SQL, Python, and BI tools.

Zimbabwe

Message

What I'm looking for

I’m looking for a role where I can own end-to-end analytics work—ETL/ELT, data warehousing modernization, and executive BI—while partnering with leadership to turn insights into measurable business outcomes.

I’m a Senior Data Analyst with around 5 years of experience transforming complex, multi-source data into actionable insights and business decisions. I specialize in SQL, Python, PySpark, and analytics workflows across AWS and modern data warehouses like Amazon Redshift and Snowflake.

At Capgemini and the University of Connecticut, I’ve led high-impact migrations and pipeline work—migrating 100+ Teradata BTEQ scripts to Redshift/Snowflake with zero downtime and 99.9% data accuracy, and building ETL/ELT pipelines using AWS Glue and Apache Airflow/MWAA. I also create executive-ready dashboards in Power BI and Tableau, including DAX-driven models that inform leadership decisions around student retention and risk indicators, while partnering closely with engineering and business stakeholders.

Experience

Work history, roles, and key accomplishments

Senior Data Analyst

University of Connecticut

Jan 2025 - May 2026 (1 year 4 months)

Engineered AWS Glue/Airflow-orchestrated Python ETL pipelines (PySpark, Pandas, NumPy) to consolidate 7+ years of student data from 8 sources into a unified dataset, reducing mismatched records from an estimated 15% to under 5%. Built Power BI semantic models using DAX to track student risk and retention trends and presented dashboards to the Dean to support curriculum adjustments.

Python PySpark Pandas NumPy AWS Glue Airflow ETL Data Consolidation Data Quality and IQR Outlier Detection Power BI DAX Semantic Modeling Dashboarding Data Presentation

Senior Data Analyst

Capgemini

Oct 2021 - Oct 2024 (3 years)

Migrated 100+ Teradata BTEQ scripts, macros, and views to Amazon Redshift and converted legacy logic into Redshift SQL, stored procedures, and UDFs, achieving 99.9% data accuracy with zero downtime. Built end-to-end ELT pipelines on AWS Glue, Redshift, and Airflow (MWAA), developed Snowpipe/S3 ingestion to reduce latency and manual effort, and optimized Snowflake SQL and Power BI/DAX dashboards fo