SUMMARY:

• Over 10+ years of total experience, out of which 9 years in Oracle ERP Applications and around 1+ year’s in R&D / Manufacturing Industry.
• Expertise in Oracle Discrete Manufacturing modules with excellent functional experience in Implementation, Upgrade, Enhancement, Testing, Production Support, Customization of Business Applications, Conversion, User, Analyzing Business requirements and writing functional design specifications.
• Functional expertise in Oracle Applications (11i & R12) modules such as Oracle Quality (QA), Oracle Inventory, Inventory Control processes, Oracle Bills of Materials (BOM), Oracle Engineering, Oracle work in Process (WIP. Very good experience with Oracle Purchasing (PO), Order Management (OM), Shipping (WSH), Cost Management (CST) & System administration (FND / AOL)
• Excellent SEV - 1 troubleshooting expertise and Discrete Manufacturing modules with the issues that span into different modules.
• Excellent experience with all the advanced & basic functions like the following and more.

TECHNICAL SKILLS:

ERP Software: Oracle Application 11i & R12 e-Business Suite

Supply Chain & Manufacturing: Oracle Purchasing, iProcurement, Sourcing, iSupplier, Order Management/Shipping, Oracle Configurator, Oracle Inventory, Advance Pricing, Bill of Material, Work in Progress, Engineering, Costing, Material Requirements Planning, Advance Supply Chain Planning, Warehouse Management System & Supplier Scheduling.

AOL: System Administration, Application Developer, Oracle Alerts, and Oracle Workflow Admin.

ERP Methodology: AIM

Oracle Applications: Versions R12/11i (11.5.10/11.5.9/11.5.8 ).

Databases: Oracle RDBMS (Oracle 10g/9i/8i/8/7).

Utility tools: Toad, SQL Developer.

Programming Languages: SQL, PL/SQL

Hardware/OS: Linux, Sun Solaris 5.5, Windows.

Project Management Tools: Microsoft Projects, MS Office & Microsoft Visio.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Global Manufacturing/SCM Functional Consultant

Responsibilities:

• Manufacturing solution implementation to capture Build to Stock consigned inventory consumption. Integrating Routing, Inventory, Bill of Material Modules.
• API Designs from Costing ERP System (X1 - Oracle ERP System) into Oracle Operations system CG1.
• Integration of Oracle OM Module into Cisco’s front end Order capturing tool - CCW.
• MRP, ASCP capabilities enchantment for a better Promise date calculations.
• Perform UAT Testing with partners and support necessarily on Partner System Enchantments.
• Support Production Issues for ongoing Transition phase of IT systems.
• Work with implementation team members to develop best practice. Methodologies, setup Oracle parameters to support the decisions
• Provide solutions and map the business requirements with using Oracle Applications ERP Supply chain/ Procurement, Order Management, Flow Manufacturing modules.
• Conduct and lead the Integration testing/Unit testing/User acceptance testing to meet the business requirements for Cisco BTS Products.
• Work with technical team and provide functional Knowledge transfer for BTS Business Process.
• Utilize Existing BTS Solution to handle Re-Manufactured (Refurbished Products) bringing uniformity across.
• Troubleshoot questions/problems from the user community with Oracle Application issues.
• Assist with the installation of new Oracle Organization unit to existing test and production systems.
• Test migrated data form legacy systems into current database and troubleshoots issues.
• Refine and improve the business requirements in the oracle Modules like purchasing, Flow Manufacturing, Order Management.

Confidential

Lead Support consultant

Responsibilities:

• Handled OSP related issues, by creating support documents and thus minimizing the issues related to OSP job creating and receiving.
• Pointing out the discrepancies in the bills of material which helped correct the resource hours and utilizing the PHANTOM operations more efficiently.
• Handled Backflush related issues in both discrete manufacturing and flow manufacturing.
• Issues related to consignment inventory, definition, consumption.
• Utilizing alternate routings for in house and OSP manufacturing of the same Items.
• Helped in cost roll up for the present year.

Confidential

Lead Consultant

Responsibilities:

• Utilizing the two segments of item in differentiating the same product into different package codes. And
• Utilizing the WIP Accounting classes in helping achieving a higher accountability in the Manufacturing process.
• Interfacing the Bills Of Material from Legacy system to Oracle
• Setting up Required setups for making a data conversion in a CRP instance.
• Functional Documents for the interfaces and the setup on the CRP.
• Worked with shop floor super users to identify and define Departments, Resources, Operations and Routings for BOM items
• Handled Lot controlled items with material control at lot level.

Confidential

Lead Consultant

Responsibilities:

• Developed global solution design for all the manufacturing brands and interacted with huge user group with multi dimensional business requirements
• Developed simplified innovative solutions for complex business process to eliminate waste in resources
• Configuring the application based on solution design, performed gap analysis and designed workaround solutions the client’s super users and users on the application and conducting pilot testing, integrated testing, design validation.
• Functional documentation for Configurations (Setups), User Documents and Customization Documents. Experience in the preparation of Standard Operating Procedures specific to Client’s business process with screen prints
• Conducted CRP, SIT, UAT & PREPROD sessions for the site additions and cutover was successfully completed for multiple sites.
• Handled RICE objects for manufacturing modules and wrote several functional specification documents.
• Worked with the project team in setup and configuration of Quality INV, BOM, WIP and WSH
• Created setup documentation for Inventory (INV), Bill of materials (BOM), Work in Process (WIP), Engineering and Cost Management
• Developed Model / CTO Bills for configurator usage and interacted with development team for all customizations.

Confidential, Plainville, CT

Lead Consultant

Responsibilities:

• Understanding and Gathering the requirement from business super users and document the same in Business requirement & analyzing the Gaps. Responsible for Customizations.
• Worked with the project team in setup and configuration of INV, BOM, WIP, and WMS
• Identified the process and mapped the business requirements with process flow charts and setup documents
• Performed a GAP analysis for the existing system to recommend improvements and customizations
• Created Inventory Orgs, Item Master, Item Categories and Catalogs, Sub inventories and stock locators
• Created setup documentation for Inventory, Bill of materials, Work in Process, Engineering and Cost
• Worked with shop floor super users to identify and define Departments, Resources, Operations and Routings for BOM items
• Identified the process and mapped the business requirements with process flow charts and setup documents
• Implementation of synchronized supply chain operations to have small investments in inventory. Synchronized Supply chain operations with every trading partner to operate under a new set of rules, to maximize profits.
• Performed a GAP analysis for the existing system to recommend improvements and customizations
• Created Inventory Orgs, Item Master, Item Categories and Catalogs, Sub inventories and stock locators
• Created setup documentation for Inventory, Bill of materials, Work in Process, Engineering and Cost
• Worked with shop floor super users to identify and define Departments, Resources, Operations and Routings for BOM items
• Prepare site specific test script. Perform complete cycle testing during the implementation life cycle
• Evaluate, recommend approaches and implement which type of Configurator to use for each family of products to minimize ECO work load and reduce future maintenances
• Provided production support for those divisions, which have implemented Oracle and supported implementation initiatives of new divisions.
• Provided solutions to all the business requirements and set up the same in the system and help the business users to understand the system and also involved in conducting CRP.
• Developed all new 2-Step ship confirm process to meet the Planning business requirement.
• Developed Custom Solution for Scheduling, WO (Discrete Job) Creation, TRIP Creation, Doing a Dummy ship confirm even before releasing the SO (Sales Order) because of Business requirements for Material Planning
• Customized Load Out, Load IN, Ship Confirm Process Using LPN (WMS) environment.
• Worked in full CTO, PTO, ATO environments to meet the business requirement
• Custom Back-to-Back process for a ATO item to meet the business requirement
• Developed Auto-reservation solution Design to meet the Business requirement

Confidential, Salt Lake City, UT

Lead Consultant (BOM / WIP / Quality- QA / CST)

Responsibilities:

• Involved in setting up meetings with Business user to gather Requirements.
• Gap and Fit analysis done based on the business requirements.
• Functional Consultant for Material Requirement Planning, Bill of Material, Work in progress, Quality and Costing modules.
• Migrated successfully from MRP to ASCP globally in 2008
• Focused on Inventory and BOM, providing alternate solutions, Set-up of modules with user data using Data loader, Collected Requirement and Prepared Functional Requirement document (BR100) for BOM and Inventory Modules. Designed and implemented Item Status, Item Attribute Control, Item DFF, Item templates, Serial Control, Subinventory, Locators, Planners, Min-max planning, Cycle Counting, Item Attachments, Shipping Network, UOM Conversion, BOM Parameters, PTO Bills of materials and Manufacturing Calendar. Setup Application Users, Menu, Responsibility and Many form Personalization. Coordinated and guided the off shore team for development of Item, Category, UOM and BOM Conversion and Interface programs, Resolution of pending transactions and open material transactions interface.
• Conversion plan for Model, Option, Planning, Standard Bills to meet Configurator business rules.
• Implemented CTP and ATP using GATP, based on PDS data.
• Worked extensive on Data collections. Scheduled the plan on data collections with complete refresh, targeted refresh and net change.
• Implemented complex ATO/PTO models in Order configuration.
• Implemented the pick sources using the global sourcing rules.
• Implemented the transit time calculation using internal locations, regions and zones.
• Successfully implemented complex shipping with Trips/ Container and BOL.
• Providing (Multi country / Multi Currency) supports for day-to-day Sales activities related to Drop Ship Orders, Demo Orders, Bill Only Orders, Internal Orders, RMA Orders and Back-to-Back Order.
• Involved in the Creation of test script documents for CRP and UAT.
• Providing functional inputs to coordinate between client and Technical consultants related to application issues.
• Successfully completed 2 CRP’s and 1 UAT. Production support and user .
• Captured the business processes in form of scenario matrix for testing various process alternatives followed as part of Bill of Material/Work in Progress/Costing/Quality and Planning.
• Involved in setting up Out-Side processing flow.
• Involved in setting up Cost types, Future, Engineering and additional Cost types, Defined material sub-elements, Defined Overheads, Material overhead defaults, Defined Category accounts, Associate WIP account class with Category accounts.
• Involved in importing of item cost from legacy system.
• Also involved with many Purchasing setups and Order Management interface designs. Setup Payment Terms, PO Lookups, Purchasing Options, Buyers, Financial Options, Transaction Reasons, Receiving Options, Suppliers, Sourcing Rule, Position Hierarchies and Employees.

Confidential

Oracle Manufacturing - Lead Consultant

Responsibilities:

• Documented the business requirements and identified the gaps
• Analyzed the existing business and system environment and mapped the future environment
• Configured OPM system to have Control of continuous or near-continuous manufacturing processes involving flexible formulas and recipes
• Quality management (Collection plans, custom elements) setups in an environment of increasing cost sensitivity
• Integrated tracking of raw materials, by-products and co-products, and finished goods with Multi-dimensional end product and inventory control
• Flexible scheduling & with Integrated quality assurance (QA) and quality control (QC) management
• Carried out system design for customizations, interfaces and extensions
• Flex fields, Organization structure, Master Org, Sub inventories, Stock locators, Picking rules, Forecast rules, Item attribute controls, Item conversion
• Plant & Lab setup, Categories, Customer Items, Item controls setup, Lot/sub lot, lot statuses, reorder rules for Planning, Grades, Grade status, Transaction types, Formulas (Products, By-Products, Ingredients), Recipes (Recipe Designer, Plant/Lab specific, steps), Technical parameters, Technical Data, Item substitution setups etc.
• The Picking Rules engine setup for the appropriate input parameters like Batch, Product, Ingredient, and Material Requirement Date for reservation suggestions that indicate the lots from which the material can be picked
• Batches, Batch workbench, Ingredient picking, batch operations / steps, Process execution parameters.
• High and low level Reservations & worked on the users on recipe designer.
• Recipe/formulation management, Co-product and by-product management
• Multi-dimensional item tracking and traceability
• Packaging/containerization, Storage and shelf life & Lots

Confidential, Pittsburgh, PA

Functional Consultant

Responsibilities:

• Completed an upgrade of Oracle Application 11.5.10.using AIM project management methodology.
• Captured the business processes in form of scenario matrix for testing various process alternatives followed as part of order management/shipping/Purchasing/Inventory.
• Designed and tested various test business case scenarios, unit testing and integration testing for various business flows.
• Validated Setup steps for Inventory like Inventory Organizations, Source Types, Item Templates, Category Sets, UOM, Classes and Conversions.
• Involved in the design of the Labels for the client for the inbound and outbound activities
• Involved in Assigning tasks to pickers, according to various business practices in UAT Server.
• Enabled the system to allocate material for picking (directed picking) by using Picking Rule.
• Enabled the system to suggest the label format and information content that are used to print a given label (compliance labeling).
• Developed process for weekly global supplier audit review on new/updated suppliers and sites
• Express Receipts disabled in Receiving for all orgs to meet the quality requirement
• Cycle Count report improvements - sort sequence, added planner code and location
• Improved logic on Open PO Summary Report regarding unapproved and cancelled PO’s
• Discrete Job Routing Sheet customization to get all the information in one place.
• Custom query to show item sourcing and ASL setup, to enable users to debug issues related to it
• Setup Kanban Pull Sequences, (Supplier & inter-org) and expense item setups. Customization to identify Kanban spikes
• Supplier Load into oracle, sourcing rules, supplier categories, sourcing assignments defined
• Communicating forecasted demand to suppliers with a customized report & process
• Miscellaneous Transactions, orphan supply/demand, WO variance Alerts developed.
• Open Internal Requisition query customization users on using the standard global process for supplier returns

Confidential

Responsibilities:

• Worked as a R&D Release engineer to co-ornate Engineering changes to Production shop, Tool room, Receiving, Inspection. I was involved in meeting Production planning department, Capital purchase, Quality, Manufacturing, Tool Room & Marketing departments. Major responsibility is to get the Engineering changes communicated to various departments getting approvals & releasing them to Production. Troubleshooting logistic issues involving various departments like production /planning / Marketing / Stores. Visiting Vendors to make sure the changes are acceptable to Big suppliers and meeting Supplier Agents.