Summary
Overview
Work History
Education
Timeline
Skills
Generic

Jitendra Ralhan

Business Intelligence Analyst
Mumbai

Summary

Seasoned Business Intelligence analyst equipped with a robust expertise in deciphering and evaluating data to propel expansion and enhance operational workflows. Devoted to assisting businesses in formulating decisions guided by data.

Overview

15
15
years of professional experience
4
4
years of post-secondary education

Work History

VP - Business Intelligence

Cityflo - Komorebi Tech Solutions Pvt Ltd
Mumbai
04.2016 - 06.2023

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.

Founding Team Member

Boxploy - Logistics Marketplace
Mumbai
01.2015 - 01.2016
  • 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.

Business Analyst

BOOKMYCAB - LiveMinds Solutions Pvt. Ltd
Mumbai
06.2014 - 12.2014
  • 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.

Technical Associate

Clover Infotech Private Limited
Mumbai
09.2013 - 06.2014
  • 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

Assistant System Engineer

Tata Consultancy Services Ltd, Telecom Company
Mumbai
12.2008 - 01.2010
  • 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.

Education

Bachelor of Engineering - Computer Science

Rajiv Gandhi Technical University
Bhopal
06.2004 - 06.2008

Timeline

VP - Business Intelligence

Cityflo - Komorebi Tech Solutions Pvt Ltd
04.2016 - 06.2023

Founding Team Member

Boxploy - Logistics Marketplace
01.2015 - 01.2016

Business Analyst

BOOKMYCAB - LiveMinds Solutions Pvt. Ltd
06.2014 - 12.2014

Technical Associate

Clover Infotech Private Limited
09.2013 - 06.2014

Assistant System Engineer

Tata Consultancy Services Ltd, Telecom Company
12.2008 - 01.2010

Bachelor of Engineering - Computer Science

Rajiv Gandhi Technical University
06.2004 - 06.2008

Skills

    Data Visualization

undefined
Jitendra RalhanBusiness Intelligence Analyst