Prakash  ·  Senior Oracle PL/SQL Developer  ·  5+ yrs

Overview: This project focused on Investment Banking with a Banking client, involving application development and database management. Responsibilities: Analyzed business requirements and designed Oracle database solutions for new enhancements. Performed database migrations from DB2 and MS Access to Oracle Database. Developed and modified database objects, including packages, procedures, functions, and triggers, with robust error handling. Implemented ETL processes for extracting, transforming, and loading data from flat files into Oracle, often using SQL*Loader. Tuned database performance by creating indexes and optimizing queries with hints, achieving faster data retrieval. Developed and maintained UNIX shell scripts and DOS batch files to support project needs.

Overview: This ongoing project in Investment Banking involves developing backend database solutions for a financial client. Responsibilities: Understood technical directions from programming staff for backend database design and development. Developed PL/SQL procedures, functions, and packages to implement complex business requirements. Created Dynamic SQL scripts within PL/SQL for runtime SQL statement generation. Utilized SQL*Loader and External Tables for efficiently loading data from flat files into Oracle databases. Enhanced performance and manipulated large datasets using Bulk Binding and Collections.