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
• Experience on SAS setup, coding, development, analysis, debugging, implementation and maintenance as a Programmer/Analyst with experience in Windows or UNIX and scripting or PC
• Expert at ETL (Extract, transform and load) the data from various databases, Excel files
• Extensive experience in SAS/BASE, SAS/MACRO, SAS/CONNECT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, SAS/SQL using FTP to remotely connect the files
• 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)
• Generate REPORTS, TABLES, LISTINGS, and GRAPHs (TLGs) using PROC FREG, PROC UNIVARIATE, SAS/GRAPH, PROC Tabulate, PROC Report, and Macros, in HTML, PDF, RTF formats using SAS output delivery system (ODS)
• Expertise 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 BDIW tools - 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
• Solid experience in slicing and dicing large datasets(>100M) using SAS indexes, SAS views
• Possess strong ability to quickly adapt to new applications and platforms
• Good team leader with strong analytical and communication skills

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
• Tableau

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

SAS Programmer

Responsibilities:

• Extensively used different SAS tools for data analysis and reporting.
• 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 database
• 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
• Created data set views and indexes to enhance the storage space requirements and CPU system resources
• Eliminated duplicate observations in the data set using NODUPKEY and NODUPRECS options in PROCSORT
• 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
• Developed SAS data set views, indexes to optimize the storage space and CPU resources
• Performed extraction, transformation and loading (ETL) of large tables from Teradata

Environment: SAS/BASE, SAS/MACROS, SAS DI, SAS WRS, SAS Visual Analytics, SAS/ACCESS, SAS OLAP Cube Studio, SQL, Oracle.

Confidential, Chicago, IL

Data Programmer

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, OLAP Cube Studio, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/MACRO, SAS/ODS, SAS/ACCESS and SAS/CONNECT, TERADATA, Oracle, SQL Server, Windows

Confidential, Herndon, VA

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, SAS/MACRO, SAS/SQL, SAS/GRAPH, ODS, ACCESS, R, MS SQL Server, MS Excel, and Windows

Confidential

SAS 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