Summary
Overview
Work History
Education
Skills
Timeline
Generic

Austen Joeckel

Yakima,WA

Summary

Data Analyst with advanced mathematical and analytical skills with a proven track record of identifying complex issues, collecting information and developing practical solutions to problems. Strong written and oral communication skills useful in summarizing and presenting findings to decision-makers and developing strategic recommendations. Self-motivated with desire to advance professionally as evidenced by continuing education in data science. Two years of experience in the medical claims field working with a team to develop complex ad-hoc reports for large clients and providing top-tier support. Positioned on a special team that provided CMS auditing and compliance solutions to clients. Took initiative to develop automation tools to eliminate routine reporting and built complex database procedures within Toad/SSMS to reduce labor hours and improve efficiency. Provided data validation and testing for the implementation of new technology and procedures across Advantasure's data warehousing. Worked with extremely sensitive data ensuring compliance to all protected health information laws and regulations.

Overview

2
2
years of professional experience

Work History

Operational Data Analyst I

Advantasure
01.2022 - 02.2024
  • Improved operational efficiency by identifying data discrepancies and implementing corrective measures.
  • Enhanced data accuracy with thorough validation checks and ongoing database maintenance resulting with 99% accuracy on over 800 on-time yearly reports.
  • Reduced manual labor by automating data extraction, report generation, and processing tasks using advanced tools, eliminating 60% of routine reports.
  • Collaborated with cross-functional teams to develop comprehensive reports showcasing key performance metrics.
  • Identified trends and patterns in complex datasets, translating findings into actionable insights for management.
  • Ensured compliance with industry regulations while managing sensitive protected healthcare data securely and confidentially with zero breaches.
  • Conducted comprehensive financial and data validation audits for medical claims to be submitted to governmental CMS departments.
  • Collaborated closely with IT staff on system upgrades and implementations geared towards enhancing overall functionality and security features.
  • Worked directly with clients to provide support and develop complex logical schematics tailored to their requirements.
  • Verified patient insurance coverage and benefits for medical claims under ICD-10 diagnosis and procedure code framework

Implementation Consultant

Columbia Fruit Packers
12.2021 - 02.2022
  • Improved client satisfaction by providing tailored implementation solutions to meet their business needs.
  • Streamlined project processes for enhanced efficiency and timely completion of implementation projects.
  • Ensured seamless data migration, developing comprehensive data mapping plans to support accurate transfer between systems.
  • Maintained clear documentation of project progress, ensuring transparency among all stakeholders throughout the implementation process.
  • Collaborated with cross-functional teams to ensure seamless integration and adoption of new systems for clients.

Education

BBA - Management Information Systems

Western Washington University
Bellingham, WA
08.2021

Associate of Arts - Liberal Arts And General Studies

College of Southern Nevada
Las Vegas, NV
04.2014

Skills

  • Business Intelligence & Analytics
  • Medical Claims Data & Terminology (ICD-10)
  • Advanced Excel, Power BI, Power Pivot, Tableau, Visio, Visual Studio
  • Database Design, Development, Implementation and Management
  • Python, SQL and DAX Programming
  • Data Mining
  • MySQL Workbench, SQL Server Management Studio, Analysis Services, Toad, Oracle
  • Application Development/NET
  • Automation Development
  • Data Validation
  • CMS Audits & Compliance
  • Ad-Hoc reporting within JIRA ticket environment

Timeline

Operational Data Analyst I

Advantasure
01.2022 - 02.2024

Implementation Consultant

Columbia Fruit Packers
12.2021 - 02.2022

BBA - Management Information Systems

Western Washington University

Associate of Arts - Liberal Arts And General Studies

College of Southern Nevada
Austen Joeckel