You are here:
Home > References > Technology Evaluation >
Data base & business intelligence solution website
Janvier 2006- April 2007
Role: Database + BI Architect/Developer
Company name: TECNOLOGY EVALUATION.
o Designing data base diagram (ER) of 4 new projects, including tables, procedures, trigger, view,and functions
o Creation of 16 reports with SSRS
o Creation of 17 packages with SSIS
o Optimizing databases for better performance.
Creation of 2 BI projects using analysis services, Cubes, ETL, Reporting services, excel pivot Table.
The first BI project was for the portfolio of the company.
The second report was for analyzing the IIS logs of 15 web sites
The steps for the BI projects are :
o Using SSIS to clean and combine data
o Standardize and conform Log files to Database.
2-Data presentation (SSAS)
o Creation of a cube
3-Data access tools
Data mining modeling
o SQL server 2005
o Analysis services (SSAS)
o Reporting services (SSRS)
o Crystal reports
o Integration services(SSIS)
database solution, BI solution, provide solutions to the most complex database and BI problems