Dec 2022 – Nov 2024 · 1 yr 11 mos · On-site

• Established a Business Intelligence Centre of Excellence, driving a data-driven decision-making culture and automated 50+ daily/ weekly reports on Tableau
• Delivered real-time insights, contributing to 15% YoY growth by supporting business and decisions
• Through Business Analytics, identified top line business gaps worth Rs 50 Crore through analysis around customer journey, operations, and digital metrics optimisation
• Boosted conversion rates and reduced delivery times by providing Insights around Operational gaps, thus resulting in a 13 bps increase in NPS
• Optimized App journeys, increasing App order share from 29% to 42% and installations by 1.8x by moving to App first approach
• Developed PID Scorecard, Customer Churn model, and 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 using tools like Adobe Analytics, Appsflyer and Clevertap
• Managed team of 20+ member (including Direct, Indirect reporters and the Vendors) thus headed different PODs to drive special projects

Oct 2021 – Dec 2022 · 1 yr 2 mos · On-site

• Established Centre of Excellence for Business Intelligence by hiring top talent in the roles of Business Analysts, BI specialists, Web Analyst, Data Scientists & MIS to create culture of Data driven decision making resulting in a year-over-year growth of 15%+
• Developed Real Time & Accurate Data & Insights to Senior Management/ Investors and Board members enabling them to with Dashboards, reporting and MIS thus reducing manual reporting worth 100 hours and enabling management to make informed business decisions
• Implemented click tracking in Adobe Analytics and GA4 from scratch, enabling product managers, designers, and the merchandising team to develop features across all four platforms of FNP. This enabled enhanced user journeys and conversion rate improved by 1.1x
• Established Customer Data Platform (CDP), to drive Customer Insights thus improving Customer Retention rate by 10%.
• Collaborated closely with Data Engineers to write ETLs and manage server costs

Jun 2020 – Jun 2020 · 0 mo

• The book is available at https://amzn.to/2YPhvrb
• This book talks about 10 principles to be adopted to live a life full of happiness, well-being, and fulfillment. These 10 principles were based on the research conducted in the field of psychology in the leading universities of the world. Many great researchers, who have conducted many experiments in this field, have suggested various activities that must be converted into habits to sustain a high level of happiness index.
• This book is all about understanding the basics of happiness and the research, so it becomes easier for readers to practice the exercises and develop these as a part of the daily routine. All the exercises are free of cost but require three vital things that are easily available but hard to conduct – a few minutes in a day, consistency and dedication

Jan 2020 – Present · 6 yrs 5 mos

• With a purpose to make Organizations Smarter, I work on
• Driving Business Insights from existing Data
• Using AI tools in day to day Business, to improve efficiency
• Enhance Employee Wellness & Happiness to boost productivity
• Current Projects
• Head of Ananlytics with GoMechanic
• Content Creator (Youtube, Instagram and LinkedIn with name RajatRKKhatri)
• Author of the book - 10 Keys to Attain Happiness
• Keynote Speaker at 50+ Events
• Been the guest on 15+ Podcasts
• Conducted Sessions, Trainings & Keynotes for brands like Pepsico, Adobe, Salesforce, ETCIO, Business Standard, Big FM, Alooba, Cactus Communication, GoMechanic, FNP,
• Been Guest Speaker at 50+ Institutes like FORE, KJSIMSR, NMIMS, Edubridge, Benett University

Aug 2019 – Jun 2020 · 10 mos

• I'm a dedicated about Living a Happy and Meaningful life. Therefore, I became a Certified Happiness Coach, Amazon Bestseller Author and started "Happy Life Architecture" to coach Individuals to live a Happier life by using Digital products like Courses, Books, Webinar, Speaking assignments, Workshops and Masterclasses.
• Happiness is a Science (and not an Art). There are Researches, Frameworks, and Studies behind this subject and "Achieving Happiness" is becoming the key Metrics to achieve these days.
• MY MISSION
• Work with organisations to create awareness and the need for happiness at work.
• Implement strategies where the employees happiness is part of the company's culture.
• Make Happiness tracking a key KPI to the track not only by HR but everyone from Top to Bottom.
• MY SERVICES
• Personalised Workshops - 1/2 Day, 1 Day and 2 Day workshops which includes Activities conducted by the participants.
• Corporate Talks - Provide lessons, motivation and research results to make the audience happier and create AHA moments
• Awareness Workshops - to increase the awareness & start implementing the tools to bring more happiness and performance in teams

Jun 2020 – Oct 2021 · 1 yr 4 mos · Mumbai, Maharashtra, India · Remote

• Lead 10 member Business Intelligence team to develop Reports and Dashboards for various teams in Tableau and thus providing Real-time data and reducing manual data reporting by nearly 50 hours worth of efforts
• Crafted Single Source of Data to improve Data Quality and Trust by implementing Google Analytics 360 as a solution, designing event tracking and thus providing Insights around the customer journeys that led to 1.25x improvement in Conversion rate
• Work across Business Dimensions to finalize the KPIs and track them. Also, to help them achieve the business targets by finding Business opportunities. This led to 135% achievement of the Topline revenue
• Developed Real Time analysis framework and provide Trigger based alerts for quick actions towards the lagging business KPIs thus bringing in Operational efficiency in the business

Dec 2015 – Sep 2019 · 3 yrs 9 mos · Gurugram, Haryana, India · On-site

• Leading Analytics team, major responsibility was to solve complex business problems, provide insights through multi-dimensional data analytics, and drive actionable business strategies
• Conversion grown by 15% YOY by conducting analysis of the online customer experience, by identifying opportunities for profitable growth including overall engagement funnel, product page optimization, new feature rollout, omni-channel integration
• CPC slashed by 40% by working closely with Marketing team to optimize traffic, campaigns, landing page experience and user journey and thus improving conversion from Paid channel
• SEO traffic grown by 125% by providing analysis to SEO team related to keywords CTR, Conversion and Engagement. Analysed the impact of landing on Amp vs. Non-Amp pages, impact of change in Ranking etc, impact of introduction of taxonomy and price-trend pages
• Enhanced Engagement metrics through Advanced Analytics by optimizing algorithmic and data science solutions such as personalization, recommendations, filter order, listing ranking etc.
• Became #1 in Listing count by providing Competition benchmarking, market share study across channels, evaluating industry problem, opportunity across Paid Sellers, Projects and Pricing
• App Retention improved by 68% by providing App Analytics, App Usage, Downloads, Retention and Usage Behaviour for Buyer as well as Seller Apps for Makaan and Housing
• Creating, Presenting and Maintaining Overall Business Dashboard that defines Business health and KPIs to CXOs and Board on a Monthly basis for all business. Corresponding data was stored in Redshift through ETLs to make processing effective and efficient
• Creating, Naming, Maintaining and Tracking Events across all pages, products and funnels for all platforms to track User journeys across pages
• Providing Consumer Insights, Buying Trends, Stories related to Real Estate industry which were published in leading publications for the purpose of PR

Dec 2010 – Dec 2015 · 5 yrs · Dubai, United Arab Emirates

• As a Senior Consultant, my responsibilities and achievements included:
• Managing multiple Analytics and Consulting projects for the Visa client in their Europe region. Includes understanding requirements, data, business, providing updates and directions to the team and update client about the project, status and approach followed. (Mar'15 - Dec'15)
• Creating dashboard for the clients on MicroStrategy to provide real time Gaps and opportunities
• Business growth in Middle East through Pre-Sales, Sales and relationship building (Oct'14 - Mar'15)
• Leading Analytics support to the Visa client in CEMEA region for all their clients: Banks, Acquirers, Merchants in Middle East, Russia and Sub Sahara Africa. (Nov'12 - Sep'14)
• Received NPS score of 62.5 and 75 (Target 50) in 2 consecutive years
• Nominated for Top Employee Award 'FractElite' in the year 2013 and 2014

Jul 2009 – Dec 2010 · 1 yr 5 mos · Richmond, Virginia, United States · On-site

• Manage Client Deliverables and Consulting
• Lead key projects like Barclays by providing them Monthly Business Insights related to Portfolio across markets.
• Awarded “Team of the Month” based on Client Value Addition
• Lead Pilot project for Contactless Card usage across markets and Setting up Web Analytics from scratch for Genworth Insurance both for Consumer and Brokers platform

Dec 2007 – Jun 2009 · 1 yr 6 mos · Gurugram, Haryana, India · On-site

• Managed Weekly/ Monthly Reporting & MIS
• Shared Business Insights with Product & Marketing teams to provide them with hypothesis to grow the business
• Initiated Affiliate Marketing & Video Advertising for the Travel sector

Jul 2006 – Nov 2007 · 1 yr 4 mos · Singapore · On-site

• Major responsibility was Execution and Delivery of projects, understanding Data and Business requirements, Data Processing, Insight generation and Client Consulting
• Worked on Projects like Cross Border Marketing Optimization for VISA, Segmentation for UOB, Malaysia and Marketing Analytics for Chico’s, USA

Feb 2004 – May 2004 · 3 mos · Sas Nagar, Punjab, India · On-site

Jun 2002 – Feb 2004 · 1 yr 8 mos · Chandigarh, India · On-site

Jul 2000 – Nov 2000 · 4 mos · Ludhiana, Punjab, India · On-site

Nov 1999 – Jun 2000 · 7 mos · Ludhiana, Punjab, India · On-site