Abhi Arora

Forecasting the vehicle sales for Central European region using multiple knowledge points and data analysis techniques. Incorporate market-specific trends, regional seasonality, compliance regulations into the forecast. Validate the incoming data for accuracy and independently locating and correcting concerns. Conduct market research supported by data and represent the results on the representative graphs (Excel, Power Bi), highlighting the conclusions in presentations. Extracted raw data from MYSQL database hosted on AWS server using python for 37 countries. Partnered directly with the development team as an individual to formulate the data pull process from AWS on the most important KPIs to carry out the detailed analysis. Built out the data reporting infrastructure using Python and Power Bi to provide insights into the product portfolios of 30 countries trimming down the analysis time by 60%. Collaborated with 5 other analysts to produce Sub Saharan Africa forecast enhancing the business cope. Developed custom data analysis solutions for the team helping the smooth transitions between the 2 databases under development. Trimmed down the data accuracy check time from 30 minutes to 5 minutes thus saving 5 productive man hours each month for the team.

Formulated the daily dashboarding and test reporting process for various stakeholders using Power Bi. Competitor benchmarking and setting the future targets in line with the requirements and compliance. Testing the functional parts and analyzing the test results to curb the pain points of the problem. Reporting the analyzed results explaining the insights of the problem along with the proposed solution. Collaborate with other teams to implement of the best countermeasure to solve the problem at hand.

Discuss engine related problems with various automotive OEM's. Proposing the solution and then confirming the output by doing the necessary tests. Analyzing the test results, preparing the reports explaining the insights and solutions.