Printing tool Download PDF

Work experience

Summer Intern

Tata Motors
Uttaranchal: Summer Intern Selected based on merit to participate in the functionality of the project“ Google hacking and SQL-injection” Coordinating and interacting with internal warehousing teams and various other support teams Assisting in subsequent release of project functional documentation Genesis Apartment, Suncity, Sarjapur Jnc., Bangalore.

Business Consultant

Bangalore: Business Consultant Design, develop and implement monthly analysis in Delhi and Orissa beer market for the largest beer manufacturer of India Reporting actionable insights Understanding the regular client requests and Providing business solutions from raw market data Handle and interact with client to manage end to end reports Addressing ad hoc request from Delhi and Orissa area sales managers Providing hypothetical analysis to clients Evaluating new launch health for a newly launched beer brand which was in news for its performance in its launch year Setting up its periodic performance reports Monitoring and testing campaigns and various promotions launched by the client in spirits market using test vs. control model Presenting results and analysis by incorporating internal and external key influencer Construction of usable data with cross team utility from raw market data 360 degree analysis of historical and forecasted sales to assess the profitability of a globally no. 1 pharmaceutical client's marketing investments. Automation of reports which saved a total of 50 analyst hours per month for the company as a self initiative, using SAS and Excel Responsibly determining solution as a fancy visual for effective visibility and understanding of a promotional analysis at client's end(using Xcelcius)

Information Analyst

Bangalore: Information Analyst Build statistical models using Linear Regression/ARIMA to make actionable recommendations to the Brand team Project management for an end to end process displayed Market Mix Modeling feasibility, work plan, modeling, action set along with a Simulation tool and model validation Extensive use of XLSTAT, Excel, Tableau, Alteryx and Power Point Built close to 50 models, in most cases enabling a growth of 2%-4% in Volumes and MS% Recognized for being able to optimize the media in a way that leveraged the Category growth by 2% in a tough economic scenario for one of the Cells Analytical and Strategic design of a Digital Campaign for the highest selling Brand for a Category enabling a conversion of competitor users Running exhaustive cycles of data management and mining(creating Linkages etc.), Hypothesis Map and Scoring Model Achieving a response rate of 25% among competition users in Direct Marketing campaigns for Maharashtra Rigorous utilization of Alteryx, R and Excel, to execute Segmentation, Cluster Analysis and Distance Based Scoring Project and people managed a Third Party Team of 5 Developing an analytical store POS tool to find opportunities to carry new Variants of a product from other stores or competitors Establishing store-cluster wise common attributes of the stores to isolate stores based on similar attributes Identify opportunities to change product assortment Implementing store operations using Cluster Analysis and Segmentation through Teradata and Excel Review regularly top brand performances and tracking eye competitors using Time Series and 4P Analysis and enabling a visually appealing tracker using Tableau Executing an efficient category portfolio in order to Optimize Media and relative Prices considering Halo Impacts and Cannibalization effects Enable high level of organizational sustainability by recommending a Travel Optimizer for the regular cab service in the company Developed the model using Spatial Analytics in Alteryx based on Segmentation and Distance Scores Reduced the turnaround time for cab request by 17% and also assured a more efficient and optimal travel Conceptualized and executed a high quality info graphics inducing a leadership nomination for the Line manager Coordination with the core



Uttar Pradesh Technical University


global hand