SUMMARY:

Information Technology services professional with extensive experience in design, development and maintenance of various applications, involving Waterfall /Agile/Scrum methodologies in Software Development Life Cycle (SDLC).

TECHNICAL SKILLS:

HARDWARE: IBM308X, MVS/390, 370, IBM PC, UNIX

SOFTWARE & LANGUAGES: COBOL, CICS, MQ SERIES, SQL, DB2, VSAM, QMF, SPUFI, OS/JCL, FILE - AID, ENDEVOR, CHANGEMAN, PANVALET, SYNCSORT, XPEDITOR, INTERTEST, BMS, SDF, COMPAREX, BMC A/R, DB2 UTILITIES, VIASOFT, MS OFFICE,RACF,PLATINUM,FTP,NDM, GTB,OPC,CA-7

PROFESSIONAL EXPERIENCE:

Confidential, CO

Sr. mainframe DEVELOPER

• Participated in analyses and requirement gathering. Documented new processes and wrote technical specifications.
• Worked with DBA’s to accommodate various DB2 change requests, including tables and indexes alterations.
• Redesigned and devleoped new Order Edits and Routing functionality, to accommodate all Global Booking Centers.
• Modified BATCH/FTP mutual funds executions feed process for confidential Fund/SERV system transmission.

Environment: WEB SERVICES /COBOL / CICS / VSAM /DB2 / DB2 Stored Procs/ MQ SERIES/ SOA/ENDEVOR

Confidential

SR. mainframe DEVELOPER

• Interacted with Project Stakeholders, participated in requirement gathering and in releases implementation planning.
• Created high level functional designs as well detailed technical specifications. Provided QA and Production support.
• For Confidential merger created Membership Eligibility service, Data conversion and Load processes
• Designed and developed Manufactured Backorder Recapture system for TRICARE for life DOD beneficiaries.
• Provided assistant and built various modules for Managed Care system and DRUG Inventory Warehouse projects.
• Developed CICS/DB2 tasks using CHANNELs / CONTAINERs technique and created DB2/SQL Stored Procs.
• In Agile framework developed Address Protocol notification system. System utilized CICS WEB Services.
• Developed numerous BATCH/DB2, JCL/PROCs, (S) FTPs, Reports, deploying SYNCSORT and EASYTRIEVE.

Environment: COBOL / CICS / VSAM /DB2 / DB2 Stored Procs/ MQ SERIES/ SOA/WEB SERVICES /ENDEVOR

Confidential

Sr. mainframe DEVELOPER

Responsibilities:

• Participated in functional analyses and design. Created technical specifications and front end integration environment.
• For TARP regulatory compliance project, created ASSET gift and inheritance functionality in wash sale modules.
• Changed various CICS/SQL modules to enhance inquiry/update tax lot split cost basis recalculations.
• Developed DB2 Stored Procedures to process street side transfer accounts and perform multi currency conversion.
• Developed SQL/BATCH programs and JCL/PROCs to accommodate Cost Basis Reporting for account transfers.
• Collaborated users and data requirement, performed SQL tuning, coordinated QA releases and Production support.

Environment: COBOL / CICS / DB2 / VSAM / MQ SERIES/ DB2 Stored Procs

Confidential

Lead mainframe DEVELOPER, ARCHITECT

Responsibilities:

• Participated in new systems architecture design. Analyzed data requirement and created technical specifications.
• Redesigned and developed several CICS functions, which is used to process and update activities in CCF Database.
• Enhanced online Reason Action Disposition component, which processes research transactions, of CCF activities.
• Created batch modules and JCL/PROCs to accommodate CCF reporting and multiple feeds generating jobs.
• Set up BATCH/CICS test environment. Prepared test scripts as well as Batch Job scheduling.
• Participated in coordination of on-site and off shore teams. Led a production support team including QA personnel.

Environment: VB6/COBOL / CICS / DB2 / VSAM / MQ SERIES/ENDEVOR

Confidential

Sr. Programmer Analyst

Responsibilities:

• Developed CICS background tasks to create and update Loan’s Master Facility and Opening Balance transactions.
• Created numerous DB2 Stored Procedures to accommodate matching loan’s positions proposals functionality.
• Implemented batch tasks and JCL/PROCs, which are used to generate a variety of AD-HOC and overnight reports.
• Created FTP /NDM jobs to transfer reports to UNIX. Coordinated QA packages promotion and demotion.
• Was involved in system performance test, SQL queries tuning, Database design and alteration.
• Assisted other team members and provided support for User Acceptation Test and interacted with Project stakeholders

Environment: COBOL / CICS / VSAM/ DB2 / MQ SERIES/ CHANGEMAN /DB2 Stored Procs

Confidential, NY

Sr. Programmer Analyst

Responsibilities:

• Was involved in architecture analyses, requirements gathering and system design.
• Developed Stock Record Options Validation CICS/DB2 API modules.
• Created process to validate exchange routing for equities trades.
• Scheduled, implemented and supported numerous COBOL/DB2 jobs for the system integration flow.

Environment: COBOL II / CICS / VSAM/ DB2 / MQ SERIES/ ENDEVOR

Confidential

Sr. Programmer Analyst

Responsibilities:

• Participated in Financial Consulting portal addition. Developed batches to load FC PDF feed to BOM database.
• Analyzed and restructured existing DB2 tables to accommodate new data requirements.
• For HELOC portal developed DB2 Stored Procs to display borrower info, loan activities and lending requirements.
• For Legg Mason conversion, created Batch jobs to convert and load historical data into BOM portal database.
• Implemented DB2 Stored Procs for accounts, which are impacted by security class action.
• Modified DB2/CICS programs and DB2 Stored Procs to resolve different production issues.

Environment: COBOL II / CICS / VSAM/ DB2 / CHANGEMAN

Confidential

Sr. Programmer Analyst

Responsibilities:

• Created DB2 module to synchronize Master DB.
• Developed multiple programs to convert Matched Reclaims to Confidential process, transform Cost Basis and sent them to confidential Special services.
• Designed and implemented universal feed that accepts various file layouts from transformation programs and stores the records into UBS Staging Tables.
• Created and tested JCL and PROCS for the new job streams.
• Was involved in creation of system implementation plan and system installation coverage.

Environment: COBOL / CICS / VSAM/ DB2 / CHANGEMAN

Confidential, NJ

Sr. Programmer Analyst

Responsibilities:

• Supported different systems and various projects in the Order and Trade Processing Department.
• Was involved in maintenance and development of new functionality for the Direct Order Routing System (DORS). DORS provided trading capabilities of Equities & Options exclusively for the Wire & Order Room.
• Performed support of Orders, Executions and Trades (OET) system. OET collects, stores or provides data to the trading the systems, and produces trades details feed to the Purchase and Sales (P&S) confirmation process.
• Designed and implemented CICS middleware, to swap trading activities between webs based Consolidated Order Entry system, and mainframe supported DORS. Developed transaction summary and trade detail inquiry functions.
• Developed real time figuration process and equity average pricing functionality. Created execution activity reports for solicited securities. Created DORS system Log & Recovery process.
• Developed Trade Bundling User Entitlements validation, Trade Bundle updates process, tuned Orders Correction functionality and modified Trades Reconciliation process.
• Worked with DBA’s to accommodate various DB2 change requests for tables and indexes alterations.
• Developed programs to extract, transform and load database, according to the new tables’ layouts. Prepared JCL, PROC, CNTLCARDS needed for the new change implementation.
• Developed and implemented CICS/DB2 background tasks, which are used to process transactions, related to the Broker Dealer Trades, and then update/ load related entries onto OET.
• Interacted with users, and on the daily basis participated in QA and Production support.

Environment: COBOL / CICS / VSAM/ DB2 / MQ SERIES/ CHANGEMAN

Confidential, NY

Sr. Programmer Analyst

Responsibilities:

• Due to major data consolidation between Prudential Securities and Prudential Insurance implemented Agent Database Security Interface system on Prudential Securities site, and modified system according to the new standards.
• Modified several on-line and batch modules for VSAM to DB2 data conversion. Changed, tested and implemented various JOBS, PROCS & CNTLCARDS to comply with DB2. Created and imbedded newly designed SQL.
• Designed and developed License Check system. In real time as well as interactively, system validates broker/agent credentials and authorizations to perform variety of business transactions.
• Modified CICS background tasks, which are used to swipe data between DB2 and VB front-end.
• Developed monthly, quarterly, and semi-annually broker’s license status reports.

Confidential, NJ

Sr. Programmer, Analyst/ Consultant

Responsibilities:

• Developed API modules, which are deriving data from multiple DB2 tables and creating Cash Management Account Master File, to feed Statement Processing system.
• Participated in IDMS to DB2 Trade History database conversion. Developed several conversion programs. Modified access path of CICS transactions across the entire system. Modified existing batch modules and changed various JCL’s, PROC’s. Embedded BMC A/R into renovated programs. Created reports and implemented user-request jobs.
• Performed on call production support and troubleshooting.

Environment: COBOL / CICS / VSAM/ DB2 / IMS

Confidential, NY

Programmer, Analyst/ Consultant

Responsibilities:

• PCS was created to provide a centralized database supported by an on-line function, and allow the users to identify, prioritize, resolve, and track the workflow of securities requiring a DTC CUSIP.
• Developed various CICS/DB2 modules, which allow to: load and update PCS database, feed other systems with PCS resolved transactions, determine the presence of stock certificates, view stock certificates, generate and maintain audit trail statistics for all changes in PCS.
• Created on-line report request and user comments screens with update/inquiry functionality.
• Interacted with users analyzing test results and screen layouts. Modified several CICS programs.

Confidential, NY

Programmer, Analyst/ Consultant

• Modified files and report layouts, changed programs logic according to the new requirements. Prepared test components by using VIASOFT query facility.
• Set up batch test environment including JCL, PROC and CNTLCARD libraries. Developed file conversion programs. Overwrite PROC’s, tested and batch programs using XPIEDITOR.
• Redesign CICS screens and modules according to the Y2K standards. Tested converted CICS programs using INTERTEST and PLAYBACK.

Environment: COBOL / 370, VSAM/ CICS.