Datawarehouse Modeling

Hi, I'm a BI/DWH/ETL expert from Bulgaria (EU) with 9+ years of experience in that field. I'm proficient in wide variety of data tools: 1.ETL-SSIS, Pentaho Kettle, Talend, Oracle Data Integrator (ODI), Informatica. 2.Databases-MySQL, MSSQL, PostgreSQL, Oracle, Teradata, and a few others. 3.BI-Pentaho BI, SSAS, SSRS, PowerBI, Cognos Also, my daily job routine requires very good scripting skills: Bash, Powershell, Python, as well as deep knowledge of SQL and database performance tuning and optimization. Best Regards, Veselin Z.

Hello Dear I am data solutions architect, i have designed a number of warehouses (a few in Erwin). I follow Kimball methodologies to design warehouse. Recently i have designed Retail warehouse by using Kimball bus architecture. How long it will take will depends upon source data profiling. After checking data granularity and natural keys for each dimension i can tell warehouse could be modeled or not (if no natural keys found to maintain slowly changing dimension). With warehouse design i can design ETL flows as well. And if interested i can implement as as well. Since i have more than 10 years experience i can design within day (s) depends upon data complexity. Looking forward to amaze you :) Kind Regards, Saima Riaz

Hi I have very good experience to design star schema database for any Banking, Insurance or Other Manufacture unit system.