Rajat Khatri

Rajat Khatri

Head of Data Analytics & Business Intelligence
India
Panjabi (Punjabi), Hindi, English

About Me

Dynamic AVP – Business Intelligence with over 13 years of experience in data analytics and business intelligence. Proven track record of driving 20% YoY business growth and optimizing data processing costs by 18%. Establ…

Experience

AVP – Business Intelligence

Ferns N Petals (FNP), Gurgaon
Oct 2021 - Present · 4 years 9 months

Established a Center of Excellence, fostering a data-driven decision-making culture while maintaining the department's P&L.
Identified 12% top-line business gaps worth Rs 50 Crore through analysis of customer journey, operations, digital metrics optimization, and campaigns (including Google PPC & SEO).
Optimized app journeys, resulting in an increase of app order share from 29% to 42% and installations by 1.8 times.
Delivered real-time insights contributing to 15% YoY growth and cost savings while collaborating closely with Product, Marketing, Operations, SCM, and Business teams.
Boosted conversion rates and reduced delivery times, culminating in a 13 bps increase in NPS.
Developed PID Scorecard, Customer Churn Model, and RFM Segmentation to enhance customer retention and engagement by 1.5 times.
Championed the UI/UX revamp of the FNP app, improving customer journeys and increasing conversion by 1.2 bps.
Collaborated with the Data Engineering team to manage data pipelines and ETL processes, optimizing data processing costs by 18%.
Managed a team of over 20 members (including direct reports, indirect reports, and vendors), leading different PODs to drive special projects.

AVP – Business Intelligence

Ferns N Petals (FNP)
Oct 2021 - Oct 2024 · 3 years

• Established Center of Excellence, driving data-driven decision-making culture & maintaining P&L of the department.
• Identified 12% top line business gaps worth Rs 50 Crore through customer journey, operations, digital metrics optimization and campaigns (including Google PPC & SEO).
• Optimized App journeys, increasing App order share from 29% to 42% and installations by 1.8x.
• Delivered real-time insights, contributing to 15% YoY growth and cost saving by working closely with Product, Marketing, Operations, SCM and Business team.
• Boosted conversion rates and reduced delivery times, resulting in a 13 bps increase in NPS.
• Developed PID Scorecard, Customer Churn model, RFM Segmentation to enhance customer retention and engagement by 1.5x.
• Led UI/UX revamp of FNP App, improving customer journeys and boosting conversion by 1.2 bps.
• Worked closely with Data Engineering team to manage data pipelines and ETLS to optimize Data processing cost by 18%
• Managed team of 20+ member (including Direct, Indirect reporters and the Vendors) thus headed different PODs to drive special projects.

Head – Business Intelligence

Cactus Communication
Jun 2020 - Oct 2021 · 1 year 4 months

• Developed Single Source of Truth (CDP) by aligning data from different sources into single table and thus optimized reporting and customer understanding thus improving customer repeat rate by 13%.
• Collaborated with operations team to enhance Vendor Management and Segmentation strategies, achieving a 15% increase in delivery efficiency while simultaneously lowering implementation costs by 5%, hence improved overall profit margins.
• Enhanced Data Accuracy, Data Governance and Compliance of GDPR.

Head – Business Intelligence

Cactus Communication, Mumbai
Jun 2020 - Oct 2021 · 1 year 4 months

Devised a Single Source of Truth (CDP) by consolidating data from diverse sources into a single table, optimizing reporting and enhancing customer understanding, thus improving customer repeat rate by 13%.
Collaborated with the operations team to enhance vendor management and segmentation strategies, achieving a 15% increase in delivery efficiency while simultaneously lowering implementation costs by 5%, thereby improving overall profit margins.
Enhanced data accuracy, governance, and compliance with GDPR.

Associate Director – Analytics

Proptiger (Housing.com)
Dec 2015 - Nov 2019 · 3 years 11 months

• Directed analytics team to solve complex business problems, deep dive analysis and generate insights using multidimensional data analysis and thus bringing in 20% YoY business growth.
• Increased conversion rates by 15% YoY through customer experience analysis and identifying growth opportunities.
• Implemented GA360 thus initiated Web (Product) Analytics including event tracking for all 3 web platforms and analyzed customer journeys thus improving the Conversion rate by 2x.

Associate Director – Analytics

Proptiger (Housing.com), Gurgaon
Dec 2015 - Nov 2019 · 3 years 11 months

Directed the analytics team to solve complex business problems, conducting deep-dive analyses to generate insights using multidimensional data analysis, thereby driving 20% YoY business growth.
Increased conversion rates by 15% YoY through comprehensive customer experience analysis and identification of growth opportunities.
Implemented GA360, initiating web (product) analytics including event tracking across all three web platforms, analyzing customer journeys, and improving the conversion rate by 2 times.

Senior Consultant

Fractal Analytics
Dec 2010 - Dec 2015 · 5 years

• Led cross-border projects, driving a 7% revenue increase for BNPP in collaboration with Visa Consulting.
• Managed Project Delivery for Fortune 500 Clients mainly VISA for the SEA & CEMEA region.
• Project Development by growing revenue from the Client from $100K to $150K.
• Provided Pre-Sales support and Business Development opportunities in the CEMEA region.

Senior Consultant

Fractal Analytics, Dubai
Dec 2010 - Dec 2015 · 5 years

Spearheaded cross-border projects, generating a 7% revenue increase for BNPP in partnership with Visa Consulting.
Managed project delivery for Fortune 500 clients, primarily VISA, in the SEA and CEMEA regions.
Engineered project development by boosting revenue from the client from $100K to $150K.
Provided pre-sales support and identified business development opportunities in the CEMEA region.

Assistant Manager - Portfolio Insights & Analytics

EXL Services, USA
Jul 2009 - Dec 2010 · 1 year 5 months

Assistant Manager - Portfolio Insights & Analytics

EXL Services
Jul 2009 - Dec 2010 · 1 year 5 months

- Headed the delivery of Web Analytics project for an Insurance giant in USA by sharing opportunity to grow the online business and moving away from traditional offline business

Business Analyst

Isango India Pvt. Ltd., Gurgaon
Dec 2007 - Jun 2009 · 1 year 6 months

Business Analyst

Isango India Pvt. Ltd.
Dec 2007 - Jun 2009 · 1 year 6 months

- Head the MIS, Online Analytics, Web Analytics and Business Analytics by working closely with various business stakeholders and sharing business opportunities to grow online business

Business Consultant

Fractal Analytics, Singapore
Jul 2006 - Nov 2007 · 1 year 4 months

Business Consultant

Fractal Analytics
Jul 2006 - Nov 2007 · 1 year 4 months

- Headed the delivery of the projects for Fortune 500 client - VISA from its SEA office in Singapore and shared opportunities to improve Cross-border business

Skills

Excel Google Analytics Leadership Process Improvement Python Structured Query Language (SQL) Problem Solving Alteryx Business Intelligence Data Science Google Cloud Platform Analytical Thinking Data Visualization Adobe Analytics Customer Segmentation Power BI R Programming Language (R) Tableau Data Analytics Advanced Analytics Web Analytics Artificial Intelligence
Report this Profile?