ERP Cloud Experience:
Strong Knowledge in developing the OTBI reports, BIP reports and Dashboards.
Extensively worked with FBDI template to load the data from source system to ERP cloud.
Extensively worked with Project Accounting to develop the various reports and dashboards and below are the details.
1. Developed the Revenue management report at project and contract level.
2. Developed the commit and actual cost project report to populate the project time and project cost
details for various sources like : PO, Travel & Expenses, OTL , Manual AP Invoices, manual journals etc.
3. Developing the Project accounting BIP reports and integrated those reports to Infolet
Dashboard from home page.
4. Developed the various BI publisher reports in project accounting and report details are as below. Below
reports will be called from HTML output and HTML output provided hyperlinks which redirects to projects
application.
5. Project team members report which provided the information about the project team members.
6. Financial project plan report which redirects to Manage Financial Project Plan page.
7. Travel and expense report which redirects to expense report page.
8. RBS report which provides the details about projects tasks, top tasks, task start date, task finish date
resource name etc.
9. PO report which shows PO details against the project.
10. Manhours report which provides the information about the man hours against the project.
11. Also developed the reports like manual AP invoices, Manual journals, customer invoices and
supplier invoices etc.
12. Developed the CBS setup report which provided the information about all the subledger application
mapping set details.
13. Extract the suppliers, supplier banks data from EBS application and loaded the same to Oracle ERP cloud
using FBDI template.
14. Developed the OTBI reports for reconcile the data what we extracted from EBS and what we have loaded to ERP cloud.
15. Developed the CBS accounting report to display the GL balances at GL account level.
16. Developed the below BIP reports and called from Analytics page.
a. OTL Report
b. Manhours cost report.
c. PO commitment report
d. Customer Invoice report
e. Manual AP Invoice Report
f. Manual Journals report
g. GL Account setup report
h. Project accounting mapping set report
i. Commitment and actual cost report
j. Project setup report
k. Travel and expense report.
l. Mission order report.
17. Created the dashboards and assigning the reports to dashboard.
18. Developed the GL trail balance report based on the client requirements using BI publisher.
19. Created the Sand boxes for integrating the dashboard reports to info let.
20. Developed the revenue management report.
EBS Experience:
Strong Knowledge in Developing Interfaces, Conversions, Reports and Extensions using SQL and PL/SQL.
Developed the various kind of Interfaces and conversions to import the data from legacy or third-party system to Oracle EBS.
Interfaces and Conversions:
1. Developed the Sales Order Import Interface/Conversion.
2. Developed the Customer Import Interface/Conversion.
3. Developed the Journals Import Interface/Conversion.
4. Developed the Open Purchase Orders Import Interface/Conversion.
5. Developed the Suppliers Import Interface/Conversion.
6. Developed the Item Import Interface/Conversion.
7. Developed the Item categories Interface/Conversion.
8. Developed the Item costs Interface to import the Inventory Item cost.
9. Developed the BOM conversion to convert the BOM details to EBS including create Routing, Routing sequence, Routing resources, BOM and BOM Inventory components.
10. Developed the PL/SQL API to update the PO need by date and request date and send the acknowledgement to DL group daily.
11. Developed the PL/SQL API to create the Volume discount price list.
Form Personalization:
1. Developed the Manufacturing Site assignment for multiple sales order lines.
2. Developed the Auto apply Pick Release Hold for all F10 warehouse orders.
3. Developed the Catchall form to release the holds on sales orders whenever sales order details get changed.
WEB ADI:
1. Developed the WEB-ADI to update the suppliers, supplier sites, supplier addresses, supplier site contact information, payment terms, remittance details.
2. Developed the WEB-ADI to import the geography details.
3. Developed the WEB-ADI to update the customer site address details.
Reports:
Developed the various kind of reports using RDF,RTF and XML Publisher.
1. Developed the R12 E-text reports for EFT and Wire payments.
2. Developed the AR Invoice report to send e-mail to customers along with the invoices.
3. Developed the custom solution and various reports as part of E&O process for one of the clients.
4. Developed the Intel shipping label report for print the shipping labels for global exports.
5. Developed the Kitty labels reports for print the only 30 labels per page for global exports.
6. Developed the pick slip, pack slip reports etc.
1. Pinterest
2. Technip Energies
3. Advantest
4. Ultragenyx Pharmaceuticals
5. Getty Images.
6. Amazon
7. Imagine
8. Watertown
9. K12
10. Walter Energy
11. AICPA
12. Newsday
13. Mastek