09/16/2023 updated


100 % available
Oracle Apps Technical Consultant, Oracle Apps Technical Consultant, Oracle Apps Technical Consultant
Noida, India
Worldwide
B.TechBusiness AnalysisBusiness RequirementsComputer ProgrammingPersonalizationCursor (Graphical User Interface Elements)Discrete ManufacturingEnterprise Resource PlanningFinancesManufacturingProject ManagementOracle ApplicationsPL-SQLSQL DatabasesExtensible Markup Language (XML)Oracle Soa
PROFESSIONAL SUMMARY:
- IT professional, having overall 10+ years of experience as an Oracle Apps Technical Consultant in Implementation, Support, Development & Customization of different oracle apps modules of Financials & SCM.
- Specialized in the Technical aspects related to the Implementation and Support of Oracle Apps R12 Applications (OM, PO, GL, AR, AP, iExpense and AR).
- Very Strong exposure to RICE (reports, interfaces, conversions, and enhancements/ extensions) components.
- Worked on Oracle Discrete Manufacturing & Oracle Process Manufacturing ERP methodology.
- Extensively Worked on P2P Cycle and O2C Cycle.
- Good Functional Knowledge in R12 MOAC and Financial module (AP, GL, PO).
- Sound Understanding and working experience with Oracle AIM Documents for Module Design and Build MD [050] MD [070], CV60 etc.
- Worked on Oracle Workflow & Oracle Alerts also.
- Worked on XML Publisher Reports and Forms developments using Template.fmb
- Worked on XML Bursting.
- Worked on Forms Personalization as per business requirements.
- Have light weight work knowledge on Oracle SOA.
- Extensive Programming experience in writing Packages, Procedures, Functions, Database Triggers, Cursors, Ref Cursor and Complex Query using SQL and PL/SQL.
- Effective communicator and versatile team player with excellent business analysis and interpersonal skills. Good people & project management skills with consistency of delivering tasks on time. Good focus and follow through abilities, with proficient efficiency and productivity.
Experience
Professional experience10+ years
Freelancer since2022
Languages
EnglishFluent
Project history
PROJECT: - 2 Oracle Apps Production Development/Support
Module Inventory
Client Solgenie Technologies for HNI Corporation (USA).
Role Oracle Apps Technical Consultant
Team Size 4
Environment Oracle Applications R12 (12.1.3)
Duration Jun 2021 to Nov 2021.
As a Technical Consultant Team Member, involved in:
* HNI Physical Inventory Tag Generation Process.
* It is a process to generate the Physical Inventory Tags Including the Physical Inventory
Report into Oracle APPS R12 Inventory Module.
* HNI Scrap Assembly Report.
* It is a report to generate the scrapped assembly items into Oracle APPS R12 Inventory
Module.
* HNI Autofas Process.
* It is a process to create the work orders automatically from the sales order into Oracle
APPS R12 Inventory Module.
Module Inventory
Client Solgenie Technologies for HNI Corporation (USA).
Role Oracle Apps Technical Consultant
Team Size 4
Environment Oracle Applications R12 (12.1.3)
Duration Jun 2021 to Nov 2021.
As a Technical Consultant Team Member, involved in:
* HNI Physical Inventory Tag Generation Process.
* It is a process to generate the Physical Inventory Tags Including the Physical Inventory
Report into Oracle APPS R12 Inventory Module.
* HNI Scrap Assembly Report.
* It is a report to generate the scrapped assembly items into Oracle APPS R12 Inventory
Module.
* HNI Autofas Process.
* It is a process to create the work orders automatically from the sales order into Oracle
APPS R12 Inventory Module.
PROJECT: - 3 Oracle Apps Production Development/Support
Module Inventory
Client Wipro for AIC
Role Oracle Apps Technical Consultant
Team Size 2
Environment Oracle Applications R12 (12.1.3)
Duration Sep 2020 to Apr 2021.
As a Technical Consultant Team Member, involved in:
* FSO User Approval Hierarchy
* It is a custom workflow to define FSO user(s) approver hierarchy.
* AP Invoice Approval is controlled by FSO approver hierarchy.
* In this users cross department mapping facility is given to approve the invoice.
Module Inventory
Client Wipro for AIC
Role Oracle Apps Technical Consultant
Team Size 2
Environment Oracle Applications R12 (12.1.3)
Duration Sep 2020 to Apr 2021.
As a Technical Consultant Team Member, involved in:
* FSO User Approval Hierarchy
* It is a custom workflow to define FSO user(s) approver hierarchy.
* AP Invoice Approval is controlled by FSO approver hierarchy.
* In this users cross department mapping facility is given to approve the invoice.
PROJECT: - 4 Oracle Apps Production Development
Module GL,AR,CM
Client Sunic Technologies for Container Corporation of India Ltd.
Role Oracle Apps Technical Consultant
Team Size 10
Environment Oracle Applications R12 (12.1.3), Oracle SOA.
Duration Aug 2019 to Aug 2020.
Responsibilities:
As a Techno Functional Team Member, involved in:
* CONCOR Oracle Apps AR Integration.
* It is an Integration project. We have integrated three different source legacy systems
into Oracle APPS R12 AR Module.
* Gathering all data as per business logics and re arrange them as per Oracle EBS
requirement to migrate all AR objects (AR Cash Receipts, AR Transactions and Cash
Management data for bank reconciliation.) including AR customer creation with update,
from source systems to Oracle EBS was primary task.
* Oracle SOA is used as a middleware and we fetch all concerned data from all three
different legacy systems into our staging tables through Oracle Job Schedulers.
* We call Oracle SOA web service from source staging servers and Oracle AR API(s) are
called from SOA web service which creates AR objects into Oracle EBS.
* Some custom reports are developed one important report which I have developed having
functionality to track each record of AR object/transaction from all different legacy
system via SOA to EBS.
* Light weight work knowledge in ORACLE SOA for project support purpose.
Module GL,AR,CM
Client Sunic Technologies for Container Corporation of India Ltd.
Role Oracle Apps Technical Consultant
Team Size 10
Environment Oracle Applications R12 (12.1.3), Oracle SOA.
Duration Aug 2019 to Aug 2020.
Responsibilities:
As a Techno Functional Team Member, involved in:
* CONCOR Oracle Apps AR Integration.
* It is an Integration project. We have integrated three different source legacy systems
into Oracle APPS R12 AR Module.
* Gathering all data as per business logics and re arrange them as per Oracle EBS
requirement to migrate all AR objects (AR Cash Receipts, AR Transactions and Cash
Management data for bank reconciliation.) including AR customer creation with update,
from source systems to Oracle EBS was primary task.
* Oracle SOA is used as a middleware and we fetch all concerned data from all three
different legacy systems into our staging tables through Oracle Job Schedulers.
* We call Oracle SOA web service from source staging servers and Oracle AR API(s) are
called from SOA web service which creates AR objects into Oracle EBS.
* Some custom reports are developed one important report which I have developed having
functionality to track each record of AR object/transaction from all different legacy
system via SOA to EBS.
* Light weight work knowledge in ORACLE SOA for project support purpose.