SUMMARY

• Over 9 years of experience as SAS Analyst / Programmer in a SAS 9 environment with Sales Operations or Commercial experience in Pharmaceutical domain
• Over 10 years of experience with SAS v9.2, SAS Macro, Excel and VBA and 5 years of experience with Sales data (SP, SD, 867, 852 etc)
• Expertise with SQL procedures SAS MACROS, SAS processing on PC and UNIX systems.
• Solution for risk analytics and reporting using SAS Data Integration Studio 4.2.
• Used Data Integration Studio ETL and traceability features to ensure data validity and auditing for LOB reporting and compliance with Data QA standards.
• Maintained DI Jobs, scheduling, maintenance and enhancements. ETL procedures to combine all

TECHNICAL SKILLS

IBM: 2064 3090, 3083, 3081, 370, 4341, 4361, 4381, 3350, 3380, 3380 MASS STORAGE, 3390, 9000 - 121; OS/MVS/XA, DOS/VSE, MICS, BASE SAS, CAPTURE, IMS/VS, IMS DB/DC, CICS, BESTII, PL/1 COBOL, TSO, SMF, SMP, OMEGAMON, RMF, NFA, OS/JCL, ALC, SMP-E, SLR, MXG, CA PRODUCTS, SMS, SAS/DB2/SQL

SAS Enterprise Guide: ORACLE, Teradata, SAS, SAS/AF, PROC REPORT, ENDEVOR, MS ACCESS, SAS Data Integration Studio 7.1, SAS/GRAPH 9.4 SAS/STAT 14.2 CCAR Modeling

SAS BI using: OLAP processing with linking cubes and hypercube. AS Enterprise Guide 7, 1 SAS 9.4

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sas Internal Consultant

Responsibilities:

• Duties include Technical Support, Training, Liaison Between the Sas Admin Group and the Business User Community
• Work closely with the Sas Admin Group using Grid Monitor to monitor the activities of the Bi Business Users.
• Worked On The migration plans: Capacity planning of the new environment
• To upgrade from Sas 9.2 to Sas 9.4
• Evaluation of Enterprise Miner & Model Manager products
• Enterprise Guide 4.3 to Enterprise Guide 7.1. and migration from netezza to teradata platform.
• Developed training classes for the Bi Business users.
• Specializing in SAS automation and modularization of complex financial and quantitative models developed in MS Excel, MS Access, and R Language CCAR Modeling

Environment: SAS 9.3 EG 5.1 SAS Mainframe SAS Window Explorer, SQL, SAS 9.4 EG 7.1 SAS Mainframe SAS Window Explorer SAS/GRAPH 9.4 SAS/STAT 14.2 Performed Sas Coding Support And Training.

Confidential, Tamp, FL

SAS Consultant

Responsibilities:

• Migrated SAS Mainframe programs from Rel 8.2 to SAS 9.3 SAS Enterprise Guide 5.1.
• Converted Programs and trained users in SAS Enterprise Guide 5.1.
• Specializing in SAS automation and modularization of complex financial and quantitative models developed in MS Excel, MS Access, and R Language

Environment: SAS 9.3 EG 5.1 SAS Mainframe SAS Window Explorer. SAS SPDS, SQL, Worked with the business units to develop requirements gathering for present and future projects.

Confidential, Chicago, IL

SAS Consultant

Responsibilities:

• Developing application using SAS Enterprise Guide, and SAS Customer Intelligence.
• Worked with LOB subject matter experts and project team to integrate data into and end-to-end SAS Data Mart
• Worked with the business units to develop requirements gathering for present and future projects.
• Specializing in SAS automation and modularization of complex financial and quantitative models developed in MS Excel, MS Access, and R Language CCAR Modeling

Environment: SAS EG SAS, SQL, PC SAS UNIX SAS Mainframe

Confidential, Charlotte, NC

SAS Data Integration Studio Developer

Responsibilities:

• Developing application using SAS Enterprise Guide and SAS Customer Intelligence.
• Worked with LOB subject matter experts and project team to integrate data into and end-to-end SAS Data Mart
• Solution for risk analytics and reporting using SAS Data Integration Studio 4.2.
• Used Data Integration Studio ETL and traceability features to ensure data validity and auditing for LOB reporting and compliance with Data QA standards.
• Maintained DI Jobs, scheduling, maintenance and enhancements. ETL procedures to combine all Data and Meta Data components.
• Worked with the business units to develop requirements gathering for present and future projects, MatLab procedures, All Data warehouse used both DB/2 and Teradata Tables.

Environment: SAS EG, SAS CI, SQL

Confidential, Wilmington, DE

SAS Data Consultant

Responsibilities:

• SAS Data Consultant working on Pc SAS and UNIX systems processing financial market data.
• A data analyst performing critical market optimization for the Universe Analytics project
• There are two types critical processing that I perform, Monthly Universe Analytics Data Extraction
• Various ADHOC's for many users in the bank.
• This data is transmitted to our vender Epsilon that provides us with critical credit information that is vital for their important business requirements. We are one the only central processing units, obtain this information.
• This project consists of coding the new programs and modifying exiting program in SAS 9.2
• Maintained DI Jobs, scheduling, maintenance and enhancements.
• Worked with the business units to develop requirements gathering for present and future projects.

Environment: s: SAS 9.2 Base and Macros DB/2 Oracle, SQL, Sybase, and Teradata Data mining, Data Warehouse, and Data Marts, and SAS BI using OLAP processing with linking cubes and hypercube standards. UNIX Linux skills and support knowledge of Bank of American Data warehouse, Project used UNIX Scripting for scheduling of monthly reporting marketing reports.

Confidential, New York, NY

SAS and COBOL Consultant

Responsibilities:

• SAS and COBOL Consultant working with the MIS Business Marketing Group on numerous Product promotions and reporting. Maintain both Ad-hoc and production systems.
• Created and maintained Both COBOL and SAS programs using extensive JCL and catalog procedures.
• Performed training and guidance in SAS product methodology, these projects consist of coding the new programs in PC SAS 9.1.3, COBOL.

Environment: s: SAS Base and Macros DB/2, SQL, ORACLE mainframe Solaris and PC SAS 9.1.3 COBOL and JCL and TSO and Clist executions of batch production modules.

Confidential, Greenville, NC

SAS Consultant

Responsibilities:

• SAS Consultant working on converting current Mainframe Financial Systems to SYSBASE ORACLE BANNER Educational Systems, This project consists of coding the new programs in PC SAS 9.1.3.
• It involved development and system testing, using system test scripts and extensive reporting on the results. It also included developing regression test cases and Business objects.

Environment: s: SAS Base and Macros DB/2 ORACLE, SQL mainframe Solaris and PC SAS 9.1.3

Confidential, VA

SAS Consultant

Responsibilities:

• SAS Consultant working on the IBM/2064 using SAS REL 9.1 and SAS REL 8.02, DB/2, UNIX and SYBASE Data Warehouse environment.
• SAS, SAS/AF PROC Report and PROC tabulate with Millions of loan data.
• This project consists of coding, enhancements and documentations of The Cash Pooling System.
• It involved development and system testing, using system test scripts and extensive reporting on the results. It also included developing regression test cases, Clist executions of batch production modules.

Environment: SQL SAS DB/2 ORACLE