SUMMARY:

• A results - driven Oracle Developer with over 20 years of demonstrated success in the design, development and deployment of large and small scale enterprise applications for the Energy, oil & gas, Retail, Petrochemical, Retail Energy and loan servicing industry. Proven ability to communicate and collaborate, motivate high performance teams.
• Extended history of building Oracle application with improved functionality and productivity and consistently meeting business critical requirements.

TECHNICAL SKILLS:

Database: Oracle database version 6, 7, 8, 9, 10g, 11g(Unix) 11.2(Window)

Operating System: Window 7, Win95, Win98, Win2000, XP, HPUX 11, SunOS 5.8

Application Server: Oracle 9IAS

Development Tool: Oracle Form 6i, Oracle Report 6i, TOAD, SQL Developer, Oracle Discover

Language: Oracle PL/SQL, Oracle SQL, Oracle PRO*C, Unix Shell Script

ERP: Oracle AR 10.7SC, Oracle Retail (Retek), SAS MarketMax (Merchandise Planning)

Softwares: Microsoft Visual Sourcesafe(VSS), IBM Rational ClearQuest, Graphon Go-Global Tidal Scheduler, Confio ignite8, Tibco scheduler

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. Oracle Technical Analyst(Contract)

Responsibilities:

• The ALPS system composed of two components: GUI and Batch. For GUI interface, ALPS utilized Siebel UI component to provide the authorized view to ALPS data. With regard to the Batch component
• ALPS work with TIBCO for scheduling and background processing of business logic (execution of Oracle stored proc/func/pkg). Solely responsible for design and development of all ALPS Oracle database objects (Tables, Global Temp tables, Views, Stored Packages/Procedures/Functions).
• Database: Oracle 11g
• Tool: Toad 10.5.13
• OS: Window 7 Enterprise
• Interface Application: Siebel, TIBCO

Confidential, Houston, TX

Sr. Oracle Technical Analyst(Contract)

Responsibilities:

• Develop marketing related Oracle database application (PL/SQL Packages, Views, Tables…) to allow the marketing campaign to accurately target existing customer base.
• Develop data filtering system which cleansed the customer data (Essid, Customer name, Customer addresses….) sourced internally (Siebel, Custom databases) and those provided by outside vendors.
• Database: Oracle 11g
• OS: Unix

Confidential, Houston, TX

Sr. Oracle Technical Analyst(Contract)

Responsibilities:

• Converting high level functional requirements to detail technical documentation.
• Review technical documents with senior team member to assure all requirements have been satisfied.
• Create PL/SQL codes and configuration that meet requirements in development instance.
• Create complex reporting views, stored procedure to pull data from multiple tables, views.
• Coordinate peer code reviews with senior team members.
• Unit tested new PL/SQL codes to ensure new functionalities met all requirements.
• Unit tested changes to existing PL/SQL source code to assure that it also met all requirements (and existing functionalities still perform as originally planned).
• Assure that DDL scripts meet IT database standards in term of naming convention and syntax.
• Deployment of database objects to UAT instance and coordinate unit testing and system wide testing with business users.
• Interactively working with business users to resolve any testing issues and adding/removing requirements if necessary.
• Working with the DBA to finalize production migration script.

Confidential, Houston, TX

Sr. Oracle Technical Analyst(Contract)

Responsibilities:

• Responsible for 24/7 production support for daily Oracle batch jobs (Tidal scheduler). Trouble shooting issues and provides real-time solutions via a desktop and remote login (after hour).
• Maintain and support PL/SQL and database objects (stored procedures, functions, packages, triggers, tables, views) for the Payoff application (.NET, VB).
• Developed and support PL/SQL and database objects (stored procedures, functions, packages, triggers, tables, views, REF cursors) for the Home Alternative Modification Program (HAMP) application (MDB).
• Assist team members(developers):
• Deploying database objects (tables, views) and PL/SQL objects (Stored procedures, Functions, Triggers, REF cursors) to Test and Production environments
• Reviewing PL/SQL codes to assure the business requirements and coding standards have been meeting up
• Be preparing to provide general technical guidance if needed
• Create and assign Work Orders to developers
• Collaborate with DBA:
• Identifying roles & privileges to be assigned to users, MDB and application accounts
• Coordinate monthly & weekly production release of PL/SQL and database objects
• For each new project, request the creation of new Oracle schema, users, default system roles.
• Requesting DBA to execute certain emergency hot fixes to correct Production data issue.
• Requesting a trace when necessary
• Identifying the source of the table locks that impact the daily batch jobs
• Scheduled periodic/on-demand refresh for development/test database with Production data/metadata.
• Working with business users:

Confidential, Houston, TX

Sr. Oracle Programmer Analyst (Contract)

Responsibilities:

• Providing daily and nightly production support for Retek RMS and RDM. Responsible included:
• Around the clock monitoring RMS/RDM Autosys day, night, weekend batch jobs.
• Coding and maintaining existing modules (Tables, Views, Sql, Pl/sql, Triggers, Stored procedures, Functions, Packages).
• Working with DBAs to identify and resolve database related issues (i.e. table locks, table segments extent, object privilege…).
• Analyzed the issue and provided immediate solution.
• Generated and executed Ad-Hoc Sql scripts to correct production data issues.
• Proactively performed application tuning. Workings with DBA in generating and identifying slow perform SQL statements via Trace file. Converted trace file to readable format using TKPROF. Generated Explain Plan to identify the operations, access path and joints chosen by the optimizer. The overall performance can be improve by adding hints, created new index or in some case complete re-write the Sql statements.
• Involved in multiple projects in RMS functional areas such as Reclass, Inventory, and Allocation. Responsibilities are:
• Worked team members to create functional high-level design and detailed technical design.
• Developed modules (Tables, Global Temp Table, View, Oracle Form 6i, Oracle Report 6i, Sql, Pl/sql, Stored packages, Triggers, Functions, Procedures, and Packages) according to technical specifications.
• Performed thorough units testing in development schema.
• Coordinate the rolling changes to test and worked with users during UAT.
• Coordinate production environment roll.
• Create ETL scripts to extract merchandise data from Retek RMS and load into SAS Merchandise Planning system. Tasks included:

Confidential, Houston, TX

Sr. Oracle Programmer Analyst (Permanent)

Responsibilities:

• Utilized Oracle Discover 4.1 to developed corporate standard Oracle Discover reports for the Finance and Sale department. Tasks included scheduled meeting with users to define new report’s specifications or enhancements to current reports. Provided monthly Discover Plus class for users on developing their own ad-hoc reports.
• Completed conversion project to upgrade all Oracle form 6i to 9i. Responsibilities included identified and eliminated obsolete 6i functions/features on forms and reports. Collaborate with the DBA in configuring server side oracle environment variables, form/report/library paths, form (formsweb.cfg), and reports (servername.conf) configuration files.
• Developed and maintained current Oracle 6i custom application (forms and reports).
• Provide part - time support for Oracle AR. Defined new concurrent programs for new reports. Defined new reports parameters.
• Developed and maintained Jetform reports (.ifd), XSL stylesheets and XML datafiles for the SAP R/3 system using Jetform designer 5.3

Confidential, Houston, TX

Jr. Oracle Programmer Analyst (Contract)

Responsibilities:

• Support character based Oracle Energy (Production Accounting module).
• Provided on-demand Sql*Plus and regular Oracle reports.
• Developed and maintained essential Sql*Loader scripts for importing external non-oracle data into Oracle database.