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