1. Built models to provide insight on how much cheaper the auction inventory is getting sold due to the absence of higher competition and reservation ad types. The CPM can increase by X$ if we increase no of clients by 1 and sell more reservation ads2. Responsible for reporting and analyzing multiple KPIs of TikTok ads' and their clients' businesses such as Revenue, CPM, CTR, CVR, and CPA, etc.3. Built dashboards on Google data studio, Power BI, and System platforms with automated quality control modules to help business track KPIs on day to day basis

1. Increased large planning team plans' efficiency by 90% in XD planning, 80% in 3PL DH capacity files, 90% in Jeeves plans of service planning, 60% in input preparation of 3PL service plan run2. Brought 4 zero-touch automated reports through auto mailers to pro-actively bring right capacity augmentation in the system and control speed and sla metrics3. Built live flex dashboard to get offload reporting and ensuring no leakages should happen in events and BBD4. Built automated QC Checks in every possible inputs and outputs to inform relevant stakeholders on time about the errors and ensuring better accuracy in outputs5. Took R session at planning org level to on-board people on the tool. Got appreciation from leadership6. Contributed to DC teams' rostering optimization by formulating it through binary constraint solution. It helped them in their manpower optimization template by linearlizing it, which was earlier non-linear

Pharma Industry (World's leading Pharma Company):1. Identified KPIs and reported insights on a weekly and monthly basis to sales and marketing team 2. Identified halo effect, quantified and attributed to variables appropriately3. Established automated quality reports (using SAS, VBA) to generate efficiency in reporting 4. Analysed over various ad-hoc request to get required insights on time for clientBeverage Industry (Largest Beverage Company):1. Helping revenue growth management team to optimize trade promotions with customers2. Established sales driver analysis model to attribute and quantify the contribution of variables on week over week sales of the product a. Used stepwise bidirectional linear regression approach for appropriate variable selection b. Created waterfall charts to show the contribution of variables on sales by using R and SQLc. Created Rshiny dashboard for presenting waterfall charts

Managing teams for Various Events, Presenting reports to faculty