TECHNICAL SKILLS:

Operating Systems: ZOS, MVS/OS, SQl Server

Languages: TSQL, SQL/DB2, Cobol, Cobol II, IMS DB/DC, CICS,SPFUI, JCL, FileAid,TSO,VSAM, Easytrive/Plus, Telon, Spufi, QMF, MQ Series, HTML, SQL Plus,PL/SQL,Sql Assist, Mload,Fload,Tpump,Pl/Sql,Toad,Sql Plus

Design Tools: Visio, Erwin

Office Tools: MS Office 2010 Suite Word, MS Xcel, MS Project, PowerPoint, MS Access

Other: Changeman, Xpediter, Endevor, Mercury Test Director /Quality Center, Librarian,Panvalet,CA7, UCC7, FTP/SFTP,NDM

Databases: DB2, IMS, Oracle, MS Access, DB2 UDB, SQL Server, Teradata 13.1, 14.0, Netezza

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Programmer/Developer IV

Responsibilities:

• Sr. Programmer/Developer IV, Corporate Treasury, as part of a team that supports and maintains a very large Oracle /Netezza data mart utilized for ad - hoc query and reporting. Responsible for creation of high/low level designs, field-to-field data mapping, coding, testing, documentation, and implementation of application on a large Data warehouse, Teradata and Netezza/Sql Server as needed.
• HLD/LLD Level Documentation. Cobol,DB2,QMF,TSO,JCL, Easytrieve, CA7, Changeman, Endevor,Xpediter,File Aid,, TSQL, SQL Server 2008,Teradata 14.0 (BTEQ, SQL Assistant).Netezza (Aginity). NDN:ConnectDirect

Confidential

Sr. Programmer/Developer V (

Responsibilities:

• Development /Maintenance on the Banks “Interact” Sales Reporting system . Overall responsibility for all aspects of the Sales Reporting system for Sr. Level Management Reporting on Branch performance.. Developed /Maintained complex Stored Procedures, on Multi Environments Prod Platform /and Dev. Database’s /Table/ Index and performance .Linked Server to the “W” Teradata databases, SSMS,SSIS (job scheduler), SSRS, Teradata 13.1, Sql Assistant, Cobol, TSQL/Sql Server 2008, MS Visual Studio 2008, FTP

Confidential - Greensboro NC

Sr. Programmer/Developer

Responsibilities:

• Corporate Treasury, as part of a team that supports and maintains a very large Oracle data mart utilized for ad-hoc query and reporting. Responsible for creation of high/low level designs, field-to-field data mapping, coding, testing, documentation, and implementation of application on a large Data warehouse, Teradata and Unix/Oracle/Sql Server as needed.

Confidential

Sr Lead Analyst/Developer

Responsibilities:

• Legacy System Analyst, supporting an ETL Datastage application. Identifying all requirements from the existing Legacy systems from LADE ( Life Accident & Disability systems) Responsible for support of prototyping of a parallel processes, to proof of concept..., Data Mapping, Functional & Operational Requirements documents in support of the new Sql Server Data Model. ( CICS, DB2, SQL Server 2005, TSQL, SQL, IMS, SAS, Focus, Easytrieve, Endevor, Xpediter, Intertest. Cobol, JCL, NDN(Connect Direct), CA7

Confidential

Sr Developer/Analyst

Responsibilities:

• Responsible for Modifications to the (MSSICS) CICS online Application for handling supplemental income processing. Testing, Functionality requirements of Enhancements to existing MSSICS online Screens. Process Recommendations on existing applications for performance improvements. CICS, DB2, JCL, TSO,ISPF QA Center( Mercury Test Director), Cobol, QMF,VSAM Endevor, Xpediter, Intertest.

Confidential, Texas

Sr. Lead Application Programmer/Analyst

Responsibilities:

• Design, Development and enhancements for a Bank Credit, Cash & Sales and POS system utilizing CICS, DB2 queries and IMS DB/DC programs for PCI compliance. Checkpoint/Recovery Processing, PSBGENS, SQL Queries, API facilities for Encryption/Decryption processing. Building of Easytrieve reports, and changes to Telon programs for PCI Compliance. Encrypt/Decrypt of Credit Card Numbers for PCI compliances. Called PCI Account number cross processing, and Credit Card
• Number masking. IMS application coding/testing. Oracle, Java, MS ASP .Net, IMS (DB/DC), JCL,Toad, COBOL/II, CICS, DB2/SQL, SPUFI, QMF, FILEAID, AbendAid

Confidential, Dallas Texas

DB2 DBA Sr. Application Programmer/Analyst

Responsibilities:

• DBA responsibilities creating SQL Extract Query processes, Review of Sql code for Performance and monitoring, Unload/Load/Reorg/Image copy Utilities, and database extracts using File Aid, DDL, DML, SQL, COBOL/II,DB2,CICS,JCL,TSO, On the More Project., For customer Credit Card Application

Confidential, NC

Sr. Programmer/Analyst, Database Analysis

Responsibilities:

• Design /Build of extracts for feeding new CRP application, interfacing with PeopleSoft HR tables. Creation of numerous extracts programs, supporting Work Brain Time Reporting CRP application. Other responsibilities: Testing, Documentations, Performance/Tuning, Testing Scripts, FTP’s, Peoplesoft HR, Sarbanes Oxley Compliances (SOX Controls),System Loads/Unloads/Image Copys/Reorgs,DB2, Oracle,SQL, QMF, Easytrieve,COBOL/II, JCL,TSOEndeavor, Test Director., Xpeditor

Confidential, DAllas, TX

Senior Programmer/Analyst

Responsibilities:

• Development and Design in support of this large Credit Card application. Other responsibilities: Testing, Documentations, Specification writing, SDM methodology. Testing Scripts, Performance/Tuning of applications, Expeditor, Release Management. Responsible for Credit Card Application Development, New Product Introduction for Credit Card application as well as Credit Loan systems., data analysis across multi-legacy systems, for system stream lining.

Confidential, Dallas, Tx

Senior Programmer/Analyst, Group DB2 DBA

Responsibilities:

• Design and Development (AC3 application) a Webfocus/DB2/Oracle/Cobol (Web - to-Mainframe application to extract (Client DDA Cash Transactions & Balances) data via Unix box (Oracle structure), utilizing Webfocus/DB2/Cobol extracts that where ported to the mainframe and Web focus reports written down on the PC for client URL Views reporting system.. Support of the Client Advices model: responsible for day-to-day, Loads, and Multi Region Data Migration via Princeton Softech application (product). Daily support of a Data Repository in support of a client securities application for Accounting/Custody BackOffice application. Performance/Tuning of applications, SQL, Database Replication using Princeton Softech product for Shadow database, Unload/Load/Reorg/Image copies, ETL Advanced Datastage, ERWIN Data Modeling, DB2 UDB Ver. 7,, Development/major Enhancements to a Security Asset application utilizing MQ series Messaging. MVS /JCL, CICS, VSAM,Cobol/II,TSO, SQL, QMF, DB2, and CA7. BMC Change/View,Oracle,Web Focus,ETL Datastage. Other Responsibilities: Development of USE Case’s in support of new client applications. Managed (6) people.

Confidential, EXTON, PA

Software/E-Commerce Director

Responsibilities:

• Project Lead: Web development project. Processing information off The web using Text Universe application. Development using Java script, VB script, ASP, and Front Page. Access 2000, NT server, SQL, Server. Developed and implemented website: Oursalon2U.com

Confidential, Valley Forge, PA

Sr. Applications/Utility /DB2 DBA

Responsibilities:

• Development/Support of a new AARP program, for identifying customers that may be denied coverage and responsible for table support (DB2) involving all aspects of table handling and manipulation for unit testing. Applications performance on (stored procedures) as well as Embedded SQL and the loading of referential tables, utilizing the Princeton Softech (Move-for-DB2) product SQL. Embedded SQL, Princeton Softech. Application performance reviews and coding recommendations, DB2 Alter, all DB2 functions for test to production migration using BMC products. System modeling and design.•SQL Embedded SQL, SPUFI, Cobol, TSO,JCL

Confidential, New Jersey

Sr . Applications Developer

Responsibilities:

• Development and support of an Oracle base marketing application for handling direct mailings for new client members. Enhancements of online CICS/DB2 applications for new member Marketing. Support of Oracle marketing application via REXX/FTP Processing from a DB2 system and various DBA functions. Support of the client server and local design of the manufacturing Data Warehouse. Using Erwin modeling tool as well as the creating EHD, ERD, activity and attribute diagrams for establishing the data warehouse model. SQL, PL/SQL.

Confidential, Memphis, TN

SR Consultant, Group DBA

Responsibilities:

• Design/development of Teller support DB2 database, along with performance and tuning of new teller applications for systems group. Developed Batch extract strip programs for consolidating (CDs, Savings and IRA) for DB2. Also developed extract strip program for (DDA accounts). Wrote Cobol,CICS programs to update HOGAN tables in support of DB2. Online versus nightly batch VSAM feeds. Support of Oracle base applications via DB2, through REXX/FTP file transfers.

Confidential, Valley Forge, PA

Senior Programmer/Analyst/Lead

Responsibilities:

• Supported client/server from the mainframe through REXX/FTP processing. Design/development of DB2 Tables in support of financial reporting to the Access Vanguard System. Development of Financial Reports for Variable Annuities for the Web. Daily Extracts From the mainframe and REXX process for the Sybase client server, along with reporting functionality. DB2/Embedded SQL,CICS,JCL,TSO,REXX,FTP,HTML,UNIX.

Confidential, Valley Forge, PA

Senior Programmer/Analyst

Responsibilities:

• Developed and Maintenance of an IDMS/CICS/DB2 Sales and Marketing system for producing custom report generated financial reports to Pharmaceutical clients. ISPF dialog report/file processing, DATACOR extracts and Easytrieve Reports. DB2, SQL, Embedded SQL, IDMS,Cobol,TSO,JCL,CICS.

Confidential, New York

Senior Consultant/Project Lead/DBA

Responsibilities:

• Development and support of a Data Warehouse, for back office accounting of Institutional/Trustee clients. Managed the Cash Movement transactions for this large Data Warehouse (335+ entities) system using CICS, VSAM, MVS/JCL,SQL, QMF, DB2, CA7 and IEF Case tools (BSD and BAA). Replication of the Sybase client server from the Data Warehouse using Princeton Softech Product. Composer/Coolgen BAA modeling tools. EHD, ERD and activity and attribute diagrams for establishing the data warehouse model.

Confidential

Senior Programmer/Analyst / IEF Case Tools

Responsibilities:

• Development of an IEF BSD, DB2 /IMS/DB Order Entry application for the Sales/Marketing and customer support groups for handling the limitations of product buying. Enhancements to the Debit/Credit system for pricing changes, Product Promotion, Product Maintenance for Generic/Non-Generic drugs. Designed and developed a Product Agreement System to restrict product purchase that did not have a specific product agreement for purchase and transportation process. RPR: Developed a PC-based Image Document System for a Manufacturing Company that required imaging and document management on AP/AR and invoicing. MS Access, Visual Basic and Watermark Software, CD-R, Archiver, TWAIN interface, Cobol,TSO,JCL,DB2, SQL, Embedded SQL, and IEF Case Tools.

Confidential, New York

DB2/DBA Group level, Senior Progammer/Analyst

Responsibilities:

• Development, installation and support of a worldwide Securities and Investment System using CICS, VSAM, MVS/JCL, SQL, QMF, DB2, CA7 and IEF (Case Tools BAA, BSD). Development of numerous Cobol,CICS applications for the SUNGARD product Invest One for securities processing. Other responsibilities included Loan systems, and database support applications for ADABASE/Natural.

Confidential

Senior Consultant/DB2 DBA

Responsibilities:

• DSN1 copies of all table spaces, application performance reviews and coding recommendations, DB2 Alter, all DB2 functions for test to production migration using BMC products. System modeling and design. Wrote various applications for DBA Group identifying backups of table spaces and rolling off more than (3) levels of explains within the plan table. This large CICS/DB2/SQL billing application involved over 500+ entities. SQL Embedded SQL, DB2, BMC.

Confidential, New York,

Sr. Programmer/Analyst, Group DBA

Responsibilities:

• Design, development and support of a Major DB2/SQL IEF Securities Transaction Application involving over 300+ entities with the largest entity. Major Project: Re-design of the TI/Maximus system, from a small security transaction processing system to a large 2,000 - 4,000 daily transactional system, consisting of over 60 million rows of data. This IEF application consisted of over 1+ million objects, in which the transaction subject area consisted of approximately 75% of the system development. Major system functions included: Transaction Management, Customer Ledger, Customer Account activity and Management. Major responsibilities for Phase I included the (BAA) ERD entity design, activity hierarchy design and all components of BAA, including Process Logic Diagrams and Entity lifecycle.