Summary

Nearly 20 years of comprehensive application experience including system analysis, design, implementation/development and administration. This includes custom ground up solutions as well as legacy migration of OLTP and Data Warehouse systems using Waterfall and Agile methodologies and custom manual ETL processes.

Technologies

Oracle 6 through 11g, SQL Plus, PL/SQL, SQL Developer, SQL Loader, Data pump, Import / Export, TOAD, Oracle Forms/Reports 3.0-10g, Oracle Application Express 4.1, Windows 3.x-7, Redhat Linux, Various ERD tools

Professional Experience

Confidential

Work with Business Analysts to design and implement Exceptional Family Member Data Repository for Department of Defense Office of Special Needs using Oracle Database 11g and Oracle Application Express 4.1. This includes schema and application design and implementation and heavy use of PL/SQL stored packages procedures and functions as well as pipelined functions.

Confidential

Work with Business Analysts and Java Developers to design, build and populate a database driven web application system to consolidate various legacy General Services Administration client server and web application systems using Oracle database 10g and 11g in a VM Ware hosted database environment.

Confidential

Provide database schema structural data model enhancements as requested by front-end developers in support of FMS front end. Optimize PL/SQL stored procedures as needed for performance enhancements in Oracle 11g. Initiate and implement structural changes to schema objects to optimize object storage. Migrate MS Access database data to individual Oracle Schemas. Write server side PL/SQL functions to assist in data validation and/or code creation. Write SQL, PL/SQL utility scripts to change schema referential and check constraints to naming standards.

Confidential

Debug, enhance and create various Oracle Forms and Reports as well as some schema data model improvements in support of shipbuilding and maintenance. Build server side PL/SQL functions and procedures to automate manual tasks.

Confidential

Assisted in creation of various ad hoc queries SQL, PL/SQL procedures, etc. Designed and implemented historical warehouse data model from Hyperion Hierarchy Database, OLTP system and populated Warehouse through extensive PL/SQL scripts, functions, procedures and packages. Performed manual ETL process via custom PL/SQL routines.

Confidential

Debugged existing Applications using PL/SQL and Oracle Forms. Designed and built data model / migrated custom asset tracking system. Wrote Various custom batch processes with SQL Plus, PL/SQL, and Bash shell scripting.

Confidential

Assist in repair and setup and maintenance of Mac and Linux based machines. Assist in design and maintenance of various Travel related website, mostly shell scripting, basic html, MySQL

Confidential

• Maintained 12 Oracle 9.2 commercial databases on Sun Solaris server. Implemented and maintained Data guard / Standby servers on 9i. Wrote cron jobs and shell scripts for daily monitoring tasks, export processes, archive log compression and tar. Developed data access queries/programs using PL/SQL Query to run in production on a regular basis and assists end users with development of complex ad hoc queries and analyses filled in for production DBA as required. Applied security patches as required
• Wrote and tested database build and migration scripts to migrate databases to Oracle 10g on Redhat Linux AS 4.

Confidential

• Determined business rules on which to base new database design. Designed new database schema including data model. Migrated data from M204 system/390 to Oracle schema via SQL Loader and PL/SQL scripts approximately: 20,000 lines to perform manual ETL process via custom PL/SQL routines. data type validation, referential integrity validation, data cleansing and population of new schema with SQL Plus, PL/SQL server side procedures, functions, triggers and packages.
• 18 files from the mainframe became about 140 normalized tables. Tuned servers at file system, architecture and schema levels and assisted development staff with tuning Oracle Forms, Reports and queries. Implemented 3 way Multi-Master Replication between two Washington DC sites and New York City.

Confidential

Performed extensive redesign of existing warehouse including data model and performed migration and population via manual ETL processes via custom PL/SQL routines. of new schema through extensive use PL/SQL. New schema design was flexible enough to allow data driven changes to incorporate new data facts and statistics into warehouse without the need for altering the data dictionary.

Confidential

• Maintenance and make significant redesigns/improvements to custom application front end called Multi
• Segment PVC Engineering Tool schema and GUI with Developer/2000, extensive use/reuse of PL/SQL
• libraries as well as stored procedures and triggers.

Confidential

Reverse engineered and re-implemented custom RSPM System Repair Station Performance Monitoring System using Oracle server, Developer 2000, PL/SQL and extensive reports. This was a relatively simple system used by the company to collect data on the efficiency of their various aircraft repair stations located throughout the United States however the reporting metrics were somewhat involved. System was previously built in Microsoft Visual Fox Pro.

Confidential

• Responsibilities included the maintenance and change management of general aviation airport database and interface in Oracle Server 6 and Oracle Forms 3.0.
• Wrote typeset program, which consists of about 10,000 lines of PL/SQL code and database procedures that embed typeset tags to feed a Macintosh system for publication of the annual Aviation USA Airport Directory, and CD ROM. Re-Designed the legacy general aviation airport database and implemented the design through the use of PL/SQL with database sequences, triggers and integrity constraints to take advantage of the new features of Oracle 7.3 Performed manual ETL process via custom PL/SQL routines to migrate to new schema. Implemented user interface of new airport database schema in Oracle Forms/Reports. Performed Basic DBA tasks as related to application development.

Confidential

Workstation Developer

Responsibilities included maintenance and support of user staff over 300 users with data and system problems with Oracle Server 7.3 database mounted on IBM R/S 6000 with Macintosh Clients and more specifically: Wrote several reports in SQL Plus for users to run interactively from their own desktops.

Wrote scripts to populate database tables with credit card terminal application data.