•
Developed and managed the complete lifecycle of loan processing for a banking/financial institution
•
Handled high-volume loan data including application, approval, disbursement, repayment tracking, and closure
•
Integrated data from branch operations, online applications, and third-party systems into Oracle database
•
Developed PL/SQL packages, procedures, and functions for loan eligibility validation, interest calculation, EMI generation, and repayment scheduling
•
Used complex SQL queries, joins, and analytical functions for data processing and reporting
•
Supported multiple loan types with customized business rules and workflows
•
Implemented triggers and constraints for data integrity and business validations
•
Created batch jobs and scheduler programs for daily activities like EMI generation, payment updates, and penalty calculations
•
Implemented exception handling and logging for transaction and system error tracking
•
Applied performance tuning techniques including indexing, query optimization, and execution plan analysis
•
Used tools like SQL Developer, TOAD, and AWR reports for monitoring and troubleshooting
•
Generated MIS and regulatory reports to support business decision-making and compliance
•
Designed and developed database as per client requirements
•
Developed complex functions, procedures, and packages
•
Tuned SQL code and PL/SQL procedures/functions
•
Created tables and checked constraints
•
Coded database triggers
•
Analyzed business requirements and impact of new development
•
Created design documents, developed and tested code
•
Involved in end-to-end development and bug fixing
•
Analyzed critical logic
•
Generated reports for business analysts and end-users
•
Migrated master data from source to target server through DB_LINK
•
Worked in Unix environment