Mainframe Developer with extensive experience in crafting and maintaining complex applications for large-scale, multinational operations across multiple platforms such as OS390 Mainframe, Unix, Terradata and Oracle servers. Leverages expertise in process design and code optimization as well as comprehensive technical proficiencies to mentor peak performing teams and empower business/revenue objectives. Well versed in system development life cycle (SDLC).
Saved warehouse operating costs and saved $100M in on-hand inventory by overhauling the sales forecast process, tracking and applying seasonal influence on weekly predictions to strengthen accuracy to 97%. This was developed in Cobol, using Datacom databases.
Optimized run time for customer sales reports from 18 hours to 90 minutes and accelerated customer startup time through process redesign. This was accomplished by removing the internal sorts within the Cobol programs and implementing external sorts, via SyncSort. This allowed the process to only read the Datacom tables once per occurrence.
Created a purchasing application based on projected service level to the customer, increasing client satisfaction and decreasing inventories levels; enabled lucrative contract renegotiations and extensions. Using a Projected Demand Datacom database, a dynamic JCL job stream, cutting edge Cobol programs, and CICS Jsub programs, I was able to create this application.
Revamped the invoice matching process for Accounts Payable, elevating accuracy and eliminating duplicate vendor payments. By reverse engineering the current Cobol/CICS/JCL/Datacom application, I was able to retrofit the process using multiple data points to increase the matching accuracy.
Technical Proficiencies
Languages
Cobol II
CICS
TSO/ISPF
Eztrieve
DFSORT
RPG II
SQL
Visual Basic
Java
J2EE
Javascript
FTP
MQ Series
XML
Tools
Daptiv
Toad
Crystal Reports
Ascential Datastage
Mobius
Metamon
Metastorm
Microsoft Project
Microsoft Visio
Microsoft Power Point
Microsoft Office
Platforms
IBM zOS and MVS
Windows XP/2000/9x/Vista/7
UNIX
EDI
Databases
CA-Datacom
DB2
Oracle
Access
SQL Server
Certificates
Certified in Microsoft Windows, Access, Excel, & Word
IBM DataStage Essentials for Enterprise Edition
IT Meeting Management
IT as a Service Organization
Business Requirements Management
Career Overview
Stone's Lodge Inn: 2010-Present
Inn, Tavern and Restaurant
IT Server Consultant (10/2010-Present) Contract Position
Reviewed current IT infrastructure and recommended improvements across the three businesses, Stone's Lodge Inn, The Fat Spy Tavern, and The Fat Spy Steakhouse.
Negotiated with external vendors to secure optimum maintenance contracts and hardware pricing.
Worked with internal clients on optimizing their current work flow and business procedures.
Optimized the third-party Point of Sales application to improve order accuracy.
Reviewed, Recommended and Installed a SQL Server based POS system.
C&S WHOLESALE GROCERS, INC.: 1991-2010
2nd Largest Grocery Wholesaler in the US, 20,000+ employees, $22B+ revenue
Senior Programmer Analyst/Project Leader (01/2006-04/2010)
Oversaw eight professionals on the IT forecasting and procurement applications development teams.
Partnered with merchandising departments to design a new investment buying process, enhancing the recommendation application and company profits. Utilizing Cobol, JCL, CICS and Datacom, via TSO.
Devised a more accurate Invoice matching process for Accounts Payable. Increasing payable accuracy to our vendors.
Served as a vital member of the Change Control Board since 2007, contributing to the review and approval of all process and infrastructure adjustments prior to implementations.
Supported daily maintenance of third-party procurement and forecasting software, ensuring the Unix- and Oracle-based applications properly handle $20B inventory.
Integrated, using Cobol/JCL/CICS/Datacom, a third-party warehousing application into the proprietary program to acquire three warehouses without retooling them, enabling immediate utilization.
Led the architecture of an in-house ad hub application which collects data from multiple sources, verifies information based on specific criteria, and formats the data into a common layout for nationwide company use transferring data via MQ and PM4Data. Utilizing ETL Datastage, SQL and Oracle.
Integrating the Oracle MDM into the existing Mainframe data flow. Utilizing ETL Datastage and working with both onshore and offshore teams.
Senior Programmer Analyst (01/2005-01/2006) Programmer Analyst (01/2004-01/2005)
Constructed an ICOP(Individual Customer Order Prompting) purchasing application implemented in 38 warehouses to direct procurement activity for $20B inventory; crafted a complex end-to-end process to cover inventory evaluation, order prompting, filling, and truck building. Utilizing Cobol, CICS, JCL and Datacom, via TSO.
Incorporated an ad feathering model into the purchasing application to predict a customer’s product pull rate, creating a standard deviation to indicate needed on-hand inventory in warehouses. Utilizing Cobol, CICS, JCL and Datacom, via TSO.
Designed training manuals and instructed new programmers in best coding practices.
Programmer (11/1998-01/2004)
Designed and developed a purchasing application utilizing Java, J2EE and DB2.
Converted the reserve inventory reporting process from RPG II to COBOL II, eliminating the need to clone the program for each customer.
Replaced the in-house date conversion process with IBM intrinsic functions to optimize code.
Contributed to the transition from a legacy program to the Exceed Warehouse Management Program, converting and validating data with zero errors.
Fleet Coordinator (01/1994-11/1998)
Developed and maintained an application, written in Microsoft Access, to track trailer locations for a fleet of 4,000+ trailers, decreasing the loss of trailers and increasing recovery if loss or theft occurred.
Developed and maintained an application, written in Microsoft Access, monitoring equipment damage and repair costs streamlining billable damage to outside parties.
Developed and maintained an application, written in Microsoft Access, recording employee accomplishments/attendance as well as generating annual reviews and pay scale recommendations.
Utility Selector/Pallet Sorter (09/1991-01/1994)
Education
Greenfield Community College, Associates Degree 1996
Brattleboro Union High School, Diploma (With Honors) 1987