Jitendra Ralhan

VP - Business Intelligence - 2020 Jan - 2023 June

• Orchestrated the design and execution of end-to-end ETL jobs for the maintenance of the analytics database.
• Created visually compelling dashboards featuring comprehensive summaries.
• Engineered an ETA system based on proprietary historical data, ensuring precise vehicle tracking.
• Designed and maintained a dynamic loyalty and promotion engine, contributing to successful marketing campaigns and maintaining favorable churn and retention metrics.
• Managed diverse geospatial requirements and implemented internal data enhancements.
• Developed custom tools for marketing, operations, and customer support teams, streamlining routine workflows.

Senior Data Analyst - 2018 Jan - 2019 Dec

• Pioneered the establishment of a data and reporting infrastructure using Tableau and SQL, providing real-time insights into product marketing funnels and business KPIs.
• Executed A/B experiments to optimize product conversion rates and reduce churn.
• Automated operational tasks, including updates to vehicle schedules.
• Implemented a Rentals Lead Management system with editable dashboards in Metabase for efficient tracking and management of leads from various sources.
• Handled data requests using raw SQL, specializing in SQL tuning, functions, triggers, and data analysis through SQL queries and Jupyter notebooks.
• Employed machine learning models for predictive analysis of cancellations and conversions.
• Engaged in web scraping and API integration using Python scripts.
• Conducted data analysis employing segmentation, exploratory data analysis (EDA), clustering techniques, and cohort analysis.

Operations Manager - 2016 Apr - 2027 Dec

• Cultivated and maintained relationships with suppliers to ensure collaborative effectiveness.
• Led and managed an on-the-ground team.
• Designed optimal routes, established efficient processes, and implemented quality checks.
• Addressed grievances and oversaw the redressal processes.
• Managed the launch of new routes.
• Ensured compliance with regulatory requirements.

• Conducted an analysis of industry trends and identified bottlenecks for fleet owners, incorporating relevant features into the product to address business challenges and enhance decision-making processes.
• Shaped solutions and approaches by capitalizing on trends within customer marketplaces and various industries.

• Enhanced business direction by prioritizing customers and implementing changes informed by collected feedback.
• Examined existing SQL queries to pinpoint opportunities for improvement.
• Orchestrated project planning and execution in collaboration with team members and team leads.

• Developed test scenarios and perform functional testing and document test results
• Defined setups and configured AP, AR, FA and GL modules with R12 new features
• Defined GL setups, Chart of Account (COA), Calendars and periods for Assets and projects

• Migration of Informatica Mappings from DEV to QA, QA to Prod
• Development of database objects like Stored Procedures, Functions, Packages and Triggers
• Application development, production support and minor enhancements, reports and dashboards.