Systems Engineering Software Development

SUMMARY

I am Senior Engineering Professional with 35+ years of systems engineering, database development and support, system testing, software development, and hardware support, with 20 years on Air Traffic Modernization programs (AIMMs2, RMLS, TFMS & TFDM). I am proficient in many software languages, enough so to perform analysis and modifications to existing code, especially where the applications connect to Oracle to manipulate data and/or call stored database procedures.

Highlights include:

Oracle 12c & 19c Database Development, Administration, & Support on Linux OS

SQL, Oracle PL/SQL database development (packages and dynamic sql)

Data Warehouses and Data Marts

ETL of data into database tables

Requirements Engineering

System Integration & Testing

Analysis, Development, Documentation, Design & Testing

Agile Development

Software Configuration Management Tools (GIT, IBM ClearCase, IBM RTC)

SharePoint Document Control & Administration

Operational Installation & Support

Hardware Support & Maintenance

CIS-CAT security benchmarking

Microsoft Office: MS Word, PowerPoint, Project, Excel

Linux User Administration

Mentoring & acclimating new team members to the environments

US Citizen with Public Trust Clearance (FAA)

PROFESSIONAL EXPERIENCE

EES, llc / Peraton Corp / FAA 10/2021-Current

Hammonton, NJ 08037

Senior Oracle Engineer

Providing Systems Engineering, Development, Oracle Database, and Systems Administration support on the FAA AIMMs2 (Aeronautical Information Management Modernization Segment 2) contract.

Oracle 12c& 19c Database performance & error analysis, schema verification, development, requirements testing and verification, general software & database support, CIS-CAT security benchmarking, development of Operational installation documentation, QLIK Talend ETL to load AIXM xml (NOTAMS, Special Activity Airspace (SAA) definitions, SAA schedules, airport data, and other NAS infrastructure data) into a single source database, work directly with the FAA on testing, installation & troubleshooting.

DTIS, llc / FAA 09/2018-10/2021

Washington DC, 20024

Senior Systems Engineer

Provided Systems Engineering and Hardware support on the FAA TFDM (Terminal Flight Data Manager) contract.

Oracle 12c on Linux servers, hardware & software support, test & operational installation at Air Traffic Control Towers & TRACONs, preparation & test of technical documentation, preparation & test of troubleshooting flow charts used for operational support, review & validation of system requirement test procedures.

Arctic Slope (ASRC) Federal Holdings / FAA 07/2017-06/2018

Egg Harbor Township, NJ 08234

Senior Systems Engineer

Provided systems engineering support on the FAA Remote Monitoring and Logging Systems (RMLS) contract.

Developed requirements, interfaced with customers & developers to establish technical expectations and customer needs, interfaced with the test team to establish & verify tests procedures, organized & controled the technical versions of maintenance equipment manuals.

BASE-2, Inc / FAA 07/2005-04/2017

Egg Harbor Township, NJ 08234

Senior Database Engineer

Support for the systems under the FAA Traffic Flow Management & Modernization (TFMM) contract, which includes Traffic Flow Management System (TFMS), National Traffic Management Log (NTML), Operational Information System (OIS), Operational Network System (OPSNET), Playbook (predefined severe weather routes), and Enhanced Traffic Management System (ETMS).

Lead Database Developer, responsible for Oracle database requirements design & development using SQL & PL/SQL, system and database validation & testing, Operational installation and support for all applications under the TFMM contract.

Lead Data Warehouse Developer, responsible for requirements, design, documentation, development, maintenance, primary operational support, trainer, primary contact for FAA Analysts using the TFM Data Warehouse.

Burlington Coat Factory 07/2004-07/2005

Burlington, NJ 08016

Sr. Software Analyst / Developer

Project lead, development, testing, & maintenance of software and database systems for large retail business. Responsible for the development of data security protocols for sensitive information, administration & development of user friendly auditing reports (Navistor), reporting, analysis, and user support on the Navistor database schema, SQL tuning and support of a large Data Mart.

Informatica of America Inc. - TMA / KenRob and Associates Inc. / FAA 04/2001-06/2003

Absecon, NJ 08201 / Leesburg, VA 20176

Computer Scientist

Backup DBA and Developer. Developed an Oracle database and applications to support the Federal Air Marshals after 9/11, Oracle 9i Database development & support, ETL of legacy data into Oracle RDBMS using Oracle Workbench.

Atlanticare Health System–InfoShare

Egg Harbor Township, NJ 08234

Programmer Analyst

DBA and Developer, Oracle Database design & maintenance, application design & development.

KenRob and Associates Inc / FAA

Leesburg, VA 20176

Senior Computer Programmer Analyst

Developed and maintained enterprise databases and applications using Oracle Database, Power Builder, PL/SQL, SQL, MS Access and VB.

Southern Ocean County Hospital

Manahawkin, NJ 08050

Lead Developer

DBA & developer supporting applications that the hospital staff required to for patient care and administration. Developed and maintained database and applications on Oracle Database, with Forms, Reports, Delrina FormFlow, and Crystal Reports.

Unisys Corporation / United States Coast Guard

Mc Lean, VA 22101

Systems Analyst

DBA & developer responsible for Installs, upgrades, and administration of Oracle Database and development tools on HP Unix platform. Developed, maintained and administered Oracle Databases and applications with Forms, Reports.

Blue Cross-Blue Shield

Philadelphia, Philadelphia, PA 19103

Systems Analyst

Responsible for the major claims processing system at IBC in Cobol and CICS on an IBM mainframe. Worked heavily with the user community, analyzing, designing and coding complete batch and online systems.

EDUCATION/TRAINING

College: Bachelor of Science in Computer Programming and Biology, Juniata College

Huntingdon, PA 16652

Oracle Education: Oracle Database 10g: Security, SQL Tuning, Administer the Oracle7 Database I, Develop Applications with Oracle Forms I (V4), Develop Applications with Oracle Forms II (V4), Develop Reports with Oracle Reports I (V2), Designer/2000 - Designing and Building Applications, Oracle Discoverer 3.1 End User and Administration, Oracle Applications Server Administration.

Atlantic Cape Community College: Java Programming, programming in "C" and "RPG III”, Data Structures using "C", Using The AS400, Mays Landing, NJ, 08330

Contact this candidate