Apr 2021 – Jul 2024 · 3 yrs 3 mos · Remote

• ● Work closely with data engineering team to plug leaks in the data pipeline
• Identify errors and bugs, find source code responsible for errors, create tickets for
• data engineering team, and audit changes
• Determine if error is caused by source data or part of the data transformation
• process
• Liaise with data engineers, clinical team, financial team, etc to ensure that
• enterprise datasets meet business needs and proactively create tickets to
• correct errors that impact downstream reports
• Utilized Snowflake, AWS, bit bucket, and Jira in this process
• ● Provide analytical support to various teams, leading to improved business performance and
• enhanced financial and clinical outcomes
• ● Identify members for clinical programs, contributing to improved patient outcomes
• ● Peer-review internal models, reports, and cost categories — ensuring accuracy and quality
• ● Automate manual processes, increasing efficiency and reducing errors
• ● Design, document, and conduct data quality audits, maintaining data integrity throughout the
• pipeline

Feb 2018 – Apr 2021 · 3 yrs 2 mos · Honolulu, Hawaii

• MDX Hawai'i was a fully owned subsidiary of agilon health providing third party administration for Medicare Advantage health plans.
• Provide financial and analytical support to the local market leadership team to help improve business performance and drive improved financial and clinical outcomes
• Reports utilized financial, clinical, membership, and claims data
• Used industry standard code sets as well as custom data models to provide informative and actionable reports
• Produce nuanced reports from complex and disparate data sources using SQL, Excel, and other systems

Nov 2014 – May 2016 · 1 yr 6 mos

• Contract to FTE position
• ● Develop new reports to identify trends that impact reimbursements from the Centers for Medicare & Medicaid Services (CMS)
• ● Develop new procedures for generating medical record “chase lists” for the Medicare, Medicaid, and Commercial/Exchange populations to decrease reliance on external vendors
• ● Create models to estimate risk scores for Medicare and Exchange populations for comparison to CMS scores to identify gaps in risk scores for potential increases to reimbursements
• ● Transition existing report procedures to ICD-10 compliance

Oct 2013 – Nov 2014 · 1 yr 1 mo

• ● Report Production
• ○ Peer review standard financial and healthcare metric reports for TPA clients
• ○ Production of ad-hoc reports for internal and external clients
• ○ Design new reports to guide actionable stretegies
• ○ Audit data quality of inbound and outbound data extracts as well as data quality in the reporting data warehouse
• ● Develop new reports and reporting tools to support new and current products.

Mar 2010 – Oct 2013 · 3 yrs 7 mos

• ● Responsible for the production of financial and healthcare metric reports for TPA clients, standard as well as ad-hoc
• ○ Requires skill in dealing with big data sets and relational databases
• ○ Advanced knowledge of SQL (Microsoft Access and SQL Server Management Studio) and Visual Basic
• ○ Advanced knowledge of Excel (pivot tables, lookups, etc.)
• ○ Combine disparate data sets to produce cogent reports
• ○ Proactively audit data quality issues in order to make best use of time available during reporting cycles
• ○ Graphic design for attractive and uniform reporting style
• ● Identify inefficiencies and automate reporting procedures for the department
• ○ Maintain running bug-list used for prioritizing fixes and assigning responsibility
• ○ Automate time-intensive processes using VB or other procedures
• ○ Identify and eliminate redundant reporting
• ● Cross training co-workers
• ○ Report company-wide membership metrics for comparison against budget and company goals
• ○ How to effectively peer review the work of others generating external reports
• ● Provide company wide technical support for Access databases including building, maintaining, upgrading, and designing new reports as company needs change
• ● Previously assisted with implementation of new healthcare data warehouse and currently designing new reports around new features

Jun 2007 – Mar 2010 · 2 yrs 9 mos