"Numbers have an important story to tell. They rely on you to give them a clear and convincing voice."
This is exactly what I do. It's fun to play with numbers, data and later express them in the form of stories, visual graphs.
I have been a diligent data fanatic and self-taught learner for the most part and am always willing to learn something new in the field of Data Analytics & Data Visualization. I recently graduated from University of Florida with a Master's Degree in Information Systems (Track: Business Intelligence & Analytics). During my time at the University of Florida, I served as a team member of Reporting & Analytics and Graduate Data Assistant. Previously, I worked as a Data Analyst for a startup in India.
I'm actively looking for full-time opportunities in the field of Data Analytics and Business Intelligence starting July 2020.
-
Experience
1. KPMG: Data Analytics Virtual Internship (Mar 2020 - May 2020)
• Assessed accuracy, consistency of 5k+ customer demographics data, and resolved data quality issues for a client.
• Derived data-driven insights from client feedback and performed ad-hoc analysis using MS Excel.
• Presented the data as actionable information to all stakeholders by using visualization tools, Tableau and Power BI.
2. University of Florida : Graduate Data Assistant (Aug 2019 - Mar 2020)
• Conducted ETL and quantitative analysis on 100k+ rows of data to assess student enrollment details in each department.
• Worked closely with Senior Data Engineer to help deliver insights using Alteryx and displaying output on Tableau.
• Performed exploratory data analysis on university’s admission reports and summarized it using Python’s plotly and matplotlib library, thereby enhancing efficiency by 30%.
• Updated SQL queries daily in Oracle Server and uploaded the collected data to AWS S3 bucket.
3. UF Office of the University Registrar, University of Florida : Reporting & Analytics Intern (May 2019 - Aug 2019)
• Analyzed huge data sets of student records, and designed interactive dashboards on Tableau that predicted KPIs, interpreted ambiguous insights to streamline University Registrar’s operation.
• Conducted data cleansing and pre-processing of 52,000 student records using Python.
• Created scripts to analyze trends for Summer and Fall 2019 students using VBA and built their reports on IBM Cognos.
4. StartupWiz Pvt. Ltd.: Data Analyst Intern (June 2017 - Nov 2017)
• Developed complex SQL queries to extract data from databases and utilized Python for data cleaning which together improved performance and reduced the run time by 20% on average.
• Transformed over 10,000 records into structured format using MS Excel to assist stakeholders in decision-making process.
• Built forecasting reports on Power BI for evaluating the company’s profit and revenue on a monthly basis.
-
Projects
1. A Visualization Approach to Job Hunt (Python, Tableau)
• Wrote Python scripts to fetch data for Fortune 1000 companies job location, revenues, sectors, salary package as per state.
• Performed statistical analysis on the dataset to draw insights, thereby transforming the comprehensive data into visually appealing dashboards that provided recent graduates and other users to make informed decisions.
2. IMDB Movie Recommender (Python, Tableau)
• Gathered data chunks from IMDb API and implemented ‘bag of words’ to generate a recommendation model.
• Performed content-based filtering algorithm with Natural Language Processing (NLP) to obtain recommendations on similar movies that were then displayed as search results on Tableau dashboards.
3. SQL Uber Project (MySQL, MS Visio, StarUML)
• Implemented the physical database design for Uber by scripting advanced data manipulation queries using MySQL.
• Designed test cases and created use case diagram using MS Visio and StarUML.
4. Diet on a Budget (MS Excel, RStudio)
• Designed and built an analytical model for achieving a nutritionally balanced diet while incurring minimum cost using advanced Excel tools like Solver, Pivot Table, and VLookup.
• Conducted trend analysis, linear and logistic regression using R to maximize nutritional value and minimize the cost.
Other Projects:
https://github.com/dharmil07
https://public.tableau.com/profile/dharmil.sanghavi