IT Analyst — Collabera/Nationwide Financial Services — Columbus, OH

October 2011 – February 2012

Senior Business Requirements Data Analyst for the Investments Controllership and Accounting teams at Nationwide.  Assessed requirements and feasibility studies for projects using Informatica, Oracle 11g and Netezza in an Agile Methodology environment.  Skills include SQL (Oracle and Netezza), Business Objects, Informatica.

Senior Systems Engineer — Evanhoe & Associates — Dayton, OH

GCSS-AF/Global Force Management Data Initiative

April, 2010 – September, 2011  — DoD Secret Clearance

Senior Systems Engineer and Informatica developer on Global Force Management Data Initiative (GFM-DI) overseen by the Vice Chairman of the Joint Chiefs of Staff.  The project involves concurrent facilitation of force structure data sharing, ensuring unique information exchanges between enterprise systems on the Global Information Grid (GIG) and mitigating data collision issues across the DoD Enterprise.  Skills include Teradata, Oracle and ERwin.

Proactively suggested creating a separate integration test strategy and environment for the most recent release slated for August 2011. This resulted in the creation of a separate testing environment and expanded duties to run weekly installation tests and report results to the PMO.

Proactively researched and provided objective evidence to the Evanhoe & Associates leaders to demonstrate that the GFM-DI project conforms to most of the CMMI Level 3 requirements.  This resulted in assignment to organize a focus group across the business to do a preliminary gap analysis with a SCAMPI C planned for the fall of 2011.

Senior Systems Engineer – Qbase/Lockheed Martin — Beavercreek, OH

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.

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.

Senior Technical Lead — Anthem — Cincinnati, OH

October, 1998 – February, 2003

Served as a project manager and technical team advisor for several large outbound eligibility data interface projects (as many as 27 sub-projects/teams) and most recently was project manager for a data quality project for data to vendors and internal data warehouse.

Accountable for leading a team of Programmer/Business Analysts responsible for the design, development, implementation, and support of Health Insurance Actuarial and Decision Support applications.

Utilized formal Project Management and SDLC Methodologies (i.e., ABT Project Work Bench and Anthem’s Application Development Methodology) and ClearCase for version management

Designed and developed Decision Support/Data Warehouse components.

Managed 2 small teams of developers during the build cycle, delivering code, and documentation while participating on the infrastructure team which defined/implemented new standard processes and maintained in-house software utilities.

Maintained and enhanced a test scripting (in-house) VBA utility and provided training and documentation while on infrastructure team.

Worked as a VB programmer on the CoMPLi project to automate documents processing for health insurance certificates.

Sr. Research Associate — Procter & Gamble — Cincinnati, OH

September, 1994 – December, 1997

Project Manager (1995 – 1997)

Managed the enhancement and maintenance of an automated Tables Generation project, including periodic roll-out, training and user support.  Project was migrated from DECVAX to HP9000, and upgraded from Visual Basic 3.0 to version 6.0.

Collaborated with project managers from Medical Surveillance and Clinical Data Management on the Data Standards Review Board to determine and deliver useful tables and monitor data standards and database modeling.

Clinical Data Manager (1994 – 1995)

Responsible for clinical data management for 7 studies adhering to Good Clinical Practices for the OTC/Oral Care focus area, including on-and off-site support and training for direct data entry systems.

Projects included implementing code for new duties assumed by data management operations to provide summary datasets for biostatistical operations.  This required an active role in the development of standard processes to facilitate the acceptance of these systems, with emphasis on meeting cycle times.

 

Project Manager/System Architect — Lasley & Hopkins, Inc. — Cincinnati, OH

January, 1993 – March, 1994

Responsible for designing/developing various applications, such as Production Line Staffing and Retail Sales Tracking for a Fortune 25 company.

Designed, analyzed, programmed and tested applications using SAS (PC and Mainframe), JCL and Macintosh’s 4th Dimension, in an Apple Macintosh workstation, Novell, Ethernet network environment and in a IBM S/370, MVS/TSO, ISPF mainframe environment.

Statistician/Data Analyst/System Architect — Wright State University School of Medicine– Dayton, OH

August, 1989 – December, 1993

WSU School of Medicine —  Fels Institute

Designed and developed SAS Biostatistics and lifestyle healthcare applications for Fels Institute which provides clinical human growth and development studies for various health care institutes and providers internationally.

Designed, analyzed, programmed, and tested database applications, as well as utilized various SAS statistical functions to conduct statistical analysis and regression.

Created library of SAS reporting functions and macros to develop flexible reporting.