Functional Consultant Resume
SUMMARY:
- 18+Years of extensive experience with Documentation, Solution design, presentation and delivery. Business Process analysis and validation; Fit Gap Analysis, as - is and to-be documentation and Oracle EBS Mapping.
- Successful hands on implementation, upgrade, and support experience in Oracle Order Management, Advanced Pricing, WMS, MSCA, Inventory, Purchasing, OTM, Costing, WIP, BOM and Oracle Discrete & Process Manufacturing.
- Hands on experience with R12 and R11i Implementation, Upgrade and Support of Oracle Applications financial and supply chain modules.
- Extensive experience in Requirement gathering, Solution design, Setup configuration, Testing, Data Migration, Documentation, Period End closing, consolidation and Post Implementation Production support.
- Experience in system admin activities like creation and maintenance of users, creating responsibilities, etc.
- Worked on Customization and Development Reports under Oracle Apps
- Oracle Applications System Implementation, Specializing In Manufacturing & WMS Modules
- Involved in all phases of implementation from Business Requirements Gathering, To Be Process Design, Gap Fit Analysis, Data Conversion, Validation, Conference Room Pilot, Super User, Documentation and Post Implementation Support.
- Functional expertise in Oracle E-Business Suite Implementation, development, Post-implementation Support, Maintenance and
- Collaborative team player with strong skills in Listening, Communication, Solution Presentation, Solution Design, Delivery Coordination and Documentation.
- Set appropriate stakeholders expectations; meet and exceed through accurate and timely deliverables and reporting.
- Experienced in creating Business-IT baseline; bringing both business and IT to a common and current reflection of operating environment within the scope of participating endeavor to gain consensus, qualify objectives and define requirements - minimize scope creep.
- Good knowledge and understanding of general accounting principles “GAAP”.
- Competent in understanding the functionality of the core Oracle Financial modules and their interplay in the overall accounting structure of an organization.
- Developed business process flows, identified risk points and suggested risk mitigating control measures.
- A strong team player, and adaptable to a variety of roles. Also possess the ability to analyze situations and offer innovative cost effective solutions.
- Experience with Onsite and Offshore delivery model.
- Excellent communication and presentation skills
SKILLS HIGHLIGHT:
Functional: Business Requirements Analysis, Gap Analysis, Process mapping and Oracle Applications functional setup
ERP: Oracle Financials and Supply chain (R12 and R11i)
Modules: Order Management, Inventory, Shipping, WMS, Advance Pricing, TCA, Quoting, Order ManagementPurchasing, i-Procurement, i-Supplier, AR,AP, GL
Process Flows: Order-to-Cash, Procure-to-Pay, Discrete Manufacturing, Process Manufacturing, WMS
Modules: Oracle Order Management, Quoting, Advanced Pricing, WMS, MSCA, Inventory, Shipping ExecutionPurchasing, BOM, WIP, Quality, iProcurement, iSupplier, OTM, Costing, Discrete & OPM
Other Software: Good understanding of MS-Office tools, Toad using SQL
PROFESSIONAL EXPERIENCE:
Confidential
Functional Consultant
Responsibilities:
- Preparing business test scripts with the business rules associated with it to test the data integrity of archived data.
- Performed setups for OM, Advance Pricing, Shipping, PO and INV modules.
- Worked with the Business team to baseline the ‘As Is’ Process and derive ‘To Be’ flow.
- Pricing Business Requirement Study and designed/documented Functional Specification.
- Worked on the setups of the TCA - Defined Parties, Accounts, Party Sites, Account Sites, Contacts, Contact Points, Relationships (Reciprocal and Non-Reciprocal)
- Designed and Developed the Test Plan for testing of the System as wells as testing of the entire bolt on modules and custom RICEW components.
- Set up Transaction Types, Applying & Releasing Holds, Credit Checking
- Set up Advanced Pricing, Price List, Pricing Agreements, and Pricing Attributes
- Defining Modifiers, Qualifiers, GSA Price List, Pricing Formula
- Defining Standard, Internal, RMA and Drop Shipment Orders
- Define Pick Release, Pick Release rules, Shipping Parameters
- Facilitated Pricing & IT Business to obtain clarity on the Business Rules and capture the same.
- Providing Post Implementation support
- Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
- Assisted Business for Business Acceptance Testing and obtain Sign off.
Confidential
SMEResponsibilities:
- Prepare Gap analysis, Development requirement, Prototype, test and implement the Warehouse Management System (WMS) as an Integrated WMS.
- Design/Implemented various Oracle WMS features Inbound/Outbound/Warehousing functionalities using Picking/Put-away Rules with different types of locators and zones, Move Order within Oracle with complex requirement at 4 different sites in US while working directly with client throughout the project on presenting various solutions via conference room pilots and discussions.
- Instrumental in conducting design workshops to perform fit-gap analysis to determine vanilla verses custom solutions to fulfill business requirements thus enabling solution design, determine configurations, understand different testing cycles and user that'll be eventually needed.
- Design/Implemented Automated Allocation to Batches, Sales Order and Material Transfers within and across warehouse in GMP controlled environment requiring using the Oracle WMS Rules Engine
- Setup and Design 3PL Warehouses and their Logistic Operations via Oracle TCA Customer Setups.
- Define Buyer, Limit to buyer Approval Group, Approval assignment and Document type.
- Worked on implementing ALL WMS LPN transactions which included merging, splitting, Loading, un-Loading, Multi-Level Nesting and Re-using LPNs.
- Prepare document for Procure to Pay including creating PO, Approval routing and approve PO, Receive PO, Enter invoices, match with PO 3-way matching, Validate invoices and issue payment
- Implemented Inventory Lot Translate for Downgrades.
- Set up Cycle/Physical Counts for 23 different Orgs including 3PLs.
- Designed Strategies to print labels for Pallets/Totes
- Implemented Oracle WMS Advanced features for system driven automatic replenishment such as Push/Pull Replenishments and Wave Picking strategies.
- Designed improved processes for Mobile Execution in Real time for logistics and manufacturing transactions using Intellinum.
- Implemented NEW Inventory Organization Structures as per client requirements for WMS and non- WMS enabled organization
- Implement and Go-Live Support for the SCM/WMS track
- As a functional consultant provided first line of Implementation support and on WMS, Inventory, Purchasing, Order Management, Advanced Pricing Modules
Confidential
SMEResponsibilities:
- Worked directly with client throughout project on various solution, presentations and discussions
- Conducted design workshop, fit-gap analysis, solution design, configuration, different testing cycles and user
- Designed and implemented automated put away process for warehouse with many different types of locators and zone
- Contributed in design for 3PL and Contract Manufacturing operations
- Designed improved execution processes and mobile execution for real time manufacturing transactions
- Implemented MSCA for WMS and non- WMS enabled organization
- Inventory organization restructure
- Designed and implemented automated allocation to batches, sales order and transfer within and across warehouse in GMP controlled environment with complex requirement
- Integration of Oracle PDH with Oracle EBS for items master and quality constraint attributes
- Improved overall supply chain and manufacturing process by consolidating various paper based processes.
- Implemented system driven automatic replenishment
- Worked on designing Excel based tools to assist in warehouse and manufacturing operations
- Support client to set up new customer with Bill-To and Ship-To Location and assign relation to parent customer.
- Support client to set up new customer with Bill-To and Ship-To Location and assign relation to parent customer.
- Supporting creating price list and attached to customer.
- Set up new freight term for shipping order.
- Grant roll to shipping user as per requirement.
- Prepare process document for creating Sales Order, Booked Order, Release order, pick order and ship confirm order.
- Set up new item with primary, secondary unit of measure, apply conversion and all necessary set up and assign cost and run update cost process.
- Set up new inventory location and map with shipping rules and warehouse.
- Designed and implemented WMS with complex requirement at 4 different sites in US and Europe
- Implement and Go-Live Support for the WMS track
Confidential, North Olmsted, OH
SMEResponsibilities:
- SME architecting and formulating detailed process flows related to Manufacturing, Pick/Pack/Ship - Commercial Customer shipments, House Hold Shipments, Dealer Shipments, SHOW Shipments, - Receiving and Repair flows around Confidential ’s ‘Return for Repair’, ‘Return For Replace’ and Refresh policies
- Implement custom design around Oracle OM/INV/Shipping/WMS modules to facilitate Allocation of Bulk Pick for Household Orders to facilitate faster picking on the WH floor.
- Implement design for Directed Picking and Put-away based on Department/Resource, Task Type Assignment, FIFO rules and Customer LPN Size Requirements.
- Implement Physical Warehouse Configurations related to Forward Pick Locations (FPL), Case Pick Locations, Bulk Pick Locations, Reserve Locations, Packing and Staging Locations based on ABC Analysis and by-item analysis of average pick quantities per item/order movement.
- Implemented the Inventory, Purchasing and Order Management modules.
- Defined different Inventory organizations as per the company’s requirement.
- Completed required setups for the Inventory, Purchasing, Order Management and WMS modules.
- Defined transaction types for order processing such as standard order, RMA - Credit Only and RMA - Credit after receipt.
- Assigned document sequences for each of the transaction types.
- Defined Item categories, Inter-Org transfer, Freight Carriers. Sub-inventories and organization parameters.
- Defined approval limits for purchasing approvals as required by the company.
- Implement WMS Push/Pull Replenishment to manage on-time and on-demand material availability.
- Implement Physical Inventory and Cycle Count to Reduce Inventory Inaccuracies.
- Implement IR/ISO to move material to Consigned Orgs related to Consigned Org functionality (SHOWS business model)
- Implement Inter-Org transfer to facilitate material transfer among warehouses.
- Implement Pick Wave templates to facilitate Sales Order Picking
- Implement Packing Work bench to facilitate SSCC LPNs for EDI Orders.
- Implement custom functionality around Staging Move feature to facilitate tracking of time/labor for activities involved.
- Conduct CRPs with Business Users before Production Rollout.
- Create BP80, BR100, and MD50’s related to designs.
- Develop documentation and trained users for newly developed processes and Rollouts.
- Preparing BR100, MD050, TE40, TE50, CRP execution, User and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
- Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
Confidential, Plano, TX
SMEResponsibilities:
- Managed the entire project from requirements analysis phase to post Production support
- Managing a team of 5 off-shore and 3 on-site resources
- Understanding current business processes and determining the scope of the Integration
- Managing project schedule and deliverables such as BR100, BP80, MD50, TE40, CV40, CV10
- Responsible for planning resource requirements and managing off-shore and on-site resources
- Understanding the customizations and providing optimal solutions per business needs
- Responsible for providing solutions and coordinating data migration activities
- Responsible for planning and tracking activities for SIT, UAT and Go Live
- Responsible for Purchasing, Inventory, Order Management, BOM and WIP modules
- Responsible for providing guidance on approval Hierarchies for POs and Requisitions
- Maintained customer and supplier master.
- Loaded the bin locations and created combinations for setting each item as default for individual bin locations.
- Provided a workaround for UPC codes and Tariff codes required by the client.
- Defined Shipping Parameters and document sets for Pick Release and Ship Confirm.
- Defined jobs, employees and buyers.
- Created shipping document sets, price lists and modifiers.
- Helped in data mapping and data conversions.
- Conducted CRP and sessions with key users
- Managing process review sessions with stake holders across globally spread departments
- Setup Oracle Quoting flow and Advanced Pricing parameters to meet the business requirements
- Provide Post Production support to REFTEK users for Manufacturing, O2C and P2P issues
Confidential, San Jose, CA
SME
Responsibilities:
- Designing Shop Floor Management processes for Repair related processes.
- Contributed to designs around Oracle OM/INV/Shipping/WMS modules related to Allocation Orders for customer Shipments.
- Designing to-be functional solutions to map Repair Supplier activities around Repairing, Replacing, Picking, Packing, Shipping, Internal Return/Repair Site Transfers, Outbound shipment to Customers, NPI Item setups, Supplier Onboarding related to Organization Setups, Sub-inventory and Locator Setups, Repair Plant Setups, Repair Forecasting/Planning, Seed inventory for Replacements
- B2B Integrations with Repair Suppliersvia3B2, 4B2, 7B5, 7B1, 3B11 and 3B13 messaging protocols
- UAT testing of Repair Supplier Web Portal/SFM Implementation
- Defined the Approval Hierarchies, Document Security, Streamlined the Receiving process, Setup the Matching Process in Purchasing module
- Defined the Accounting Rules and Invoicing Rules in Oracle AR module to drive deferred revenue as well as upfront revenue.
- Worked with end users to document the business processes & functional requirements also providing them with materials
- Coordinated activities with Implementation team on creating test plans & documents, conduct unit testing, correcting bugs and re-testing while meeting project deadlines. Facilitated discussions with end-users / managers to gather functional requirements.
- Coordinated with client through Conference calls and WEBEX sessions to get the requirements and coordinating with the technical team for fixing the issues for proper deliverables to the client.
- Provided KT sessions to the testing and the technical teams.
- Architecting SPVTG Repair Business process flows of Oracle SFM and O2C processes around Cisco’s Repair Web services support for Enablement-Required PIDs via EDOS, Auto-Test, and License Management with SWIFT, CsA (Cesium Appliance) and CUP (Cisco Unified Publishing)
- Develop documentation and trained users for newly developed repair processes
Confidential, Concord, NH
SME
Responsibilities:
- Understanding current business processes
- Provide on-going support to business users for Manufacturing,O2C and WMS issues
- Understanding the customizations and troubleshooting day to day issues
- Responsible for providing and handling issues for iSupplier and iProcurement
- Understanding and preparing MD-050 for enhancement/interfacing requests
- Responsible for analyzing root cause and providing solutions for recurring issues
- Implemented Internal Sales Orders, Intercompany Invoicing, ATP, ASN functionality using WMS LPNs.
- Implement/test Scanners for Processing bar labels for the Master Pallet Labels, temporary picking labels, final transfer LPN labels, Staging Move, Drop loaded LPNs and final catch weight labels
- Implemented business rules and priorities using WMS Rules Engine for Picking, Put-away, Cost Groups, and Label Printing and Cross Docking features of Warehouse Management.
- Analyzed and recommend Label formats for the Receipt, Inspection, Inspection Rejection, Put-Away, Transfers and Move labels related to warehouse activity
- Provided solution where customer needed to use Cross-docking feature of Oracle WMS but did not had the right supply type coming into Oracle from the legacy manufacturing system. Implemented the complete cross-docking solution successfully by resolving this issue.
- Configured WMS Pick and Put-away rules for the warehousing operations, most of them were done using a custom SQL expression
- Automated Pick release to Shipping process using standard APIs in a OTM environment
- Implemented Cycle Counting and Physical Inventory procedures within the warehouse
- Created BP80, BR100, and MD50’s related to designs around Pick Slips, Pack Slips and Shipping documents
- Prepare Gap analysis, Development requirement, Prototype, test and implement the Warehouse Management System (WMS) as a distributed WMS
- Guide and train users in CRP/SIT/UAT phases.
Confidential, Topeka, KS
SME
Responsibilities:
- Creating MD50’s for customizations related to the Inbound and Outbound operations of the warehouse
- Setting up Order Management, Inventory, Shipping, and Purchasing modules, design Pick Slip, Pack Slip, Commercial Invoice, other shipping documents, set up customers, suppliers, Sourcing Rules, ASL and other procurement setups, per business requirements
- Modeling more than 18,000 post office Organizations and Internal sales Orders between them for replenishments.
- Implementing generation of separate Pick Slips for Bulk and Line picks using WMS Rules Engines and Shipping customization setups.
- Implemented custom functionality to split/pack large quantities into smaller LPNs prior to Put-away using UOM Conversions at Receiving and WMS LPN Pack functionality.
- Setting up IR/ISO/Inter-Organization Transfer for Replenishments between Warehouse and Post Office Organizations.
- Integrated the 3rd party picking system to Oracle WMS and did the complete coding for this interface
- Designed the partial picking, over-picking solutions in the integrations of oracle with 3rd party WMS
- Procurement module related setups not limited to Sourcing Rules, Assignment Sets, Approved Supplier Sets, Buyers, Approval Hierarchies Group, Document types.
- Order Management related setups not limited to Transaction types, Processing Constraints, Defaulting Rules amongst others.
- Guiding users during SIT/CAT phases
Confidential, Mountain View, CA
SME
Responsibilities:
- Develop and design to-be business process to process data feed from 3PL Vendors via B2B.
- Create CV010 document to illustrate data conversion requirements, strategy, conversion approach and process flows
- Identify key dependencies and propose solutions for integration and provide prototype for the integration build
- Created the Pick Release rules and document sets for order types according to business rules and assign printers and roles based on security
- Created Work shifts and concurrent programs to minimize workload on the standard manager and maximum working efficiency
- Developed custom reports to track freight costs, backorders, ups tracking, interface pending orders for end-users using Discoverer
- Configured folders at both OM Headers and Lines levels for ease of use, during go-live
- Coordinate cross functional teams to deliver BRD’s, Root Cause Analysis documents, Process Flows, Use Cases and Post Production validation scripts
- Successfully implemented the custom serial allocation by coding using the wms transactions temp table which requires expertise about how to use this table.
- Prepare document for Procure to Pay including creating PO, Approval Routing and Approve PO, Receive PO, Enter Invoices, match with PO 3-way matching, Validate invoices and Issue payment.
- Support client to set up new customer with Bill-To and Ship-To Location and assign relation to parent customer.
- Coordinate Change Requests and Releases for various environments(DEV, QA, UAT, PROD)
- Manage and coordinate onsite and offshore teams during development, testing and full cycle release phase
Confidential, Fresno, CA
SMEResponsibilities:
- Design and integrate Custom Truck Check-in/Dispatch system with Oracle 11.5.10.2 Order Management/Shipping/Inventory/WMS modules with hooks to Oracle’s Pick, Pack and Ship processes.
- Designed solution to enable Bar-coding of incoming raw material inventory to control movements and consumption of material within the manufacturing and warehousing facilities.
- Implemented customer specific ABC Compile, Cycle Counting and Physical Inventory procedures within the warehouse.
- Helped determine required high-level business processes, data exchange requirements and evaluated existing infrastructure capabilities.
- Review and provide overall direction of current MSCA transactions and recommend potential improvements and/or best practice as well.
- Created BP80, BR100, and MD50’s related to designs around Pick Slips, Pack Slips and Shipping documents
- Implemented business rules and priorities using WMS Rules Engine for Organization wide Picking and Put-away Strategies.
- WMS Operation Details and Lot transactions, Material Status, Material Status Control, Put Away Rules, Picking Rules, Task Type Assignment Rules, Cost Group Rules.
- Setup the Inventory, WIP and Purchasing Quality Plans using Collection elements, specifications and values to identify both Quality results and actions for rejected materials
- Prepare functional and technical design for WMS/MSCA/INV/Shipping custom components and advise developers for coding
- Designed/Developed new mobile MSCA pages to track the truck movement within the warehouse(like a Yard management system)
- Created the action plan details to invoke alerts and messages from quality action rule for defective items
- Mapped out the Parent and child collection element relationships to maintain and confirm data integrity
- Developed reports for the stakeholders such as Buyers, Inspectors, Engineers and Operators to view Quality results using Discoverer