SUMMARY

• An accomplished SAS Professional with more than 6 years of extensive IT experience.
• Experience with full development life cycle of a project from conception to rollout.
• Team player with excellent communications and interpersonal skills.
• Multiplatform SAS experience: Windows 98/NT/2000, UNIX, Mainframe, client/server environment. Used shell scripts and run SAS on background.
• Strong experience in SAS/BASE, SAS/MACRO, SAS/ODS, SAS/SQL, SAS/ACCESS, in WINDOWS and UNIX environments. Extensive experience in writing UNIX SAS and PC SAS code.
• Worked extensively on SAS Procedures and Data Step Programming to develop the process flow applications from Data Acquisition to Data Exploitation/Reporting.
• Modified existing/creating new SAS programs by developing SAS Macros to improve ease, speed as well as improve consistency results.
• Knowledge job control language (JCL), CLIST, or REXX to allocate and access mainframe files of various organizational types (VSAM, QSAM, ISAM. BDAM, PDS, tape, DASD, etc) to read the record by their format (FB, FBV, VB, etc)
• Active role in updating and migrating existing SAS environments to SAS9 and the efficiencies.
• Built an enterprise data warehouse / data mart with SAS Datasets and OLAP Cubes.
• Good knowledge of Data Modeling and Database Design.
• Automated processes and reports using shell scripting for invocation, SAS Macros
• Provided ADHOC reporting support by analysis and resolution to correct errors for QA.
• Extensive SAS procedure experience such as PROC SQL, PROC TRANSPOSE, PROC APPEND, PROC FORMAT, PROC SORT, PROC SUMMARY, PROC MEANS, PROC FREQ, PROC IMPORT, PROC EXPORT, PROC CONTENTS, PROC PRINT, PROC TABULATE, PROC REPORT, PROC DATASETS.
• Knowledge of data warehousing and business intelligence concepts, design principles Experience in RDBMS development including SQL, PL/SQL, languages.
• Extracted, Transformed and Loaded Customer data from internal/external commercial warehouse/marts to create structured datasets as per business requirements.
• Performed conversions and migrations of SAS technology(mainframes to unix) and custom solutions.
• Provided best practices related to ensuring security measures are established and implemented.
• Import and Export raw data files using SAS/ACCESS, SAS/SQL for database management systems including ORACLE, DB2 and MYSQL.
• Worked on mainframe JCL, Easytrieve and COBOL programming for maintaining and supporting legacy systems.

TECHNICAL SKILLS

Platforms: UNIX, Windows 98, 2000, NT, XP, MS - DOS,ZOS

Languages: SAS, Easytrieve, Cobol, JCL

Web Design: MS-FrontPage, HTML

Database: MS-Access, DB2, SQL Server 2000/7.0/6.5 MYSQL, TOAD, SQL Analyzer

SAS Skills: SAS V8.2, V9.1.3 V 9.2, SAS/BI and Enterprise Guide, SAS PC

IBM Mainframe: (OS/MVS, TSO, ISPF)

Utility packages: (DYL250, MARK IV, SAS, SPSS, TPL); experience with DB2 and SQL (QMF and SPUFI)

Tools: /Packages: MS Office, Putty, WSF2,SCM,PVCS,CVS.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

SAS Analyst

Responsibilities:

• Involved in Business Analysis and Systems Planning.
• Migration of data from text files and DB2 to SAS data sets
• Proficient in writing JCL.
• Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Generated reports by submitting JCL and monitoring weekly, Daily and Monthly Jobs.
• Played a major role in quick generation of Ad-hoc Business Analysis Reports and resolving data issues upon request.
• Developed SAS programs using SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS for statistical analysis and data display
• Developed custom reports using Data Null and Dynamic Data Exchange (DDE) technique.
• Connected to the different systems using FTP.
• Developed an Automated Quality Control System for Data Validation and data integrity.
• Used ODS statements and PROC TEMPLATE to create reports in style format.
• Involved in various Testing phases (Unit, System and Integration).
• Used SAS extensively to create ad hoc reports, match merge and created graphs by using SAS/GRAPH base.
• Used SAS Macros, PROC SQL to extract, sort; match test accounts and ODS to HTML, PDF and RTF.
• Familiar with ICD 10 Coding systems.
• Issue log maintained to track the Issues/Queries/Clarifications for each of the project.
• Implementation of Quality System Procedures.
• Ensured completion of the projects on schedule and within budget constraints. Monitored the projects from initiation through delivery SDLC that resulted in better control and organization.

Environment: SAS (V8.2), SAS/BASE, SAS/SQL, MVS/TSO using JCL, SAS/MACROS, SAS/STAT, SAS/GRAPH, SAS/ODS, HTML, DB2, MS-Excel, UNIX

Confidential, San Antonio, TX

Senior SAS Analyst

Responsibilities:

• Prepared and analyzed detailed workflow chart and diagram to illustrate sequence of steps that programs must follow and to describe input, output, and logical operations involved.
• Developed COBOL programs for various report generations.
• Developed DB2 stored procedures, views, tables.
• Performed Data entry and conversions, data validation and corrections, uploading/downloading data from/to a PC, statistical data analysis, created permanent formatted SAS data sets for present/ future analysis.
• Extracted raw data and created SAS data sets from data warehouse that are required for the project analysis.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII files by using Set and Merge for generating Reports and Graphs.
• Extensively used Data Null and SAS procedures such as PROC PRINT, PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS, PROC SUMMARY, and PROC TRANSPOSE for producing customized reports and external files.
• Developed numerous ad hoc SAS programs to create summaries and listings.
• Worked on SAS/Base, SAS/Stat, SAS/Access, SAS/Graphs and SAS/Macro, SAS /ODS, SAS/SQL, SAS/Reports.
• Extensive use of Data Null, Summary, Means and Freq procedures ascertaining quality and standards for the code changes made.
• Created base macros to run reports. Created standard reports to use across studies and created base programs to set up data.
• Used Base/SAS to perform sorting, indexing, merging data and generated reports.
• Converted MS-Word documents and Excel tables into SAS data sets
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Executed SAS programs in mainframe and developed Easytrieve programs for reporting purposes.
• Produced data listings, Summary tables and graphics for interim and final analysis and Publications.
• Used SAS for pre-processing data, data analysis, reports generation, statistical analysis and graphs.
• Conferred with manager and representatives of departments concerned with programs to resolve questions of program intent, data input, output requirements, and inclusion of internal checks and controls.
• Corrected statistical program errors, using methods such as modifying program or altering sequence of program steps.
• Wrote instructions to guide operating personnel during production runs.
• Analyzed, reviewed, and rewrote statistical specials programs to increase operating efficiency or to adapt program to new requirements.
• Compiled and wrote documentation of development and subsequent revisions.
• Created Business Requirements Documents which described business problems or opportunities that was achieved or facilitated by the development or enhancement of a software tool or system. These documents include valid context diagrams, activity diagrams, use cases, and functional and non-functional system requirements.
• Interfaced with business users to elicit information to support the creation of business requirements documents.
• As needed, worked with Business Systems Analysts to provide necessary oversight for major projects.
• Provided oversight, assistance and mentoring support for Business Systems Analysts to improve their performance.

Environment: SAS 9.2, SAS9.1.3, SAS v8, SAS/Access, SAS/BASE, SAS/Macro, SAS/SQL, SAS/CONNECT, SAS/Graph, MVS, SAS/SQL, Proc SQL, SAS/BI,MySQL,COBOL,DB2, Easytrieve

Confidential, Lynchburg, VA

SAS Analyst/ Mainframe developer

Responsibilities:

• Extract data from different data sources like UDB/DB2, Excel sheets, Delimited text files, Comma separated files, using SQL pass through facility and different data steps respectively.
• User defined Business Rules were applied to the extracted data and SAS data set was created. Different sources were merged using matching conditions. SQL Pass through Facility with DB2 and Proc SQL with necessary outer or inner joins was mainly employed in extracting data from different DB2 tables.
• Loading SAS data sets as a table onto DB2 using SQL pass through facility, library reference method or PROC DBLOAD, which is then used for UAT purpose to be tested by Business users.
• Validating data and creating a HTML report using different procedures like PROC FREQ, PROC MEANS, PROC TRANSPOSE, PROC DATASETS, PROC SORT, PROC COMPARE, PROC SQL, PROC REPORT etc. and SAS ODS facility.
• Used extensive SAS/Macros programming for producing multiple pdf documents using SAS/ODS facility and mail them using UNIX mailx option.
• Used macro statements like %if, %then, %else, %let, %put all to perform macro processing.
• Used iterative %DO, %GLOBAL, %INPUT, %LOCAL,%EVAL,%STR, %MACRO, %MEND statements, SYMPUT routine and SYMPUTN routine for evaluating various macro functions.
• High performance maintenance operations are performed using TERADATA over MVS (Z/OS), which aids in batch processing and multiload task did insert, update, and delete multiple tables or views or large number of rows.
• Modified existing SAS code for migration from V8 to V9 BI Environment.
• Responsible for providing Business Intelligence (BI) design, development and implementation, documentation and deployment of complex data architectures emphasizing Data Warehousing, Data Integration, and Data Management technologies.
• Migrated codes from SAS/INTRNET to SAS Stored Process.
• Worked on SAS stored procedure and ODS to build Web based applications
• Installed and configured the SAS V9 BI Architecture for the UNIX IBM-AIX environment
• Installed MS Office add ins for Microsoft Integration for the BI Architecture
• Responsible for identifying and validating business efficiency opportunities through data acquisition, data mining, and business analysis.
• SAS Macros were extensively used mainly for portability and repetitive tasks. Macro options MLOGIC, SYMBOLGEN, MPRINT, and MACROGEN etc. are used to debug the macro and macro variables.
• Rigorously used data step options like keep, drop, rename, compress as a part of storage efficiencies. Data set options if, where, missover, truncover etc. were used in reading raw data files.
• Used JCL statements like JOB, EXEC, DD PROC, PEND, COMMAND to instruct the system about its requirements and perform the operations.
• Used %SYSFUNC, its functions and options to update huge SAS data sets with a given small SAS data set. Open, close, fetch, varnum, getvarn, getvarc etc. were some functions used with %SYSFUNC.
• Outer joins and Merge data steps were extensively used in forming the data sets from different data sets.
• Match merging using merge statement with (in=) option was extensively used to find exceptions of loan numbers from different tables.
• PROC SURVEYSELECT was frequently used to extract random records from SAS data set
• PROC COMPARE was used to compare data sets and corresponding fields from SAS data sets.
• Developed the best practices approach for the Customer Marketing team access OLAP cubes.
• Automated processes and reports using SAS Web Report Studio, Portal, EG, SAS Macros
• Modified SAS technology and solution configuration settings due to ongoing IT infrastructure changes.
• Responsible for executing proof-of-concepts area of the SAS Intelligence Platform (i.e. DI, IDP, OLAP).

Environment: SAS 9.2, SAS 9.1.3, SAS v8, SAS/Base, SAS/BI, SAS/Access, SAS/Macro, MVS, SAS/SQL, SAS/Graph, SAS/STAT, SAS/Connect, Proc SQL, DB2,Report Studio, MVS, Query Studio, UNIX and CDE,COBOL,DB2, Easytrieve

Confidential, New Jersy

SAS /Mainframe Programmer

Responsibilities:

• Responsible for Reports such as Month to date reporting of applications, accounts and BTs by segment and Channel, Weekly program results for Direct Mail, Historical mail results by group, app type and price, using SAS procedures and SAS Macros.
• Responsible for Development and maintenance of SAS programs using base SAS, macros and data steps.
• Responsible for pulling data from Oracle and Db2 databases for report generation. Data is direct mail and telemarketing applications and accounts, acquisition services (mail cpps) and the channels (non-mail costs).
• Responsible for uploading data sets from PC SAS to UNIX and UNIX to PC.
• Generated reports using SAS data null and data manipulation using multiple files in SAS data steps.
• Responsible for generating budget plans, generating offer id’s using SAS and updating into database for marketing users.
• Developed SAS programs using SAS/base mainly sorting, merging, and data validation using Proc freq, proc means, proc compare, proc tabulate, proc sql etc.
• Responsible for pulling data for applications, accounts and balance transfers.
• Worked with Data Warehouse, and Mine for analyzing customer profiles.
• Performed Unit/Assembly/Functionality Testing according to requirements

Environment: SAS V8.2, SAS/BASE, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS PC, SASEG, MVS, UNIX, JCL, COBOL, Easytrieve, DB2, EXCEL and data mining.

Confidential, New York, NY

SAS Analyst/ Mainframe developer

Responsibilities:

• Responsible for Reports such as Month to date reporting of applications using SAS procedures and SAS Macros.
• Importing and exporting of data from and into SAS, MS Access and Excel.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII files by using Set and Merge for generating Reports and Graphs.
• Prepared new Datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, and Update, Formats, Functions and conditional statements.
• Worked with Statisticians in generating SAS analysis datasets, production of data listings, summary tables, and statistical analysis.
• Created SAS datasets in local SAS directory. Created SAS views from Oracle database tables using SAS/ACCESS and writing SAS programs using BASE SAS and SAS MACROS to create SAS reports.
• Extracting data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved the insurance data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
• Extensively used PROC Report and PROC Tabulate to create reports

Environment: SAS/ BASE, SAS/MACRO, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ACCESS, Ms-Excel, SAS/ODS, DB2, Unix, and Windows NT,COBOL, Easytrieve