SUMMARY

• Over 12 years of experience in software application 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 and ERWin writing server side stored procedures/ triggers.
• Experience in Performance Tuning, Capacity Planning, Space Management, Database Upgrades/Migration and Planning Backup & Recovery Strategies.
• Experience in OLTP system support in Oracle DB & ETL processes using PL/SQL as well as Informatica.
• 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, ERWin, PL/SQL Developer, TOAD, SQL Navigator, Oracle Forms 6.0/6i/9i/10g, Oracle Reports 3.0/6.0/6i/9i/10g, Serena Version Manager for PVCS, Spotfire, Informatica PowerCenter 9.

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.

O.S: UNIX, Windows 7, Windows Vista, Windows NT and Windows 2000/98/95.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Oracle Developer

Responsibilities:

• Performed analysis and code changes of various Database triggers, SQL programs, functions, stored procedures and packages as a part of my duties.
• Created new database functions to in corporate new business and regulatory requirements into the existing processes. Performed modifications on existing DB objects including cursors within existing SQL scripts using TOAD and front-end applications using Oracle Forms 10g.
• Provide technical assistance to the EDI Lead and modify, test and debug various interfaces as per the business logic requirements.
• Created and modified batch files for automation of SQL script files and scheduled those using DBMS scheduler.
• Developed the migration scripts for deploying the code into production and worked with the DBA group on go-live day during migration to production.
• Provide technical support in testing and debugging of multiple modules in the Northern Border/Bison pipeline application after go-live.

Environment: Windows 7, Oracle 10g Enterprise Edition, SQL*Plus, TOAD 12.7.0.12, Oracle Forms 10g.

Confidential, Houston, TX

Oracle Developer / Data base Analyst

Responsibilities:

• 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.
• Provided analytical as well as technical support for ETL processes in Oracle database systems using PL/SQL logic as well as Informatica.
• 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: Oracle 11g Enterprise Edition Release 11.2.0.4.0 , SQL*Plus, TOAD 10.0.5.1710 , TIBCO Spotfire, Informatica PowerCenter 9.

Confidential, Houston, TX

Senior Oracle Developer/Analyst

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.
• Worked closely with the Database Administrator (DBA) group to develop and optimize the performance of the database, data transfer replication and refresh jobs running on the database. Also performed performance tuning of existing Views and Snapshots which included creating and modifying indexes on the tables and re-writing the queries based on the explain plans generated.
• Provide analytical support in testing, debugging an implementation of multiple complex PL/SQL programs.

Environment: 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/Programmer Analyst

Responsibilities:

• Worked as a part of the Oil and Shipping Delivery Vertical team at Confidential .
• 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 100% as a Developer on the STI Connect Project which involved interfacing the STUSCO system with Global SAP (GSAP) using complex PL/SQL and UNIX programs. Worked on production support for that project (OLTP system) post go-live.
• Worked with the Database Administrator (DBA) group and the Middleware group to develop the interface and setting up the directories on the database and host server.
• Involved in performance tuning and code review of complex SQL Queries.
• Created database procedures to extract the data from flat text files into staging database tables using oracle built-in packages.
• Created and modified batch files for automation of SQL script files and scheduled those using DBMS scheduler. Also automated executing script files through UNIX using Appworx.
• Performed enhancements on existing DB objects and PL/SQL programs and also developed new programs and reports using TOAD.

Environment: 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.
• Performed enhancements on existing forms and reports using Oracle Forms & Reports 6i.
• Performed analysis, code review and performance tuning of various Database triggers, complex SQL programs and queries, stored procedures and packages using SQL Navigator as a part of my duties.

Environment: 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 US Company (STUSCO) Oracle DBA 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 & roles into new ones as part of enhanced security controls.
• Created SQL Loader scripts to extract data obtained from STNA Security into the Oracle database staging tables.
• Created and modified database objects including complex Stored Procedures, Functions and Packages.
• Performed enhancements on existing forms using Oracle Forms 10g.
• Performed Installation of Oracle Forms & Reports 10g. Also worked on Oracle Forms Application Server configuration and managed the mid-tier servers.

Environment: 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

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.
• 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, 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).

Environment: RETEK, PL/SQL Developer, Oracle Forms & Reports 6i, Oracle 9i, Windows NT, Unix.

Confidential, Houston, TX

Oracle Developer

Responsibilities:

• I have also worked on support and troubleshooting for these projects as well as subsequent projects that have been completed at various times over the duration of my assignment.

Environment: PL/SQL Developer, Oracle 9i, MS SQL Server Mgmt Studio, Windows NT and Windows XP.

Confidential, Houston, TX

Oracle Developer

Responsibilities:

• Involved in Peebles Integration, a project for Confidential Inc. using Oracle 9i database, Oracle Forms & Reports 6i.
• Involved in the Developing, Testing and Tuning the Flash Sales Reports at various levels used to display corporate sales data along with the history data.
• As a part of the MarketMax project, created Autosys scheduler jobs and SQL scripts in Unix environment.
• As a part of the Multiple Tax Rate Implementation project, I designed forms, reports and created data conversion scripts for implementing interfaces for the users that will help them in the maintenance of tax rate systems and reporting data through web reports.
• I was involved in multiple projects in RMS functional areas such as Item reclassification and Inventory and the Retek Distribution Management (RDM) functional areas such as Carton Tracking, Central Stock and RTI Sorter Simulation.
• Also worked on production support & on-call support for the real-time OLTP system, the relevant Autosys batch processes as well as previous & subsequent projects that have been completed including Peebles Expansion and Merchandise Hierarchy Conversion.

Environment: RETEK, PL/SQL Developer, Oracle Forms & Reports 6i, Oracle 9i, Windows NT and Unix.