SUMMARY

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

Professional Experience

Confidential

SAS Analyst

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

Confidential

SAS Analyst

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

Confidential

Mergers Acquisitions Analyst

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

Confidential

Engineering Project Manager

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