May 2020 – Jun 2021 · 1 yr 1 mo · Bengaluru, Karnataka, India

• 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 ads
• 2. 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

Mar 2019 – May 2020 · 1 yr 2 mos · Bangalore

• 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 run
• 2. Brought 4 zero-touch automated reports through auto mailers to pro-actively bring right capacity augmentation in the system and control speed and sla metrics
• 3. Built live flex dashboard to get offload reporting and ensuring no leakages should happen in events and BBD
• 4. Built automated QC Checks in every possible inputs and outputs to inform relevant stakeholders on time about the errors and ensuring better accuracy in outputs
• 5. Took R session at planning org level to on-board people on the tool. Got appreciation from leadership
• 6. 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

Feb 2016 – Mar 2019 · 3 yrs 1 mo · Bengaluru Area, India

• 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 appropriately
• 3. 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 client
• Beverage Industry (Largest Beverage Company):
• 1. Helping revenue growth management team to optimize trade promotions with customers
• 2. 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 SQL
• c. Created Rshiny dashboard for presenting waterfall charts

Jul 2015 – Jan 2016 · 6 mos · Hyderabad Area, India

Jul 2014 – Apr 2015 · 9 mos · NIT Durgapur

• Managing teams for Various Events, Presenting reports to faculty