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
• 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.
• 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, Itasca, IL

Oracle SCM Functional Lead

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.
• 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.
• As part of the Production Support team - worked on handling the help desk tickets
• Routinely involved with period close and book closure activities.
• Worked on prioritizing the help desk open requests
• Worked on the support of the users for new enhancement requests.
• Supported the users for developing ad hoc reports as part of the reconciliation process
• Supported the interface issues and resolved the errors
• As part of the production support team - worked on resolving workflow issues
• Supported the users for developing of new error reporting alerts (periodic and event)
• Supported the users in resolving performance issues in the system
• Worked on the close process with the users
• Supported the streamlining of closing of the modules in oracle e-business suite
• Resolved issues daily with interfaces that we are coming in from suppliers with ASN Information

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.
• Coordinated with the client by providing them onshore Functional support of their daily reported production issues
• Provided 24*7 supports in co-ordination with Onshore/ Offshore model support to the business.
• Delivered excellent service and support to internal business customers, also was responsible for monitoring progress against service level agreements. Also responsible for ensuring each reported problem is resolved in a timely manner, tracked according to standards, and escalated as appropriate.
• Coordinated activities with testing and the technical team to resolve daily reported production issues. Facilitated discussions with end-users/managers to gather functional requirements on their issues.
• Supported the Interface errors that occurred and resolved them in a timely manner
• Supported the month end and quarter end activities to help the business with the close process

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

Confidential, CA

Oracle Functional Consultant Production Support

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, NC

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 processCreate 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.
• 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.