DITC - Consultants_2023_Resume 30-23181-DSOHF
1 of 6
SUMMARY
Experienced IT professionals with 30+ years overall and 10+ years of consulting
experience. Successfully completed multiple IT projects (onsite and remote) in roles such
as Sr. IT Consultant, Sr. Data Analyst and Sr. Data Engineer/Architect. Produced data
models and adaptive analytics delivered to executives to help drive meaningful use &
decision support.
▪ Platforms: Epic: Ambulatory, Hyperdrive/Hyperspace, Data Courier, Reporting
Workbench, Clarity; Cerner: PowerChart, HealtheIntent, CCL/DA2/DvDev
▪ Technical Experience: ServiceNow ITBM and ITSM modules
Big Data Technologies Azure Synapse, HDFS, Hive, Hue, MapReduce, Pig, Hadoop,
and Hbase, Spark, Kafka.
Programming languages C++C#, Java/JavaScript, Python
Databases MySQL, MS-SQL Server 20012/16, Oracle, Teradata
No SQL Mongo DB, Cassandra, HBase
Scripting/Web Languages HTML5, CSS3, XML, SQL, Shell/Unix, Perl, Python.
Operating Systems Linux, Windows XP/7/8/10, Mac.
Software Life Cycle SDLC, Waterfall and Agile models.
Utilities/Tools Git/GitHub/GitKraken, Confluence, Eclipse, Tomcat,
PUTTY, MIRTH, Rhapsody, NetBeans, SQL, Maven, Visio,
Visual Studio Code, JIRA, DevOps
Data Visualization Cognos, Crystal, Power BI, Tableau, TOAD, SSRS
Cloud Services AWS (EC2, S3, EMR, RDS, Lambda, CloudWatch, Auto
Scaling, Redshift, Cloud Formation), Azure(Databricks, Data
Lake, HDInsight), Google Cloud Platform (GCP).
EXPERIENCE
DIRECT IT CONSULTING, LLC
Sr. Integration/Data Engineer – Consultant (October 2013 to Current)
▪ Conducted QA testing of raw and refined data imported with ITIL scripts
▪ Scripted source to target mapping (STTM) for HL7 FHIR interoperability
▪ Analyzed data validation for segment mapping of FHIR USCDI Core Resources
▪ Utilized Google Cloud Platform (GCP) of cloned repository for reviewing and
editing of XML code within Visual Studio Code.
▪ Executed advanced SQL queries utilizing SQL Spark and Hive for data mining.
▪ Wrote test plans and test cases for unit and integration testing
▪ Worked on FHIR Resource mapping in coordination with Redox for API
development of data set ingestion and integration
INDUSTRY EXPERIENCE
▪ 25+ years in Info Technology
▪ 10+ years of report writing
▪ 8+ years of analytics experience
▪ 5+ years integration experience
EHR PLATFORM EXPERIENCE
▪ Allscripts
▪ Cerner
▪ Epic
▪ McKesson
▪ Meditech
▪ eClinical Works
▪ Sunquest
MODULES/TOOLS
▪ Ambulatory
▪ Hyperspace
▪ Hyperdrive
▪ Beaker
▪ Data Courier
▪ Clarity
▪ Crystal
▪ Cognos
▪ Tableau
▪ Care Everywhere
▪ Community Connect
▪ Reporting Workbench
▪ MIRTH
▪ Rhapsody
▪ Hadoop
ORGANIZATIONS
▪ Highmark
▪ BayCare
▪ DaVita
▪ St. Barnabas
▪ Catholic Health
▪ Stanford Health
▪ Sutter Health
▪ Ardent Health Services
▪ Honor Health
▪ Peace Healthcare
▪ Community Health Systems
▪ University of Utah Healthcare
2 of 6
▪ Utilized Azure DevOps for HL7 interface services, analytics, API and other development projects
▪ Managed JIRA stories and tasks for Care Quality and Epic Payer Platform
▪ Managed roles for DWaaS on OptumCareData Platform for member data management in-cloud and on prem.
▪ Scripted source to target mapping (STTM) for HL7 FHIR interoperability
▪ Data validation of patient attribution files determining threshold for proper data flow to POC, DEV, STG and PRD
environments.
▪ Executed SQL queries utilizing TeraData SQL Assistant and SNOWFLAKE and DATABRICKS and POSTMAN with GET URLs.
▪ Managed unit tests and files with GitHUB with push and pull requests.
▪ Wrote test plans and test cases for unit and integration testing
▪ Learned and interacted with both legacy data systems and new normalized data sets hosted on Azure and utilized Synapse
for big data analytics and Power BI for discrete data dashboards.
▪ Drove the design, development, and delivery of cutting-edge features for Kafka on Confluence / Apache Kafka.
▪ Developed Power BI Reports and Dashboards of KPI measures for stakeholders.
▪ Conducted FHIR interoperability for future HL7 interoperability
▪ Wrote test plans and test cases utilizing Azure DevOps
▪ Managed unit tests and files with GitKraken
▪ Executed Python coded scripts to parse HL7 messages in Visual Studio
▪ Developed REST API, data management and model orchestration with Python
▪ Validated test data with MS SQL Server Management Studio
▪ Wrote technical specifications for user documentation
▪ Supported all aspects of Rhapsody servers (DEV, TEST and PROD).
▪ Worked closely with DBA team for performance monitoring and tuning.
▪ Monitored Rhapsody Comm Points and Rhapsody Routes, and restarted both as necessary.
▪ Created and configured new Rhapsody Comm Points and new Rhapsody Routes in support of ongoing projects.
▪ Documented, modified and streamlined existing Rhapsody Routes.
▪ Maintained and modified custom JavaScript coding that translated HL7 data as it passed through Rhapsody.
▪ Maintained and replaced security certificates on all the Rhapsody servers.
▪ Troubleshot issues with all integration systems and solutions.
▪ Utilized MIRTH Connect for client configuration and HL7 interface message handling
▪ Worked collaboratively with BI teams to identify appropriate solutions for various reporting needs.
▪ Conducted QA testing of raw and refined data imported with ITIL scripts
▪ Scripted source to target mapping (STTM) for HL7 FHIR interoperability
▪ Data validation of patient attribution files, pre-processing of ECI foundation layers, ECI Batch & Stitching and determining
threshold for proper data flow to SMILE CDR
▪ Executed advanced SQL queries utilizing TeraData SQL Assistant and Postman for GET URLs
▪ Wrote test plans and test cases for unit and integration testing
▪ Analyzed data validation for segment mapping of FHIR USCDI Core Resources
▪ Assisted with HEDIS input ingestion and FHIR conversion from ECDS for CMS-ONC mandate
▪ Worked on Preferred Drug List, Nurses Check List and Medicare and Medicaid claims.
▪ Utilized Azure DevOps for HL7 interface services, analytics, API and other development projects.
3 of 6
▪ Incorporated CCL queries for more complex data mining and analytics.
▪ DA2/CCL platform managed with backend ops jobs.
▪ Developed TJA Procedures/Hip Fracture DA2 reports which included the query and report design. These 12 reports
included pre and post op with parameters.
▪ Developed APS Procedures with OR Cases report for patients who received spinal block Duramorph by Anesthesiologists.
▪ Familiar w/data structure on the backend and clinical workflows on the front end.
▪ Maintained DA2 Scheduler for automatic report delivery throughout corporation.
▪ Developed Press Ganey (PGFusion) surveys for integrated analytics focused on patients to improve KPI’s.
▪ Mined backend data on the EDW reporting platform utilizing report tools like Tableau.
▪ Created Tableau visualizations for the data extracted and managed big data.
▪ Identified patterns and meaningful insights from data by analyzing it.
▪ Prepared data for use by Tableau and established connections to Data Sources.
▪ Performed Data Modeling in Tableau Desktop and developed workbooks and hyper extracts on Tableau Desktop.
▪ Turned data into opportunities with Power BI data visualization tools to drive better business decisions by analyzing
enterprise data for insights.
▪ Designed Power BI dashboards and managed server.
▪ Architected and documented data flows for Epic, NCA Portal and Village CMT interfaces including technical definitions, data
flow and integration formats and protocols for ingestion.
▪ Developed reports including query and report design with Discern Analytics v2.0 (DA2/CCL) for decision support.
▪ Collaborated with stakeholders on defining report parameters and deliverables as well as clinical data validation.
▪ Analyzed and maintained Cerner core service rules for PowerChart, PathNet and CoPath.
▪ Lead Salesforce interface design, development, configuration and implementation with other platforms.
▪ Conducted QA testing which included writing use cases for functional and integration testing of newly interfaced systems
including Cerner, Epic, Capella, and Salesforce applications for data migration prior to go-live.
▪ Data validation of patient attribution files writing and executing SQL queries utilizing Cerner HealtheIntent and
HealtheAnalytics for analysis of import/export.
▪ Implemented the extraction, loading, and transformation ELT of data using Oracle Data Integrator configuring the ODI
master and work repositories, ODI models, defining and organizing the ODI project including interfaces, packages,
procedures, variables, user defined functions, and knowledge modules.
▪ Worked closely with laboratory, clinicians and statisticians while monitoring Case Report Form (CRF) and Cumulative
Distribution Function (CDF).
▪ Gathered and validated business requirements and user stories and drove workshops with business SMEs and user groups.
▪ Worked with ambiguous requirements which drove collaborating with business group and made decisions on application
functionality and collaborated with business SME.
▪ Report and track Cerner Service Requests (SR).
▪ Documented technical specs and data flow diagrams in Confluence.
▪ Documented and tracked tasks in JIRA to complete technical requirements.
▪ Analyzed data validation for segment mapping data of HL7 messages for integration.
▪ Performed ADT interface functional and integrated testing of performed registrations.
▪ Created Functional Specification documents and mapping of data elements to collaborate with development and testing
teams to build a quality interoperability product using healthcare industry standards HL7 and FHIR for data gathering and
exchange of data via bi-directional interfaces.
4 of 6
▪ Created test cases for testing and signed off on their completeness and correctness.
▪ Designed forms, reports and dashboards that supported the data analysis collection efforts of customized patient record
information for studies.
▪ Evaluated EHR (Epic, Cerner, etc.) processes, uncovering areas for improvement, and implementing solutions utilizing the
SMART on FHIR API technology platform for development of healthcare applications for healthcare customers.
▪ Extraction, Transform, Load (ETL) from customer Electronic Health Record (EHR) applications into flat file (X12) format of
payer claims (835/837 and 270/271) data.
▪ Performed requirements analysis and defining solutions for automated workflow, data leverage and predictive KPI
analytics. Lead the ITIL team for ServiceNow ticket triage, reporting, troubleshooting and resolution.
▪ Gathered critical information from meetings with various stakeholders and produced useful spreadsheets, reports and
dashboards for various areas like Revenue Cycle Management, Care Management, Patient Engagement and Identity Mgmt.
▪ Lead integration of Salesforce data after design, configuration and deployment of CPQ module for decision support.
▪ Analyzed cloud based (Azure) clinical trial data to create summary statistics of performance utilizing Medidata Rave Clinical
Data Management (CDM) system. Worked closely with laboratory, clinicians and statisticians while monitoring Case Report
Form (CRF) and Cumulative Distribution Function (CDF).
▪ Developed self-running AI software to automate predictive models for recommended searches and virtual assistants.
Designed machine learning system, applied algorithm to generate accurate predictions and resolve data set problems.
▪ Gathered and validated business requirements and user stories and drove workshops with business SMEs and user groups.
▪ Worked with ambiguous requirements which drove collaborating with business group and made decisions on application
functionality and collaborated with business SME.
▪ Created Functional Specification documents and collaborate with development and testing teams to build a quality product.
▪ Reviewed test cases and sign off on their completeness and correctness.
▪ Developed reports and dashboards using Tableau that supported the data analysis collection efforts of customized patient
record information for studies used in decision support.
▪ Knowledgeable with data structures on the backend and clinical and lab workflows on the front end for the Electronic
Health Record (EHR) and Laboratory Information Systems (LIS) like Epic and McKesson respectively.
▪ Used SQL based query writing with Server Report Services including the SQL Server Reporting Services (SSRS) with the
Report Designer component.
▪ Developed and scheduled a new ETL data extract using SQL Server Integration Services package to send lab data to New
York Department of Health (NYDOH). Built a linked Oracle for McKesson MLAB server on an SQL server with parallel testing.
▪ Set up Aqua Data Studio on the same SQL server with SSIS package scheduled. Built and scheduled a SSIS package to run in
parallel to McKesson MLAB production package prior to cut over.
▪ Re-engineered existing project: changed it from using Oracle views.
▪ Developed Discern Analytics 2.0 (DA2) Reports and incorporated Cerner Command Language (CCL) queries for more
complex issues including scheduling reports for automatic delivery. Familiar with data structure on the backend and clinical
workflows on the front end.
▪ Developed Press Ganey (PGFusion) surveys.
▪ DA2/CCL platform managed with backend ops jobs.
▪ Designed Tableau dashboards and managed Tableau Server.
▪ Identified patterns and meaningful insights from data by analyzing it and improved performances by modifying SQL queries.
5 of 6
COMMUNITY HEALTH SYSTEMS BRENTWOOD, TN
Sr. Cerner Consultant (December 2011 to October 2013)
▪ Achieved 100 percent scores on audit before attestation reporting period for HHS incentive payment for hospitals all over.
▪ Reached attestation and submission of electronic Clinical Quality Measures (eCQM) for Meaningful Use (MU) Stage I for full
reimbursement from CMS.
▪ Built PowerChart menus, order sets, assessments, and flowsheets in TEST and import them into PROD for inpatient workflows
for Cerner Millennium and iMed EHR.
▪ Led design sessions and utilized DCWs to ensure proper build of PowerChart with application CCL and Rules development.
▪ Tested new software fixes in updated patch releases including unit and integrated testing.
▪ Inpatient clinical builds for providers on new Cerner Millennium PowerChart and CoPath platforms.
▪ Trained super users and end users in class and at the elbow on software prior to go-lives.
▪ Developed MU reports for clinical decision support.
UNIVERSITY OF UTAH HEALTHCARE SALT LAKE CITY, UT
Sr. Epic Consultant (Feb. 2011 to Dec. 2011)
▪ Built menus, Order Sets, assessments, and Flowsheets in POC, TST, and imported them into PROD for EpicCare Ambulatory
and Beaker modules.
▪ Tested new software fixes in updated patch releases for unit and integrated testing
▪ Trained super users and end users at the elbow on software prior to go-lives
▪ Supported MyChart, EpicLink, Care Everywhere, and Community Connect for rural providers
▪ Developed reports for Physician Quality Reporting System (PQRS) and clinical decision support to improve quality care based
quality measures available.
▪ Developed Smart Phrases, Order Sets, Flowsheets, forms, Med, Dx, and Preference Lists
INTERMOUNTAIN HEALTHCARE SALT LAKE CITY, UT
Sr. Business Analyst/Report Writer (April 2007 to Feb. 2011)
▪ Completed custom development and support of database, interface, and application support of PACS/RIS systems
▪ Performed analysis in support of HL7, DICOM, Health Information Exchange (HIE) data
▪ Documented, performed testing, and validation for integration testing via transaction interface sets
▪ Supported all providers who used the application on their devices
▪ Built and tested requested tasks
▪ Created user accounts and managed profiles
▪ Supported resolution of field devices
▪ Served on-Call rotation for 24x7 legacy application support for end users while utilizing remedy for customized development
for Incident and task management
▪ Wrote reports for management using Cognos report writing tools for lab decision support
6 of 6
▪ Executed all phases of testing including but not limited to, unit, application, integrated and regression in all environments.
▪ Queried and maintained databases with tools such as SQL, TOAD, and Access for data mining
▪ Corrected Facets workflows and business and technical rules for diagnosis and billing codes for faster claims adjudication
▪ Resolved issues and tracked upgrade requests for Facets software optimization.
▪ Worked on ICD-10 conversion project with Deloitte consultants
PC CONSULTING, INC. KAYSVILLE, UT
Sr. Business Analyst/Report Writer (March 2006 to March 2007)
▪ Sold additional products and services to existing customers and achieved 100 percent of sales quota
▪ Led project discovery, gap analysis, built, installations, set up, and maintained databases for TimeShareWare software
▪ Supported technical and security SFDC issues for customer support
▪ Wrote and ran SQL queries and scripts to update and fix data structures within tables
▪ Wrote reports with Crystal Reports writing tool for decision support
▪ Managed major accounts such as Marriott time shares in San Francisco and Singapore
DIRECTPOINTE, INC. LINDON, UT
Sr. Healthcare Program Manager (March 2005 to March 2006)
▪ Conducted market research of healthcare provider demographics
▪ Developed strategic healthcare sales and marketing plans; attended industry trade shows (Interop IT Expo in Orlando, FL 2005)
and specialty conferences (GE Centricity Users Summit in Dallas, TX 2005)
▪ Developed customized healthcare products and service offerings, included managed services and GE Centricity ASP models
▪ Worked closely and professionally with clients and SME, demonstrating interpersonal skills
▪ Communicated effectively with clients as well as team members in verbal and written formats
▪ Delivered presentations as needed and exercised initiative, discretion, followed up and independent judgment
INTERMOUNTAIN HEALTHCARE SALT LAKE CITY, UT
Sr. Business Analyst/Project Manager (March 1994 to April 2004)
▪ Built, configured, and implemented Trizetto Facets, a new $20M claims system, on time and on budget; the successful
medical claims system was for the payer (HMO) division of IHC
▪ Coordinated all technical aspects of the project including interfacing with management, architects, system administrators,
business analysts, programmers, DBAs, and users for new claims workflow and rules implementation
▪ Conducted change management meetings and addressed any issues for upgrades and modifications for downstream effects
▪ Supported client and server networked systems, managed user accounts, and security
EDUCATION
SOUTHERN UTAH UNIVERSITY CEDAR CITY, UTAH
BS Degree June 1993