SUMMARY

• Over 13+ years of extensive experience in implementation, upgrade, Testing and Support of Oracle eBS for business flows Order to Cash (OTC), Procure to Pay (PTP) cycles, Forecast to Stock (FTS), Forecast to Make (F2M), Quote to Order (QTO).
• Strong understanding of business flows, underlying technical architecture and table structure of all eBS SCM applications (OM, PO, Pricing, EDI, INV, BOM, WIP) and Oracle Value Chain Planning Applications including Advanced Supply Chain planning (ASCP), Demantra and Global Order Promising (GOP, ATP).
• Review and maintain EDI specifications and Mapping EDI Data for inbound and outbound transactions between eBS and Trading Partners (850,855,865,810,856) in e - Commerce Gateway and XML Gateway using Oracle SOA B2B and ODI.
• Preparing Test Script and test plans and capturing test results, Defect Tracking for UAT, CRP & SIT Testing with business Using ALM(QC) and panaya.
• Analyzing business requirements and Convert Business requirement into Development and technical requirements for AIM methodology such as BR100, MD50, MD70, MD120 and end user manuals.
• A highly motivated, energetic individual and a team player with excellent analytical & problem solving, communication and interpersonal skills.
• Technically proficient in RICE components and End to End Implementation, Customization, Conversion, Interface, Extension, Development, Production support and Testing in Oracle E-Business Suite (EBS ) 11i and R12.
• Experience in Business Requirements gathering, GAP Analysis, Test Plan Preparation, Unit Testing, Functional Architecture, System Integration testing, UAT, Go-Live preparation and Production Support.
• Skilled in Configuring the application based on solution design, performed gap analysis and designed workaround solutions. Excellent knowledge on Functional Analysis and Implementation, Techno/Functional analysis on Interfaces/Legacy conversions, Views and Reports.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• The SCM (Supply Chain Management) certification obtained from APICS (BSCM) and Completed Certification on Oracle Fusion Financials General Ledger and e-Business essential, Purchasing and OM.

TECHNICAL SKILLS

Application Development Tools: Oracle Applications R12 and 11i versions

Primary Modules: OM, PO, INV, AR, ASCP, BOM

Secondary Modules: Demantra, Supplier, BOM, WIP, EDI, MRP, IO, Pricing (QP), AP, AR, GL

Apps Technical: RICEW (Forms Reports, Integration, conversion, extensions, workflow), OAF, Personalization, Workflow, Web ADI, Unix Shell scripting, XML/BI Publisher, Application Developer and System Administrator responsibility tasks.

Application Package: Kintana, Clear case, HP Quality Center, BMC Remedy

Databases / DB Tools: Oracle 10g & 11g, PL/SQL Developer, Toad, SQL

Desktop Tools: MS Excel, MS PowerPoint, MS Visio

Methodologies /Techniques: Business Process Analysis, Functional Requirement Analysis, GAP Analysis and Solution Design

Operating Systems: Windows XP, Windows 7 and Windows 8, Unix,Linux

Programming Languages: SQL, PL/SQL, Java Script, VB Scripts, Excel Macro

Testing Tools: ALM, Manual Testing

PROFESSIONAL EXPERIENCE

Oracle SCM Consultant

Confidential, Erie, PA

Environment: Demantra Implementation for Confidential Transportation Grove City Organization for forecast generation and Level Loading Open Sales order demand.

Responsibilities:

• Integration with Order Management with Demantra to collect Open Sales Order (internal and external), Pricing using Demantra Shipment collection program and Level Load demand in Demantra.
• Send back Level Loaded demand to Master Demand Schedule (MDS) to eBS-MRP for shipment relief and Collected as MDS by standard collection to Global ASCP Plan.
• Define IR-ISO Set up for intercompany transfer.
• Configuring Series, Levels, system/database/engine Parameters, forecast tree, Engine profiles and Building Data Model in business Modeler.
• Create and Configure Worksheets for Demand analysis and Level Loading Open Sales order demand.
• Validation (Production Pull in Capacity) and Color expression on custom Series on worksheet.
• Custom Hook for updating item code and loading data based on Schedule ship date in Demantra staging table.
• Customization and Integration with EBS Full download workflow for import Process (Worksheet Setup and defaulting Values).
• Custom Workflow Integration for export forecast series into DNORM table and Loading into Master Demand Schedule (MDS) in eBS for shipment relief in EBS.
• Customization for collecting sales order Demand based on Schedule ship date instead for Requested Date in Shipment collection program Using Custom hook.
• Define Integration interface with ASCP for loading Demand and spread forecast for UX parts.
• Convert Business requirement into Development and technical requirements for enhancements and coming up with a proposed solution and preparing BR100.
• Creating method and interface developed in Demantra to maintain Level capacity and Pull in schedule.
• Custom Calculation while saving data (Change in update workflow in Demantra).
• Controlling menu in collaboration Workbench using Demantra Admin Manager.
• Conducted PO, OM, Demantra and ASCP data flow for CRP & SIT sessions with business.
• Configure and maintain BR100 and Demantra config document for Set up & migration.
• Developed all the custom PL/SQL code for custom hooks, EBS full download workflow customization and worksheet customization.
• Working with DBA and oracle on Demantra Installation and Demantra issues.

Oracle Business Analyst

Confidential, Colorado Spring, CO

Environment: Implementation, Testing and support of Oracle App R11i in Order Management (OM), Purchasing, Shipping, Inventory and ASCP and integration between AX with oracle interfaces for drop ship, Back to Back process using isuplier Module.

Responsibilities:

• AX integration with Oracle 11i for Sales Order, shipping, Purchase Orders (PO) receiving.
• Define OM Set up and maintain BR100 (transaction types, holds, workflow, shipping Method code, freight Terms and Sales Person).
• Define IR-ISO for Intercompany set up
• To support the production issues occurring in Order Entry & Shipping, Receiving and associated with number of small enhancements called as Micro Projects in OM, PO, INV, WMS, BOM, WIP and ASCP and Demantra.
• Review and maintain EDI specifications and Mapping EDI Data for inbound and outbound transactions between eBS and Trading Partners (850,855,865,810,856) in e-Commerce Gateway using Oracle SOA B2B and ODI.
• Convert Business requirement into Development and technical requirements for enhancements and coming up with a proposed solution and preparing MD50 and BR100.
• Changing ATP rule with max of lead time to subassemblies to view Material and resource constraint in the ATP plan.
• Enabling Forecast consumption in ASCP instead of eBS Source instance and Changing forward and backward consumption for enhancing forecast.
• Integration between isupplier, Collaboration planning and ASCP for SOMI (Supplier Owned Managed Inventory).
• Supporting ATP plan (GOP), buy and manufacturing plans, standard collections and Demantra custom collection.
• Exploding BOM into ASCP based BOM planning percentage.
• Define buy from Sourcing Rule and ASL Set up for drop ship process for AX integration.
• Explaining users about the pegging details/ supply/ demand created in ASCP planning workbench.
• Support Demantra Custom collection and define new series.
• Configuring ATO, PTO and CTO Model for discrete and flow manufacturing.
• Flow schedule creation from ASCP planned orders for smoothing inventory Vs Mix Max Inventory Planning for Subassembly.
• Inventory Optimization plan for Time-phased safety stock Calculation (SS) and feed into ASCP MRP Plan.
• Define Pricelist set up and Pricing agreement.
• Collaboration planning integration with iSupplier for sharing demand and get supplier commits.

Oracle 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.
• Define new OM transaction types and defaulting rules for new 3PL order types.
• Enabling new 3PL org for CDC (Canada distribution Centre).
• Enabling intercompany transaction between Golfsmith 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 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.
• Enabling EDI 856 ASN inbound transactions for PO
• Define buy from Sourcing Rule and ASL Set up.
• Supporting eBS (OM, PO, INV, e-commerce Gateway) modules and bug fixing all the enhanced mini projects and planning integration between JEP (Just Enough Planning) and eBS and Min Max planning for new stores and setup new stores (Inventory Orgs).
• Review and maintain EDI specifications (850,856,810) and Mapping EDI Data for inbound and outbound transactions between eBS and Retail Pro and Trading Partners.
• Integration with Isupplier for VMI, Consigned Inventory

Oracle Techno-Functional 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 and Oracle Value Chain Planning (Demantra, ASCP) instance for Collection and Supply planning and demand planning.
• Define Constrained and unconstrained Plans in Plan Options and instance setup.
• 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.
• To support the production issues occurring in Demantra and ASCP for Supply Commits and Planned orders releasing, sourcing rule, collection and plan runs.
• Engine Tuning for Forecast Modelling (System parameters, forecast tree, causal factors) .
• Custom interface for safety stockcalculation (SS) using Existing Demand and supply and comparing custom calculation Vs Inventory Optimization(IO) plan output.
• Forecast Export to ASCP by Level loading from Demantra
• Testing of Real Time Sales and Operations Process (RTSOP)in Demantra.

Oracle Techno-Functional Analyst

Confidential, Schaumburg, IL

Environment: Implementation and 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.
• Explaining users about the pegging details/ supply/ demand created in ASCP planning workbench and release planned orders for purchasing and WIP.
• Enabling SCI Data Collection for Sales and operation planning RTSOP.
• 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, Oracle Value chain planning and Demantra instance for Collection and Supply planning and demand planning.
• Integration for supplier using TPC(isupplier) for supplier commits, ASN and VMI.

Oracle SCM Techno Functional Consultant

Confidential, Schaumburg, IL

Environment: Implementation and support of Oracle App R12 (12.0.6) in ASCP, Demantra, GOP,OM,PO modules and Confidential had agreement with ALE/ALU to do business with customer faced 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.

Oracle Techno Functional Consultant

Confidential, Schaumburg, IL

Responsibilities:

• EDI implementation by Oracle e-commerce gateway (Mapping with GXS, Interface with Oracle) (EDI 850,855,860,856,810 Transactions).
• Gathering, analysing 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.

Techno Functional Consultant

Confidential, Schaumburg, IL

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.
• Monitoring Jobs and re-running jobs in Control-M

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.

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.
• Monitoring and re-running failed unix cron-jobs using control-M
• 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.

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. The processing Customer Sales orders and Purchase Orders entered into the CHS Order Management ERP so that they may be electronically transmitted to the EMb (Formerly Symbol) ERP for Manufacture, Fulfillment and Distribution.

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.
• Job monitor using control - M and ticketing and change Management tracing using Service tool.
• 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.