Business Analyst Db2 Dba
Resume:
EDWIN NIEVES
*********@*****.***
North Bergen, NJ
Summary: Senior Business Analyst, Application programmer Analyst, DB2 DBA and RDZ Developer with hands-on, experience in Financial, Retails, Publishing and Health Care Industries. Specializing in Analysis, development, testing, design, and production support for Business and systems applications. Latest experience as a WEB server developer for CICS (RDZ for system Z). Work with Agile, SDLC, and Waterfall methodologies.
Professional experience in Online (CICS/JCICS) and batch processing (JCL, COBOL) interfacing with JAVA, UNIX servers and Oracle Database applications. Also involved in the full life projects Cycle and project management. Experience includes working as a DB2 DBA, Online and Batch application developer, and project lead. As a DB2 DBA support People-soft platform with HR and Financial applications. Creating and altering Data Bases for Financial and Brokerage industry, development, enhancement and implementation for Mainframe applications. Production support for online trading system, batch and online applications. Worked as project lead, Coordinating releases using Endevor and Change-man with more than 5 years’ experience.
Hardware: IBM-3090, IBM-370, IBM PC, IBM SERVERS.
SOFTWARE: COBOL, COBOL2, COBOL3, COBOL LE, CICS, CICS, JCICS (CHANNEL AND CONTAINERS, WSDL AND RDZ), DB2, NSP (NATIVE-STORE-PROCEDURES), COBOL/DB2 STORE PROCEDURES, DB/DC,DML, DCL, DDL, SQL, VSAM, OS/JCL, FTP, SFTP, TSO/ISPF, OS/UTILITIES, DYLL280, EZTRIEVE, QUIKJOB, XPEDITER, INTERTEST, IBM DEBUGIN TOOL, START TOOL, SPUFI, QMF, PLATINUM, BNC, FILE-AID, ABEND-AID, VI, UNIX, GTB, BMS, MQ-SERIES, ORACLE, PEOPLE SOFT DB2 DBA, FILE-AID for DB2, SORT UTILITIES,Dyal280 and Easytrieve, DEBUGGING TOOLS, DB2 (QMF, SPUFI, PLATINUM), AND IBM UTILITIES. KNOWLEDGE IN C#, WPF, SQL-SERVE, ASP.NET, WPF, UI AND GUI. IMPLEMENTATION PACKAGES (CHANGEMAN, ENDEVOR, INFORMAN, OPC, CA7 AUTOSYS. TEMTRAK)
January 2019 to Present, PNC Bank.
PCS-Plastic Card Services/Debit cards systems.
Senior Mainframe Developer.
Cobol2-3, JCL, DB2 SQL, VSAM, ICETOOLS/SYNCSORT, BMC, QMF, PLSQL, DATA STUDIO and Easytrieve, API and MQ process.
Developed and implementation new Realtime process for Debit cards, activations, Linked accouts and OFFset/PVV migration.
Design, test and implement batch Online and batch Process to send new and cards to Fiserv for activation. PVV and Linked accounts.
Complete design and implementation for 24 by 7 debit cards process
Include work with API and postman for testing.
Developed the process to migrate a total of 36 millions cards to Fiserv.
Using NDM for batch transmission and API for Realtime process request
Develop a process 24/7 to minimized Fraud on the debit cards, by creating a process to allow the Customers to locked their cards for security purposes and unlocked when the customer is ready to use the cards again.
Complete the entire PCS(Debit cards ) migration to Fiserv and Validate all new and maintenance process for cards activation and linked accounts.
.
December 2016 to December 2019, Morgan Stanley
Division of Gain and loss/Tax Lot: TCS/Contractor.
One New York Plaza New York City NY
Business Analyst and Senior Programmer analyst/ Developer (Batch, CICS, COBOL, Cobol2-3, JCL, DB2 SQL, VSAM, ICETOOLS/SYNCSORT, BMC, QMF, PLSQL, DATA STUDIO and Easytrieve)
Developed and implementation of UIT and ROC (Return of Capital), adjustment payment process.
Design, test and implement batch process to apply WSC (Wall Street Concepts) dividend and Principal payment adjustment for all equities, MF, and UIT tax lots.
Complete development of Bonds Carry over Premium for Year-end process.
Work close with Operation/User to determine and apply business rules in order to calculate carry over bonds premium and bonds premium discount.
Working on Translated BRD (Business Requirement Documents) to Technical specs. Analyze all application programs impacted by the Business requires and identify the technical coding and changes.
Participated on the GK (Gains Keeper) implementation and test.
Created a parallel process to run with the new changes in QA, in order to suit GK process.
Worked on the GK implementation Flip, by demoting current production system to
To QA and promote QA new version with GK enhancements to production. Work together with OPC scheduling and QA group in solving defects and execution or timing issues. Execute Data Base refresh in order to keep data integrity throughout the duration of the project.
Working on GK successfully implementation and support after. This by creating compare reports between production and the parallel system.
Developed a back-out system and keep it running in QA as a Plan-B during GK implementation faces.
March 2016 to December 2016, Bank of America/Merrill Lynch
Division of Tax Lot: Contractor.
1500 America Dr. Hopwell NJ
Business Analyst and Senior Programmer analyst/ Developer (CICS, COBOL, Cobol2-3, JCL, IN synch for DB2, VSAM, ICETOOLS, BMC, QMF, PLSQL)
Working on Translated BRD (Business Requirement Documents) to Technical specs. Analyze all application programs impacted by the Business requires and identify the technical coding and changes.
Working with the Qa group and assisting on the testing plans and
Create the run books with all different test cases for the QA group.
Working on Tax Lot Data Base Expansion:
Designed and implemented a new cover and uncover Tax Lot system for supplemental and no supplemental securities. Code DB2 and CICS, JCL and sort cards for the entire process. Also unit and regression tested the application, created all implem packages using endeavor. Created all SDD, Run Books and estimations using MS-Project.
Currently working on the Data Expansion project, Created Test Plans and test cases presented all results in a run book.
Remediated VSAM conversion to DB2. Data analysis for
January 2015 ADP/retirement service. Contractor
To February 2016 Florham Park, NJ.
Business Analyst/Senior Programmer and Analyst. (File-Aid, SQL, IBM Utilities and ICETOOL,CICS, COBOL, Cobol2-3, JCL, IN synch for DB2, VSAM, and RDZ)
Crete Test plans for the QA group to test the Omni-Plus changes, this involve translate all User requirements documents to the technical language, Create Flow Diagrams for the users, QA group and Developers. Assist Developers to Identify Data mapping from Vsam files using FileAid to the new DB2 Format by comparing the Tables DCLGEN attributes using SQL and BMC.
Participated on a conversion and upgrade of the Retirement Services (401K) Omni-Plus system by SunGard.
Was responsible for review, analyses data fields, layout Mapping and for Developed specifications, diagrams, and flowcharts.
Modified application and system programs, including coding, testing, debugging, trouble shooting and implementation for about 1,600 Cobol CICS programs. These include DB2 and SQL performing modification and tuning.
This conversion and upgrade encompassed of CICS applications into Admin Web and impacted batch application programs, JCL and JOBB.
Remediated VSAM conversion to DB2. Data analysis for fields and layout mapping also tested all programs for compliance services system.
The project was tracked by Rally software and being governed utilizing Scrum as an iterative and incremental Agile software development framework for managing product development.
April 2014 ADP/retirement services/ Contractor
September 2014 Florham Park NJ.
Senior Programmer analyst and RDZ for System z Web server for
CICS Developer
Design new Web server development for CICS provider using IBM RDZ Tools.
Responsible for a day by day application development, installation and mentor/Trainer of the system and application support staff on RDZ.
Configure RDZ and CICS pipe lines, URI Mapping WSDL WSDLBINDS, for applications with multiple containers for Top down, Bottom up Scenarios and meet in the Middle.
April 2013 ESI/IBM Contractor:
To Feb/2014 Senior programmer Analyst and production Support Technician
Perform the Business Analyst Roll for the production support group, by Analyzing all production FTP/NDM files, and create true file to replace any
Bad data set to the vendor. Create all user reports using ICETOOLs and –Easytrieve, based on the business documentations and requirements.
Provided production support for CDH (Consumer Driven Health) system.
Handle tickets using Remedy software, Do analysis and identify the problem.
Also provided the higher manager with daily status report, as per the progress of all tickets.
Update all ticket and recreate the problem and provide the solution for all Online (CICS), Batch (COBOL, JCL, and Easytrieve), and Recreate DB2 queries to retransmit all report to all vendors. Cover Production Releases on a 24 X 7 schedule.
Request one time jobs and implement any immediate and permanent fixes to the CDH system. Interface with Eligibility and POS by trouble shooting any related Issues.
Coordinate implementation, promotions and emergency release with Endeavor. Plan all of the different Endeavor levels of promotion and testing (Regression, QA, User acceptances and promotion.
April 2012 Verizon Wireless, Orangeburg, NY/ Contractor
To January 2013 Senior Programmer Analyst and Data integration Tech/Consultant
business of Media alert to send messages to the Mobiles. Develop and enhancement of the Data rewire and Data grid system.
Providing analysis and expect for all programs and data base changes needed to integrate a new Data source (Data-Grid) into the billing and account applications. Also made all changes to intergrade a new
Utilize RDZ tools for Coding and unit testing of all new programs and JCL.
Worked as a DB2 Gate keeper between the DBA and Developer group, providing index and performance issues analysis and solutions.
Promotions to all level (SBX, DEV, QUAL, and PPRD) using Endeavor for all online and batch modifications, these include (CICS, DB2, NSP (Native –Store-Procedures), Copybooks, COBOL, DCLGEN, PROC and JCL) enhancements and new applications to be implemented into production.
Coordinate and plan project life cycle thru Endeavor for the beginning thru the production implementation and production Check out.
April 2000 UBS Financial Services/PaineWebber, Weehawken, N, J.
To July 2011 Senior Programmer Analyst/Project Leader/DB2 DBA
Maintenance and Enhancement of Syndicate Trading and Retails systems.
Participated on a new Syndicate Retail and trading system rewrite and redesign and providing the clients with a syndicate system, designed using JAVA Front-End interfacing with a mainframe via channel and containers using JCICS features, and RDZ to design WSDL.
Used RDZ to create the front-end lay out (WSDL) and a mapping copybook in the Mainframe, Upload the generated WSDL programs and XML code to the mainframe and prepare the change management package.
Stored and accessed data from and to the DB2 Data base, using CICS and Store Procedures Support Fixed Income and UIT department, production support and new enhancements implementation and designed using CICS and Batch support system interfacing with an Oracle DB on the Unix Server.
This include jobs scheduling, report generators by Dyal280 and COBOL, screen definitions using BMS and GTB functionality.
Responsibility involved project managing for a FTP to SFTP and NDM conversion, QA, and Production implementation for more that 250 JCL and Control cards.
Manage Focus elimination project by replacing two focus applications and redesigning them using MQseries, CICS and DB2.
Organized and participated on coding, Unit testing, QA and implementation for more than 50 jobs, 90 batch programs, and 150 CICS modules including maps, 30 report (Dyl280) and over 200 files transmissions.
Participated on a DB2 tanning and performance prove for Order entry and execution department.
Verified and changed about 250 (online and batch) programs for performance efficiency and data integrity.
Using DB2 utilities and Omega Mon to identify better index path and performance statistics for all online (CICS/DB2 and batch COBOL) programs.
Also support Unit investment trust application on the mainframe and the interface with oracle on the distributor side.
Worked on New issue management (Syndicate Retails system), department rewrite project to increase company profits by creating an Email Doc delivery system, being this part of cost saving.
Participated on an email Prospectus Doc Delivery and paper less project for statements delivery.
Work on a new trading system design for a 24 by 7 processing, This include over 200 new CICS and DB2 programs using MQseries to drop the message or trades and prioritize the messages to invoke real time update to the db2 table partition.
Tuned and massage all sql coding to better perform and to improve trade flow.
August 1998 New York Daily News, Jersey City N, J
To April 2000 Application DB2 DBA:
Migration for a PeopleSoft Financial/HR application from Oracle to DB2 Platform.
As the application DBA, Responsibilities include: (Reorganized, backup and alter DB2 tables).
Also create Views to be use by Cristal reporting tools, the creation of sys- group, Databases, table-spaces, index-spaces, tables, and views.
Testing modification for Y2K Project. Participates on the PeopleSoft migration of five different versions of PeopleSoft and Y2K for Dev., Demo, QA, and Production environments.
Recovering batch jobs and Schedule design. Take full charge of disaster recovering plans and executing.
March 1994 PaineWebber, Weehawken, N.J.
To August 1998 DB2 DBA and Senior Programmer Analyst.
Worked as a DB2 DBA, supporting 6 different applications, alter exiting table and creating new tables for existing application.
Also worked close with the Data modeler for the creating of new databases for online trading.
Trouble shoots fixed income application for tuning and performance by implementing new access path and clustering index.
Creating DB2 Store-Procedures and maintaining DB2 Catalog entries.
Project lead and DB2 DBA
Supported Portfolio Management Information system, providing clients and branches with the tax lot for all realized and unrealized gain and cost basis.
Batch and online enhancement and support for 2/CICS/COBOL/Dyal280/Vsam/JCL/FTP/DB2/CICS/COBOL/Dyal280/Vsam/JCL/FTP.
Provide all tax lot for statements and data warehousing.
Application Developer
Participated on a new land balancing system development for Mutual funds.
Full charge of the project life cycle, from design, coding testing and production deploy.
Including 50 new Jobs (JCL and PRO), 90 CICS and COBOL programs, and FTP transmissions for data from the server for a VB application support and reports generation in page Center.
Senior programmer analyst, working for Managed Account department.
Worked on a new (PACE) product development. Coding and testing Online and Batch process (CICS, COBOL, and DB2).
This Include OPC scheduling, CICS table's definition, DB2 tables design and create all FTP process for the data transmission.
Took charge of the schedule set up and Unit and regression test.
October 1991 United Retail Group, Inc. Rochelle Park, NJ
to March 1994 Senior Programmer Analyst
Designed Code and Maintained the Distribution Center System, responsibilities Included, converting batch and CICS program from COBOL to COBOII, and generate compensation reports using Quick JOB.
Write new BMS and CICS functionality to support VSAM files accessing IDM database.
Update CICS tables (FTP/PPT/PCT/TCT) definitions, in development, QA and Production implementation.
Design and implement OPC Batch scheduling for Night processing.
Supported and enhanced the company credit cards system.
Participated on the URG MIS conversion project to reallocate all files and Software from a location in Ohio to a new data center in Kentucky.
Created all Data backups and restored all data on the new environment.
January 1986 Commercial Programming Unlimited, New York NY
to December 1990 Programmer Analyst / Information processing Instructor:
Designed and maintained various Batch and On-line programs for National Westminster Bank.
Development and implementations for the Pre-authorized Mortgage Transfer system, Include code all (JCL, COBOL, BMS, and CICS) Programs, for TCAM/VTAM and create all VSAM files.
Teaching various Programming and Math courses in the Private Business School (CPU). Teach and train people in information processing fields. Experience on Teaching COBOL, CICS, JCL, Information processing, Math, Accounting and others.
Education:
October 2011
to March 2012 Millennium Focus Solution Bloomfield, NJ.
Training in C#, GUI, WPF, UI, WCF, SQLSERVER, Web Server frame work and HTML.
December 1986 Steven Institute of Technology, Hoboken, NJ
Completed 15 Credits toward a MS in Electrical Engineer.
June 1984 International Institute of America
Hato-Rey, PR
BAS in Applied Science with a major emphasis in computer programming and
Mathematics also minored in Accounting and Typing.
Contact this candidate