6/01 to 9/02 Safeway Stores Walnut Creek, California
Designed and wrote a beverage Quality Assurance Standards and tracking application using Visual Basic 6 and mainframe
connections for the Supply Division.Performance analyst and quality assurance lead for a project that involved Java applications
running under Mozilla on Linux on proprietary hardware “slates” attached to a shopping cart. Personalized
shopping advice was transmitted using radio frequencies to the slate which included a magnetic stripe reader.Project lead to
formalize data extraction and FTP transfer from mainframe DB2 databases to mid-range Informix databases as part of the
Inventory Shrink analysis project using VB.net. Lead Technician on three eBusiness projects – demand aggregation
(company-wide order consolidation across numerous hardware platforms); integrated catalog management (automation of
vendor item changes) and using Connect Direct and Connect Enterprise to send point of sales data from a datamart to select
vendors. Architecture was MQ Series linking mainframe COBOL LE programs to Java handlers which handed off XML to a
browser. The follow-up projects involved extracting business rules from the legacy COBOL applications and re-engineering in
Visual Basic with a substantially different architecture. Participated in the specialized purchasing system (meat, seafood and
produce only) construction which converted more than two hundred forms from FoxPro 2.5 to Visual Basic 6 with unique FAX
and email services.
1/01 to 6/01 TenSquare.com San Jose, California
Project manager and technical lead reporting to the Chief Financial Officer for a very high volume, real-time billing system
designed to obtain gasoline pump display controller telemetry in XML using VB 6. Rule-based calculations were applied to rate
the advertising events and then interface to Oracle Financials (accounts payable and accounts receivable).
11/99 to 1/01 Safeway Stores Walnut Creek, California
Co-lead on a project to design and write an application to coordinate general ledger budgets with shop floor control of
manufactured items using Visual Basic with intense and extensive use of Crystal Reports. Data mining to determine which
customers were most profitable and why by building essBase cubes from extracted DB2 data and by using Informatica
PowerCenter. The Store Charges application was written in Visual Basic and used Informix and DB2 databases to provide retail
store management with visibility into the accounting consequences of ordering actions.Designed and wrote a very complex
application which tracked and evaluated the efficiency of the company’s annual two billion dollar investments in real estate
purchases and facility upgrades. Working under considerable pressure I replaced an under-documented and inefficient collection
of FOCUS programs by building a flexible harness which allowed accounting personnel to build SQL queries and have them run
overnight on a schedule. The results were downloaded to Access and any errors reported by email. This reduced the number of
sleeping bags in the offices during period close by 100%.
Chronological (continued):