SUMMARY

• Computer professional with extensive experience in Mainframe development, Data Warehousing, Analytical Reporting, development of business solutions for various industries.
• Extensive experience in system analyses and design utilizing direct communication with business users, collection of user requirements, creation of technical documentation and demonstrations of final products.
• Experience in development, implementation, and maintenance of multiplatform systems.
• Coordination of work across different teams including off - shore personnel.

TECHNICAL SKILLS

• MVS/XA/ESA
• WINDOWS XP/2000
• TSO/ISPF
• OS/JCL
• COBOL
• COBOLII
• DB2/SQL
• SPUFI
• QMF
• CICS
• VSAM
• FILE-AID
• SYNCSORT
• CHANGEMAN
• XPEDITER
• EDF
• INTERTEST
• PL/SQL
• UNIX
• MICROSOFT OFICE
• HTML
• Business Objects 5.1.8/9
• XI Release 2/3
• MS SQL Server
• MS Access
• ORACLE 8i/9i

PROFESSIONAL EXPERIENCE

Confidential, New York

Programmer/Analyst - Consultant

Responsibilities:

• This project involved design and development of new programs, jobs, procs, VSAM files, DB2 databases and customization of reports to fit reconverted by Pershing data to the Confidential Reporting System. Project also required the analysis and reengineering of dozens of modules to reduce the number of interfaces with Confidential external systems.
• Part of the project implicated changes of COBOL/CICS modules, DB2 database and JCL to Pershing specifications. Extensive testing of all involved components including unit, parallel, and user acceptance testing.

Environment: COBOL II, CICS, DB2/SQL, DB2 STORED PROCEDURES, SPUFI, FILE-AID, OS/MVS, OS/JCL, OS UTILITIES, TSO/ISPF, CHANGEMAN, INTERTEST, XPEDITER, COMPAREX

Confidential, New York/New Jersey

Programmer/Analyst - Consultant

Responsibilities:

• Designed and implemented a large number of production batch jobs both for archival and retrieval processing.
• Performed multiple changes to the existing jobs, procs, and programs necessitated by the processing changes, such as file expansions, changes of the files and DB2 tables used for reference.
• Modified a number of on-line programs to expand system functionality.
• Performed timely production support for the uninterrupted processing to satisfy users’ requests.
• Developed Web Intelligence (WEBI) reports using Chart, Combined query functions, Sub-queries.
• Designed and coded multiple Trading Surveillance reports that delivered the monitoring tools for the Compliance specialists.
• ‘One Day Price Difference Report for Individual Fixed Income Trades’
• ‘Three Day Price Difference Report for Individual Fixed Income Trades’
• ‘Price Difference report from the Mark Price’
• ‘As-Of Price Difference Report’
• Created a large number of ad-hoc reports to satisfy Compliance Users with the Trade History Data including collection of data for submission to SEC.

Environment: Cobol II, VSAM, DB2, CICS, JCL, File-Aid, SyncSort, Xpediter, Microsoft Excel, Changeman, Business Objects - WEBI, ZABO, Broadcast Agent, Desktop Intelligence, Web Intelligence, Infoview, DBArtisan

Confidential, New York

Consultant

Responsibilities:

• Took part in development and maintenance of Mortgage Servicing System and Mortgage Registration System.
• Customized Mortgageware - industry common software to suite specific needs of the company.
• Created data conversion modules to suit MERS requirements.
• Maintained statistical information on a weekly, monthly, yearly basis.
• Maintained information pertaining status of loans originated, serviced, and sold by FFL

Environment: SQL server, Excel, Mortgageware, Microsoft Office, HTML.

Confidential, New York

Programmer/Analyst - Consultant

Responsibilities:

• Made changes to batch process to split existing Request file in four parts according to the entity request repeated number of times, depending on timeframe of the user request.
• Enhanced a number of programs, used in different procs utilizing Trade file and created several programs to make changes to existing process for Sindicate reporting.
• Created a number of ad hoc reports to process historical trade information.
• Maintained several programs for Trading Violation System according to the new business requirements (e.g. if FC fully registered in home State, all IA registrations have been added according to the Security Registration).

Environment: Cobol II, VSAM, DB2, CICS, JCL, File-Aid, SyncSort, Xpediter, Microsoft Excel, Changeman

Confidential, New Jersey

Sr. Programmer/Analyst - Consultant

Responsibilities:

• Analysis of user requirements and creation of program specifications for Sales and Sample History, Product, and Customer conversions;
• Designing, coding, debugging a number of conversion programs for Sales History and Product conversions;
• Data analyses, cleansing, and manipulation.
• Test planning, execution, coordination and result communication;
• Supporting Integration Testing with the downstream systems;
• Participation in implementation;

Environment: Cobol II, DB2 (4.1), VSAM, JCL, SPUFI, File-Aid, SyncSort, Xpediter, Oracle (v8i), PL/SQL, UNIX, SQL station, Microsoft Access.

Confidential, New Jersey

Programmer/Analyst - Consultant

Responsibilities:

• Created a number of on-line Inquiry programs tracking the performance of sales representatives in various branches, regions, and territories.
• Developed Data Entry modules to add, change, delete information pertaining to sales representative activities.
• Updated DB2 tables such as: Policy Tracking, Policy Transaction and Employee Tables.
• Created reports reflecting activities of sales representatives.

Environment: COBOL II, CICS, DB2, TSO/ISPF, JCL, SPUFI, QMF, Xpediter, File-Aid, SyncSort