SUMMARY:

A results - oriented Information Systems Professional with experience in analysis, design, development, implementation and maintenance of business systems. Broad technical knowledge combined with leadership ability and creative problem solving skills. Effective communicator and technical expert with consistent track record in delivering bottom-line results.

TECHNICAL SKILLS:

Hardware: IBM 3090/370 Series, IBM PCs and Compatibles, ES900

Software: IBM COBOL, ORACLE, DB2, CICS, JCL, MQ Series, VSAM, REXX, EASYTRIEVE, GAMMA, ISPF, JCL Utilities, DB2 (IBM) Utilities, DB2 (BMC) Utilities, ORACLE PL/SQL, SQL LOADER, Oracle Utilities, ORACLE SQL DEVELOPER, DB2 STORED PROCEDURES, ORACLE STORED PROCEDURES, IBM RATIONAL DEVELOPER FOR Z SYSTEMS, IBM DATA STUDIO, TOAD FOR DATA ANALYSTS, IBM DEBUG TOOL, IBM FILE MANAGER FOR Z/OS, PLATINUM PRODUCTS, PROEDIT, SPUFI, QMF, FILE-AID/DB2, SYNCSORT, INTERTEST, XPEDITER, FILE-AID, ENDEVOR, LIBRARIAN, CHANGEMAN, ESP, CA7, HTML, XML, JavaScript, VB, VB Script, ASP, MSMQ, VISIO, MS-Office, ORCHESTRIA.

PROFESSIONAL EXPERIENCE:

Developer

Confidential

Responsibilities:

• Development and implementation of Broker Dealer Separation (BDS) project for CAPS, MICS and Pierce Repo systems utilizingIBM COBOL, DB2, CICS and MQ.
• Completed full analysis and implemented BDS changes for the MICS Reconciliation process (Batch, CICS, DB2 and Web Interface).
• Implemented new DTCC data feeds to MICS system to handle new Participant ID’s using new conversion process between DTCC subaccounts and CAP boxes. (Batch, DB2, VSAM).
• Analysed, developed and implemented SEG 100 Position Reports to handle DTCC vs. ML Stock Record reconciliation process. (Batch, CICS, DB2 and VSAM)
• Developed new process to handle BDS changes for the hardcoded application accounts (Batch, CICS, DB2, VASAM and MQ).
• Implemented changes to handle new legal entity data flow through CICS applications. (CICS and VSAM)
• Performed technology upgrades and full regression testing to convert CICS and BATCH modules to a new version of IBM COBOL5 software.
• (CICS, DB2 and VSAM)
• Development and implementation of Miami Pearl Option Exchange utilizing CICS, DB2, VSAM and MQ.
• Changes were made to the following systems: Clearing, Core TP (Trade Processing), GTR (Global Trade Repository)
• Completed full analysis on changes related to introduction of a new Option Exchange. (Batch, CICS, DB2, VSAM and MQ).
• Implemented new data validation process and loaded new data for Miami Pearl Exchange (Batch, DB2 and VSAM).
• Performed full cross system testing (Batch, CICS, DB2, VSAM and MQ).

Lead Developer

Confidential

Responsibilities:

• Development and implementation of WEBFICOS Registrations Portal functionalities utilizing DB2 Stored procedures.
• Web-based Portal provides full scale functionality for maintenance of US securities registrations with FINRA and NFA. WEBFICOS has a comprehensive firm-wide solution to manage securities registrations and licenses for more than 25,000 Financial Advisors and U.S. securities registered employees.
• Analyzed and documented registration related rules and functionalities of legacy mainframe system.
• Provided screens design and functionality to Front-end Java team and supervised detail implementation.
• Created back-bone process (DB2 Stored procedures) to support Portal functionality.
• Development and implementation of WEBSLIC synchronization process utilizingIBM COBOL, DB2, CICS and ORACLE.
• Objective of WEBSLIC project was to re-platform Insurance Licensing application by introducing new Web interface.
• Completed full analysis and documentation of legacy user interface (CICS).
• Designed and implemented two way Synchronization process between Legacy database (DB2, VSAM) and new ORACLE database.
• Created new ORACLE tables, procedures and modules to support synchronization process.
• Development and implementation of HR XREF database utilizingORACLE.
• HR XREF database is loaded from GDW (Global Dara Warehouse) published feed and is used as a main source of employee’s data.
• Developed stored procedures to validate and load data into XREF database
• Created new tables, materialized views, triggers, functions to support XREF load process.
• Performed enhanced testing and production implementation.
• Development of Orchestria database utilizing Oracle and support of Orchestria communication monitoring system utilizingknowledge of Polish language.
• Orchestria database feeds Orchestria monitoring system with latest monitoring hierarchy status.
• Developed validation process to support wide variety of rules and policies present in Orchestria system
• Created tables, functions to support Orchestria validation process.
• Prepared Polish syntax translations and supported production implementation.
• Performed improvementsto the system design to improve system stability.
• Performed Ad-Hock system changes to meet business requirements.
• Analysed data validation rules and data flow process, provided support to system conversion process.

Software developed:DB2 Utilities, FILE-AID/DB2, SPUFI, JCL UTILITIES, SYNCSORT, XML, INTERTEST, FILE-AID, CHANGEMAN, PL/SQL, SQL LOADER, SQL DEVELOPER and MS-Office.

Tech Lead/ Team Lead

Confidential

Responsibilities:

• Technical Lead managing offshore team. Analysis and development of Integrated Billing System (IBS) and Integrated Check Writing System (ICW) utilizingData Warehouse, Teradata, DB2, ORACLE, IBM COBOL and CICS.
• IBS/ICW systems provide finance information to more than 60 000 pharmacies.
• Designednew Teradata storages/ DB2 tables, provided solutions for the new data flows, new business logic was implemented, changes were made to HIPAA 835 Outbound transactions layout, coded new modules to support functionality changes, allowing efficient data processing and system stability.
• Performed enhancements and improvementson ICW Directs/ Pharmacy Cycle/ Payment Remittance systems, providing software stability during heavy batch executions.

Software developed utilizing: MQ SERIES, DB2 Utilities, PROEDIT, SPUFI, QMF, JCL UtilitiesREXX, EASYTRIEVE, INTERTEST, FILE-AID, VISIO, MS-Office.

Lead Developer / Team Lead

Confidential

Responsibilities:

• Analysis, redesign and implementation of EH (Exception Handling) system utilizingIBM COBOL, DB2, CICSandMQ Series.
• EH system handles Rating/Billing exceptions using on-lines and automatic resolution process.
• Redesigned EH database, resolving inefficient database structure, improving exception handling by on-line and batch process, providing better accommodation of future changes.
• Changed on-lines and batch modules, supporting database changes and allowing efficient data process.
• Created new market/data type dependent feed to user’s database, providing users with complete exception information and allowing improvements in exception resolution approach.
• Analysis, design and development of EDR Conversion process utilizingIBM COBOL, DB2 and MQ Series.
• EDR Conversion is part of Rating/Billing customer conversion process between Vision and I2K billing systems.
• Designed and implemented EDR conversion process, allowing successful customer data conversion between two billing systems.
• Provided complete analysis on data validation rules to allow successful converted data flow through Vision Rating system.
• Created new data streams for conversion markets, providing efficient data process of new and accumulated data messages (volume: two billion calls/transactions).

Software developed utilizing: DB2 Utilities, FILE-AID/DB2, SPUFI, QMF, JCL UTILITIES, SYNCSORTEASYTRIEVE, XML, XPEDITER, FILE-AID, ENDEVOR, CA7, VISION, MS-Office.

Senior Programmer/Analyst

Confidential

Responsibilities:

• Analysis and development of Employee Information System (EIS) utilizingIBM COBOL, DB2,CICSandVSAM.
• Designed and implemented Timekeeping Summary screens, allowing users to make fully informed decisions.
• Created Accrual Adjustment screens, enabled users to make reason-based corrections and adjustments.
• Development and Maintenance of Payroll system utilizingIBM COBOL, CICS, DB2andStored Procedures.
• Designed DB2 database for HBANKscreens, insuring data integrity and allowing efficient dataprocessing.
• Performed enhancements and improvements of overtime/deductions modules, providing introduction of new transactions to the system.

Software developed utilizing: IEW/GAMMA, DB2 Utilities, Platinum Products, SPUFI, QMF, JCL Utilities, INTERTEST, XPEDITER, FILE-AID, LIBRARIAN and MS-Office.