DG

Dhwani Rekhang Gandhi

Data Analyst Intern · KPH Healthcare Services


Work Experience

Data Analyst Intern

KPH Healthcare Services

2021 – Present

* Created prompts, filters, and metrics in MicroStrategy to deliver dispensing reports to authorities for business decisions * Built an SSIS package to automate the process of generating and sending Excel reports using Execute SQL Task, Script Task and Send Mail Task to respective stores and pharmacies for inventory purposes and information circulation * Wrote procedures and advanced SQL queries using CTEs and window functions to answer business questions

Data Science Intern

DXFactor

2020 – 2020

* Designed and deployed data processing pipelines and data analyzers using Python, Azure SQL Server, and Blob Storage * Reduced query execution time of API endpoints by 80% using pagination with SQLAlchemy, and indexes and functions * Conducted exploratory data analysis on data provided by clients and presented reports to assist business assessments * Analyzed and provided solutions for issues raised by the testing team to prevent performance bottlenecks * Built a web scraper using Selenium to extract LinkedIn URLs of 10,000 companies associated with the fitness industry

Education

Master of Science in Applied Data Science

Syracuse University

2021

Master of Science in Applied Data Science

Bachelor of Engineering in Electronics & Telecommunication

University of Mumbai

2019

Bachelor of Engineering in Electronics & Telecommunication