SAS Programmer Analyst

Shirley Wu

** ***** ***** **, *******, CT *****

973-***-****

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

QUALIFICATIONS

Data Analytical Skills: A basic knowledge of statistics, SAS/R languages, SQL, Hadoop & MapReduce, database design, data mining, data cleaning and manipulating, data visualization and reporting.

Database Management Skills: Design a database schema, produce DDL and ER Diagram, ETL, SQL queries.

Data/Web Mining Skills: Data mining techniques such as association rule, classification, clustering, web mining and time series. Use JAVA implements apriori algorithm and decision tree.

Data Visualization Skills: Tableau Public, Excel/Vlookup, Excel/Pivot, Excel chart and graph, Excel functions.

System Analytical Skills: Agile Model, competitive analysis, problem statement, risk analysis and estimation of the system.

TECHNICAL SKILLS

Statistical Packages: SAS, Minitab, R, SPSS

Database Tools: SQL Server, Oracle SQL Developer, MS SQL

Programming Languages: SAS, SQL, R, JAVA

Others: Hadoop, SAP, Access, Excel, PowerPoint, Tableau Public, RapidMiner, Weka

PROJECTS

Data Analysis Project – Heart Disease Analysis (SAS, R, EXCEL)

Extracted and cleaned the data by using R and SAS.

Built statistical model by using linear regression analysis.

Programmed code for choosing the best model by using R and SAS.

Data Warehousing Project – Medical Claim Fraud Analysis (SQL, EXCEL)

Extracted and cleaned the data within the Teradata System by using SQL.

Designed DDL and ER diagram, and translated the ER diagram to a relational schema.

Developed the SQL Statements to detect and discover possible fraud.

Data Mining Project – Apriori Algorithm, K-Means, Decision Tree (SPSS, JAVA, EXCEL)

Used Java implemented Apriori algorithm and Decision tree.

Used SPSS evaluated and compared the model performance.

Data Visualization Project (Tableau Public, EXCEL)

Used Excel built Pivot table, summarized and formatted the variables to meet specific purpose.

Used Tableau Public built a nice dashboard and makes sure the visual components effective and intuitive.

Systems Requirement Analysis Project (Agile model)

Used Agile model, created a Computerized Library Management System with team members.

Completed competitive analysis, problem statement, risk analysis and estimation of the system.

WORK EXPERIENCE

Data Analyst 2015 Summer Internship

Office of the Mayor Newark, NJ

Used Excel and SQL tool Golden extracted, cleaned and modified the data.

Used Excel and analytical tool - CitiStat dashboard completed analysis (KPIs, Claims, Overtime Payroll etc.) for the purposes of management.

Assisted senior analyst completed CitiStat monthly report.

Data Analyst / Accountant July 2009 – July 2011

Samsung Electronics Suzhou LCD Co., Ltd. Suzhou, China

Used SAP System FI model to examine and control company expenses.

Assisted General Ledger management.

Extract/Upload data from COST Analysis System (SQL control).

Created monthly report by comparing and analyzing expense/cost data and provided financial information to management by using SAS/SQL and Excel.

Guided assistants on how to use SAP.

CERTIFICATION

SAS Certified Base Programmer Jan 2016

SAS Certified Advanced Programmer Feb 2016

Oracle Database 11g: SQL Fundamentals 1 Dec 2015

Oracle Certified Associate, Java SE 7 Programmer Aug 2014

EDUCATION

Master of Science in Business and Information System Sep 2014 - May 2016

New Jersey Institute of Technology GPA: 3.9/4.0 Newark, NJ

Bachelor of Science in Marketing Sep 2005 - Jul 2009

Harbin Institute of Technology - One of Top10 Universities China

Contact this candidate