Projects
Current and Past Performance
Defense Contract Management Agency (DCMA)
- Database and ETL design and development
- Main contributor and designer of DCMA's new etools Enterprise Integrated Tool Set (EITS), an
over arching framework to tie together all data collected by the 106 transactional web-apps to
provide a holistic contract life-cycle view - Project Management, Integration, and Development leads on DCMA's enterprise SharePoint collaboration environment. Responsibilities include managing the standardization and migration of legacy documentation, development and training of end user capabilities and the design, development, migration and deployment from existing SharePoint 2010 platform to SharePoint 2016 enterprise stack.
Defense Health Services System (DHSS)
- Database and ETL design and development.
- Responsible for maintaining code and insuring availability 24 hours a day 7 days a week of
the Electronic Surveillance System for the Early Notification of Community-based Epidemics
(ESSENCE) - Provided ETL and Database support for the Clinical Data Mart (CDM) that loaded 20GB of flat
files per cycle, 3 times a week to a 2TB database while maintaining 24/7 uptime for reporting
needs
VBA Enterprise Data Warehouse (EDW) – Office of Performance Analysis & Integrity (PA&I)
The Office of Performance Analysis and Integrity (PA&I) manages and enhances the Veterans Benefits Administration (VBA) Enterprise Data Warehouse (EDW).
Established in 1997, the EDW is the source for all data and information about Veterans benefits data. It contains relevant data from each of VBA’s transactional systems
and arrays the data in a variety of business intelligence reporting for executive managers, business lines and claims processing teams in VBA’s 57 Regional Offices.
EDW data is used for fraud detection and prevention, financial auditing and reports to Congress; it is the source for all legal reporting requirements, to include
the Government Performance Accounting Act, the American Recovery and Reinvestment Act and the Federal Funding Accountability and Transparency Act of 2006.
Argus Solutions has supported the EDW in all facets of its redesign, continuous maintenance and delivery of new data offerings. Argus Solutions’ key services for the EDW include:
- Data Architecture.
- Data Modeling
- Metadata Management
- Data Integration
- SAS Analytics
- Business Intelligence in OBIEE and Tableau
- Operations & Maintenance DBA
Health Data Product Enhancements (HDPE) – Clinical Case Registry (CCR) Traumatic Brain Injury (TBI) Registry
The VHA Health Registries Program supports the population-specific data needs of the enterprise. Health registries are a critical component to population surveillance. The Traumatic Brain Injury (TBI) and Clinical Case Registry (CCR) were established to provide population-specific patient data required to ensure that quality health care services continues to be delivered in a timely manner.
The Traumatic Brain Injury Registry application supports the maintenance of local and national registries for clinical and resource tracking of care for such Veterans through a comprehensive evaluation questionnaires (initial and follow up) designed to provide rehabilitation professionals with a vehicle by which they can assess patients and collect clinical outcome information. The information collected from these instruments is electronically transferred and stored in the form of a medical progress note in the patient's electronic record. This progress note can be retrieved through the Computerized Patient Record System (CPRS).
Argus Solutions’ key services for the TBI / CCR Registries include:
- SQL Server Database Architecture
- Database Administration DBA
- .NET Development
- SQL Server Reporting Services (SSRS) Report Development
Energy Information Administration (EIA)
- Data Integration
- System Integration
- B2G Data Exchange
- Meta Data Management
- Full Business Intelligence Solution
- Report Development
- Ad Hoc Analytic Development
- Dashboard Development
Department of Justice (DoJ)
- Data migration
ECS Limited
- Enterprise IT Infrastructure Support
United States Postal Service (USPS)
- ETL Design and Development
- Provide Informatica coding and design expertise for a real-time system using web-services, message
queuing, and flat file as sources to write to a 2+ billion record database target
- Provide Informatica coding and design expertise for a real-time system using web-services, message
