Business Intelligence, DWH, DataStage/ETL, IBM Cognos, Reporting
IMPLEMENTING A FINANCIAL DATA WAREHOUSE (AEGON)
- Taking part in and orginizing interviews
- Keeping in touch with customers
- Understanding and translating business and IT needs'
- Creating Business Requirements Specifications
• Defining business definitions and matching them in the source system
- Mapping Source Systems
• Incremental Loading
• Identification of data services and dispatches
• Identifying relevant fact and dimension tables and their logic (processes, triggers, scripts - code retrieval tasks)
- Data modelling in SAP Powerdesigner
- Data profiling purity analysis, data cleansing
- Determine how data comes from source system to ETL server
- Data mapping
- Interface specification
IBM COGNOS REPORT UPGRADE AND DEVELOPMENT (ERSTE BANK)
Participating in IBM Cognos Report Upgrade (Cognos Analytics v11.7) and Development
DATA MINING: FRAUD DETECTION (E-ON)
- SAS Enterprise Guide
- MSSQL queries
TRIGRANIT