System Architect / Developer / Tech support

EXPERIENCE

3/2001 - Present

Tri-Technology Systems

Lemont, Illinois

Software Maintenance / Network Administration for various clients, 2001 – Current

Maintain, modify, update and write additional software as needed per client specifications. This includes changes and modifications to RealWorld, GEAC, MCBA, job costing, payroll and other custom programmed packages for clients along with implementing new network architecture in a variety of environments.

Report Concierge – Retail Software Package - Commercial Real Estate Appraisal Report Generator, 2001 – Current

Responsible for design / development / deployment of a narrative report automation software package for the commercial real estate appraisal industry. This includes distribution CD, web presence including but not limited to user registration, trial product download, product updates, purchase, product support by chat and bulletin board, and activation via the web. The original prototype was developed over the last 12 years by a real estate firm using WordPerfect macros. I redesigned, enhanced functionality, and programmed the saleable commercial application. It was publicly released Q4, 2002. It consists of 21 input screens, written in VB 6.0, heavily utilizing Microsoft Word's office automation and COM features. It is transportable between Access and SQL Server. It is a two-tier client/server application. It incorporates a "Live Update" feature, which informs users of program updates and enhancements via the web, and allows them to download and install the updates similar to Norton Anti Virus live update feature. It includes web purchase and registration facilities via ASP components. See www.reportconcierge.com for more information.

· Project Technical Summary: Microsoft Office 2000 -2007, Microsoft Visual Studio 6.0, Microsoft Project, Visio, Microsoft Source Safe, OLE, Janus GridEx, Rational Rose, Access, SQL Server 6.5, 7.0. Beta Testing SQL Server 2000 Enterprise Edition 64 bit, Microsoft Front Page 2000, Mercury Mail Server, Anyboard BBS, RM Cobol, MicroFocus Cobol, Anyboard Chat, ADO, ODBC, Windows 98, ME,XP, 2000, 2000 Pro, 2000 Advanced Server, MySQL, HTML, NT 4.0, IIS, DNS, Crystal Reports 7, Comersus.

Customer Support – Support various customers in network administration, software development / enhancements, and system administration / troubleshooting.

Assist clients with various technical troubleshooting issues regarding networking, system administration. Maintain various clients’ software by enhancing and modifying source code.

· Technical Summary: Microsoft Office 2000 - 2007, Microsoft Visual Studio 6.0, Liant Cobol, Visual Basic, Linux admin, SCO Unix, Postgresql, Access, Exchange, 2003 SBS , GEAC, VB.

· Microsoft Small Business Specialist designation, MCSE tests in progress, JAVA

3/1996 - 2/2001

National Cattlemen’s Beef Association

Chicago / Illinois

System Architect / Development / Management

VBMM (Value Based Meat Management System) - A perishable goods sales forecasting and category management system for supermarket chains, zones or individual stores.
Allows retail chain stores to generate sales plans/ad campaigns for meat, fish, poultry, veal, lamb and beef at any level of corporate hierarchy. It forecasts sales volume, costing, and profitability margins for these commodities. The user interface is a spreadsheet look alike. The forecasting module retrieves Sales History, Cost, and Retail pricing information from imported Scan Data History, derived or loaded cost information, and retail price information (for any time period and organizational hierarchy level) to generate the initial sales plan. This spreadsheet incorporates roll up/roll down and drill up/drill down capabilities for product category summarization. It can be manipulated at any detail level to produce a purchase and sales campaign strategy for meat department(s). It allows an ad campaign to be generated for the entire corporation, division, price zone, or individual store, with historical recap of projected vs. actual sales. Corporate level sales plans can then be reduced and distributed to store, price zone, or division levels. The distribution algorithm is based on each retail product's contribution to sales volume for every level of corporate hierarchy in the selected time period. Conversely, different sales plans can be aggregated or combined between hierarchy structures to produce a bottom up type of scenario. This allows lower, even store level, planning to occur and aggregate up to corporate level product purchasing, thereby reducing overall costs and providing corporate management the ability to monitor ad campaign effectiveness.
VBMM also contains a costing module which generates future cost figures for different retail cuts of meat based on a cross section of product blend costs, raw material volumes, and labor (time and motion) needed to produce the retail beef product from a primal. It incorporates shrinkage, wrapping, shipping, and stocking labor factors to fully burden the retail product's cost for later profitability calculations. In this module future cost and retail pricing is calculated and determined for an organization's hierarchy and can be distributed to lower or hierarchy levels if wanted. Retail pricing is manually entered producing an overall profit percentage or, if wanted, the profit percentage is entered for any product type and the system calculates future retail prices needed to satisfy profit percentages.
It was converted to client/server architecture and migrated to SQL Server in the year 2000.
Developed requirements, design, SDLC, BCE, ACWP, manpower allocation, task scheduling and prioritization for 3 to 6 consultants during development and conversion of this system.
The product has subsequently been sold to a marketing firm which produces product strategy information for the National Beef Council based on various market studies in process.

· Project Technical Summary: (Delphi II, III, IV, InfoPower, Paradox, SQL Server 6.5, 7.0 Interbase, ReportSmith, Crystal Reports 6, 7, Active Reports, Visual Basic, Microsoft Project, Visio, Access, Sdesigner Pro, IIS, Web Services, Stored Procedures and Triggers.

3/1992 - 5/1996

May & Speh

Downers Grove / Illinois

PAII & QA

Marketing data tabulation and statistical reporting of information retrieved from various promotions and surveys. Included de-duping, data cleaning via NCOA database, and scoring utilizing NCOA data cleaning routines.

· Project Technical Summary: Cobol. Cobol II, DB2, ISPF, File Aid, CICS, VSAM, TSO, Abend Aid, JCL.

AT&T Partners In Business / Loyalty system - A points award / redemption system for toll free “800” business phone number usage.
Worked with the development team in overall design, SDLC, requirements definition, coding and implementation of this system. This complex system consists of on line enrollment (CICS/VSAM), reward point accumulation (via AT&T's billing files), award redemption and reconciliation. Files are parsed into ten segmented VSAM master files for performance.
I was later contracted back in to design, manage, and implement the aggregator portion of the AT&T Partners In Business / Loyalty system. Project budget, defined tasks, manpower requirements and managed four programmer / analysts over a 90 day period during the design / programming / implementation of the aggregator portion of this system.

· Project Technical Summary: Cobol. Cobol II, ISPF, EDF, FileAid, CICS, VSAM, DB2, Abend Aid, JCL, AIX, Microsoft Project, Visio.

3/1987 - 3/1992

Northern Bank Note

Countryside / Illinois

Project Manager

Facilities Management
Implement a complete business / production control system for a medium-size financial printing company. This system includes order-entry, inventory, production control, sales reporting, and interfaces to MCBA Accounting. I worked as lead designer / programmer on this project, using RM COBOL and UNIX and Novell. This is a RM COBOL system running under UNIX / Novell / NT currently supporting 64 users. Document, audit and revise organizational workflow to increase order processing and production efficiencies.

· Project Technical Summary: RMCobol, Liant Cobol, AT&T 3b15 Unix Admin, SCO Unix Admin, Bourne Shell, RealWorld, Windows 95, MCBA.

Bank Vault Inventory
A stock bond inventory system written for a financial printing company in FoxPro for their client banks. Storage charges based upon a rate table were produced monthly and automatically interfaced with the MCBA billing and accounts receivable system.

· Project Technical Summary: Microsoft FoxPro, MSDos

Bond Transfer System
A back-office bond transfer system. Written in C for a five-user PC network (Network OS) running under DOS. I designed the system and managed two programmer/analysts in an 18-month development project. This system is still in use today without modifications since it's implementation in 1989.

· Project Technical Summary: Microsoft C 5.1, MSDos, Raima DBvista database

EDUCATION

6/1975

Roosevelt University

US-IL-Chicago

SKILLS

Skill Name

Skill Level

Last Used

Experience

Design / Management Tools
	MS Project	Expert	Currently used	7 years

S-Designer Pro

Intermediate

2 years ago

1 year

	Rational Rose	Intermediate	1 year ago	2 years
	Visio	Expert	Currently used	6 years
	Erwin	Intermediate	1 year ago	2 years
	VSS	Expert	Currently used	7 years
Mainframe Languages / Tools
	CICS (Macro / Command)	Expert	+4 years ago	18 years
	SDF, EDF	Expert	+4 years ago	10 years
	Panvalet / Roscoe	Expert	+4 years ago	5 years
	Easytrieve	Expert	+4 years ago	4 years
	CA-Sort	Expert	+4 years ago	5 years
	Abend Aid / File Aid	Expert	+4 years ago	5 years
	TSO, Clist, IEFBR utils	Expert	+4 years ago	10 years
	DB2	Intermediate	3 years ago	4 years
	VSAM, QSAM	Expert	+4 years ago	12 years
	JCL	Expert	+4 years ago	18 years
	Cobol / Cobol II	Expert	1 year ago	20+ years

Micro Languages / Tools

MS Visual Studio 6.0

Expert

Currently used

6 years

Visual Basic	Expert	Currently Used	5 years
Active Reports	Intermediate	1 year ago	2 years
C++	Intermediate	Currently used	3 years
Java Script	Intermediate	Currently used	1 year
VB Script	Expert	Currently used	4 years
ASP	Intermediate	Currently used	2 years
XML	Intermediate	Currently used	2 years
HTML / DHTML	Intermediate	Currently used	6 years
COM / DCOM	Intermediate	Currently used	2 years
PHP	Beginner	Currently used	½ year
PERL	Beginner	Currently used	1 year
IIS	Expert	Currently used	4 years
Access	Expert	Currently used	6 years
ADO	Expert	Currently used	6 years
SQL Server 7.0	Intermediate	Currently used	3 years
MYSQL	Intermediate	Currently used	1 year
Delphi II, III, IV	Expert	1 year ago	6 years
Paradox	Intermediate	2 years ago	5 years

InfoPower	Expert	2 years ago	5 years
RM Cobol	Expert	Current	10+ years
Crystal Reports 6, 7	Expert	Currently used	4 years
Liant Cobol 85	Expert	+4 years ago	6 years
Realia Cobol	Expert	+4 years ago	3 years
MF Cobol	Expert	+4 years ago	6 years
C	Intermediate	+4 years ago	2 years
FoxPro	Expert	+4 years ago	7 years
Korn, Bourne, and C Shell	Expert	+4 years ago	10 years
Raima DB Vista	Intermediate	+4 years ago	2 years


Applications

MS Office Suite

Expert

Currently used

10 years

Business Accounting Apps / Full range, G/L, A/P, A/R, O/E, I/M, P/R, etc., etc., etc.

Expert

Currently used

20 years

Manufacturing Apps / WIPS, MRP, Forecasting, Shop Floor, COPICS, etc.

Expert

+4 years ago

10 years

Marketing Apps, Direct Mail, Scoring, Data Cleaning, tabulation, etc.

Expert

+4 years ago

10 years

MCBA

Expert

+4 years ago

5 years

RealWorld Software

Expert

+4 years ago

10 years

QuickBooks

Expert

Currently used

12 years

Informatics

Intermediate

+4 years ago

5 years

MSA Payroll / HRMS

Expert

+4 years ago

5 years

O/S experience
	Windows / 2000/ 2003 / 2008 Server Admin – Hyper-V, AD, OU, GPO	Expert	Currently used	8+ years
	SCO Unix admin	Expert	Currently used	12 years
	Linux Admin	Expert	Currently used	7 years
	Windows 7 , Vista, XP, 2K pro	Expert	Currently used	12 years
	AIX	Intermediate	2 years ago	4 years
	Solaris Various (large scale) Virtualization Projects (VMware, ESXi, Citrix, RDP), thin client implementations	Intermediate Intermediate	+4 years ago Current	4 years 1 year

REFERENCES

Cheerfully Furnished Upon Request