Post Job Free

Resume

Sign in

SAS Certified Advanced Programmer, Proficient in SQL, Excel VBA

Location:
Los Angeles, CA
Posted:
February 13, 2015

Contact this candidate

Resume:

Mo Bark (Christine) Lau

acoa2f@r.postjobfree.com

LOS ANGELES, CA 91401 MOBILE: 626-***-****

PROFESSIONAL PROFILE

A technologically savvy banking and financial services professional with proven track record of levering strong quantitative,

analytic and technology skills to deliver optimized and efficient business processes and solve complex problems.

ROFESSIONAL EXPERIENCE

P

BANK OF AMERICA, CALABASAS, CA 2011 PRESENT

2013 PRESENT

AVP, QUANTITATIVE ASSOCIATE – CREDIT LOSS FORECASTING

Core member of the Credit and Prepay Model Implementation Team responsible for validating model input data to be used for

model runs for Comprehensive Capital Analysis and Review (CCAR) and Allowance for Loan Loss and Lease (ALLL) purposes

and conducting model runs for the Company’s Representation and Warranty portfolio.

• Evaluated default risk of the Company’s $1.1Trillion Representation and Warranty portfolio by conducting credit and

prepay model runs on a monthly basis in support of Rep and Warrant risk loss forecasting

• Developed a SAS based procedure which analyzes data month over month variance on over a hundred attributes

• Collaborated with data management team on a monthly basis to resolve data anomalies to ensure data quality prior to

passing to model runs and other analytical processes.

2011 2013

AVP, BUSINESS CONTROL SPECIALIST – CREDIT LOSS FORECASTING

Core member of the Information and Data Management Team responsible for the extraction, transformation, loading and quality

control of the Company’s First Mortgage and Home Equity data

• Performed ETL of mortgage data with over 50 million records on a monthly basis from the Company’s various databases,

SQL and Teradata etc, to a centralized data warehouse to be consumed by various line of businesses, including but not limited

to operations, finance and credit loss forecasting.

• Performed rigorous data sanity check on production mortgage data which includes general ledger reconciliation, attribute

analysis and change analysis and resolved data issues through effective communication and collaboration with all stakeholders

• Significantly improved ETL, data sanity check and report generation processes through SAS code optimization, Excel

VBA automation and participation in the design and development of SQL Server Business Intelligence objects

• Developed and generated delinquency/roll forward report monthly to monitor portfolio credit quality and trending

• Presented to all mortgage stakeholders on a monthly basis to communicate data updates.

SKILLS

SAS Certified Advanced Programmer (SAS 9.3)

Proficient in SQL, SQL Stored Procedures, Excel, Excel Pivot table, Excel VBA

Experienced with SQL CUBE, SSIS, SSAS, SSRS, MS SQL, Teradata and SAS data management

Fluent in Mandarin and Cantonese Chinese

DUCATION

E

UNIVERSITY OF WISCONSIN – MADISON, MADISON, WI 2007 2010

BACHELOR’S OF BUSINESS ADMINISTRATION

Double major in Finance, Investment and Banking, and Statistics.

Overall GPA: 3.8/4.0

Graduate with Distinction

ROFESSIONAL DESIGNATES & LICENSES

P

CFA Level II Candidate Passed CFA Level I Exam



Contact this candidate