OBJECTIVE:

Business Analyst / Software Engineer / Demantra and ASCP Consultant

SUMMARY:

• A solution focused professional with over 15 years’ experience, including hands - on experience with 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.
• Confidential has 7 years of direct experience with Demantra and other Oracle VCP products.
• Confidential has demonstrated capacity to find root causes and to deliver effective Technology Solutions, including custom programming and functional training. Confidential is a consultative IT Professional who brings both Technical knowledge and an understanding of Business to his customers along with a strong desire to assist his Clients in accomplishing their Technology objectives. Information Technology career demonstrates a proven track record of successfully delivered solutions.
• 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. He can do light to medium level OBIEE configuration for APCC custom dashboard.
• He is extremely technically knowledgeable of Demantra.
• Have provides functional guidance on Oracle production scheduler (PS) Oracle advance supply chain scheduling (ASCP), Advance Planning Command Center (APCC) and Inventory Optimization (IO).
• I have been lead in implementing PS, IO, APCC and ASCP on both a discrete manufacturing environment and an Oracle process manufacturing environment.
• Stabilized data import process from Data warehouse.
• Analyzed existing custom SQL code which moved data into Demantra staging table from the data warehouse. Enable import process to be automated.
• Provided multiple options for increasing worksheet performance and user experience.
• Documented existing integration and technical settings as well as doing an overall solution road map for going forward.
• Successfully completed four post go live task critical.
• These task included modification of series. Changes to integration interfaces, and custom PL/SQL program to remove mistakenly linked combinations.
• Also provide advice and training to Client’s It staff on ways of completing 2 other task.

KEY SKILLS AND KNOWLEDGE:

Industry Knowledge Areas: 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 with 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

ERP Methodology: AIM

Databases: Oracle, Oracle Business Accelerator

Languages: PL/SQL, SQL Server, SQL Plus SQL

Oracle Tools: Demantra Tools, Discoverer, Developer 2000, Bentic

Operating Systems: Unix, SQL Developer, Toad, Supply chain management (Advance Supply chain planning), Windows (XP/2000/NT/98/95), MRP and MPS Planning

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Demantra 7.3.0, Windows server, Oracle 10g, Tomcat, data warehouse

Functional/Technical Lead

Responsibilities:

• 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.
• Trained technical staff on standard best practices.

Confidential

Environment: Demantra 7.2.0, Windows server, Oracle 10g, Tomcat, data warehouse

Functional/Technical Lead

Responsibilities:

• Stabilize a custom data import process and enable the schedule of the process.
• Provide roadmap documentation giving the 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.

Confidential

Environment: Demantra 7.2.0, Windows server, Oracle 10g, Tomcat, data warehouse

Functional/Technical Lead

Responsibilities:

• Stabilize a custom data import process and enable the schedule of the process.
• Provide roadmap documentation giving the 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.

Confidential

Environment: Demantra 7.1 I, Windows server, Oracle 10g, Websphere, JDE

Functional/technical lead

Responsibilities:

• 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 the wrong location
• Adjust current custom PL/SQL load script to combine code and description on certain level members

Confidential

Environment: Demantra 7.1 I, Windows server, Oracle 10g, Websphere JDE

Functional/technical lead

Responsibilities:

• 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, Confidential revamped process reducing the 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 the process,
• Trained Client’s internal Demantra support staff.

Confidential

Environment: Oracle Demantra, Oracle ASCP Rel 12, Linux, Oracle 10g, Oracle ASCP

Solution Architect, Functional lead

Responsibilities:

• Mapped Hierarchies for 3 different product lines then blended them together
• One difficulty of this project was ASCP was being feed by a pure legacy feed and so this was the first time Demantra’s data was coming into ASCP then in Demantra using the Self-service load OAT templates
• Trained subcontracted consulting resources.
• Trained client internal support staff.
• Worked with Oracle Product Development team as this being a leading edge project due to legacy feeds.
• Created custom worksheets and series in attempts to match current business process within a Demantra framework.

Confidential

Environment: Demantra 7.2, Windows, Oracle 10g, JDE

Functional Lead

Responsibilities:

• Did detail mentoring and data checking with 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 the new features of 7.1 over the previous version of Demantra 6.5 discussed with the 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-with” functionality and it’s usefulness to business process from within the worksheet windows for filtering the next worksheet in the business process.