Responsible for creating analytics development solutions using InterSystems HealthShare Health Insight platform as well as providing developmental guidance to team members. Utilize domain driven design, design patterns and clean code principles in our analytics software development life cycle. • Develop custom analytics solutions such as:o Tracks and updates the ATNA audit log with custom events if the user request to the HIE Clinical Viewer is a standalone or downtime user request.o Tracks Health Insight tables kills in order to keep our SQL Server data warehouse in sync with Health Insight tables’ changes.o Creates solution to automate Health Insight errors resolution. o Creates XSLT Transformation that parse SDA Streamlets• Create Smart programs:o Send notifications for scheduled surgical patients when insurance change occurred.o Send notifications to care team for inpatients admitted more than four times within a year.o Send notifications for decease patients.• Troubleshoot Analytics errors that occurred on the Edges, Access Gateways, Registry and Analytics instances.• Conduct code reviews and unit tests of team member codes.

Developing Ensemble ETL processes to intake supplemental data in structured and unstructured formats for CMS Five-Star Quality Ratings and Rating System measures that identify Care Gaps and Target Measures. • Supervises a QA and a Data Analyst. Provides DA guidance for creating SQL scripts for data analysis processes. Provides supporting guidance to QA to ensure that tasks are completed in a timely matter to pseudo claim standard format.• Developing Ensemble ETL pseudo claim batch processes to intake supplemental data from flat file, HL7v2 Lab, and CCD (HITSP C32 and CCDA documents).• Developing Ensemble supplemental data enrichment processes.• Working closely with several technical groups within UHC to fully automate the intake of supplementary data to pseudo claim and a common format other downstream system.

Integration of Multi-specialty Physician practices Epic Bridges and Ensemble bi-directional interfaces with ancillary systems, and third party vendor systems as well as the migration of NextGen deconversion to Epic EMR Ambulatory.:Develop Epic Bridges such as Surescripts E-prescribing with Epic, bi-directional ADT interfaces, LabCorp, Quest, and NYS Immunization Registry with Epic. Written custom cache application code in Ensemble for lab conversion project, CCD conversion, NYS Immunization batch Real Time interface, as well as Problem conversion project.Operational support of Epic Bridges and Ensemble HL7 interfaces.Design and manage the HealthShare Ensemble instances. Implements Epic Bridges and Ensemble production alerting and monitoring notification. Communicate with project leadership, application coordinators, subject matter experts, and Epic representatives.Lead interface analysis, build, testing, and go-live support.Establish plan for how each interface or conversion is going to be coded or exchanged.Clearly specified plan of how interfaces will work in the organization.Translate business needs into specifications for interface engine programmers or directly program interface engines.Provision primary technical support for interfaces after go-live.Works collaboratively with IT Analysts, Clinical Analysts, Business Analysts, and others to understand detailed needs of end-users and configure ACIS software to support those needs.Uses vendor and third party provided tools to tailor the software to satisfy end-user needs.Creates testing plans to ensure the software performs error and bug free through all phases of testing.Analyzes and reviews interface specifications from the vendor and third party companies.Develops interfaces using engine technologies and relevant language, maintains and monitors live interfaces, and provides support and resolves problems as needed.

Implements bi-directional interface from multi-hospital HIS System(s) and associated clinical systems, such as Lab, Radiology, Pharmacy, Epic ADT, E-prescribing, and other ancillary systems.Develops interfaces that have included ADTs, Orders, Order Status Updates, Add-on Orders, Results, Charges and Transcription.Support communication protocols and standards for HL7, X12 and XML.Creates, modify and test message structures, events, and connectivity.Monitor integration engine performance, logs, databases, connections, and disk usage.Analyzes and troubleshoot interface problems using on-line integration tools and utilities.Apply modifications to existing interfaces to enhance functionality or improve integrity.Perform integrated testing and moving the applicable test environment interface components to the production (live) environment adhering to formal change management requirements.Prepares system documentations for interfaces as well as providing technical support and guidance.Designs Rhapsody Integration Engine routes and interfaces to facilitate Epic EMR interoperability with clinical downstream systems.

Played a leadership role in the design and implementation of the organization enterprise geographical information systems (GIS) that leverages ESRI ArcGIS Server products and Oracle 10gr2.Created system and user documentations for geographical information system and software applications as well as test or rollouts plans for client's hardware and software upgrade or a clean installationWorked closely with DBAs and System Engineers to ensure optimal performance of the organization enterprise geographical information systems.Designed and developed enterprise web-map that leverages the Dot Net framework, open-source technologies including Open-layers, REST, XML, XSLT and jQuery to enable users to perform a variety of geography spatial analysis.Designed and develop Geo Spatial web services using C#.Net and ESRI objects for spatial analysis. Migrated desktop applications to web-based using ASP.NET C#, ADO.NET and Oracle backend technologies.

Designed and developed various applications that included a content management system, eligibility and referral system, a staff tracking system and meeting scheduling system. These systems leverage various technologies such as MsSQL VBA, Dot Net (VB.net, C#, ADO.NET), MYSQL, JSP, JAVA, and Oracle technologies.Troubleshoot and debugged various JSP, JAVA, and Oracle web based applications due to runtime errors.Created software documentations and test plans to support various custom designed systems including database design, software application, flowcharts and objects diagrams.

Participated in exercises to standardize an existing database using Microsoft Access.Developed MS Access and Excel Applications (VBA) to aid in analysis and cleanup activitiesTrained staff and interns and provided guidance during the clean-up project.Responsible for creating Global Statistical Reports regarding the weekly and monthly Progress reports.Implemented GUI base automation applications.Automated Microsoft Access applications to analyze large quantities of business data.