Oracle Wms (functional Consultant) Resume
San Dimas, CA
SUMMARY
- Hands on Experience in configuring Supply Chain Management (SCM) modules Inventory, Warehouse Management System (WMS), Purchasing (PO), Order Management (OM), Pricing, Shipping and Manufacturing Modules Bills of Materials (BOM), Planning (MRP).
- Very Well experienced in Order to Cash Flow (O2C) and Procure to Pay (P2P) flow, different fulfillment methods like ATO, ISO, Drop Shipment and Inventory inbound and outbound transactions.
- With Over 18 + yrs. of experience, Murali Natamai has worked as a seasoned Supply chain professional, having core Industry experiences working on the following industries related to their Manufacturing, Logistics, Warehouse and Systems integration.
- Taken training under 12.2 Releases.
TECHNICAL SKILLS
ERP Package SolutionsOracle eBusiness Suite: SCM and Manufacturing Modules
Mobile Page Customization: MWA Express Server
Label Printing Softwares: ClearOrbit, Loftware Label designer
Languages/Web: C, C++, SQL, PL/SQL
Database: Oracle 7.x/8i/9i/10g/11g, SQL Server, MS Access
Design Tools: Oracle Forms and Reports (6i/9i/10g) and Oracle Workflow
Label Design Tools: Zebra Designer for XML, Bartender
Operating Systems: UNIX, Linux, Solaris, HP UIX and Windows XP/Vista/W7
Migration Tools: STATS, ITG
Other Tools: Service Now, Workflow, TOAD/SQL Navigator, MS Office, SVN GxP Compliance Tools • GDocs, GTrack
PROFESSIONAL EXPERIENCE
Confidential,San Dimas, CAOracle WMS (Functional Consultant)
Oracle Apps Modules: WMS, INV, OM, PO
Responsibilities:
- Set up the WMS system under Oracle to comply with the new warehouse facility.
- New system to have flexibility to handle high / low value items along with other categories.
- Configured two of the inventory organizations for shipping capability along with integration with Boundary applications for shipping manifesting.
- Configure new product pricelist, customer specific qualifiers.
- Meet GxP compliance for all deliverables and complete Validation of the system.
Oracle WMS (Techno Functional Solution Architect)
Oracle Apps Modules: WMS, INV, OM, PO, eAM.
Responsibilities:
- Technical Architecture in the Process flow POC, finalizing the flow for their Warehouse management.
- Developed component to meet their Technical challenges on new customization.
- Ongoing process improvements for Warehouse integration with Other legacy systems.
Oracle WMS, 3PL, Logistics Business Analyst
Release: Oracle Applications R12 (12.1.3) ; 11.5.10.2
Oracle Apps Modules : WMS, INV, BOM, OM, QP, PO, ENG, TRANSPORTATION, XML Gateway.
Responsibilities:
- WMS / 3PL Continuous Process improvement in the Warehouse management area.
- Gap analysis of Business requirements and changes.
- Ongoing process improvements / implement for Purchaing, Order Management and TPL (Third party logistics).
- Resolving production support issues (Supply chain modules).
- Drive /Monitor Month end, Year end INV close activities.
Oracle SCM Consultant
Oracle Apps Modules : INV, BOM, OM, QP, PO, MRP, ENG, ITM
Responsibilities:
- Gap analysis of Business requirements and changes.
- Prepare Functional / Technical specifications on new customizations.
- Resolving production support issues (Supply chain modules).
- Monitor Month end close activities.
Oracle Applications Oracle Consultant (SCM)
Environment: Oracle Applications (11.5.9) Developer 6I (Report 6i, Forms 6i), Workflow 2.6, Discoverer 4i, 9i.
Oracle Apps Modules : INV, MSCA, BOM, OM, QP, PO
Project Name: Oracle Applications Consolidation
- Confidential Confidential ., Inc. is a leading product manufacturer in the fields of Copiers, photographic equipments.
- This division of Confidential Confidential ., Inc.is the distribution and service unit for the Copier machines.
- This project is on the consolidation of 3 different regions (EAST, CENTRAL, WEST) within Confidential to one single regions. (multi org to single)
Oracle SCM Consultant
Environment: Oracle Applications (10.7, 11.5.10) Developer 6I (Report 6i, Forms 6i),UNIX Shell Scripts
Oracle Apps Modules : INV, OM.
Responsibilities:
- As a Functional Consultant, have designed conversion process for Item master, Bundling, Copy Sales Order with ship set functionality.
- Reviewing and approving the Functional, Design and Unit test documents.
Sr. Oracle Techno Functional Expertise,
Technology Environment: Oracle Applications (11.5.3, 11.5.9) Oracle 8I (SQL Plus 8.0, PL/SQL 8.0, SQL Loader 8.0),Developer 6I (Report 6i, Forms 6i),UNIX Shell Scripts
Oracle Apps Modules : WMS, INV, BOM, WIP, MRP, OM, QP, PO, QA
Responsibilities:
- As an Onsite coordinator to coordinate with the offshore team for sizing and scheduling, interact with end users and offshore team, participate in meeting with customers as needed, meet SLA’s for issue resolution, provide guidance to the offshore team for issue resolution.
- Reviewing and approving the enhancement estimates and project deliverables - Functional Specification, Technical Design Document, Unit Test Plan, User Manual and Source Code from the development team.
- Suggesting and executing configuration changes as and when needed which is acceptable by the business and does not affect the business.
- Regression testing and issue resolution as a result of new configuration / Code changes going into production.
- Handling Critical and High severity support requests and worked as initial point of contact for business and end users.
- Coordinating with the off-shore team(Caritor India) for development requirements
- Training and assisting user groups.
- Achieving stability in specific modules by effective scheduling and execution of activities.
- Ensuring proper process documentations throughout the project life cycle for all offshore developments.
- Supporting the functional team during User Acceptance Testing (UAT). Performing integration testing and reviewing the unit test results from offshore team.
- Monitoring and trouble shooting of daily run processors. (MRP, ATP, Min-Max)
- Improving the performance of processors as a routine maintenance activity.
- Carry root cause analysis on issues and provide solutions.
Technical member
- Configured rules, strategies as per the business logic.
- Configured printers, label formats under ClearOrbit application for xml data processing and Barcode label printing.
- Developed Barcode labels using Bartender Software.
- Developed scripts to prioritize the tasks with rules defined by Business criteria.
- Developed new SO Drop reports using Oracle reports 6i, which details the contents of an LPN when they are dropped.
- Developed alert mechanism for troubleshooting LABEL process.
- Mass data changes and cleanups to meet the installation requirements for WMS.
Oracle Applications Oracle Consultant (SCM)
Technology Environment: Oracle Applications (11.5.3, 11.5.8) Oracle 8I (SQL Plus 8.0, PL/SQL 8.0, SQL Loader 8.0),Developer 6I (Report 6i, Forms 6i),UNIX Shell Scripts
Orcle Apps Modules : INV, BOM, WIP, OM, QP, PO
Responsibilities:
- Performed the role of on-site SA in resolving issues.
- Carried out impact Analysis, coding & unit testing for forms, reports under OM, Purchasing, WIP, MFG.
- Impact Analysis, code modifications and testing of AutoSys Jobs.
Confidential,Boston
Oracle Applications Oracle Consultant (SCM)
Technology Environment: Oracle Applications (11I, 10.7) Oracle 8i(SQL Plus 8.0, PL/SQL 8.0, SQL Loader 8.0),Developer 6I (Report 11I, 10.7),UNIX Shell Scripts
Oracle Apps Modules : INV, BOM, PO
Responsibilities:
- System Analysis, Programming, Unit testing, Integration testing, User acceptance, Onsite Implementation and co-ordination
Oracle Applications Oracle Technical Lead (SCM)
Technology Environment: Oracle Apps 11I,Developer 6i (Forms 6i, Reports 6i),Oracle 8.0(SQL Plus 8.0, PL/SQL 8.0, SQL Loader 8.0),UNIX Shell Scripts
Apps Modules : INV, BOM
Responsibilities:
- Design, Coding, and Testing
Oracle Technical Lead (SCM)
Technology Environment: IBM AIX 4.3 with Oracle 8.1.6, Shell Script and Win-NT
Apps Modules : INV, BOM, MRP, OM
Responsibility:
- Design, Coding, and Testing
Confidential, NY
DB Migration Technical Lead
Technology Environment: IBM AIX 4.3 with Oracle 8.1.6, Shell Script and Win-NT
Responsibility:
Design, Coding, Testing, On-site implementation.
Confidential
Team Leader
Technology Environment: Visual Basic 6,Oracle 8, MTS, Crystal Reports 7.
Responsibility:
- Lead a team of Five persons.
- Involved in the preparation of Design Document, Prototype.
- Identify components for Business logic.
Visual Basic Programmer
Technology Environment: C, VB 5, Crystal Reports 4.6, Sybase 11.5.1, UNIX.
Responsibility:
- Play the role as a on-site developer to meet clients customization needs.
Developer
Technology Environment: Oracle 7.3, MS - Access, Visual Basic 6, Crystal Reports.
- To provide an end solution which will automate the risk management process and facilitate the achievement of the Business objectives.
- To use technology as a business enabler.
- To interface well with other legacy systems, receive and forward data with these systems in a transparent manner.
Developer
Technology Environment: Oracle 8, Visual Basic 6, Crystal Reports
- The package is developed using ADO method with ActiveX component for control processes thereby minimizing the package size to some extend. This package is basically developed to indent/issue materials that are used in different departments of a particular organization. It is a generalized package with which an
- The different forms in this package are Indent form,Purchase Order form, Receipt form, Issue form etc. Also facility for Quality acceptance form is available.
- The different reports generated in this package are :
- · The rate at which a batch of process has taken place could be generated.
- · The list of different materials issued between specified dates also with respect to a particular department.
- · The list of pending orders, receipts
- · The list of vendors available for a particular material
Confidential
Programmer Analyst
Technology Environment: Oracle 8, Forms 5, Reports 3
Material Management and transaction Control
- As a team leader / programmer analyst involved in developing a package for the transaction control of orders, materials for a shoe manufacturing concern. It mainly involved following forms :-
- · material requirement form used for the calculation of raw material required in processing the order.
- · Purchase order, goods inward entry, goods despatch, material flow, package details.
- · Also transaction w.r.t the sub-contractors are entered through a separate form.
- · Data bases of all vendor, customer, sub-contractors are available. Also a search tool is available to search for a particular category of a vendor/customer.
- The reports generated are:-
- · Bill of materials list, also pending order list.
- · Purchase order report. Goods receipt(in stock) details.
- · Package details. Delivery Chellan report. Despatch details.
Lead Developer
Technology Environment: Ms Access, Visual Basic 5.0, Crystal Reports
Project Name: Production & Stock Management System
- This Project Deals with the Placement and maintaining of Orders in Leather Industry.
- Also for Packing and supplying of Finished Goods Ordered by Various Customers as well as to Maintain their accounts.
- This project is coded with DAO (Data Access Objects 3.5) and CrystalReports as the Reporting tool.
Confidential
Programmer
Technology Environment: Oracle 7.3, Forms 4.5, Reports 2.5
- As a Programmer analyst involved in the development of an Inventory Control System(ICS).
- The functions of the system include purchase management, stores management and materials planning.
- The system helps to maintain item master, price master and vendor master.
- It facilitates QC approvals, stock adjustments, purchase inquiries, vendor quotations, material issues and returns, price revisions and purchase order amendments.
- The important reports of the system include purchase order, material receipt note, material rejection note, approved and non-approved vendors. Involved in development of master maintenance, all transactions related to stores management, testing The System takes care of Bill of Materials, Material requirement planning and processing of target based orders.
- The reports of the system include order execution status, orderwise/productwise raw material requirement, order/gradewise pending order list, etc..
Confidential
Catalogue Information system
Technology Environment: Oracle 7.3, Forms 4.5
- As a Programmer involved in the development of Catalogue Information System(CIS). The functions of the system include Database for storing the catalogue information category wise, product wise and vendor wise.
- The system facilitates in selection of a product with information about their sources, their latest prices, recently utilized project details and the vendor to which the company is satisfied with.
- Also informations about Black listed vendors, the reasons behind it, the percentage of vendor to customer co-operation are listed for each product.