SAS Consultant Resume Columbia, SC - Hire IT People

OBJECTIVE

SUMMARY

A SAS program analyst with over 5 years of industry experience in analysis, design and development.
Strong experience in SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACRO, SAS/SQL and SAS/ACCESS.
Expertise in analyzing and coordinating large volumes of data, generating reports, tables, listing and graphs.
Experience with optimized performance using data validating and data cleaning on large volumes of data using statistical procedure like PROC SORT, PROC FREQ, PROC MEANS, PROC CHART, PROC UNIVARIATE, PROC ANOVA, PROC GLM, PROC REG, PROC LOGISTIC and PROC ARIMA.
Experience in Ad - hoc programming for healthcare data management department.
Expertise in transforming data imported from disparate data sources into analysis data structure, using SAS FUNCTIONS, OPTIONS, ODS, ARRAY processing, MACRO facility, and storing and managing data in SAS data files.
Experience in cleaning and resolving data issues as well as merging data from different sources into a single integrated dataset.
Excellent ability to trouble shoots existing programs.
Possess strong ability to quickly adapt to new applications and platforms.
Highly motivated and energetic worker.
Effective ability to work independently and as a team member on group projects.

TECHNICAL SKILLS

SAS Tools: SAS/BASE, SAS/STAT, SAS/ACCESS, SAS/SQL, SAS/MACRO, SAS/GRAPH, SAS/ODS.

Database: ORACLE, SQL SERVER, DB2.

Operating Systems: Window98/2000/NT/XP, UNIX.

Languages: JAVA, C/C++, HTML/CSS, PHP, SQL/MYSQL, JSP, JAVASCIPT.

Office Tools: MS-OFFICE, EXCEL, ACCESS, WORD, POWERPOINT.

PROFESSIONAL EXPERIENCE

Confidential, Columbia, SC

SAS Consultant

Responsibilities:

Used SAS to extract and analyze Medicare data from DB2 warehouse to fulfill ad hoc reporting requests, sample and overpayment requests received from internal fraud analysts and law enforcement investigators.
Communicated with fraud analysts regarding the specifications of data analysis and reporting requests.
Monitored and updated internal report tracking application to reflect assignments and status of analysis and reporting requests.
Validated that Quality Control and ISO guidelines and standards were adhered to during the requirements review, programming, and delivery phases.

Confidential, Columbia, SC

Statistical Analyst / SAS Programmer

Responsibilities:

Worked extensively to generate SAS data sets, statistical reports, graphs and listings with SAS and company’s software.
Provided SAS programming in analyzing large volumes of marketing data, generating final study reports, tables, listings and graphs.
Performed data analysis and statistical analysis on the data sets using various SAS procedures.
Validated the data sets and comparing the results to that of source programmers output.
Developed software modeling tools written in JAVA, ORACLE PL/SQL and SAS.
Developed and maintained marketing mix models that quantified the impact of marketing activities on product sales.
Tracked and updated in market model performance.

Confidential, Columbia, SC

Statistician III

Responsibilities:

Extracted data from data server (DB2) using SAS/SQL facility and generate ad-hoc reports.
Maintained large health care data set, modifying and combing data from various sources in varying formats to create SAS data sets by using SET and MERGE statement.
Used SAS procedures to generate reports, graphs and listing.
Prepared new datasets for statistical analysis from raw data files and modified existing datasets using SAS SET, MERGE statements, SORT, UPDATE and FORMATS procedures, and SAS Functions.
Created complex and reusable SAS Macros and extensively used existing SAS Macros and developed SAS programs for data cleaning, validation, analysis and report.
Tested and debugged existing SAS macros.
Generated monthly and annual summary reports, graphs and listings using procedures including PRINT, REPORT, FREQ, MEANS, TABULATE, SQL, UNIVARIATE, GPLOT and GCHART.
Wrote programs in SAS to generate reports, creating RTF, HTML listings and listings using SAS/ODS.