Webinar: Empowering Sustainment Through the Use of a Multi-schema Database Structure by Department of Homeland Security/OCFO

About This Webinar

Enterprise Visibility and Management of Operating and Support Costs (EVAMOSC) is an unclassified, AWS GovCloud based database developed by the Office of the Secretary of Defense – Cost Assessment & Program Evaluation (OSD CAPE). EVAMOSC is DoD’s authoritative system for accessing operating and support (O&S) cost data for major weapon systems. EVAMOSC ingests and normalizes terabytes of data from each of the military services and many source data systems. Since each service and source system utilize different data naming conventions, table structures, and collection methods, EVAMOSC implements various normalization techniques and business rules as well as a common taxonomy in order to ensure cost comparison accuracy when commingling data from multiple services and source data systems.
In this presentation, EVAMOSC team members will discuss IT and DoD-centric challenges it has faced when developing EVAMOSC and how it has overcome those challenges to develop a multi-schema database architecture which:
1) Ensures users have visibility into EVAMOSC’s normalization/business rules.
2) Allow users to access data both in the common taxonomy developed by EVAMOSC as well as utilize the taxonomy from the source data system(s).
3) Leverages serial data schemas (a best practice in database management) to enable multiple levels of data aggregation and transformation to meet numerous use cases across a diverse user base.
4) Provides transparency, auditability, and updateability via a tiered serial data schema.

Presenters

Daniel Germony

Operations Research Analyst

Daniel Germony is an Operations Research Analyst with 13 years of experience working in the Department of Defense (DoD). Currently, Mr. Germony works in the Office of Secretary of Defense (OSD) – Cost Assessment Program Evaluation (CAPE) Office as the lead for Operations & Support (O&S) data transformation in support of CAPE’s Enterprise Visibility and Management of Operating and Support Costs (EVAMOSC) system. Mr. Germony is also leading CAPE’s efforts to improve access to data science tools and methods for DoD’s cost community and is heavily involved in the policy development and execution of cost data collection efforts. Before working at CAPE, Mr. Germony was the Senior Data Scientist at US Army TACOM’s Cost & System Analysis Office where he oversaw development of advanced cost analysis tools and trained new analysis on data analysis best practices. Mr. Germony has a Masters in Cost Estimating and Analysis from the Naval Postgraduate School and a Bachelor’s degree in Economics from the University of Michigan.

LTC Daniel Summers

Daniel Summers is an Army Officer with 10 years of operations research experience. Dan has a master’s degree in Operations Research from the Air Force Institute of Technology and a bachelor’s degree from the United States Military Academy at West Point.