Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Prathmesh Jadhav

Pune

Summary

Highly motivated and analytical data professional with 2 years of experience as a Data Analyst. Possesses technical expertise and a deep understanding of business needs. Skilled in predictive modeling, data manipulation, exploratory data analysis, and visualization. Proven track record of identifying trends and patterns to drive business growth and optimize processes. Strong attention to detail with the ability to effectively communicate complex findings to non-technical stakeholders.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Assistant Manager-(Data Analyst)-Mortgage Business

Bajaj Finance Limited
Pune
09.2023 - Current
  • Maintained and enhanced the customer propensity model for fresh home loans, optimizing bureau variables based on business requirements for salaried customer segmentation. Leveraged SQL for advanced data analysis.
  • Strategically segmented the balance transfer eligible customer pool into 24 broad categories using bureau tradelines, prioritizing segments for targeted inbound and outbound marketing acquisition based on historical conversions.
  • Created a comprehensive B2C business funnel dashboard utilizing Excel and SQL for tracking KPIs, from lead acquisition to disbursal of outbound data allocation.
  • Managed the execution and tracking of monthly DOEs (models) for outbound customer acquisition in the mortgage business, targeting both salaried and self-employed customers. Utilized SQL, Excel, and QuickSight to analyze conversions and optimize acquisition strategies.

Associate (Data Analyst) - Insurance Business

Bajaj Finance Limited
Pune
07.2022 - 08.2023
  • As an Associate in the insurance business, I provided data support and tracked performance using Power BI, SQL, and Excel. Developed KPIs for metrics including business done, growth, lead generation, and call center performance, generating reports to enhance decision-making and business outcomes.
  • Implementation of comprehensive customer journey tracking and a retargeting campaign model to recapture journey drop customers by utilizing the skillset in SQL.
  • Cleaned and segmented business prospect data to align with marketing goals, enhancing new customer acquisition.
  • Provided data insights to various marketing teams to support strategic decision-making and campaign effectiveness.

Business Analyst Internship

iNeuron
Banglore(remote)
02.2022 - 05.2022
  • Solved various given assignments and problems by utilizing the skillset of SQL, Python, PowerBI, and Excel.

Education

M.C.A(External) - Data Science

Bharti Vidyapeeth Pune
Karad
04-2024

Bachelor of Science - Statistics

Shivaji University, Kolhapur
Kolhapur
04-2020

Skills

  • Microsoft SQL Server
  • PostgreSQL
  • Spark SQL
  • Excel
  • Power BI
  • Quicksight
  • Python
  • Statistics

Certification

  • iNeuron Business Analytics Master
  • IBM Excel For Data Analysis
  • iNeuron.ai Power BI Community
  • Python for data science and machine learning Udemy

Timeline

Assistant Manager-(Data Analyst)-Mortgage Business

Bajaj Finance Limited
09.2023 - Current

Associate (Data Analyst) - Insurance Business

Bajaj Finance Limited
07.2022 - 08.2023

Business Analyst Internship

iNeuron
02.2022 - 05.2022

M.C.A(External) - Data Science

Bharti Vidyapeeth Pune

Bachelor of Science - Statistics

Shivaji University, Kolhapur
Prathmesh Jadhav