System Analyst / Programmer Resume

Title
System Analyst / Programmer

Primary Skills
COBOL, CICS, Install/1, DB2, SQL, VSAM, IDCAMS, JCL, TSO/ISPF, Xpeditor, FTP, Platinum, FileAid, Changeman, Control/M

Location
US-OH-Columbus (will consider relocating)

Posted
May-13-09

Technical Analyst with over 20 years of experience on mainframe systems with a broad background in all phases of the software development life cycle, building maintainable user friendly applications in a rapidly changing business environment. Recognized for broad technical knowledge and proven ability to achieve focused results and creative solutions, resulting in many contributions that have led to improvements in efficiencies and cost savings.

Professional Experience:

1994 -- 2008 Limited Technology Services (LTS), a Division of Limited Brands, Inc., Columbus, Ohio
Technical Analyst
Hardware/Software: Mainframe: IBM Z series, MVS, COBOL, CICS, Install/1, DB2, SQL, VSAM, IDCAMS, JCL, TSO/ISPF, Xpeditor, FTP, Platinum Edit, FileAid, Changeman, Control/M, some Easytrieve, SAS, & EDI.
PC: Windows, Visio, Excel, Word, Outlook, Power Point, Project

• Updated all CICS-Install/1 processes and DB2 tables in support of the new PKMS (Manhattan) conversion. Designed, wrote, and setup all PKMS/Mainframe interfaces. Worked with PKMS staff to setup and schedule processing cadence to support the interfaces and overall mainframe processing for the Victoria's Secret Direct -- DC5 Relocation Project.
• Designed process to take initial plans and compute new dynamic plans using actual sales. Designed a new DB2 tables to permit parallel processing with independent restart capabilities to reduce impact on nightly batch window - Merchandise Planning Upgrade.
• Analyzed manual process Bath & Body Works (BBW) used to get sales data from it's web provider and convert it to a usable format, then designed, wrote, and implemented an automated process to deliver the data each morning prior to start of the home office's business day.
• Designed and built all POS interfaces to collect hours and staffing information at the store level for all of the brands within Limited Brands at the time for the Peoplesoft Payroll Project. I also flowcharted and coordinated the building of the full production schedule (mainframe & Peoplesoft).
• Led team to install GLOBESET, a client based deposit management system, at BBW to monitor and balance bank deposits at the store level across the 900+ store chain.
• Designed and led a team that accomplished the goal to provide store management with next day sales results (a 24hr increase over prior reporting to that time) that included comparable sales by category and corporate rank statistics. Also built an e-mail interface process to deliver an excel version of the report to all field management, which became the model for all go forward reporting.
• Interfaced the size level forecasting system Limited Brands developed to Lane Bryant's current MMS allocation system. Designed interfaces and built trigger mechanism to control flow of data to minimize space requirements. Wrote tech manual and participated in the preparation of user training material.
• Saved over $80,000 in the first season of deployment after redesigning the picking and packing slips to improve the efficient movement of product through the DC.
• Received first SPARK award within first year of employment for A/P-EDI project below -- the first person in company's history to be so recognized.
• Increased efficiency of A/P department by automating the posting of EDI invoices from a manual system. A/P system was IDMS based, so I had to build an understanding of both the database and the A/P system prior to designing and coding the solution.

1985 -- 1994 Nationwise Auto Parts, Inc., Columbus, Ohio
Senior Systems Analyst
MSA SF/DRP Product support specialist
Hardware: IBM 3090, MVS, COBOL, CICS, RPG II, VSAM, FileAid, IDCAMS, JCL, TSO/ISPF, Xpeditor, SDF2, SYNCSORT, Librarian.

• Responsible for the support of our Inventory Control Systems, both in-house and purchased.
• Requested by MSA to assistance in the development of modules needed to complete their Retail Inventory System SF/DRP when their deliver date began slipping. I was assigned to the MSA development team and worked in Atlanta for a period of three months.
• Designed in-house forecasting and replenishment system (Batch & CICS) to eliminate work load on MSA system by over 65% and increased overall store inventory efficiency.
• Tuned and redesigned several key VSAM files that resulted in reducing nightly batch processing times by hours. Wrote CICS program to show computed file size using various allocation options.


1980 -- 1985 York Steak House Systems, Inc., a division of Darden Restaurants, Columbus, Ohio
Project Lead, Payroll Systems
Hardware: Burroughs B1985, MCP II, COBOL, RPG II, Scope, Candi, NDL.
IBM Series/1, COBOL.

• Restructured Payroll system to handle multiple companies, a benefits menu, and tip reporting. Mandated after our office took over all processing for the Casa Gallardo restaurant chain.
• Consulted with Darden to convert Payroll system to run on their mainframe and add the Olive Garden restaurant chain to system after York's headquarters were moved to Orlando, FL.
• Designed and developed recurring journal sub-system to support G/L.
• Developed all batch software for new A/P system for Series/1.
• Served as in-house expert and trainer for new PC/spreadsheet software.


1974 -- 1980 Iron City Distribution Company/Beverage Marketing Corp., Mingo Junction, Ohio
Programmer Analyst
Hardware: Burroughs B1865, MCP II, RPG II, Scope, Candi, NDL.
Converted from an IBM System/3, RPG II

• Developed all software needed to publish the “National Beverage Marketing Directory”.
• Converted all software and data moved to Burroughs system and trained all operators on new system and procedures.
• Designed invoicing system and support documents used by sales staff.
• Revamped sales reports for readability and processing efficiencies.


1976 -- 1979 Jefferson Technical College, Steubenville, Ohio
RPG II Programming Instructor

• Instructed an evening class in RPG II and ADVANCED RPG II programming during the winter and spring quarters.


EDUCATION: Jefferson Technical College
Degree: AB/Data Processing

Numerous classes, seminars, webinars, and CBT's focusing on coding, performance & tuning, project leading, & vendor products.

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Columbus, OH | Resumes in Ohio

View other System Analyst / Programmer resumes, Programmer / Developer resumes