Western Door

Employed, Laboris

May 2004 – January 2009

  • A few years after leaving the La Jolla Institute, Steve PonTell asked me to join him at a residential “finish carpentry” company located at 719 Palmyrita Ave, Riverside, California. I became the Lead Application Programmer using Oracle E-Business Suite (11.5.10 on a 10g database). Specifically, I was involved in:
    • Requirements Definition: I wrote a 50 page system requirements document and 7 sub-system requirements documents that defined our business ERP needs. These requirement documents were based on interviews I conducted with all department heads and company executives.
    • Vendor and Implementation Consultant Selection: 5 vendors demonstrated their ERP software and discussed their recommended implementation process. The requirements documents were provided to each ERP vendor prior to their product demonstrations. After the CEO selected Oracle as the ERP vendor, a consultant was chosen to assist our team in implementing E-Business Suite.
    • Functional and Technical system setup: Due to non-performance, the consultant team was terminated after 4 months and I led the in-house go-live effort. During the subsequent 8 months, I manually setup the Oracle instance multiple times prior to go-live. The modules I setup were: GL, AR, AP, OM, QP, PO, INV, BOM, MRP, WMS, WIP, and FS. Every instance was tested by our department heads, and I implemented changes after each iteration was reviewed. I wrote a full setup document that details every key-stroke (800 pgs).
    • Legacy system data conversion using TOAD/Excel: Every department had data that needed conversion, standardization and clean-up prior to loading into the Oracle database. I worked with technical leads from 3 departments (Sales/Estimating, Purchasing, Manufacturing) to define and load 600K items into our Master Item catalog. I loaded 330K BOM’s and Routings to support our Manufacturing process. I loaded 1000 vendors and a complete set of GL balances. I loaded standard costs for all purchased items.
    • Incorporation of “Multi-org” capabilities: The initial implementation of our Oracle instance had 1 business group, 3 operating units, and 2 inventory orgs. 2 years after initial go-live, I successfully added a 2nd business group with it’s own operating unit and inventory org.
    • Real-Time, Web-based Dashboard creation (Application Express): After a successful go-live on 12/31/05, the company soon realized that getting real-time information from Oracle was essential. This began a development process of web-based “dashboards” which queries department/user-specific information. I wrote 100 dashboards that covered all aspects of the company, including Production, Inventory, Warehouse Management, Purchasing, Customer Service, and Accounting. The combination of Oracle EBS and these dashboards greatly increased productivity.