Data Analyst with a proven track record of automating processes, developing insightful dashboards and providing tailored solutions. My recent accomplishments include significantly reducing report generation time by automating using python and power query, creating interactive dashboards, and implementing custom VBA solutions to address complex challenges.
Hi, I’m
R PREM
Manager-Data Analyst
Summary
Overview
5
years of professional experience
Work History
GroupM
Manager-Data Analyst
Feb.2024 - Current (2 education.years_Label & 4 education.months_Label)
Job overview
- Automation:
Monthly Reports: Automated monthly reports using Python, reducing report generation time from 320 hours to 10 hours.
Weekly Reports: Streamlined weekly report generation using Excel Power Query, VBA, and Power Automate, decreasing time from 20 hours to 3 hours.
- Dashboard Development: Created dashboards to monitor and track critical performance indicators.
- Custom VBA Solutions: Provided tailored Excel VBA solutions to address the challenges of various teams.
Tata Technologies
Senior Design Engineer
Jul.2019 - Feb.2024 (4 education.years_Label & 7 education.months_Label)
Job overview
- Project Performance Dashboard: Developed and maintained an Excel and Power BI dashboard to visualize project performance for the APAC region's Industrial Heavy Machinery and Manufacturing division.
- BOM Automation: Automated the updating of a Bill of Materials list for diesel forklifts using VBA and Power Query, integrating data from Windchill and offline sources.
- Market Research: Conducted in-depth market research on counterbalance forklifts in India and emerging markets, providing strategic insights to a leading forklift manufacturer.
- Product Analysis: Analyzed competitor features and recommended user-preferred attributes for diesel and electric forklifts to inform product development.
Education
Indian Institute of Management, Tiruchirappalli
Post Graduate Certification in Business Analytics & Applications
Jun.2023 - Jul.2024 (1 education.year_Label & 1 education.month_Label)
University Overview
Capstone Project - Data analysis of Apollo tyres Tamil Nadu
- Sales data visualization dashboard across tyre category and dealer
- Root cause analysis for dealers with low sales
- Predictive Analytics to estimate the next month sale for different tyre models
VIT University, Chennai
B.Tech Mechanical Engineering
Jul.2015 - Apr.2019 (3 education.years_Label & 9 education.months_Label)
University Overview
- GPA: 8.07
Skills
Python, SQL, Tableau, Power BI, Excel, VBA
Languages
English
Tamil
Hindi (beginner)
Software
Excel
Python
SQL
Power BI
Tableau
VBA
Interests
Crocheting
Table tennis
Badminton
Cooking
Timeline
Manager-Data Analyst
GroupM
Feb.2024 - Current (2 education.years_Label & 4 education.months_Label)
Indian Institute of Management, Tiruchirappalli
Post Graduate Certification in Business Analytics & Applications
Jun.2023 - Jul.2024 (1 education.year_Label & 1 education.month_Label)
Senior Design Engineer
Tata Technologies
Jul.2019 - Feb.2024 (4 education.years_Label & 7 education.months_Label)
VIT University, Chennai
B.Tech Mechanical Engineering
Jul.2015 - Apr.2019 (3 education.years_Label & 9 education.months_Label)