Oracle Software Developer Resume Profile
GA
Summary
ORACLE Software Developer
Performance-driven IT Professional with 18 years of experience in design and development as an Oracle developer in a UNIX environment.
Professional Profile
Coded, tested and performance tuned PL/SQL in database objects packages, procedures, functions , Oracle forms, Oracle reports and Oracle Business Intelligence for multi-facility applications for Lockheed Martin, Confidential Navy and healthcare industry clients.
Technical Proficiencies
Applications: Oracle Database 4.0, 4.5, 6.0, 7.2, 8, 9i, 10g, 11g , ORACLE Forms 4.0, 4.5, 6.0, 8, 9i, 10g, ORACLE Reports 2.0, 2.5, 6, 10g, ORACLE Business Intelligence, SQL Navigator 6.4.0, SQL Developer Beta test only , SQL Loader, ORACLE Designer, IBM Data Studio 4.1, IBM Rational ClearCase Explorer 7.1.2 and Rational Requisite Pro 7.1.2, vi, NOMAD2 Forms and Reports , Microsoft Project, Microsoft Visio, Remedy, Microsoft Office, JCS Job Control Scheduler , DBMS Scheduler
Operating Systems: Windows, UNIX/Solaris, IBM DB2, IBM/VM
Programming Languages: SQL Plus PL/SQL, NOMAD2, REXX, EXEC2, HTML, COBOL
Employment History
Confidential
- Provided business analyst consulting services for client Blue Cross Blue Shield of Florida integrating third party Oracle based product to support healthcare insurance claims data warehouse applications as part of a ongoing contract renewable every 6 months.
- Created the business rules and mappings from user requirements and collaborated with the developer team and lead analyst to system test and debug the software during development and system testing.
- Supported PL/SQL changes triggers during testing and on an as needed basis
Confidential
- Confidential that provides lending services, rental real estate services, other financial and consulting services project management .
- Completed real estate renovation apartment building as project foreman. Managed day-to-day operations including work schedules, budgets 25000 and personnel 1 to 8 workmen at a time . Planned resources to satisfy routine and long-range requirements.
- Started crowd sourced loan portfolio with current return of 11 percent per year and projected growth of 9 to 10 percent per year.
Confidential
Programmer/Senior Analyst
Key Accomplishments
- Automated Movement Ordering System Upgrade/Deployment
- Tasked to upgrade the missile ground tracking software Automated Movement Ordering System aka AMOS to deploy AMOS to additional facilities while closing known potential problems in the recording of location history a customer contractual requirement .
- Updated with PL/SQL code in the affected database packages and procedures, certain complex Oracle 10g forms, Oracle 10g reports and views for use by Oracle Business Intelligence and cross tested the forms, reports and views modified another developer on the team.
- Created the test plans, set up test case data according to the test plan, and collaborated with the developer and lead analyst to test and debug the software during development and system testing.
- Implemented software updates ahead of schedule with minimal impact to user schedules. Improvements were reported in reduced time per move transaction, transparency across facilities and data integrity.
Human Resources Upgrades Convert Forms and Reports Adding On Demand and Scheduled Email Alerts
- The corporation mandated specific cost saving goals across the corporation starting in 1998.
- Tasked to supported the Human Resources HR team to convert Oracle 4.5 forms and Oracle 2.5 reports to Oracle 10g forms and reports and making additional modifications to the proprietary Oracle HR modules adding automated on-demand and scheduled Oracle's DBMS SCHEDULER email responses to the management team which alerted them to various changes in employee physical limitations and temporary or permanent changes in medical state.
- Performed all identified Oracle forms and Oracle reports coding changes
- Created the database package and its procedures for the on demand and scheduled email alerts using PL/SQL.
Calibration/Exchange Pool Development
- The corporation mandated specific cost saving goals across the corporation starting in 1998
- Performed general and specialized calibration services that utilized multiple hardware and software systems most were 12 or more years old which performed essentially the same functions.
- Resolved major issues within these tolls such as user fatigue, missing documentation of transparent business processes , budget constraints, time constraints, and additional customer functional requirements
- Coordinated the data conversion and external interface efforts
- Reconstructed all necessary transparent process in writing and passed these documents regarding the old system application system design and as built architecture to the development groups
- Developed the UNIX and PL/SQL scripts to extract the old FEMS system data to the new system Calibration/Exchange Pool aka CEP data which included creation of the meta-data files, providing test, system, user QA and final conversion of data to the CEP production environment