Summary
Overview
Work History
Education
Skills
Achievements
Languages
Disclaimer
Timeline
Generic

Rohit Mishra

Pune

Summary

I am a seasoned data engineering professional with over 10 years of experience in the BFSI domain, specializing in data analytics, integration, and reporting solutions. I possess a strong background in tools like Databricks, Enterprise Data Warehouse (EDW), MSBI (SSIS, SSRS, SSAS), and Power BI, with extensive hands-on experience in SQL Server, data migration, cleansing, optimization, and data visualization. I have held leadership roles, managing teams and delivering critical data and reporting solutions for global clients in the financial services sector. My expertise includes automating complex reporting processes, developing end-to-end ETL pipelines, and designing comprehensive data architectures to meet business needs. I am also adept at collaborating with cross-functional teams, ensuring alignment of data solutions with business logic and KPIs to drive performance tracking, risk management, and operational efficiency.

Overview

11
11
years of professional experience

Work History

Lead – ORM

Bajaj Finance Limited
Pune
05.2022 - Current
  • Leading a team of 4 data engineers, overseeing all ORM data requirements and managing daily, monthly, and quarterly MIS reports essential for departmental operations
  • Collaborated closely with risk and functional teams to align data sources with KPIs and control charts, ensuring accurate and real-time tracking for risk evaluation
  • Automated exception triggers and breach notifications for Risk Control KPIs, derogatory reporting, and detailed LAN information for board and PPG levels, improving transparency and risk mitigation
  • Led the development of automated reports for risk KPIs, Sales Compliance Staircase action Match/Mismatch, and the ORM Data Dictionary, delivering actionable insights to leadership
  • Ensured accurate data reconciliation across multiple data sources, streamlining reporting processes and improving data quality
  • Facilitated communication among cross-functional teams in order to achieve deliverables on time.
  • Executed ad hoc reports and data analysis tasks across Risk, Sales Compliance, Banking Operations, and DMS, enhancing decision-making and responsiveness.

Lead - Technology (MSBI)

Synechron Technology Pvt. Ltd.
Pune
10.2018 - 05.2022
  • Led a team in delivering complex data integration and reporting solutions for BFSI clients using MSBI (SSIS, SSRS) and SQL Server
  • Developed, tested, and maintained planning and forecasting reports for clients.
  • Managed the migration of legacy reports to modern platforms, optimizing ETL processes for performance and scalability.
  • Collaborated with business stakeholders to ensure alignment with data requirements, ensuring timely and accurate reporting for business intelligence.

Senior Software Engineer

EPAM Systems India
Hyderabad
02.2014 - 07.2018
  • Developed and maintained robust data warehousing solutions, ensuring smooth data integration and reporting using MSBI tools
  • Created and optimized ETL processes, ensuring data quality and consistency across large-scale data environments
  • Actively engaged in client discussions to gather requirements and deliver customized business intelligence solutions.

Education

PG – DAC - Diploma in Advance Computing

CDAC, Bangalore
02.2014

Bachelor of Technology - Information Technology

AITH, Kanpur
05.2013

12th Grade (UP Board) -

SVM, Kanpur
04.2008

10th Grade (UP Board) -

SVM, Kanpur
04.2006

Skills

  • ETL and Data Engineering: Expertise in developing and optimizing ETL pipelines, managing data migration, and implementing Data Warehousing solutions
  • SQL Development: Proficient in dynamic stored procedures, T-SQL, views, and indexes
  • MSBI Stack: Extensive experience with SSIS, SSRS, SSAS for building scalable solutions
  • Power BI: Skilled in using Power BI for data visualization, reporting, and creating interactive dashboards
  • Team Leadership: Proven experience leading and mentoring teams of data engineers, ensuring effective task management, collaboration, and professional development
  • Process Automation: Expertise in automating data workflows and reporting processes to enhance operational efficiency, reduce manual effort, and ensure timely, accurate reporting
  • Client Communication: Regularly worked with clients for status updates, requirement discussions, and project management
  • Project Management: Proficient in managing end-to-end project lifecycles, from requirement gathering to implementation and delivery, using Agile methodologies like Sprint Planning, progress tracking, and deployment
  • Decision-Making: Strong problem-solving and analytical skills with a focus on data-driven decision-making, ensuring business goals are met through efficient data management and reporting solutions

Achievements

  • Awarded by EPAM as rising star -2015, got client appreciation for SIU access DB migration to SQL server.
  • Co-Ordinated Tech festival in College.
  • Participated and secured positions in various technological and cultural events organized by HBTI, IIT-KNP, IIT-KGP.
  • Secured Second place in state Science quiz in 8th class.

Languages

Hindi
First Language
English
Proficient (C2)
C2

Disclaimer

I hereby declare that above written details are true to the best of my knowledge and belief.

Timeline

Lead – ORM

Bajaj Finance Limited
05.2022 - Current

Lead - Technology (MSBI)

Synechron Technology Pvt. Ltd.
10.2018 - 05.2022

Senior Software Engineer

EPAM Systems India
02.2014 - 07.2018

PG – DAC - Diploma in Advance Computing

CDAC, Bangalore

Bachelor of Technology - Information Technology

AITH, Kanpur

12th Grade (UP Board) -

SVM, Kanpur

10th Grade (UP Board) -

SVM, Kanpur
Rohit Mishra