SUMMARY

• 20 plus years information technology field experience providing technical solutions, programming, analysis and design, data mining/analysis/validation, unit and system testing, production validation, quality assurance and technical documentation.
• Solid experience as a technical lead/architect, providing programming and analysis using the SAS Software and various RDBMS which includes DB2, Oracle, Teradata, MS Access. Informix and Sybase on UNIX, Windows and mainframe platforms. Proficiency with Base SAS, ODS, SAS Macros and functions, SAS/Access, SAS/Connect, SAS/SQL, SAS/Graph, SAS Enterprise Guide 4.3. Very experienced with other softwares including COBOL, JCL, UNIX shell scripting, Gupta/Centura SQL Windows, PL/SQL.
• Experience with multiple platforms including PC, UNIX and MVS mainframe.
• Experience in performing some SAS Platform Administration tasks like adding users, libraries, SQL connection and registering tables into the metadata. Providing users SAS EG setup to access the SAS App metadata.
• Very strong skills in analyzing and interpreting various data and applications including Financial Services, Publishing, Utilities and Government reporting, on large volumes of data with over 700M records per table.
• A very efficient, effective team player who works well and delivers quality output under extreme pressure and tight deadlines with very minimal supervision. A very good mentor to team members who are junior to the team or someone from the business side.
• Recently completed the SAS Platform Administration Fast Track, SAS Business Intelligence Fast Track and SAS Data Integration Fast Track training courses at SAS Institute. SAS Tools learned are the DI and BI suite of products like Data Integration Studio, DfPower, Information Map Studio, SAS OLAP Cubes, Web Report Studio, Management Console, SAS Enterprise Guide in BI Platform and SAS Microsoft Add-Ins. Learned how to manage the Metadata Server environment thru SAS management console.

SKILLS SUMMARY

• SAS: BASE, GRAPH, Macros, Functions, SQL, Intrnet, Procedures, Data Step, ODS, SAS
• Connect, , SAS Enterprise Guide 4.2
• Through training at SAS Institute - SAS Data Integration Studio, DfPower, SAS Information Map Studio, Web Report Studio, SAS OLAP Cube, SAS Microsoft Add-Ins
• RDBMS: DB2, Teradata, Oracle, Informix, Sybase, MS Access
• SQL: SQL, SQL Talk, SQL Base, SQL Loader, SQLPlus, Gupta/Centura SQLWindows
• MicroStrategy, MS Excel Pivot Table, Fault Analyzer, DM Network Data Mover , Query Manager, Q E,
• QMF Report Windows, Rational ClearCase, ClearQuest, Visio
• MicroFocus/Merant Cobol, COBOL II, Workbench Tool, MVS JCL, MVS TSO, CICS, VSAM, FileAid, SYNCSORT, Expediter, AbendAid, ENDEVOR

EXPERIENCE

Confidential

Associate 7, SAS Technical Lead/ Architect Health Information Exchange BI/IM Analytics

• Responsible for providing SAS technical expertise in the Health Information Exchange in the BI/IM group of Wellpoint
• Created technical responses and requirements to business requirements that support the Health Information Exchange project.
• Responsible for providing technical solution by creating the Technical Design Document in using SAS in supporting the project that requires statistical approach as Risk Models are developed
• Manage a small group of SAS developers and ETL developer as they provide programming support for the project
• Develop and implement SAS and SQL programs using SAS Enterprise Guide 5.1, BASE SAS,PROC SQL, Teradata SQL, SAS Connect, SAS Access, macros and functions to support the implementation of a risk model to support the Affordable Care Act program in Wellpoint.
• Responsible for the quality of programs developed by the developers ensuring it follows the TDD and is efficient
• Created information flows of the proposed technical solution
• Worked closely with the data warehouse team and the business in gathering and understanding the data new and existing need for the project
• Attends regular HHS Health and Human Services Department seminars that talk about the regulatory requirement for the project.
• Environment: SAS Enterprise Guide 4.3, SAS 9.2 Macros, Procs, ODS, Graph, STAT, Base, Connect, Access, SQL, PC, UNIX , Teradata, Teradata SQL Assistant, ReflectionX, MS Excel, VBA, Windows XP/2008

Confidential

Consultant, SAS Application Architect Statistics Infrastructure BASEL II

• Responsible for providing data analysis, programming and reporting support to the Statistics Infrastructure BASEL Team at Capital One
• Develop, implement and maintain SAS programs using SAS Enterprise Guide 5.1, BASE SAS, SAS GRAPH, PROC SQL, Teradata SQL, SAS Connect, SAS Access, macros and functions to support the statistical modeling part of the BASEL II project.
• Work with other teams in the BASEL PMO to identify gaps analysis on data requirements as the statistical model and BASEL datamart is made available
• Work with the statistical modeling team to identify issues on the model code and to gain better understanding on the business intent.
• Environment: SAS Enterprise Guide 5.1, SAS 9.2 Macros, Procs, ODS, Graph, STAT, Base, Connect, Access, SQL, PC, UNIX, mainframe , Teradata, JCL, TSO, InfoConnect, Teradata SQL Assistant, MS Excel, VBA, IBM mainframe, Solaris, Novell, Windows XP

Confidential

Credit Metrics Analyst/SAS Analyst

• Responsible for the development, management and maintenance of the data feed presentation layer into a centralized repository called the Datashare that is currently used by the Credit Risk Department and other departments like Audit, Finance, Quality Control, Default. The data includes mortgage, economic data, credit card and student loans. The data processing is done in SAS as input sources varies from SQL to flat files to excel files and it's pushed into SQLServer.
• Part of the SAS Admin team responsible for developing and maintaining the metadata environment in the group. Provides technical assistance to the analytics users when using the metadata in the SAS EG. Some of the task include adding new users or groups, libraries, SQL connection to the metadata working with the Suntrust central SAS COE group to test new product installs like the Microsoft Add-Ins or the SAS EG 4.3.
• Responsible for providing data analysis and reporting support to the Credit Risk department for Mortgage and Student Loans LOB that involves some intensive data research and simulation
• Built reports used in the monthly earnings deck for the Credit Risk.
• Built automated SAS modules used to extract data from various sources, perform data quality checks, perform various transformations, and loads to SQL Server.
• Develop and maintains SAS programs using SAS Enterprise Guide 4.2, BASE SAS, SAS GRAPH, PROC SQL, SQL Server2005, DB2, SAS Connect, SAS Access, macros and functions to generate additional monthly reports needed for credit analysis of the mortgage portfolio.
• Provide data analysis support to different LOBs like QC, Finance or Audit or teammates as needed performing adhoc requests.

Environment: SAS Enterprise Guide 4.3, SAS Management Console, SAS Microsoft Add-Ins, SAS 9.2 and SAS 9.1.3 Macros, Procs, ODS, Graph, STAT, Base, Connect, Access, SQL, PC, UNIX, MVS Mainframe, JCL , SQL Server 2008 and 2005, DB2, Oracle, MS Access, MS Excel

Confidential

Consultant, Sr SAS Data Analyst for Small Business

• Responsible for providing data analysis, programming and reporting support to the Small Business Statistics Team at Capital One
• Develop and maintains SAS programs using SAS Enterprise Guide 4.2, BASE SAS, SAS GRAPH, PROC SQL, Teradata SQL, SAS Connect, SAS Access, macros and functions to retro-score credit bureau data for different risk and response models for Small Business and to dual validate the application stage models for Small Business.
• Develop SAS programs using SAS Enterprise Guide 4.2, BASE SAS, ODS, SAS GRAPH, PROC SQL, Teradata SQL, SAS Connect, SAS Access, macros and functions to pull various production data used produce HTML based reports that are used to monitor the population stability index and validity of the different risk and response models used in Small Business Card and Lending.
• Develop SAS programs, JCLs and shell scripts to validate data produced by the 3 credit bureaus and model scores that the outside vendor produced for the risk model for Small Business
• Develop various SAS programs, JCLs and shell scripts that extract data from different sources like datawarehouse which is Teradata environment, mainframe, and unix platforms using SQL-pass-thru, SAS Access LIBNAME, PROC CIMPORT and DOWNLOAD, JCL and Unix scripts.
• Provide data analysis and data management support from development to post production phase to all the statisticians in the Small Business Lending group as various risk or response models are developed. This is to ensure the correctness and quality of the data used in the models.
• Provide programming support to the Small Business and Solutions Lending team and other Credit card team members i.e. a total redesign of all the model monitoring report process for the Lending which included development of a more efficient datapull code and conversion from a manual Excel/Pivot tables to automated html based graphs process of producing the reports .
• Provide SAS support to different Line Of Business groups as needed
• Provide technical and business mentoring to team members who are junior to the statistics team or to someone from the business side whether it's SAS related or some business process.
• Provide assistance to the SAS manager as the need arises ie, she's on vacation to manage assigned projects effectively making sure each milestones are met on time, delegate business adhoc requests effectively to other 2 team members so as not to impact major projects' timelines
• Provide data management support to the Small Business and other LOB analysts such as creating SAS datasets, Teradata tables and/or flat files and develop various distribution reports using SAS scripts for their risk analysis use.

Environment: SAS Enterprise Guide 4.2, SAS 9.1.3 and SAS 8.2 Macros, Procs, ODS, Graph, STAT, Base, Connect, Access, SQL, PC, UNIX, mainframe , Teradata, JCL, TSO, InfoConnect, Teradata SQL Assistant, KEA X, MS Access, MS Excel, VBA, IBM mainframe, Solaris, Novell, Windows 2000

Confidential

Consultant, SAS Technical Analyst for PE Tax Conversion Project and MS Access Developer for the Securities Operations Redesign Project

• Analyze and gather data requirements based on TAS conversion requirements.
• Prepare technical documents including Business Requirements Specification, Rational Model Activity Diagram, Unit and UAT Validation test cases and scripts and Deployment diagrams supporting TAS conversion from development through testing to production.
• Develop technical design of process based on use cases.
• Develop SAS programs using BASE SAS, SQL-pass-thru, LIBNAME, PROCs, macros and functions and scripts JCLs or UNIX shell to extract from DB2 UDB tables, then transform and load these data back to the datawarehouse.
• Develop SAS programs using BASE SAS, SQL-pass-thru, ODS, macros and functions to generate reports that are delivered in HTML and CSV formats.
• Execute unit testing and technical support for Test Team ensuring standards are met.
• Liaison with Corporate Tax group endorsing integrity of design and technical requirements.
• Design and develop UAT Reports for Corporate Tax group validation of data accuracy and integrity.
• Perform initial technical OLAP analysis reporting requirement mapping on old and new system.
• Develop SQL queries to extract, insert or update tables and generated data reports for the Securites Operations Redesign project.
• Help identify control gaps and perform research and analysis on them
• Environment: SAS 8.2 Macros, Procs, ODS, Base, Connect, Access, SQL, mainframe , DB2 UDB, JCL, TSO, Hummingbird, DB2 Command Center, ClearQuest, Visio, Rational Rose, DOORS, MS Access,
• IBM mainframe, Solaris, Novell, Windows 2000

Confidential

Consultant, Senior IS Analyst for Global Finance, Information Management Control ALPS Project

• Perform all data requirements gathering and technical analysis for financial reporting process. Mapped old installment loan system with new SHAW system. Worked with global business users.
• Transformed data requirements into technical requirements for system development.
• Created technical documents Data/File Quality Checkpoints, Data Migration Strategy, Test Plans, Security Requirements supporting project transition from development through production phases.
• Designed/created high level, detailed reports on data requirements, user input/resource availability.
• Analyzed and wrote technical documentation to support production of financial reports used by Corporate Accounting, other global finance teams and various business groups.
• Provided analysis and programming support for development and implementation using SAS BASE SAS, ODS, PROC SQL, Macros and functions and MS Access.
• Business Group Coordinator ensured successful implementation of data, process, financial reports.

Environment: PC SAS 8.2 Macros, Procs, ODS, Base, SQL , Oracle, SQL, MS Excel, MS Office 2000, MS Outlook, MS Excel Pivot Table, Novell, WindowsXP

Confidential

Consultant, Senior Technical Analyst for OFHEO Historical Loan Performance Project

• Developed historical data and report processes for business group submission to Office of Federal Housing Enterprise Oversight. Designed and implemented prototyping and data modeling for each.
• Performed analysis, developed SAS programs BASE SAS, ODS, PROC SQL, SAS Access, SQL Pass-thru, Macros and functions and shell scripts, implemented processes, including data extraction from various sources corporate data warehouse DB2/UDB environment, mainframe, Sybase, SAS datasets and text files of final data and report production migration for each submission.
• Created SAS datasets, provided data samples, validated/reconciled reports and flat file formats supporting UAT validation and approval efforts of business/regulatory reporting team.
• Performed Ad-hoc queries supporting business users group.

Environment: SAS 8.2 Macros, Procs, ODS, Base, Connect, Access, SQL, Interactive, UNIX, mainframe , KornShell, DB2 UDB, SQL, MS Office 97/2000, MS Access, MS Excel, TSO, JCL, Sybase, Exceed, DB2 Command Center, MS Excel Pivot Table, Visio, Rational ClearCase, ClearQuest, Solaris, AIX, IBM mainframe, Novell, Windows 2000

Confidential

Software Engineer II, Sr SAS Programmer/Analyst for Account Review Mgt, Marketing Project

• Provided technical design, analysis, program development using SAS programs BASE SAS, STAT, ODS, PROC SQL, SAS Access, SQL Pass-thru, Macros and functions and shell scripts and production support for ARM campaign Direct Mail/Inbound Balance Transfer, Unsecured Line Increase, Point Programs .
• Supported development of modeling stage for each marketing campaign product list pool using SAS, Informix and Sybase.
• Operated and interacted with all business units involved including Marketing, Credit Risk, Targeting and QA/Audit team ensuring timely, accurate handling of marketing campaign fulfillment.
• Completed, interpreted and supported unit and systems tests creating technical documentation.
• Performed process and data analysis created ad-hoc reports on production data.
• Built predictive models for marketing group's effective decision-making. Designed and analyzed initiatives/experiments testing various marketing strategies. Performed customer profiling and segmentation for effective targeting and ROE calculations.
• Environment: SAS 8.2 Macros, Procs, ODS, Base, Access, Connect, SQL, Interactive, STAT , Visio,
• Vi Editor, Oracle, Informix, Sybase, MS Office, MS Access, Rhumba, Exceed, UNIX, NT
• Confidential Cons., Sr. IS Analyst/Lead Mainframe Dvlpr for Young Adults Lifestyles, DMCNames Project
• Developed programs, designed, analyzed and supported Direct Marketing Center US Card Department direct and indirect marketing campaign programs, marketing efforts and response models.
• Liaison with Marketing Analysis and AXIOM business groups. Provided ad-hoc reporting for users and analysts.
• Provided unit and systems test support and QA through pre- and postproduction of test case/test scripts, data integrity and technical documentation for solicitation/marketing promotion projects.
• Performed data modeling based on marketing campaign efforts. Developed and supported effective targeting through customer profiling and segmentation. Supported modeling group via SAS/STAT for logistic regression proc logistic, proc rank, proc freq, proc SQL and cluster analysis proc varclus .
• Ensured production data integrity between client and vendors.
• Developed methodology and macro build variables utilizing solicitation history for accurate response prediction, including key variable definition capturing individual response behavior and transaction history.
• Environment: SAS Macros, STAT, Procs, ODS, Base, SQL , Oracle, DB2, SQL, SQLPlus,
• SQL LOADER, FileAid, SYNCSORT, MS Office 97/2000, MS Excel, MS Outlook, UNIX,
• MS Excel Pivot Table, Visio, TSO/ISPF, MVS/ESA JCL, IBM mainframe, Novell, Windows 95/2000

Confidential

Consultant II, Senior Programmer Analyst for UFS File/Application Maintenance Project

• Created production, modification and file error reports on schedule for client delivery. Provided production status reports identifying issues and pending resolutions to project managers. Mentored junior team members providing technical and system knowledge support.
• Developed, analyzed, tested, maintained and documented production environment including specification requirements, project requests, program changes, data processing analysis/investigations, program/system walkthroughs and system issues.
• Supported production system including pre- and post production problems system set-up, preparation, compilation, pre-production test , system abends, erroneous applied transactions analysis, detailed static error causes and resolutions.
• Team coordinator for section test and production releases special clean-up runs, wind-downs and copybooks/dictionary changes.
• Performed group requests for master and transaction file and control cards review. Coordinator of user requests supplying file extracts in report format.
• Designed data error issues, resolutions specifications for code changes and data re-entry/manipulation . Completed proposed program code changes. Performed unit and system tests. Wrote technical documentation and program walkthroughs.
• Processed special pre-release runs. Tested outsourced vendor special inputs ensuring data integrity.
• Reported weekly to IT and client's marketing management team. Provided IT Manager with detailed analysis and resolution of production data errors.
• Environment: SAS, DB2, FileAid, VSAM, Extra For Windows, SYNCSORT, ENDEVOR, AbendAid,
• QMF, Fault Analyzer, Hummingbird, MS Office 9/2000, Lotus Notes 4.5/5.0, TSO/ISPF, MVS/ESA JCL, Expediter, IBM mainframe, Novell, Windows 95/3.1/NT/2000

Confidential

Programmer Analyst for Message Ready System, Inter Exchange Carrier Group Project

• Maintained and supported all Message Ready system modules including program development changes, unit testing and technical documentation. Analyzed impact on various new projects affecting Message Ready system.
• Provided production, test criteria creation and system validation, release test support and QA in development of new programs.
• Coordinated AT T, Sprint, MCI and inter-exchange carrier requirements directly resend missing/unreadable tapes causing production problems, offline production data runs for test purposes on new projects or production problems .
• Provided: special reports to project managers or IEC carriers daily production run status reports upcoming project impact analysis ongoing project reports completed/pending production resolutions report.
• Coordinated with IT groups to ensure integrity with major systems test, production problem resolution and billing system production test.
• Environment: Cobol II, TSO/ISPF, MVS/ESA JCL, TSO Expediter, CICS, FileAid, SAS, SAR,
• Network Data Mover NDM , AbendAid, OV/VM PROFS, Extra for Windows, DESIGN/1, GAIA Tool,
• High Level Design, MS Office, MS Exchange, MS Schedule , IBM mainframe, Windows Workgroup, NT

Confidential

Senior Programmer for GMD's COMPASS 2000 Project

• Developed, maintained and supported front-end GUI and back-end BATCH modules for all major subsystems, including change of front-end database manipulation and development of new front- and back-end modules.
• Supported Model Office/Prototype test of system retrofitting changes to front- and back-end modules.
• Tested functions and units based on program specifications and program and system walkthroughs.
• Provided maintenance support for online programs technical documentation program specification changes, test plan, test case preparation, test results .
• Supported QA team by performing system and functional tests prepared QA technical documentation test plan, test case, test results for most front- and back-end modules based on business/user requirements and COMPASS 2000 standard procedures.
• Environment: MicroFocus/Merant Cobol, Workbench Tool, DB2/2, SQL Server, SQLTalk, SQLBase,
• GuptaSQL Windows/Centura, SQLReport Windows, Q E Database Editor, SQL Library, SQL, EMC/TAO,
• Word Macro Programming for Windows, MSWord for OS/2, Query Manager, Database Manager