• Design and develop scripted solutions for data monitoring tools and metrics.Define and document scripting best practice within the Technical Services team.Introduce and educate Technical Analysts to scripting basics.• Conduct calls with customer organization and third-party vendor ensuring allneeded information is gathered and the interface solution is clearly understood by all parties. Manage customer escalations related to interfacing and data quality. Mentor other team members on appropriate customer management strategies.• Serve as a product owner for Data Quality Development (aka Data Quality Manager product)• Understand and review data files of various formats (delimited, HL7, CCD(A), X12 837) and provide meaningful feedback to third-party vendor and customer to drive resolution of identified issues.• Write custom SQL to research and analyze data received via interface.• Recognize standard (LOINC, SNOMED, ICD9, CPT, etc.) and non-standard, customterminologies common in healthcare data sources.• Articulate requirements and participate in testing with interface developmentteam for any needed interface configuration enhancements and issue fixes. Collaborate with development to develop requirements and solutions for new feature or complex projects.• Document final interface configuration specifications for distribution to internal and external teams.• Assist technical support and data quality teams with complex issue investigation and resolution.• Mentor and provide training for Technical Analysts.

Data Engineering • Migrated Oracle stored procedures, packages, functions and other SQL objects from Oracle 11g environment to new 2012 MS SQL Server environment.• Created Tables, Stored Procedures, Views, Triggers, user defined data types in Oracle 10/11g and SQL Server.• Investigate and resolve performance issues by creating indexes and optimizing queries.• Responsible for troubleshooting the ingestion of membership, structured clinical data, claims data and patient demographics and the associated backend processes that link the incoming patient data to the master patient index and existing patient data.• Implemented and managed a re-attribution process that allows Insurance companies to resolve conflicts and assign patients to the appropriate provider organization.• Mentored internal client services, provider implementation and data ingestion teams on the technical aspects of the frontend and backend processes and procedures.• Maintained Users with Appropriate Roles, Privileges and Profiles.• Prepared unit test cases and performed unit testing.Production Support Analyst • Responsible for maintaining multiple sponsors’ health care programs.• Participated consistently in complaint investigations, corrective and preventative actions.• Identified process improvements for clinical data collection.• Supported Client Services and Data Operations team in daily tasks and issues.• Accountable for maintaining production database using SQL queries.• Shared the responsibility of validating and rolling patients into new health care program.• Validated automation processes in the Linux/AIX environment.