Senior Mainframe Programmer Resume

TECHNICAL SKILLS

COBOL II, CICS, DB2, JCL, QMF, TSO/MVS, VSAM, FTP, QSAM, GTAM, Easytreive, Quikjob, CA - Intertest, SyncSort
DB2, SPUFI, QMF, TSO/ISPF, WSDL files and SOAP, SMS, Abend-aid, Accuchek, MS-DOS, Java, C++, MySQL
Sharepoint Document Management, Cognos Query Studio, MS T-SQL, Visual Basic, MS-Windows, Windows Applications (Excel, Outlook, Word, Access).
Hardware troubleshooting, Windows configuration, HTML, XML, Endeavor, IDZ/RTz, T-SQL, EDI documents, XML parsing
DB2 query optimization, job performance tuning, and Waterfall and Agile methodologies for ALM.

PROFESSIONAL EXPERIENCE

Confidential

Senior Mainframe Programmer

Responsibilities:

Write stored procedures, COBOL DB2 programs, JCL, Easytrieves and QMF queries.
Full suite of IBM JCL products such as IDCAMS IEFBR14, among many others
Object migration using Endeavor and RTz
Production database updates using Easytrieve and SPUFI
Performance tuning
SME for the NY DOH Client Eligibility subsystem
Supports NYDOH client eligibility applications and eligibility updates of client tables
Use debugging tools to find and document system bugs
Expert knowledge of EDI 834 files
Heavy client interaction and client liaison.
Project migration documentation, QA and integration testing

Confidential, Franklin Lakes, NJ

Senior Software Architect Tech Lead Capability

Responsibilities:

Develop program specifications and scope estimates.
Corroborate with Master Data Management for daily feeds and hierarchical data structure design.
Write stored procedures, mainframe web services for MULE interface.
Production support
System checkouts
Performance tuning
SME for the Client Benefit Management (CBM) group
Hierarchical data structures and inherited benefits
Statement generation
Coordinate changes with onshore and offshore resources.
Develop ETL extracts from DB2 to MDM and Enterprise Information Warehouses (Cognos Report Net)
Assist with production problems.
Write, test, and debug COBOL DB2, DB2 stored procedures, JCLs, and CICS programs on a Z/OS IBM mainframe for the CBM application.
Create High Level and Design Level Documents
Leading a team of 4 developers
Gap analysis

Confidential

Senior Developer

Responsibilities:

Produce stored procedures and SSIS workflows for corporate reinsurance and portals.
Developed and maintained ETL processes and FTP to Cognos front end.
Tune reinsurance queries.
Developed premium and loss balancing reports in Cognos ReportNet.
Write, test, debug Cobol and EZtreive programs and JCLs on a Z/OS IBM mainframe. HTokio Marine Management is one of Japan’s largest property and casualty insurers.
Monitor monthly batch cycles and with operations staff fix production abends.
Assists actuarial, financial and underwriters on specifications of monthly quarterly and year end reporting.
Produce Ad-Hoc reports for DOI (Department of Insurance).
Set up queries on an Oracle Database using SQL Plus and MS-SQL Server.
Led business analysts to understanding of monthly reporting jobs for specifications to new TED system.
Wrote specifications to document TMM’s batch cycle.
Set up annual Triangle Reports for the Actuarial Department.
Worked on automation of loss-run reporting for the claims department.
Set up and analyzed premium and loss claims for ETL to a Data. Warehouse
Maintain annual triangle reports for actuarial analysis of claim data.
Perform maintenance on TMM’s reinsurance Outstanding Claim Item lists.

Confidential

Mainframe Programmer/Analyst

Responsibilities:

Write, test, debug DB2 Cobol programs and JCL’s on a Z/OS IBM mainframe. Confidential, the inventor of the money market fund, is a mutual fund house specializing in money (accrual) funds.
Produced numerous Ad-hoc reports using QMF and SPUFI.
Wrote an interface to Bank of New York for ACH transactions using NACHA format.
Modification or Purchase and Redemption validator for ACH feed from BNY.
Set up FTP JCLs for BNY ACH transactions.
Tune daily jobs for optimized performance using DB2 explain and others methods.
Designed and debugged an interface for a securities firm using the Fidelity trading platform
Set up a report program for users for cash reconciliation for institutional clients.
Set up a monthly report detailing banking activity for FDIC Insured Deposit customers in tiered rate accrual funds.
Worked with external auditors for year end reconciliation.
Worked on Datawarehouse extraction jobs for Cognos reporting.
Coded and modified COBOL and JCL for labels for mailings of legal documents such as prospectuses.
Worked with operations staff to troubleshoot production Abends and produce tapes.
Set up a system to prevent automated mailings to returned mail addresses, saving the company thousands of dollars a month on wasted postage and materials.