SUMMARY

• SAS Programmer/Developer with over six years of experience in Analysis, Design, Testing, Development and Validating the applications.
• Strong Knowledge in SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/BI, SAS/EG, SAS/GRAPH, AND SAS/STAT in PC and Unix environment.
• Created RTF, PDF, and HTML listings, tables and Reports usingSAS/ODS. .
• Excellent programming skills in joining, merging and extracting data from various databases using SAS/SQL and PROC SQL.
• Strong knowledge in dynamic programming and list processing using SAS/MACRO.
• Wrote lots of common macros that are used across multiple applications and saved the macros in permanent SAS catalog for reuse.
• Strong knowledge of Data steps, Proc steps like Proc Means, Proc Freq, Proc Report, Proc Tabulate, Proc Format etc.
• Strong knowledge on SAS BI like SAS Enterprise Guide, SAS Stored Process etc.
• Extensively used SAS Enterprise Guide to create and execute stored processes for the future use.
• Proficient on using SAS Enterprise Guide for accessing and manipulating different databases like Oracle,DB2, Teradata, Sybase etc.
• Extensively used SAS/SQL pass through facility to connect with relational databases like Oracle, DB2, Sybase and Teradata.
• Data validation and data cleaning usingSASprocedures with relational databases..
• Skilled in SAS programming, merging SAS datasets, preparing data, producing and validating reports, SAS formats, and Managing data.
• Basic Knowledge on SAS/STAT for data modeling and predictions.
• Expert in using report generating procedures like PROC CONTENTS,PROC PRINT, PROC REPORT, PROC TABULATE, PROC FORMAT, PROC FREQ, PROC UNIVARIATE, PROC SUMMARY, and PROC TRANSPOSE.
• Experience in using SAS/GRAPH procedures like PROC GPLOT, PROC GCHART and PROC BOXPLOT.
• Expert in using Data Null to create macros, customized reports, reports on external files and debugging SAS codes.
• Expert in using import wizard, export wizard, proc import and proc export to import and export data from excel spreadsheets and to excel spreadsheets.

TECHNICAL SKILLS

SAS: SAS V8, SAS V9, SAS/BI, SAS/EG 4.0 5.0, SAS DI studio

ETL Tools: Data Stage 8.1(Information Server)/7.5.2(Enterprise Edition) /7.1

Database: Oracle 10g/9i/8i, DB2, SQL Server, TeradataOffice ToolsMS Office, MS Access

Operating System: MS - DOS, Windows 98/2000/XP/Vista/7, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

SAS Data Analyst

RESPONSIBILITIES:

• Worked on a project named Online Banking with different kinds of offers like home page, sign in and sign off and other so many channels.
• Worked particularly on Audits and Quality control reports generating.
• Generated lots of Fancy quality control reports on colored excel to distribute for different teams for verification purposes.
• Wrote lots of Data Steps to access and manipulate data from different sources like Teradata, oracle and excel sheets.
• Used SAS/SQL to extract data from different databases and joining tables.
• Used SAS/ACCESS to access and manipulate different databases like teradata, Oracle etc.
• Extensively used SAS Enterprise Guide to connect to PC SAS and Unix SAS.
• Worked on a transformation project from SASDome to SAS Grid.
• Extensively used data step to access and manipulate data from different databases like Teradaat, SQL server, Oracle, DB2 etc.
• Wrote lots of common macros that are used across multiple applications.
• Generated reports in HTML, PDF or RTF formats according to business specifications.
• Used lots of report generating procedures like PROC CONTENTS,PROC PRINT, PROC REPORT, PROC TABULATE, PROC FORMAT, PROC FREQ, PROC UNIVARIATE, PROC SUMMARY, and PROC TRANSPOSE.
• Created ad-hoc reports and tables for information delivery and data management departments.
• Extensively used Data Null to create macros, customized reports, reports on external files and debugging SAS codes.

ENVIRONMENT: SAS V9, SAS/BASE, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/EG, MS Office Applications, Windows 2000, Windows NT, UNIX,TERADATA

Confidential, Plano, Texas

SAS Data Analyst

RESPONSIBILITIES:

• Created batch and interactive applications utilizing SAS/BASE, SAS/SQL and SAS/MACRO
• Worked on a Project named Confidential Auto Finance to select valuable customers for the Auto loans.
• Wrote lots of Data Steps to access and manipulate data from different sources..
• Used SAS/SQL to extract data from different databases and joining tables.
• Worked with huge data around millions records received from third party named Acxiom every week.
• Used SAS/ACCESS to access and manipulate different databases like Teradata, Oracle etc.
• Generated lots for HTML and Other types of quality control reports for the verification of our customer selection process.
• Extensively used data step to access and manipulate data from different databases like Teradaat, Oracle etc.
• Wrote lots of common macros that are used across multiple applications.
• Generated reports in HTML, PDF or RTF formats according to business specifications.
• Used lots of report generating procedures like PROC CONTENTS,PROC PRINT, PROC REPORT, PROC TABULATE, PROC FORMAT, PROC FREQ etc.
• Extensively used Data Null to create macros, customized reports, reports on external files and debugging SAS codes.
• Wrote lots of Common reusable macros and automated the BAU process.

ENVIRONMENT: SAS V9, SAS/BASE, SAS/STAT, SAS/SQL, SAS/GRAPH, SAS/ACCESS, SAS/EG, MS Office Applications, Windows 2000, Windows NT, UNIX,TERADATA

Confidential, Philadelphia, PA

SAS Programmer/ Data Modeler

Responsibilities:

• Migration of data from text files, Excel spreadsheet, Oracle and DB2 to SAS data sets using import wizard and SAS/SQL pass through facility.
• Analyzed various database containing sales, titles, account, region etc data of the releases of various titles.
• Experience in dynamic programming and list processing using SAS/MACRO.
• Actively involved in the analysis of Marketing and Sales data. Performed Retrospective Analysis on sales representative data to analyze and summarize the differences in amount of commission paid.
• Extensively used Proc Report, Proc Tabulate and ODS output to generate report as per the desire format.
• Read datasets with a lot of missing values using MISSOVER and TRUNCOVER options.
• Created new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update and conditional statements. .
• Extensive use of SAS/BASE and SAS/STAT for producing tables, listings, figures, and generating statistical reports
• Developed reports using Proc Reports, Proc Tabulate, and Data Null of clinical trials using base SAS procedures such as PROC SUMMARY, PROC TABULATE and SAS GRAPH.
• Used SAS/EG to access and manipulate different databases like teradata, Oracle etc.
• Extensively used SAS/CONNECT software to connect different operating systems with the networked computer.
• Extensively used Proc Report, Proc Tabulate and ODS output to generate report as per the desire format.

Environment: BASE SAS 9, SAS/GRAPH, SAS/STAT, SAS/MACRO, SAS/SQL, SAS/Access, SAS/EG, SAS/Connect, MS Excel, Windows, Oracle, MS SQL, TERADATA,DB2

Confidential, Dayton OH

Research Assistant

RESPONSIBILITIES:

• Performed statistical analysis like PROC REG, PROC ANOVA, PROC TTEST, PROC GLM, PROC CORR etc.
• Developed reports using PROC REPORTS, PROC TABULATE and DATA NULL .
• Developed efficient, well documented, readily comprehensible and modifiable SAS code using SAS/BASE and SAS/MACRO facility.
• Wrote lots of macros using SAS macro facility and using Data Null .
• Accessed various database to gather data, performed a table lookup and translated data values for meaning and readability using SAS/SQL.
• Downloaded data from Oracle, DB2 and Teradata using SAS/SQL pass through facility in to SAS to be analyzed and then exported to Excel for further analysis.
• Used SAS/EG to access and manipulate different databases like teradata, Oracle etc.
• Extensively used SAS/CONNECT software to connect different operating systems with the networked computer.
• Produced customized reports by using PROC TABULATE, PROC REPORT, and PROC SUMMARY and also provided descriptive statistics using PROC Means, PROC Freq etc.

ENVIRONMENT: SASV9,SAS/MACROS,SAS/GRAPH,SAS/STAT,SAS/SQL,SAS/BASE,SAS/EG, ORACLE, TERADATA,WINDOWS XP

Confidential, Erie, PA

SAS Programmer

RESPONSIBILITIES:

• Wrote lots of data steps to access and manipulate data from different sources.
• Used lots of proc steps for analyze and to produce customized reports.
• Developed reports using proc report, proc tabulate, and Data Null ..
• Wrote common macros that are useful across multiple tables.
• Performed statistical analysis like PROC REG, PROC ANOVA, PROC TTEST, PROC GLM etc.
• Developed efficient, well documented, comprehensible and modifiable SAS codes using SAS/BASE and SAS/MACROS.
• Used SAS/SQL to perform queries, join tables and to connect to different databases like Oracle, DB2 and Teradata.
• Worked on multiple projects simultaneously and meet the deadline as required. generated HTML, PDF, and RTF pages to publications to the internet using SAS/ ODS.
• Imported lots of data into SAS data warehouse using proc import and import wizard.
• Exported SAS data sets to different databases and external files using proc export and export wizard.
• Used lots of SAS/GRAPH to produce nice charts and plots.

ENVIRONMENT: SAS V8, V9, SAS/MACROS, SAS/GRAPH, SAS/STAT, SAS/SQL, SAS/BASE, SAS/ODS, SAS/EG,ORACLE, WINDOWS XP, TERADATA