SUMMARY

• Over 7+ years of experience in Statistical Analysis Software (SAS) for developing and implementing various applications.
• Solid Experience and Excellent command in various SAS procedures and tools like SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/ CONNECT, SAS Enterprise Guide and SAS/SQL in Windows and UNIX operating systems.
• Solid understanding and proficient use of various procedures like proc SQL, proc report, proc freq, proc means, proc contents, proc dataset, proc append proc import, proc export, proc print, proc sort.
• 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 informats.
• Excellent command in writing complex script for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel and SAS on various environments.
• Proven skills in Data Cleansing, Data Archival, Data Migration, ad - hoc reporting and coding utilizing SAS on UNIX, 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
• Good analytical skills pertaining understanding a business domain coupled with excellent teamwork and strong communication skills.
• Good knowledge in software engineering methodologies
• Extensive experience in preparation of reports, tables, listings and graphs
• Strong leadership, interpersonal and oral/written communication skills
• Ability to work independently as well as collectively & willing to relocate

TECHNICAL SKILLS

Statistical Packages: SAS 8.x 9.x (Base SAS, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/ODS), SAS Enterprise Guide, SAS Information Map studio.

Databases: Oracle, Sql Server for Teradata

Languages: SAS, SQL, C, C++, Core JAVA, HTML, XML.

Platforms: Windows and UNIX.

Others: MS office, MS Visio, MS Project Management, VBA macros.

Version: SAS 9.2 to 9.4

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

SAS Programmer

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
• 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, PROC MEANS, 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 analyzed data employing pivot table and pivot chart in Excel
• Performed several statistical functions using SAS/STAT procedures and created one-way and Multi-way tables
• Created mailing lists of targeted customers using PROC FORMS

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

Confidential, Chevy Chase, MD

SAS Programmer

Responsibilities:

• Extensively used different SAS procedures such as PROC SQL, PROC REPORT, PROC PRINT, PROC SORT, PROC TABULATE, PROC SUMMARY, PROC MEANS, PROC UNIVARIATE, PROC FREQ, PROC DATASETS, PROC TRANSPOSE for data analysis and report
• Used PROC GCHART, PROC GPLOT and PROC G3D for generating graphs such as pie-charts, 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.
• Combined multiple raw data files to form a SAS Data set using the FILENAME statement with the FILEVAR= option
• Used SAS/ACCESS to extract, insert, delete, update data from ORACLE database
• Extensively used DATA NULL statement to generate raw data files, new macro variables and reports which were stored in external locations
• Created data set views and indexes to enhance the storage space requirements and CPU system resources
• 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 PROC SORT
• Used Match-merging to determine the insurance type and the claims filed by the customers based on the unique value of customer ID

Environment: SAS SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/GRAPH, SAS/ACCESS, SAS/STAT, SQL, HTML, Oracle, Windows XP

Confidential, Chattanooga, TN

SAS Developer

Responsibilities:

• Interacted with business users and gathered business requirements.
• Executed ad hoc data analyses in response to business requests.
• Maintain the in-scope applications production support levels for lights on door open(LODO)
• Monitoring production schedules/jobs
• Interfaced with the software development team to resolve production problems, investigate performance issue.
• Many production jobs were setup and coded from scratch.
• Scrubbing and sub setting data for the purpose of sustaining data accuracy as well as maintaining data quality; creating and selecting new variables.
• Monitoring the existing code performance and to change the code for better performance.
• PROC SORT procedure was used to sort data sets before applying the MERGE statement when merging various Oracle tables
• SAS data sets were constantly created and updated using the SET and UPDATE statements
• SQL joins procedure was used to join various data from different data sets across various databases
• Imported the spreadsheet data into the SAS using Proc Import procedure then generate the reports.
• Proc Export procedure is used for exporting the data from SAS to spreadsheets
• Frequently supplied audit reports to the Audit Team based on their queries using various SAS procedures which often included the DATA NULL data step.
• Generate customized reports as required per the formats provided by the vendor.
• Maintained routine SAS MACROS to create Audit reports, Waterfall reports and Final mailing lists.
• Provided required reports to parties concerned to generate the technical specifications and analysis of the data.
• Transferring files using FTP.
• Modified older programs with hard-corded data values with Macro programs to enhance the flexibility, reusability of SAS programs and also to reduce system resources.

Environment: SASBASE, SAS/MACROS, Subversion SVN, TWS,MS Office,DB2 9.5 on AIX, UNIX

Confidential

Statistical Analyst

Responsibilities:

• Modified data using SAS/BASE and Macros.
• Employed techniques like sorting and merging on the raw data sets and coded them using Proc SQL and SAS Macro facility to get the required output
• Prepared graphs using the modified data for business analysis.
• Creation of Data Sets on the Remote Server.
• Used shell programming to run weekly and monthly reports
• Used SAS/ACCESS to gather data from RDBMS like TERADATA.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Extensively used SAS/ Macro facility to provide reusable programs that can be conveniently used to update reports.
• Used SAS Data Integration Studio to develop various jobs processes for extracting, cleansing, transforming, integrating, and loading data into Data marts and Data warehouse database.
• Extracted data sets from server using PROC IMPORT and created datasets in SAS libraries.
• Coding SAS programs with the use of SAS/BASE and SAS/Macros for Ad-hoc reports.
• SAS scripts on UNIX are run, and the output datasets are exported into SAS.
• Maintained and enhanced existing SAS reporting programs for marketing campaigns.
• Maintained SAS statistical analysis for the products purchased every month.
• Run reporting programs and download the results into EXCEL and build pivot tables.
• Presented the results and statistical reports in PowerPoint for marketing staff.

Environment: SAS/BASE, SAS/STAT, SAS/SQL, SAS/MACRO, SAS/ACCESS, SAS/ODS, MS Access, Excel, TERADATA.