Kevin Hernandez Email & Phone Number

San Juan, Pr

San Juan, Pr

• Identify enhancement opportunities in Operational letters process. Add controls and reporting to eliminate problem areas. Greatly reduced processing time and added automation to process. Added sequencing logic to be able to send multiple letter batches per day.• Design and implement a module in company’s main web application to map and convert between ICD-9 CM and ICD-10 CM codes. Design ETL process that uses web scraping to find new ICD-9 – ICD-10 mapping files on CMS site, downloads the files, and updates database.• Design and implement Prescriber Maximum Out-of-Pocket ETL process that loads and calculates the maximum out-of-pocket amount each patient and dependants have utilized.• Design, implementation, testing and maintenance of Membership Synchronization ETL processes for 4 new clients using SQL Server Integration Services. Optimized data flow logic and T-SQL queries to reduce processing time on all existing Membership processes.• Design, implementation, testing, and maintenance of Claims Utilization reporting process for new Medicare client. Implemented client’s preferred logic to calculate adjusted claims.

San Juan, Pr

• Research, design and implement a solution using Mirth Connect cross-platform integration software to translate NCPDP messages and to replace company’s old NCPDP integration software. Use Java and JavaScript to create custom NCPDP connectors.• Responsible for maintenance and optimization of Commercial Membership ETL processes for existing clients.• Responsible for maintenance and optimization of Medicare Operational Letters ETL process. (Transition, Coverage Determination, and Excluded Provider letters).• Maintenance and optimization of Medicare Explanation of Beneffits (EOB) letter process. • Responsible for maintenance and optimization of database synchronization ETL processes to manage Prescriber and Pharmacy Database subscriptions and provide data to downstream systems.• Responsible for the design and implementation of SQL Server Reporting Services reports as requested by internal and external users.

Bachelor Of Science (B.S.), Computer Engineering

Bachelor Of Science (B.S.), Computer Engineering

High School Diploma