Summary
Overview
Work History
Education
Skills
Certification
Awards
Sqlprojects
Timeline
Generic
Ravi Kumar

Ravi Kumar

Data Analyst
Bengaluru

Summary

Versatile Data and Salesforce Business Analyst with over 5 years 5 months of experience in leveraging advanced analytics and business intelligence tools to inform strategic decision-making and enhance operational efficiency. Seeking to contribute to the success of the Company as a Data Analyst /Salesforce Business Analyst /Product Analyst.

Overview

7
7
years of professional experience
14
14
Certifications

Work History

Data Analyst

MyCaptain
03.2022 - Current
  • Spearheaded Salesforce system enhancements, increasing Pre-Sales team efficiency by 30% through custom reports and feature development which led to an increase in conversion rate by 20%
  • Led data analysis using Google Sheets and MS Excel, resulting in a 20% increase in targeted marketing strategies' effectiveness
  • Managed vendor relations and implemented IVR solutions, enhancing customer service operations by 25%
  • Optimized communication processes using Moengage and Verloop, improving customer-facing operations efficiency by 15%
  • Extracting Complex data from Salesforce Database using SQL for Mid-funnel performance tracking
  • Functioning as Salesforce Admin & Salesforce Business Analyst
  • Business Requirement Gathering for feature and automation development
  • Coordinating with salesforce developer as product person for development and testing of features
  • Optimised and brought new stages and lead status in the lead processing state machine in Salesforce
  • Instrumentation of data to analyze the lead progress and capturing data for insights
  • Clustering leads in Persona's to Optimize Sales Executives efforts on leads and optimize marketing campaign for lead Generation.

Associate Engineer

Quess Corp Limited
11.2020 - 03.2022
  • Contributed to OBD II software development and vehicle testing, resulting in a 10% improvement in diagnostic accuracy
  • Engaged in reverse engineering projects, enhancing product understanding and support capabilities.

Graduate Apprentice Trainee

Mahindra and Mahindra Limited
10.2018 - 10.2019
  • Led Industry 4.0 Lab projects from inception to completion, achieving a 15% improvement in assembly line efficiency
  • Managed maintenance of manufacturing machines, reducing downtime by 20%.

Jr Consultant (Operations & Analytics)

Autoninja
12.2017 - 06.2018
  • Managed CRM services for automotive dealers, increasing customer retention rates by 10%
  • Conducted data analysis to identify growth opportunities, resulting in a 5% increase in dealer sales.

Education

B.Tech in Mechatronics - undefined

SRM University
07.2014 - 2018.05

Class 12, Science -

Pranab Vidyapith Higher Secondary School
02.2013 - 2014.05

High School Diploma -

Mount Mary Higher Secondary School
01.2011 - 04.2012

Skills

Data Analysis

undefined

Certification

The Complete SQL Bootcamp - Udemy

Awards

  • 1st place in Innovation, Electric Solar Vehicle Championship (ESVC)
  • 3rd runners-up, National Solar Vehicle Challenge 2017 (NSVC)

Sqlprojects

  • Mid-Funnel Performance Tracking, Improve conversion rates by analyzing mid-funnel metrics., Salesforce, SQL, Extracted and analyzed mid-funnel data, optimizing processes., Increased conversion rates by 20%
  • Targeted Marketing Strategy Analysis, Enhance marketing strategy effectiveness., Google Sheets, SQL, Analyzed campaign data to identify trends., Boosted campaign effectiveness by 20%
  • Customer Service Operations Enhancement, Improve customer service efficiency., Salesforce, Google Sheets, SQL, Analyzed interaction data and optimized processes., Enhanced efficiency by 25%

Timeline

Data Analyst

MyCaptain
03.2022 - Current

Associate Engineer

Quess Corp Limited
11.2020 - 03.2022

Graduate Apprentice Trainee

Mahindra and Mahindra Limited
10.2018 - 10.2019

Jr Consultant (Operations & Analytics)

Autoninja
12.2017 - 06.2018

B.Tech in Mechatronics - undefined

SRM University
07.2014 - 2018.05

Class 12, Science -

Pranab Vidyapith Higher Secondary School
02.2013 - 2014.05

High School Diploma -

Mount Mary Higher Secondary School
01.2011 - 04.2012
The Complete SQL Bootcamp - Udemy
Probability and Statistics For Business and Data Science - Udemy
Become a Product Manager - Learn the Skills & Get the Job - Udemy
Advanced Product Management: Vision, Strategy & Metrics - Udemy
Data Programming ( SQL & Python) - Sololearn
SQL Intermediate - Sololearn
Trailhead Badge: User Management - Trailhead by Salesforce
Trailhead Badge: Salesforce Admin: Quick Look - Trailhead by Salesforce
Trailhead Badge: Lightning Experience Customization - Trailhead by Salesforce
Trailhead Badge: Data Management - Trailhead by Salesforce
Trailhead Badge: Reports Dashboards for Lightning Experience - Trailhead by Salesforce
Trailhead Badge: Data Modeling - Trailhead by Salesforce
Trailhead Badge: Salesforce Platform Basics - Trailhead by Salesforce
Trailhead Badge: Essential Habits for Salesforce Admins - Trailhead by Salesforce
Ravi KumarData Analyst