Jai Lodha

Experience

• 

  Mu Sigma Inc.

  Jul 2016 - May 2020

  Managed a $1.2M engagement (3 subgroups | 12 people) with a Chicago based major US Airline- In charge of account PnL, problem scoping, solution design and implementation, project planning and execution, people and stakeholder management, business reviews, scrum, and business development𝐊𝐞𝐲 𝐏𝐫𝐨𝐣𝐞𝐜𝐭𝐬 𝐃𝐞𝐥𝐢𝐯𝐞𝐫𝐞𝐝:● Customer Segmentation and Profiling – Built a customer segmentation model based on their spend patterns, and created customer personas to help marketing teams run targeted campaigns and increase ancillary revenue● Feedback prioritization – Built an automated tool to classify and prioritize customer feedback using topic modeling, text classification, and heuristic prioritization rules, which enabled sales managers to effectively address critical feedback, thus improving CSAT scores by 13%, and reducing man-hours by 30% Show less 𝐊𝐞𝐲 𝐏𝐫𝐨𝐣𝐞𝐜𝐭𝐬 𝐃𝐞𝐥𝐢𝐯𝐞𝐫𝐞𝐝 | 𝐀𝐢𝐫𝐥𝐢𝐧𝐞𝐬 𝐃𝐨𝐦𝐚𝐢𝐧● Social Care Dashboard – Integrated data from multiple sources to develop an automated Spotfire dashboard for tracking customers’ social chatter and assessing the performance of Social care agents to aid in agent management and appraisal. The solution resulted in,- Cost savings of ~$300K annually- Reduction in average response times by 4.5 min- Increase in CSAT and agent performance by 11% and 16%, respectively● Sentiment analysis – Identified themes of conversation and associated sentiment change throughout the conversation to highlight pain points for both customers and associates. This resulted in:- Improvement in overall CSAT by 2% due to improved service on themes with negative sentiment- Reassignment of associates and relevant training provided to enable them to have better conversations● Share of Wallet – Built a comprehensive report that provides a deep-dive view of airline spends of Loyalty members, to assist Customer Loyalty team and Geography Managers in personalized service and content targeting𝐎𝐫𝐠 𝐢𝐧𝐢𝐭𝐢𝐚𝐭𝐢𝐯𝐞𝐬:● Interviewed and evaluated college graduates as part of Mu Sigma’s off-campus placement drive● Member of the Policies and Communications team that was tasked with identifying and solving org-wide problems Show less 𝐊𝐞𝐲 𝐏𝐫𝐨𝐣𝐞𝐜𝐭𝐬 𝐃𝐞𝐥𝐢𝐯𝐞𝐫𝐞𝐝:𝐂𝐏𝐆 𝐃𝐨𝐦𝐚𝐢𝐧● Analytical Data Foundation – Created an analytical data foundation for a major CPG manufacturer, which provides an integrated and robust view of the US packaged food industry for strategic business planning, thus reducing the time required to collaborate by several org teams by over 300 hours● 360⁰ Trend watching – Developed an automated tool that enabled users to track the white space opportunities in the market by analyzing several market trends across sales, competition, social media, search interest, etc.● New Product Sales Forecasting – Developed an ML model using Random forest and Linear regression to forecast sales of a new product before its launch by leveraging similar product attributes and promotional strategies𝐑𝐞𝐭𝐚𝐢𝐥 𝐃𝐨𝐦𝐚𝐢𝐧● Automated Business Intelligence – Conceptualized and built automated reports to monitoroperational performance of warehouses and stores, and identifying issues impacting customerexperience, which reduced the man-hours required by 90%● Collection window extension – Tracked and analyzed the effects of collection window extension, post which helped in its roll out across UK, which resulted in an increase in sales and collection rates by £9.7 Mn and 3pp respectively● Customer experience and Business improvement – Provided actionable insights and recommendations to improve both customer experience and business operations by performing several deep-dive analyses, e.g., price sensitivity, store profiling, customer abuse, etc.𝐎𝐫𝐠 𝐢𝐧𝐢𝐭𝐢𝐚𝐭𝐢𝐯𝐞𝐬:● Mentored several batches of new joiners to make them delivery ready Show less

  • Apprentice Leader (Account Manager)

    Jan 2020 - May 2020

  • Decision Scientist (Team Lead)

    Jun 2019 - Dec 2019

  • Decision Scientist (Data Analyst)

    Jul 2016 - May 2019
• 

  Lowe's India

  May 2020 - Nov 2022

  Worked with the Field Merchandising team from the grassroots level to the executive leadership to aid in solving several problems like assortment planning, product localization, demand-supply gaps, and inventory management𝐊𝐞𝐲 𝐏𝐫𝐨𝐣𝐞𝐜𝐭𝐬 𝐃𝐞𝐥𝐢𝐯𝐞𝐫𝐞𝐝:● Sales Index Report – Built a one-stop solution for analyzing sales trends at all levels, across merch and geography hierarchies, thus making field merchants self-sufficient in routine requests● Not Stocked Opportunity – Identified and prioritized a multimillion-dollar sales opportunity to stock items in stores that have the scope for product stocking similar to other 'stocked' stores in the district● Seasonality Calendar – Designed a comprehensive seasonality calendar to aid in assortment, inventory, and order planning by providing holistic and granular views across categories and geographies ● Focus Classes Report – Built an end-to-end automated MSTR report for focus classes that provides field merchants with concise info on product and store performance and inventory, thus saving each merchant 2+ hours every week● Planned Sales vs Inventory Tracker – Built an interactive report to track inventory(available and in-transit) against the plan and highlighted categories at severe risk of inventory shortage over the next four weeks due to higher than planned comps. This helped in understanding demand patterns and enabled conversations with global sourcing teams to preemptively allocate supply Show less

  • Lead Analyst | Merchandising and Products

    Feb 2022 - Nov 2022

  • Senior Analyst | Merchandising

    May 2020 - Mar 2022
• 

  Landmark Group

  Nov 2022 - now

  Product Manager | Category Management