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
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.
o SQL server 2005
o Analysis services
o Reporting services
o Excel Macro.
o SSIS, SSAS, SSRS
o Crystal Reports
database solution, BI solution, provide solutions to the most complex database and BI problems