Sam John Email & Phone Number

Bengaluru, Ka, In

Gurugram, Haryana, India

Gurugram, Haryana, India

Pricing and Promotion Analysing the impact and performance of product pricing and promotions on retailer's revenue and profit.• Built a comprehensive dashboard to evaluate the monthly and yearly trend of sales across retail departments, store types and customer lifecycle. The dashboard helped the client understand the post-COVID customer behaviour change and the impact of high UK inflation on overall customer spend.Category Management Analysing the impact of product movement in categories and their impact on demand and sales transfer.• End-to-end productionisation of analytical solution for identifying tree hierarchy of new product launch before sales using text matching(Fastext) algorithm to find the closest matching product based on the description of the product. The vector results from the model were used to identify the highest cosine similarity product to assign its tree hierarchy. The solution provided a result of 78% correct product mapping along with a close match of 91%.• Achieved revenue of 1 million for the company with the delivery of an automated comprehensive dashboard which helps in analysing range change of product category and the impact of the sales /unit /customers.

Goa, India

Vinidhan: The Student Managed Investment Fund of GIM, Actively managing investment fund with real-time exposure in the equity market and built quant strategy with backtested result of 54% profitability in NIFTY-50 stocks & engaged extensively on Industry report on the Power sector

Goa, India

Pune, Maharashtra, India

 Responsible for the creation of a command centre to analyze the processing of various systems of the organization on AWS Quicksight.  Sourced customer processing data from various databases such as MYSQL/MongoDB/Athena and performed ETL of data pipeline in KNIME software(API for Data Pipelining, Data Mining, Data Analysis). Displayed the command centre dashboard on AWS Quicksight of all the processes in a structured and periodic manner along with the average turnaround time of customers availing the product.  Command centre dashboard will help the organizations to check the working of all the systems on a single screen, and also will help the company to identify the errors in real-time in case of any system breakdown.

Master Of Business Administration - Mba In Big Data Analytics

Bcom - Bachelor Of Commerce, Finance, General

Education record