SUMMARY:

• Over 6 years’ experience in analysis, design, development and testing in SAS.
• Strong experience in SAS/BASE, SAS/STAT, SAS/MACRO, SAS/ACCESS, SAS/SQL in Windows Environment.
• Experience in import raw data with PROC IMPORT, INPUT Statement and INFILE Statement.
• Hands - on experience of extracting data from database such as Oracle with SAS/ACCESS .
• Heavy experience in SAS data extraction procedures, import and export techniques using SAS/SQL, SAS/ACCESS.
• Solid background in design and develop 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 skills of generating report with SAS procedure including PROC PRINT, PROC REPORT, PROC SQL, PROC TABULATE, PROC FORMAT, PROC CONTENTS, PROC UNIVARIATE, etc.
• Strong skills with SAS/ODS to generate different forms of reports including RTF, HTML, PDF and MS Excel.
• Experience of query, modifying and manipulating data, deleting duplicates, applying formats and labels with PROC SQL .
• Experience in developing and debugging SAS/MACRO to extract, modify, merge and analyze data as well as generate analysis output.
• Experience of simple sampling, separate sampling and stratified sampling with PROC SURVEYSELECT .
• Rich experience in SAS Marketing Research and Business Analytics through data mining, optimization, neutral network, and decision tree etc.
• Proficiency in pridictive modeling using SAS Enterprise Minor to fit linear statistical regression models, logistic regression models, mixed models, time series analysis and modeling, apply the regression diagnostics and check the goodness of fit.
• Knowledge of logical and physical database design with Erwin .
• Experience of Oracle Database, Matlab and SAS developer .

TECHNICAL SKILLS:

SAS Skills: SAS/BASE, SAS/STAT, SAS/MACRO, SAS/SQL, SAS/ACCESS, SAS/ODS, SAS/GRAPH

Database Skills: Oracle

Language: SQL, JAVA

Design Tools: SAS Enterprise Minor, Erwin, MS Excel, Power Point, Word

PROFESSIONAL EXPERIENCE:

Confidential, Winnertech, NJ

SAS Programmer & Analyst

Responsibilities:

• According to the data mapping, selected and extracted samples from a list of raw datastes, eliminated duplicates, created a one-subject-per-row dataset with PROC SQL.
• With given requirement, established a segmentation for the behavior of customer with PROC FORMAT based on their credit score.
• For all numeric variables, performed data quality check with PROC MEANS and PROC FREQ, focusing on minimum, maximum, and missing values.
• With PROC UNIVARIATE, checked extreme values for the dataset and did correction to the errors.
• For all character variables, checked data quality with PROC FREQ. Found invalid and missing values. Corrected invalid values and assigned supposed values to the missing ones.
• Created a format to separate valid data from invalid one with PROC FORMAT. Applied this format to the whole dataset.
• 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 UNIVARIATE, PROC PRINT and DATA step.
• As instructed, split the dataset into 3 different percentage with DATA step.

SAS Programmer & Analyst

Responsibilities:

• Extracted data from different hospital database using SAS/Access, SAS/SQL and created data sets.
• Performed data cleansing, transformation and data quality as a part of ETL process.
• Identified patients and produced data listings, summary tables and reports using Proc Reports, Proc Mean, Proc Tabulate and Proc Freq for patients who could benefit from talking health care professionals about their conditions.
• Produced reports employing various SAS procedures like Proc Print, Poc Format, Proc Report, Proc Tabulate, Proc Summary, and Proc SQL .
• Used Proc Plot to make pictorial representation of the data relationships.
• Developed new macors, data listing, and report generation as per the suctomer’s requirements.
• Generated reports in DATA Step with line sizes, page breaks and page header & bottom messages.
• Developed and maintained standardized SAS Templates and Macro for requlatory submission reports.
• Written ODS SAS procedured to publish reports as HTML .

SAS Analyst

Responsibilities:

• Analyzed The preliminary statistics on the input variables by StatExplore function.
• With given the analysis, used transform function to reshape the highly skewed inputs.
• For transorfmed variables, produced a three-dimentional scatter plot with Exported Data function.
• Created the transactions segments by cluster function. Changed the default properties of Cluster node.
• Attached the Segment Profile function to the Cluster, interpreted the contents of the generated segment. Labeled each segment according to the generated profiles.

SAS Analyst

Responsibilities:

• Based on the given inputs, used transform function to reshape the skewed distributions.
• For regression model, established Data Partition function to separate inpits into training and validation parts.
• For all numeric variables, performed Impute function for the interval inouts with the input mean, added unique inputation indicators for each input with missing values.
• Applied Regression function with stepwise method for inout variable selection, and validation profit for complexity optimization. Showed the average profit versus iteration by iteration plot.
• Created Bucket, Bin and Optimal Discrete Regressions to describe the model. Generated average profit from Iteration Plot from each model.
• Assessed the collection of the above models by using Model Comparison function. Chose the best model based on average profit and ROC chart.