SUMMARY:

• Sr. Mainframe Developer/Information Technology professional with 20 years of experience in designing, development, testing, implementation and supporting Mainframe Business Applications in IBM MVS and IBM/z/OS environments.
• Worked for major financial firms, robust knowledge and significant hands on involvement in various aspects of Banking/Brokerage/Insurance/Financial Services Applications.
• Robust knowledge/experience working with COBOL batch and CICS online applications, DB2 Database, SQL, Internal and External Stored Procedures.
• Experienced with full cycle Application development and Quality Control application testing starting with creating test cases/scripts and test data and carrying out unit and system testing.
• Responsible, dedicated, organized with solid analytical, system design and problem solving skills, capable of working both independently and as a team player.

TECHNICAL SKILLS:

Hardware: IBM - 390, IBM-PC and compatibles, Client Server, Mac and SUN computers.

Operating Systems: OS-MVS, TSO-ISPF, Windows 7/XP, MS-DOS, UNIX.

Languages: COBOL, JCL, DB2, SQL, XML, IDMS, CICS, C, CA-EasyTrieve, C#, T-SQL, Java Script, HTML, PL-SQL, PL-1 and C++.

Databases: DB2, DB2 SQL Stored Procedures, MS SQL Server, MS ACCESS and Oracle.

Development tools: BMC, MQ-Series, NDM, FTP and SFTP, IBM Utilities, DFSORT, OPC, DB2AID, SPUFI, FILEAID, CHANGEMAN, ENDEAVOR, CA-Librarian, IBM Debugger, QMF, PLATINUM, DB2 Utilities, EXPEDITER, SDSF, VSAM, IDCAMS, INTERTEST, OMEGAMON and Abend-Aid.

Software: HP Exstream, FINALIST, SQL/PSM, FTP, SFTP, ODBC, RDZ, Visual Explain, MS Office (Word, Excel, MS ACCESS, MS Outlook), VISIO, ASP.NET, VB.NET, Visual Basic 4-6, Access Basic, Power Builder and UNIX Shell.

PROFESSIONAL EXPERIENCE:

Confidential, Weehawken, NJ

Senior Software Developer.

Responsibilities:

• Designed, developed and tested number of new documents batch processes, by collecting source from many systems, printing for mail and emailing documents to clients. Using COBOL, DB2, SQL Stored Procedures, JCL, NDM, FTP and HP Exstream.
• Designed, coded and tested SQL DB2 Stored Procedureson a distributed platform with Java as a front-end language. Stored Procedures Builder has been used as a SP testing tool.
• Analysis, coding and testing of JCL jobs and procedures.
• Created test data and test cases, carried out Unit/System testing.
• Production support and maintenance of the systems.

Confidential

Contractor

Responsibilities:

• Designed and implemented SQL stored procedures for "OLS mailbox project";
• Designed and coded CICS screen to manage restart "Mailbox data" batch production in CICS and MQ-Series;
• Designed and coded DGF Suppression batch process, using JCL and DB2 Utilities;
• Updated DGF online and batch processes for Estate accounts.
• Designed and coded request to handle new account household role for NRA and UBSI clients.
• Designed new database to keep trucking and history of versions of Disclosure letters in DGF.

Confidential

Senior Software Developer.

Responsibilities:

• Completely designed, implemented and supported online household process in “COBI” project for CAI system (Process to reduce mail expenses by consolidation mail packages);
• Designed and coded address entry process, including ZIP code verification and convert 6 digits ZIP code to complete eleven digits long ZIP code by online processes.
• Involved in new DB2 tables structure design for “Welcome Package” database, created for new accounts first mail.
• Involved in design and implementation of email reporting process from mainframe with attachments in different format including Excel and zip packages.
• Provided performance tuning for online “Commission ineligibility”, “Print option” and “Account approval” processes, using BMC and Visual Explain. Corrected all of listed processes.
• Provided full production support for CAI system, for the last year accomplished more then fifty production tickets and installed all fixes and reports in production.

Confidential

Senior Business Systems Delivery Specialist.

Responsibilities:

• Designed, coded, and tested new subsystem that implemented new high complexity regulatory business requirements. System processed over 150,000 real-time claim transactions per day to adjudicate new members, providers, and claims into DB2 corporate database. Performed multiple iterations of system volume and DB2/CICS performance testing, created system tune-up solutions to reduce data and transactions contention and maximize the system throughput rate.
• Designed and implemented utilities of preparation data for testing Claim System, by specific criteria, using historical records. Chose claims from production and loaded data into QA Claim environment, include also surrounded systems, like members and providers. Using also COBOL, SQL, CA-EasyTrieve, DB2 and IDMS, DB2 Utilities.
• Designed and created a brand new QA process included extract from multiple DB2 Claim tables only for claims, involved in particular project (partial backup). Then loaded all records from the first step into ACCESS tables with structure similar to DB2 HMO Claim system. Base on the “Snap-shot” ACCESS database created multiple unique reports included compare between base line and regression. Using also COBOL, SQL, CA-EasyTrieve, VB.
• Used COBOL-II, DB2-8 and 9, SQL, MQ-Series, ORACLE, PL-SQL, CICS, IDMS, ENDEVOR, CA-Librarian, EXPEDITER, DB2AID, SPUFI, CA-EasyTrieve, ODBC, VB, MS ACCESS, ClearQuest, ProTerm, SOA.

Confidential

Senior Application Developer

Responsibilities:

• Developed and moved batch DB2 programs with static SQL to internal and external Stored Procedures (Prepared test and production environment - Endevor processors, compilers and DDL for create SP).
• Implemented fit from UNIX and UNISYS system to MVS (CUSMOS project). Converted system from VSAM to DB2 environment on time and without errors.
• Implemented new production trail, designed and implemented variable production trail for Claims System, including several separate process customer maintenance, reports and checks writing, managed by relational database, using COBOL, JCL, DB2 utilities, ENDEVOR.
• Created online control production system to track job flow, using Visual Basic 4.0 and DB2.
• Designed and implemented Eligibility Reports for number of different layouts driven by parm file (COBOL, EasyTrieve, DB2, VSAM and JCL).
• Coded and implemented front ends for date-entry related to Contracts, using Power Builder 5.0 and DB2.
• Provided programming full production support for Customer Maintenance and Tape Process systems.
• Created download files process from mainframe data into PC databases, floppy and CD disks systems by FTP.
• Wrote program specs, documentation, and user interface.
• Environment: COBOLII, DB2, DB2 Utilities (REORG, RUNSTAT, DROP, CREATE etc.), DB2 Store Procedures, VB-6, VSAM and CICS, UNIX and UNIX shell.

Confidential

Programmer Analyst / Consultant

Responsibilities:

• Converted online from CICS to client service using VB and DB2 for Claims System. System utilizes COBOL II, CICS, PL-1 and Visual Basic.
• Developed, tested and implemented a number of programs: Insured ClaimsRegister (list of claims ordered by claim date and status), Scheduled Check Review, Scheduled Payments Control List, etc.
• Responsible for design and implementation of Contract Address System, which was handling additions, update, browse and deletes of participants for Capitation System, by providing services for contract match.
• Used Visual Basic, Visual C++, ACCESS.