Tony Hernandez Email & Phone Number

Eugene, OR, US

Springfield, Oregon, US

• Lead ETL and report development for Medicare Advantage Risk Adjustment using SQL and SAS.
• Train and support colleagues on data tools and effective data analysis methods.
• Optimize data processes and reduce legacy ETL and report runtimes by 25-75%.
• Update and maintain logic for Medicare Advantage Gap Reports, integrating V24 andV28 models for Payment Year 2023 and 2024.
• Support the Medicare Advantage Chart Review Program by generating chase lists and coding workbooks for the Risk Adjustment Coding Team.
• Create process standards and comprehensive technical documentation for workflows.

Springfield, Oregon, US

• Led ETL development to produce HEDIS data mart for quality measures processing.
• Contribute processed HEDIS and STARS data to enterprise data warehouse for reporting and submission deliverables, using SQL and SSIS.
• Managed HEDIS audit data sections, ensuring compliance with auditor requirements.
• Managed technical cross-functional projects through collaboration with stakeholders to support HEDIS and STARS measures.
• Served as the technical contact for supplemental data transfers, ensuring smooth integration and timely delivery of data for HEDIS and STARS reporting.
• Create process standards and comprehensive technical documentation for workflows.

Springfield, Oregon, US

• Developed ETL workflows to produce HEDIS data mart for quality measures processing.
• Developed and supported dynamic reports using SQL stored procedures and SSRS.

Hood River, OR, US

• Participated in 6-month Farman Fellow leadership program that focuses on furtherdeveloping purpose, identity, and community for survivors, with an increased commitment to contributing to the work of Project Koru.
• Attended Camp Koru in May 2022 as a cooperative leader to help young adult cancer survivors navigate their survivorship during their experience.
• Represented Project Koru at events to fundraise and share the mission of Project Koru.

• Developed ETL workflows between two claims processing systems using SQL.
• Developed data driven applications to capture and report health metrics and survey data.

Learned the business workflows by working in various departments with changing responsibilities. I learned about the water tracking workflows in order to develop a web-based, water usage tracking system. I completed the application planning, development, documentation and implementation of the system as a Senior project at Oregon Tech.The system was.