Oracle PL/SQL Developer Resume Example Highmark Inc.

ORACLE PL/SQL DEVELOPER

Professional Summary

Over 5 years of experience in designing, developing, implementing and testing database applications and solutions as Oracle PL/SQL Developer.

Skills

Oracle PL/SQL specialist
Experience in using SQL Navigator, TOAD for Oracle, SQL Developer, and Eclipse developing tools
Experience with working on Harvest (CA Software Change Manager), PVCS VM, and Git Version Controls
Advanced knowledge of various databases such as Oracle, MS Access, and Teradata
Working knowledge with DB Tools/Utilities like OM, SQL*ELoader, Explain Plan, TKPROF, Import/Export, and EXPDP/IMPDP

Advanced knowledge of Linux Shell Scripting
Data Warehouse ETL design knowledge
Knowledge of Java core, C, and C++
Advanced problem solving skills
Troubleshooting and debugging
Performance and scalability optimization
Knowledge of using Data Modeling Tools such as Erwin and Visio

Work History

Oracle PL/SQL Developer, 06/2012 to Current
Highmark Inc. – Pittsburgh, PA

Involved in understanding the technical direction of the programming staff from a back end database design and development perspective.
Developed Linux Shell/SQL Scripts for data extraction, transformation and to load on staging tables.
Developed PL/SQL Procedures/Functions/Packages to load data into Dimension and Fact tables.
Improved data warehouse's performance by implementing advanced Oracle Data Warehousing features: Materialized Views, Partitioning, External Tables, Dimensions, Parallel Execution.
Worked with Production Support team to immediately resolve failures in production data processing. Collaborated with business users on
resolving data inconsistency and reporting issues.
Used SQL*Loader and created the External Tables in order to load data from flat files into oracle tables.
Extensively used Bulk Collect and FORALL statements for manipulating the large amount of data and enhance performance.
Wrote complex SQL queries using joins and sub queries to retrieve data from the database. Also made use of set operators like Union, Union all, Intersect and minus.
Responsible for performance tuning using Explain plan, TKPROF and oracle Hints. Used Table Partitioning in huge Table to increase database performance.
Responsible for Import and Export of database objects as per requirement. Also used DB LINKS for accessing data across different databases.
Used 'SQL Navigator' IDE for developing and managing Pl/SQL
scripts.
Used Bitmap, B-Tree Index and functional based Index to enhance
performance to retrieval Data from database table.
Handled errors using system defined exceptions and user defined exceptions.
Optimized and enhanced the existing procedures and SQL statements for the better performance.
Attended walk through, Code review and Status meeting to discuss the status of the project.

Oracle PL/SQL Developer, 10/2010 to 03/2012
US Census Bureau – Suitland, MD

Involved in understanding the technical direction of the programming staff from a back end database design and development perspective.
Developed procedures, functions and packages to implements the business Requirement using PL/SQL.
Created Dynamic SQL script in PL/SQL to build SQL statements dynamically at runtime.
Used SQL*Loader and created the External Tables in order to load data from flat files into oracle tables.
Extensively used Bulk Binding and Collections for manipulating the large amount of data and enhance performance.
Wrote complex SQL queries using joins and sub queries to retrieve data from the database. Also made use of set operators like Union, Union all, Intersect and minus.

Oracle DBA/PL/SQL Developer, 10/2005 to 11/2007
IONNOR Solutions – Mohali, Punjab, India ‎

Analyzed the business requirements of the project by studying the Business Requirement Specification document.
Installed and upgraded oracle database server.
Migrated database from DB2 and MS Access to Oracle Database.
Created/Modified tables, views, queries for new enhancement in the application using TOAD.
Created/Modified database objects like packages, procedures, functions, and triggers and handled errors using Exceptions.
Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client.
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL*Loader.
Used PL/SQL Wrap Utility to encrypt PL/SQL source code and to make the code portable to any platform.
Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
Created and modified several UNIX shell scripts/ Dos Batch files according to the changing needs of the project and client requirements.

Education

Master of Science: Computer Engineering, 2010
University of Bridgeport - Bridgeport, CT (USA)

Post Graduate Diploma in Computer Application: Computer Application, 2005
Guru Nanak Dev University - Punjab, India

Bachelor of Science: Computer Application, 2004
Guru Nanak Dev University - Punjab, India

Certifications

Oracle Advanced PL/SQL Developer Certified Professional
(1Z0-051,1Z0-147,1Z0-146)
Oracle Certified Associate, Oracle Solaris 10 Operating System (1Z0-876)

Resume Overview

Companies Worked For:

Highmark Inc.
US Census Bureau
IONNOR Solutions

School Attended

University of Bridgeport
Guru Nanak Dev University

Job Titles Held:

Oracle PL/SQL Developer
Oracle DBA/PL/SQL Developer

Degrees

Master of Science : Computer Engineering , 2010
Post Graduate Diploma in Computer Application : Computer Application , 2005
Bachelor of Science : Computer Application , 2004

Oracle PL/SQL Developer Resume Example

Resume Score: 80%

DISCLAIMER

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes