Prakash · Senior Oracle PL/SQL Developer · 5+ yrs
Mid-LevelAbout Prakash
Prakash applies over 5 years of professional experience as a PL/SQL Developer, leveraging Oracle technologies to deliver robust solutions. His expertise spans the full Software Development Life Cycle (SDLC), with significant contributions to Investment Banking projects. He excels in database design, ETL processes, and performance tuning, demonstrating strong capabilities in handling large datasets efficiently.
Core expertise
Additional skills(5)
Why hire Prakash?
Ownership of database object creation and modification in projects.
Demonstrated ability in database migration processes from DB2 and MS Access to Oracle.
Proven track record in optimizing database performance through various tuning techniques.
Successfully migrated databases from DB2 and MS Access to Oracle Database.
Enhanced database performance through index creation and query optimization, resulting in faster data retrieval.
Developed extensive PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections, and Database Triggers.
Project highlights(2)
Investment Banking Database Management – PL/SQL Developer
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.
Key outcomes:
Successfully migrated databases from DB2 and MS Access to Oracle.
Enhanced database performance through index creation and query optimization.
Investment Banking Backend Solutions – PL/SQL Developer
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.
Key outcomes:
Implemented business requirements through comprehensive PL/SQL procedures, functions, and packages.
Improved performance for large data manipulation using Bulk Binding and Collections.
5+ years of industry experience
- •Investment Banking Database Management— PL/SQL DeveloperPL/SQL · Oracle 11g · SQL*Loader · UNIX Shell Scripting
- •Investment Banking Backend Solutions— PL/SQL DeveloperPL/SQL · SQL*Loader · External Tables
At a Glance
Single contract. Billed in USD.
Typically responds within 4 business hours.
Top Skills
Vetted by WitaristNot sure if this is the right fit?
Tell us your requirements and we'll match you with the best candidates.
Prakash
Orcale Developer