SUMMARY:

• Base SAS programmer certified by the SAS Institute.
• Professional experience of over 6 yrs in data handling, statistical analysis and report generation in both Finance/Insurance and Clinical trial projects.
• Proven ability in data transformation processes including data cleansing, scrubbing, profiling and applying business logic rules to large datasets.
• Expertise in various SAS tools such as SAS/BASE,SAS/MACROS, SAS/SQL,SAS/ODS,SAS/REPORT,SAS/ACCESS,SAS/STAT,SAS/GRAPH,SASEG and SASETL on both PCSASand UNIX platform.
• Well experienced with extraction, transformation and loading data in to Oracle Tables using ETL and Data Warehousing procedures.
• Experienced in importing and exporting raw data files present in different formats (excel, comma, tab etc).Validation and modification of datasets usingSASprocedures like FREQ, SORT, SQL and MEANS.
• Performed Data Cleansing, Data Archival, and Data Migration, ad - hoc reporting and coding utilizingSASon both UNIX and Windows Environments.
• Extensive experience in generation of Tables, Listings, Summaries, and Graphs using variousSASreport generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC PRINT PROC TRANSPOSE, PROC SUMMARY, PROC GLM, SASArrays and null .
• Knowledge in SAS Enterprise Guide Software for reporting and analytical tasks.
• Extracted and manipulated data from Oracle data base using SQL Pass through facility.
• Well versed with SAS ODS and exported SAS datasets to different file types such as HTML, PDF, RTF and EXCEL.Statistically analyzed data using various models such as Analysis of Variance (ANOVA),Regression Analysis, Liner Models and Correlation analysis.
• Programming expertise in SAS on both windows and Unix environments in case of Ad-hoc reporting, data archival and problem solving skills.
• Skilled in creation of automated SAS programs to run batch jobs at command line.
• Develop the code to Read and Write the oracle tables and validated for quality check.
• Enhancing the efficiency of previously existing programs in terms of memory usage and control data storage space.
• Ability to work both individually as well as in a collaborative manner across project teams.

TECHNICAL SKILLS:

SAS Tools: SAS 9.1, SAS 9.1.3, sas9.1.2, (BASE, STAT, GRAPH, SQL, Access, CONNECT, ODS)

SAS Procs: Print, Means, Univariate, Correlation, Regression, SQL, Tabulate, Freq, Sort, Summary, Format, Import, Export, Transpose, Plot, Compare, Life Test, Gplot

Languages: SAS, SQL, PL/SQL

Database: Oracle, SQL, and MS Access.

Operating Systems: Windows 7, Windows 95, Windows 2000, MS DOS, UNIX AIX

Office tools: Word, Excel, Power Point, Visio

WORK EXPERIENCE:

Confidential, New York, NY

Sr. SAS Programmer

Responsibilities:

• Designed and developed SAS code in support of the Data Strategy which outlines the data movement between servers, PC to Server, inputting data.
• Created reports for presentation of enterprise level data using data across multiple data sources, exported reports using ODS in HTML, PDF and RTF format.
• Imported data using ProcSQL pass though facility from data warehouses, data marts, and a series reporting and analytics layers.
• Created analysis or derived datasets by accessing data that are required for analysis/reporting as per project requirements usingSAS/ACCESS andSAS/CONNECT.
• Checked the quality of the data by creating series of automated edit checks and validating data with the DATA dictionary.
• Created Listings and Graphs by using various procedures such as Proc Means, ProcFreq, and Proc Summary, ProcUnivariate, Proc Tabulate, Proc ANOVA, ProcGlm, Proc report and Proc Print.
• Used SAS PROC SQL to extract data from different relational database management (Teradata) systems. Used SQL Assistant to analyze and query from the Teradata DB.
• Extensively performed Data Cleansing during the ETL's Extraction and Loading Phase by analyzing the raw data and writing SAS Program and creating complex reusable MACROS.
• Extracted data from ORACLE and other relational databases for analysis by applying SAS/ACCESS.
• WroteSQL queriesto check data for different conditions like duplicate values and missing values.
• Extracted data from RDBMS oracle and SQL server to the SAS system.
• Performed Data entry and conversions, data validation and corrections, uploading/ downloading data from/to a PC.
• Used SAS for pre-processing data, data analysis, generating reports, statistical analysis, and graphs.
• Performed data sorting, merging and indexing using various SAS procedures.
• Effectively utilized PROC SQL, PROC FREQ and PROC MEANS for data analysis and generating reports.
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Ran Ad-Hoc Reports for various business requirements.
• Excellent experience in Oracle 8i, 9i, 10g, 11g on RHEL 4/5, Solaris 5, IBM AIX 5, HP UX 11i and Windows environment.
• Responsible for accurate and timely data analysis and submissions
• Programmed complex Macros as well as used tested and debugged existing macros as per requirements.
• Generated ad-hoc reports as per business needs under tight deadlines.
• Extensively worked on Oracle data base to manipulate the data by retrieve and update tables and views.Generated scripts for Data transformation and Data Loading (ETL) for Data Warehouse.
• Extensively worked on the ETL process using SSIS package.
• Generated various summaries and listings through ad hoc SAS programs.
• Part of the development and analysis of Periodic Forecasting Reports created using MS Excel and SAS tools.
• Used Proc FORMAT to customize the variables according to user-defined formats in printing reports. Created format libraries for global team usage.
• Designed test plans and tested SAS procedures before launching them into production environment.
• Performed thorough debugging and implementation of automated reporting process and scheduled batch jobs from both windows and UNIX.
• Transported SAS files across multiple platforms by creating SAS transport files and exported files as Excel, HTML, RTF and PDF output files using SAS ODS depending on Business requirements.

Environment: SAS 9.2, SAS/ACCESS, SAS/CONNECT, SAS/STAT, SAS/GRAPH, MS-ExcelMS-Access, ORACLE 9i, SSIS,UNIX AIX, HTML, Windows 7, Visual Basic

Confidential, Dallas, TX

Sr. SAS Analyst

Responsibilities:

• Performed statistical analyses and data mining on data using SAS and Oracle database in order to provide better consumer loans, recoverability, and marketing strategies.
• Using Import techniques to create new datasets from raw data files from different sources including excel.
• Used SQL pass through and Libname facility to convert large Oracle datasets to SAS datasets.
• Make necessary changes to existing datasets using a variety of SAS procedures such Merge, Set, Sort, Update, formats, functions and conditional statements.
• Developed and used pre existing SAS MACROS for Data Cleaning, Validation, Analysis, and Report generation.
• Involving in testing and debugging preexisting Macros.Extensively created graphs and plots usingSAS/GRAPH and theSASGraphics Editor.
• Developed routineSASmacros and automated SAS programs to create tables, graphs and listings.
• Extensively applied dataset merging, macro facility, Proc report, SAS functions, and SAS formats also to analyze data gaps for dollar amounts in the source system.
• Performed data analysis, data migration, data preparation, graphical presentation, statistical analysis, reporting, validation and documentation.
• Used SAS/Internet tool to fully integrate the SAS program with the web application.
• Used SQL and SAS PROC SQL Pass through Facility to work with Databases.
• Involved in migrating the Folders, Mappings, Sessions, Worklets, Workflows by using the Exporting/Importing and Copying options in Informatica Power Center.
• Developed and maintained ETL maps to Extract, Transform and Load data from xml files into the Enterprise Data warehouse.
• Extensively used reporting procedures to generate bi weekly, quarterly, annual reports based on existing data.
• Several SAS tools such as SASBASE,SAS/Stat,SAS/Access,SAS/SQL,SAS/Macro, and SAS/Graph were used as part of advanced modeling methods for the consumer lines and processing of loans.
• Performed tabulation counts, correlations and checked for dispersion using SAS programs.
• Analyzed data using SASBase procedures such as Proc FREQ, Proc CORR, Proc SORT and Proc MEANS.
• Create Unix Scripts to run multiple jobs in the batch mode and to automate jobs.
• Used SAS ODS to create output reports in various file formats such as RTF, PDF, and HTML.
• Used SQL queries to create SAS data sets and extract data from databases.
• Customization of reports using the Data Null technique.
• Performed regression analysis to analyze data and determine significant statistical factors.

Environment: SAS9.2,SAS/SQL,SAS/Graphs,SAS/Stat,SAS/Access, UNIX AIX,SASSQL,SASETL,SAS CONNECT, SASEnterprise Guide, Oracle, MS Access, Windows XP.

Confidential, Irvine, CA

Principle SAS Programmer

Responsibilities:

• Involved in the analysis of clinical data for various phases of clinical studies.
• Creation of analysis datasets, Summary tables, Listings, Graphs and Plots in accordance with the specifications of the study.Worked in collaboration with statisticians and modified the datasets and tables according the business requirements.
• Validated data and performed quality control check of the displays and datasets using different QC levels
• Worked with various domains. Extracted raw datasets from various data sources, modified and created specifications working with business users, created analysis and derived datasets.
• Involved in the development of Analysis Plan and reported production of individual and pooled data sets by combining data from various sources.
• Extensively worked on problem solving, data analysis, and complex report generations.
• Analyzed data using statistical procedures such as PROC MEANS, PROC UNIVARIATE, PROC FREQ and PROC PHREG for analysis.
• Validated of data presented in reports, listings and created edit checks for datasets to filter discrepant data extensively using various SAS techniques.
• Used Proc Compare for double programming to validate Tables, Listing and Analysis datasets.
• Generate Customized Reports using the Data Null technique.
• Created transport files, datasets and catalogs using CPORT and CIMPORT procedures.
• Importing and creation of datasets from text files and excel sheets and creation of analysis datasets.
• Produced output files in various forms such as HTML, RTF, Excel and PDF using SAS ODS.
• Create pooled datasets and modified them using SAS procedures for sorting, merging and concatenating data.
• Updated SAS macro library and SAS format library as per requirements for new projects and new analysis and debugged already existing departmental Macros.

Environment: SAS9.1.3,SAS/SQL,SAS/Graphs,SAS/Stat,SAS/Access, UNIX AIX, SASSQL,SASETL, SAS CONNECT, Oracle, MSAccess, Windows XP.

Confidential

SAS Analyst

Responsibilities:

• Gather data through various marketing strategies on credit cards by developing SAS Macro programs.
• Extract data from Oracle database using SQL pass through facility, Tagsets Excel sheets, MS Access, and Delimited text files. Import and export procedures were applied in these procedures.
• Extracted, merged the data from diverse sources using matching conditions and then upload in to the data warehouse based on user defined Business rules.
• Create SAS Reports using PROC REPORT, PROC TABULATE and load SAS data sets as tables into Oracle and SQL Server using SQL pass through facility, library method
• Extract data from Oracle database and flat files using Proc SQL, Proc Import andSASData Step. Programming using SAS and SQL to clean, validate, manipulate, and create reports based on existing strategies.
• Create ad hoc reports and standardize existing reports.Use of SAS ODS to generate output files and reports.Analyze large datasets and develop business strategies using various SAS tools such as SAS/BASE,SAS/SQL,SAS/ACCESS andSAS/MACROS.
• Update data on a weekly and monthly basis and maintain and manage the database and make changes when necessary.Analyzed credit card risk in order to determine prospective customers for new credit cards. Assisted the data services in the development of new business logic.
• Collaborated with fellow SAS programmers and attended project team meetings.
• Provided technical assistance, trouble shooting and attended project team members.

Environment: SAS9.1.3,SAS/Macros,SAS/Graph,SAS/Access, SAS/STAT,SAS/ODS,SAS/SQL, Oracle 11g, MS Excel, UNIX, Windows.

Confidential

SAS Data Analyst

Responsibilities:

• Collect and transform business requirements to SAS Code.
• Gathering the requirements from end users for designing quality checks and validation process
• Data extraction from the database using SAS/Access and SAS/SQL and other data servers using SAS/CONNECT.
• Generate datasets from raw data files using various input techniques in SAS/Base.
• Created permanent SAS datasets in standard locations by extracting data from Oracle database.
• Developed variety of reports using various SAS reporting procedures.
• Modifying data using SAS/BASE procedures, SAS/SQL and Macros.
• Implemented statistical procedures in SAS like PROC MEANS, PROC FREQ, and PROC SUMMARY. Conducts analysis and generate tables, listings and graphs using SAS.
• Create reports in PDF and RTF formats in accordance to the requirements.

Environment: SAS 9.1.3, SAS/ACCESS, SAS/STAT, SAS/GRAPH, MS-Excel, MS-Access, ORACLE 9iWindows XP

Confidential

SAS Developer

Responsibilities:

• Developed programs for creation of analysis datasets, Listings, Tables and statistics for clinical trial data according to the requirements.
• Wide use of PROC REPORT and NULL for generation of reports.
• Developed and reviewed protocol documents, Case report forms, Annotated CRF, Templates and Statistical Analysis Plans for Clinical Trials.
• Created and used MACROS as per requirements.
• Merged complex datasets and made necessary data changes.
• Ad-Hoc reporting for presentations and analysis of data using SAS ODS.
• Performed edit checks in accordance with the mentioned specifications.

Environment: SAS 8.2, SAS/MACROS, SAS/STAT, SAS/SQL, WINDOWS XP