We provide IT Staff Augmentation Services!

Senior Oracle Developer Resume

Houston, TX

SUMMARY

  • Nearly 11 years of experience in software development using Oracle Technologies.
  • Oracle PL/SQL Developer Certified Associate (OCA).
  • Strong experience in back - end programming in Oracle SQL*Plus, PL/SQL Developer and TOAD specializing in Database Triggers, Packages, Stored Procedures and Functions.
  • Proven expertise in all phases of Software Development Life Cycle (SDLC) of various projects.
  • Proficient in Data Modeling (Logical and Physical Design of Databases) using Designer 2000 writing server side stored procedures/ triggers.
  • Experience in Performance Tuning, Capacity Planning, Space Management, Database Upgrades/Migration and Planning Backup & Recovery Strategies.
  • Experience in Database Administration of systems operated by multiple users and multiple databases.
  • Extensive experience in Client/Server application development using Oracle Forms 5.0/6.0/6i/9i/10g.
  • Experience on multiple projects implemented for Energy Trading and Risk Management (ETRM) systems.
  • Over 3 years of experience on multiple projects implemented using the RETEK application.
  • Expertise in creating custom reports using Oracle Reports 3.0/6.0/6i/9i.
  • Experience in Dynamic SQL, Records, Arrays and Exception Handling.

TECHNICAL SKILLS

GUI Tools: RETEK (Oracle Retail Application), Developer 2000, Designer 2000 V 2.1, PL/SQL Developer, TOAD, SQL Navigator, Oracle Forms 6.0/6i/9i/10g, Oracle Reports 3.0/6.0/6i/9i/10g, Merant Version Manager for PVCS, Spotfire.

Databases: Oracle 11g/10g/9i/8i/8.0/7.0, MS SQL Server 2005, MS Access 7.0/97/2000.

Languages: C, C++, SQL, PL/SQL, T-SQL, Pro*C, MATLAB.

Web: HTML, MS FrontPage.

Operating Systems: UNIX, Windows NT and Windows 2000/98/95.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Senior Oracle Developer

Responsibilities:

  • Currently involved in the Development and Database Support for the Rockies Business Unit Production DB, which includes creation and enhancements of the database.
  • Create new views/snapshots for creating new reports in Spotfire for the business users.
  • Involved in the database mappings for the Data warehousing project for the Rockies DB.
  • Perform analysis and enhancements of various Database tables, views and packages, Materialized Views and Scheduler jobs as a part of my duties using TOAD.

Environment: The environment used is Windows 7, Oracle 11g Enterprise Edition Release 11.2.0.4.0 , SQL*Plus, TOAD 10.0.5.1710 , TIBCO Spotfire.

Confidential, Houston, TX

Senior Oracle Developer

Responsibilities:

  • Involved in the Development and Database Support for the Production DataMart Repository (PDREP) DB, which includes batch jobs for DB replication and refresh of snapshots using MV logs, all of which run on the Oracle database.
  • PDREP is the DataMart for the Enterprise Upstream (EU) Application, which is the Oracle Applications software for Oil and Gas.
  • Perform enhancements on existing DB objects including Materialized Views using PL/SQL Developer.
  • Perform analysis of various Database tables, views and packages, Materialized Views and Scheduler jobs as a part of my duties.
  • Provide analytical support in testing, debugging an implementation of multiple complex PL/SQL programs.

Environment: The environment used was Windows 7, Oracle 11g Enterprise Edition Release 11.2.0.4.0 , SQL*Plus, ServiceNow, PL/SQL Developer 10.0.5.1710 .

Confidential, Houston, TX

Senior Oracle Developer

Responsibilities:

  • Worked as a part of the Oil and Shipping Delivery Vertical team at Shell Trading.
  • Involved in the Application and Database Support for the Inventory Optimizer (IO) Application, Appworx Batch Scheduling Application and the XPT Application, all of which run on the Oracle database.
  • In addition to the above duties, performed the Technical and Business Analysis and worked as a Developer on the STI Connect Project which involves interfacing the STUSCO system with Global SAP (GSAP) using complex PL/SQL and UNIX programs. Currently working on production support for that project post go-live.
  • Involved in performance tuning and code review of complex SQL Queries.
  • Performed enhancements on existing DB objects and developed new applications using TOAD.
  • Performed analysis of various Database triggers, SQL programs, stored procedures and packages as a part of my duties.
  • Provided analytical support in testing, debugging an implementation of multiple complex reports.

Environment: The environment used was Windows VISTA, UNIX, Oracle 10g Enterprise Edition Release 10.2, SQL*Plus, Microsoft Visual Studio, TOAD 10.6.1, Citrix.

Confidential, Houston, TX

Senior Oracle Developer

Responsibilities:

  • Involved in the Application and Database Support for the Confidential Power Vision Application, which is developed using Oracle Forms & Reports 6i.
  • Involved in performance tuning and code review of complex SQL Queries.
  • Performed enhancements on existing forms and reports using Oracle Forms & Reports 6i.
  • Performed analysis of various Database triggers, SQL programs, stored procedures and packages using SQL Navigator as a part of my duties.
  • Provided analytical support in testing, debugging an implementation of multiple complex forms and reports.

Environment: The environment used is Windows XP, Oracle 9i Enterprise Edition Release 9.2.0.5.0, SQL*Plus, Oracle Forms 6i, Oracle Reports 6i, SQL Navigator 4.3.2.476, Citrix.

Confidential, Houston, TX

Oracle Developer

Responsibilities:

  • Worked as a part of Confidential Company (STUSCO) Oracle Development Group on Project DSPAM (Database and Self-Permissioning Access Management) for STNA Security.
  • Was involved in the Database Security Remediation project for the North America (NA) databases, which includes data migration of current user profiles and roles into new ones as a part of enhanced security controls.
  • Created SQL Loader scripts to extract data obtained from STNA Security into the Oracle database temporary tables.
  • Created and modified database objects including complex Stored Procedures, Functions and Packages.
  • Created SQL scripts to migrate the data from SQL Loader into the database tables as per the data model and requirements.
  • Involved in performance tuning and code review of complex SQL Queries.
  • Performed enhancements on existing forms using Oracle Forms 10g.
  • Worked on Oracle Forms Application Server configuration and managed the mid-tier servers.
  • Performed Installation of Oracle Forms & Reports 10g.

Environment: The environment used was Windows 2000, UNIX, Oracle 10g Enterprise Edition Release 10.2.0.1.0 , SQL*Plus, Oracle Forms 10g, Oracle Reports 10g, TOAD 9.6.1, Citrix.

Confidential, Houston, TX

Senior Oracle Developer

Responsibilities:

  • Worked as a part of Energy Trading and Risk Management (ETRM) Oracle Development Team on Nucleus Project HULK for Energy Trading.
  • Created new Forms and performed enhancements on existing forms using Oracle Forms 9i.
  • Created new FAS (Financial Accounting Standards) Reports using Oracle Reports 9i.
  • Provided maintenance and support for Oracle Forms & Reports for Project HULK.
  • Created and modified database objects including Tables, Indexes, Triggers, Views, Stored Procedures, Functions and Packages.
  • Involved in performance tuning and code review of complex SQL Queries.
  • Performed Installation of Oracle Forms & Reports 9i.

Environment: The environment used was Windows NT, Oracle 10g Enterprise Edition Release 10.2.0.3.0 , SQL*Plus, Oracle Forms 9i, Oracle Reports 9i, PL/SQL Developer, PVCS Version Control (Merant Version Manager), Citrix.

Confidential, Houston, TX

Oracle Developer

Responsibilities:

  • Involved in SAS MDO implementation, a project for Confidential Inc. using Oracle 9i database, Oracle Forms & Reports 6i.
  • Responsible for Forms Development (for data handling of the employee and user records, purchase orders, invoices and transactions), enhancements (for adding features to system), creating and modifying Batch programs (for Unix Autosys batch jobs using Unix Shell scripts) and Debugging (error handling and output requirement fixes).
  • Perform analysis of various Database triggers, SQL programs, stored procedures and packages using PL/SQL Developer during coding, testing and debugging phases.

Environment: The environment used was RETEK, PL/SQL Developer, SQL*Plus, Oracle Forms 6i, Oracle Reports 6i, Oracle 9i, Windows NT and Unix.

Hire Now