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,...
- Extensively worked on Oracle Applications modules like OM, AR, INV, WMS, PO, AP, GL,OPM
- Proficient in writing stored procedures, Packages and functions using SQL & PL/SQL.
- Worked in Reporting tools Like RDF, BI Publisher, OPTIO, Delimited text Reports with PLSQL.
- Extensively created inbound & outbound Interfaces which are Integrated with third party via Oracle SOA services.
- Worked in Oracle SOA Technology and implemented few services for inbound, outbound interfaces with the help of EBS Adapter and business events.
- I learned ADF Technology, on my own and implemented two simple applications.
- Having basic hands on knowledge in Fusion Technologies BIP, FBDI, OTBI, Customizations.
- Extensively worked in conversion project, Personalization and Customizations in Oracle Applications.
- Hands on Experience in Technical documentations MD70, MD50, CV60, TE70
- Worked in both implementation and support projects on R12 & 11i.
Skills
Database
Web Development
Programming Language
Others
Positions
Portfolio Projects
Company
Russia ICN Project
Role
Full-Stack Developer
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
Tools
Toad JDeveloperCompany
Logistics Service Provider
Role
Full-Stack Developer
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
Tools
Toad JDeveloperCompany
Duty Management System
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
Tools
Toad JDeveloperCompany
GATI
Description
Project Details:
Converion Project, Converstion of Account Payables data from Legacy
- 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
Skills
Oracle E-Business Suite PL/SQLTools
Toad bi publisher