Highlights:

Skills:

Data Research Assistant 01/2024 - current
Indiana University School of Medicine, Bloomington, Indiana United States
Industry: Healthcare
Integrated diverse sociodemographic, environmental, and health data from multiple sources using advanced techniques like web scraping and spatial data enrichment. Performed complex analytics including descriptive statistics, trend analysis, and data visualization using Python, SQL, Excel, Power BI, and STATA. Developed dashboards and presentations summarizing key findings for stakeholders and leadership. Expertise in heterogeneous data integration, statistical analysis, and developing visualizations to extract meaningful insights from complex data.
Skills: SQL, Python, Power BI, Data Extraction, STATA ? Acquired and integrated sociodemographic, environmental, and health data from diverse sources using advanced techniques like web scraping and spatial data enrichment. ? Performed complex analytics including descriptive statistics, trend analysis, and data visualization utilizing Python, SQL, Excel, Power BI, and STATA. ? Built dashboards, and presentations to summarize key findings for stakeholders and leadership.--
Microsoft Ambassador, 10/2023 - 12/2023
University Information Technology Services, Bloomington, Indiana United States
Industry: Educational
Educating and spreading awareness to IU students and staff about benefits of using Microsoft 365 applications.
Skills: Power BI, Microsoft forms, MSSQL Server ? Led 50+ workshops on Microsoft Office 365 among students and promoting the adoption of Microsoft Office 365. ? Utilized Microsoft forms and Power BI to analyze event participation, driving data-informed decisions resulting in a 2X increase in student adoption of Microsoft technologies.--
Data Engineer Intern, 05/2023 - 08/2023
Rocket Companies, Detroit, Michigan United States
Industry: Mortgage
Developed scalable PySpark & AWS Glue ETL pipeline processing 10 million user records for Change Data Capture (CDC). Streamlined data validation in ETL pipeline, reducing load failures by 40%. Collaborated with MLOps team to design data architecture integrating Health Analytics Report into Rocket Money app. Expertise in building automated ETL pipelines and data architectures for machine learning apps.
Skills: AWS Glue, PySpark, Python, CI/CD, GitHub, AWS S3, AWS Athena, ETL ? Built scalable ETL pipeline for Change Data Capture (CDC) by processing 10 million user records using PySpark & AWS Glue from raw to transformed state. ? Streamlined data validation process in ETL pipeline, thereby reducing the data load failures by 40%. ? Partnered cross-functionally with MLOps team and designed data architecture to integrate Health Analytics Report in the Rocket Money app.--
Data Engineer 05/2021 - 07/2022
KPMG, Pune, Maharashtra India
Industry: Audit
Led Oracle to BigQuery migration, orchestrating data loading to complete 15 days ahead of schedule. Automated 15+ financial report data pipelines using SSIS, cutting delivery time from 2 days to 5 minutes. Enabled Excel exports and automated notifications. Developed Python script to optimize GCP cloud storage data validation, reducing row count analysis time from 1 hour to 5 minutes and improving efficiency by 70%. Expertise in cloud migration, building automated data pipelines, and leveraging Python for process optimization to drive major efficiency gains.
Skills: GCP BigQuery, Apache Airflow, SQL, Python, CI/CD, GitHub, SSIS, SSMS, ETL ? Led the migration of Oracle SQL scripts to BigQuery, efficiently orchestrating data loading and achieving project completion 15 days ahead of schedule. ? Transformed 15+ financial reports by automating end-to-end data pipelines in SSIS, cutting delivery time from 2 days to 5 minutes, enabling Excel exports, and automating stakeholder notifications. ? Streamlined data validation on GCP cloud storage by developing a Python script for row count analysis, reducing processing time from 1 hour to 5 minutes thereby improving the efficiency of data validation tasks by 70%.--
Business Intelligence Developer, 08/2018 - 05/2022
Vodafone, Pune, Maharashtra India
Industry: Telecom
Generated over 1M £ revenue by delivering Cross-sell, Up-sell, and Retention campaigns with Marketing team. Automated weekly SQL updates with Python after a critical database error, improving accuracy and efficiency by 50%. Streamlined data processing by automating SQL and Salesforce integration, reducing task time from 5 days to 30 minutes and boosting campaign efficiency. Expertise in designing high-revenue marketing campaigns, leveraging automation and integration to optimize data processes and drive major efficiency gains.
Skills: SQL, Teradata, Python, Excel, VBA, Qlik sense, Data extraction ? Generated revenue of more than 1M £ by delivering Cross-sell, Up-sell, & Retention campaigns with Marketing team. ? Automated weekly SQL updates with Python after a critical database error, enhancing accuracy and efficiency by 50%. ? Streamlined data processing by automating SQL and Salesforce integration, cutting task time from 5 days to 30 minutes and boosting campaign efficiency.--

University of Pune 06/2013 - 05/2017
Pune, Maharashtra, India
Degree: Bachelor's Degree
Major:Mechanical Engineering
Bachelor of Engineering in Mechanical Engineering; GPA 3.3/4.0

Akash_Gangadharan_Resume