PROFESSIONAL SUMMARY:

• Over 20 years of development, batch automation and administration experience.
• ETL development utilizing Oracle SQL*Loader scripting, SQL and PL/SQL.
• Experience with Sun Solaris, HP - UX, AIX UNIX and various Linux operating systems.
• Experience working with UNIX scripting languages Korn, C shell and Perl.
• Production support experience with Oracle in various ETL, data warehousing and application environments.
• Business Objects development, administration and support.

TECHNICAL SUMMARY:

RDBMS: Oracle 7, 8, 9i, 10g, RAC, 11g, 11g on AWS and 12c.

RDBMS Access: SQL*Plus, TOAD, SQL Developer and SQL Navigator.

Languages: Oracle PL/SQL, Korn, Bash, C shell scripting and Perl.

Operating systems: UNIX and Linux.

Batch Automation: Autosys 4.5, R11.x, DBMS SCHEDULER and crontab.

BI Applications: Business Objects.

Other: SQL*Loader, Perl DBI, NDM Connect Direct, FTP, SFTP, CA WCC, Net Backup and CVS/SVN version control software.

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr Oracle Developer

Environment: Oracle 11g, PL/SQL

Responsibilities:

• Sr. Oracle Developer for Operational Risk Management (ORM) group
• Converted existing batch operations on the back-end to real-time processing using PL/SQL packages.
• Performance tuning for queries used in reporting and the ORM application.
• Provided Level III support for the Operations Team.
• Performed Database design and code reviews.

Confidential, Irving, TX

Sr Oracle Developer

Environment: Oracle 11g, PL/SQL

Responsibilities:

• Sr. Oracle Developer for Operational Risk Management (ORM) group
• Converted existing batch operations on the back-end to real-time processing using PL/SQL packages.
• Performance tuning for queries used in reporting and the ORM application.
• Provided Level III support for the Operations Team.
• Performed Database design and code reviews.

Confidential, Jacksonville, FL

Application Programmer

Environment: Oracle 12c, PL/SQL, Autosys R11, Korn shell scripting

Responsibilities:

• Sr. Oracle Developer for the Confidential group.
• Wrote Linux Korn shell scripts that were used as wrapper processes for file trasfers, file polling and Oracle SQL*Plus required for batch automation.
• Wrote SQL*Loader control scripts used to import data into the database.
• Automated testing process using Autosys and Korn shell scripting.
• Perl scripting utilizing the DBI and Threads modules to create parallel processing used in creating database extracts.

Confidential

Sr. Database Developer / DBA

Environment: SQL Server, SSIS, Powershell, sqlcmd utility

Responsibilities:

• Provided SQL Server DBA support for databases related to warehouse picking and business intelligence.
• Maintained SSIS packages that were used as ETL processes to provide data to the BI database.
• Used the sqlcmd utility and Powershell to create a scripts and a subset of data from production that the developers used in local unit testing.

Confidential, Addison, TX

Oracle Developer / DBA

Environment: Oracle 11g, PL/SQL, DBMS SCHEDULER, *NIX

Responsibilities:

• Provided Oracle 11g database development.
• Troubleshoot issues in the existing PL/SQL packages.
• Query and process performance tuning of SQL and PL/SQL code used by application.
• Automation of procedures using DBMS SCHEDULER.

Confidential, Pennington, NJ and Plano, TX

Sr. Oracle Developer

Environment: Oracle 11g, PL/SQL, Autosys R11, *NIX, Korn Shell

Responsibilities:

• Provided application setup and configuration and assisted in troubleshooting defects.
• Provided assistance of the initial batch automation using Autosys and Korn shell scripting.
• Application support of the Teradata Aprimo Marketing application.

Confidential, Beaverton, OR

Application Engineer

Environment: Oracle 11g, PL/SQL, DBMS SCHEDULER, Autosys R11, *NIX

Responsibilities:

• Provided Oracle 11g database development.
• Troubleshoot issues in the existing PL/SQL packages as well as provided new development according to STM and Functional Specifications
• Query and process performance tuning of SQL and PL/SQL code.
• Automation of Oracle processes using DBMS SCHEDULER.
• Management of batch in Production, Production Support (PS ) and Release environment (RLS) using Autosys.

Confidential, Portland, OR

DBA/ PL/SQL Developer

Environment: Oracle 11g on Amazon Web Services ( AWS ), PL/SQL, DBMS SCHEDULER

Responsibilities:

• Provided DBA support for Oracle on AWS for various production and development databases.
• Query and process performance tuning of SQL and PL/SQL code used by enterprise application.
• Automation of weekly production processing through the use of DBMS SCHEDULER.
• Researched and resolved issues with database performance at the system and application level.

Confidential, Beaverton, OR

HR Batch Coordinator

Technologies Summary: Autosys R11.

Responsibilities:

• Management of batch in Production, Production Support (PS ) and Release environment (RLS)
• Coordinating outages, upgrades, and releases.
• Attending meetings and communicating information out to HRIT.
• Review all batch changes and approve them.