Missionary Data Warehouse

Sr BI Architect

Engaged in BI data warehouse projects for the missionary department utilizing Tableau, Python, SAP Data Services, SAP Business Objects, Oracle and Amazon Cloud Services (AWS) Redshift to create analytics, reports and dashboards.


Operational Data Store (ODS)

Sr Healthcare Solutions Architect

Architect of an operational data store for a healthcare insurance company client utilizing Amazon Cloud Services (AWS). Mapped data from multiple disparate sources to be homogenized into a single repository for reporting and analytics.

  • Maintained ODS and Data Warehouse model in ER/Studio.
  • Guided ETL developers, performed data profiling and various QA validations.

HC Standard

Sr Data Architect

Primary data architect for flagship application, HC Standard™ that supports information sharing between healthcare workers, providers, and first responders, primarily in crisis situations and mass casualty events. Improved and streamlined system to ensure flexibility for continued growth.

  • Optimized database architecture and processing procedures to improve information sharing and response time.
  • Reduced database query time and report generation an average of 98%.

Clinical Quality Measures for Registeries

Sr Data Architect

Designed data model, processes, and procedures to perform Critical Quality Measures against data from disease, surgery, and other healthcare registries. Collaborated and provided strategic advice in converting registry specific survey responses to usable clinical data for other measures.

  • Reduced volume of data used in processing by 66% and reduced overall processing time by 75%.
  • Created enhancements and features for CoreANALYTICS™ tool to better track health analytics.

Healthcare Analytics

Sr BI Solutions Architect

Designed high-level concept technical solutions to replace aging data systems. Developed and implemented common data solutions for multiple departments and functions. Oversaw identification, prevention, and recovery from incorrect or fraudulent billing practices. Managed multi-million dollar projects to integrate systems across multiple business divisions within common data solution. Managed project costs effectively to ensure utility and efficiency.

  • Reduced analytics execution time an average of 75%.
  • Designed process that reduced documentation management time by an average of 30 minutes per document.

CoreANALYTICS™

Sr Data Architect

Lead Architect and designer of industry’s first dynamic measure calculation engine within CoreANALYTICS™. Designed engine concept, database schema, XML measure specification, measure compiler, and the measure editor. The measure specification allowed non-programmers to create measure definitions, compile and execute them. Led development team to implement appropriate algorithms, compiler and stored procedures on database implementations including SQL Server and IBM Netezza. Worked with validation team to verify results.

  • Reduced measure development time by 85%.
  • Measure calculation engine replaced a manual process which required 6-months to enable daily calculations.
  • Allowed hospitals to report measure results to meet CMS requirements and receive incentive payments.

Quality Health First®

Sr Data Architect

Lead Architect and Development Manager for Quality Health First® program. Project involved collection, management and aggregation of large amounts of clinical and claims data from multiple sources. Measures based upon HEDIS and AMA for preventative screenings were used to reduce health care costs and to improve overall patient health care. Designed the architecture and developed complex logic. Defined standards for development and documentation. Participated in the Measures Committee consisted of physicians, nurses, and administrators.

  • Oversaw development that allowed participating providers to receive incentive payments.
  • System calculated 40 measures for 250,000 patients in 45 minutes which was a significant improvement over the alternative system that calculated 40 measures for 75,000 patients in 8 hours.