LiveCareer-Resume

oracle pl sql developer resume example with 14+ years of experience

Jessica
Claire
resumesample@example.com
(555) 432-1000,
, , 100 Montgomery St. 10th Floor
:
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
Education
University of Bridgeport Bridgeport, CT (USA) Expected in 2010 Master of Science : Computer Engineering - GPA :
Guru Nanak Dev University Punjab, India Expected in 2005 Post Graduate Diploma in Computer Application : Computer Application - GPA :
Guru Nanak Dev University Punjab, India Expected in 2004 Bachelor of Science : Computer Application - GPA :
Certifications
  • Oracle Advanced PL/SQL Developer Certified Professional
    (1Z0-051,1Z0-147,1Z0-146)
  • Oracle Certified Associate, Oracle Solaris 10 Operating System (1Z0-876)
Work History
Galaxy Solutions - Oracle PL/SQL Developer
Somerset, NJ, 05/2012 - Current
  • 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.
Galaxy Solutions - Oracle PL/SQL Developer
Hartford, CT, 09/2010 - 02/2012
  • 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.
IONNOR Solutions - Oracle DBA/PL/SQL Developer
City, STATE, 09/2005 - 10/2007
  • 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.

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • University of Bridgeport
  • Guru Nanak Dev University
  • Guru Nanak Dev University

Job Titles Held:

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

Degrees

  • Master of Science
  • Post Graduate Diploma in Computer Application
  • Bachelor of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: