SUMMARY:

Dedicated technical professional with 30+ years of experience in Information Technology. Hands - on software development lifecycle (SDLC) background, requirements gathering, infrastructure analysis, solution design, development, testing, and implementation, utilizing mainframe technologies in professional environment. Equally experienced in new development projects as well as maintaining existing mainframe systems. Able to work independently as well as with a team. Specialties include COBOL, CICS, DB2, JCL, VSAM.

TECHNICAL SKILLS:

Applications: MS Office, Visio Pro, Rational ClearQuest

Languages: COBOL, CICS, DB2, SQL, EZTRIEVE, JCLCSP AD/AE, IBM VisualGen, Visual Basic 5.0, HTML, ANSI C

Tools: ChangeMan, SyncSort, $AVRS, SAR, Xpediter, InterTest, DebugFilezilla, DataStage, File-Aid, BMC, IBM utilitiesTSO/ISPF, SPUFI, QMF, VSAM, FTP and NDM

PROFESSIONAL EXPERIENCE:

Confidential, Oakland, California

Staff-Contractor

Responsibilities:

• MAINFRAME/COBOL/DB2/VSAM/SyncSort/JCL/FOCUS/DataStage
• Responsible for monthly loading of PPS and UCPath data into the CPS Corporate Data Warehouse through an extensive series of jobs, programs, and reports run using a variety of software tools to supply data to CPS users.
• Involved in CPS enhancement to cut over input data from PPS to UCPath as each campus converts to the new University-wide system.
• Performed PPS maintenance in compliance with requests from the University.

Confidential, San Francisco, California

Contractor

Responsibilities:

• MAINFRAME/COBOL/DB2/VSAM/SyncSort/JCL
• Enhanced Stock Plan Services (SPS) customer experience when exercising options or selling shares for taxes by putting a hold on cash funds to prevent customer from unknowingly using funds to trade before the 3-day settlement date.
• Created job to purge obsolete data from DB2 tables in order to reuse account type for SPS project
• Created job to correct commissions on trades filled over multiple days
• Created weekly batch jobs for Spread in IRA (SIIRA) project to review option positions and ensure they are captured on the right side (cash vs. margin) of the IRA account.

Confidential, San Francisco, California

Contractor

Responsibilities:

• Developed new batch components to in corporate new Confidential products into the Balance.
• MAINFRAME/COBOL/DB2/VSAM/SyncSort/JCL
• Developed an interim system to introduce 3rd Party Exchange-traded Funds (ETFs) product into BP&T systems.
• Developed a long-term solution for 3rd Party ETFs to replace interim solution.
• Worked on Aggregated Margins project creating DB2 table load jobs to populate new tables.

Confidential, San Francisco, California

Contractor

Responsibilities:

• Developed and maintained new online and batch programs to support the Cashiering systems.
• MAINFRAME/COBOL/DB2/VSAM/SyncSort/JCL/EZTRIEVE
• Developed 20 incoming and outgoing file transmission programs for the Bank Sweep Tower project.
• Developed and integrated a Redemption Suppression process into existing job flow to prevent flagged securities from being processed with valid securities.
• Performed analysis for the Asset Management Sub Track 4 project.
• Developed new transactions for the Asset Management Sub Track 3 project.
• Created batch mismatch report for the Asset Management Sub Track 3 project.
• Participated in code walkthroughs and reviews.

Confidential, San Francisco, California

Contractor

Responsibilities:

• Developed and maintained new integrated cashiering platforms used both internally within the organization and by clients on the Web.
• Platforms supported Java-based Integrated Cashiering System and .Net-based Client Central System.
• MAINFRAME/COBOL/DB2/VSAM/SyncSort/JCL
• Served as team lead for the Verbal IRA Distribution Project, creating technical design specifications and participating in database modeling and code development to enable the Client Central system to capture tax withholding elections for IRA retirement accounts.
• Developed code to add Real-Time Funds Transfers to the Client Central System.
• Migrated Check Disbursements code from the Integration Cashiering System to the Client Central System.

Confidential, San Francisco, California

Business analyst

Responsibilities:

• Identified data elements required for new provider and enrollee dental forms.

Confidential, San Francisco, California

Contractor

Responsibilities:

• MAINFRAME/COBOL/DB2/VSAM/SyncSort/JCL/EZTRIEVE
• Created and maintained batch programs used to load data to the Corporate Data Warehouse.
• Supplied data extracts to various groups throughout the organization.
• Responsible for answering email inbox troubleshooting questions that are sent to the group from within the company.
• Responsible for troubleshooting mainframe-related production problems.

Confidential, San Francisco, CA

Contractor

Responsibilities:

• Platforms supported Java, CICS and HTML clients.
• MAINFRAME/CICS/COBOL/DB2
• Participated in database modeling, screen design and code development for a system used to calculate and store the Required Minimum Distributions amounts that are required by law on retirement accounts for customers over the age of 70 ½.
• Designed screen flow and developed programs for a retirement distribution system (IRAS) able to channel funds by journaling between accounts and also in the form of outgoing checks to customers.
• Re-engineered the entire completed IRAS system to utilize the newly adopted company approach of using driver programs to call segmented APIs to process data
• Replaced the IRAS database and modified the existing code with a table structure designed to be shared between company systems.
• Incorporated the journaling of stock positions in the IRAS distribution system to allow journaling between accounts.
• Adapted backend APIs of IRAS system to be used by the Integrated Cashiering system, a Java front end client used to process checks, journals and wires.

Confidential, San Francisco, California

Senior Application Programmer/Analyst

Responsibilities:

• Developed and maintained programs used internally within the bank for storing customer information for automatic teller machine customers in a CICS/COBOL/DB2 environment.
• MAINFRAME/CICS/COBOL/DB2/VSAM
• Coded and installed enhancements to a customer information system that enabled bank employees to facilitate electronic banking card upgrades and downgrades for customers.

Confidential, Stamford, Connecticut

Project Leader

Responsibilities:

• Evaluated newly implemented Issuance System to ensure functionality. Responsibilities included communicating with branches to monitor system usage and coordinating implementation of modifications with project team.
• Managed database administration tasks including table reorganizations for all corporate systems.

Senior Programmer/Analyst

Confidential

Responsibilities:

• Served as project leader on a team developing an on-line Property Facultative Issuance system.
• Responsibilities included programmer management, database design, development of on-line applications, creation of conversion schedule and system implementation.
• Removed majority of VSAM files and replaced them with relational database as part of the new Issuance system.
• Developed and modified programs, screens, database tables and fields for project that provided multiple country/currency capabilities for existing underwriting system.
• Worked closely with users to ensure that applications met their needs.

Confidential, San Francisco, CA

Programmer/Analyst

Responsibilities:

• Designed, developed and maintained various reinsurance/accounting on-line applications and batch programs.
• Assisted the Database Administrator in the design of the corporate database and exported production database to IS test database, keeping test development current.
• Restructured an on-line insurance issuance subclass code entry and its respective batch report system.
• Analyzed job streams using VSAM files and produced programs to convert them to use SQL.