We provide IT Staff Augmentation Services!

Oracle Scm/wms Ba Lead Resume

Pittsburgh, PA

SUMMARY

  • 9.2+ years of corporate experience in Oracle Supply Chain Management in Oracle e - Business Suite OM, INV, PO, BOM, WIP, Shipping, Warehouse Management (WMS), Transportation Management (OTM)
  • Experience with Order to Cash and Procure to Pay business flows.
  • 2+ years of Experience working on Oracle Transportation Management (OTM)
  • Good skills in Preparing User requirement analysis, Design to configure OTM, Application Configuration
  • End to End implementation of Oracle Logfire WMS (Cloud Solution)
  • Effective communicator with a proven ability to lead, manage and coordinate complex projects to ensure successful execution within scope, on time and within budget. Adept at building effective working relationships with global client teams.
  • Rich experience in creating clear and precise documentation from user requirements and system analysis. Document types include BR100, MD50 and MD70 etc.
  • Extensive experience with EDI Standards.
  • Experienced in working with Clients and Managers in identifying key release deliverables, schedules and priorities and supervising work done by offshore teams.
  • Expert in data modeling, Normalization, database design, data loading, data retrieval, modification and archival techniques.
  • Experience in using version control tools like Visual Source Safe, PVCS.
  • Excellent analytical, problem solving, communication and Interpersonal Skills with good work ethics and the ability to work well in a team or individual environment.

TECHNICAL SKILLS

ERP APPLICATIONS: Oracle Applications 12.1.X, 11.5.X, Oracle SCM OM, INV, PO, BOM, WIP, Transportation Management (OTM)

LANGUAGES: SQL, PL/SQL

OPERATING SYSTEMS: AIX, Unix, Sun Solaris, Windows NT, HP-UX.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Oracle SCM/WMS BA Lead

Responsibilities:

  • Worked as a Senior Functional Consultant in Oracle Fusion Cloud R13 of WMS, MSCA, OM, Shipping and Inventory modules.
  • Successfully implemented the Wave Planning process for all their business lines (STO-Stock Orders, MTO-Make to Orders, PAW-Parts and Warranty) for all the locations.
  • Worked on the end to end implementation of Logfire WMS - defining parent-child company relationships, setting up eligible facilities/companies, assigning users to equipment types, user menu configuration, worked on the RF menu in Logfire, defining the label printer, etc.
  • Configured the Warehouse Rules for Picking & Put Away, Defined the WMS Strategies and Rules Workbench.
  • Cleaned more than 60,000 lines which got stuck in Transaction Interface table with various reasons.
  • Preparing functional specification documents like MD50’s and BR100.
  • Fixed the Replenishment Requested and Replenished Completed issues due to WMS Pick Rules, Fixed the LPN and Shipping Content label related issues.
  • Worked with Development Team to Develop New Custom Program which helped business to clear Tracking and DFF values on schedule times.
  • Worked with Stake Holders and Development Team in redesigning the shipping interface program which created lot of issues after post GO-LIVE.
  • Deliveries not being sent to OTM for planning, collect orders not getting in OTM for planning making other freight terms go apart from collect.
  • Trained Warehouse Managers and supervisor on planning Waves and Clean up waves.
  • Modified existing put away and Pick rules to suite their business process.
  • Worked on designing and implementing BTA (Batch Ticket Automation) order, one of the plant processes more than 35,000 BTA orders per year so eliminated manual batch ticket creation efforts. Convert Sales order to Batch ticket instantaneously to support 5-day lead time.
  • Source Batch Ticket to correct dispense cell in US based on customer location.
  • Performed business requirements gathering, AS-IS & TO-BE Study, GAP Analysis, Configuring CRP Applications, Test Plan Preparation, Unit testing, UAT and Post GO-LIVE Support.
  • Implemented Min-Max Planning to maintain stock in specific sub inventories. Created new Put away and Picking Rules according to their shipping methods.
  • Writing complex pick rules to meet requirements for picking material from specific sub minventories, Lot numbers, zones and Customize the Picking and Shipping process based on the client requirement.
  • Designed custom form (Tripware) for Pick Release process to capture the vehicle details along with shipment weight which can also send data to OTM through Biztalk as an interface.
  • Configuration of Scanners for the Warehouses. Participating in the CRP, SIT and UAT with the clients.

Environment: Oracle Fusion Cloud R13 Inventory, Purchasing, Order Management, Shipping, WMS, OTM, MSCA (Telnet), Bill of Materials and Work in Progress, Oracle 9i, Bugzilla, SharePoint and etc.

Confidential, Itasca, IL

Oracle WMS BA Functional

Responsibilities:

  • As a SCM Functional consultant implemented SCM modules: Purchasing (PO), Oracle Order Management (OM), Inventory (INV), Shipping (WSH), Warehouse Management (WMS), Oracle Transportation Management (OTM)
  • Performed Requirement and Gap analysis. Configurations and Setups Purchasing (PO), Oracle Order Management (OM), Shipping (WSH), Warehouse Management (WMS), Inventory (INV), Oracle Transportation Management (OTM)
  • Worked on the WMS - defining parent-child company relationships, setting up eligible facilities/companies, assigning users to equipment types, user menu configuration, worked on the RF menu, defining the label printer, etc.
  • Worked on integrating Shipping module with Third Party Fulfillment warehouse, defined pick release rules, ship confirm rules, freight terms, packing options, etc.
  • Worked on the Oracle OM module - setting up the transaction types, credit check rules, order and line workflows, defaulting rules, processing constraints, etc.
  • Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • Worked on the data mappings, fixing errors, design specifications around the e-Commerce gateway including the following mappings EDI 832 Price/Sales Catalog, 843 Inbound Response to RFQ, 856 ASN (Shipping) inbound and outbound
  • Define order transaction type setups for all types of order process flows and map it with legacy system transaction types.
  • Define the order reservation process rules and setup custom substitution rules.
  • Define the ATO configuration item BOMs and import orders against new configurations.
  • Extensively worked on preparing test scenarios, test scripts on different applications to help the users for better understanding the application
  • Work with Business team to carry out Functional testing, integration testing and volume testing.
  • Work with Business team in User Acceptance testing with end users in the warehouse.
  • Prepare user-training documents and conduct user-training sessions on the new changes implemented in Oracle instance.
  • Facilitate the onsite-offshore co-ordination during design and all the phases of project schedule.

Environment: Oracle Apps R12.2.4 in Inventory, Purchasing, Order Management, Shipping, WMS, MSCA, Bill of Materials and Work in Progress, Oracle 9i

Confidential, Minneapolis, MN

Oracle SCM Functional Analyst

Responsibilities:

  • Mainly responsible for mapping the client's business process in the modules of Oracle Inventory and Order Management.
  • Responsible for the setups for Purchasing (PO), Order Management (OM), Warehouse Management System (WMS), Shipping, Bill of Materials (BOM) and Oracle Transportation Management (OTM)
  • Performed all the setups for Order Management including defining of the OM Workflows, Transaction Types, Line Transaction flows, RMA Process, Setting up Pricing in Advance Pricing (Modifiers, Qualifiers, Pricing Formulas), Shipping Networks, Shipping Parameters, etc.
  • Worked on the cartonization in Oracle WMS
  • Worked Cross Docking Setups, Item Container Relationships in Oracle WMS
  • Worked on the WMS Rules Engine defining rules for Put Away, Picking, Task type Assignment
  • Worked on Cost Group Assignment, Label Format Assignment in Oracle WMS
  • Worked on Operation Plan Selection in Oracle WMS
  • Working on the DFI setups for mobile, Label Formats, etc. in Oracle WMS
  • Setting up shipping networks to enable Inter Organization Transfers.
  • Prepare System Requirement Documents (SRD) for the new requirements.
  • Preparing Test Cases for the new functional requirements.
  • Mapped complex outbound logistics requirement on Order Management.
  • Drop ship Functionality was setup to enable the OM team to ship the goods directly to Customers from Supplier warehouse.
  • Worked with Web methods EDI team to complete ASN receiving testing for Drop ship orders.
  • Responding to functional assistance tickets from the business users, problem analysis and resolution in Post implementation support.
  • Production Support Analyzing and resolving implementation issues.

Environment: Oracle Apps 12.1.3 in Inventory, Purchasing, Warehouse Management (WMS), Shipping, Order Management, Shipping, OTM.

Confidential

Oracle Functional Consultant

Responsibilities:

  • As part of the Implementation team - worked on the implementation for Quoting, OM, Advance Pricing, Shipping, WMS modules
  • Worked on Oracle WMS Implementation doing the setups for the WMS Org, WMS Sub Inventories, Cartonization, Cross Docking Setups, Item Container Relationships
  • Worked on the WMS Rules Engine defining rules for Put Away, Picking, Task type Assignment, Cost Group Assignment, Label Format Assignment, Operation Plan Selection, Working on the DFI setups for mobile, Label Formats, etc.
  • Worked on the Configuration of the INV module including setting up of the Item Catalogs, Defining Catalogs, defining change categories and Types, Defining Item structures, setting up document management, defining roles and implementing role-based security.
  • Responsible for the implementation ABC codes, Cycle counting and Physical Counting.
  • Worked closely with Client finance user team and Oracle finance consultant on issues like intercompany invoicing, auto invoicing, tax codes and inventory valuation and resolved them by explaining the standard Oracle functionality.
  • Worked closely with on site and off site technical team on Master and Transactional data conversion and validation issues.
  • Worked with Oracle Support for managing service requests
  • Worked as part of the Production Support team to manage enhancement requests from the business users
  • As part of the production support team - managed the interface table errors, tracking errors, fixing them.
  • Worked on managing workflow errors as part of the Production Support team
  • Supported the users on performance issues as part of Production Support activities.
  • Worked on supporting users by resolving workflow errors
  • Supported the approval issues that arose around AME
  • Supported the FSG report development in GL
  • Supported the Auto Lock box interface with 3 banks
  • Supported the Auto Invoice interface in AR
  • Supported the integration of the Item Master with the PDH module
  • Supported the users when they had performance issues with reports, forms and interfaces
  • Supported the new development activities - developing enhancement code, migrating it to production, etc.
  • Supported the users with developing month end and quarter end scripts for helping with error reporting
  • Supported the users with developing AD hoc reports for month end and quarter end reconciliation
  • Supported the integration of EDI transactions with Oracle e-Commerce Gateway, resolving issues as part of the production support team

Confidential

SCM Functional Analyst

Responsibilities:

  • Worked on supporting the Month end and quarter end activities
  • Came up with a close process road map for the users in order to enable smooth closing of the periods
  • Fixed interface errors so as to enable smooth closing
  • Worked on alerts to inform users of errors so as to proactively fix issues
  • Worked on fixing workflow issues as part of the production support team
  • Worked on the analysis of new requirement for enhancements from the users
  • Worked with the users on prioritizing new enhancement requests for the users as part f the production support team
  • Supported the users on a daily basis - managing the help desk queue, analyzing issues, prioritizing the issues, resolving the issues, having status meetings with users to keep them informed of the progress of open tickets
  • Worked on customizing the reports Transaction Register (INVTRREG) to change the layout, add parameters to fit in the client requirements.
  • Built a new custom report on Inventory Aging showing transaction date, sub inventory, item number, on-hand quantity and transaction type depending upon aging bucket.
  • Tested the objects before sending them in for User Testing.
  • AP - Worked on the AR/AP netting process and refund functionality in AP
  • AR - Worked on the Auto Lock Box process
  • Create the receipts and post the data into standard oracle interface tables. Created a report of records created and rejected.
  • AR Auto Invoice Interface - Worked on the Auto Invoice interface program to import invoices from an external system into Oracle.

Confidential

Supply Chain Functional Analyst

Responsibilities:

  • As a SCM Functional consultant implemented financial modules: i-Procurement, Purchasing (PO), Warehouse Management (WMS), Oracle Order Management (OM), Inventory (INV), BOM, WIP,
  • Performed Requirement and Gap analysis. Configurations and Setups i-Procurement, Purchasing (PO), Oracle Order Management (OM), Warehouse Management (WMS), Inventory (INV), BOM, WIP,
  • Worked on the Oracle OM module - setting up the transaction types, credit check rules, order and line workflows, defaulting rules, processing constraints, etc.
  • Configured Taxation for US Sales Tax, Canadian GST and VAT Tax in EMEA in e-Business Tax module. Involved in the configuration of Tax Content Service, Tax Determination Services, Tax Users, Look Up Codes, TCA Geography Hierarchy, TCA Classifications for Tax, Tax Classification Codes, Tax Accounts and Tax Accounting Information.
  • Worked on the setups of Warehouse Management (WMS) module
  • Worked on the data conversion from 11i to Release 12 for all financial modules.
  • Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
  • I worked on EDI transactions like 810, 852, 832, 826, 850 file formats.
  • Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
  • I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
  • Pre upgrade testing and Post upgrade production live support.
  • Support Production issues on a day to day basis including month end closure p1 issues
  • Implementation and support of i-Procurement, Purchasing (PO), Oracle Order Management (OM), Inventory (INV), BOM, WIP Module
  • Provide support/enhancements for the existing Oracle and Discoverer Reports (across OM, INV and PO) and create new ones based on business requirements.
  • Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
  • Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration

Confidential, Palo Alto, CA

Functional Consultant

Responsibilities:

  • Gathering business requirement by having detailed discussions with business team.
  • Functional Specification writing, Reviewing Master business requirement details, Gap analysis.
  • Review other functional Specifications.
  • Worked on the set ups all the modules in Order to cash cycle.
  • Preparing various functional requirement and propose high-level design details for programs to keep data in Order Management and I Store, I-Procurement, I-Expense instance in sync.
  • Involved in setups, requirement gathering and functional specs preparation for Oracle incentive compensation.
  • Prepared high-level technical design document.
  • Coordinated and lead the entire phase of the project which included initial operations analysis, business process re-evaluation, conversions, customizations, testing, training, documentation and implementation of modules.
  • Interacting with upper management to identify the business process and needs and with end users to identify their requirements.

Environment: Oracle 9i, Oracle Financial Applications 11i (11.5.10.2), AR, I-Procurement, PO & AP.

Hire Now