SUMMARY

• SAS Programmer with 8+ years of experience in SAS development and testing with retail, financial & mortgage industries.
• Expertize in working with different SAS environments such as WINDOWS and UNIX.
• Adept in using SAS Enterprise Guide for performing day to day programming in SAS.
• Proficient in writing shell scripts for executing SAS jobs automatically on a timely basis.
• Expert hands - on knowledge of SAS/BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/ETS, SAS/ODS, SAS/SQL and SAS/OR.
• Extensive programming experience with SAS datasets and procedures such as PROC FORMAT, PROC TABULATE, PROC REPORT, PROC TRANSPOSE, PROC PRINT, and SAS/STAT procedures such as PROC CORR, PROC REG, PROC GLM, PROC ANOVA, PROC FREQ, PROC MEANS, and PROC UNIVARIATE.
• Hands-on experience in extracting data from DB2, ORACLE, Sybase, TERADATA, and SQL Server databases using SQL Pass through facility and also uploading data using SAS libname statement.
• Worked with the marketing team and analyzed marketing data using SAS tools to generate reports, tables, listing and graphs.
• Efficient in data manipulation and generating customized reports using SAS Data steps and procedures including Data NULL, PROC PRINT, PROC REPORT, PROC MEANS, PROC SUMMARY, PROC CONTENTS, PROC DATASETS, PROC FREQ, PROC FORMAT, PROC SQL, PROC TABULATE and PROC ACCESS.
• Experience in developing SAS Macros from scratch and developed application for data updates, data cleansing and reporting.
• Well versed with creating HTML, RTF and PDF reports for financial data using SAS ODS facility, PROC Report and SQL Pass through facility.
• Successfully increased portability of existing SAS programs and created new programs using SAS macro variables to improve efficiency and consistency of result.
• Successfully analyzed business logic and system needs to prepare dataflow diagrams and documentation.
• Adept in using statistical techniques such as ANOVA, regression analysis for data modeling.
• Also worked for Clinical Trials data like Demographic data, Generic Treatment, Population, Adverse Events (AE), laboratory data (lab data), Physical and vital signs following CDISC standards.
• Particularly adept in identifying technology solutions for business problems and implementing them.
• Result oriented, committed and hard working with a quest to learn new technologies and undertake challenging tasks.
• Excellent leadership, analytical and problem solving skills.
• Good communication and presentation skills.
• Go-getter attitude and a good team player.
• Enthusiastic to develop new skills in a dynamic environment.

TECHNICAL SKILLS

Operating System: Windows 98/2000/XP/7, DOS, UNIX AIX

Statistical Tools: SAS 8/9.1/9.2, SAS/BASE, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/SQL, SAS/ACCESS, SAS/ETS, SAS/ODS, SPSS, STATISTICA, SAS Enterprise Guide 4.1/4.2/4.3

Languages: C, C++, Java, SQL, PL/SQL, XML, HTML, DHTML, Java Script, VB Script and Shell Scripting

RDBMS: MS SQL Server 2000/2005, Sybase, Oracle 8i/9i/10g, Teradata V2R5/V2R6, MS Access 2003

MS Office Suite: Word, Excel, PowerPoint, Outlook, and Access

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis-MN

Sr SAS Programmer/Analyst

Responsibilities:

• Extracted the data from DB2 and Oracle using PROC SQL pass through facility.
• Extracted data from the Mainframe flat files using SAS, SAS SQL procedures and create SAS data sets.
• Worked with the Guest browser’s data and sales data that consists of more than 2 billion records.
• Used Common Table Expressions (CTEs) to improve resources usage and increase performance.
• Converted raw data files into SAS datasets using the SAS INFILE statement.
• Scheduled SAS jobs using CRON TAB Scheduler.
• Migrated the SAS code and SAS data sets from the old environment to new grid environment
• Extensively used PROC SQL, PROC TRANSPOSE, PROC EXPORT and SAS Macros.
• Used PROC RANK, PROC FORMAT, and PROC UNIVARIATE to analyze the guest spend and to do the guest segmentation.
• Used SAS/MACRO facility to decrease the redundancy of extensively used SAS scripts and to increase the flexibility of the code.
• Utilized SAS/ODS to create reports in PDF, RTF, HTML formats as per the user needs.
• Developed SAS code and created ad-hoc reports based on the given requirements.
• Created dash board reports and ad-hoc reports on weekly and monthly bases.
• Used EXCEL and VBA scripts to develop the ad-hoc reports.
• Extensively used QUERY ANALYSER to check data in the Data base (DB2) and run the SQL queries directly in DB2.

Environment: SAS 9.1.3, SAS 9.2, SAS-EG 4.2, SAS/BASE, SAS/SQL, SAS/OR, SAS/MACROS, SAS/STAT, SAS/ACCESS, MS-OUTLOOK, COBOL,JCL,DB2, and Oracle,Windows XP, Mainframe.

Confidential, Columbus -Ohio

SAS Developer

Responsibilities:

• Extracted data from different data warehouses, Teradata and SQL using SQL Pass through facility.
• Converted raw data files into SAS Datasets using the SAS INFILE statement.
• Used SAS/MACRO facility to decrease the redundancy of extensively used SAS scripts and to increase the flexibility of the code.
• Created SAS datasets for modeling environments.
• Responsible for manipulating, transferring and managing data in SAS.
• Handled the tasks of writing reports and data using UNIX platform.
• Extracted the data from mainframe environment.
• Extensively used PROC SQL, PROC SORT, PROC FORMAT, PROC FREQ, and PROC ANOVA.
• Stored formats in permanent catalogs to increase the reuse and portability of the formats.
• Used select/when statements wherever possible instead of if/then else statements to increase the efficiency.
• Used stored macro procedures in building macros to facilitate other users to share macro code.
• Decreased the run time of the existing SAS programs by eliminating redundant DATA steps by using WHERE statements instead of IF statements and using PROC FORMAT to format SAS variable values instead of multiple IF statements.
• Produced final reports and charts in excel to send to business users.
• Used Excel Pivot tables to summarize complex data.
• Creation of monthly financial reports.

Environment: SAS 9.1.3, SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ACCESS, SAS/STAT, SAS Enterprise Guide 4.2, Teradata, UNIX, SQL Server,Windows XP

Confidential, Mclean -VA

SAS Developer

Responsibilities:

• Extracted the data using SAS from different input sources and transformed the data according to the business requirements and generated the reports and load ready text files.
• Data was extracted from xml files, external input files into SAS datasets.
• Extracted data from Oracle, DB2 and Sybase databases into SAS using SQL pass-through facility.
• Applied the business rules to the SAS datasets using data and PROC steps.
• Created temporary tables in DB2 using LIBNAME statement.
• Generated the reports using SAS ODS TAGSETS.
• Created many reports to track the performance of the servicers related to data issues.
• Daily reports were run using Business Objects WEBI.
• Ad hoc reports were created using Business Objects.
• Documented every module in the project.
• Wrote shell scripts to automate the process.
• Macro code was written extensively to automate the SAS code.
• Created the Assessment report daily to track the performance of the servicers.
• Contacted the servicers for data issues.

Environment: SAS 9.1, SAS/BASE, SAS/SQL, SAS/ACCESS, SAS/MACROS, Oracle, DB2, Sybase, MS Outlook, COBOL,JCL, IBM AIX,Windows XP, Mainframe.

Confidential - VA

SAS Programmer/Analyst

Responsibilities:

• Extracted data from Oracle databases and flat files.
• Developed reports using PROC FORMAT, PROC REPORT, PROC TABULATE and DATA NULL for analysis. Used SAS/ETS to analyze time series data.
• Extensively used SAS/STAT to perform analysis of variance, multivariate analysis of variance, and repeated analysis of variance.
• Generated flowcharts using MS Visio. Conducted behavioral analysis with large data on various promotional campaigns to support the market research department.
• Effectively prepared performance reports and presentations. Successfully published monthly sales and payment trend reports on the company intranet using SAS ODS.
• Retrieved ORACLE tables with PROC SQL. Run weekly and monthly reports using SAS.
• Extracted Oracle tables from SAS and within Oracle by suing SAS/Access, and SAS/SQL.
• SAS/SQL was used for pre-processing data, SQL queries, data analysis, generation reports, and statistical analyses.
• Effectively worked with users to define business processes and information systems for supporting those processes.
• Developed reports for senior management and other departments using SAS tools and Excel.

Environment: SAS/BASE, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/GRAPH, Oracle 8, UNIX and Windows NT.

Confidential

Statistical Developer

Responsibilities:

• Involved in clinical trials, Data migration/extraction from flat files, excel, CSV, DAT and Oracle database.
• Provided output for the clinical study report using Output Delivery System (ODS).
• Used SAS/ODS for delivering output in different formats including HTML, PDF and RTF.
• Involved in creating the data specifications or flow charts to generate analysis datasets and validation macros.
• Worked with CDISC team to map analysis dataset into SDTM model according to FDA specifications.
• Involved in writing SAS program code using SAS/BASE, SAS/MACROS SAS/STAT to produce analysis datasets.
• SAS macros were successfully used to create new programs and modified existing SAS programs to make them portable as well as consistency of results.
• Extensive use of the SUMMARY, CONTENTS, TRANSPOSE, SORT, PRINT, SQL, GPLOT and GCHART procedures.
• Worked with all the necessary procedures that compile to NDA submissions.

Environment: SAS/BASE, SAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/ACESS, SQL, MS Office, ODS, Windows XP