Total 12 Years’ Experience in Banking and Financial domain with Nucleus Software Exports Limited, Noida. Work for Nucleus Software Finnone LMS (D2K /JAVA) and PL/SQL Technology. Extensive technical knowledge and experience on ORACLE procedures, functions, packages, triggers, SQL & performance tuning. Adept at maintaining cordial relationship with client with better client interaction skills and provide the best solution by Product knowledge. Expertise in Group GL Reconciliation & Template handling. Experience in development, Peer & User acceptance testing & version control. Have Involved in Analyzing the Detailed Functional Specification of Various Custom Components Implemented for Resolution of Real Time Issues. Have Hands on Programming Experience in Oracle SQL and PLSQL.
More than 12+ years of programming experience as an Oracle PL/SQL Developer in all phases of Software Development Life Cycle (SDLC) including Analysis,
Design, Data Modeling(Logical and Physical) and implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
Expertise in creating relational database development, for creating complex databse queries, writing Contraints, Indexes, Views, Packages, Stored Procedures,
Cursors and Functions using PL/SQL in Oracle databases.
Expertise in Database Performance Tuning, Performance monitoring and Optimization using Oracle hints, Explain plans, TK-prof.
Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export.
Experience in development of custom Oracle forms and reports application.
Used several Oracle provided packages such as DBMS JOB, DBMS Profiler, DBMS STATS and DBMS Scheduler packages.
Skilful in working with the tools like SQL*PLUS, TOAD, PL/SQL Developer.
PL/SQL
undefinedAxis bank, Mumbai, 2012 - 2016, This project involved enhancements and performance tuning requirements. Loan auto authorization: Wherein user have to do disbursal initiation and system will auto authorize the loan which has been punched in Loan Origination System. Fate upload: This involved update of actual status of PDC (Post Dated Cheques) . Bulk Rescheduling upload: This involved automation of rescheduling activity wherein user want to change the repayment schedule of a loan. Billing process Tuning: This is vital process in Finnone product as this creates EMI due on billing date, so slow processing caused loss in business hours of Axis Bank. GL Reconciliation: Being a bank/financial organization it must have reconciled GL balances before financial end, I check the GL balances and shared clarification if found any. It is a monthly activity which is done on month end. Disbursal Initiation: This is the process to purchase new contracts from LOS module and to move contracts into LMS, this process was taking time to push the data into LMS.
Hero Fincorp, Delhi, 2016 - 2020, This project involved enhancements and performance tuning requirements. Receipt Automation: This include automation of receipts wherein user will upload data in file through process and these receipts will automatically be updated as bounced, clear or canceled through this process. Presentation Process Automation: Presentation process is a vital process in financial organization and automation of this process reduced a lot of manual interventions and manual errors. Combined Repayment Schedule: In this change customer asked for combined repayment schedule for partially disbursed cases. FRR Process: In this change customer asked for FRR process to be enabled based on product, scheme, uploaded agreements and flexible parameters on which they can restructure repayment schedule of loan. IMD Cancellation: In this requirement customer has asked to manage IMD money as income or refund as per their requirement loan wise. Auto closure Maturity: In this change system should pick all those matured or foreclose eligible cases automatically and process these cases for closure. There should be handling of cutoff amount on the basis of type of closure request. Many other enhancements: Broken period accrual, Crilic Report generation, Eod Bod process execution from backend and dependent process execution.
OVF Bank of Spain, Delhi, 2020 - 2021, In this project I was aligned with a team to complete the implementation of Bank of Spain wherein my responsibility was to accomplish interface implementation in the project. I was awarded with Behind the Scene award for completing implementation within target date.
GMF Chile, Delhi, 2021 - Present, In this project I was aligned with a team to monitor day to day financial requirement of business. My role is to smoothen the regular functionality of Finnone and look for the proper coordination of Finnone with other organization which will help business to perform better. Last month I got SPOT award for providing key defect fix for Chile project.