SUMMARY:

• 16 plus years information technology field experience providing programming, analysis and design, data mining/analysis/validation, unit and system testing, production validation, quality assurance and technical documentation.
• Solid experience in 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.

TECHNICAL SKILLS:

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, Richmond, VA

Credit Metrics Analyst/SAS Analyst

Responsibilities:

• 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 the development and maintenance of the monthly data feed into a centralized repository called the Datashare that is currently used by the Credit Risk Department and other departments like Finance, Quality Control, Default. The data processing is done in SAS but is pushed into SQLServer.
• Responsible for providing data analysis and reporting support to the Credit Risk department for Mortgage 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 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, Richmond, VA

Sr SAS Data Analyst

Responsibilities:

• Responsible for providing data analysis, programming and reporting support to the Small Business Statistics Team at Confidential
• 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, Confidential, Solaris, Novell, Windows 2000

Confidential, McLean, VA

SAS Technical Analyst

Responsibilities:

• 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 AccessConfidential, Solaris, Novell, Windows 2000

Confidential, Richmond, VA

Senior IS Analyst

Responsibilities:

• 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 Confidential 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

Senior Technical Analyst

Responsibilities:

• 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, Confidential, Novell, Windows 2000