Analytics on eBusiness Tax Brought Stability to P2P Invoice Processing Process

Established in 1997, the client is a world leader in developing and commercializing first-or-best-in-class therapies for rare genetic diseases. Headquartered in California, US, the client has operations spread across 20+ countries and has 2500+ employees worldwide.

Background

The customer’s Finance team was using complex SQL packages and Excel macros and pivots for reporting on eBusiness Tax (tax on buying/selling of goods/services). However, it was facing multiple issues related to file transfer, file size, file location, frequent corruption of macros, etc. with the existing reporting tool. Further, the tool was not supported by the client’s IT department. Hence the client wanted to build this functionality in a reporting tool.

 

DiLytics’ Solution

DiLytics extended the current reporting solution in Oracle Analytics by:

  • Creating new tables and adding columns to existing tables in Enterprise Data Warehouse (EDW)
  • Developing extract, transform and load (ETL) code using Informatica to extract data required for eBusiness Tax reporting from EBS into EDW staging tables
  • Developing ETL code using Informatica to load data required for eBusiness Tax reporting from the EDW staging tables into Facts and dimensions
  • Modeling the extended EDW tables in Oracle Analytics to create metrics and attributes

It has also provided reports on the following

  • Invoice Register Check
  • Expected vs Effective
  • Account Reconciliation
  • CSUT NSA Detail & CSUT Self Assessed Detail
  • Rec – VAT Detail
  • IE VAT Summary

Business Benefits

Key business benefits to the client included:

  • Enabled P2P process to run smoothly by ‘automatically’ calculating the tax (whether US Sales tax or EU VAT) that should be applied to the invoices
  • Provided an opportunity for the Finance team to efficiently report transactions

Technical Stack

Source System(s): Oracle EBS
Data Integration Tool: Informatica
Data Warehouse: Oracle Business Analytics Warehouse
Reporting Tool: Oracle Analytics

DiLytics Delivers

View all Success Stories →

Manufacturing Analytics

DiLytics implemented a Manufacturing Analytics solution for a Biotechnology Company in a short period of 100 days.

Enterprise Data Warehouse Implementation Enabled Better Business Performance

DiLytics implemented a custom data warehouse solution for a Leading Container Leasing Company in a short span of 150 days.

Center of Excellence

DiLytics established a Business Intelligence Center of Excellence to help a Video Game and Digital Entertainment Company maximize RoI.