Project Data

Summary

Over ten years of Information Technology experience focusing on analysis, development, testing and implementation of mainframe systems. Worked more than 10 years in USA at MCI WorldCom, Merrill Lynch, JC Penney, MBNA-BOA and Venture Solutions. Worked extensively as a back-end developer on COBOL, JCL, DB2 and HP Exstream including having experience in production support environment.

Experience

O’Neil Data Systems (Plano, TX) SQL DATA/Exstream Developer 12/2013 - Current

Responsibilities:

Currently working in processing of different products like ANOC-EOC, EOB, ID Cards, and Welcome Kits for multiple clients on daily, weekly and monthly basis. Data is being processed through our internal system called ‘Job Scheduler’ that handles input, CASS, pre-composition, build-ID, proof, presort and composition. I mostly work on SQL Server Management Studio 2008 using Store Procedures, Tables, Functions and Databases. SSIS Packages are extensively used to create PDFs and final output print files to print out our final products. Each step in our Job Scheduler is associated with SQL Server 2008 and DTSX (SSIS) packages. I am responsible for creating or modifying Store Procedures, SSIS Packages based on the requirements from the clients. SQL agent has been used for the automation to start our process automatically. HP Exstream 8.0 is our design, print software used to create various PDF designs for multiple clients before we finally print our books, kits, letters, ID Cards and other statements in our print and delivery department. As a Data/Exstream developer I take part to manipulate data using matrix data tables that we receive periodically from the clients. I load data into the tables and process them through our SSIS packages and Store Procedures called in the packages to get our final output.

Environment/Skill Set

SQL SERVER 2008, MICROSOFT VISUAL STUDIO, STORE PROCEDURES, SSIS PACKAGE, JOB SECHDULER,EXSTREAM 8.0, DATA PROGRAMMING.

Venture Solutions Inc. (Fort Worth, TX) Mainframe/Exstream Programmer/Analyst 04/2007 –12/2013

Responsibilities:

Worked for mortgage servicing companies, consumer banking and other clients. Involve in data analyzing, converting data into specific format from the different sources including LPS. I used COBOL II, JCL, VSAM, ISPF, TSO and QUIKJOB (a convenient tool to manipulate data) to process the data used to come every night to create the billing statements. Converted data used to process through entire systems, COBOL programs and JCLs to move the final output to the HP Exstream (Version 7.00). VSAM files were used for data storage. HP Exstream 7.0 was used to create new design, pages, modifying existing design including monthly statement, fee pages, escrow statements and other various marketing products. Responsibilities included coding, testing, debugging and implementing new application as well as maintaining existing systems in HP Exstream. I also worked on letters and marketing products like Paymap, MNL Life Marketing etc. on day to day as well as monthly basis. I had also taken an important role in implementation of a recurring project to print W2/1098/1099 statements each year in the month of December/January.

Environment/Skill Set

VSE/ESA, JCL, TSO/ISPF, COBOL II, VSAM, QUIKJOB, QUIKVSAM, EXSTREAM DIALOGUE (7:00)

JC Penney (Dallas, TX) Mainframe Programmer/Analyst 11/2006 - 01/2007

Responsibilities:

Payroll Processing System:

Involved in activate changes in the payroll processing, taxes, benefits depending on the company policy. Also I was responsible for coding and modifying COBOL programs to activate new deduction CDs for benefits 2006 processing. I had utilized mainframe COBOL as well as server COBOL connected to Oracle10g/PeopleSoft Database and Net Express to develop COBOL environment to create modern system using existing code.

Environment/Skill Set

OS/390, MVS/JCL, TSO/ISPF, DB2, COBOL II, ORACLE 10G, PEOPLESOFT, NET EXPRESS,ORACLE SQL *PLUS, SQR, FILE-AID, VSAM

Bank of America (Dallas, TX) Mainframe Programmer/Analyst 5/2006 to 11/2006

Responsibilities:

Input Systems Project:

Input System gathers all the inputs from different sources such as; payments, Visa, Master Card, Amex, Access Checks, etc. This system validates and creates File Maintenance Activity file to send to FM group at the end of the day processing. Worked on COBOL II, JCL and DB2.

Same Day Payment Project:

Activate card holder transactions during the cut-off time. Input system creates data from the most current activated account numbers. New Memo Post programs put the accounts/transactions on the MQ Series for Authorization group to receive and approve before sending to the online system.

Environment/Skill Set

OS/390,MVS/JCL,DB2,COBOLII,XPEDITOR,ENDAVOR,SPUFI,MQSERIES,CA7,CICS,FILE-AID

JC Penney (Dallas, TX) Mainframe Programmer/Analyst 12/2000 to 4/2006

Responsibilities:

Inventory Management Systems and Interfaces:

Maintained security, bin location, report binders, also processing orders, entering receipts, transfer and updating records. This is important for effective implementation and reducing problems. Responsibilities involved accomplishment of day to day task including changing/coding COBOL II, JCL/ PROC, Control Cards, installing IIN to implement the changes in the production. I was involved in fixing production problems, maintained contact with the users to visualize the problem for numerous stores, figuring the most suitable solutions of the problems to keep the system on the track. Extensively production support was also included into my day to day activity in all the projects associated to mainframe environment.

Environment/Skill

OS/390, MVS/JCL, DB2, COBOL II, TSO/ISPF, ENDAVOR, SPUFI, CICS, REMEDY, INSYNC, ABEND-AID, CRISS, FILE-AID

Government of West Virginia(Charleston, WV) Mainframe Programmer 8/2000 to 11/2000

Responsibilities:

RAPIDS Project:

RAPIDS (Recipient Automated Payment & Information Data System) Work Program provided the automated support for work programs administered by the Dept. of Health and Human Resources. I maintained the system as well as modified programs online (TELON) and batch COBOL for the clients. For batch, programs were changed and ran using JCL and Procs. Mainframe express was used to compile and run or monitoring flow of the programs. Coolbiz was used for flowchart documentation of the online / batch programs.DB2 was used extensively on both online and batch system. A large number of databases were used to gather information for one particular case.

Environment/Skill Set

OS/390, MVS/JCL, TSO/ISPF, DB2, COBOL II, CICS, TELON, SPUFI, QMF, MAINFRAME EXPRESS,COOBIZ, INTEREST

Merrill Lynch (Edison, NJ) Mainframe Programmer Analyst 3/1999 to 7/2000

Responsibilities:

Preferred / Auction Market Security Maintenance project:

Preferred / Auction Market security values were included into Global Performance ROR( Rate of Return) calculation.

Rule set Maintenance project:

Rule set specified how a customer’s activity needs to be categorized for performance measurement.

FDS Activity Maintenance project:

The purpose of this requirement was to enhance the current system by capturing and including FDSactivities the performance calculations.

CBS Activity Migration project:

This project processed firm-wide activity on a daily basis to provide category codes and performanceamounts for ‘Global Performance Measurement’ system. Responsibilities included addition of modification of rule sets, few programs were got changed for ‘account’ class as well as ‘asset’ class activities. COBOL, DB2 programs have been modified to extract all the activities from a set of 15 CBS tables to categorize those activities. Daily-categorized activities have been inserted into table using a DB2 update program. Large number of new JCL’s, Process, and Control Cards has been produced in this project to include FDS as a part of performance system.

Environment/Skill Set

OS/390, MVS/JCL, TSO/ISPF, DB2, COBOL II, CICS, SPUFI, QMF, PROEDIT, PANVALET, ICETOOL

MCI WorldCom Programmer/Analyst /Mainframe 7/1998 to 1/1999

Responsibilities:

CNBS (Centralized Network Billing System):

CNBS supports MCIs Cost Allocation Service. This project involved developing programs for delivery of detail and summary reports to the cost centers, delivery of General Ledger Tape,optional a Call Detail Tape.

CNBS inputs:

Customer Hierarchy, General Ledger Tape format, Vnet CDRs, Toll free CDRs, Private lines, Charges for other telecom services. Outputs include: Customer Report, General Ledger Tape, Call detail tapes, Administrative Reports and Control Reports .Analysis, design, development, testing, implementation, and modification of existing programs as per business requirements were also include in my day to day responsibilities.

I worked on COBOL II, JCL, PROC, VSAM files, DB2, Control cards, Easytrieve to perform day to day maintenance job.

Environment/Skill Se

OS/390, MVS/JCL, DB2, COBOL II, VSAM, EASYTRIEVE, TSO/ISPF, FILE-AID

Technical Skills

Hardware: OS/390, IBM Compatible PC's

Operating system: ESA/VSE, MVS, MS-DOS, Windows NT 4.0, XP PROF.

Programming Language: VS COBOL II, JCL

Databases: DB2 6.0, MySQL, SQL SERVER 2008

Tools: TSO, ISPSF/PDS, FILE-AID

Scheduler: CA7, ESP

Utilities: SPUFI, QMF, PANVALET, PROEDIT, INSYNC, MAINFRAME EXP, COOLBIZ,

TELON, PLATINUM, EASYTRIEVE, QUIKJOB, DIALOGUE

Debugging: XPEDITOR, INTEREST, ABEND AID, NET EXPRESS

Transaction Processor: CICS

Others: HTML 4.0, WEB DESIGN, ORACLE SQL * PLUS, ORACLE G10, PEOPLE

SOFT, HP EXSTREAM 8.0

Education: Calcutta University, Bachelor Degree in Commerce with Honors.

Contact this candidate