Will Apps
Wake Forest
Summary
ETL Data Developer with over eight years of experience designing, developing, and maintaining robust healthcare data exchange solutions. Proven expertise in automating data processes, ensuring data quality, and building scalable systems that address current and future business needs. Specializes in HEDIS automation, EMR data pipeline architecture and development, and creating impactful data visualizations, with extensive experience working with ANSI X12 and a multitude of healthcare transaction sets for claims, eligibility, pharmacy, and billing. Adept at collaborating with leadership, business teams, and technical stakeholders to translate complex requirements into efficient, high-quality data-driven solutions.
Overview
7
7
years of professional experience
Work History
ETL Data Developer
GRIPA
05.2022 - Current
- Automated HEDIS measure collection and analysis, significantly increasing data accuracy and reducing support overhead for healthcare quality evaluation.
- Designed and built a robust EMR data pipeline, enhancing data availability and accessibility for the GRIPA data warehouse.
- Developed user-friendly data visualizations in Arcadia, empowering business teams with actionable insights for data-driven decision-making.
- Currently engaged in customized application development, collaborating directly with providers to create tools that improve HEDIS scores and promote data-driven care.
- Managed extensive data extraction, transformation, loading (ETL), and data quality processes.
- Collaborated effectively with both technical and non-technical stakeholders, including leadership and providers, to understand needs and deliver tailored solutions.
- Contributed to data initiatives, documented data exchange processes, and provided mentorship and technical guidance to junior team members.
Database Developer II
ProAct - PBM
10.2018 - 05.2022
- Designed, developed, and maintained healthcare data exchange solutions with providers, payers, and PBMs, ensuring seamless data flow.
- Worked extensively with ANSI X12 and HIPAA-compliant transaction sets (including 834, 837, 835, 270/271, 276/277) to support claims, eligibility, pharmacy, billing, and enrollment processes.
- Partnered closely with business teams (claims, eligibility, pharmacy, billing, enrollment) and technical stakeholders to gather requirements, ensuring data quality, regulatory compliance, and reliable system performance.
- Translated complex business requirements into detailed, production-level technical specifications, leading to the creation of new features and enhancements.
- Built and designed numerous data solutions, consistently ensuring data integrity for a rapidly growing company.
- Managed an eligibility process tracking over a million members' eligibility for pharmacy claims reporting and adjudication. (SQL, T-SQL, SSIS, SSRS, C#)
- Collaborated with PBM partners to optimize prescription, formulary, and claims workflows, including adherence to NCPDP pharmacy standards.
- Actively involved in troubleshooting issues and optimizing workflows to enhance system efficiency.
Education
Bachelor of Applied Science (BAS) - Computer Science
Le Moyne College
Syracuse, New YorkAssociate of Arts and Sciences (AAS) - Hotel/Motel Administration/Management
Herkimer Community College
Herkimer, New YorkSkills
- Database & ETL: Microsoft SQL Server, SQL, T-SQL, SQL Server Integration Services (SSIS), Database Design, Extract, Transform, Load (ETL), Database Administration, SQL Server Management Studio
- Healthcare Data Exchange: ANSI X12 (834, 837, 835, 270/271, 276/277), HIPAA Compliance, NCPDP Pharmacy Standards, Electronic Data Interchange (EDI)
- Healthcare Data: Healthcare Effectiveness Data and Information Set (HEDIS), EMR Data Pipelines, CMS, HCPCS, CPT Coding, Claims Management, Quality Measures
- Data Reporting & Visualization: SQL Server Reporting Services (SSRS), Arcadia, Internal Reports Automation
- Programming & Scripting: Python, C#, Java, PHP, JavaScript, XML, JSON, XML Schema Definition (XSD)
- Methodologies & Concepts: Algorithm Design, Data Architecture, Process Optimization, Data Governance, WinForms
Timeline
ETL Data Developer
GRIPA
05.2022 - Current
Database Developer II
ProAct - PBM
10.2018 - 05.2022
Associate of Arts and Sciences (AAS) - Hotel/Motel Administration/Management
Herkimer Community College
Bachelor of Applied Science (BAS) - Computer Science
Le Moyne College