Gauri Dharkar

Business Analyst Intern

AstraZeneca•  June 2020 - Present

• Creating web page to aggregate vaccine test data and build statistical model to compare cell clumping as result of vaccine in different populations using Python. This will enable concurrent access to the data among scientists for drawing inference. • Built Production Plan Change Tracker applying ETL on SAP data to migrate and automate report generation of weekly production data on SQL server using VBA, Excel and SQL with Agile methodology for process improvement • Created PowerBI dashboards by analyzing employee training data with DAX and power querying that helps operations department to reach goal of 80% Lean Framework training completion by end of year

Data Analyst

Sandhar Engineers•  July 2018 - July 2019

• Analysis of electricity meters data across district region leveraging MS-SQL and Excel to find power theft, resulted in 17% reduction in theft in ten months duration • Maintained high-volume complex metadata for billing of electricity meters database for client exploiting MS-SQL • Created KPI dashboards summarizing monthly power thefts and power consumption factors using Tableau for regional leadership teams to create plan of action