Sumit Chatterjee Email & Phone Number

Leicester, Gb

London, United Kingdom

• Produce analytical output in relation to valuation and specification data, new vehicle prices, registration statistics and used vehicle prices collected from the market for all vehicle groups including cars, commercial vehicles, motorcycles and caravans.• Provide regression analysis based on seasonality and econometric factors. Plotting the data in scatter plots and graphs for non technical audience like editorial departments and for press releases to general public.• Provide data solutions for internal and external customers in the form of standard and bespoke reports. Also includes preparation of sample data for sales teams to assist them in their sales prospecting.• Performing maintenance on valuation and forecasting models, periodic checking if models are fit for purpose, scheduling and automating where possible to minimize human intervention and errors.• Undertake periodic review of model coverage, mileage tables, trading margins, model specifications etc.• Engagement with new projects for development or upgrading of internal processes or systems, help with the modification to an existing product or service or help with the creation of new customer offering.• Undertake relevant desk research work and to communicate with stakeholders any aspect of valuation or forecast methodology and processes.• Extract added values from existing datasets through data mining using SAS, SQL and MS Excel and visualizing those using Tableau and Excel dashboards.

India

• Analyzing historical financial performance of the companies under coverage and meeting management to understand future course of the company as well as industry.• Analyzing the industry dynamics and help in preparing financial forecasting models.• Developed pivot charts and dashboards for customer and company analysis.• Analyzed data and produced relevant reports about the profit margin for various customer categories.• Used valuation techniques to arrive at target price for purchase of various high profile stocks.• Preparing company visit report, initiating coverage report, quarterly result update and event updates.• Making presentations to the fund managers / buy side analysts to assist them in taking decisions.• Presenting stock specific views for media if required.