PROFESSIONAL SUMMARY:

IT professional with proven experience in design, development, implementation and maintenance of business applications involving full project life cycle and participation in relational database management.

TECHNICAL SKILLS:

Hardware: IBM 3081, 3032, 3033, 3090, AS, 9404, PC WORKSTATION

Software: COBOL, COBOL II, CICS, DB2/SQL, FILE - AID, SAS, MQSERIES, STORED PROCEDURES, DB2 ACCESS, SPUFI, DB UDMS, OMEGAMON, PLATINUM, IMS/DB, IMS/UTIL, FILE MASTER AS400/COBOL, AS400/COBOL-INTERACTIVE, AS400/CL, SQL/400, DB2/400, VSAM, DB2, IDMS, ADSO, OS/MVS, OS/JCL, PROCS, OS UTILITIES, FOCUS, SAS, CULPRIT, TSO/ISPF, CHANGEMAN, COMPAREX, INTERTEST, XPEDITER, EASYTRIEVE, MICROSOFT EXCEL.

PROFESSIONAL EXPERIENCE:

Confidential, Sleepy Hollow, NY

Consultant /Analyst/Technical Specialist

Responsibilities:

• Key member of the technical team involved in off going conversion of Confidential IMS database system to DB2 database.
• Worked with Confidential personnel to insure properly mapping of IMS segments to DB2 tables, generate the DB2 DDL, and generate the processes for getting the IMS data onto new DB2 table.
• Provided technical analyses and unit testing of embedded SQL statements in new the I/O calling modules written to access DB2 database.

Environment: COBOL II, CICS, VSAM, DB2, DB2/SQL, IMS/DB, IMS/UTIL, IDMS/DC, ADSO, SPUFI, FILE-AID, PLUTINAM, OS/MVS, OS/JCL, PROCS, OS UTILITIES, TSO/ISPF, NYLLMS, XPEDITER, COMPAREX, MICROSOFT EXCEL.

Confidential, Rye, NY

Consultant /Analyst/Technical Specialist

Responsibilities:

• As a Technical Lead of off-shore and on-site group of developers supported day-to-day running of the President’s Recognition Program (PRP) subsystem. PRP provides recognition and rewards to Representatives for outstanding in Total Sales, Sales Increase and Leadership in a business cycle that runs from the April of current year to the March of the next year. Wrote technical specifications used by the members of the support team to enhance PRP system.
• As a Technical Lead of off-shore and on site group of developers supported day-to-day running of the Leadership Sales subsystem. Leadership is Avon’s Multi-level Marketing (MLM) program. In MLM program, sales Representatives appoint other Representatives and earn a percentage on their sale.
• Wrote technical specifications used by the members of the support team to enhance Leadership system.
• Full cycle project that involved analyses, design, hands-on development and production implementation of PRP DB2 Data Base Expansion. The project consisted of adding new columns and expanding lengths of existing columns on the number DB2 tables. Columns modifications were primarily designed to prevent truncation of sales amounts that had periodically occurred for bonus sales amounts.

Environment: COBOL II, CICS, VSAM, DB2, DB2/SQL, IMS/DB, IMS/UTIL, STORED PROCEDURES, MQSERIES, SPUFI, DB2 UDMS, FILE MASTER, OS/MVS, OS/JCL, PROCS, OS UTILITIES, TSO/ISPF, AS400/COBOL, AS400/COBOL-INTERACTIVE, AS400/CL, SQL/400, DB2/400, CHANGEMAN, INTERTEST, EASYTRIEVE, MICROSOFT EXCEL

Confidential, New York, NY

Senior Programmer / Analyst

Responsibilities:

• As a member of Compliance Tech Services team responsible for the support of Trade Surveillance System, participated in the conversion of the retail Confidential brokerage accounts onto the third party platform, Pershing LLC a subsidiary of BNY Mellon.

Environment: COBOL II, CICS, VSAM, DB2, DB2/SQL, SAS, MQSERIES, STORED PROCEDURES, SPUFI, FILE-AID, OS/MVS, OS/JCL, PROCS, OS UTILITIES, TSO/ISPF, CHANGEMAN, INTERTEST, XPEDITER, COMPAREX, MICROSOFT EXCEL.

Confidential, New York, NY

Senior Associate / Senior Programmer / Analyst

Responsibilities:

• As member of the staff participated in day-by-day production support, enhancement of CPI (Customer Profile Information) system.
• Enhancements were made to the original system to simplify clients’ experience of the account opening process.
• Number of changes were done both limited the amount of paperwork on account opening activities, and created an effective and valuable experience for the customers.
• Key member of the team responsible for full cycle project which involved redesign, development, implementation and day-to-day support of CPI CIP-AML (Customer Profile Information Customer Information Program Anti Money Laundering) system.
• Member of the team responsible for full cycle project that involved of design, development, implementation and initial support of new Welcome Kit (WK) system. WK is a brochure that client receives upon the opening of the new account.
• Responsible for support and maintenance of Monthly CPI Purge cycle. Purge process of comprised of the parts.

Environment: COBOL II, CICS, VSAM, DB2, DB2/SQL, SAS, MQSERIES, STORED PROCEDURES, SPUFI, FILE-AID, FTP/SFTP, OS/MVS, OS/JCL, PROCS, OS UTILITIES, TSO/ISPF, SAS, CHANGEMAN, INTERTEST, XPEDITER, COMPAREX, MICROSOFT EXCEL.

Confidential, New York, NY

Consultant / Senior Programmer / Analyst

Responsibilities:

• Wrote a number of reports and fixed programs that would help business and system analysts to eliminate errors and inconsistencies created as a result of conversions.
• Created reports that would help the analyses and consequential breaking of Confidential (Household) accounts.
• Reports were designed to help Confidential management team eliminate wrongfully consolidated Confidential accounts.

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

Confidential, New York, NY

Consultant / Senior Programmer / Analyst

Responsibilities:

• Key member of a team that created a standalone Stock Loan system from one that was highly integrated with the PSI back office operations, and ported it to a third party service bureau (TPSF). This involved customizing over 1,200 programs, more than 300 jobs to execute on the TPSB’s computer system along with over 350 VSAM files, 2 DB2 databases and customizing hundreds of reports to fit their online report viewer software as well as learning the new development environment on the fly. This also required the analysis and reengineering of dozens of modules to reduce the number of interfaces to external systems down to less than a dozen.
• Part of the project implicated changes of COBOL/CICS modules, CICS maps, DB2/SQL, DB2 database and JCL to Wachovia specifications. Extensive testing of all involved components including positive/negative testing and user acceptance.

Environment: COBOL, COBOL II, CICS, VSAM, IDMS, DB2, DB2/SQL, DB2 ACCESS, SPUFI, FILE-AID, OMEGAMON, PLATINUM, OS/MVS, OS/JCL, PROCS, OS UTILITIES, TSO/ISPF, CHANGEMAN, INTERTEST, XPEDITER, COMPAREX, MICROSOFT EXCEL.

Confidential, New York, NY

Consultant / Senior Programmer / Analyst

Responsibilities:

• Responsible for enhancement, maintenance and production support of Confidential (Depository Trust Company Integrated Cashiers Management Institutional Delivery System).
• Support of DVP (Delivery Verses Payments) and ACATAS (Account Customer Automated Transfer System) systems.

Environment: COBOL, COBOL II, CICS, VSAM, IDMS, DB2, DB2/SQL, DB2 ACCESS, FILE-AID, SPUFI, OMEGAMON, PLATINUM, OS/MVS, OS/JCL, PROCS, OS UTILITIES, FOCUS, CULPRIT, TSO/ISPF, CHANGEMAN, INTERTEST, COMPAREX