Summary
Overview
Work History
Education
Skills
CAREER TIMELINE
SKILL MATRIX
Personal Information
Timeline
Generic

Himanshu Chitrakar

Pune

Summary

  • Strategic Data Analytics & IT Leadership with expertise across the BFSI and enterprise technology domains, specializing in descriptive, diagnostic, and predictive analytics. Improved financial forecasting and trend analysis, driving revenue optimization for key clients.
  • Proficient in end-to-end ETL processes, leveraging Oracle SQL, PLSQL, PySpark, Azure Databricks, and Informatica for data extraction, transformation, and loading, data pipeline automation, data lake architecture. Automated data pipelines and reduced processing time by 50%.
  • Expert in financial modeling, variance analysis, risk assessment, and forecasting, utilizing descriptive, diagnostic, and predictive analytics to enhance budgeting, trend analysis, revenue optimization, and cost control strategies.
  • Proven ability in data warehousing, data cleansing, normalization, and governance, ensuring data integrity, compliance with regulatory standards, and seamless integration of structured and unstructured datasets.
  • Business intelligence (BI) and dashboarding expertise, designing interactive reports, KPI scorecards, and data visualizations in Tableau & Power BI, enabling real-time monitoring, performance tracking, and strategic decision-making for senior stakeholders.
  • Skilled in Agile and DevOps methodologies, collaborating with cross-functional teams, managing data migration projects, optimizing data processing workflows, and automating reporting functions to improve operational efficiency and reduce turnaround time.
  • Experienced in stakeholder engagement, requirement gathering, and process automation, translating business needs into scalable data solutions, SQL query optimization, API integrations, and leveraging AI-driven analytics for enhanced decision support.

Overview

6
6
years of professional experience

Work History

Sr. Unit Manager Data Analyst

Bajaj Finance
09.2022 - Current
  • Database Management & Troubleshooting: Troubleshoot and maintained the reporting database environment, ensuring optimal system performance and issue resolution.
  • Data Expertise & Integrity: Provided technical expertise in data storage, mining, cleansing, and integrity, ensuring high-quality, normalized datasets.
  • Predictive Analytics: Leveraged data modeling and predictive analytics to convert complex data into actionable insights and forecast future trends.
  • Confidential Data Handling & Compliance: Managed and processed confidential data in line with strict guidelines, ensuring compliance and data security across reporting activities.
  • Data Reporting & Analysis: Generated comprehensive reports across 5+ systems, delivering key insights that improved data-driven decision-making, resulting in a 20% reduction in reporting time for senior management.
  • Business Intelligence Development: Developed and implemented 10+ dashboards using Tableau and BI tools like Power BI, which led to a 15% increase in operational efficiency by providing real-time insights for performance monitoring and decision-making.
  • Performed advanced data analysis and implemented Design of Experiments (DOE) to drive growth in both secured and unsecured business volumes across verticals, while designing interactive Tableau dashboards to track campaign performance, borrower segmentation, and approval conversions, enabling stakeholders to optimize strategy.

Unit Manager

Bajaj Housing Finance
Pune
09.2019 - 09.2022
  • Conducted advanced data analysis and implemented Design of Experiments (DOE) to increase mortgage business volumes across verticals.
  • Designed and developed Tableau and Power BI dashboards to track DOE data counts, conversion ratios, and business performance, providing real-time insights for leadership.
  • Analyzed customer interactions from SMS and app channels to identify borrower profiles, enabling data enrichment and personalized campaigns tailored to mortgage products.
  • Implemented DOE and challenger programs to test new mortgage offerings, supporting seasonal volume growth while mitigating portfolio risk.
  • Created and managed pre-approved mortgage offers for targeted customer segments, balancing growth with risk policy compliance.
  • Built algorithms and SQL logic for cleaning and validating vendor-purchased property data and CIBIL records, enhancing the accuracy of mortgage pre-approval programs.
  • Designed interactive Tableau dashboards showcasing mortgage campaign performance, borrower segmentation, and approval conversion, enabling stakeholders to optimize strategy.

Education

MBA - Computers

Pune University
DY Patil
01-2024

Bachelor of Science - Computers

Amravati University
Amravati, India
07-2016

Skills

  • Database Management: Oracle SQL, Oracle PLSQL, Azure Synapse Analytics, Data Warehousing, Query Optimization & Performance Tuning
  • ETL & Big Data Technologies: Basic PySpark, Azure Databricks, Informatica, Control-M (Job Scheduling & Automation), Data Pipeline Development
  • Data visualization: Tableau & Power BI

CAREER TIMELINE

  • 20016 - 18 | IT Appz India
  • 2018 - 19 | Bajaj Finance (Offroll)
  • 2019 - 23 | Bajaj Housing Finance
  • 2023 - Present | Bajaj Finance

SKILL MATRIX

  • Progressive Leadership
  • Technology & Innovation
  • Data-Driven Decision Making
  • Problem-Solving & Results Orientation
  • Analytical Thinking & Critical Analysis

Personal Information

Timeline

Sr. Unit Manager Data Analyst

Bajaj Finance
09.2022 - Current

Unit Manager

Bajaj Housing Finance
09.2019 - 09.2022

MBA - Computers

Pune University

Bachelor of Science - Computers

Amravati University
Himanshu Chitrakar