SUMMARY

• 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.

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

PROFESSIONAL EXPERIENCE

Confidential, Princeton, NJ

SAS Analyst

Responsibilities:

• 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.
• Participated in Risk Management Project and Basel 2 Project, which is helping 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 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 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.

Confidential, Chicago, IL

Mergers & Acquisitions Analyst

Responsibilities:

• Managed all aspects of accounting and bookkeeping including research of proposed acquisitions 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 of the Talent Acquisition Team and three interns.
• Created work flows for company’s operation and compiled interns 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 ps.
• Provided recommendations at executive level following extensive profit and loss analysis.
• Presented statistical results by using appropriate graphs, charts, tables and written reports.

Confidential

Engineering Project Manager Intern

Responsibilities:

• Participated in an intensive 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.