SAS Analyst

Hao Ding

856-***-**** / ******@*****.***

. Over 5+ Years of experience as a SQL/SAS Analyst in Financial industry

in Data Analysis and Reporting.

. Highly skilled in SQL Server, Base

SAS, SAS/SQL, SAS/REPORT, SAS/TABULATE and MACROS.

. Good experience producing high resolution graphs using SAS/Graph.

. Worked with SAS/ODS and SAS/ACCESS.

. Hands on experience in SQL Programming activities like merging tables,

data cleaning, report writing, formats, functions etc

. Experience in using SAS to read, write, IMPORT and EXPORT to another

data file formats, including delimited files, Spreadsheet, Microsoft

Excel and access tables.

. Ability to work on multiple tasks and strong interpersonal, analytical

and presentation skills.

. Accustomed to working in challenging environments under deadlines,

excellent analytical, and problem solving skills.

Technical Skills:

SAS Skills SAS (BASE, ACCESS, MACRO, SQL, STAT, GRAPH, ODS

and Functions)

Languages C/C++, SQL, HTML, XML

Databases MS SQL Server, MS-Access.

Applications MS Office, Mackintosh, MS Visual Basic 6.0,Adobe

Photoshop, Adobe Page-maker,

Operating Systems Windows 2000/XP/Vista/7, UNIX

Educational Qualifications:

. B.S. Financial Engineering Dongbei Univ. of Finance and Economics,

China

Certification & Language:

. SAS Certified Statistical Business Analyst Using SAS 9: Regression

and Modelling

. SAS Certified Advanced Programmer for SAS 9

. SAS Certified Base Programmer for SAS 9

Professional Experience

American Express, NYC

2013.11 - Till Date

Global Merchant Service- Risk Mangement and Finance

SQL/SAS Analyst

Roles & Responsibilities:

. Develop and operate scanners to predict and prevent credit and fraud

risk from merchants

. Created UNIX scripts to transfer output data from two environments.

. Graphying and presenting weekly updates on high-risk merchants

referred by scanners, and design plans to increase hit rate of

scanners

. Attending weekly phone conference with Amex's third party partner-

Victrio to listen their weekly report and analysis and send feedbacks

to improve collabaration

. Leverage graph & network theory and advanced visualization tools to

create risk triggers and rules

. Work with large volumes of structured and unstructured data from

databases, including text mining and data cleaning to perform risk

management concerned analysis

. Design the blueprint of next generation of risk management science &

infrastructure

Environment: SQL Server, SAS 9.1.3/9.2 (Base, Macros, SQL, SAS Functions &

Procedures), UNIX, PuTTY

American Express, NYC

2012.11 - 2013.10

SAS Analyst

Roles & Responsibilities:

. Used SAS/ACCESS to extract data from different relational database

management (ORACLE and SQL SERVER) systems using SAS.

. Built programs to extract data, performed data entry, conversions,

validation and corrections.

. Created new datasets from raw data files using import techniques and

modified existing datasets using Set, Merge, Sort, Update and

Conditional statements.

. Created base macros to run reports.

. Created permanent formatted SAS data sets for present and future

analysis.

. Generated high quality reports in the form of listing, HTML, RTF and

PDF formats using SAS ODS.

. Extensively used Data _Null_ and SAS procedures such as Print, Report,

Tabulate, Freq, Means, Summary and Transpose for producing ad-hoc and

customized reports and external files.

. Worked on SAS Data integration studio in sql join and sql sort

transformations and managed the status of jobs and transformations.

Environment: SAS v 9.1, SAS/Base, SAS/STAT, SAS/Macros, SAS/DI STUDIO, DB2,

Windows, UNIX, MS Excel.

Greenwich Equity Group, Greenwich CT 2010.8-

2012.10

SAS/MS-Excel Data Analyst

Roles & Responsibilities:

. Calculated VXX (VIX Short-term Future Index) historical value beyond

its inception date back to May, 2004 and helped design an ongoing

index conversion interface on Google Drive for trading purpose

. S&P Trend Analysis by analyzing relationship between S&P 500 with

Nikkei, FTSE, CAC, Hang Seng etc

. Worked with Barclay- ETN team to figure our calculation of VXX

. Used SAS and Excel to generate report to evaluate and compare model

built by our team with the realistic VXX index

Environment: SAS 9.1.3/9.2 (Base, Macros, SQL, Graph, ODS, Stat, SAS

Functions & Procedures), Windows, MS-Excel

Bank of Montreal (BMO), Shanghai Branch 2009.1-

2010.6

Data Aanlayst /reporter

Roles & Responsibilities:

. Generated credit assessment report for China National Cereals, Oils

and Foodstuffs Corporation (COFCO) in Loan Product Group (LPG). Tasks

include Financial Analysis, industrial research, Macroeconomic

analysis

. Entering customer data into our team's database and query to generate

performance report on a weekly basis to summarize weekly performance

and analyze fluctuation using SAS/SQL

Environment: SQL Server, SAS 9.1.3/9.2 (Base, Macros, SQL, Graph, ODS,

Stat, SAS Functions & Procedures), Windows.

Contact this candidate