SATHISGURU M.

SATHISGURU M.

Oracle Apps Tech Consultant

Wadgaon , India

Experience: 9 Years

SATHISGURU

Wadgaon , India

Oracle Apps Tech Consultant

36033.1 USD / Year

  • Notice Period: Days

9 Years

Now you can Instantly Chat with SATHISGURU!

About Me

Around 9 + years of experience in IT Industries this includes 8 years as Oracle Apps Technical Consultant with required functional knowledge Extensively worked on Oracle Applications modules like OM, AR, INV, WMS, PO, AP, GL,OPM Proficient in writing...

Show More

Portfolio Projects

Description

LSP Project rollouts for South Africa, Poland, UK, Canada. Working on custom enhancements and break fix Handling Sev1 & Sev2 incidents and Leading the bridge call for SEV1 production support. Organizing Meeting with business to prioritizing the Enhancements and projects. Organizing Weekly Technical Team meeting.

Show More Show Less

Description

Russian law requires the possibility to keep an administration of the number of SKUs sold to end customers (DS) compared to the quantity imported for every single shipment Imported.

Show More Show Less

Description

Inbound and outbound Interfaces to provide automated communication between Herbalife and the 3rd Party logistic processes.

Show More Show Less

Description

Warehouse must pay the Excise Duty and other Regulation Tax to the Government Agency (Customs) for the Items Stored in Warehouse, Imported and Exported from the Warehouse.

Show More Show Less

Description

Development of Auto SDM Creation of Unique Delivery for every sale order line. Development of Custom Reservation Logic based on the client Requirement. Program that will Search for on hand QTY for an item in subsequent warehouses if it is not available in default warehouse. If on-hand is available in subsequent warehouse the warehouse will be changed for sale order line then it will be pick released. Dynamic Error Report for Auto SDM Process with XML Bursting Triggers For generating Demand Date based on the Schedule Ship date and OS Date. Program to Schedule the Auto SDM process. Worked in processing Constraints to enable security in Fields Removal of Reservations for backordered lines after pick released.

Show More Show Less

Description

Development of New AP interfaces by extracting the Data from client Legacy System. AP supplier & Supplier Site creation. Prepayment Invoice interface. Prepayment payment interfaces. Prepayment centralized payment interfaces. Standard Invoice interface. Standard Invoice payment interfaces. Standard Invoice centralized payment interfaces. AP Sub ledger Report, AR Sub ledger Report, TDS Report

Show More Show Less

Description

Directly interact with Customers to fix the issues. Involved in data extraction and migration activities. Developed a personalization which will update the organization id in RA_CUSTOMER_TRX table. Developed a Personalization whenever the amendment of unit price of blanket purchase order is happening it should check with the legacy table data if it is matched amendment will happen otherwise error will be thrown.

Show More Show Less

Description

Have done reconciliation on all control accounts like Receiving Inventory, AP Accrual, Material Account, Service Tax interim and Final Account Individually can do reconciliation of trial balance accounts using script Developed Reconciliation Report.

Show More Show Less

Description

Customized Oracle Standard Reports as per user requirement. Involved in development of reports based on business requirements and registered them in Oracle Applications. Worked on Form Personalization on Inventory To Block the Users for entering wrong Cost Of Sales Account, Expense Account

Show More Show Less

Description

Involved in requirement gathering for the Custom Object Development. Developed various XML Publisher Reports. Preparation of MD70 Technical Specification Documents. Involved in migrating the custom objects from Test to UAT and UAT to Production instance using FND LOAD.

Show More Show Less

Description

Project Details:

Russian law requires the possibility to keep an administration of the number of SKUs sold to end customers (DS) compared to the quantity imported for every single shipment Imported

Objects worked on:

PLSQL:

  • XHL Update Lot Level ICN Transactions
  • XHL OM NTS Ship confirm program
  • XHL OM NTS After Ship confirm Reprint program

ADF:

  • LOT ICN ADF Application

Show More Show Less

Description

Project Details:

Inbound and outbound Interfaces to provide automated communication between Herbalife and the 3rd Party logistic processes

Objects worked on:

PLSQL:

  • XHL - LSP Receipt Outbound Interface
  • XHL - LSP Receipt Inbound Interface
  • XHL - LSP Outbound Pick Release Interface
  • XHL - LSP Inbound Pick Confirmation Interface
  • XHL - LSP Inbound Ship Confirm Interface
  • XHL - LSP Outbound SKU Interface
  • XHL - LSP Stock Exception Report
  • XHL - LSP Stock Reconciliation Report

SOA Composites implemented:

  • LSPMemberOrderPickReleaseService
  • LSPMemberOrderDequeueService
  • LSPInboundServices
  • LSPInboundDequeueServices

Show More Show Less

Description

Project Details:

Warehouse must pay the Excise Duty and other Regulation Tax to the Government Agency (Customs) for the Items Stored in Warehouse, Imported and Exported from the Warehouse.

Objects worked on:

ADF:

  • DMS Maintenance ADF Application

SOA:

  • DMSShipConfirmServices
  • DMSPickOrdOutboundServices

PLSQL:

  • HL DMS DS Orders Pick Confirm Outbound Interface
  • HL DMS Outbound RSO-3P Ship Confirmations Interface
  • HL DMS Other outbound Orders Interface
  • HL DMS Stock Mutation Interface
  • HL DMS Products Interface
  • HL DMS Stock Synchronization Interface
  • HL DMS Archive Interim Tables
  • HL DMS Purge Archive Tables

Show More Show Less

Description

Project Details:

Converion Project, Converstion of Account Payables data from Legacy to Oracle EBS

  • Development of New AP interfaces by extracting the Data from client Legacy System.
  • AP supplier & Supplier Site creation.
  • Prepayment Invoice interface.
  • Prepayment payment interfaces.
  • Prepayment centralized payment interfaces.
  • Standard Invoice interface.
  • Standard Invoice payment interfaces.
  • Standard Invoice centralized payment interfaces.
  • AP Sub ledger Report, AR Sub ledger Report, TDS Report

Show More Show Less