SUMMARY

• SAS developer with over 6 years of professional experience in working with SAS with strong emphasis on SAS programming for reporting, modeling, data analysis, and data manipulation for BI, Marketing, and Financial departments of large enterprises
• Extensive experience in SAS/BASE, SAS/MACRO, SAS/CONNECT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/SQL in Windows environment
• Utilized Enterprise Guide(EG) and its functionality to create project flows which could include aspects of data manipulation, summarization, frequency, sorting, recoding, filtering & querying, building expressions, listing or printing, joining multiple tables, distribution analysis and report generation to a variety of output formats
• Experience with VA Data Builder, VA Explorer and VA Designer, generating reports, graphs, and tables in SAS Visual Analytics (VA)
• Hands on experience in SAS programming for extracting, transforming and loading data from Flat files, Excel spreadsheets and external databases (MS SQL Server/ Oracle/ DB2) tables using LIBNAME and SQL Pass Thru facility
• Hands on experience working with Information Map Studio, Data Integration Studio and Web Report Studio
• Creating OLAP cubes utilizing usefulness of OLAP Cube Studio, creating calculated measurements and orders, drill - through, execution tuning, collections, part level measurements
• Extensive experience in SAS Programming, using Base SAS, Macro Facility, Proc SQL, SAS Procedures, SASFunctions, SASFormats, and ODS facility indata scrubbing, manipulation, and preparation to produce summary datasets and reports
• Solid experience in the creation of SAS data sets, Reports, Listings, Graphs, Tables, Ad-hoc reports and dealing with large datasets according to the Standard Operating Procedures (SOP) and reviewing CRF
• Knowledge of testing & training statistical models like decision trees, cluster analysis, non-parametric analysis, optimization and time series analysis
• Good experience in slicing and dicing large datasets using SAS indexes, SAS views

TECHNICAL SKILLS

• SAS/Base
• SAS/Macro
• SAS/Stat
• SAS/Connect
• SAS/ODS
• SAS/ACCESS
• SAS/ETL
• SAS /Graph
• SAS/OLAP Server
• SAS BI platform
• SAS EG
• SAS EBI
• SAS add-in MO
• SAS WRS
• MS-Access
• Oracle
• MS SQL server
• DB2
• Windows
• UNIX
• R
• Visio
• Microsoft Office
• Word
• Excel
• PowerPoint
• Outlook

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. SAS Programmer

Responsibilities:

• SAS DI Studio to load and transform tables from excel files
• Developed OLAP Cubes for hierarchy drilling down in SAS OLAP Cube Studio
• Performed statistical analysis for data management and reporting, and performed validation, including testing SAS code
• Experience in utilizing Web Report Studio and its usefulness to make web reports, use channels and prompts made inside of data maps, give report connecting, adjust report formats
• Used data step to derive analysis dataset from raw dataset using defined programming specifications
• Developed SAS data set views, indexes to optimize the storage space and CPU resources
• Cleaned data set for duplicate observations using NODUPKEY and NODUPRECS options in PROCSORT
• Performed extraction, transformation and loading (ETL) of large tables from Teradata
• Generated reports/graphs from processed data using SAS Visual Analytics

Environment: SAS 9.4, Windows, UNIX, SAS BASE, MACRO, GRAPH, STAT, SQL, ODS, MS SQL, MS Access/Excel, Oracle

Confidential, IL

Data Analyst

Responsibilities:

• Supported programming and analysis of healthcare data with an emphasis on complex SAS programs to integrate and analyze payer data from multiple sources.
• Performed statistical analysis for data management and reporting, and performed validation, including testing SAS code.
• Created SAS query along with ETL tools to extract, as well as process Healthcare Claims Data from different database into the SAS environment
• Used data step to derive analysis dataset from raw dataset using defined programming specifications
• Performed extraction, transformation and loading (ETL) from large Oracle, Teradata, DB2, MS/ACCESS tables
• Manipulated existing Oracle and Teradata tables by accessing the data using SQL pass through facility
• Prepared data listings, summary tables and graphs for analysis using SAS system
• Developed reports using PROC REPORTS, PROC TABULATE and DATA NULL
• Created reports in the style format (RTF, PDF and HTML) using SAS/ODS
• Responsible for the proper documentation and validation of programs/macros/procedures to produce the standardized data displays

Environment: SAS BASE, SAS/Enterprise Guide, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/MACRO, SAS/ODS, SAS/ACCESS and SAS/CONNECT, TERADATA, Oracle, SQL Server, Windows

Confidential, Plano, TX

SAS Programmer

Responsibilities:

• Working on checking Data quality by comparing current month data and previous month data or going back up to 3 years to check the same month’s data to reveal the similarities and variances in the data. The determination is usually based on checking differences in missing, mean, standard deviation, minimum and maximum values of the range of data
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update Formats, Functions and conditional statements
• Created complex and reusable Macros and extensively used existing macros in developing SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros
• Generated graphs using SAS/GRAPH and the SAS Graphics Editor
• Developed routine SAS macros to create tables, graphs and listings
• Used Proc REPORT to generate reports. Developed annual reports based on existing data
• Imported data from excel sheet for analysis in SAS
• Coded SAS programs for ad hoc jobs using Base SAS and SAS/Macros
• Converted Teradata data tables into SAS data files using SAS SQL 'Pass Through Facility,' and uploaded SAS data files into Teradata tables using SAS 'Dbload' procedure

Environment: Base SAS, SAS/Macros, SAS/SQL, SAS/Graphs, SAS/Stat, SAS/Reports, SAS/Connect, Windows XP, UNIX, Teradata SQL/Assistant, SAS BI, SAS Web Report studio

Confidential, Florham Park, NJ

SAS Programmer

Responsibilities:

• Performed PROC IMPORT/EXPORT procedures to import/export external excel files
• Data set options DSD, DLD, Truncover, Missover, If, Where etc., were used in reading raw data files
• Analyzing various tables using Data manipulation techniques like merging, appending, concatenating and sorting
• Developed and designed different SAS programs and SAS macros to analyze financial data
• Produced various reports like summary reports, tabular reports as per business requirements using PROC REPORT, PROC TABULATE, DATA NULL, PROC SUMMARY, PROC MEANS and PROC FREQ
• Handled large raw data files with high-volume data using FIRSTOBS, OBS, N options, SAS data steps, OPTIONS like Compress, Keep, Drop and other techniques
• Written R code to test and train linear and logistic regression models

Environment: SAS/Base, Macro, SQL, Graph, ODS, ACCESS,R, MS SQL Server, MS Excel, and Windows

Confidential

Business Analyst

Responsibilities:

• Developed SAS programs for statistical analyses and data displays
• Raw data was processed to create datasets in the required format and tabulated so as to easily analyze data then wrote code using SAS/Base, Proc SQL
• Data Analysis and graphical presentation for various summary reports using Base SAS and SAS/Graph facility
• Extracted raw data from excel spreadsheets and MS Access. Created input data sets and analyzed the data by creating graphs using the SAS/GRAPH facility
• SAS was used for pre-processing data, SQL queries, data analysis, generating reports, and statistical analyses
• Processed data collection to ensure proper quality of data. Maintained the daily error log for cleaning the data

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