IVC Inc is a large manufacturer/contract manufacturer of Vitamins in North America. The company as of Feb 2011 migrated to Oracle EBS R12. EBS Manufacturing (OPM) lacked many reports. BP Analytics was hired to develop a fully scalable DW that almost real time (1 hour delay) provides the analytics needed to run the company.
BP Analytics developed from scratch a data warehouse that extracts data from Oracle EBS into a highly optimized Data Warehouse. Currently Cognos 8.4.1 is used as the reporting engine. The extract and load process has been streamlined to provide reporting that has a one hour delay and all reports run under two minutes.
We developed over 50 reports in the following functional areas:
- Cost Accounting
- Sales and Marketing
- Executive level Summaries
- Quality Control
No third party software tools were used and we were able to complete the project on schedule and on budget. We are currently the DBA for the Data Warehouse and have written an extensive ERD diagram showing the linkage among the tables.