SUMMARY

• SAS programmer with over 5 years of experience in analysis, design, development, and validating the applications.
• Solid experience and excellent command in various SAS procedures and tools like SAS/BASE, SAS/MACROS, SAS /SQL, SAS/ GRAPH, SAS/STAT, SAS/ODS, SAS Enterprise Guide, SAS/DI, SAS/VA, SAS/OLAP Cube Studio.
• Expertise in processing large datasets for data transformation and data modeling including data cleansing, data scrubbing, data profiling.
• Solid understanding and experience in proficient use of procedures like proc freq, proc means, proc report, proc contents, proc export, proc print.
• Expertise in storing and managing data in SAS files, merging SAS data sets, using ARRAYS and MACROS, SAS procedures (PROCs), PROC SQLs, SAS Formats and in - formats
• Proven skills in Data Cleansing, Data Archival, ad-hoc reporting and coding utilizing SAS on Windows
• Experience in using various MS office tools for analyzing, arranging and presenting data
• Strong experience in coding using SQL, Procedures/Functions, SAS macros.
• Experience in creating SAS programs and performed data validation on raw data sets and created data set for analysis
• Extensive experience in preparation of reports, tables, listings and graphs
• Experience in generating reports employing various SAS procedures like PROC PRINT, PROC REPORT, PROC PLOT, PROC CHART, PROC SUMMARY, PROC FREQ, PROC TABULATE, and PROC MEANS, PROC UNIVARIATE, PROC FORMAT, PROC TRANSPOSE and Data null .
• Possess a strong ability to adapt and learn new technologies and new business lines rapidly.
• Good verbal and written communication skills. Ability to work collaboratively across project teams having the capability to work independently or in groups.

TECHNICAL SKILLS

• Base SAS
• SAS/VA
• SAS/SQL
• SAS/Macros
• SAS/OLAP Cube Studio
• SAS/DI
• Minitab
• Witness-12
• AutoCAD
• SolidWorks
• MS Office Suite
• MS Project
• SQL.
• Operating Systems: Windows 7
• Windows 8
• Windows XP
• Windows Vista

PROFESSIONAL EXPERIENCE

Confidential, NYC, NY

SAS Programmer

Responsibilities:

• Extensively used different SAS procedures such as PROC SQL, PROC REPORT, PROC PRINT, PROCSORT, PROC TABULATE, PROC SUMMARY, PROC MEANS, PROC UNIVARIATE, PROC FREQ, PROC TRANSPOSE for data analysis and report
• Used PROC GCHART, PROC GPLOT for generating graphs such as piecharts, histograms,bar graphs, scatter plots from processed data
• Expertly created Macro programs to generalize various reporting needs, thus eliminating the need for creating multiple programs with prefixed values.
• Used SAS/ACCESS to extract, insert, delete, and update large datasets from ORACLE SAS DI Studio to load and transform tables from excel files
• Developed OLAP Cubes for hierarchy drilling down in SAS OLAP Cube Studio
• Generated and maintained reports using SAS Datasets and OLAP Cubes as sources in WRS
• SAS Visual Analytics for generating graphs such as pie charts, histograms, bar graphs, scatter plots from processed data
• Performed merging and joining of data using merge, set statements in data step methods and by using inner,outer joins, SET operators in PROC SQL
• Eliminated duplicate observations in the data set using NODUPKEY and NODUPRECS options in PROCSORT
• Used Match-merging to determine the insurance type and the claims filed by the customers based on theunique value of customer ID

Environment: SAS/BASE, SAS/SQL, SAS/MACROS, SAS/OLAP Cube Studio, SAS/VA, SAS/DI, SAS/ACCESS, SAS/STAT, SQL, Oracle, Windows XP

Confidential, Herndon, VA

SAS Programmer/ Analyst

Responsibilities:

• Extracted, updated and deleted data from MS SQL Server using SAS/ACCESS and SAS/SQL
• Used PROC IMPORT to convert raw data files in different formats to SAS data sets.
• Used PROC EXPORT to convert SAS data sets to formats specified by the end-user
• Created different types of prompts and filters using SAS Information Map Studio depending upon the end user requirements.
• Used SAS DI Studio to register tables and transform accordingly
• Generated reports using SAS WRS from SAS Datasets and OLAP Cubes as sources
• Read raw data files with missing values using TRUNCOVER and MISSOVER options
• Created SAS reports in external locations using DATA NULL statement with FILE and PUT statement.
• Generated reports using BASE SAS procedures - PROC PRINT, PROC TABULATE, PROC FREQ, PROCMEANS, and PROC SUMMARY.
• Created large data sets employing MERGE and SET statements in the data step
• Utilized SAS/ODS to create reports in PDF, RTF and HTML format
• Combined data vertically using SET statements, PROC APPEND, and SET operators in PROC SQL
• Combined data horizontally using data step merge and by using match merging, in-line views in PROC SQL
• Conducted extensive data checks to ensure the reliability of data
• Summarized and analysed data employing pivot table and pivot chart in Excel
• Performed several statistical functions using SAS/STAT procedures and created one-way and Multiway Tables Created mailing lists of targeted customers using PROC FORMS

Environment: SAS, SAS/BASE, SAS/ODS, SAS/GRAPH, SAS/ACCESS, SAS/STAT, Oracle, MS SQL Server, MS OFFICE

Confidential, Bloomfield, MI

SAS Analyst/ Programmer

Responsibilities:

• Used SAS and SAS Tools for pre-processing data, data analysis, statistical analysis, and created permanentformatted SAS data sets.
• Performed Data analysis, statistical analysis, generated reports, listings, and graphs using SAS Tools SAS/Base, SAS/Graph, SAS/SQL, SAS/Connect, and SAS/Access.
• Used sorting and merging techniques on the input data set for Data Preparation, to get the required outputand then writing the code using SAS tools.
• Developed routine SAS macros to create tables, graphs, and listings for inclusion in reports and maintainedexisting ones. Prepared data listings and summaries for statistical analysis.
• Developed reports using PROC REPORT, PROC TABULATE and DATA NULL for analysis.
• Designed statistical summary tables, graphs, and patient data listings using base SAS procedures likeprocsummary, proc Tabulate and SAS/Graph.
• Conducted and generated the Regression, Correlation studies, and Analysis of Variance (ANOVA) using Proc REG, Proc CORR, Proc GLM, Proc ANOVA.
• Performed data extraction from MS-Excel tables into SAS data sets.
• Analysed data through problem-solving. Performed data archival, Ad-hoc reporting, and coding utilizing SAS on WINDOWS.
• Converted ORACLE data tables into SAS data files using SAS SQL Pass-through Facility, and uploaded SAS data files into ORACLE tables using SAS Dbload procedure.
• Used Output Delivery System (ODS) facility to write custom safety and efficacy reports directing SAS outputto RTF and HTML files.
• Extensively used the SAS/ Macro facility to write weekly and monthly reports.

Environment: SAS 9.1.3, SAS/BASE, SAS/STAT, SAS/SQL, Oracle, Window NT.

Confidential, Boston, MA

SAS Analyst/ Programmer

Responsibilities:

• Converted MS-Word documents and EXCEL tables into SAS data sets.
• Created web reports in HTML format using SAS/ODS.
• Using SAS/STAT to perform analysis of variance for balanced or unbalanced designs, multivariate analysisof variance, and repeated measurements analysis of variance.
• Worked with Fraud Analytics to develop new and modify existing process documentation and templates inthe implementation of fraud risk controls and reporting.
• Provided insightful and analytic based recommendations that consider fraud exposure, customer service, and operational impacts.
• Written SAS reports to Excel, the SAS content server, HTML, and PDF
• Performed Data entry and conversions, data validation and corrections, uploading/ downloading data from/to a PC, statistical Data analysis, created permanent formatted SAS data sets for present/ future analysis.
• Created base macros to run reports. Created standard reports to use across studies and base programsto set up data.
• Developed SAS macros for data cleaning and Reporting and to support routing processing.
• Created and updated permanent SAS formats for future analysis and reports.
• Used SAS for pre-processing data, data analysis, generating reports, statistical analysis, and graphs.

Environment: SAS, SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS Macros, SAS/SQL, SAS/ACCESS, Windows.

Confidential

SAS Analyst

Responsibilities:

• Modified/developed SAS codes for data cleaning and Reporting and to support routing processing.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Identified problems with the data, if there were any, and also produced derived datasets, tables, listings, and figures, which analysed the data.
• Produced quality customized reports by using PROC TABULATE, REPORT, and SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
• Report generation using many SAS procedural statements and data null steps.
• SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analyzes.
• Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data.

Environment: SAS/BASE, SAS/SQL, SAS/ACCESS, MS Excel, MS PowerPoint, Window NT/2000