Rajat Khatri

Rajat Khatri

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

نبذة عني

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…

الخبرة

AVP – Business Intelligence

Ferns N Petals (FNP), Gurgaon
Oct 2021 - حتى الآن · 4 سنوات 9 أشهر

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 سنوات

• 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 سنة 4 أشهر

• 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 سنة 4 أشهر

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 سنوات 11 أشهر

• 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 سنوات 11 أشهر

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 سنوات

• 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 سنوات

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 سنة 5 أشهر

Assistant Manager - Portfolio Insights & Analytics

EXL Services
Jul 2009 - Dec 2010 · 1 سنة 5 أشهر

- 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 سنة 6 أشهر

Business Analyst

Isango India Pvt. Ltd.
Dec 2007 - Jun 2009 · 1 سنة 6 أشهر

- 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 سنة 4 أشهر

Business Consultant

Fractal Analytics
Jul 2006 - Nov 2007 · 1 سنة 4 أشهر

- 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

المهارات

إكسل تحليلات جوجل توجيه تحسين العمليات بايثون (لغة برمجة) لغة الاستعلامات الهيكلية (SQL) حل المشكلات ألتيركس الاستخبارات التجارية علم البيانات منصة Google Cloud التفكير التحليلي التصور البياني للبيانات تحليلات أدوبي تقسيم العملاء باور بي آي لغة البرمجة آر (R) تابلو تحليلات البيانات Advanced Analytics Web Analytics Artificial Intelligence
الإبلاغ عن هذا الملف الشخصي؟