Information Engineer/Data Warehouse Design Consultant — Ramsey Consulting, Inc./CACI, Inc. — Fairborn, OH

GCSS-AF/Keystone Decision Support System

2004 – 2006 — DoD NAC

This began as a contract-to-hire position through Ramsey Consulting in Dayton, OH for 6 months, and was continued as a direct hire to CACI.  The Keystone Decision Support System (KDSS) is the business intelligence platform delivered through the Global Combat Support System (GCSS-AF), supporting analysis for the Air Force Working Capital Fund.

Responsible for designing enhancements to the Keystone Decision Support System based on customer (Air Force) requirements, including the creation of an ER diagrams and DDL to build the Oracle environment and populate static tables, as well as defining objects formulae and definitions.

Lead ETL developer for two enhancements to the KDSS.

Coordinated data analysis during design for the functional team while acting as a technical advisor to the technical team during data analysis for design and test phases.

Piloted the first detailed and comprehensive technical documentation used by the project.

Drove a team-wide definition and documentation of process change from a “waterfall” approach to a project team iterative development process orientation.