Supporting Oracle ERP 11.5.10 Modules and various manufacturing related applications.

Independent Projects:- Conversion of an Inventory Transaction search engine from Oracle and Classic ASP into MySQL and Perl.

• Upgrading system interfaces between Markdown Optimization (MDO) and Retail Price Management (RPM)• Supporting a stand-alone in-house flash-sales reporting system for daily sales metrics, loosely tied to Oracle Retail• Oracle Development: SQL and PL/SQL, Oracle Forms and Oracle Reports, Pro*C

Supporting Oracle 11.5.10 ERP, a single world-wide instance with 300,000 Items and 100 Inventory Orgs, Linux/RAC• Supported Item Master, BOM, Costing, Inventory, WIP, Purchasing, Configurator and Transfer Pricing• Worked with Functional Leads, created Requirements, Technical Designs, Test Cases• Supported IT Quality and FDA Computer Software ValidationSupply Chain Finance• Built a process for "multi-sourced" standard costing• Designed a staging database for Annual Costbuild to handle 60 sources• Created a Transfer Markup process to handle approx 100 rates• Improved performance of Account Generator from two hours to five minutes• PPV and reconciliation toolsOracle Manufacturing• Technical lead for Discrete Manufacturing (ODM) conversions (11.5.10)• Developed requirements, technical documentation and helped coordinate conversion steps• Built a staging database for complex conversion rules (PL/SQL)• Designed, built and/or coordinated- Item Master, Revisions, Bill of Material, Routings, Inventory Locators, Quantity on Hand, Purchase Orders, Cost, Kanban, WIP- Legacy data extracts, SQL/Loader, Dataloader- Data cleansing analysis (SQL)- Customized Oracle Interfaces- Product Line Accounting (PLA)- Created Costing logic to help preserve the legacy inventory value in Oracle• Process Manufacturing (OPM)- Support for Immunomics 11.5.4 instanceTechnical Applications:LabQM- Laboratory Quality Management system for Inter-laboratory Quality Assurance, clinical labs submit data to be grouped statistically and reportedVAMP- Value Assignment Management system for the value assignment of target ranges during Reagent manufacture and for printing of product insert• Technical Lead on two related systems• FDA validation documentation and testing• Monthly productiom support• Assisted Web Data Entry project in Oracle Weblogic• Oracle RDMS, Forms and Reports, Delphi, LaTex

Supported the Commercial Aircraft division of "then" McDonnell-Douglas in Long Beach, later acquired by Boeing:• Implementation Team for “Shop Floor 2000” a paperless Electronic Work Instruction System, written in client/server Delphi using an Oracle database on Sequent Unix clusters• Created a Mfg Assembly Tracking system in Oracle Forms and Reports

Designed and maintained computer software and database software relating to the Neuroblastoma Autologous Bone Marrow Transplant program.• Authored and co-authored scientific publications.• Co-created DIMSCAN, a digital imaging microscope system and software for neuroblastoma cytoxicity testing. Cells grown in microplates were scanned using fluorescent dye.• Supported LIFEGRAF, a custom program for producing Kaplan-Meier Survival Curves.• Designed a database tracking system for the Monoclonal Antibody Production laboratory. Foxpro database for tracking antibody purification, batch data, column sterility, etc. • Programmed and maintained neuroblastoma research databases for patient demographics, test results, bone marrow purge data, freezer inventories and research protocols.

• Created a Project Management Reporting System (PMIS) for reporting to NASA • Work Breakdown Structure and C/SCSC Methodology