Rohit Madigar

Developed daily auto-tracking dashboards using Python and automated data push to Google Sheets using the Gspread library, scheduled with Cron, to provide the sales team with real-time insights. Collaborated with a team of Analytics to design and implement a Dashboards on Power BI Tool, reducing report generation time by 40% for company sales. Optimized SQL queries to improve data retrieval efficiency, reducing query execution time by 30%.

Data Analytics Intern - IT Solutions - Pune, India

(2024-06 - 2024-08)

• Developed daily auto-tracking dashboards using Python and automated data push to Google Sheets using the Gspread library, scheduled with Cron, to provide the sales team with real-time insights.
• Collaborated with a team of Analytics to design and implement a Dashboards on Power BI Tool, reducing report generation time by 40% for company sales.
• Optimized SQL queries to improve data retrieval efficiency, reducing query execution time by 30%.
• Automated data cleaning processes using Python (Pandas), reducing manual efforts by 50%.
• Conducted explanatory data analysis (EDA) to identify business trends, ensuring high-quality seamless user experience, increasing revenue by 15%.
• Collaborated with cross-functional teams to enhance customer retention through data-driven insights.
• Participated in daily stand-ups and contributed to sprint planning sessions, enhancing my understanding of Data Analyzing Tools for Cleaning and Visualize the databases.

Bachelor of Technology - Electrical Engineering - NBN Sinhgad School of Engineering (2019-07 - 2022-06)

Diploma - Electrical Technology - Sharad Institute of Technology polytechnic (2016-07 - 2019-06)