Mainframe Developer with demonstrated expertise in large-scale and complex projects in finance, billing, brokerage, credit cards, tax reporting, payroll, insurance claims processing, freight pay and accounting. Expert level in applying COBOL, CICS, DB2, Stored Procedures and MQ in all stages of systems development life cycle including design, development, business analysis, process re-engineering, data analysis, performance tuning and production support. Capable of coordinating cross-functional groups including offshore, handling multiple priorities and manage client expectations.
z/OS, OS/390, MVS, UNIX/AIX, Oracle, Windows, MS Office Suite, UML, RUP, Visio, MS Project, XML
COBOL, JCL, CICS VSAM, SQL NATURAL, ADABAS, ADSO, Easytrieve Plus, IMS, FOCUS, SAS, REXX, JAVA, DB2
QMF, SPUFI, Control-M, CA-7/11, Websphere MQ, Mainview, TMON/Omegamon, Explain, Performance Analyzer
Metastorm Integration Manager, SOA, ETL, JDA, Microstrategy, QC, QTP, Test Director, WinRunner, LoadRunner
Changeman, Endevor, Panvalet, Librarian, Startool, Insight, Detector, SP Builder, iStrobe, BMC Tools
PeopleSoft, People Tools, People Code, SQR, App Designer, App Engine; Infoman; CMMI, AFP, CSF
TSO/ISPF, SDSF, FILEAID, SYNCSORT, Xpediter, Intertest, CEDF; ConnectDirect (NDM), FTP, Remedy
Securities Movement and Control, Managed Accounts Reporting, Brokerage Accounting, Compliance, Transfer, Mutual Funds, Commercial Information, Worker\'s Compensation, Policy Master, Premium and Claims Processing, Credit Card Member Posting and Billing, Accounts Receivable, Sales Audit, Cash Management, Sales and Cash, Tax Reporting, Retirement Plans, Vendor Charge Back Authorization, Third Party Payments, Retail Operations, Budget Management, Freight Pay, Invoices, Tendering and Shipment Processes, Customer Relationship Management, Statements, Revenue Management
Confidential,Mainframe Consultant (9/2010 – 5/2012)
Conversion of CICS/VSAM/DB2 programs to COBOL/DB2 Stored Procedures for Brokerage Compliance system including development and maintenance, implementation and support. Create system, functional and technical specification, designed and developed extract programs, modules, jobs and cataloged procedures. Create test environment and developed test scenarios, test plans via Test Director, executed functional/system tests using WinRunner and LoadRunner. Development of COBOL/DB2 programs with XML parsing. Performed full SDLC including data analysis, modeling and mapping.
COBOL, CICS, VSAM, DB2, Easytrieve Plus, MQ, MS Project, Visio
Confidential,Sr. Mainframe Developer - Consultant (4/2010 – 8/2010)
Modification and testing of DB2 Stored Procedures within Above Property application for Revenue Management System. Created, tested and implemented process to help Sr. Market Account Executives to define their period and yearly sales goals. Created and updated test documentation. Analysis of application logistics with performance tuning and optimization. Production support and semi-annual Account Processing.
z/OS, JCL, COBOL, DB2, Stored Procedures, One Yield, SPUFI
Confidential,Sr. Mainframe Developer - Consultant (7/2007 – 2/2010)
Subject Matter Expert and QA Approver for Transportation Management System with analysis, specification development, coding, testing and post-implementation support for Import Transportation, Freight Pay, EDI and non-EDI Invoices modules. Created, validated, rerated and matched of vouchers and accruals for General Ledger, performed reconciliation analysis, research and data manipulation for Load Planning with locations, orders, carriers, resources, transit times, tender, shipment notifications. Conversion, maintenance, enhancements, monitoring, performance tuning and production support to ensure MQ-based secure transmissions between Mainframe, Oracle and Manugistics (JDA) using Microstrategy and Metastorm Integration Manager. Planned and conducted unit, system, integration, UAT, regression, disaster recovery tests and production validation. Spec/code reviews, analysis and redevelopment of process flow diagrams.
COBOL, CICS, DB2, MQ, XML, REXX, PeopleSoft, SOA, UNIX, Test Director, SharePoint, Easytrieve Plus, Visio
Confidential,Mainframe Systems Consultant (5/2006 – 4/2007)
Conversion of physical securities within Securities Movement and Control application per Piper Jaffray merger project, maintenance and enhancements for SOA-based Managed Accounts Reporting System to keep trades and holdings in compliance with regulations. Preparation of securities rating file and corresponding reports that reflects cash and eligible mutual funds concentrations, non-rated securities, product codes and special handling accounts. Created, developed and tested journals with client positions, balances, locations and general ledger offsets for safekeeping, custody, coupon bonds, legal transfer and restricted securities for margin/bookkeeping production of deposit tickets. Created process to construct count sheets, exception reports, summary and fractional files for Security Audit reconciliation.
DB2, Stored Procedures, COBOL, CICS, VSAM, JCL, XML, MQ, Fileaid, Changeman
Confidential,Mainframe Systems Consultant (5/2002 – 2/2006)
Specification development, coding and testing for Account Master file with set up of customer, clearing and reconciliation accounts, Securities Master file with formatted screen maintenance, Inquiry with up-to-date information on securities trading and Post-Trade Accounting subsystems to reconcile trades between clearing/customer accounts regarding CUSIP, settlement date, size and price. Assisted in setting up SWIFT messaging, modified existing job streams and PROCS. Maintenance of Transfer System to control transfer of securities between registered holders with online history tracking.
COBOL, DB2/SQL, Stored Procedures, CICS, VSAM, Easytrieve Plus, REXX, SAS, MQ, NATURAL, ADABAS, SOA
Confidential,Financial Systems, Application Developer (4/2001 – 3/2002)
System analysis, development, maintenance and production support of Commercial Information System for back end reporting on business property accounts activities. Systems and integration testing, improvement of application data flow and production schedule. Performed modifications and enhancements for Worker’s Compensation and Tax Systems, Policy Master, Premium and Claims Processing.
COBOL, CICS, DB2, Easytrieve Plus, VSAM, PL/1, NATURAL, ADABAS, MQ, XML, Panvalet, Changeman
Confidential,Financial Systems, Technical Specialist/Sr. Programmer Analyst (2/1999 – 3/2001)
Program and systems analysis, coding and testing for Sales Audit, Vendor Charge Back, Third Party Payment (bankcards operations), Sales and Use Tax Reporting and Retail Operations Budget Systems for tracking, monitoring and reporting on a diverse sales and cash flow production activities. Conducted IMS/DB2 conversion project for Vendor Database and PeopleSoft modifications for Supply Chain using People Tools, App Designer, SQR and App Engine. Participated in analysis, development for Time, Leave and Payroll Processing.
UNIX, COBOL, CICS, DB2, VSAM, IDMS, REXX, IMS, SAS
Confidential,Systems Consultant (7/1996 – 12/1998)
Development and enhancements for Credit Card Member Posting and Billing application. Systems analysis of Balance Transfer, Marketing database, set up of JCL and PROCS, functional specs and program development.
Specification development, actual coding and testing, production turnover and support for IRA/KEOGH reporting system to assign activity codes to certain types of transactions such as deposits and withdrawals of cash, transfers of cash and securities between IRA and other accounts.
COBOL, CICS, VSAM, DB2, REXX, BAL, JCL, SAS
Confidential,Programmer Analyst (7/91 – 5/96)
Development, maintenance, testing for Accounts Receivable System with emphasis on Customer Billing. Participated in system, integration and regression testing activities. Managed Journal Entry Subsystem, coded programs to report Allowances of Bad Debt. Created and modified JCL and PROCs. Handled ad-hoc requests and participated in production support and user training.
COBOL, CICS, DB2, VSAM, IDCAMS, Syncsort
M.S., Aeronautical Engineering
COBOL/CICS/DB2, BAL, Structured Testing, Test Director, WinRunner, LoadRunner
UNIX, AIX – 1999; Natural, ADABAS
PeopleSoft – People Tools, People Code, SQR, App Designer, App Engine
DB2 UDB for z/OS, Stored Procedures, Triggers; XML, Java; AFP, CSF
Websphere MQ, Websphere Application Service – 2003; CMMI, ETL, SOA