Anubhav Saxena

• Leading Customer Experience Charter for Myntra-Flipkart synergy project looking synergy impact on performance metrics impacting customer experience like NPS ,Delivery speed, Customer delivery promise, making sure all metrics remain in parity with benchmarks.
• Leading promise-precision charter to ensure accuracy of delivery promise, working collaboratively with Ops and planning to maintain to the current accuracy and ideation on project for improve it further to achieve best in industry performance.
• Developement of end to end power bi dashboards which will provide efficient and pinpointed reporting for metrics.
• Leveraged data and analytics to make informed decisions and drive business improvements.

Roles and Responsibilities:

• Working as a part of the Customer Experience analytics team where we our output metric is NPS (Net Promoter Score).
• The first project was Consolidation break where in collaboration with cross functional teams I worked on case building for the project where my role was to analyze the data and provide suggestions on efficient ways to implement the project , I also provided cost-benefit analysis with very high accuracy. This project is currently giving goodness of 10% better speed, which in case improved NPS.
• My Other Project is to work in collaboration with cross functional teams to improve the customer perception of Myntra's delivery speed by improving promise accuracy metric used to govern this is Precision(customer promise date - actual delivery date). Built an automated dashboard which can explain where we need to improve on promise, taking promise breach into consideration decided on a best possible solution which improved Promise by 15%, received 'Make It happen' quarterly award for the same.
• Designed and developed a fully automated promise buffer consumption report using python, SQL and gsheet which is first of its kind project here in Myntra, this helped in better governance of promises going into system providing better accuracy.
• Ideated and implemented festive-based express promise system for Rakhi'22 for 1st time which provided 20% growth in revenue of Rakhi sales this was further flowed in for Christmas and New Year.
• Led SCM data control tower where I looked into various metrics and shared pinpointed insights with SCM-CT which uses them to govern the performance of the supply chain, all these insights were shared on a daily meeting with supply chains ops and SCM-CT.
• Handled leadership connects and SCM control tower for 3 HRD events (EORS Dec'22 and Big Fashion Festival'22) provided the latest accurate status of sales and also provided insights into maintaining supply chain performance at the AOP level. Received 'Consumer First' quarterly award for the same.
• Handling weekly scm connect with leadership, to share insights on supply chain performance and highlight major issues and achievements for the week.
• Designed and implemented data model and dashboard in collaboration with MDP(Myntra data platform team) for the base of CE's new power bi reports as dashboard transition started from gsheet to Power BI, this will help us build more user-friendly and detailed dashboards.
• BU Head appointed me to lead the learning and development part of the team where in collaboration with HR conducted 'data storytelling' and power bi workshops for the team's skill development.
• Helped tech team to build Local/Zonal/National pincode level mapping, which will help in easy implementation of speed-based projects.

Roles and Responsibilities:

• Working as a business analyst in finance department majorly looking into inventory side data.
• Create interactive dashboards using power bi and mysql to show inventory health and movement.
• Used web scraping(python selenium) as python scheduler to download data automatically(128 files) completely automating the process.
• Using R to automate all major data processing.
• Optimizing mysql database to efficiency store and process data.
• Migrated data from mysql to redshift which improved data processing speed, reduced processing time by (30% approx.).
• Delivery adhoc data request on time, sometimes even on a short notice.

Roles and Responsibilities:

• Utilized Python, Power BI, MY SQL and Google analytics for data analysis and intelligence.
• Helping drive growth, retention for app with rigorous Google Analytics based data analytics.
• Performed daily data queries and prepared reports on daily, weekly, monthly, and quarterly basis.
• Develop and initiate more efficient data collection procedures.
• Defined the KPIs with product team that measure the game’s(Qureka Pro) performance in a meaningful way.
• Manage the planning and development of design and procedures for metrics reports.
• Processing, cleansing, and verifying the integrity of data used for analysis.
• Performing customer behavior analysis, reviewing growth of product.

Roles and Responsibilities:

• Optimizing data collection procedures(Using SQL)and generated reports on a daily, weekly, monthly, and quarterly basis for data buddy & genie (Android Apps)
• Helped solve diverse business problems with in-depth analysis.
• Analyzed program data to provide input for key decision making and strategic planning.
• Validated results and performed quality assurance to assess accuracy of data.
• Create Interactive Dashboards using Power Bi and SQL to show business performance.
• Helped in building Road maps for Databuddy & Bid-Win based on analysis to improve the output regularly.
• Performing customer behavior analysis, reviewing growth of product & conducted reports for implementation to efficiently achieve objectives.