Ayush Jain

Experience

• 

  Citibank

  Aug 2005 - Jul 2006

  MIS Analyst Trainee

  • Extracted data from the backend server and provided it to the Credit Policy Department• Prepared Portfolio Quality Review Report and monthly MIS reports• Maintained developer and project codes for Credit Policy - Auto

• 

  STMicroelectronics

  Sept 2006 - Apr 2007

  Project Management Associate

  • Assisted program manager in day-to-day reporting and reporting automation• Conducted data analysis using analytics tools to support project decision-making• Coordinated cross-functional teams and supported project planning and management

• 

  Agilent Technologies

  Apr 2007 - Mar 2011

  • Designed and developed end-to-end reports to support business decision-making• Led process improvements and VBA automation projects, resulting in increased efficiency and cost savings• Coordinated with overseas teams to successfully transition processes and ensure smooth operations, while coaching and mentoring team members to enhance their skills and knowledge. • Developed MIS reports and Brio reports to support business decision-making• Automated manual processes using VBA, resulting in increased efficiency and accuracy• Contributed to Lean projects and process improvements to optimize operations and reduce waste.

  • Business Intelligence Reporting Specialist

    Jul 2009 - Mar 2011

  • Business Intelligence Analyst

    Apr 2007 - Jul 2009
• 

  Microsoft

  Oct 2010 - Sept 2011

  Microsoft Most Valuable Professional

  • Proud recipient of Microsoft MVP Award for Microsoft Excel for consecutive two years, recognizing my strong contributions to the Excel community• Created and moderated multiple forums, providing solutions and generating new ideas to help Excel users achieve their goals• Shared tips and tricks through blog posts, webinars, and social media, empowering users to unlock the full potential of Excel• Committed to fostering a thriving Excel community, and always eager to connect with fellow enthusiasts and share my knowledge and experience. Show less

• 

  EY

  Mar 2011 - Dec 2022

  • Managed a team of experienced managers, providing guidance and support to ensure successful delivery of analytics services to clients.• Worked with senior leadership to develop the overall strategy and direction of the analytics services offerings, including new product development and go-to-market initiatives.• Built and led a team of data and analytics professionals focused on automating finance processes for banking clients, resulting in significant cost savings, and improved operational efficiency.• Successfully built and led a high-performing transaction analytics team (TASx TD) from onboarding and training to client delivery, fostering collaboration between technology and business resources. Show less • Managed multiple client engagements, overseeing the timely and high-quality delivery of analytics services to support transaction-related analyses. Coordinated with cross-functional teams to ensure smooth project execution, while maintaining a focus on client satisfaction and business objectives.• Collaborated with clients to understand their specific business needs and developed tailored analytics solutions that delivered actionable insights. • Developed a consumer product enabler to automate commonly recurring analysis in the CPR sector deals, increasing efficiency and accuracy in the analysis process. • Led the setup of the BI team as part of the Capital Edge product, providing reporting and analysis for post-acquisition activities. Designed and implemented a comprehensive reporting framework that enabled clients to gain valuable insights into their acquired businesses, while also providing ongoing support and training to the team to ensure continuous improvement in performance. Show less

  • Assistant Director

    Oct 2020 - Dec 2022

  • Manager

    Aug 2017 - Oct 2020

  • Associate Manager

    Aug 2015 - Aug 2017

  • Assistant Manager

    Aug 2013 - Jul 2015

  • Senior Analyst

    Mar 2011 - Aug 2013
• 

  All India Management Association (AIMA)

  Jan 2013 - Jan 2021

  Visiting Faculty

  • Visiting Faculty at AIMA, delivering comprehensive training on advanced Excel and VBA programming to develop technical skills for financial modelling.• Conducted workshops and training sessions on financial modelling tools and techniques, providing students with hands-on experience to enhance their proficiency.

• 

  Houlihan Lokey

  Dec 2022 - now

  Associate Director

  • Spearheading the DVC team at HL India to drive analytics adoption across the transaction diligence lifecycle and build automation solutions for improved efficiency.• Proactively identifying opportunities in buy/sell-side deals to embed sector-specific analytics and developing go-to-market solutions for recurring analyses.• Leveraging advanced analytics such as Customer Lifetime value, Market Mix Modelling, Social Media Analytics, ESG Analytics, Geospatial Analytics, Supply Chain Analytics etc. to drive post-acquisition value creation and facilitate exit readiness for private equity clients. Show less