Resume

Sign in

Actuary

Location:
McKinney, Texas, United States
Posted:
September 13, 2018

Contact this candidate

Resume:

YIWEI (SHERRY) LIU

McKinney, Texas ***** 469-***-**** ac61kd@r.postjobfree.com linkedin.com/in/yiwei-sherry-liu

Green Card Holder Status

ACTUARIAL EXAMS

EXAM FM / 1 FINANCIAL MATHEMATICS SCORE 9 COMPLETION DATE 2/2018

EXAM P / 1 PROBABILITY SCORE 7 COMPLETION DATE 11/2017

COMPLETED 2 VEE EXAMS (ECONOMICS, AND CORPORATE FINANCE) 5/2018-8/2018

TECHNICAL SKILLS

SAP (ECC 6.4, SCM 7.0), SQL, SAS, Tableau, Toad, Microsoft Excel (Regression, Solver, Macros), VBA, Python, R, Microsoft Access, Microsoft Project, Visio, Oracle, PeopleSoft, E-Views

EXPERIENCE

RENT-A-CENTER, Plano, Texas

Statistical Data Analyst, 2015-2018

Built statistical model to assist the manager making decisions on supply chain in order to reduce costs and maximize profits.

Wrote SQL queries in TOAD to retrieve related data to support statistical analysis

Updated data in SQL Developer and updated table and reports via Visual Basic.

Used SAS distribution to conduct cluster analysis and group stores by performance.

Built statistical model to determine eligibility of stores to carry products in 36 classes.

Recommended enhancements and changes in replenishment parameters to drive replenishment orders and maximize store sales and profitability, variance pattern and other factors to determine optimized order point for each store/class.

Led special projects supporting supply chain decisions and managed project timeline.

Conducted cyclical and ad hoc analysis and presented key findings by Tableau to improve decisions.

SAMSUNG TELECOMMUNICATIONS AMERICA, Richardson, Texas

Order Management Analyst, 2013-2014

Responsible for data management at each stage of inventory flow, and for building on models to identify and solve problems.

Identified data exchanged in SAP between purchase orders, inventory, shipping status, atlas, and invoice documents.

Monitored inventory and material movements and used SharePoint to realize information sharing.

Applied Excel to maintain statistical analysis updated and assisted with target-oriented decision.

Utilized Macro function to identify problem data; standardized all worksheets for categorization purpose.

Used SQL to perform data retrieving, table join, and database updating in Microsoft Access.

SHERWIN WILLIAMS, Garland, Texas

Statistical Business Analyst, 2012

Participated in lean sigma project that utilized statistical distribution knowledge and quantitative analysis to identify the reason for inventory shrinkage.

Performed field visits of factory and researched on value-added and non-value-added process.

Studied business process flow, conducted data mining from corporate database, and joined data tables to achieve one-to-one, one-to-many, or many-to-many relationship based on primary and foreign key in SQL.

Used Excel to select and analyze data of materials that had losses during delivery; categorized reasons for loss.

Utilized pivot table to complete statistics on different potential reasons of material shrinkage.

Applied what-if analysis on raw material Slurry 66-30-37 and identified source of $100,000 discrepancy.

STANDARD CHARTERED BANK, Guangzhou, Guangdong, China

Financial Pricing Analyst - Actuary, 2010

Performed actuarial analyses based on statistical data, and built up pricing model and determined optimal price for new financial products with consideration time value of money.

Conducted market research on new financial products and performed price analysis to estimate price elasticity.

Performed sampling survey of 1,500 observations, allocated customers’ master data and risk-return preference, and used statistics skills to categorize data into database.

Built models in Excel based on hypothesis, applied multivariate regression in Excel, analyzed ANOVA report, and concluded on how much each potential factor would influence on customers’ consumption preference.

Used estimated index from regression to apply Solver in Excel to complete transition modeling for case, and identified set of optimized rates and payment values for new financial product.

Performed what-if analysis and set most profitable rate and payment method for new financial product.

Provided final reports to management to support decision of new finance product improvement.

CERTIFICATION

Certified Corporate Financial Planner, Issued by International Federation of Financial Standards Association, 2017

Six Sigma Green Belt, Issued by American Society of Quality, 2012

EDUCATION

HONGJING INTERNATIONAL EDUCATION Actuary Certification Training, 2017

UNIVERSITY OF TEXAS AT DALLAS, Richardson, Texas M.S., Supply Chain Management, GPA: 4.0, 2013

SOUTH CHINA NORMAL UNIVERSITY, Guangzhou, Guangdong, China B.B.A., Accounting, GPA: 3.7, 2011

UNIVERSITY OF WEST FLORIDA, PENSACOLA, FLORIDA Exchange Program, Finance, GPA: 4.0, 2009

ORGANIZATION

SOCIETY OF ACTUARIES CANDIDATE

SIFE TEAM IN SCNU BUSINESS SCHOOL TEAM LEADER

AMERICAN SOCIETY FOR QUALITY TEAM MEMBER



Contact this candidate