SUMMARY

• 9+ years of experience providing innovative solutions in the Financial and Credit Card industry.
• Thorough knowledge of the Banking industry and all phases of the Credit Card lifecycle and Data manipulation and Statistical Analysis.
• Expertise in SAS / Base, SAS / Graphs, SAS / Macros, SAS / ODS, SAS / SQL, COBOL, DB2, VSAM, JCL, Rexx, UNIX Shell Script, VBA.
• Familiar with SAS Access, SAS/STAT, SAS/Connect, SAS/ETL
• Extensive experience in preparation of reports, tables, listings and graphs in HTML, PDF and RTF formats using Output Delivery System
• Hands on experience in Mainframe in JCL, Mainframe SAS
• Experience with conversions from Mainframe to Unix in various projects. Conversion of JCL to Unix Shell Script and from DB2 tables in Mainframe to SAS Datasets in Unix.
• Hands on experience in Unix File management system, space management, scripting, and job management and scheduling
• Has vast experience and excellent communication and interpersonal skills helps contribute to timely completion of project deliverables.
• Enhancements and evaluation of credit/debit card system and Financial Applications.
• Involved in all the stages of the software development cycle, namely design, specification, coding, debugging, testing (test plan and test execution), integration and system testing, documentation and maintenance of the programs.
• Experience in complete life cycle of systems design and development.
• Highly successful in developing synergistic relationships to bring projects to completion on time and within budget.
• Proficient in IBM utilities and worked with Tools like ENDEVOR, FILE - AID, OPC, CA View, CHANGEMAN.
• Created complex test plans, requirements and design test cases. Managed execution of different testing phases (unit, integration, systems, interface and compliance testing).
• Ability to work independently as well as collectively as part of a team

TECHNICAL SKILLS

SAS Skills: BASE SAS, SAS/MACRO, SAS/CONNECT, SAS-SQL, SAS/STAT, SAS/GRAPH, SAS - ODS, SAS/ACCESS, SAS/ETL

SAS Procedures: PRINT, TRANSPOSE, CONTENTS, MEANS, CHART, PLOT, PRINTTO, TABULATE, UNIVARIATE, SUMMARY, SORT, SQL, PROC FORMAT, FREQ, FORMS, UPLOAD, DOWNLOAD, DATASETS AND FORMAT, IMPORT, EXPORT, REPORT, GCHART, GLM, MIXED, GSLIDE, COPY, ANOVA, REG

Advanced SAS: Macros, DATA NULL, Reports, Array Processing, Hash Objects, Pointers, Display Manager.

Languages: SAS 9.2 Programming, COBOL, JCL, ASSEMBLER, REXX, PL/SQL, Unix Korn Shell Script, VBA, JavaScript, Perl script

Operating Systems: OS/390, Z OS, MVS/ESA, MS WINDOWS, UNIX.

File Organization: VSAM, PS, PDS, GDG

Hardware: IBM-3090, IBM ES-9000, IBM COMPATIBLES

Utilities/Tools: TSO/ISPF, ENDEVOR, FILE-AID, FILE-AID, OPC, Autosys, Maestro, LSF, MS-OFFICE SUITE, EXCEL, OUTLOOK, POWER POINT

Databases: DB2, ORACLE, SQL Server 2005/08, MS ACCESS

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

SAS Analyst Technical Lead

Responsibilities:

• Worked in the migration of SPDE and SAS datasets from one environment to the other using proc CPORT and CIMPORT
• Helped in the testing of new functionality like XLSX macro and additional proc template options in the new server
• Deploying of code in development using SAS DI Studio.
• Worked in the migration of job flows from SAS DI Studio to the LSF 7.6 version
• Helped the user community to move from SAS EG4.2 to SAS EG 6.1. Helped them with documentation and user queries in the new environment
• Helped in the setup of SAS Connect with DB2 and Oracle in the new environment and with the testing and validation of these.
• Helped in the set up of Tumbleweed Connectivity for file access as well as modification of jobs to use the Tumbleweed Connectivity instead of the direct SFTP between servers.
• Worked in the project plan and for creating user test cases and their validation.
• Wrote Design documents, Program specs and SAS code.
• Involved in various Testing phases (Unit, System and Integration)

Environment: SAS V9.4, SAS/Base, SAS/Graph, SAS/Macros, SAS-ODS, Enterprise Guide, (DI) Studio, OLAP Cube SAS Information Map, Unix Shell Scripts, LSF

Confidential, Phoenix, AZ

SAS Analyst Technical Lead

Responsibilities:

• Initial Analysis including Impact Analysis, Requirement Analysis,
• Code level Mapping of fields and jobs
• Preparation of High level and Low level design documents
• Development and Modification of around 55 jobs which were impacted by the migration in very tight timelines.
• Helped in the set up of Tumbleweed Connectivity for file access as well as modification of jobs to use the Tumbleweed Connectivity instead of the direct SFTP between servers
• Deploying of code in development using SAS DI Studio.
• Testing of the modified jobs in unit testing, System testing and Integration testing.
• Warranty support after implementation for changing requirements

Environment: SAS V9.1.3, SAS/Base, SAS/Graph, SAS/Macros, SAS-ODS, Enterprise Guide, (DI) Studio, OLAP Cube SAS Information Map, Unix Shell Scripts, LSF

Confidential, Irving, TX

SAS Analyst Programmer Lead

Responsibilities:

• Converted large numbers of JCL scripts, assisted with development of consistent file naming.
• Test codes, comparing outputs between different data systems for full data (6M members) tests.
• Prepare reports, maintain progress reports, draft and publish procedure, consult with team.
• Identified opportunities for cost savings and added value to the client.
• Development using ISPF, batch SAS v9.2, PC and Enterprise Guide interactive SAS, MS Word, Excel, and Outlook.
• Use of DI Studio for user transformations and integration
• Extensive use of Autosys for job scheduling
• Created a customized JCL for Job scheduling.
• Migration of data from text files and DB2 to SAS data sets.
• Created complex and reusable Macros and extensively used existing macros and developed SAS
• Developed an Automated Quality Control System for Data Validation and data integrity.
• Developed a JCL to run jobs in MVS system.
• Migration of large data from DB2 tables around 400 to SAS datasets around 8 million observations.
• Documentation, Preparing statistical reports using SAS.
• Wrote Design documents, Program specs and SAS code.
• Involved in various Testing phases (Unit, System and Integration)

Environment: SAS V9.2, SAS/Base, SAS/Graph, SAS/Macros, SAS-AF, SAS-ODS, IBM 3090, DB2, JCL, Autosys, Enterprise Guide, (DI) Studio, OLAP Cube Studio, SAS Information Map.

Confidential, Irving, TX

SAS Lead Analyst Programmer

Responsibilities:

• Creation of new SAS datasets mirroring the already existing data for other partners so that a uniform reporting could be developed for Business Analysis.
• Created complex and reusable Macros and extensively used existing macros
• Improve code efficiency and run time load on system resources using parallel processing, hash lookups and Compiled SAS macros
• Developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.
• Creation of new Rexx and Easytrieve scripts for validation of new test files from Best Buy.
• Played a major role in quick generation of Ad-hoc Business Analysis Reports and resolving data issues upon request.
• Built decision trees and neural networks using SAS 9.1
• Developed an Automated Quality Control System for Data Validation and data integrity.
• Worked with DI Studio for creating user transformations and integration of data sources.
• Developed a JCL to run jobs in MVS system.
• Documentation, Preparing statistical reports using SAS.
• Wrote Design documents, Program specs and SAS code.
• Played a role of coordinator between onsite and offshore for project delivery
• Involved in various Testing phases (Unit, System and Integration)
• Created SAS MACROS and SAS GRAPHICS. Used Proc REPORT to generate reports.
• Creation of new JCL jobs in OPC scheduler
• Created a customized JCL for Job scheduling.

Environment: SAS V9.1, SAS/Base, SAS DI Studio SAS SQL, SAS/Graph, SAS/Macros, SAS-AF,SAS-ODS, IBM Z-OS, COBOL II, DB2, JCL, VSAM,ENDEVOR, Easytrieve FILE-AID

Confidential, Irving, TX

SAS Lead Programmer

Responsibilities:

• SAS programming and onsite coordinator.
• Data Extraction from various sources like Flat files, Excel spread sheets, VSAM and manipulated to the format of intermediate tables.
• Involved in populating intermediate tables in Data warehouse for Weekly, Monthly and Yearly load.
• Created Reports using Base SAS, SAS/Reports Procedure.
• Generate reports using PROC REPORT,TABULATE, EXPORT AND DATA NULL AND PUT STATEMENTS.
• Created Macros, in order to generate reports daily, monthly basis
• . Worked with DI Studio for creating customized user transformations and integration of data sources.
• Created SAS Views from tables in DB2 using SAS/Access.
• Generation of reports and transferring the output to the SAS Output Delivery System.
• Refreshing tables in DB2 Schemas with the SAS data sets
• Coding SAS programs with the use of Base SAS / Macro’s for ad-hoc jobs.
• Wrote VBA Screen scrapping tools to screen scrap FDR screens for testing and validation
• Client interaction and sending work to off shore
• Work with IT support groups and management teams to define and support system and information needs,
• Provide high quality service to all internal division and corporate support teams as well as to all external customers,
• Involved in preparing technical specification documents based on user requirements,

Environment: SAS V9.1, SAS/Base, SAS/Graph, SAS DI Studio, SAS/Macros, DB2, MS-Excel, VBA, Unix Shell Script

Confidential, Irving, Tx

SAS Lead Programmer

Responsibilities:

• Sas Programmer and team lead. Involved coordination with onshore and client
• Produced Listings, Reports, Tabulations and Summaries of the data using procedures such as Freq, Means, Univariate, Summary, Tabulate, Report, Transpose for statistical analysis by Marketing and MIS teams
• Provided input to planning documents such as Validation, Study Protocol and Statistical Analysis Plans.
• Created and implemented statistical analysis plans and specification documents; participated in database design, data collection guidelines, and logic checks.
• Participated in designing, coding, testing, debugging and documenting SAS Programs and Macros.
• Developed SAS programs using Base SAS for tabulation counts, correlation’s and checks for dispersion for normality using PROC Means, PROC Tabulate and PROC Univariate.
• Applied generally accepted Programming Standards and Techniques to assure efficient program logic and data manipulation.
• Created a SAS reports using the Data Null technique and Proc Report for submission as per Regz regulations and company standards.
• Formatted HTML, RTF and PDF reports, using SAS - output delivery system ODS.

Environment: BASE SAS V9, SAS/ACCESS, SAS/CONNECT, SAS/Macro, SAS/GRAPH, SAS/STAT and UNIX.

Confidential, Irving, Tx

SAS Analyst Programmer

Responsibilities:

• Developed SAS programs using Proc Tabulate, SAS Base and SAS/Stat that enabled users to generate reports on Daily/Weekly/Monthly/Quarterly/Annual reports.
• Generated adhoc reports for company’s audit and inspection requirements.
• Data was extracted from databases and also flat files.
• Preprocessed training data and performed advanced modeling on testing dataset.
• Evaluated the model performance using decision trees and confusion matrices.
• Created SAS data mining and scoring data sets form source tables by programming in BASE SAS.
• Report Generation and Documentation with respect to evaluation of model performance and effectively communicating the results to higher management
• Developed and maintained multivariate statistical models used to predict customer behavior and to profile customer potential.
• Calculating possible risk and premiums for individual organizations.
• Customized existing SAS programs and created new programs using SAS/Macros to improve the consistency of the results.
• Compile statistics and create detailed reports and graphs for management and customer review using SAS/Graph, SAS/Macro and SAS/Report.
• Correlating and presenting weekly or monthly data to senior management.

Environment: SAS/Base, SAS/Macro, SAS/Stat, SAS/Graph, SAS/SQL, Oracle, PL/SQL, Unix, MS-Excel and HTML

Confidential

Analyst Programmer

Responsibilities:

• Migration of data from DB2 to Sas Files in UNIX
• Creation of network nodes for successful transportation of files
• New Unix Shell scripts to run the jobs in place of the JCL
• Creation of new functional parameters for reusable macros for the new jobs in Unix.
• Correlating and presenting weekly or monthly data to senior management.

Environment: SAS/Base, SAS/Macro, SAS/Stat, Unix Shell Script, Perl Unix programming

Confidential

Analyst Programmer

Responsibilities:

• The project used ASP.NET, C# and MS SQL as the back end and the front end used Javascript, XML, CSS and XSLT.
• Was involved in creating a usable interface for the admin to add content. The interface used Javascript, XML and the AJAX technology to create a dynamic easily usable interface.