MATTHEW
J. DEAN
Phone: 423.280.1185 Email:
SUMMARY
Seasoned IT professional with over 10 years of “in-the-trenches” consulting experience leading projects involving custom computer programming, data conversion/migration, and implementing packaged software solutions. Former Big-6 consultant with extensive experience in the Energy, Retail, and Manufacturing industries.
PROFESSIONAL EXPERIENCE
Choice Fabricators, Inc.
Rainbow City, AL – Project Manager/Independent Consultant 2003 - Present
- Real Time production and Shipping Project
Project manager of a real-time Steel manufacturing tracking and shipping system developed in VB.NET.
Responsible for all system design, architecture, project management, and delivery of a working solution.
Responsible for scheduling and tracking of project milestones.
Developed software to track product movement and WIP through the production process with bar code labels.
Developed software for Handheld Wireless RF guns to allow for the picking of inventory shipments.
Developed Quality software for the creation of the first production pieces as well as Job tracking.
SQL Server 2000 database design, developed stored procedures, and DTS work for data ETL.
- Purchasing and Customer Service Project
Developed VB.NET software module to import X12 EDI files.
Purchase Order system development.
Developed VB.NET module for Real-time job tracking and container tracking of parts through stamping machines.
Package Software Associates
- Nuclear Work Plan System Development Project
Worked with users to define the system requirements for a new Nuclear Work Planning System.
Developed a working prototype by programming JSP pages and Java servlets using Adobe’s FDF Toolkit.
Converted data from a proprietary system to an Oracle database using Unix shell scripts and Oracle load utilities.
Developed a Java based system to allow for the tracking of Nuclear construction work plans.
- Dam Safety System Development Project
Worked with users to define the system requirements
for a new Dam Safety System.
Developed a working prototype by programming Java servlets using Sitraka’s Jclass ServerCharts.
Lead the data conversion effort to convert 400 Quattro Pro worksheets for 42 Dams to an Oracle database.
Developed conversion programs using VBA, Unix shell scripts, and Oracle load utilities.
-
Lead the reporting team during the Indus PassPort
implementation.
Worked with users to define the requirements for new reports and the conversion of existing reports.
Designed a DB2 reporting database for combining historical data with PassPort data.
Developed interfaces from PassPort using COBOL programs, JCL, and BMC DB2 load utilities.
Trained users on ReportSmith and taught ad-hoc reporting techniques.
Developed reports (FERC 154) to balance the PassPort real-time inventory system to the corporate G/L.
Created programs for daily monitoring of accrued liabilities greater than $250,000.
Created extracts for loading 400,000 catalog items into PassPort (DB2) and EMPAC (Oracle).
- Energy Softworx
Fuels System Implementation Project
Lead the CQAR reporting (adjustments to $1 Billion dollars worth of fuel
contracts) development.
Developed reports using MS Access and Oracle PL/SQL pass-through queries.
Developed data warehouse interfaces from Energy Softworx using COBOL, JCL, and Oracle load utilities.
Developed an ASP IIS based system for the correction of Coal Quality Sampling data.
Matthew J. Dean Page
2
- Walker Financials System Upgrade Project
Programmed and tested logic to correctly implement the Federal Prompt Pay Act
in the Check Writing module.
Programmed modifications for Encumbrance Accounting, Receipts, Invoices, Contracts, and Purchase Orders.
Developed VSAM to DB2 data conversion programs.
Modified DB2/Assembler file access modules and analyzed DB2 Explain outputs.
QuoteSmith.com
- Web Site Development Project
Developed interfaces from RM/COBOL ISAM data files to C/dbm files on an IRIX server.
Created C programs for CGI access to
insurance data from the web.
Deskware, Inc.
- CobolScript Compiler Development Project
Designed the CobolScript programming language - U.S. Patent & Trademark #: 2407077-75599013.
Compiler/Interpreter development in C on the Microsoft Windows, Solaris, FreeBSD, and Linux platforms.
Licensed this scripting language to 500+
COBOL shops worldwide.
ADP/GSI Outsourcing
- Kash n Karry/Food Lion, Outsourcing Client
Lead Unix data and systems conversions related to corporate buyout of client companies.
Managed contract-programming staff (3 programmers) for C/C++ application development.
Managed Unix administrators (2 sys admins).
Informix DBA for 10 database applications, performed tuning and upgrades of Informix on SunOS/Solaris.
Performed Unix system administration and 7/24 support for 20 Sun servers and two AIX servers.
Converted data from DB2, IMS, and VSAM to Informix databases.
Developed interfaces to submit JCL on mainframes from shell scripts on Unix servers.
Mapped data from legacy IMS system to
WWCS (World Wide Chain Store) packaged system.
- National Recovery Systems, Outsourcing Client
Developed applications using C/ESQL and Informix 4GL.
Tuned Informix databases and upgraded the Informix DBMS software on a SunOS server.
- Sports and Recreation Inc., Outsourcing Client
Installed Informix and configured a new Sparc 1000 Sun server.
Installed PeopleSoft, partitioned Informix database tables and indexes, and deployed PeopleSoft clients to PCs.
- Returns Processing Center, Outsourcing Client
Maintained POS systems written in C++ in an X-Windows environment with Interviews and Rouge Wave.
Performed Informix database support
(backup and recovery) and tuning.
- Parafax, Bulk Faxing System Re-Write
Rewrote a Clipper application used for bulk faxing on an array of 100 machines
connected to a Novell server.
Price Waterhouse Public Utilities Group
-
Lead a 6-member team to extract VSAM, Adabas, and proprietary data to a new DB2 and Sybase environment.
Configured the DB2 and Sybase environments.
Conducted JAD sessions with users according to Price Waterhouse’s SMM (Systems Management Methodology).
- Consolidated Natural Gas, CIS Implementation
Audited a large client/server systems effort in accordance with Price
Waterhouse’s SMM.
Assisted technical leads with proper client/server design and creation of Sybase stored procedures.
-
Developed client/server components in PowerBuilder for Customer and Service Order inquiries.
Designed and created Sybase stored procedures and integrated them with CICS transactions.
Matthew J.
Dean Page
3
- Piedmont Natural Gas, Billing System Implementation
Programmed Billing and Service Order modifications to the system using ADW.
Responsible for coding mainframe COBOL data conversion programs, JCL, and DB2 load utilities.
Tested billing programs and performed Q/A on converted data.
- Niagara Mohawk Power Corporation, Power Billing Implementation
Performed analysis of large volume electric and co-generation facilities.
Analyzed tariffs and hourly billing calculations to develop the design for the Hourly Integrated Pricing program.
Designed and developed billing programs for co-generation, PASNY,
and various tariffs in
Modified A/R and G/L subsystem programs using ADW, COBOL, CICS, and Xpediter.
Conducted JAD sessions with users to achieve approval for design work.
Performed project estimation and analysis for coding, implementation, data conversion and testing phases.
Designed, developed, and tested DB2 load utilities, COBOL, APL, dBASE, and SAS extract programs.
EDUCATION
B.S. Computer Technology
|
Actron CIS/Service 2000 |
|
|
Curator |
PeopleSoft |
|
EMPAC |
Walker Financials |
|
Energy Softworx |
WorldWide Chain Store |
|
IBS |
Made To Manage |
|
Mainframe |
Unix |
PC |
|
MVS/CICS |
AIX |
DOS |
|
OS/390 |
FreeBSD |
Novell |
|
VM/CMS |
HP Unix |
Windows 2000 |
|
z/OS |
IRIX |
Windows 98 |
|
|
Linux |
Windows NT |
|
|
SCO |
Windows XP |
|
|
SunOS/Solaris |
|
Databases/File Systems
|
BDAM |
ISAM |
Oracle |
|
BDE |
MS Access |
PostgreSQL |
|
DB2 |
MS SQL Server |
Sybase |
|
Informix |
MySQL |
VSAM |
|
MS SQL Server 2000 |
|
|
Report Writers
|
ReportSmith |
SQR |
|
|
|
Methodologies
|
SMM/Summit |
Whitten, Bently, Barlow |
Bar Code/Scanner Equipment
|
Intermec 3400/4400 |
Wedges |
|
Symbol LRT 6800 |
|
Programming Languages
|
ANSI COBOL |
JavaScript |
|
ASP |
JCL |
|
Assembler |
JSP |
|
Bourne Shell |
K Shell |
|
C Shell |
MicroFocus COBOL |
|
C/C++ |
PHP |
|
Clipper |
PL/SQL |
|
CLIST |
PowerBuilder |
|
COBOL II |
RM/COBOL |
|
CobolScript |
SAS |
|
Dbase |
TGS |
|
Gupta SQL Windows |
VBA |
|
HTML |
Visual Basic |
|
Java |
Visual C++/C SDK |
|
VB.NET |
Intermec IPL |
Source Code Management Systems
|
CVS |
Panvelet |
|
CA/Endevor |
RCS |
|
Visual Source Safe |
|
Other Software
|
Adobe FDF Toolkit |
INFOPAC |
|
ADW |
Platinum DB2 Utilities |
|
Apache, |
QMF |
|
BMC DB2 Utilities |
SPUFI |
|
Candle OMEGAMON |
SQL*Plus/SQL*Loader |
|
Compuware Abend-Aid |
Strobe for DB2 |
|
Compuware File-Aid |
Sybase rep server |
|
Data Direct |
SyncSort |
|
ERWIN |
TSO/ISPF |
|
Excelerator |
WebSphere |
|
IEF |
Xpediter |
|
Loftware |
|