Data Analyst Analysis

ERNI PUN

·**** S Western Ave · Chicago, IL ***** · Cell: 312-***-**** ·

·Email: ********@*****.*** ·

Data Analysis Experience:

Senior Health InformaƟon Consultant AIM Specialty Health (Elevance Health), New SoluƟons; Chicago, IL 01/2022- Present

Obtain, verify, analyze, and model financial target outcomes such as return-on-investment (ROI) using medical claims and authorizaƟon data

Provides business experƟse regarding the appropriate use if data element and cooperates with reporƟng personnel from other areas to establish and maintain these common business rules

Lead and acƟvely parƟcipate in new soluƟon strategy sessions with AIM medical directors and SoluƟon Design consultants

Translate data trends into strategic recommendaƟons for program development and acƟon plans

Partner with Actuarial team members to validate cost model outcomes, savings modeling assumpƟons, and ROI recommendaƟons

IdenƟfy medical cost, service uƟlizaƟon, service intensity, unit cost, and membership trends to idenƟfy new opportuniƟes for product expansion

Performs strategic data analysis (data mining) and research as appropriate to support business needs

Develops detailed understanding of relevant business process, goals and strategy in order to provide analysis and interpretaƟon

Senior Data Analyst BlueCross BlueShield AssociaƟon, Office of Commercial Markets; Chicago, IL 04/2020- 12/2021

Lead program refresh by applying univariate and multivariate analysis to determine thresholds for quality, business, and cost metrics

Contribute to development of project plans, identify and define critical paths

Collaborate closely various business entities such as Clinical and Operations to develop analytical solutions

Prepare and deliver effective summaries for various audiences and make recommendations

Write Standard Operation Procedure to fully document details of analytic evaluation process

Guide junior/new staffs for any analytic related tasks Analyst BlueCross BlueShield AssociaƟon, Office of Commercial Markets; Chicago, IL 06/2015 – 03/2020

Utilize SAS functionality to create efficiencies and to enhance automation which significantly improves customer satisfaction to benefit national Plans and healthcare providers

Create interactive visualization dashboards via Tableau to enhance overall client experience of data outcomes presentations

Perform statistical analysis and provides recommendation to management based on data finding

Leads reporting and analyze of a national program with 23 million members

Manage appeal and reconsideration process for healthcare providers who failed the initial scoring process

Gather and analyze data on health care markets, policy reform, competitors, and health plan performance to improve national Plan membership

Implement Survey Methods to analyze hospital network

Manage internal clients to identify needs per Program

Complete documentation of Clinical and Analytics Processes for publication

Mentor contingent staff and interns

Data Analyst Chicago Public Schools, Office of Early Childhood EducaƟon; Chicago, IL 10/2012 – 05/2015

Produce various reports such as early childhood enrollment reports, attendance reports, and demographics reports by using SAS to improve overall reporting efficiency of department

Disseminate the reports to program directors, chief officers, and the Mayor’s office

Data cleaning and manipulation of Early Childhood datasets for approximately 120,000 student, using SAS and Microsoft Excel

Matching preschool application data in FileMaker against IMPACT SIM enrollment data and Head Start COPA system

Monitoring key performance indicators such as student chronic absenteeism and student outcomes by using Teaching Strategies GOLD™

Manage the Classroom Assessment Scoring System™ (CLASS™) observation data to observe interactions between teachers and students by established the reporting system; making sure data accuracy, creating SAS code for scoring and school rating, producing pdf reports using SAS ods layout for teachers, and tracking on observation progress

Work closely with Governor’s office data team to make sure CPS preschool rating is aligned with ExceleRate™ Illinois rating system

Handle data request in a timely manner

Create data flow chart for Community Partnership Program(CPP) to monitor data collection process and data location

Other Job Experience:

Math Tutoring Internship DePaul University Math Department; Chicago, IL 09/2008- 03/2009

Multitasked and managed tutoring multiple math subjects to each student

Able to manage and successfully tutored a small group of college students Sales Internship Grubhub.con; Chicago, IL 06/2008-09/2008

Successfully executed and signed five contracts for the start-up company under a short period time

Made calls to set up meetings with clients, negotiated deals, and taking customer service inquiries EducaƟon:

DePaul University, Chicago Illinois: 2007-2010; Bachelor of Statistics; GPA: 3.24/4.0 Related courses taken: Probability & Statistics I II & III, Actuarial Science I, Numerical Analysis I, Linear Algebra, Data Analysis, Applied Regression Analysis, Applied Time Series/Forecast, Data Analysis/Statistical Software II, Programming in JAVA I

Northeastern Illinois University: 2005-2007; Sophomore Standing of Education; GPA 3.23/4.0 Skills:

SAS Enterprise Guide, SAS in UNIX Environments, SAS Windows Base

Tableau

Microsoft Suite (advanced Excel user and advanced PowerPoint user)

Experiences with SQL, MS Access

Great interpersonal skills gained from previous working experiences

Reference available upon request

Contact this candidate