JATIN MUKATI
PROFILE SUMMARY
Results-oriented data analyst with expertise in SQL, Python, Power BI, and Tableau. Transform complex data into actionable insights,
quantifying impact and identifying key trends to solve business challenges and drive decision-making.
SKILLS
Programming: SQL (Joins, CTEs, Window Functions), Python (Pandas, NumPy, Web Scraping)
Data Visualization: Power BI (DAX, Data Modelling), Tableau (Dashboards, Parameters, Actions)
Data Analysis: Advanced Excel (Pivot Tables, VLOOKUP, Index-Match), Statistical Tests (Regression, T-Test, Chi-Square)
EXPERIENCE
Infosys Springboard Internship 6.0 – Data Visualization Intern
Aug 2025 – Oct 2025
• Collaborated in a team project on WIID (25K+ records, 180+ countries), testing and comparing data cleaning approaches.
• Enhanced data quality by handling 20%+ missing values and outliers using Median, Mode, Interpolation, and KNN techniques.
• Developed Power BI dashboards and integrated Streamlit to visualize global income inequality across 180+ countries.
Accenture – Data Analytics and Visualisation Virtual Experience (Virtual Internship from Forage)
Jul 2024 – Jul 2024
• Merged tables and identified relationships in 7 data sets, resulting in streamlined analysis and improved insights.
• Performed in-depth analysis of website traffic data to identify the top 5 categories on a popularity basis.
• Utilized data visualization and storytelling skills to create a Powerpoint presentation on content performance for Social Buzz (client).
PROJECTS
Vendor Performance Analysis |SQL, Python, Power BI
• Conducted vendor and inventory analysis to identify underperforming brands, evaluate top vendor contributions, and measure bulk
purchasing impact on costs.
•Pinpointed $2.71M tied up in unsold inventory and highlighted vendor concentration risks with top 10 vendors contributing 65%+ of
purchases.
•Discovered bulk purchasing reduced unit costs by 72%, leading to recommendations on optimizing purchasing strategies.
•Designed an interactive Power BI dashboard to present insights and support data-driven decision-making for vendor diversification and
profitability improvement.
Cyclistic Analysis |Excel, SQL, Tableau
• Analyzed 5.66M bike-share rides using SQL, Excel, and Tableau to compare casual riders vs. members.
• Identified that casual riders take 72% longer rides on average (21.5 mins vs. 12.5 mins).
• Determined peak usage occurs on Saturdays during summer at 5 PM.
• Found members prefer classic bikes, while casual riders favor electric bikes slightly more.
• Built an interactive Tableau dashboard to visualize findings and support targeted marketing strategies.
EDUCATION
Master of Business Administration -MBA (Finance and Marketing)
Shri G. S. Institute of Technology & Science, Indore
Bachelor of Commerce – B.Com (Computer Application)
Maharaja Ranjit Singh College of Prof. Sciences, Indore
Sep 2023 – May 2025
Sep 2020 – May 2023
CERTIFICATIONS
Google Data Analytics Professional Certificate (Coursera)
May 2024 – Aug 2024
• Executed SQL queries on MySQL & PostgreSQL, improving data accessibility and accuracy.
• Built Tableau dashboards on datasets with millions of rows, accelerating decision-making by 50%.
Career Essentials in Data Analysis by Microsoft and LinkedIn (LinkedIn)
Jul 2024 – Jul 2024
• Proficient in data analysis fundamentals, including SQL, data cleaning, modelling, and interpretation.
• Skilled in data visualization, reporting, and dashboard creation using tools like slicers.
Getting Started with Google Workspace Specialization (Coursera)
Nov 2023 – Nov 2023
• Developed proficiency in Google Workspace tools (Gmail, Calendar, Drive, Docs, Sheets, Slides, Meet and Chat).
