Summary

Mainframe Software Engineer with over thirty years of experiences in the Development, Maintenance and Enhancements of Computer Application Systems. Technical strengths include COBOL, DB2, IDMS, CICS, TSO/ISPF, VSAM, NDM, FTP, UNIX, IMS DB/DC and JCL. Responsibilities include COBOL Programming, System Analysis, SQL, Database Design, Testing and Production Support. Function well as a team player with a wide range of mainframe experiences.

Technical Skills

Expert Level

Beginner Level

• JAVA
• UNIX Scripting
• HTML
• JAVASCRIPT
• Microsoft ACCESS

Career Excellence

Confidential

Programmer/Analysts II ISD

Technical Lead Store Number Expansion Project

• Work with several contractors' in-shore and off-shore.
• Participate in the design and remediation of programs.
• Review/Walkthrough all the remediated components Programs, JCLs, Includes, Parameter Cards and CA7 Scheduling to make sure it is correctly remediated, working and as to specification.
• Assists in obtaining the required approval to install all the remediated components.
• Assists and support the validation of all the installed components until the Warranty is completed.
• Design Lead Order Forecast and Truck Load Optimization Project
• Gather and document all the requirements of the Business.
• Convert the requirements into Diagrams using Visio.
• Present the Design for Walkthrough and obtain approval.
• Identify all the required tools to be use in the projects.
• Construct the detail specification
• Assists programmers and contractors in understanding the specification.
• Documents all the required design documents.
• Code/Install the most complex program of the project.

Programmer Analyst II

Confidential

Projects.

• Utilizes In-house software and tools such as COBOL On-Line and Batch , CICS Web Services, CICS, MQ-Series, DB2, IMS, IDMS, SPUFI, ICETOOL, SYNCSORT, IBM Utilities. NDM Connect Direct, FTP, SFTP, Data Stage.
• Design/Coded Provider and Requestor Web Services to provide cross platform access to Oracle databases and Unix Servers.
• Design/Coded programs that access the Web Services via the Batch processes.
• Mentor Junior Programmers
• Work with Vendors/Contractors assigned to the projects.

Competencies

An individual must be able to successfully perform the essential functions of this position with or without a reasonable accommodation.

Functions and Responsibilities

• Conducts application analysis and design for end users by reviewing business processes documenting business requirements researching potential solutions making recommendations to meet Customers' business objectives writing program specifications writing detailed checklists for change control implementations writing data analysis documents and creating technical design documentation.
• Supports Information Systems Division ISD applications by responding to user questions and problems researching service level functions for example, performance, availability, reliability identifying and resolving issues to root cause developing solutions participating in change management processes implementing changes and improvements for example, alerts, monitors and engaging in war room or focus room meetings.
• Participates on team projects by following Information Systems Development Life Cycle ISDLC processes leading small projects gathering requested information writing, testing, and debugging programs and scripts implementing test scripts and procedures testing and installing third party software writing instruction manuals compiling documentation reports and documenting application changes.
• Develops the team member capabilities by mentoring teaching team members for example, coding languages, scripts, documentation requirements, programming standards, DBMS technologies conducting analyses and recommending solutions and coordinating tasks.
• Demonstrates up-to-date expertise in Information Systems Division ISD -Applications Development area and applies this to the development, execution, and improvement of action plans by providing expert advice and guidance to others in the application of information and best practices supporting and aligning efforts to meet Customer and business needs and building commitment for perspectives and rationales.
• Provides and supports the implementation of business solutions by building relationships and partnerships with key stakeholders identifying business needs determining and carrying out necessary processes and practices monitoring progress and results recognizing and capitalizing on improvement opportunities and adapting to competing demands, organizational changes, and new responsibilities.
• Models compliance with Company policies and procedures and supports Company mission, values, and standards of ethics and integrity by incorporating these into the development and implementation of business plans using the Open Door Policy and demonstrating and assisting others with how to apply these in executing business processes and practices.
• Judgment: Demonstrate Professional Judgment - Researches and integrates relevant information and data, and uses expertise to make recommendations or decisions. Identifies and applies sound, fact-based criteria in setting priorities and making decisions.
• Use business measures and analyses to identify improvement opportunities. Probes and looks beyond symptoms to determine the root causes of problems and identify possible solutions.
• Customer Centered: Meet Internal and External Customer Needs - Identifies the requirements, expectations, and needs of Customers. Supports and aligns with initiatives, goals, and actions focused on improving Customer service. Address the concerns and issues of internal and external Customers. Use Customer data, analyses, and insights to improve Customer-related decisions.
• Execution and Results: Focus on Execution and Results - Aligns and pursues work activities to achieve the mission and business priorities of the organization. Share information, practices, and resources across functions, organizations, and locations to improve performance.
• Effectively uses existing processes and tools to achieve performance objectives. Uses and explains major process steps to manage time, resources, and challenges to meet goals.
• Planning and Improvement: Plan for and Improve Performance - Develops and implements plans, practices, and processes to better achieve organizational goals. Develops contingency plans to manage or eliminate potential problems. Identifies and recommends ways to continually improve and streamline processes and practices.
• Influence and Communicate: Build Influence - Develops and presents logical, convincing reasons in support of one's perspectives and initiatives. Proactively shares relevant information and timely updates with appropriate people. Listens attentively and asks questions to ensure understanding.
• Researches information for and prepares documents and presentations that effectively convey relevant information in a timely manner.
• Ethics and Compliance: Model Ethics and Compliance - Acts in accordance with policies and procedures. Demonstrate ethical performance.
• Support the efforts to enforce the compliance with policies and procedures.
• Adaptability: Adapt professionally - Demonstrates creativity and strength in the face of change, obstacles, and adversity. Adapt to competing demands and shifting priorities. Update and share knowledge and skills to keep current in one's area of expertise. Embraces change and supports its implementation.
• Build Relationships: Form Relationships - Builds trusting, collaborative relationships and alliances across functional and organizational boundaries. Relate to others in an accepting and respectful manner, regardless of their organizational level, personality, or background.
• Collaborate with people from diverse backgrounds, experiences, and functional areas to discover new perspectives.

Confidential

Programmer/Analyst II

Programmer's Skills set:

Uses the following In-house software and tools

COBOL On-Line and Batch , DB2, CICS, MQ-Series, IMS, IDMS, SPUFI, ICETOOL, SYNCSORT, IBM Utilities. NDM Connect Direct, FTP and UNIX Scripting.

Confidential

Work Description:

As Programmer/Analysts, Design, Code and Implement programs to incorporate the FundServ Held IRA and Initial 529 process for a specific Fund Companies into the Edward Jones Mutual Fund Trading System. This is the project that touches mostly, all the Mutual Fund Trading System features, i.e., from the time the Mutual Fund End User fill up the application and enters the information to the Mutual Fund Trading System, to the time that we mail the Trade Confirms to the Client. New Online screens were developed in order to capture the Beneficiary information and store them to DB2 databases. This process also includes communication from our MQ Queue Processing to the NSCC/DTCC, which is the hub of the industry and Clearing agency that handles the trade validation and facilitates the delivery and receipt of money and securities, to the Fund Company that assign the shares, price and commission and then back to NSCC/DTCC to our MQ Queue Processing that will then process the order and post the billing data to the ADP/Broadridge, which provide home office financial services to brokerage firms and outside external vendor. The MQ process also creates the Trade Confirms that is mailed to the Customer. The Customer Balance information, account activity and portfolio information are stored to the EDJ CATS System.

Confidential

Work Description:

As Programmer/Analysts, Design, Code and Implement UNIX scripts to retrieved the Monthly position data from the FundServ server and FTP transfers them to our Mainframe application for reconciliation. Ensures that the file controls requirements are all met.

Confidential

Work Description:

As Programmer/Analysts, Performed the several assigned small enhancements to above processes. This change normally touches the On-line programs, MQ Queuing process and Batch programs. The scope of testing touches mostly, the processes I mentioned in the FundServ Held IRA and Initial 529 project . Changes are regression tested by the End user around the Mutual Fund Trading System Application.

Confidential

Work Description:

As Programmer/Analysts, Design, Code and Provide availability to perform the database extract of the time sensitive request to produce the Mutual Fund Reports and Statistics. Construct a onetime process to perform several CUSIP mergers and Profile mass changes. Provide the availability to manually extract data from the FundServ Server from time to time that it is required. Provide availability to walkthrough complex programs that are changed by other programmers.

Confidential

Work Description:

• As Programmer/Analysts, Provide availability to provide a 24X7 On-call support to the Mutual Fund Trading Application and The Money Market Application for a week on a rotation basis. Responsibility is to answer any production on-call or beeps and to provide the first line of analysis and resolution to the problems to avoid any delay to production process.
• Provide availability to provide User support during the daily Mutual Fund prices process. This is a once a week assignment that ensure all prices are received on time from the Fund companies. The goal is to ensure that all prices are in on time to avoid production delays.

Confidential

Project: Problem Ticket Research and Resolution

Work Description:

As Programmer/Analysts, responsible to research and resolved the problem issues that occurred during the Broker Book application production process. This process includes ABEND resolution, coding correction and recommendation of future enhancements.

Project: Class Action

Work Description:

• As Programmer/Analysts, Design, Code and Implement the new Class Action Reporting Application System programs. This process take the request via the J2EE front end application, store the information to DB2 tables and used the data as a parameter to extract the necessary information from other databases DB2 and IDMS in order to create the required Class Action Report that are used for researched by mostly, the legal department.
• Provide availability to provide User support during the daily Mutual Fund prices process. This is a once a week assignment that ensure all prices are received on time from the Fund companies. The goal is to ensure that all prices are in on time to avoid production delays.
• Coordinate any Situation Alert if necessary, which involved all the experts in the company if the deadline was not met. This was necessary for any decision needed to in order go forward with the processing.

Confidential

Consultant Senior Programmer/Analysts

Confidential

Enhance the Third Party Administration System TPA and the Client Data System CDS .

Responsibilities include:

• Assist in the evaluation of systems scope and objectives.
• Estimate the time required to complete the project.
• Design, code, test and implement programs that extract data from different DB2 tables using SQL.
• Fine tune DB2 SQL using EXPLAIN before using them into the program.
• Create a DB2 Data Mart.
• Validate and Reformat data to be able to load into the Oracle Data Warehouse taking into consideration the referential integrity of the database.
• Produce control reports for reconciliation.
• Maintained/Enhanced the TPA and CDS Online/Batch System.
• Uses COBOL, VSAM, DB2, CICS, MQ Series, SYNCSORT, EASYTRIEVE, ENDEVOR, TSO ISPF, JCL and NDM Connect Direct as FTP software .

Confidential

• Reconcile the Magazine and BHE applications accounts receivables.
• Responsibilities include:
• Work with the Andersen Consulting Group as a sub-contractor.
• Assist in the evaluation of systems scope and objectives.
• Design Test Scripts.
• Create, extract, validate, reformat data required to satisfy the test scripts.
• Construct the JCLs, Procedures and Programs.
• Integrate testing of all the systems Batch and Online within the Magazine and BHE applications.
• Execute the testing and produce test results.
• Provide the test results to the Andersen Consulting Group and Business user for verification and approval.
• Uses COBOL, CICS, VSAM, DB2, SYNCSORT, FILE-AID, EASYTRIVE, TSO/ISPF, JCL, CLIST and RHUMBA FTP software.

Confidential

Responsibilities include:

• Perform the Y2K preliminary Analysis, Issue Identification and Validation of programs that belongs to different clients in and out of the United States.
• Uses knowledge in COBOL, CICS, DB2, VSAM, IMS DB/DC, IDMS and EASYTRIVE

Confidential

Assigned to re-construct and automate the Third Party Administration System and the file distribution process of the Client Data System CDS .

Responsibilities include:

• Evaluate the project requirements System Scope and Objectives .
• Design, code, test and implement all the programs required in order to automate the TPA and CDS system.
• Perform the unit test and the performance test of the system.
• Maintained/Enhanced the TPA Online System and CDS Batch System.
• Uses COBOL, CICS, MQ Series, VSAM, SYNCSORT, NDM Connect Direct FTP , TSO/ISPF, JCL, ENDEVOR and IBM utilities.

Confidential

Senior Programmer/Analyst

• Provide technical leadership to systems developers and maintenance programmers. Production supported the IMS DB/DC and DB2 applications, The Telephone Billing. Design databases for the new system application. Application supported the existing application and or system using the software available in-house such as the Catalog Visibility and others.
• Handle special on-demand projects such as Y2K and conversion of OS COBOL to COBOL II. Provide maintenance to the existing IMS DB/DC and CICS/DB2 application system and developed several new telephone applications system using TSO/ISPF, COBOL, CICS/DB2 generated by the KEY VISION code generator product, SAS, QMF, SPUFI, and ABEND-AID.
• Construct and participate in construction of new application using the TSO/ISPF, IMS DB/DC, MFS, BTS I II, ABEND-AID and other IMS related products of several Telephone Billing sub system.

Confidential

Analyst/Programmer

Programmer

Work on several banking applications such as: Savings and Current system, Loans, PIS, Financial system and Payroll system. Participate in the development of the system, maintained the current applications and perform mostly, complex programming using Key to Disk, COBOL, EASYTRIEVE, TOTAL DBMS and Panvalet.