Software Engineer Resume
Sugar Land, TX
SUMMARY:
An Oracle Developer/Analyst with broad experience implementing and maintaining custom Oracle applications developed using Oracle Forms, Reports, SQL, and PL/SQL. I can function as part of a team or as an individual applying Oracle technology to solve complex problems.
MY SKILLS INCLUDE:
- Analysis
- Development
- Maintenance
- Tuning
- Database management & administration
TECHNICAL SKILLS:
SOFTWARE EXPERIENCE: Oracle Forms 9i, 6, 5, 4.5, and 3.0, Oracle Reports 6, 3, Oracle PL/SQL, Oracle SQL*Plus, SQL Developer, Oracle Pro*C, Pascal, FORTRAN, COBOL
DATABASE EXPERIENCE: Oracle 11g, 10g, 9i, 8i, Microsoft SQL Server 2008 R2 & 2012
OPERATING SYSTEM EXPERIENCE: Windows 8, 7, Server 2008, Oracle Linux 6, Solaris
EMPLOYMENT HISTORY:
Confidential, Sugar Land, TX
Software Engineer
Responsibilities:
- Oracle Developer/Analyst for a large data warehouse application that Confidential used for reporting both quality and performance data
- Performed database and OS upgrades that resulted in a 40% reduction in nightly build run time
- Managed and tuned Cost of Service Delivery back - end that helped to more effectively utilize in-stock resources
- Created a system of Linux shell scripts that ran the nightly build in a more efficient manner
- Wrote a series of PL/SQL scripts to efficiently import data from XML into Oracle tables
- Created and modified SQL Server Integration Services (SSIS) packages that would perform ETL functions, pulling data from SQL Server and inserting it into Oracle tables. Additionally migrated those packages to SQL Server 2012
- Made PL/SQL scripts to quickly find differences between the schemas of the Production and Development environments and fix those differences
Confidential, Angleton, TX
Senior Oracle Programmer
Responsibilities:
- Oracle Developer/Analyst for a manufacturing work floor management system
- Performed modification and development work on a large Oracle Forms 6i based manufacturing work floor management system that was custom built.
- Tuned and improved the responsiveness of many of the above Oracle Forms by either rewriting code or properly using indexes, thereby improving work floor turn-around time.
- Created, managed, tuned, and tested the Oracle PL/SQL data migration scripts that would port the schema of the above mentioned application to a new database format.
- Wrote extensive forms usage documentation in support of a Forms migration.
- Managed, developed, and unit tested the back-end SQL and Oracle PL/SQL used by a large Java-based data warehouse reporting application.
- Tuned and rewrote inefficient SQL queries that were submitted to the data warehouse either ad-hoc by the user or from the data warehouse reporting application.
- Decreased user complaints and downtime by being available at night to troubleshoot and fix application and database problems
Confidential, Houston, TX
Senior Software Engineer
Responsibilities:
- Programmer responsible for maintaining a physical inventory tracking system
- Managed the maintenance and development of all data model changes and database-side PL/SQL triggers for a large Exploration/Production information management system.
- Analyzed, maintained, and expanded the Oracle 6i Forms used by a large Exploration/Production physical inventory tracking system.
Confidential, Houston, TX
Oracle Programmer/Analyst
Responsibilities:
- Contractor who worked at various sites maintaining and developing Oracle Forms and Reports
- Performed contract work at a client where I engaged in the analysis, maintenance, and development of a large Exploration/Production physical inventory tracking Oracle Forms 6i system.
- Performed Y2K remediation work on Oracle Forms and Reports.
Confidential, Houston, TX
Oracle Programmer/Analyst
Responsibilities:
- Responsible for prototyping an E&P information tracking system and performing work at a client site
- Developed a prototype of an Exploration/Production information tracking system written in Oracle Forms 5.0 and Oracle Reports 3.0.
- Performed contract work at a client company where I analyzed and developed a large Oracle Forms 6i based Exploration/Production physical inventory tracking system.
Confidential, Houston, TX
Senior Programmer/Analyst
Responsibilities:
- Developer who maintained and expanded a large inventory tracking system
- Maintained and expanded a large records management/inventory tracking system written in Forms 3.0, ReportWriter 1.1, and Pro*C where the database was on a SCO Unix backend.
- Developed and maintained billing/invoicing screens, programs, and reports for the above inventory tracking system.
