AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXF34013
profile image
Balsaraf A AXF34013 Active
PLSQL developer sql in Pune
PL/SQL Developer with 3.6 years of experience in Oracle database development, performance tuning, and Master Data Management (MDM) for banking and financial services. Skilled in writing efficient PL/SQL code and optimizing PL/SQL workflows, improving query performance, automating data processes, and ensuring compliance with RBI/SEBI/KYC regulations. Adept at supporting large-scale data migration, resolving production issues, and delivering high-quality, governed customer data for critical banking operations .
Industries : Banking and Finance, Banking
Share
Hire Balsaraf A
Download PDF
Availability
Full-time
Total experience
4 years
Technical skills
PLSQL
3 Years & 7 Months
ETL
3 Years & 7 Months
Performance Tuning
3 Years & 7 Months
Database development
3 Years & 7 Months
query tuning
3 Years & 7 Months
Plsql developer, soapUI,postman,jira
Projects
Customer MDM and single KYC
August-2022 to
Description
Project goal was to design and implement a centralized Customer Master Data Management (MDM) platform to consolidate customer records from multiple banking systems and establish a reusable Single KYC profile. The system delivered a 360-degree customer view by validating key attributes (Name, Mobile, PAN, etc.) across Branch, Mobile, Internet Banking, and ATM channels. It eliminated duplicate records, improved data accuracy, and enabled reuse of verified KYC documents across financial products (savings, credit cards, loans, insurance). The platform also automated extraction and updates of customer records from Core Banking, Loans, Credit Cards, Internet Banking, and Insurance, thereby strengthening compliance, reducing manual effort and streamlining onboarding and servicing.
Roles and Responsibilities
Designed and developed database objects (tables, views, procedures, packages) using Oracle SQL Developer as per business requirements. Maintained and enhanced PL/SQL procedures, functions, triggers, and packages by implementing change requests. Optimized phone number procedure and developed a trigger to log values into the log table, reducing execution time by 49.34%(4.56 min to 2.31 min). Developed and optimized complex SQL queries and PL/SQL stored procedures using bulk collect, bind variables, and exception handling, enhancing performance and reliability. Optimized daily MERGE process in MDM project by adding composite indexes, filtering changed records, and using conditional updates, reducing runtime from 15+ min to under 2 min. It improved data availability for downstream applications. Participated in Citi Bank to Axis Bank customer data migration, developing custom PL/SQL scripts to ensure accurate, efficient, and seamless data transfer. Implemented and maintained Master Data Management (MDM) to ensure clean, consistent, and governed customer data across banking systems. Participated in migration from Bespoke MDM to Informatica MDM as part of SDLC. Performed testing for Informatica MDM using testing tools like Postman and SoapUI and documented test cases. Applied business rules to standardize customer attributes (name, address, mobile, PAN, Aadhaar), removed duplicates/junk values. Ensured compliance with RBI/SEBI/KYC regulations while providing clean customer data to downstream systems. Managed routine support activities including job monitoring, incident resolution, and troubleshooting database-related issues. Provided application-level support by resolving tickets and customer issues on calls as well as mails and in-depth investigation of production issues to maintain operational continuity. Provided Root Cause Analysis (RCA) reports for recurring production issues. Participated in Disaster Recovery (DR) drills to ensure system availability.
Technologies: Plsql developer, soapUI,postman,jira
Industry: Banking and Finance
Customer MDM
Description
Project goal was to design and implement a centralized Customer Master Data Management (MDM) platform to consolidate customer records from multiple banking systems and establish a reusable Single KYC profile. The system delivered a 360-degree customer view by validating key attributes (Name, Mobile, PAN, etc.) across Branch, Mobile, Internet Banking, and ATM channels. It eliminated duplicate records, improved data accuracy, and enabled reuse of verified KYC documents across financial products (savings, credit cards, loans, insurance). The platform also automated extraction and updates of customer records from Core Banking, Loans, Credit Cards, Internet Banking, and Insurance, thereby strengthening compliance, reducing manual effort.
Roles and Responsibilities
Designed and developed database objects (tables, views, procedures, packages) using Oracle SQL Developer as per business requirements. Maintained and enhanced PL/SQL procedures, functions, triggers, and packages by implementing change requests. Optimized phone number procedure and developed a trigger to log values into the log table, reducing execution time by 49.34%(4.56 min to 2.31 min). Developed and optimized complex SQL queries and PL/SQL stored procedures using bulk collect, bind variables, and exception handling, enhancing performance and reliability. Optimized daily MERGE process in MDM project by adding composite indexes, filtering changed records, and using conditional updates, reducing runtime from 15+ min to under 2 min. It improved data availability for downstream applications. Participated in Citi Bank to Axis Bank customer data migration, developing custom PL/SQL scripts to ensure accurate, efficient, and seamless data transfer. Implemented and maintained Master Data Management (MDM) to ensure clean, consistent, and governed customer data across banking systems. Participated in migration from Bespoke MDM to Informatica MDM as part of SDLC. Performed testing for Informatica MDM using testing tools like Postman and SoapUI and documented test cases. Applied business rules to standardize customer attributes (name, address, mobile, PAN, Aadhaar), removed duplicates/junk values. Ensured compliance with RBI/SEBI/KYC regulations while providing clean customer data to downstream systems. Managed routine support activities including job monitoring, incident resolution, and troubleshooting database-related issues. Provided application-level support by resolving tickets and customer issues on calls as well as mails and in-depth investigation of production issues to maintain operational continuity. Provided Root Cause Analysis (RCA) reports for recurring production issues.
Technologies: Plsql developer, soapUI,postman,jira
Industry: Banking
Work history
Software Engineer • August-2022
Description: Designed and developed database objects (tables, views, procedures, packages) using Oracle SQL Developer as per business requirements. Maintained and enhanced PL/SQL procedures, functions, triggers, and packages by implementing change requests. Optimized phone number procedure and developed a trigger to log values into the log table, reducing execution time by 49.34%(4.56 min to 2.31 min). Developed and optimized complex SQL queries and PL/SQL stored procedures using bulk collect, bind variables, and exception handling, enhancing performance and reliability. Optimized daily MERGE process in MDM project by adding composite indexes, filtering changed records, and using conditional updates, reducing runtime from 15+ min to under 2 min. It improved data availability for downstream applications. Participated in Citi Bank to Axis Bank customer data migration, developing custom PL/SQL scripts to ensure accurate, efficient, and seamless data transfer. Implemented and maintained Master Data Management (MDM) to ensure clean, consistent, and governed customer data across banking systems. Participated in migration from Bespoke MDM to Informatica MDM as part of SDLC. Performed testing for Informatica MDM using testing tools like Postman and SoapUI and documented test cases. Applied business rules to standardize customer attributes (name, address, mobile, PAN, Aadhaar), removed duplicates/junk values. Ensured compliance with RBI/SEBI/KYC regulations while providing clean customer data to downstream systems. Managed routine support activities including job monitoring, incident resolution, and troubleshooting database-related issues. Provided application-level support by resolving tickets and customer issues on calls as well as mails and in-depth investigation of production issues to maintain operational continuity. Provided Root Cause Analysis (RCA) reports for recurring production issues. Participated in Disaster Recovery (DR) drills to ensure system availability.
Education
Masters degree in Computer Science
Mumbai University
2019 to 2021
Language
English - Advanced