Ben
DataBase & Business Intelligence Expert Solution
  Home   Services Forum Jobs References Live demo   Contacts  
Mnaouar Ben Khelifa
Email:
Password:
Remember
Subscribe?     Forgot Password ?
tunis annonces femme cherche
tunis ads weatherReferences
tunis annonces meuble
tunis annonces autotunis annonces chien Sms Equipment
tunis annonces meuble
tunis annonces autotunis annonces chien Patrick Morin
tunis annonces meuble
tunis annonces autotunis annonces chien Via-Rail
tunis annonces meuble
tunis annonces autotunis annonces chien Tree Technologies
tunis annonces meuble
tunis annonces autotunis annonces chien Montreal City
tunis annonces meuble
tunis annonces autotunis annonces chien Komunik
tunis annonces meuble
tunis annonces autotunis annonces chien Cgi
tunis annonces meuble
tunis annonces autotunis annonces chien Technology Evaluation
tunis annonces meuble
tunis annonces autotunis annonces chien Speedware
tunis annonces meuble
tunis annonces autotunis annonces chien Iata
tunis annonces meuble
tunis annonces autotunis annonces chien Canada Direct
tunis annonces meuble
tunis annonces autotunis annonces chien Tradesoft
tunis chat chien
End of Left Navigation
End of Left Navigation
End of Left Navigation
weather montreal
tunis annonces You are here: Home > References > Montreal City >

Data base & business intelligence solution website
July 2008 – Dec 2008
Role : DBA: Database & BI Architect:
Company name: Montreal City
Responsibility: Data architecture (SQL 2005), BI reports

Realization:
o- Provided input to review /walkthrough process with the objective to normalize the existing operations databases using a variety of applications and technologies.
o Installed SQL server 2005 on cluster ( 2 nodes active /passive).
o Administration of SQL server 2005 including securities, users, backups, tasks.
o Created 25 packages with SSIS (integration services)
o Created 15 Reports with SSRS(Reporting services)
o Created OLAP cubes with SSAS (Analysis services)

o Reviewed and evaluate corporate data architecture, strategies and frameworks, data requirements, and business information needs. Recommend the steps required to establish data structures to support them.
o Established meta-data standards, guidelines and architecture.
o Analyzed and propose changes to databases from the context of the Logical Data Model.
o Identified the transformation of Logical Data Models to Design models.
o Assisted in the development of data modeling and meta-data policies and procedures.
o Performed data analysis and modeling for; identify data issues, recommend data analysis concepts, the suitable Data Management Policy and Data Dictionary/Models.
o Analyzed and evaluate alternative data architecture solution recommendations to meet business requirements/problem resolution to be incorporated into the corporate data architecture.
o Documented Corporate Data Architecture Principles. Recommend the logical implementation of Data Architecture Framework and support database migration from Oracle to SQL.
o Recommended the Conceptual and Logical Data Models design & development to normalize the existing databases.

Technology used:
o SQL server 2005
o Analysis services
o Cube
o MDX
o Reporting services
o Excel Macro.
o SSIS, SSAS, SSRS
o Crystal Reports
o .Net
o VB.net
o ASP.net
o C#


database solution, BI solution, provide solutions to the most complex database and BI problems

Data base & business intelligence solution website