GCSS-AF
April 2007 – April 2010 — DoD Secret Clearance
The following are projects accomplished for the USAF Global Combat Support System (GCSS-AF) for the Prime Contractor, Lockheed Martin, while working for Qbase.
Served as Tech Lead/Lead Programmer for the SNTUID (Serial Number Tracking/Unique Identification of tangible items) project for the Air Force Materiel Command. This project was the interface between the machine used to mark parts with a unique identifier and the DoD UID Authority. Led meetings with the customer to manage the project and was the lead Data Architect/Modeler, DBA and ETL programmer on a web-based application and a SQL Server database using SSIS.
Acted as Lead ETL Programmer for the BOBJ Metrics project for Lockheed Martin on behalf of the Air Force. Created ETL using Informatica 7.1 pulling in Oracle 10g Business Objects Repository data regarding usage of the various reports in the Data Services framework and outputting an xml document transmitted by SFTP to the customer on a daily basis. Authored all documentation according to GCSS-AF standards.
Lead Sys Admin and Programmer – Predictive Analysis Pilot (SAS) for the Logistics Directorate (USAF/A4). Worked with SAS sales and support to install and configure SAS. Worked with SAS consultants to construct mathematical models then led the presentation to the GCSS-AF Data Services PMO.
Lead ETL Programmer – Informatica Upgrade/Coding Standards effort for the GCSS-AF Data Services/Operations and Sustainment. Piloted a project converting Informatica 7.1 workflows to Informatica 8.1, and revise coding standards to translate Teradata BTEQ scripts to Informatica mappings.
Lead Architect and Tech Writer for the GCSS-AF Data Services/PMO. This effort published standards documentation on the web application for the GCSS-AF. Standards documents were received from the Operations and Sustainment group, and uploaded to the existing (but empty) library area of the web application. Also produced were hierarchical maps of hyperlinks that simplified finding the appropriate standards for any of the tools used by Data Services.
Lead Business Objects Developer – ACES (Automated Civil Engineering) Housing Management/Project Management BOBJ Rework for the USAF/A7. Inherited a project completed by another consulting group to Lockheed Martin that was released from the project. Tasked with handling the PM side which required modifications to the universe to fit the existing Teradata structure and ERwin data model on the Data Services side and 30 revised reports. Identified serious flaws in the ETL delivered by the previous developers, resulting in continuing work for the customer to layer on the needed changes in a future project. Instrumental in defining the project plan/engineering requirements for the future work on ACES HM/PM.Lead Business Objects Developer – ACES Real Property Data Services application for the USAF/A7. Worked with a data modeler and an ETL developer to receive and load ACES Real Property data into Data Services EDW and create Web Intelligence reports for the customer. Created Teradata views to support the ad hoc reporting capabilities, as well as developed Webi reports. Authored all project documentation.
Lead Teradata DBA and ETL Developer- ACES PM MILCON application for the USAF/A7. Worked on the Teradata side to create data structures and views to support a calculation-intensive report used by the Pentagon to structure the Presidential Budget. Created 17 views to support the complex report and optimize performance for an application that held more than 50 calculation operations.
Lead ETL and Reports Architect/Programmer – ACES HM Re-engineering (Performance Optimization) for the USAF/A7. Served as the only developer for all segments of the work (Teradata DBA, Informatica, Business Objects). Redesigned data structures and views which were accessed by the Business Objects HM application to mitigate the poorly performing HM reports previously undertaken in the original ACES HM project. Created Informatica workflows and denormalized tables to support the Unaccompanied Housing and Military Familly Housing reports which were timing out before results could be displayed. Revised ACES HM Universe to remove old, poorly performing Business Objects derived tables and replacing with a more efficient strategy, cutting display time down to 21 seconds. Created underlying data structures optimized to support a set of calculations based on the time period entered by the user (because of this, no calculations could occur until the user specified the dates, but the strategy compiled denormalized data in such a way to streamline the work done in the Business Objects layer).
Lead Teradata DBA/Business Objects Developer – ACES PM FIM (Facility Investment Metric) application for the USAF/A7. Created Teradata views and reworked the ACES PM Universe and reports to mimic the results formerly delivered from an Access database. Deconstructed processes in the Access database and refined logic on the Data Services side to replicate all the features and reports. Constructed automated comparisons of output between the two systems.