Analysis of the current environment including:
Standards, Data sources, ETL, Modeling, DBA and Reports
Business user needs evaluation
Performance Tuning
Tool Assessment
Evaluation of current/potential ETL and
Report Writing Tools
Data Warehouse Architecture and Design
Data Warehouse Standards based on
unique requirements and limitation of the client.
Data Warehouse Architecture Guidelines
Conceptual, logical and physical Data Warehouse Design
Data Warehouse's Metadata design
Data Integration and ETL Services
Requirements Gathering and Analysis
Data Profiling
ETL Process Design and Development
Automate the Cleansing and Integration of client data
from multiple sources.
ETL Performance Tuning
Business Intelligence (BI) Integrator
Create decentralized aggregate Data Marts throughout
the organization
Report Development and Implementation
Data Warehouse Support
Data Warehouse Maintenance
Guidelines and Best Practice for DWH
Maintenance/Performance
Training (End user and BI Support)
Regulatory Reporting Implemtation
to address the requirements of Basel II
Step-by-step assistance with the implementation of a regulatory platform
Ensure compliance with external regulations
Integrates both internal and external current and historical data
Support the obtaining of maximum functionality from the solutions
Maintenance/Performance
Integrate solo and subsidiary data sources and identified the client segmentation