Yatin Arora

Yatin Arora

Business Analyst

Followers of Yatin Arora926 followers
location of Yatin AroraWest Delhi, Delhi, India

Connect with Yatin Arora to Send Message

Connect

Connect with Yatin Arora to Send Message

Connect
  • Timeline

  • About me

    Senior Manager, Reporting and Analytics at Bain & Company

  • Education

    • Netaji Subhas Institute of Technology

      2006 - 2010
      Bachelor of Engineering (B.E.) Biotechnology
  • Experience

    • Mu Sigma

      Aug 2010 - Feb 2011
      Business Analyst

      • Analyzed data for a large insurance company to detect reasons for increase in paid severity using techniques such as regression• Developed a model to interpret & prioritize the driving factors that aided credit card expenditures using linear regression modeling.• Used Cluster Modeling to help detect cases of external frauds in the claim process• Self Learnt Tableau and created multiple out of the box data visualization solutions for clients; In addition, was also responsible for creating training documents to be used for educating other teams about the various functionalities of Tableau Show less

    • Grail Research

      Mar 2011 - May 2013
      Analyst
    • Grail Insights

      Jun 2013 - Jul 2013
      Associate

      I honed my market research and project management skills at grail research where I took complete ownership of project execution from understanding the problem statement, devising the best research methodology, planning the project execution, and delivering insightful and quality outputsI worked primarily in the FMCG domain understanding the importance of key brand health indices and how they were affected by various promotional/branding/pricing campaigns. In addition, I was also responsible for client facing interactions and providing feedback to help grow the analysts who worked with me improve their skills I also created multiple excel dashboards which were used by clients for data interpretation and decision makingIn addition, I was responsible for updating training docs and providing training to new recruits in the firm on MS excelKey Highlights:--Designed multiple research instruments such as questionnaires and field briefing note--Was go to person for all research related needs for a FMCG client with 200+ stores--Created an automated reporting dashboard in MS Excel for a 100+ question survey to analyze results of a global summit-- Executed a 1000+ respondent study to compare brand health indices such as Awareness, Familiarity, Charisma, etc., and several meta perceptions for the client and its key competitions Show less

    • Ridhi Sidhi Enterprises

      Jul 2013 - Nov 2018
      Strategy And Operations Head

      Strategy and Operations Head (Jul’13-Oct'18) Ridhi Sidhi Enterprises is a startup venture specializing in imports and wholesale of Industrial Sewing Machine Spare partsMy foray in the entrepreneurial world challenged me to streamline/optimize and expand what was basically a family owned and operated venture into a smooth functioning organization using my experience in the corporate world, I am also entrusted with building and implementing strategies to achieve mid-term and long-term business goalsI have had to wear various hats which encapsulated both upstream and downstream functionalities in the business chain where I have bought about positive changes which have resulted in stable and consistent growth in terms of both top-line and bottom-line figuresKey Highlights:--Increased revenue from key clients by 20% (y-o-y), won back several lapsed clients and created multiple new business leads--Streaming business operations, and refocused company product offerings to improve bottom line figures --Strengthened current brand portfolio and successfully launched new spare parts brand with over 20 product offerings--Added new (ROI>50%) product categories to increase overall profitability--Modified vendor management strategies to lower down freight and purchase costs Show less

    • Bain & Company

      Nov 2018 - May 2022
      • Manager, Reporting and Analytics

        Oct 2020 - May 2022
      • Senior Specialist

        Nov 2018 - Sept 2020
    • Bain & Company

      Oct 2022 - now
      • Senior Manager - Reporting and Analytics

        Oct 2023 - now
      • Manager, Reporting and Analytics

        Oct 2022 - Oct 2023
  • Licenses & Certifications