E-commerce Data Warehouse

by veskojl
E-commerce Data Warehouse

Intelligent Trader is a retail decision support tool, which goal is to facilitate and optimize the actions taken by the owner of online business when trying to maximize the trading profit. Project is developed using the Pentaho BI technologies, MySQL and Infobright databases and Mondrian as an OLAP provider. It has staging area for the data, where later is cleansed and aggregated, data warehouse area using Infobright DB as storage and OLAP cube has 5 fact tables, 7 dimensions and about 180 metrics. The picture shows sample loading of a fact table. Key technologies: Pentaho BI 4.x, MySQL 5.x, Infobright 3.x, Mondrian, Liferay Portal 4.x

image of username veskojl Flag of Bulgaria Sofia, Bulgaria

About Me

I am a Data Warehouse (DWH) expert with solid knowledge and proven experience. I have 12+ years within the Business Intelligence (BI) field and I've worked on a different type of DWH projects: from small ones to medium sized and large scale solutions. My core competences are DWH and ETL design and implementation, but I have no fear to create complex charts and dashboards. Over the years I've gained experience of various DWH/ETL/BI tools and technologies like: Teradata, Oracle, MS SQL Server, Pentaho BI, Microsoft BI (SSIS, SSAS, SSRS), and many others. I'm looking for challenging DWH, ETL or BI projects.

$80 USD/hr

7 reviews
4.6

Tags