Iris Liu
210 Santa Louisa
Irvine, CA 92606
Phone: [Send email to request phone number] 79-3759 (home) 213-400-2188 (cell)
Email: [Send email using form at bottom]
EDUCATION
University of Southern California, Los Angeles, CA
Master of Accounting
University of Minnesota at Twin Cities, Minneapolis, MN
M.S. in Biostatistics
State University of New York at Binghamton, Binghamton, NY
B.A. in Mathematics
PROFESSIONAL EXPERIENCE
Hyundai Capital USA, Irvine, CA
3/2010-Present
• Generating KPIs for company-wide dashboard through SAS programming
• Perform analysis based on credit scores (FICO scores) for industry-wide
benchmark study
United Health Care Group, Cypress, CA
5/2008-7/2009
• Project planning, extracting and merging data from UHG west region data store
to build model for projecting and forecasting medical cost trend
• Conducting drill down analysis to identify cost trend and sources for the
trend.
• Extracting data from multiple company wide databases and conducting
reconciliation analysis to identify discrepancies among data sources and create
monthly reconciliation reports.
• Extensive SAS and SQL programming and using Excel and Access application.
• Working closely with team members in other states and other departments
including Finance, Accounting, and IT.
Well Point Insurance Company, Woodland Hills, CA
9/2007 – 5/2008
• Creating periodical and Ad Hoc reports for State Sponsored Program of Well
Point by extracting data from Wellpoint’s Oracle databases. SAS programming, SQL
programming and Working with Access database
• Working with doctors and nurses on writing report requests as well as trouble
shooting
Farmers’ Insurance Group, Los Angeles, CA
6/2003-12/2006
• Building predictive models for Farmers’ California Homeowner’s line of
business by extracting and merging data from Farmers’ companywide internal
databases and external databases using SAS and Emblem software.
• Delivering mandatory rate filing for the State of Washington applying credit
score using multivariate analysis
• Extracting data, designing model and programming for Homeowner retention
project using multivariate analysis using SAS
Deloitte & Touch LLP, Los Angeles, CA
• Working on Multi-Million dollar projects to build predictive models for
insurance companies nationwide
• Participating in all phases of model developing from data cleaning, data
merging, Univariate analysis to Multivariate analysis and applying different
level of data mining techniques including Regression, GLM, Neural Network and
Decision Tree.
• Conducting researches on predictive modeling theories and methodologies
• Communicating with clients about their expectations of projects, the scope and
approach of projects, and the results of projects and collaborating with
co-workers in offices in different states and in other countries
• Programming in SAS, Access and Excel. Preparing and presenting presentations
in Powerpoint
Toyota Motor Insurance Company, Torrance, CA
10/1998 -10/1999
• Performing statistical analysis to price Warranties for Toyota Motor Company
• Performing specialized reserve analysis for Warranty insurance
• SAS Programming
Automobile Club of Southern California, Costa Mesa, CA
10/1995-10/1998
• Preparing rate filings to the Department of Insurance including preparing
exhibits and calculating indications
• SAS programming and data extraction
Massachusetts General Hospital, MA
New England Research Institute, MA
Department of Biostatistics, University of Minnesota at Twin Cities, MN
9/1988-3/1994
• SAS programming and statistical analysis for projects sponsored by Harvard
Medical School, AIDS trials sponsored by NIH and clinical trials conducted by
University of Minnesota at Twin Cities, School of Public Health
COMPUTER AND DATA SKILLS
Language/Software/Database: SAS (Basic & Statistical and Modeling package,
EMBLEM, Visual Basic, SQL, Neural Network, Microsoft Office. Oracle, Hyperion
Commercial Databases Experience: U.S. Census database, EASI database, Weather
database, Credit Score database
Operating System: Unix, TSO (JCL) Mainframe, PC SAS
|
