Software/Database/Data Engineer, SQL, C#, HL7/FHIR

Scott E. Tilson

***** ******** **. • Overland Park, KS 66210 • 913-***-**** • *****.******@*****.*** Overview

Experienced Software/Database/Data Engineer with a demonstrated history of working with data analytics and reporting, extract/data warehousing, SMART on FHIR development, and DoD/VA federal consulting in the healthcare information technology industry. Technically skilled in Python, Oracle SQL, Oracle SQL Developer, MS SQL Server, MS SQL Server Management Studio, Performance Tuning Queries/Stored Procedures, C#, ASP.NET, SMART on FHIR, HL7 processing, Cerner Millennium EHR, Cerner Command Language (CCL), Informatica, and SAP Business Objects. Process skilled in Azure DevOps, JIRA, Agile development, federal consulting, and project management. Professional Education

Master of Science, Engineering Management, 2020

Graduate Certificate, Cybersecurity, 2020

Bachelor of Science, Computer Engineering, 2015

Work Experience

IBM (Octo, LLC)September 2023 – May 2025

Data Engineer

Technical Stack: SQL, Oracle SQL Developer, TOAD, Health Level 7 (HL7), Python, JAVA, Excel, Claims Management System

(CMS), Centralized Mail Portal (CMP), Veterans’ Benefits Management System (VBMS), GovernmentCIO (GCIO) VA VICCS

Analyze and process requests and responses for private medical records regarding VA Disability Claims using the CMS, CMP, VBMS, GCIO systems

Identify enhancements and defects through reports and Excel data analysis to facilitate the processing of slow-moving requests and responses

VA Health Data Repository

Analyze HL7 messages and data to identify inconsistencies in the Cerner modernization effort regarding veterans’ medications, allergies, and lab tests with results

Query using TOAD for Oracle and compare data and data models against three separate systems: Vista, Health Data Repository, Cerner

Propose and implement solutions to maintain data consistency, integrity, and interoperability across both Cerner and Vista systems

Precision Value & Health September 2021 – September 2023 Software Engineer / Team Lead

Technical Stack: C# (ASP.NET 5.0), JavaScript, MS SQL Server/MS SQL Server Management Studio Research and Development

Design SMART on FHIR web-based applications for EHR integration with Epic MyChart, Cerner Millennium, and IKnowMed for the facilitation of patient financial assistance related to high-cost medications

Designed Continuous Integration/Continuous Deployment (CI/CD) structure in Azure DevOps including repositories, build pipelines, test pipelines, release pipelines, and web-integration Oracle (Cerner), Kansas City, MO May 2014 – September 2021 Senior Software Engineer

Technical Stack: Cerner Command Language (CCL), Oracle SQL/Oracle SQL Developer, Shell, Python, Ruby, JQuery, CSS, HTML, C++, Visual Basic, C#, XAML, JAVA, Informatica, SAP Business Object, Microsoft Visual Studio Federal Consulting

Consult for the DoD and VA providing specialty solutions within the Millennium solution set to meet business needs including custom reports based on Millennium data models and Cerner Command Language (CCL)

Assist in the extract, transform, and load of DoD and VA data from Vista into the Millennium data models

Maintain required security clearances (Public Trust) for live production access and modification in DOD and VA systems Engineering

Design and build analytic scripting to produce reports on healthcare data for private and public entities

Design Python scripting to automate development of code based on structured requirements

Maintain and update extract, transform, and load processes for 280+ health systems including VA and DOD

Contact this candidate