Data Integration Manager

• Feb 2022 - Present

Manager, Data Integration

• Jan 2020 - Jan 2022

• Managed a team of Senior, Mid-Level, and Junior Data Engineers to complete complex data integration projects and accomplish business objectives.• Supervised daily operations of 100+ bidirectional data pipelines for various customers, vendors, and contributing healthcare providers to ensure seamless and uninterrupted data integration.• Responsible for hiring, terminating, promoting, recruiting, and training of staff. Administered performance evaluations and merit increases. Performed corrective action when necessary.• Mentored, coached, and disciplined team members. Helped develop their skillsets to grow their careers.• Formulated strategic initiatives, recommended and helped implement system and process improvements. Developed, documented, and enforced best practices, business processes, and standards.• Partnered cross-functionally with other departments to gather and communicate vital information.• Met regularly with direct reports to resolve blockages, provide decisions on best course of action, evaluate outcomes of work, align with Agile/Scrum methodologies, and deliver performance feedback.• Managed team change requests and approvals via Git, leveraging CI/CD pipelines for quick deployment.• Maintained quality customer service by enforcing quality standards, analyzing and resolving customer service problems, providing Tier 2 escalation support for On-Call Engineers to meet each customer's SLA.• Acted as an individual contributor to fill staffing or knowledge gaps to deliver on results as necessary.• Worked with DevOps and Data Management to design DI architecture for a Data Lake built in ArangoDB.• Worked with team to migrate DI workflows from legacy RDBMS to new FHIR Data Warehouse platform.• Extended our Python-based ETL engine to stream robust status and validation logs as structured JSON events to Elasticsearch and Kibana using Kafka. Utilized this data to monitor DI health and fire alerts. Show less

Senior Data Engineer

• Sep 2018 - Dec 2019

• Implemented a real-time episode-of-care bundle prediction pipeline that receives HL7 messages from client sites, validates and routes them to our Analytic Engine, then packages and sends analytic results to the client's API endpoint instantaneously, enabling huge cost-saving decision support.• Established data integration workflows using live TCP/IP connections over a VPN tunnel, RESTful HTTP web-services, SFTP file drops, and connecting to client systems to retrieve data directly.• Created ETL solutions to seamlessly integrate disparate healthcare data feeds and file formats (such as CSV, XML, Excel, or MS Access) into one homogeneous data set in our repository using Mirth, CloverETL, • Coded transformations, data feeds, extensions, and micro-services using PostgreSQL, Python, Java, JavaScript, and shell scripts.• Created data pipelines converting HL7 v2, CDA, and CSV flat files to FHIR.• Helped to build a cutting-edge data integration platform using multiple AWS tools, Kubernetes, Kafka, the ELK stack, and NiFi.• Worked with an Agile cross-functional team to support client needs and deliver effective DI solutions to meet client expectations.• Researched and resolved various technical issues and data quality questions and concerns.• Architected and built viable data models to contain structured customer data in our repository, allowing for performant analytic queries and analyses. Show less

Operations Data Specialist with The Resource Group

• Oct 2016 - Aug 2018

• Project Lead of Patient Reimbursement Workflow Redesign project. Its successful completion led to an 80% reduction in payment processing time. • Managed ETL (Extract, Transform, Load) of large data sets of hospital supplies for external client, resulting in successful system implementation. • Lead efforts to engineer software tool to help manage inventory not loaded in PeopleSoft SCM system. • Provided consultant service to external client to enable integration of contract data with Lawson MMIS. • Designed and built web request management tool allowing users to submit and manage product data adds and updates through a single source. • Analyzed pricing reports and corrected a set of longstanding discrepancies, saving $145,000 annually. • Collaborated with local hospital operations leadership, external vendors, and national data team to maintain favorable key performance metrics. • Performed data cleansing and validation to correct and prevent discrepancies. Identified and resolved EDI (Electronic Data Interchange) and data issues. • Scripted SQL queries in Oracle PeopleSoft database. Analyzed data, compiled, and presented findings. • Wrote documentation and trained users in technical procedures. • Liaised between departments at local hospitals and national information systems data management team to ensure data integrity. Show less

Application Technical Analyst (Integration Team)

• Apr 2014 - Sep 2016

• Managed project design, development, implementation, and quality assurance testing of a new national clinical results interface architecture. This replaced a legacy system which saved over $500,000 annually and enhanced usability.• Project Manager of SMTP Secure Direct Messaging project, connecting HISPs (Health Information Service Providers) and EHR systems using XDR/XDM specification. Result: Providers exceeded regulatory compliance targets.• Integration co-lead of implementation and upgrade of Meaningful Use lab order/result matching interface using Java, Mirth Results integration, and custom PostgreSQL tables.• Technical lead on clinical application projects that resulted in MU compliance, improved performance, and reduced support burden.• Created custom HL7, XML, CCD, and flat-file interfaces using Mirth Connect and Rosetta Interface Engine. Connected with FTP and TCP/IP protocols, SOAP and RESTful webservices, and APIs.• Programmed custom EHR application interfaces using JavaScript and SQL database connections. This functionality enabled data exchange with new business partners and created new revenue streams.• Constructed XSLT transformer to modify and correct XML transactions to meet CDA (Clinical Document Architecture) R2 standard for Cancer Registry.• Programmed custom interfaces to transform HL7 messages via TCP connection into SSL-secured bidirectional SOAP (Simple Object Access Protocol) and HTTP interfaces for 6 unique state immunization registries. As a result, met regulatory guidelines and earned government incentives.• Partnered with cross-functional project teammates to plan and deploy Mirth Integration Engine.• Devised and coded custom enhancements to Cerner and Nextgen EHR databases and HL7 interfaces to meet strategic goals or customer needs.• Wrote TSQL statements, triggers, and stored procedures in Microsoft SQL Server Management Studio.• Mentored and educated junior associates. Show less

Application Programmer Analyst

• Nov 2012 - Apr 2014

• Built and deployed a new Microbiology Summary Tool in PowerChart EHR, enabling providers to access discretely-interfaced lab tests and securing Meaningful Use early adopter incentive payments for clients.• Served as technical lead on projects of varying scope, building and deploying new EHR tools targeted at healthcare providers.• Investigated and resolved data issues from the Cloverleaf Interface Engine.• Coded Cerner CCL(Cerner Command Language)/SQL reports as requested by the application teams or steering committees.• System support and issue troubleshooting. Wrote custom queries to diagnose issues or provide data. Show less

Clinical Application Specialist

• Nov 2011 - Nov 2012

• Probed EHR data during fungal meningitis outbreak to rapidly identify all potential cases to be contacted.• Built interface data mappings, product files, and orders in Cerner EMR. Resolved backend PharmNet/PowerChart issues.• Maintained data quality, performed quality assurance and issue resolution.• On-call technical troubleshooting and problem solving.

Physician Technology Support

• Nov 2009 - Dec 2011

• Diagnosed and resolved Cerner PowerChart, FirstNet, and SurgiNet application issues, networking diagnostics, and various other reported hardware and software problems. • Trained and managed access for users. LDAP User Management. • Diagnosed and resolved Cerner PowerChart, FirstNet, and SurgiNet application issues, networking diagnostics, and various other reported hardware and software problems. • Trained and managed access for users. LDAP User Management.

IT Support Consultant & Electronics Technician

• Oct 2003 - Jun 2009

• Performed network setup and fresh OS installations on customer devices. Built, calibrated, and tested small electronics and single-board computers. Repaired and re-calibrated customer hardware. • Performed network setup and fresh OS installations on customer devices. Built, calibrated, and tested small electronics and single-board computers. Repaired and re-calibrated customer hardware.