SUMMARY

• Over 25 years of experience in systems analysis and programming for the financial,aerospace, food, computer chip and rail road industries.
• Strong background in developing interfaces for client server application, user training and support documentation.

TECHNICAL SKILLS

Programming Languages: COBOL, COBOL II, JCL, PL/1

Hardware: IBM Mainframe, PCs and most compatibles

Operating Systems: Windows NT, MVS

PROFESSIONAL EXPERIENCE

Systems Analyst

Confidential, West Lake, TX

Responsibilities:

• Confidential - Kevin Ruscik Manager
• Working on enhancements of CICS and batch programs
• Which includes VSAM, CICS and DB2.
• Modify various programs, JCLs and Macros since September 2017.
• Team member of Fee Disclosure project mandated by
• US Congress for 401K PLANS managed by Fidelity for
• Large number of companies.
• Developing Technical design specs as per approved requirements
• To create fees at investment fund levels for the company.
• Develop / modify DB2 / COBOL programs, CICS screens to extract data from
• Various FPRS DB2 tables and VSAM files.
• Develop Test plans, test cases and perform Unit tests.
• Participate with QA team for SIT. Analyze and interpret
• Use Endevor for software
• Set up new jobs and schedule for production. Participate in
• Meetings with customers and other team members to refine
• Requirements. Create and FTP Master files for Plan level, Plan Fund
• Level, Plan Source Level and Plan Safe Harbor and Plan Rule level
• For Broadridge. Use Various FPRS CICS transactions for Plan, fund and
• Source level information
• Projects - Fee Disclosure Revenue Credit sharing, Tax Exempt Accounts
• Participants Plan to Plan Transfer, Mississippi State, Non Residents
• Tax % mandated by IRS as per treaty rate with foreign countries
• Apr. 2008 - Oct. 2009, Systems Analyst, Superior Technical Resource

Customer

Confidential, Fort Worth, TX

Responsibilities:

• Team member for MRP systems. Provided production support For Part/Plant Master, Bill of Material (BOM). Apply V-MODEL process to develop IE Standard
• Report system’s requirements, design, development, test plans, test cases,
• Perform UNIT / INTEGRATION / REGRESSION / ACCEPTANCE tests,
• Documents test results, defects, resolve defects, implement, schedule system.
• Develop System flow chart and user guide.
• Also develop, test, implement interface for JSF parts loaded in SAP and
• Removed from Part / Plant System using V-MODEL methodology.
• CAPP, EWI, PDM Interface with PMPR and BOM mainframe based IMS, DB2, COBOL, JCL.
• Set up and scheduled production jobs. Interacted with end User for IE Standards reporting project.
• Developed interface with SAP’s Material System to update Part/Plant records in IMS Databases.
• Developed JSF/PDM/MBOM/PIOS Interface to create RECON file for JSF parts. Developed transition process of JSF parts from PDM to CAPP and from CAPP to BOM. Interacted with JSF user community to resolve issues and develop solutions. Set UID (Unique Item Description) for parts.
• Use File-Aid for DB2 tables, IMS Databases and Flat files to create test data and select specific records based on selection criteria. Use Xpediter to debug DB2, IMS programs for ONLINE transactions and batch programs
• Schedule jobs using CONTROL-M to create download file for JSF parts

Product Data Manager

Confidential, Dallas, TX

Responsibilities:

• Created special promotion offers to be included with statements for selected credit card holders in USA, Canada, UK and Ireland as a member of the Selective Statement Insert system.
• Modified 40 COBOL/COBOL II programs with embedded DB2 SQL statements. Modified 40 JCLs/Prcos, Sort Control cards. Modified 2 REXX programs to translate queries created by customers for reformatting and processing.
• Developed 60 jobs to load/unload DB2 tables.
• Set up test plans, test cases, conducted UNIT and System Integration Tests, documented and published results for customer review.
• Developed design documents, interacted with customers in USA, Canada and Europe. Participated in peer review and code walk through.
• Identified and documented problems in Mercury Quality Center and resolved them in timely manner.
• Migrated JCLs, Procs, and Copybooks programs in staging libraries using Endevor for the software change management process. Suggested improvements in the process which prevented major problems.
• Use File-Aid for DB2 tables, flat files to select specific records as per test plans.
• Apply V-MODEL Methodology to develop test plans, test cases, perform

Senior Systems Analyst

Confidential, Fort Worth, TX

Responsibilities:

• Developed interface between mainframe and client server Capacity Planning Systems (CPC), the module of the Manufacture Resource Planning system.
• Interacted with third party vendors in the development, testing and implementation phase of developing a system to monitor response times for orders created from client servers and processed by the mainframe. The system alerted customers by sending a text message to a cellular phone if the response time exceeded one minute.
• Developed a system to update parts in PIOS’s Part Master Database received from Part Data Manager and CPC in a real-time environment and eliminated scheduling of the process.
• Implemented enhancements to BOM systems, a component of PIOS.
• Developed batch, BMP and online interfaces between EWI-BOM, EWI-PM/PR, PDM-BOM, PDM-PMPR, SFM-PM/PR, CAPP-BOM and CAPP-PM/PR.
• Use File-Aid for DB2 tables, IMS Databases and Flat files to create test data and select specific records based on selection criteria. Use Xpediter to debug DB2, IMS programs for ONLINE transactions and batch programs
• Set up and schedule jobs using CONTROL-M to process files received from
• Implemented Y2K changes to more than 200 programs including: Plant Performance Tracking; Product Request; Consumer Correspondence; Quality Information; Documentation; and Specification systems.
• Languages utilized - IMS, DB2, COBOL II, AS400, SAS, Easytrieve and Oracle
• Set up daily/weekly/monthly jobs using CONTROL-M to update Plant Performance System. Create down stream files for Labor and Cost of Material

Systems Integrator

Confidential, Sioux City, IA

Responsibilities:

• Developed API for Meter Control Inventory System using MQ SERIES, CICS, and Cobol II.
• Analyzed DB2 tables, IMS transactions, and 500 COBOL programs for Y2K related problems and created various reports for management's review with Microsoft Office suite.
• Verified installation of IBM's tool, RA version 5.4.0.
• Analyzed CLAIM System's Batch and Online COBOL, Assembler, PL/I and CICS applications for Y2K. Created reports for management review.
• Analyzed 33 systems which consisted of 5700 PL/I programs, 300 COBOL programs, 300 Assembler programs, 300 CICS transactions, 300 VSAM files, 1500 jobs and 11,000 data sets.
• Prepared date impacted analysis reports by constructing queries in QMF, Microsoft Access, Excel and LOTUS 123 spread sheet.

Systems Analyst

Confidential, Plano, TX

Responsibilities:

• Implemented PeopleSoft's Payroll Module.
• Developed interfaces between the Mainframe MVS and HP9000. Developed programs using SQR and Oracle on UNIX and COBOL II on MVS.
• As Team Lead for Order Entry/Quote System, continuously interacted with customers to propose solutions to business problems, translate requirements, and resolve technical issues.
• Developed applications in EDI, COBOL II, IMS, and DB2 to generate JIT orders based on MIN/MAX inventory levels for Intel, Motorola, Ford, IBM and GM’s Inventory and Warehouse System.
• Developed Labor and Attendance Adjustments application on the Payroll System using COBOL, DB2, JCL, IMS DB/DC.
• Calculated gross earnings and labor distribution to the General Ledger System.
• Resolved technical problems and implemented enhancements.
• Rewrote applications to improve performance by reducing tapes, eliminating hard copy and Microfiche reports which resulted in annual savings of over $100,000.