SAS Data Analysis and Data Management

B INGQIAN SI, M.P.M., B.S.E.

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

White Plains, NY 10606 224-***-****

S U M M A RY

A Data and Business Analyst with proven project management capabilities able to deliver robust, accurate insights and build statistical

models to drive the performance of an organization. Capable of identifying key opportunities where analytics can influence and

improve processes. Familiar with translating insights from complex analysis into simplified terminology for both technical and non

technical audiences. Proficient in English and Chinese allied with demonstrated knowledge of business solutions, document control

systems and procedures, and data management. Expertise in multiple forms of SAS programming, data cleansing, data archival, data

migration, and reporting. Comfortable working in fast paced and pressurized environments to stated timeframes.

Extensive SAS working experience in analysis, design, development in financial industry and business areas.

Strong skilled in SAS/BASE, SAS/STAT, SAS/MACRO, SAS/ACCESS, SAS/SQL in SAS 9.

Experienced in importing raw data with PROC IMPORT, INPUT Statement and INFILE Statement.

Experienced in SAS data extraction procedures, importing and exporting techniques by using SAS/SQL, SAS/ACCESS.

Strong background in designing and developing SAS code with high efficiency, maintainability and readability.

Advanced skills in data quality management and data cleansing with PROC SUMMARY, PROC FREQ, PROC MEANS,

PROC SORT, PROC UNIVARIATE as well as some DATA steps like ARRAY, MERGE, SET, etc.

Strong skilled in generating report with SAS procedure including PROC PRINT, PROC REPORT, PROC SQL, PROC

TABULATE, PROC FORMAT, PROC CONTENTS, etc.

Strong skilled with SAS/ODS to generate different forms of reports including RTF, HTML, PDF and MS Excel.

Experienced in querying, modifying and manipulating data, deleting duplicates, applying formats and labels with PROC

SQL.

Experienced in developing and debugging SAS/MACRO to extract, modify, merge and analyze data as well as generate

analysis output.

Experience of Oracle Database and SAS Developer.

Solid background in performing business analysis like Customer behavior, Marketing Campaign and Risk Management.

Accomplished Kellogg business courses: Business Strategy, Strategic Management in Non market Environment, and

Understanding Media and Content.

Proficient in Microsoft Office Suite w/ advanced.

TECHNICAL SKILLS

SAS Skills: SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/ACCESS, SAS/ODS.

Language: C, C++.

Design Tools: Microsoft Office Suite: Word, Excel, PowerPoint. MatLab, PowerWorld.

CRM Tools: Salesforce, LinkedIn.

OS: Windows 7/8, MAC OS X

EDUCATION & CERTIFICATIONS

Master’s Degree: Project Management – Northwestern University, Evanston, IL (2014)

BINGQIAN SI Resume, Page 2

Bachelor’s Degree: Electrical Engineering – North China Electric Power University, Beijing, China (2012)

Outstanding Graduate Recognition & Honorable Mention for Mathematical Contest in Modeling

Certifications: SAS Certificated Advanced Programmer for SAS 9

SAS Certificated Base Programmer for SAS 9

PROFESSIONAL EXPERIENCE

North Windsor, Princeton, NJ

SAS Analyst (2014.6 Present)

Participated in Customer Segmentation and Marketing Campaign Project, which is helping our client to grow business of

credit card by digging out more good performance customers.

Selected and extracted samples from a list of raw dataset according to the data mapping, eliminated duplicates, created a one

subject per row dataset with SORT and MERGE steps.

Established segmentation for the behavior of customer with PROC FORMAT based on their credit score. Applied this

segmentation on all selected samples.

Defined new variables and assigned different designated values to them based on campaign matrix using IF THEN DO

expressions in PROC SQL, and derived product information for each customer.

Performed data quality check with PROC MEANS and PROC FREQ for all numeric variables, focusing on minimum,

maximum, and missing values. Did correction for errors and marked missing value.

Checked data quality with PROC FREQ for all character variables. Found invalid and missing values. Corrected invalid

values and assigned supposed value to the missing ones.

Created a format to separate valid data from invalid data with PROC FORMAT. Applied this format to the whole dataset.

Checked formats for certain character variables. Manipulated irregular character value with SUBSTR function and

concatenation operator to correct them.

Defined a variable to calculate aggregate number of default with SUM statement and IF statement.

Created a Macro with keyword parameters of data cleansing process for future use, including PROC UNIVRIATE, PROC

PRINT and DATA step.

Split the dataset into 3 different percentages with DATA step as client required.

North Windsor, Princeton, NJ

SAS Analyst (2014.6 Present)

Participated in Risk Management Project and Basel 2 Project, which is helping our client enhance their risk management and

build a forecast model to predict delinquency asset, default portfolio and default time to achieve better performance.

Imported raw data into a new dataset with DATA step, and defined several new variables to calculate roll rate (RR) of

different time periods with LAG function.

Performed different calculations of RR for first appearance of every account and rest with First. automatic variable and IF

statement.

Calculated 3 month moving average analysis of RRs: For first appearance of every account, assigned missing value to all

RRs; For rest of the records, utilized SUM, LAG and N function to achieve moving average calculation. Discrimination of

first appearance and rest of the records was implemented by First. automatic variable and IF statement as well.

Converted original multiple row per account dataset into a one row per account dataset based on last step calculations. Only

kept the last record of every account with last. automatic variable and IF statement.

Selected, extracted and combined variables with PROC SQL. Eliminated duplicates with distinct option.

Kept the last month’s status of every account as an indicator to track whether a customer has charged off with IF statement.

Converted this character variable to numeric indicator 0 and 1 for further analysis.

Performed the time period: For charge off customers, calculated the time period from the beginning of study to the time that

they charged off with INTCK function; For non charge off customers, assigned a constant for this variable.

Performed logistic regression with PROC LOGISTIC and figured out the regression equation in order to find out the potential

relation between default behavior and the time period.

BINGQIAN SI Resume, Page 3

BLACKMORE PARTNERS, INC., Chicago, IL

Mergers & Acquisitions Analyst (2014.8 – 2014.12)

Managed all aspects of accounting and bookkeeping including research of proposed acquisitions, trend and competition

analysis, legal documentation reviews, and delivery of findings to senior management through Salesforce.

Fostered strategic partnerships with existing management teams and internal departments.

Coordinated a global and diverse portfolio of business enterprises through investment processes.

Collated data and research to advise on best practices for implementation of strategic initiatives.

Spearheaded the professional development of the Talent Acquisition Team and three interns.

Created work flows for company’s operation and compiled interns training process documents.

Managed company LinkedIn page and increased page view number by improve quality and content of postings.

Managed company Salesforce account, including creating categories and selections, importing clients’ portfolios, changing

items based on director’s preferences.

Provided recommendations at executive level following extensive profit and loss analysis.

Presented statistical results by using appropriate graphs, charts, tables and written reports.

JILIN ELECTRIC POWER & DESIGN INSTITUTE, Changchun, China

Engineering Project Manager Intern (2013)

Participated in an intensive training program in preparation for global projects pertaining to electric power system planning

and design, UHV transmission lines and substations, engineering consultation, environmental impact assessments,

geotechnical engineering, and EPC.

Served as a key contributor in translating Jordan Power construction project proposals in addition to bid analysis to streamline

vendor negotiations.

Administered quality assurance measures during reviews of electrical design documentation and assessment data for the

Power Distribution and Transmission Department.

Simulated and calculated power flows by using PowerWorld and MatLab.

Analyzed and interpreted significant results based on data summaries.

Involved in writing code using SAS/BASE and SAS/MACROS to extract data from excel tables, and generated SAS analysis

datasets, summary tables and statistical analysis.

Contact this candidate