Dhwani Rekhang Gandhi
Data Analyst Intern · KPH Healthcare Services
Work Experience
Data Analyst Intern
KPH Healthcare Services2021 – 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
DXFactor2020 – 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 University2021
Master of Science in Applied Data Science
Bachelor of Engineering in Electronics & Telecommunication
University of Mumbai2019
Bachelor of Engineering in Electronics & Telecommunication