Responsibilities:•Defining EHR integration strategies and building prototypes for those strategies in a cloud environment•Defining database schemas, deploying databases, and creating stored procedures to store/retrieve data•Creating presentations & architecture diagrams for executive, product, customer, and engineering levels to illustrate how everything we build fits together end-to-end with an EHR•Working with Leaders, POs, PMs, Devs, Engs to consult on integration options, limitations, and deliverables•Working with Security team to consult on the healthcare partner security reviews and governance•Working with Data Scientists to define data schemas for ML inferences and predictions•Working with Product Managers to consult on roadmaps and “go-to-market” strategies•Working with QA Engineers to define test cases and workflows•Working with EHR vendors and their API endpointsProjects:•Implementation of an EDI Engine for real-time ingestion in an Azure cloud environment including the development of several parsers tailored to different HL7 and X12 message type, transformation of parsed data into normalized data sets, stored procedures to write data to tables, and tables to store the data•Infrastructure as Code work using terraform to auto-generate Azure VMs, VNETs, SQL Servers, and Databases•Automating data extraction from Epic data warehouses, Chronicles and Clarity, including writing the queries and building batch jobs•Writing a comprehensive set of revenue cycle queries using Snowflake to feed into Azure Blob Storage to be consumed by Databricks, with the data spanning patients, guarantors, accounts, charges, transactions, and supporting translation tables•Supported several healthcare go-lives for our revenue cycle product which included scaling infrastructure through terraform, building data payloads, running ingestion, debugging, and completing data validation using queries to compare source and destination data as it traverses our data pipeline

Responsibilities:•Drafting integration architecture diagrams•Working on product roadmaps•Leading partners/products through customer security requirements and reviews•Consulting on product strategies•Defining API endpoint specifications•Creating database schemas and stored procedures•Creating prototypes integrations in development environments•Creating de-identification processes for Patient Health Information (PHI)Projects:•Architected product integration for Patient Pre-Payments solution including building proof-of-concept integrations using APIs to source patient estimates from an EHR and write back endpoints to sync payments made back into EHR.•Architected product integration for Predictive Healthcare Insurance solution including implementing an EDI Engine, building TCP interfaces to receive X12 270/271 messages, building parsers for these messages, and building rest endpoints to ML & Telemetry services.•Consulted on API requirements and patient workflows for a Digital Immunization Credential offering through mobile phones.•Supported Prior Authorization implementation, focused on debugging latency and data accuracy issues.•Defined data schemas and wrote queries to source data for ML projects supporting predictions around a Healthcare Payor's "Propensity to Deny" and "Propensity to Pay" claims.

Backend development, optimization, and production support of Epic Integration tools utilized by the Providence St. Joseph Healthcare organization. Work has primarily been focused on web application commonization, debugging, and performance / feature enhancements leveraging the following technologies: C#, SQL, .Net Framework, Entity Framework, Log4Net, EPPlus, CSVHelper, Visual Studio, SQL Server Management StudioConsulting for solutions built by various Epic Analyst teams such as Grand Central, Integrated Masterfile, and Resolute Billing. Some examples include providing extended life support for a Hospital Billing Chargemaster Tool, ticket aggregation research during Epic Instance Alignment, and configurations for end-to-end insurance verification using EDI X12 messaging between Epic and vendor Experian.

Solutions Development through workflow analysis and mapping, automation, engineering, windows scripting, programming, and database development. Focus on developing solutions and tools that can improve efficiencies in workflows, system build, and maintenance among application teams.Consulting on the development of Epic Tools with the Epic Integration Architecture team.Production Support of critical/non-critical issues and optimization requests for Epic Medical Record System modules: Eligibility (RTE), Grand Central, Prelude, Security, Tapestry.Facility Structure build out of core Epic records for deployments within modules: Grand Central, Prelude.Data Courier of build between a complex multi-layered environments. Documentation and tracking of the moves via internally developed web tool called Gatekeeper. Designing a sustainable implementation of the Tapestry Managed Care module, working through complexities such as: retention of legacy medical systems for “source of truth” data, interface data syncing between different medical systems, automating/streamlining complex time-intensive processes, and consulting on migration cleanup efforts.

Enterprise Virtualization Engineering of Desktop/Applications focused on scalability with VMware/Citrix environments.Worked on virtual desktop design/optimization, application virtualization, network/server/storage configuration, secure gateway/load-balancing, thin/zero client endpoints, cross-domain group policies, persona management, printing, quality assurance/testing, process documentation/standardization, infrastructure metrics/monitoring, workforce mobility, and end user experience. Leveraged technologies from: Citrix, Microsoft, Liquidware Labs, Teradici, VMware, Wyse, and ZenossProduction support/troubleshooting, local administrative access auditing/evaluation/mitigation through Active Directory, and Microsoft System Center Configuration Management (SCCM) with an emphasis on packaging software for deployment leveraging Wise Packaging. Tested new hardware/software for production, published applications that utilized Batch/VBS/Powershell scripts, implemented group policy printing solutions, and ran security audits through Symantec Endpoint Protection (SEP).

Maintained the usability of hardware systems and clinical/business software through deployment, configuration, and troubleshooting. Supported doctors, nurses, information technology professionals, and other Providence Health & Services employees. Worked with the Desktop Engineering team to develop a standard desktop/laptop/tablet images for deployments in a business/clinical environment.

Network Defense Engineering and Architecture for secure LAN/WAN Environments, leveraging security technologies between Transport and Application layers. Employed up-to-date technical knowledge with regards to industry best practices, security countermeasures, and the LAN/WAN network hardware utilized. Systems Management and Monitoring of a secured military Nipper/Sipper network for threat detection and intrusion prevention. Data and Hardware encryption rollouts with Trend Micro Mobile Armor (Data Armor, File Armor).Wireless Intrusion Detection Systems (WIDS) roll-outs with Netscout AirMagnet hardware.Policy Creation and Documentation of guidelines, techniques, and procedures developed for Information Assurance.

Maintained the usability of hardware systems and business software through deployment, configuration, and troubleshooting.Consulted with users and customers, explaining issues at both technical and non-technical levels in order to resolve problems with software products and services. Developed custom VBA solutions in a Microsoft Office environment, to help automate workflows.Database Administration including development and maintenance of several Access/SQL databases housing information about Clients, Employees, Inventory, Troubleshooting Logs, and Service Logs.Administration of an Electronic Document Management System including access/security, server, storage, optical character recognition engine, and configuration of scan templates.