We provide IT Staff Augmentation Services!

Oracle Ebs & Vcp: Oracle Scm Business System Analyst Resume

Colorado Spring, CO

PROFESSIONAL SUMMARY:

  • Over 11+ years of experience in Implementation/Upgrade/Support of Oracle ERP applications of Quote to order, Procurement, manufacturing, Logistics, Supply and demand planning.
  • Worked extensively on Supply Chain Modules in Order Management (OM), purchasing (PO), Shipping, Receiving, Sourcing, Inventory (INV), Advanced Supply Chain Planning (ASCP), Global Order promising (GOP), Collaborative Planning (CP), EDI and Demantra.
  • Extensive exposure in preparation of AIM methodology documents such as BR100, MD50 MD70, MD120 and end user manuals.
  • Gathering, analyzing business requirements and Convert Business requirement into Development and technical requirements.
  • End to End Implementation, Customization, Conversion, Interface, Extension, Development, Production support and Testing in Oracle E - Business Suite (EBS) 11i and R12.
  • Strong experience in various rounds of System Testing, Functional Testing, Integration Testing and User Acceptance Testing.
  • Served as a liaison between the business and IT to provide Oracle functional and technical business solutions that meets needs of client managers and other stake holders.
  • Defining Supply chain business process (Order to Cash, procure to pay Manufacturing, Logistics, supply and demand planning).
  • Strong skills are in PL/SQL, Oracle8i, 9i, 10g, Forms4.5,6i, Workflow2.6, VB, Excel Macro, ASP, SQL Server, Manual testing, preparing test plan and test cases using QC.
  • A highly motivated, energetic individual and a team player with excellent analytical & problem solving, communication and interpersonal skills.
  • Large number of successful implementation, global rollout, upgrade and improvement projects with detailed oracle expertise.
  • Experience in System Administration tasks related to Menus/Functions, Responsibilities, Users
  • Highly motivated team player with positive attitude, goal oriented and excellent business and interpersonal skills
  • The SCM (Supply Chain Management) obtained from APICS (BSCM) and Completed on Oracle Fusion Financials General Ledger and e-Business essential, Purchasing and OM.

PROFESSIONAL EXPERIENCE:

Oracle eBS & VCP: Oracle SCM business system Analyst

Confidential, Colorado Spring, CO

Environment: Implementation and support of Oracle App R11i in Purchasing, Order Management, Shipping, Inventory and ASCP.

Responsibilities:

  • Convert Business requirement into Development and technical requirements for enhancements and coming up with a proposed solution and preparing MD50 and BR100.
  • Setup and support advanced supply chain planning (ASCP), Collaboration planning (CP), isupplier and iprocurement modules.
  • Integration between isupplier, Collaboration planning and ASCP for SOMI (Supplier Owned Managed Inventory).
  • Supporting ATP plan (GOP), buy and manufacturing plans and collections.
  • To support the production issues occurring in Order Entry & Shipping, Receiving and associated with number of small enhancements called as Micro Projects.
  • Creating SR with Oracle for Data Fix and oracle bugs for all issues.
  • Integrating eBS and VCP instance for Collection and Supply planning.
  • Creating interface between AX and Oracle.
  • Exploding BOM into ASCP based BOM planning percentage.
  • Define forecast Set and feed as demand schedule for ASCP.
  • Define buy from Sourcing Rule and ASL Set up for drop ship process
  • Explaining users about the pegging details/ supply/ demand created in ASCP planning workbench.
  • Implementing OSP Process with ascp integration.

Primary Module: ASCP, GOP,CP,OM, PO, INV, Receiving and Inventory planning.

Secondary Module and Technical: SQL, PLSQL, XML Publisher and SQL Data Loader.

Oracle eBS & VCP: Oracle SCM Consultant

Confidential, Austin TX

Environment: Implementation and support of Oracle App R12 (12.1.2) in Purchasing, Order Management, Shipping, Inventory and ASCP.

Responsibilities:

  • Convert Business requirement into Development and technical requirements for enhancements and coming up with a proposed solution and preparing MD50 and BR100.
  • Supporting planning integration between JEP (Just Enough Planning) and eBS and Min Max planning for new stores and setup new stores (Inventory Orgs) and Enabling intercompany transaction between Confidential Canada and US and Store to Store (STS) transfer.
  • Review and maintain EDI specifications and Mapping EDI Data for inbound and outbound transactions between eBS and Retail Pro and Trading Partners.
  • To support the production issues occurring in Order Entry & Shipping, Receiving and associated with number of small enhancements called as Micro Projects.
  • Creating SR with Oracle for Data Fix and oracle bugs for all issues.
  • Review and maintain EDI specifications and Mapping EDI Data for inbound and outbound transactions for B2B Process (Trading Partners) and third party logistics providers (3PL).
  • Integrating eBS and VCP instance for Collection and Supply planning as POC.
  • Define forecast Set and feed as demand schedule for ASCP.
  • Define buy from Sourcing Rule and ASL Set up.
  • Explaining users about the pegging details/ supply/ demand created in ASCP planning workbench.

Primary Module: OM, PO, ASCP, INV, Receiving and Inventory planning.

Secondary Module and Technical: SQL, PLSQL, XML Publisher and SQL Data Loader.

Oracle eBS & VCP: Oracle Planning Consultant

Confidential, Schaumburg, IL

Environment: Implementation and Warranty support of Oracle App R12 (12.1.3) in ASCP, Demantra, GOP modules for Confidential EMB business separation for Zebra Technologies. MSI and Zebra are sharing same instance for different business entity (Separation project).

Responsibilities:

  • Analysing business requirements and Convert Business requirement into Development and technical requirements for Zebra and MSI separation.
  • Define Roles and responsibility and enabling organization security between MSI and Zebra orgs.
  • Doing MD50, BR100 for Functional and Technical Set up for ASCP and Demantra.
  • Conversion of Sourcing Rule, planners and forecast set, ASL, assignment, shipping Network for new org.
  • Integrating eBS, VCP and Demantra instance for Collection and Supply planning and demand planning.
  • Changing Org and demands in Plan Options and instance setup.
  • Launching supply plan and validating and releasing Plan orders.
  • Loading unconsumed forecast and validating consumed forecast in Demantra and ASCP between MSI and Zebra orgs.
  • Running standard collection, ATP and scheduling and rescheduling Sales Orders.
  • Perform System and Integration testing for all custom interfaces and integrations systems like TPC (Trading Partner collocation), SAP and SSM systems.
  • Explaining users about the pegging details/ supply/ demand created in ASCP planning workbench.
  • Releasing the planned orders into Purchase requisition for buy items and internal requisition for transfer items based sourcing rule and Releasing planned orders into WIP Jobs for make items.
  • Enabling Profile in integration interface for new orgs in Demantra.
  • To support the production issues occurring in Demantra and ASCP for Supply Commits and Planned orders releasing, sourcing rule, collection and plan runs.
  • Creating SR with Oracle for Data Fix and oracle bugs for all issues.

Primary Module: ASCP, PO, WIP and Oracle Sourcing.

Secondary Module and Technical: Demantra, OM, INV, BOM, SQL, PLSQL, XML Publisher and SQL Data Loader.

Oracle eBS & VCP: Oracle SCM and Planning Consultant

Confidential, Schaumburg, IL

Environment: Implementation and Warranty support of Oracle App R12 (12.0.6) in ASCP, Demantra, GOP,OM,PO modules for Project Bell ( MSI Outsourcing Distribution Center to DHL) by enabling B2B process between MSI and DHL(3PL).

Responsibilities:

  • Doing BR100, MD50 and MD70 for Functional and Technical Set up for Q2O and ASCP set up for New 3PL org in R12.
  • Gathering, analysing business requirements and Convert Business requirement into Development and technical requirements for MSI and DHL integration (B2B).
  • Enabling new orgs in ASCP plan options and collections and Disabling old org and sales order conversion from Old shipping warehouse to new warehouse and Scheduling and rescheduling new sales order and converted orders.
  • Item, Category, planners, sourcing rule and sales order conversions for new Orgs.
  • Loading Booking and shipping History for new Org and new item location combination in demantra using member and chain management for new warehouse.
  • Perform System and Integration testing and Raising and closing all the Defects with SME and development team.
  • Review and maintain EDI specifications and Mapping EDI Data for inbound and outbound transactions for trading Partners.
  • Tradesphere interface for commercial invoices with 3PL for export compliance.
  • Enabling Profile in integration interface for new org in Demantra and exporting Forecast into ASCP.
  • Spreading forecast into DENOM Table using custom configurator from Demantra (Monthly bucket to Weekly bucket).
  • Importing Protection Demand into demantra through custom workflow.
  • Integrating eBS, VCP and Demantra instance for Collection and Supply planning and demand planning.
  • Explaining users about the pegging details/ supply/ demand created in ASCP planning workbench and release planned orders for purchasing and WIP.
  • To support the production issues occurring in Demantra and ASCP for Supply Commits and Planned orders releasing, sourcing rule, collection and plan runs.
  • Releasing planned orders into Requisition and WIP jobs.

Primary Module: ASCP, GOP,OM, Sourcing and PO

Secondary Module and Technical: Demantra, INV, BOM, WIP, SQL, PLSQL, XML Publisher and SQL Data Loader.

Oracle eBS & VCP: Oracle SCM and collaborative Planning Consultant

Confidential, Schaumburg, IL

Environment: Implementation and Warranty support of Oracle App R12 (12.0.6) in ASCP, Demantra, GOP,OM,PO modules and Confidential Solutions had agreement with ALE/ALU to do business with VMI model with customer (ALE/ALU) will pay on usage or after aging periods as part Denali Project. The customer will share their forecast in advance and MSI will build components with JDM supplier and ship to customer location (3PL)(Denali Project).

Responsibilities:

  • Defining as external Orgs for External customer Ship to locations and enabling Planning and IR - ISO Integration between MSI and ALE/ALU external orgs.
  • Loading customer demand (kanban demand file) into forecast in source ERP instance.
  • Approving replenishment Quantity (Planned orders in ASCP) in external orgs and Creating Internal Requisition and Internal Sales Order.
  • Sending 856 ASN and receive against Internal requisition
  • Set up Blanket Sales agreement and Release and doing virtual shipment against release and doing invoice.
  • Set up sourcing rule and ASL and shipping network
  • Analysing and writing development requirements and design to meet external customer and MSI business requirements
  • Raising and closing all the Defects with SME and development team.

Primary Module: ASCP, Demantra, GOP,OM and PO

Secondary Module and Technical: INV, BOM, WIP, SQL, PLSQL, XML Publisher and SQL Data Loader.

Oracle Applications: Oracle Techno functional Consultant

Confidential, Schaumburg, IL

Environment: Transformation project From SAP into Oracle Applications for emb business for Confidential by global Single ERP application and implementing and support e-commerce Gateway and Order management Modules.

Responsibilities:

  • EDI implementation by Oracle e-commerce gateway (Mapping with GXS, Interface with Oracle)(EDI 850,855,860,856,810 Transactions).
  • Gathering, analyzing business requirements and Convert Business requirement into Development and technical requirements to fit business from SAP to eBS.
  • Custom OAF form for EDI error correction and Credit card integration with Cyber source.
  • Drop ship item workflow customization and Tradesphere interface for commercial invoices.
  • Delivery tracking Report using XML Publisher and Defect fixing using QC(Quality Centre)
  • Perform System and Integration testing and stamp the deliverables quality and Execution of test cases
  • Raising and closing all the Defects with SME and development team.
  • Review and maintain EDI specifications and Mapping EDI Data for inbound and outbound transactions for B2B Process (external Partners) and third party logistics providers (3PL) with GXS.
  • Create and maintain instance strategy for Development, SIT and CAT testing for eBS, legacy instances and Excellence in solution design, solution architecture, implementation and strategy.
  • Defining Supply chain business process (Quote to Order and Logistics).
  • Doing MD050 and MD070 for Functional and Technical Set up for Oracle applications.
  • Analysed and recommend e-commerce Gateway module for efficient process of EDI.

Primary Module: OM, e-commerce Gateway (EDI).

Secondary Module and Technical: AOL, PO, INV, BOM, WIP, SQL, PLSQL, XML Publisher and SQL Data Loader Pricing, ATP and Shipping.

Oracle Applications: Order to Cash Techno Functional Consultant

Confidential, Schaumburg, IL

.

Environment: Oracle Apps R12 ERP Business Suite.(OMAR project)

Responsibilities:

  • As a part of its business process they require item conditioning which includes item organization assignment, attribute change for invoice, Defaulting warehouse, Sub inventory and assigning the category for existing items.
  • Gathering, analysing business requirements and Convert Business requirement into Development and technical requirements to fit business into ERP from COF.
  • Defaulting warehouse and sub inventory when sales is entered using PL/SQL API
  • Closing Sales Order after two Minutes once all the sales order lines are closed using workflow builder 2.6
  • Customization COGS Account derivation using workflow builder 2.6
  • Enabling Pricing Security
  • Forms personalization on Pricing agreement and sales Order forms
  • Credit Approval Reports, Pricing Agreement Reports using OBIEE
  • Item conditioning and Category assignment
  • Defining Supply chain business process (Quote to Order, procure to pay, Manufacturing and Logistics).
  • Doing BR100 and MD070 for Functional and Technical Set up for Oracle applications.

Primary Module: OM, PO, INV, e-commerce Gateway(EDI), AR, BOM, WIP, Quoting, Pricing, ATP and Shipping

Secondary Module and Technical: AOL, SQL, PLSQL, Data Loader, SQL Loader, Unix scripting and XML Publisher.

Oracle Applications: Oracle Applications Procure to Pay Techno functional Consultant

Confidential, Schaumburg, IL

Environment: Production Support of Oracle App 11i (11.5.8) in Purchasing (PO) and WIP (work in progress) Modules and handling mini projects.

Responsibilities:

  • Analysing business requirements and Convert Business requirement into Development and technical requirements for Global purchasing.
  • Creating New approval Group and approval assignment for employee Supervisor approval hierarchy method with single user for multi org.
  • Changing the Set up for Auto Close PO as soon received completed by changing Set up invoice Close Tolerance 100%.
  • Closing All the PO, Releases which are completely received by PL/SQL Script.
  • Analysing development requirements and creating design.
  • Perform System and Integration testing and stamp the deliverables quality
  • Execution of test cases and Raising and closing all the Defects with SME and development team
  • Creating SR and follow up Oracle if there any issues and Creating approval hierarchy and approval assignment.
  • Item conditioning and category conversion.
  • Creating instance strategy for CAT and SIT testing.

Primary Module: PO, iProcuement, INV and AP.

Secondary Module and Technical: Conversion and AOL, SQL, PLSQL, Data Loader, XML/BI Publisher, SQL Loader and XML Publisher

Oracle Applications: Business System Analyst

Confidential, Schaumburg, IL

Environment: Production Support and testing of Oracle App 11i (11.5.8) and R12 (12.0.6) in Purchasing (PO), Order Management, INV Modules.

Responsibilities:

  • Creating Test cases and test plan for Order Management requirement and Creating traceability matrix with business requirement and Test Plan.
  • Test Execution for Order entry export compliance and product compliance and shipping flow with ISC systems
  • VB,ASP Applications - Confidential online Applications (MOL) and Writing VB Script for Data Validations
  • Writing scanner Programming for Asset Management and Optio Development for existing Report.
  • Create and maintain instance strategy for Development, SIT and CAT testing for eBS, AR1, AR2 legacy instances (MOL) and Excellence in solution design, solution architecture, implementation and strategy.

Primary Module: OM, PO, INV, AR and AP.

Secondary Module and Technical: VB Script, Macro, Conversion and AOL, SQL, PLSQL, XML/BI Publisher, Data Loader and SQL Loader.

Oracle Applications: Production Support Analyst and Business System Analyst

Confidential, Schaumburg, IL

Environment: Production Support and testing of Oracle App 11i (11.5.10) and 11i (11.0.3) in Purchasing (PO), Order entry, shipping, INV Modules.

Responsibilities:

  • End - to - end Drop shipment implementation for Symbol organization.
  • Requirement study for SCM modules and Analyze business requirements and convert into technical requirements
  • Item Conversion and Detailed design Test Plan.
  • Custom form development for shipping
  • Writing test scripts and PL/SQL program for PO creation and PO extract, consigned PO Receipt
  • Testing the functionality based on the users functionality and Testing the sales Order validation and Pick release and PO creation customized Program
  • Integrating the custom-developed forms and Programs with Oracle Applications.. Used Oracle utilities like SQL loader
  • Mapping the existing business scenario of OM and bring up customization
  • Understanding the User Requirements and coming up with a proposed solution for the tickets raised by the customer.

Primary Module: OM, PO, INV, AR and AP.

Secondary Module and Technical: Forms, Reports, XML Publisher, Conversion and AOL, SQL, XML/BI Publisher, PLSQL, Data Loader, SQL Loader and VB Macro.

Oracle Applications: Production Support Analyst

Confidential, Schaumburg, IL

Environment: Production Support and testing of Oracle App 11i (11.5.8) and 11i (11.5.10) in Purchasing (PO), Order Management, INV Modules.

Responsibilities:

  • Primary role is to support the production issues occurring in Order Entry & Shipping
  • Also associated with number of small enhancements called as Micro Projects.
  • Other activities include - Alert Monitoring, Daily Activities, Month End Activities, Job Monitoring & Scheduling
  • Understanding the User Requirements and coming up with a proposed solution for the tickets raised by the customer
  • Detailed design Test Plan
  • Development of the design / Coding by putting in Operation, the Assent tool which ensures that the programs adhere to the defined standard
  • Formally reviewing the deliverables before sending it to the customer and track the various stages in the life cycle of the project using the Client Specific tool Compass.
  • Creating SR and follow up Oracle if there any Oracle issues.

Primary Module: OM, PO, INV, Shipping.

Secondary Module and Technical: VB, ASP,VB Script, MS access, SQL Server, VB Script, Conversion and AOL, SQL, PLSQL, Data Loader, SQL Loader, XML Publisher.

Hire Now