SUMMARY

• SAS analyst with over 7 years of experience in developing statistical analysis, building data warehouses and reporting applications in both the Financial Institutions and Telecommunications using SAS software
• Over three years of IT work experience including design and development experience of client/server and mainframe applications using DB2, Oracle, SQL, PL/SQL, and SAS on Windows NT, UNIX and Mainframe.
• Three years of experience in BASE SAS, SAS Macros, SAS Connect, SAS Graph, SAS ODS, and SAS SQL in Windows, UNIX and Main Frame environments.
• Extensive experience in creating SAS Datasets and manipulating the data for the preparation of reports, tables, listings and graphs.
• Extensive experience with concatenating, interleaving, and merging SAS datasets.
• Modified existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results.
• Performed statistical analysis of data and reporting with SAS under multiple platforms
• Proven skills in data cleansing, data archival, data migration, ad - hoc reporting, data validation and coding using SAS on various environments
• Very proficient in RDBMS concepts and expertise in using Oracle, Access, Teradata and SQLserver databases.
• Good analytical, problem solving and interpersonal skills. Ability to work in a team environment or independently and handle multiple tasks concurrently.

TECHNICAL SKILLS:

Operating System: Windows 98/2000/NT/XP, UNIX, IBM Mainframe

Database: MS-Access, SQL Server 2000/7.0/6.5, Oracle9i/10g, Teradata

SAS Skills: SAS/BASE, SAS/STAT, SAS/MACRO, SAS/ODS, SAS/GRAPH, SAS/SQLSAS/ACCESS and SAS/CONNECT

SAS Procedures: PRINT, MEANS, REPORT, SORT, FREQ, TABULATE, TRANSPOSE, IMPORT, EXPORT, SQL, COMPARE, REG, CORR, ANOVA, GLM, GPLOT.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SAS Developer

Responsibilities:

• Data transfer and conversion from one platform to the other to be used for further analysis (SAS to oracle, oracle to Excel).
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting data between SAS and SQL.
• Data manipulating by MERGE, APPEND, CONCATINATION, SORT and generated the reports.
• Data validation by checking data distribution and by comparison to a standard data.
• Used sql pass through facility and oracle dbload procedure for data transfer.
• Used SAS /Base to perform sorting, merging and updating and generated reports.
• Used SAS Macros to write re-usable code to produce recurring weekly and monthly reports.
• Extensive usage of DATA NULL for reporting purposes.
• Used SQL joins for improving the functionality of programs written using merge techniques.
• Wrote and modified SAS code in windows environment.
• Generated reports in PDF and HTML format using SAS ODS.
• Developed standard and custom data listings, summary tables, graphs.
• Extensively used statistical procedures like UNIVARIATE, SUMMARY, TABULATE, MEANS, GPLOTS and t-tests
• Generated, Compared and Updated the reports

Environment: SAS/BASE SAS/STAT, SAS/SQL, SAS/MACRO, SAS/GRAPH, SAS/ACCESS, SAS/ODS, UNIX, Oracle, SQL, MS Access, Excel, Windows.

Confidential, Waukegan, IL

SAS Analyst Programmer

Responsibilities:

• Loading DLT Tapes onto the server and converting the data (EBCDIC) in them to SAS Data sets using SAS Data steps.
• Used Proc Tabulate, Proc Report, Proc Mean, and Procsql to generate monthly statistical reports.
• Done Code Optimization using SAS Macros.
• Done Data conversion between SAS in Unix/Windows environments.
• Modified the programs by using SAS MACROS, as table driven rather than changing YYMM value every month in all programs.
• Converted external data (Flat Files, Excel spreadsheets etc.,) into SAS data sets and
• SAS data sets to Flat Files, Excel spreadsheets.
• Converted SAS Reports into HTML and other formats using SAS/ODS.
• Mentored Team Members in SAS related issues.
• Extracted data from Oracle, Excel and flat files into SAS Datasets.
• Wrote Oracle Database Triggers, Stored Procedures, Functions, PL/SQL Blocks.
• Used Explain Plan Utility for Optimizing SQL Queries.
• Used Oracle Materialized Views for Optimizing the SQL Query Performance.
• Collection of user requirements and development of technical specifications and provide documentation as applicable.
• Prepared flow diagrams and spread sheets showing how the sequence of the programs to be run.
• Extensively used ETL to load data from Oracle database and Flat files to Oracle datawarehouse.
• Created Informatica mappings with PL/SQL procedures to build business rules to load data.
• Develop applications, support production systems.
• Involved in different Team review meetings.
• Used change management system for documenting application/data base changes.

Environment: UNIX, Windows, BASE SAS, SAS/AF, SAS/SCL, SAS Macros, SAS/ACCESS, SAS Procs and SAS/SQL, SAS/GRAPH, SAS/STAT, SQL, PL/SQL, Oracle 8i, Informatica, SAS/Intrnet, Erwin, SAS CONNECT, SAS/ASSIST, SAS/ODS, ProcFreq, Proc Report, Proc tabulate, Proc Means, ProcUnivariate, Visio2000, Excel, MS-Excel.

Confidential, Melville, NY

SASProgrammer

Responsibilities:

• Wrote the programs in SAS and SQLto generate the reports.
• Created base macros to run reports. Creating standard reports to use across studies.
• Written base programs to set up data.
• Was responsible for data entry and conversions; data validation and corrections; uploading/downloading data from/to PC; statistical analysis of data for use in litigation cases; creating permanent formatted SAS data sets for present and future analysis.
• Data validation by checking data distribution and by comparison to a standard data.
• Prepared implementation plans, and test plan.
• Designed and Developed different report templates based on the user specifications.
• Created reports using ODS statements and PROC TEMPLATE to generate different output formats like HTML, PDF and EXCEL to view them in the web browser.
• Ran report programs and downloaded the results into EXCEL for data analysis.
• Produced Graphical reports showing PIE and BAR charts for analysis while providing the drill down capabilities.
• Used SQL and PROC SQL to work with DB2.
• Moved data sets across platforms from PC to UNIX and Vice Versa.
• Extensively used SAS/BASE, SAS/CONNECT, SAS/SQL, SAS/ODS, SAS/STAT,
• SAS/GRAPH, SAS/ACCESS and SAS/MACROS for programming

Environment: SAS 8.1, JCL, SQL, BASE/SAS, SAS/MACRO, SAS/ ACCESS, SAS/ CONNECT, SAS/ ODS, SAS/ SQL, SAS/ENTERPRISE MINER, MVS, AIX, Windows NT, SAS/REPORT, SAS/SQL SAS/STAT, UNIX, MS Access.

Confidential, Purchase, NY

SAS Developer

Responsibilities:

• Worked with merchant data and transaction data that consists of more than 100 million records
• Aggregated data from transaction level detail to product level detail and merchant level detail
• Extracted data from Netezza using korn shell scripts and created dat files on UNIX
• Used command line nzsql to query the database tables
• Converted raw data files into SAS Datasets using the SAS INFILE statement
• Extensively used PROC SQL, PROC SORT, PROC FORMAT and PROC FREQ
• Used SAS/MACRO facility to decrease the redundancy of extensively used SAS scripts and to increase the flexibility of the code
• 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 efficiency
• Changed SAS configuration file to resolve work space and utility space issues
• Used single threading for PROC SORT instead of multithreading to resolve utility space related errors
• Used stored macro procedures in building macros to facilitate other users to share the 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

Environment: SAS 9.1.3, SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ACCESS, IBM AIX 5.0

Confidential

SAS Officer

Responsibilities:

• Modified/developed SAS codes for data cleaning and Reporting and to support routing processing.
• Developed efficient, well-documented, readily comprehensible and modifiable SAS code using SAS/ Base and SAS/ Macro facility.
• Identified problems with the data, if there were any, and also produced derived data sets, tables, listings and figures, which analyzed the data.
• Produced quality customized reports by using PROC TABULATE, REPORT, and SUMMARY and also provided descriptive statistics using PROC Means, Frequency, and Univariate.
• Report generation using many SAS procedural statements, SAS/MACROS, and data null steps.
• 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/SQL, SAS/ACCESS, MS Excel, MS Power Point, Window NT/2000