A results-oriented IT professional with over 20 years of solid experience in the insurance and financial industries. Application programmer in the IBM mainframe environment with strong technical and interpersonal skills. Adept at identifying problems and providing immediate solutions.

Hardware: IBM mainframe IBM PC and compatible

Software: COBOL, COBOL II, PL/1, DB2/SQL, VSAM, CICS, IMS DB/DC, Intertest, Expediter, OS/MVS/JCL, TSO/ISPF, RDz, SDFII, Endevor, Fileaid, SYNCSORT, IBM utilities, in-house utilities, ACCESS, CHANGEMAN, INFOMAN, MQSeries, Easytrieve, XML

PROFESSIONAL EXPERIENCE

Confidential

DB2 SQL developer

Accomplishments

• Customer Service Charge systems calculates fees for Directly Debited and Billed customers based on accounts' fee based and balance compensated charges. It generates automatic Debits and Customer Invoices/Advices. The platform
• is COBOL2, CICS, DB2, VSAM, IMS DB/DC. Designed, coded, tested and implemented enhancements for the Accounts Deferral project.

Lead IT Analyst Consultant for Marketing and Trending team

Accomplishments

• True Demand Project extensive enhancement to the existing systems will improve revenue for the business with
• improved ability to service the representative and reduced year-end inventory levels. The demand is captured
• from eCommerce. Online analysis, flow book, reporting, Supply Chain capture, trend forecast will be provided.
• Major contributor to coding and testing of components required to support the initiative utilizing

COBOL2, CICS, DB2, VSAM.

• As part of support effort for the system responsible for requirement analysis, coding/testing. Conducted user testing involving downstream systems . Worked with other developers, database management, release management and change management teams to install changes in production.

Lead Programmer Analyst for Fedwire Securities Modernization Project

Accomplishments

• Conducted deep and detailed analysis of the current Fedwire system. Created technical documentation for the design of the new custom built applications that replicate the existing functionality.
• Customer Information Subsystem using COBOL2, CICS, DB2, VSAM.
• Responsible for analysis, design, coding and implementation of enhancements and technical support of
• The Fedwire Securities Service provides safekeeping, transfer, and delivery-versus-payment settlement services to US depository institutions and US branches and agencies of foreign banks. The Fedwire securities system maintains in electronic form all marketable US Treasury Securities, as well as many federal agency, government sponsored enterprise and certain international organizations securities.
• Developed and implemented interfaces from the current mainframe system to the new Java-based application using

IMS DB/DC.

• Led QA team members in comparative testing effort resulting in the creation of test data to be used for like-for-like parallel testing with the new system.

Lead Programmer Analyst / DB2 SQL developer / Consultant for Statements and Master Security Description teams

Accomplishments

• Lead Developer for the Asset Classification team. This new engine classifies assets using an attribute-based approach and standardized Taxonomy. The mechanism gives downstream applications the flexibility to choose from a number of application-specific views as required. The platform is COBOL2, VSAM, CICS, DB2/SQL.
• Developed and implemented DB2 interfaces for Morgan Stanley Smith Barney joint venture .
• Conducted unit, regression and system testing. Created ad-hoc SQL queries, worked with DBAs on table creation and expansion.
• Miscellaneous changes, enhancements, ad-hoc requests for production support and troubleshooting.
• Statement Renovation project. Designed, developed and implemented interfaces from mainframe to Data Warehouse. Researched and documented the current mainframe process, revised and reworked jobstreams, validated test and parallel runs outputs.
• Consultant for Transaction Management / Correspondence Clearing System
• Updated application programs and performed unit, QA and user acceptance testing UAT . This system processes daily trade transactions from different systems and routes it to other systems for further processing.

Consultant for Master Security Description team

• Designed, coded and implemented numerous screens/programs to augment the CICS portion of CitibusinessOnline. The system supports incoming and outgoing wires processing as well as front-end users' business and account maintenance.
• Provided timely response to users' requests for problem investigations and ad-hoc reports.
• Developed and implemented CICS/DB2 part of Batch Book Transfers, a major enhancement to CitibusinessOnline created a new front-end facility.
• front end.
• is CICS/VSAM/DB2. It consists of a traditional mainframe system and provides data transfer for the Web
• CitiBusiness Online is a Web-based HTML/Javascript/Java small business banking system. The back-end
• Changes and enhancements for production support and troubleshooting.
• Designed, coded and implemented independently and as a member of a team enhancements for pricing and reporting.
• Single-handedly developed MARS system to automate a highly labor-intensive manual process producing bond rates for Master Security Description. It will considerably improve data accuracy and result in savings of a full-time resource. The COBOL batch and online system has over 40 components using MQSeries messages.
• Participated in two conversions due to bank acquisitions. Developed several reports and interfaces from outside sources to the DB2 database.
• Performed production support including on-call support.

Senior Programmer Analyst

Accomplishments

• Designed, coded and implemented a new screen and a batch process to accumulate and display TMS statistics on a daily, weekly and monthly basis for a 12-month period.
• Responsible for the support of the online portion of Trade Management System.
• total using a DB2 database as the source .
• Designed and developed a subsystem to support changes in Commission Schedules. 9 modules
• Over 50 programs changed to conform to the new release of CICS.

Business Application Specialist,

Accomplishments

• Solely responsible for the support of Life Long Term Disability, a CICS/batch claims processing system.
• Single-handedly wrote all programs and set up all job streams required to convert mainframe claims processing application from NYLCARE to AETNA system.
• Created feeder files using VSAM input to be loaded on ACCESS within a very short timeframe. Over 100,000 records of 15 types in two weeks.

Accomplishments

• Supported and enhanced the interface between claims and check-writing. Added several sites by setting up new JCL procedures using FTP and XCOM. After the implementation was responsible for production support and troubleshooting resulting in increased customer satisfaction. Performed supervisor's duties during her frequent absences.
• Supervised and trained a team of four programmers responsible for development and maintenance of three insurance systems:
• LLDS, an online and batch COBOL/PL1/CICS claims processing and recording system. The batch part provided reports and interfaces with other systems.
• Third Party Administration System used tapes, cartridges and transmissions as input to LLDS.
• Disability System produced numerous disability reports.
• Performed nightly on-call support, scheduling production and model office job streams, ad-hoc reports, setting up disaster recovery tasks.
• Supervised the team responsible for a smooth installation, complete testing and burn-in of a package replacing IMS DB/DC Group Claims Processing System. The team worked on an interface with an existing RAMIS system.