PROFESSIONAL SUMMARY:

• A proven expert in Statistical Analysis Systems (SAS) development and analysis on SAS Enterprise Guide(SAS/EG), TSO/MVS Mainframe as well in a UNIX environment using Teradata, ORACLE and DB2 databases Specializing in the automation of SAS systems/applications.
• SAS 9.1.3, SAS 5.1 Enterprise Guide (SAS/EG), Enterprise Minor and Mainframe TSO/MVS using Batch processing (JCL).
• Extensive experienced in SAS/BASE, SAS/DB2/SQL, SAS/MACROS, SAS/ACCESS, SAS 9.3 on SAS Grid, SAS/BI tool, experience in SAS/STAT, SAS/ODS SAS Enterprise Miner, SAS Management Console.
• Experience in data extracting(ETL), MIS Reporting, data Conversion and manipulation, transformation, data cleansing and suppressions, data validation & error trapping, testing and loading large data sets into SAS from various applications/databases (Oracle, Teradata, DB2, SQL server, Access, Spread sheet, text files) and environments (windows, UNIX, TSO/MVS Mainframe).
• Extensive experience working with Business Partners, Statisticians, and key stakeholders to provide SAS programming Analysis of the Data, generating reports, tables and listings as well as creating project specifications.
• Extensive experience as a Business Analyst reviewing and understanding Line of Business for each client as well as developing business scenarios and writing BRD, program specifications, UAT testing, detailed test plans, test scripts, test cases along with expected results and capacity planning.
• Experience in UNIX Shell and Perl Scripting.
• Experience in Governance and Oversight (G & O) including Deep Dive Regulatory Compliance.
• Change Management tools/ management and work flow process.

TECHNICAL SKILLS:

HARDWARE: IBM 30XX

SOFTWARE: TSO / ISPF / MVS SPUFI, UNIX, SAS/EG, SAS/EM, SAS Management, Console, SAS/BI, VM / CMS, EXCEL, MS ACCESS, EZTRIEVE

LANGUAGE: SAS, SQL, UNIX script, COBOL I/II, JCL, SYNCSORT, Q - BASIC, Script, FOCUS, CLIST/DIALOGUE MANAGER, PL/1, PLC, RACF

DATABASE: Oracle, Teradata, DB2/SAS/SQL, DB2/QMF/SQL, OLAP DataMart IMS

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Senior Data Analyst/SAS Programmer Analyst

Responsibilities:

• Production support applications break fixes were immediately resolved as well as modifications/updates, MIS Reporting, ETL, Data conversion, manipulation and occasionally new applications were implemented using SAS/UNIX scripting, X Manager Reflections, Teradata, FUTRIX, Tableau.
• Fraud Analysis and strategy using SAS/SQL

Environment: BASE SAS, SAS/Teradata/Oracle/SQL, SAS/MACROS, UNIX, MS EXCEL

Confidential, Phoenix, AZ

Senior Data Analyst/ SAS Programmer Analyst

Risk Acquisition of Home Mortgage

• Lending division. Created and updated systems using SAS/EG, SAS/SQL, SAS/Macros, UNIX and Teradata base.
• Dealt with home mortgage loans that go through a systemic exception/variance process before being funded. write fraud strategy - SAS/SQL environment

Environment: BASE SAS, SAS/Teradata/Oracle/SQL, SAS/MACROS, SAS/EG, UNIX, MS EXCEL

Confidential, Memphis, TN

Senior Data Analyst/SAS Programmer Analyst

Responsibilities:

• Worked for Confidential as a contractor specializing in SAS/EG, UNIX utilizing Teradata base, SAS/SQL, SAS/Macros
• Updated existing systems using SAS/EG Utilizing XML and GUI online interface for reporting purposes.
• ETL, Data conversion and manipulation.
• Clients were able to access reports online from the SAS/XML interface.
• Dealt with nationwide global as well as international shipment transactions both historical and current. write fraud strategy - SAS/SQL environment

Environment: BASE SAS, SAS/Teradata/Oracle/SQL, SAS/MACROS, SAS/XML, SAS/EG, UNIX, MS EXCEL

Confidential, Phoenix, AZ

Senior Data Analyst/SAS Programmer Analyst

Responsibilities:

• Worked for Confidential as a data Analyst using SAS/EG and PC/SAS with extensive SAS/SQL and SAS/Macros.
• Applications are mostly ADHOC and semi production connecting to UNIX platform for Data extraction(ETL), Data conversion and manipulation
• The department is in charge of processing mailings for insurance claims, determining whether medication is still covered by CVS, changes in prescription, changes in pharmacies used in network etc.
• Vendor Transition from other networks to CVSCaremark. Following HIPAA guidelines. write fraud strategy - SAS/SQL environment

Environment: BASE SAS, SAS/Teradata/Oracle/SQL, SAS/MACROS, UNIX, MS EXCEL

Confidential, Richmond, VA

Senior Data Analyst/SAS Programmer Analyst

Responsibilities:

• Generate Dashboard Reports on Daily, Weekly and Monthly basis for various LOB using SAS/EG, SAS/UNIX, SAS/SQL,ODS/HTML accessing local data mart as well as DB2 database.
• Worked with Mortgage Foreclosure data.
• Dealing with Loss mitigation, Risk Management, HPCR, FNMA, FHLMC mortgage Data.
• ETL, Data conversion and manipulation using SAS/EG on UNIX
• Verify results via OLAP SAS/BI online applications connected to DB2 database.
• Also participated in UAT Testing before systems were placed in production.

Environment: BASE SAS, SAS/Teradata/DB2/SQL, SAS/DB2/, SAS/BI, SAS/MACROS, SAS/ODS/HTML, DASHBOARD, OLAP, UNIX, MS EXCEL

Confidential, Austin, TX

Project Lead/Sr. SAS Programmer Analyst

Responsibilities:

• Worked in the Global IT department.
• Updating, creating and automating existing system using SAS/EG and SAS in UNIX environment with extensive use of SAS/SQL.
• Created and updated files daily(ETL) that were automatically sent to users along with email notifications also converted and mapped files for future process.
• Also participated in UAT Testing before systems were placed in production.
• Project Lead in charge of Monitoring sales across the Globe tracking unauthorized sales (Grey Marketing) of HP products and coordinate responsibilities of other consultants on the project.

Environment: BASE SAS, SAS/EG, SAS/Teradata/Oracle/SQL, SAS/MACROS, SAS/ODS, UNIX, MS EXCEL

Confidential, Elk Grove Illinois

Sr. SAS Programmer Analyst

Responsibilities:

• Dealing mostly with Mortgages that were Repurchased, Sold or took a loss.
• Participated in ETL, Data conversion and manipulation.
• Created, updated as well as automated systems using SAS/EG 4.2 and SAS 9.2 in a UNIX Environment with extensive use of SAS/SQL.
• Created Forecasting reports that reflected Loans that were Conforming or Non-Conforming, Repurchased, took a loss or sold to Freddie Mac(FHLMC), Fannie Mae(FNMA), Government (GNMA, FHA) etc.

Environment: BASE SAS, SAS/Teradata/Oracle/SQL, SAS/MACROS, SAS/ODS, UNIX, MS EXCEL

Confidential, Tucson, AZ

Senior SAS Programmer / Data Analyst

Responsibilities:

• Responsible for the creation, automation and update of major system for the Customer Care Dept. of Confidential .
• Systems were written in SAS Base, SAS/SQL, intense SAS Macros using Oracle database on UNIX Platform.

Environment: BASE SAS, SAS/Teradata/Oracle/SQL, SAS/MACROS, SAS/ODS, UNIX, MS EXCEL

Confidential, Glen Allen, VA

Sr. SAS Programmer / Data Analyst

Responsibilities:

• Responsibilities include Updating existing Model Score monitoring tools, trouble shooting and resolving issues with other applications using SAS/EG/UNIX, SAS/EG/CITRIX and Tera database with extensive use of SAS/SQL.
• Decision Science department develops model scoring variables as well as data models for credit related systems.

Environment: BASE SAS, SAS/Teradata/DB2/SQL, SAS/MACROS, SAS/ODS, UNIX, CITRIX, MS EXCEL, SAS 9.1.3 Enterprise Guide, Mainframe TSO/MVS using Batch processing (JCL)

Confidential, Raleigh, NC

Project Lead SAS Programmer Analyst

Responsibilities:

• Responsibilities included creating and updating systems in SAS/EG. Lead programmer in charge of contractors off shore.
• Worked on SAS/BI tool Web Report, Data integration Studio. Worked with database Architects to develop CUBEs tailored for the department’s needs. These Cubes allowed new measures and dimensions to be created.

Environment: BASE SAS, SAS/Teradata/DB2/SQL, SAS/MACROS, SAS/ODS, SAS/BI, UNIX, MS EXCEL, SAS 9.1.3 Enterprise Guide

Confidential, Phoenix, AZ

SAS Data Analyst

Responsibilities:

• Responsibilities included creating, updating, analyzing ADHOC programs using SAS in a UNIX/Exceed Humming Bird environment.
• Participated in ETL, Data conversion and manipulation.
• Create and analyze performance and time series reports to access the best criteria or solutions for loan campaigns. Analyze various processes and create best practice solutions.
• Automate processes that were initially ADHOC into a production type environment.

Environment: BASE SAS, SAS/Teradata/DB2/SQL, SAS/MACROS, SAS/ODS, UNIX, MS EXCEL, SAS 9.1.3 Enterprise Guide

Confidential, Phoenix, AZ

Lead SAS Reporting Data Analyst

Responsibilities:

• Responsibilities involved managing and supporting a production environment both onshore and offshore; communicating daily with users;
• Troubleshooting, testing, making necessary changes to enhance the capacity of processed data when an application goes down and recommend necessary changes to production application written in Statistical Analysis Systems (SAS) as well as ADHOC SAS/EG version 9.1.3 applications on UNIX /Citrix server platform accessing DB2 database.
• The production applications are basically Model Scoring for Quantitative Analysis. These applications involved extensive use of macros to generate new Data Models, update, as well as analyze existing Data Models on a monthly basis.

Environment: BASE SAS, SAS/DB2/SQL, SAS/MACROS, SAS/ODS, UNIX, MS EXCEL, SAS 9.1.3 Enterprise Guide, SAS Enterprise Miner, SAS Management Console.

Confidential, Charlotte, NC

Sr. Programmer Analyst/Data Analyst

Responsibilities:

• A Senior Consultant for the Market Research Department in Confidential .
• Responsibilities included managing ADHOC as well as Production projects from start to finish which involved assisting in the creation of specifications of each project (BRD)
• Analyzing the requirements and data availability as well as Capacity Planning then create programs using SAS, SAS/SQL in a WAP UNIX environment accessing Teradata/DB2 database as well as Oracle databases followed by testing, data regression, data manipulation and user acceptance.
• Completed Six Sigma, DTS, Sigaba training as well as BOA Compliance training which included Anti Money Laundering, Client Privacy and Technology Training. These trainings were prerequisites to handling data that was processed by the department. Identify High risk accounts using macro applications and suppressions routines to separate them from rest of the data.
• Created routines suppressions that complied with client privacy requirements.

Environment: BASE SAS, SAS/ODS,SAS/SQL, SAS/MACROS, UNIX, MS EXCEL, MS ACCESS, DB2, Teradata, SQL Server

Confidential, Richmond, VA

Sr. Programmer Analyst/Data Analyst

Responsibilities:

• A Senior Consultant in Credit Analytics Department of Confidential .
• Responsibilities included creating production as well as Adhoc reports using PC/SAS/SQL accessing DB2 as well as Oracle databases.
• Reports involved forecasting and analysis of various types of mortgage loans.
• Created Pivot tables, Charts and reports that showed statistical analysis of clients in specific demographic areas, income levels etc. at risk of foreclosure.

Environment: BASE SAS, SAS/ODS, SAS/SQL, SAS/MACROS, UNIX, MS EXCEL Charts and Pivot tables, MS ACCESS, DB2, Oracle database

Confidential

Sr. Programmer Analyst

Responsibilities:

• Responsibilities included creating reports based on analysis of previous year’s Campaign Initiatives to reflect trends and profitability.
• Quantitative Analysis was done on data from Amex SEIMS database.
• Extractions were done using DB2/QMF/SQL then reports were created based on the data extractions using SAS/SQL on TSO/MVS.

Environment: BASE SAS, SAS/ODS, SAS/SQL, SAS/MACROS, TSO/MVS Mainframe, MS EXCEL, DB2/QMF/SQL

Confidential, Phoenix, AZ

Sr. SAS Programmer Analyst

Responsibilities:

• Responsibilities included conducting analysis on existing insurance systems as well as create new adhoc reports for campaign processing.
• The reports were created using PC/SAS/SQL as well as SAS in a UNIX environment accessing DB2 Database.
• Troubled shoot problems that occurred on production applications.
• Interacted with users/statisticians on a daily basis as well as assisted in the creation of project specifications. The main purpose of these reports was to promote new insurance campaigns Ameriprise has to offer potential clients nationwide.
• Ameriprise offers Auto and Home insurance thus our applications were geared towards creating as well as maintaining systems consisting of individual clients who have either or both homeowners/Auto Ameriprise policies, signaling alerts for non-payments, renewal or actual claims etc.
• Statistical modeling was done to reflect how effective the campaigns were during certain periods.

Environment: BASE SAS, SAS/ODS, SAS/SQL, SAS/MACROS, UNIX, MS EXCEL, MS ACCESS, DB2

Confidential, Phoenix, AZ

Data Security Analyst

Responsibilities:

• Responsibilities included conducting analysis and updates of existing systems, created adhoc reports, built and implemented new systems that were moved to production as well as converted applications from one production environment to another.
• SAS. Applications were written in SAS/SQL, SPUFI on TSO/MVS, CA7/TSS and COBOL/DB2/SQL, using JCL.
• Conversions were also made on some of the CA7 to SAS applications.
• The functionality of the applications was for security purposes mainly geared towards user accessibility to the mainframe environment.
• Created reports based on User ID privileges on the mainframe using CA/TSS and SAS.

Environment: BASE SAS, SAS/ODS, SAS/SQL, SAS/MACROS, TSO/MVS Mainframe, MS EXCEL, DB2/SPUFI/SQL, RACF Security