Computer Sciences CorporationSenior Analyst
Jan. 2002 - Jan. 2009Pensacola, FLTraining and data analyst in support of the Navy Training Management and Planning System (NTMPS)
o NTMPS Lead integrator for Navy's Sea Warrior Enterprise Data Environment. Team developed human resources Operational Data Store in MS SQL Server for US Navy. Responsible for identification and scheduling of NTMPS manpower resources in support all Sea Warrior efforts, including manpower Level of Effort estimates. Involved with providing ETL (DTS/SSIS), database design and data back-end services. Work with application customers on data encryption for sensitive Personal and Privacy Act data. Also, manage SQL Server database and replication process for afloat use, including developing analysis reports. Work with customers to develop business process diagrams and supporting data requirements.
o Project leader for Navy balanced scorecard/dashboards development project. Project and technical lead for team of 5 Cognos developers and administrators involved with developing web based metrics for executive level managers and headquarters staffs. Worked with Navy management to provide metrics and dashboards, including identification of new data sources, integration into current data warehouse, multi-dimensional OLAP data cube design and development, geospatial reporting, developing user account management process, and design and development of reports, visualizations and metrics using the Cognos suite of applications.
o Designed, developed and maintained Naval Reserve Manpower, Personnel and Training Oracle datamart, including Cognos Impromptu reports. Developed series of reports to calculate travel distance of drilling reserves to Reserve Center.