Project Manager in the Procurement group that successfully led a 15 person team as Business PMO across 4 time zones (San Jose, Ireland, Singapore, India) on a supply chain infrastructure project with a budget of $600K and a benefit of ~$1M/yr in cost reductions. Project configured Oracle, Camstar, and EDI to automate the purchase of direct materials.Primary procurement business partner to the IT Business Applications group on negotiations for professional services with annual spend of ~$3M.Implemented Oracle Iprocurement and PO modules for 17 countries in Europe and Asia which eliminated paper requisitions, improved SOX compliance, and increased efficiency.Created quarterly purchasing department metrics to present to Operations VP such as Negotiated Savings, Total Spend, Turn-around-time, Savings Opportunities, and Engagement with stakeholder percentages. Wrote SQL scripts in TOAD application to query Oracle.Led testing for procurement modules globally and implemented AME (Approval Management Engine) for Oracle R12 Upgrade. Automated test scripts saving at least 1000 hours of people effort each year using HP Quality Center software.Managed a team of 7 people during the 2009 “Great Recession” when our Operations department shifted ~50% headcount (200 people) from USA to Singapore. The team's focus shifted from data processing to partnering with stakeholders to negotiate savings.Other projects included implementing Oracle Stores and Catalogs functionality, creating department Sharepoint site, implementing DocuSign electronic signature, and implementing Pcard program.

Improved performance by as much as 50 percentage points by creating MS Access databases for Past Due Sales Orders, Past Due Work Orders, Safety Stock, E&O Reserve Trend, Weekly Gross Inventory, and On-time Shipment metrics. Enhanced Worldwide Inventory Report by providing more in-depth analysis and consolidating historical data. Remodeled Reserves Analysis schedule to cut work time from 2 days to 2 hours. Increased accuracy of international Profit Eliminations and cut work time by 8 hrs. at month end close. Reduced the cycle time of month-end reconciliations by as much as 1.5 days to achieve a 3 day close. Analyzed impact of standards change and improved the reporting process by formulating sequential steps in conjunction with Visual Basic scripting. Analyzed at-risk work orders for E&O reserves analysis. Processed weekly transfers of Oracle 11i Inventory and Purchasing modules. Documented procedures after improving processes. Processed ECO’s in Agile and Oracle Costing Module.The following are accomplishments for Positive Light,Inc. which was a startup where I worked that was purchased by Coherent in 2003.Created forecasting model for Revenue. Partnered with Positive Light CFO to prepare budget for annual manufacturing department expenses. Prepared summary reports (i.e. Balance Sheet, Income Statement, and Statement of Cash Flows for acquisition).Assisted CFO and Operations in project to allocate costs by Product Family. Reconciled system differences between manufacturing software and financial software with SQL resulting in the reduction of variances by hundreds of thousands of dollars. Maintained commissions model for sales department. Calculated burden rate for labor and overhead. Maintained company’s capital assets tracking system. Generated monthly BBB, Inventory, and Income Statement reports. Key contributor in migrating capital asset and inventory module into Oracle 11i.

Partnered with client CIO and sales force to design internet sales configuration tools. Functional lead in gathering requirements and storyboarding prototypes. Performed business requirement analysis on e-commerce (Selectica) configuration engagements. Produced deliverables such as flowcharts, HTML prototypes, storyboards, and business requirements documents for clients based on interviews. Developed business processes on configuration engagements.

Developed MS Access WIP database resulting in timesaving of 60 hrs. per month. Coded VB script which converted hierarchical database reports into relational OLAP models for Cost Accounting resulting in timesaving of 50 hrs. per month. Performed quality assurance on data upload during BaaN ERP upgrade. Generated daily Bookings, Billings, and Backlog (BBB) report for upper management. Performed bank reconciliation that had been neglected for 6 months. Analyzed yield, migration, and price variance for forecast and month-end close cycle. Performed weekly WIP reconciliation between different computer systems. Maintained standard cost and contributed in cost revision for all products.