SUMMARY

• A solution focused professional wif over 12 years’ experience, including hands - on experience wif many major software planning systems such as Baan ERP & Oracle suite of value chain products which includes Oracle Advance Supply Chain Planning, Oracle Demantra, Oracle Global Order Promising and Oracle Inventory Optimization. Tim has demonstrated capacity to find root causes and to deliver effective Technology Solutions, including custom programming and functional training.
• Tim is a consultative IT Professional who brings both Technical noledge and an understanding of Business to his customers along wif a strong desire to assist his Clients in accomplishing their Technology objectives. Information Technology career demonstrates a proven track record of successfully delivered solutions.

PROFESSIONAL EXPERIENCE

• Technical lead: Tim created SQL server scripts for GL allocation of funds in a Predictive trade promotions engagement.
• Technical/functional lead: Tim provided both technical and functional support for new series and extended functionality wif existing series while also providing both demand planning and supply chain functional guidance.
• Technical lead and functional assistant at a Demantra implementation of a custom electronic manufacture. Tim did major technical configuration as well as assisted in providing a functional design for a solution. Conducted user interviews for design requirements and provided input from a supply chain view.
• Implementation of Demantra: Coded and tested a major customization to enable reports to be seen and data exported in calendar months and not standard 4-4-5.
• Development project on ASCP functionality: Worked wif development to set up and test various business cases using constraint based planning
• ASCP and Demand planning fundamentals class: Assisted in teh preparation and delivery of an Advance Supply Chain Planning and Oracle Demand Planning for a client upgrading from 11.5.4 to 11.5.10 and implementing ASCP from using MRP
• Lead Consultant for MPS and MRP training: Trained various companies in teh concepts and functionality of MPS and MRP, through doing dis he increased improved teh overall company performance
• Functional and technical lead in a 3rd line support/development team: Tim did functional and technical analysis in teh areas of Process Manufacturing, Discrete Manufacturing, and Planning for a major ERP system making it a world class support organization

TECHNICAL SKILLS

• Key Skills and Knowledge
• Demantra 7.01, 7.1,7.1.1 and 7.2 (3 years total based on release of version)
• Oracle ASCP 11.5.10 R12 (1 year), Interfaced Demantra wif JDE and SAP
• Supply Chain: Advance Supply Chain Planning, 11i Demand planning,, Inventory Optimization Fundamentals, Production Scheduling-Discrete, Oracle Collaborative Planning, and Global Order Promising
• Core Mfg: Inventory, BOM,, Routing, and Oracle Process Manufacturing
• Key Skills and Knowledge
• Databases Oracle SQL Server
• Languages PL/SQL Baan script
• Oracle Tools
• Oracle Business Accelerator Demantra Tools, SQL Plus SQL
• Unix
• SQL Developer
• Toad
• Bentic
• Supply chain management (Advance Supply chain planning)
• Windows (XP/2000/NT/98/95)
• MRP and MPS Planning
• ERP Software
• Baan IV, Baan V, Infor 6, Oracle EBS, ASCP

Confidential;

Baan Software Engineer and consultant

Environment:

• Demantra 7.3.5, APCC 12.2.3 and ASCP 12.2.3, Windows server, Oracle 10g, Tomcat, data warehouseModules involved: Demand management and S&OP, ASCP, APCC
•  Demantra 7.3. and higher, Windows server, Oracle 10g, Tomcat, data warehouseModules involved: Demand management and S&OP, IO, APCC

Responsibilities:

• Technical lead: Created technical documents for bring client specific data feeds alongside of Standard ODI/PIP feeds from JDE into VCP.
• Created an integration roadmap and design into and out of Demantra.
• Stabilize a custom data import process and enable teh schedule of teh process.
• Provide roadmap documentation giving teh client multiple options for increasing performance of worksheets and data import.
• Produce an integration document based on current configuration implemented by a previous resource.
• Created functional worksheets in various formats from embedded worksheets to multi-tab but single view functionality for demo to Business analyst and end users.
• Trained internal support staff in day to day support of Demantra.
• Simplify, correct and test series modifications and create new series to achieve desired functionality.
• Create an import process for open orders.
• Create a removal process for items mistakenly linked to teh wrong location
• Adjust current custom PL/SQL load script to combine code and description on certain level members
• Business process analysis and Oracle Demantra mapping
• Through discovery and observation noticed an EDI process was taking 18 hours to import POS and VMI client’s inventory on hand. Through analysis of mapping process and EDI standards, Tim revamped process reducing teh time to only 3 hours.
• Published technical Demantra documentation on custom integration and PL/SQL scripts doing data manipulations
• Published functional documentation describing changes in business process
• Program, debug and test PL/SQL scripts
• Created workflows to allow scheduling of weekly and daily jobs
• Modified series definitions as need and created new series
• Created and introduced a waterfall process against sales forecast
• Created new worksheets to enable new VMI clients
• Did performance test of worksheets and adjusted them as need while keeping current business process or enhancing teh process,
• Trained Client’s internal Demantra support staff.

Environment:

•  Oracle Demantra, Oracle ASCP Rel 12, Linux, Oracle 10g, Oracle ASCP
• Demantra 7.2, Windows, Oracle 10g, JDE

Responsibilities:

• During CRP1 show cased teh Oracle application standard features and discussed wif teh business process owners for identifying gaps
• Did detail mentoring and data checking wif key users on worksheet function, design and troubleshooting
• Helped in creating Business Solution design (BSD).
• Created a step by step process guide document
• Created a detailed custom Super user guide
• Created a custom series and import process to enable a demand to resource matching process.
• During CRP1 showing teh new features of 7.1 over teh previous version of Demantra 6.5 discussed wif teh business process owners for identifying gaps
• Ran install wizard in upgrade mode on both dev and test system against a huge amount of data
• Did trouble shooting of data imports after upgrade.
• Trained functional super-user on “open-wif” functionality and it’s usefulness to business process from wifin teh worksheet windows for filtering teh next worksheet in teh business process.
• Created SQL server scripts based on a functional design document.
• Published technical Demantra documentation on custom integration and PL/SQL scripts doing data manipulations
• Published functional documentation describing changes in business process
• Programmed PL/SQL scripts
• Modified series definitions as need and created new series
• Worked wif client support team who was both on site in USA and remotely in UK.
• Advised customer on a technical sound design that what would turn into a bad business process if realized
• Bounced teh Apache webserver as need to implement changes in Demantra as need.
• Mapped Hierarchies for data import
• Created new data model based on custom staging table and teh custom Hierarchies
• Did multiple training sessions
• Created custom series and worksheet based on business needs
• MD050 document was written for customer interface between Demantra and ASCP as dis was pre-7.1.1 release engagement.
• Custom Support training documents were created