Matt Dean
Software Systems Developer at Siskin Steel & Supply
deskware@outlook.com
Summary
SOFTWARE APPLICATIONS PROJECT MANAGER & CONSULTANT - Mr. Dean is a Purdue University
graduate and a Price Waterhouse Alum with over 25 years professional consulting experience helping
companies implement complex large-scale custom software system projects. He is a hands on technical
manager with the ability to mentor staff and share with them real world approaches to solving business
problems through the use of Information Technology.
Mr. Dean is known for his breadth of knowledge from legacy mainframe systems to modern programming
environments and platforms. Prior to the year 2000 he founded a company that produced a programming
language and reverse engineering tools that helped thousands of companies around the world mitigate the
impact of Y2K. He is known in the software industry as the creator of the cobolscript programming language,
and for bringing the VACE software reverse engineering tool to market.
He has been an employee of high-caliber firms like Price Waterhouse and ADP-GSI. It was through working
on substantial projects throughout the United States and Canada that he was able to develop a keen work ethic
and a strong business accum. As a Manager for the Tennessee Valley Authority (TVA) he has been a driver for
change, and has overseen numerous software engineering teams, projects, and outside consultants.
Specialties: Manufacturing, Utilities, Retail, Steel
Experience
Software Systems Developer at Siskin Steel & Supply
May 2016 - Present
Summary
Hired for real-time manufacturing systems development and analysis to support a large multi-state inventory,
logistics, and distribution operation.
Operating Systems: Unisys Clearpath MCP
Programming: WFL, COBOL, INSYTE
Databases: DMSII, MS SQL
Other: JIT, SOX
Sr. IT Business Consultant at Tennessee Valley Authority
Page 1
March 2014 - January 2016 (1 year 11 months)
Business Consultant in a strategic leadership role that, works in concert with executive leadership across
TVA Strategic Business Units (SBUs). In this role I am broadly empowered and accountable to act to
establish a comprehensive technology vision and strategy, develop multi-year technology roadmaps, and
investment plans. I am responsible for building and maintaining strategic partnerships between Information
Technology (IT) and other TVA SBUs and analyzing the expectations of the business to achieve lower
costs, maximum value, competitive advantage, and improve customer satisfaction through the appropriate
use of technology. As a Business Consultant I am is responsible for working with TVA SBUs to ensure
adequate business cases including benefits and return on investment (ROI) are developed for all proposed
IT programs and projects. Also responsible for ensuring SBU IT/Operational Technology (OT) Plans are
developed and maintained that align with the TVA Strategic IT Plan. Responsible for the strategic business
interface between the TVA SBUs and the Information Technology organization. Other responsibilities
include fostering an understanding of IT enabled business process improvements and ensuring effective
communication between TVA SBUs and IT.
I work closely with IT program and project managers and analysts during the entire lifecycle of SBU IT
programs and projects. Provide cross-organizational coordination and business consulting services for
Information Technology, mentors and provides oversight for lower level IT Business Consultants. Assist
TVA SBUs in obtaining IT program and project budgets ranging up to $250K to $100M.
Operating Systems: MS Windows, Solaris
Programming: C#, VB.NET, Informatica, T-SQL, PL/SQL, ESRI GIS, PHP, Shell Scripting
Databases: MS SQL, Oracle, FireBird
Other: Lean Process, Agile, Waterfall, SOX
Manager - River Operations, Envrionment, and EGIS Applications at Tennessee Valley Authority
January 2012 - March 2014 (2 years 3 months)
Managed a team of software development professionals in meeting the automation needs of the TVA.
Supervised a department size from 20-40 staff including employees and multiple staff augmentation
contractors.
Buget under management ranged from $4-8 million. Developed a strategic applications plan to support
TVA’s overall strategic plan and river operations and eGIS applications strategies. Identified opportunities
to improve TVA’s business practices, through long-term cost reductions and revenue enhancements, and
selling the ideas/concepts to internal TVA customers including securing appropriate funding for all River
Operations and eGIS applications. Assembled teams of software professionals to address agreed upon and
funded technology projects, ensuring that IS professionals from non-application disciplines are involved as
appropriate.
Page 2
Developed and supported TVA-wide river operations and eGIS applications initiatives and served as primary
focal point for shared systems and expertise in the areas of river operations and eGIS operations planning.
Ensured that existing applications used by the business unit are fully supported with appropriately skilled
staff. Maintained a high level of customer satisfaction. Maintained individual development programs
for each employee such that each staff member is properly equipped to perform his or her job function.
Addressed and planned for improving employee performance in areas such as coaching, developing, and
training employees, career planning and development, achieving staffing and hiring goals, workforce
balancing, diversity, union/labor relations, and complaints/grievances.
Operating Systems: MS Windows, Solaris
Programming: Java, C#, VB.NET, C++, ESRI GIS, Informatica, T-SQL, PL/SQL, Shell Scripting
Databases: MS SQL, Oracle, FireBird, SAS Datasets
Other: Lean Process, Agile, Waterfall, SCRUM, SOX
Project Manager at Choice Fabricators, Inc.
2003 - September 2013 (10 years 9 months)
Summary
Hired as a contractor to replace a legacy RM/COBOL system and write a new custom ERP/MRP system in
VB.NET and MS SQL Server for a JIT Steel Manufactuer.
Projects
• Real-time Production Inventory System - Wrote a real-time JIT production system in VB.NET/MS SQL
Server to create Intermec bar-code tags to track Raw Materials, Work-in-progress, and Finished Goods from
a coil of steel to a part for automobiles, appliances, and HVAC systems.
• Shipping, Picking, and ASN System - Created a custom windows forms VB.NET/MS SQL Server system to
drag-and-drop parts from inventory, create packing slips, and send Advanced Shipment Notices (ASNs) via
the Internet to customers. Also created VB.NET console applications to run on Symbol wireless scan guns
for staging and loading semi-trucks. Database triggers and store procedure were also utilized.
• MRP Planning System - Created a windows forms application in VB.NET/MS SQL Server containing
complex grids for analyzing Demand from customers downloaded via. the Internet with current Raw
Material, Work-in-Progress, and Finished Goods inventory numbers to plan purchasing and production
scheduling in the plant. Many data base stored procedures were also created for this system.
• EDI Demand Processing System - Wrote a custom system in VB.NET/MS SQL Server to login to
suppliers B2B websites like GE SupplierNet, Frigidaire, and download EDI 830, 862, etc files and parse the
mainframe data and import the demand into the production systems. This was done without a VAN or EDI
Page 3
software, my expertise in parsing mainframe data allowed me to develop the custom code without the need
for GenTran, Microsoft BizTalk, or other EDI processing software.
Operating Systems: MS Windows
Programming: VB.NET, RM/COBOL
Databases: MS SQL Server, ISAM
Other: EDI
Project Manager at Zycron
April 2009 - January 2012 (2 years 10 months)
Summary
Contractor hired to lead the re-hosting of 30+ mission critical IBM mainframe applications to Solaris/
Informatica/Oracle and MS Windows/C#/MS SQL Server platforms. Afterwords, was retained to lead the
development of 6 Fuels Assurance Cost Tracking Systems on MS Windows/C#/ESRI GIS/MS SQL Server
and Oracle platforms.
Projects
• IBM Mainframe Re-Host - Lead the re-hosting of several of the TVAs mission critical fuels applications to
shutdown their mainframe, and support the implementation of Maximo. Managed a large development team
rewriting legacy COBOL/JCL/DB2 systems to Informatica/Oracle and C#/MS SQL Server.
• Fuels Inventory Tracking - Managed a team of C#/ESRI GIS/MS SQL Server developers to create a near
real-time system to track barge and rail deliveries of $2.65 billion dollars work of coal. I reached out to Tier
I transportation vendors like Norfolk Souther, BNSF, Union Pacific, Ingram Barge, etc. and negotiated the
custom interfacing of their shipments for the TVA.
• Vendor Data Automation - Managed a team of Unix/Informatica/Oracle developers to create an email
based data automation system. This system involved 3rd party labs on the Ohio and Mississippi Rivers and
Terminals that would email and SFTP sample data to the TVA before coal was received.
• Coal Quality Annual Reporting - Managed a team of C# developers that uplifted a MS Access system used
to adjust payments on $2.65 billion dollars worth of fuels purchases. This involved calculating the penalties
or premiums paid on these purchases and the SOX compliance issues involved in these transactions.
Operating Systems: MS Windows, IBM Mainframe
Programming: C#, VB.NET, Informatica, COBOL, JCL, ESRI GIS, Shell Scripting, PL/SQL, T-SQL
Databases: DB2, MS SQL Server, Oracle, MS Access, IMS, VSAM, SAS Datasets
Other: SCRUM, EDI, SOX
Consultant/Team Lead
2000 - 2003 (4 years)
Page 4
Summary
Software engineer hired to program Walker Financials/COBOL/DB2, C/RMCOBOL, Java, PL/SQL, Shell
scripting for Oracle custom systems and interfaces.
Projects
• Walker Financials System Upgrade - Programmed the Purchasing, Receiving, Check Writer, and
Encumbrance Accounting upgrades for the TVAs financial system using COBOL/TGS/DB2.
• Dam Safety System - Coded a J2EE/Oracle web based system for recording instrumentation data collected
by field inspectors from Piezometers, Weirs, and other data loggers. Also programmed graphing and
charting functions.
• Indus Passport Supply Chain Implementation - Lead the reporting team for the replacement of the TVAs
legacy custom mainframe supply chain system. Also performed data conversion for the Purchasing, Issues,
and Receipts.
• Nuclear Work Planning System - Developed a Java/Adobe FDF Toolkit/Oracle based system to replace a
legacy HP work planning system. This system was similar to a web based system but used the Adobe FDF
toolkit to place fields on top of Adobe PDF forms that were displayed in a browser and then the entries were
saved to an Oracle database and re-displayed when someone looked them up. This was a custom application
developed to support the re-start of the Browns Ferry Unit 1 reactor.
• Energy Softworx Fuels System Implementation - Programmed PL/SQL scripts for interfacing to an Oracle
database and a fuels data warehouse.
• QuoteSmith.com Insurance web site - Coded C programs used on the QuoteSmith.com website. Also
modified legacy RM/COBOL systems and built new interfaces. This was the first company to sell insurance
on the Internet.
Operating Systems: MS Windows, Solaris, SGI IRIX, IBM Mainframe
Programming: Java/J2EE, C, COBOL, Mainframe Assembler, PL/SQL, T-SQL, Shell Scripting
Databases: DB2, Oracle, MS SQL
Other: Adobe FDF Toolkit
President
1998 - 2000 (3 years)
Summary
Started a company and developed a C/SDK Windows application to reverse engineer COBOL, Assembler,
PL-I, and RPG source code for Y2K. Also wrote the cobolscript compiler in ANSI C.
Projects
• VACE Reverse Engineering Workbench - Wrote a windows application in C/SDK and created custom
DLLs that contained parsers for the COBOL, Mainframe Assembler, PL-I, and RPG languages. This
Page 5
software analyzed source code and displayed a unique navigation tree that allowed mainframe programmers
to quickly analyze and edit very large programs.
• cobolscript compiler - Created the cobolscript language and the associated interpreter/compiler in ANSI C.
U.S. Patent & Trademark #: 2407077-75599013.
Operating Systems: MS Windows, Linux, Solaris, FreeBSD
Programming: C/SDK, ANSI C, Shell Scripting
Databases: MySQL, Postgres
Other: unixODBC
Unix Data Center/Application Development Manager at ADP-GSI
1995 - 1998 (4 years)
Summary
Hired to maintain C/C++/Information applications on the SunOS and Solaris platforms and create interfaces
to IBM Mainframe systems. Also was an Informix DBA. Later promoted to manager.
Projects
• Kash n Karry Food Stores Pricing System - Maintained C++/Motif/Rogue Wave/SunOS/Solaris applications
for pricing systems that would interface with an IBM Mainframe and then IBM POS machines in stores.
• Returns Processing Center System - Maintained a C++/Motif/Rogue Wave/SunOS/Solaris application that
would read POS scanners an inventory damaged or returned grocery items.
• Sport and Recreation PeopleSoft Implementation - Installed PeopleSoft on a large Solaris server and created
the Informix database environment. Also installed and configured PeopleTools on client machines.
• Parafax Bulk faxing System re-write - Re-wrote a dBASE application in Clipper that would poll hundreds
of computers on a rack with each one of them containing four modems and combine .TIFF art work with data
from a database and send thousands of faxes.
Operating Systems: MS Windows, DOS, SunOS, Solaris
Programming: C/C++, Clipper, Shell Scripting
Databases: Informix, DB2
Other: PeopleSoft
Consultant at Price Waterhouse, Public Utilities Group
1993 - 1995 (3 years)
Summary
Hired to write COBOL/JCL/DB2 code for billing systems, and then PowerBuilder/C SDK/Sybase client
server systems. Later promoted to Sr. Consultant.
Projects
Page 6
• Toronto Consumers Natural Gas CIS System - Programmed COBOL/JCL/DB2 batch billing programs and
modified PowerBuilder/Sybase screens for a large Customer Information System implementation.
• South Carolina Electric and Gas CIS System - Coded and modified PowerBuilder/C SDK/Sybase screens
for a large Customer Information System implementation.
• Dominon Power CIS Audit - Conducted an audit of the PowerBuilder/Sybase environment on a large
Customer Information System project.
• Piedmont Natural Gas Billing System - Coded batch COBOL/JCL/DB2 programs to calculate gas bills for
North Carolina, South Carolina, and Tennessee customers. Also modified CICS screens with BMS Maps/
COBOL.
• Niagara Mohawk Power Billing System - Coded batch COBOL/JCL/DB2 programs to calculate industrial
electric bills for large customers, hourly billing clients, and co-billing with the Power Authority State of New
York. Also modified CICS screens with BMS Maps/COBOL.
Operating Systems: IBM Mainframes, MS Windows
Programming: COBOL, JCL, PowerBuilder, C/SDK, SAS
Databases: DB2, Sybase, Oracle, SAS Datasets
Other: Knowledgeware
Programmer/Analyst at Purdue University
March 1991 - June 1993 (2 years 4 months)
• Planned, negotiated and developed database structure for the Integrated Pest Management Information
System that was utilized by SAS and CAD applications.
• Developed an Integrated Pest Management Information System to be marketed by the University to
Landscape Architecture firms.
• Worked with Architects, Entomologists, and Civil Engineers to effectively meet their information needs.
Engineering Assistant - Internship at Duke Energy Corporation
April 1991 - September 1991 (6 months)
• Maintained and enhanced dBASE systems.
• Instructed Engineering Assistants and CAD Operators on the used of dBASE systems.
• Performed PC maintenance (Optimizing hard drives, cleaning disk drives, and diagnosing hardware
problems).
• Installed Software such as word processors and engineering applications.
• Assisted Electrical Engineers with field checking and mapping projects.
• Broke down work orders and drew electrical easements from legal descriptions.
• Involved in customer relations (in person and through letters).
• Contributed greatly to the department with technical support associated with Engineering Management
Systems.
Page 7
Customer Service Specialist - Internship at Duke Energy Corporation
April 1990 - September 1990 (6 months)
• Worked independently on Lotus and dBASE projects.
• Consulted managers on the uses of Lotus, microcomputer ease, and dBASE systems.
• Processed regular payments, disconnect payments, prepared daily reports, and bank deposit reports.
• Acquired an understanding of numerous accounting as well as managerial procedures.
Dietary Staff Member
April 1989 - September 1989 (6 months)
• Gained experience working with physically and mentally handicapped individuals.
• Prepared daily diets for residents with physical disabilities, diabetes, AIDS, and mental disorders.
• Introduced me to working together with all types of people.
Education
Purdue University
BS, Computer Technology, 1989 - 1993
Activities and Societies: Intramural Basketball and Boxing.
PriceWaterhouse
MITIS Program, Consulting, 1993 - 1993
Activities and Societies: United Way
Page 8
Matt Dean
Software Systems Developer at Siskin Steel & Supply
deskware@outlook.com
Contact Matt on LinkedIn
Page 9