Data Analyst

Shuai (Sharon) Yang

** ***** ***** *****,

Apt **12, Jersey City, NJ 07310

(617) 678-

**** ******.*****.****@*****.***

SUMMARY & GOAL

. 2.5 years Professional Experience in Financial Industry across functions

in Finance-Strategy & Planning, Credit Risk Analytics, and Auditing

. Master Degree in Financial Engineering

EXPERIENCE

BLACKROCK (July 2012-Current)

New York, NY Reporting & Financial

Models Analyst, Finance-Strategy & Planning Group

. Retrieved data from Essbase and Oracle, re-engineered the architecture

and calculations in MS Access Database using SQL Query Programming for

Headcount Forecasting Report

. Maintained, troubleshoot and developed technical initiatives, including

producing end user manual, providing technical support, leading end user

training and demo presentation to assist new technical features in MS

Access Database

. Automated analytical reports using Excel Modeling and VBA

. Developed monthly financial forecasting, reporting and close process for

the business, focused on enhancing models of Variance, Trend and Components

Analysis on Headcount, Compensation, and G&A expense by business drivers

. Created and automated Expense Variance model using Statistical

methodology to improve the presentation quantitatively

. SharePoint administrator

. Business knowledge of Corporate Operations and Asset Management

CITIGROUP (July 2011- June 2012)

New York,

NY

Data Analyst & SAS Programmer, Credit Risk Analytics Group

. Processed large data sets from Teradata EDW and data analysis for risk

metrics to oversight portfolio performance, created MIS Reports to support

Operations/Business teams technically using SAS/SQL Programming in UNIX

environment, and tested Excel VBA automation tools

. Developed data dictionary, modified code and validated models

. Enhanced data integrity, assessed and investigated data coverage and

quality to maintain a solid infrastructure

. Validated the Multi-variable Regression Model methodology to project the

Possibility of Default (PD) with economic indicators, tested the projected

loss by Scenario Analysis using Excel and Access for FED Comprehensive

Capital Analysis and Review (CCAR) Stress Testing

. Reviewed the Business Requirement Documents (BRD), wrote and executed

Test Scripts, performed User Acceptance Testing (UAT) with Technology team

. Structured commercial loan and conducted credit analysis using Moody's

Risk Analyst tool

. Owned a SharePoint site

. Business knowledge of commercial loans for small business

DELOITTE & TOUCHE LLP (July 2008- August 2009)

Shanghai, China

Auditor, Audit Department

. Annual Audit Report and Notes for Manufacturing Industry

. Design Audit Plan and conduct Audit Procedures

. Balance Sheet and Income Statement

. Accounting Cycle and Internal Control

. Consolidated Financial Statements

EDUCATION

NEW YORK UNIVERSITY (January 2010 - May 2011)

New York, NY

Master of Science, Financial Engineering/Applied Mathematics

XIAMEN UNIVERSITY (September 2004 - July 2008)

Xiamen, China

Bachelor of Economics, Finance

Contact this candidate