Aric Osieczanek
Herriman,UT
Summary
Experienced and dedicated Senior Data Analyst with expertise in working with complex datasets. Tech-savvy analyst possessing solid SQL query writing skills coupled with deep knowledge of visualization tools and techniques. Committed to continually advancing my knowledge and always eager to learn new technologies.
Overview
16
16
years of professional experience
Work History
Senior Analyst - Medical Economics
Aetna
Sandy, UT
12.2015 - 08.2023
- Maintained a suite of analytical reports used by the larger team to help quickly identify medical cost trends and potential issues.
- Synthesized multiple sources of data and large data sets to develop reports, tools and metrics.
- Performed ad-hoc analyses using SQL queries to extract relevant information from large datasets.
- Created, designed and maintained business intelligence databases, spreadsheets and reports.
- Specialized in report automation and data visualization.
Financial Analyst
Aetna
Sandy, UT
09.2012 - 12.2015
- Gathered data and compiled financial reports related to membership and healthcare usage.
- Assisted in balancing and reconciling financial data while maintaining assigned financial reports.
- Followed established reporting, planning, forecasting calendars to ensure deadlines were met.
- Identified discrepancies in financial data and recommended corrective actions to resolve them.
Coordination of Benefits Verification Analyst
Coventry Health Care
South Jordan, UT
08.2010 - 08.2012
- Conducted detailed research and verification of customer information for accuracy and compliance with company standards.
Customer Service Specialist
Coventry Health Care
South Jordan, UT
08.2009 - 08.2010
Internal CSO Auditor
Coventry Health Care
South Jordan, UT
01.2009 - 08.2009
Customer Service Representative
Altius Health Plans
South Jordan, UT
12.2007 - 01.2009
Education
Bachelor of Science in Information Systems -
University of Utah
Skills
- SQL, SAS EG and Databases
- Microsoft Excel, Power Pivot, Power Query
- Microsoft Power BI
- Ability to work in a team or Independently
- Strong Analytical and Critical Thinking Skills
- Ability to Learn Quickly
- Data Modeling and Visualization
Timeline
Senior Analyst - Medical Economics
Aetna
12.2015 - 08.2023
Financial Analyst
Aetna
09.2012 - 12.2015
Coordination of Benefits Verification Analyst
Coventry Health Care
08.2010 - 08.2012
Customer Service Specialist
Coventry Health Care
08.2009 - 08.2010
Internal CSO Auditor
Coventry Health Care
01.2009 - 08.2009
Customer Service Representative
Altius Health Plans
12.2007 - 01.2009
Bachelor of Science in Information Systems -
University of Utah