SUMMARY:

• Self - motivated and dynamic professional with 11+ years of expertise in designing and implementing supply chain solutions including Supply Chain Planning, Discrete Manufacturing, Costing and Distribution domains.

• 11+ years of experience as Oracle Solution Architect with successful completion of projects in Process and Application solution designing, Managing and implementing enterprise-wide solutions along with end to end Life-Cycle implementations
• Managed offshore as well onsite teams on project deliverables.
• Passionate about delivering outstanding Business-results through creative combination of Business-Strategy and Technology
• 7+ Years On-Site and 3 Years of Off-Shore Experience in Oracle eBusiness-Suite
• Expertise in implementing supply chain solutions including Supply Chain Planning, Manufacturing and Sales & Distribution domains
• Have worked on Implementation, Up-gradation and Support Projects.
• Involved in implementations of Advanced Supply Chain planning, Costing, Inventory, BOM, OSFM, Purchasing, Order Management, WMS, Receivables, Trading Community Architecture and e-Commerce Gateway modules.
• Proficiency in INV, WIP, WMS, BOM, OSFM, PO, AP, OM interfaces in Oracle 11i and R12 Implementation, Development, Interfaces, Data-Conversions and Customizations, Business-Intelligence (BI and OBIEE) Reports
• Worked on Manufacturing Execution Systems ( Confidential ) and EDI integrations with Oracle EBS
• Experience in Gap Analysis, Module Setup, Business Analysis, Application Design, Conversion and Interface Design, Handling Support requests, System Administration and User training
• Possess excellent interpersonal, communication and organizational skills with proven abilities in team management, customer relationship management and planning.

KEY SKILLS:

• Manufacturing
• Costing
• Planning
• Order Management
• Inventory
• Bill of Materials
• Work in Process
• Purchasing
• Shipping
• WMS
• Sql,Pl/Sql
• Oracle APIs
• BI/XML Reports
• OBIEE

PROFESSIONAL EXPERIENCE:

Confidential, San Diego

Responsibilities:

• Scoping, Requirement gathering, Gap Analysis and Solution Designing
• Extensively worked on B2B integrations with external parties for Manufacturing and Distribution transaction processing
• Designed below Interfaces to process lot transactions using SQL, PL/SQL and APIs
• Lot based Job Starts
• WIP Lot transactions
• WIP Move transactions
• Inventory transactions
• Designed Supply chain solution to meet the planning and operations teams requirements
• Responsible for SCM Module( Master Data, Manufacturing, Purchasing and distribution) configurations, Conversions and System Readiness
• Support for all Manufacturing and Confidential Supplier integration Production issues and enhancement requests
• Used HP Quality center to design test plans
• Coordinated with supply chain, finance, Quality, Engineering teams for project deliverables
• Preparation of test scripts/cases and conducting User Acceptance Testing.
• Preparation Solution design documents.
• Worked with Project management team to define the cutover plan for Production migration
• Post Go-live Support & User Training: Preparation of setup and troubleshooting documents and user manuals.

Confidential

Oracle Techno Functional Lead

Responsibilities:

• Designed custom lot genealogy repository from Oracle tables
• Designed lot tracking system using Oracle Order Management, Shipping and Manufacturing
• Gap Analysis of RMA Orders and helped to define the global process in distribution network
• Worked with development team to extract data for Production lots as well as Engineering lots
• Worked with BI Team to on over all architecture to bring manufacturing data into one central repository.

Confidential

Oracle SCM Techno Functional Lead

Responsibilities:

• Worked with Engineering and Quality team to identify the lot attribute sources to remove dependency on Confidential suppliers
• Worked with Logistics and Sales team to design WMS picking Rules based lot attributes
• Identifying Gaps in existing Lot attribute derivation method
• System Design & Implementation of Lot attributes derivation from raw material to Finished Goods.
• Designed data Conversions to update attributes for existing lots using Inventory APIs
• Designed and developed WIP and Inventory Interfaces to carry and update lot attributes with lot transactions using SQL, PL/SQL, Value sets and APIs

Confidential

Oracle SCM Techno Functional Lead

Responsibilities:

• Mapping the Confidential business model to Confidential model
• System design for data migration( Master data, On-hand qty, Sales orders and purchase orders) from Confidential system
• Designed Electrical wafer sort solution which helped to pay Confidential Suppliers for actual service cost based on sorting method(Partial lot or Full Lot)

Confidential

Oracle SCM Techno Functional Lead

Responsibilities:

• Enhancing the system design to meet new business requirements due to wafer buy model
• Roll out of existing costing solution to new product lines
• Worked with sourcing and finance teams to charge WIP Jobs with actual wafer Probe cost

Confidential

Oracle SCM Techno Functional Lead

Responsibilities:

• Enhancing the system design to meet new business requirements for Confidential
• Worked with Confidential Suppliers to define the data model for B2B transmission through Rosettanet for Manufacturing, Receiving and Shipping transactions
• Involved in enhancements and Implementation of Oracle costing customization and Oracle Shop Floor Management (OSFM)

Confidential

Oracle SCM Techno Functional Lead

Responsibilities:

• Confidential uses Confidential Lot-eDapter and Rosettanet(7B1) to process Supplier WIP Transactions in Oracle Applications.
• Worked with Confidential Suppliers on transaction mapping using Rosettanet standards(7B1)
• Responsible for configurations and System Readiness

Confidential

Oracle Data Migration Architect

Responsibilities:

• Designed and Managed data migration model to bring the data Legacy system to oracle applications
• SCM Modules(Purchasing, Master data, Inventory, Order Management) configurations and System Readiness
• Designed Shipping documents( Pack slip, pick slip, commercial invoice etc..) to meet new business requirements based on EU policy
• Designed and developed data conversions using SQL, PL/SQL and APIs:
• Items
• BOMs and Routings
• Item Costs
• On-Hand
• Supplier and Supplier banks
• Customers
• Purchase Orders
• AP Invoices
• AR Invoices
• Sales Orders
• Designed SEPA file which is very important form of payments in European Zone
• Preparation of test scripts/cases and conducting User Acceptance Testing.
• Preparation of setup and troubleshooting documents and user manuals.

Confidential

Oracle SCM Techno Functional Lead

Responsibilities:

• Worked together with Planning, Engineering and Purchasing teams to Setup new Factory( Confidential De Vernejoul)
• Involved in rollout of Existing solution for new factory which includes enhancements and Implementation of Advance Supply chain planning( Confidential ), Oracle Shop Floor Management (OSFM), Order Management and Warehouse Management Systems (WMS).
• Preparation and Execution of the Project Plan and Cutover Documents
• Responsible for System setups and System Readiness
• Post Go-live Support & User Training: Preparation of Test Cases and Conducting User Acceptance Testing. Supervising End user Training and Documentation

Confidential, Philippines

Oracle SCM Techno Functional Lead

Responsibilities:

• Worked as Onsite SCM Consultant to Implement Oracle Confidential and Intercompany.
• Constrained Confidential Implementation (EDD and ECC).
• Conceptualized and designed Plan Metrics Solution using OBIEE for Master Planner analysis.
• Designed and Developed MDS Upload program using SQL, PL/SQL and APIs to upload demand data into system.
• Designed and developed automation intercompany order creation based on demand from central warehouse
• Responsible for Intercompany transaction flow setups
• Designed intercompany Shipping documents (Pack slip, pick slip, commercial invoice etc..)
• Designed solutions based on discussions with business and worked with users to get them implemented.
• Worked on designing OBIEE answers and dashboards.
• Responsible for Complete Mater-Data setups and data Conversions, Reports & Form-Personalization
• Solution included cleaning up of existing ERP system inclusive of BOMS, Routings, Items, and Categories using SQL, PL/SQL and APIs
• Scoping, Requirement gathering, Gap Analysis & End-User training
• Coordinated and managed Facilitated Functional Testing, Business Functional Testing, Integration Testing and End to End Testing encompassing Planning, Procurement, Manufacturing and Demand Planning.
• Worked closely with Oracle Confidential Development and Support Teams for resolving product issues.
• Developed test plan scenarios to replicate exact business processes.
• Preparation and Execution of the Project Plan and Cutover Documents
• Post Go-live Support & User Training: Preparation of Test Cases and Conducting User Acceptance Testing. Supervising End user Training and Documentation

Confidential

Oracle SCM Techno Functional Consultant

Responsibilities:

• Worked as Offshore Consultant to Implement TCA and Order Management.
• Worked on OBIEE to design the Order management metadata by using AWM
• Worked on designing OBIEE answers and dashboards.

Confidential

Oracle SCM Techno Functional Consultant

Responsibilities:

• Worked as Offshore Consultant to Implement Discrete Manufacturing, Confidential products and Order Management.
• Coordinating with the Onsite Consultants to map the real business processes
• Automated the Shop floor activities on a day to day basis, with zero manual intervention
• Designed and developed Order import Program and shipping documents
• Upgraded Confidential products like TPM, Confidential Routing eDapter, Confidential Lot eDapter and eDapter Tool Kit with Oracle Applications
• Prepared Test Cases and Conducted User Acceptance Testing
• Coordinated with Product development teams to get results as per client requirements.
• Worked for fixing Supplier Integration Issues, Shipping Issues.

Confidential

Oracle Applications Support

Responsibilities:

• Worked as Onsite Consultant in the Up-gradation of Confidential which are used to carry Confidential transactions to Oracle based on INV, BOM, PO, WIP and OSFM setup.
• Designed and Developed solution which will help to pull the data(Lot Transactions) from Factory works system and process into Oracle using Oracle API/Interfaces
• Upgraded Confidential products like Confidential Routing eDapter, Confidential Lot eDapter and eDapter Tool Kit.