POONAM BHAWARI
Data Engineer
Pune
Summary
Results-driven Data Engineer with hands-on experience in automating banking processes using Azure Data Factory (ADF), SQL, and cloud-based ETL solutions. Proven track record of reducing manual efforts by up to 95% through scalable pipeline development, workflow optimization, and data quality improvements. Skilled in managing ITSM data requests, Credit Limit Increase (CLI) processes, and supporting audit and compliance with accurate, audit-ready datasets. Strong domain knowledge in banking operations, customer communications, and EMI/SNP workflows.
Overview
3
3
years of professional experience
4043
4043
years of post-secondary education
Work History
Data Engineer
RBL Bank
07.2022 - Current
- Automated Banking Reports via ADF: Migrated critical manual banking reports to Azure Data Factory, reducing manual effort by 83%, increasing process efficiency, and ensuring data accuracy and compliance.
- End-to-End Automation of LTI (Long Term Inactive) Customer Process: Designed and implemented a fully automated pipeline for the LTI customer identification and reporting process, achieving 95% automation, and improving data traceability and turnaround time.
- Campaign Communication Workflows: Developed ADF pipelines to streamline customer communication campaigns, enabling timely delivery of messages based on segmentation and campaign triggers.
- SNP/EMI (Split and Pay) Process Optimization: Automated multiple sub-processes and validation steps in the SNP/EMI data flow, significantly reducing manual intervention, and increasing operational efficiency.
- Insurance Data Audit Automation: Built data pipelines to support audit and compliance reporting for insurance-related datasets, ensuring clean, traceable, and regulation-ready outputs.
- ITSM Request Management: Proactively handle ITSM (IT Service Management) requests related to data sharing and access, ensuring timely ticket assignment, resolution tracking, and stakeholder coordination.
- Credit Limit Increase (CLI) Process Support: Manage the CLI process end-to-end, including base data loading, issue resolution, and customer-level support, ensuring seamless updates and accurate data handling.
- I took the initiative to organize and lead multiple office events and employee engagement activities, contributing to a positive work environment and team bonding beyond regular project responsibilities.
Education
Bachelor of Engineering - Information Technology
Pune Institute of Computer Technology
Pune08-2022
Diploma in - Computer Engineering
Government Polytechnic Pune
Pune06-2019
Skills
SQL Developer,
ETL,
ETL developer,
ETL Testing,
ADF,
Azure Data factory,
Databricks,
Python,
Data Warehouse,
Project Management,
Data analysis
Timeline
Data Engineer
RBL Bank
07.2022 - Current
Bachelor of Engineering - Information Technology
Pune Institute of Computer Technology
Diploma in - Computer Engineering
Government Polytechnic Pune