May 21
Clients PDF Print E-mail

Avea  (GSM operator in Turkey)

   A. Data warehouse restructuring project

     • Data Warehouse modeling
          Pre-paid, post-paid, VAS Customer, CDRs (rated+unrated), Product, Contract, Offer,
          Invoice, Payment, Customer Communications, Awards
     • Datamarts modeling
     • Data Warehouse implementation
     • Reporting systems implementation
     • Tools and technologies used: Oracle, Oracle Data Integrator, Oracle Business Intelligence 
        Enterprise Edition


    B. CRM Project

     • Campaign Datamarts Modeling
     • Campaign Datamarts Implementation
     • Integration of Data Warehouse, Siebel OLTP and Campaign Datamarts
     • Campaign Reporting systems implementation
     • Tools and technologies used: Oracle Siebel Marketing Automation,
       Oracle Siebel CRM, Oracle Data Integrator, Informatica,
       Oracle Business Intelligence Enterprise Edition

    C. OLAP Project

Vodafone (GSM operator in Turkey)


Extension of the Data warehouse model
Business Requirements Analysis of the Finance Department
Financial Datamart modeling
Financial Datamart implementation

Turkcell (GSM operator in Turkey)


Design and implementation of the datamining datamart
ETL consultancy

Tellcom/SuperOnline (Service Provider)


Data warehouse modeling
Data warehouse ETL consultancy
Oracle Data Integrator Training
Tools and technologies used: Oracle, Oracle Data Integrator (ODI)

Türkiye İş Bankası  (Very large Bank)


Data Profiling (Basel II)
Data Quality Analysis (Basel II)
Tools and technologies used: DB/2, Intellica DataArt
Business Intelligence training

Garanti Bank (Very large Bank)

Data warehouse Restructuring Project
Data Model Design (BDW)
ETL design and implementation
Training
Tools and technologies used: Oracle Data Integrator

Digiturk (Digital Broadcasting company)

  • Data Warehouse and Datamarts restructuring design and modeling
  • Business intelligence and Data warehouse Architect Training
  • Oracle Data Integrator Training
  • Tools and technologies used: Oracle, Sybase IQ, Oracle Data Integrator, Sybase Power Designer

TEB (large bank)

  • Technical assessment of Business Intelligence and Data Warehouse environments
  • Business Intelligence Roadmap generation
  • Tools and technologies used: Oracle, Business Objects
  • Data warehouse modeling and mapping design, datamart design

Groupama Sigorta ve Emeklilik (Insurance and Life Insurance)

  • Business Intelligence Roadmap creation
  • Tool selection criteria and RFP
  • Data Warehouse and Business Intelligence Training
  • Data Warehouse design and modeling
  • Data Warehouse implementation
  • Reporting and OLAP systems implementation
  • Data Mining solution implementation
  • Tools & Technologies used: DB/2, SAS, SAS ETL Studio, SAS Query Studio, SAS
  • Enterprise Guide, SAS Enterprise Miner

Ray Sigorta (Insurance)

  • Data Mining Training

Finansbank (large bank)

A. Data warehouse implementation

  • Data Warehouse consultancy and implementation
  • Tools & Technologies used: Oracle, Oracle Data Integrator

B. Data warehouse restructuring

  • Reengineering of the Finansbank Data warehouse

Tekstilbank (mid-­size bank)

  • Business requirements analysis
  • Data warehouse design and modeling, implementationDesign and implementation of ETL processes
  • Design and implementation of business intelligence and reporting systems
  • Design and implentation of the campaign management system
  • Implementation Data mining infrastructure
  • Oracle Data Integrator and Oracle Business Intelligence Suite Trainings
  • Tools and technologies used: Oracle, Oracle Data Integrator, Oracle Business
  • Intelligence Suite, Oracle Siebel Marketing Automation, Inforsense

Bank Asya (large bank)

  • Business Intelligence Roadmap creation
  • Data Warehouse and datamarts design and modeling
  • Data Warehouse and datamarts implementation
  • Reporting and Analysis systems implementation
  • Tools and technologies used: Oracle, Sybase IQ, Oracle Data Integrator, Business
  • Objects, Sybase Power Designer

Kuveyt Türk Katılım Bankası A.Ş. (mid-­size bank)

  • Business requirements analysis
  • Business Intelligence Roadmap creation
  • Data Warehouse and datamarts design and modeling
  • Data Warehouse and datamarts implementation
  • Reporting and Analysis systems design and implementation
  • Design and creation of the OLAP cubes
  • Tools and technologies used: Microsoft
  • Design and implementation of dashboard and reporting systems with QlikView

State Social Security Organization (Sosyal Güvenlik Kurumu – SGK)

  • Data warehouse modelling
  • ETL training
  • Data Warehouse ETL design
  • Data Warehouse implementation
  • Tools and technologies used: Oracle, Oracle Data Integrator

POAŞ (Petrol Ofisi) (Oil Production and Distribution)

  • Data warehouse modelling
  • Data warehouse ETL design
  • Reporting and analysis systems design and implementation
  • Tools and technologies used: Oracle, Oracle Data Integrator, Oracle Business
  • Intelligence Suite Enterprise Edition

CMC Call Center(call center in Turkey)

  • CRM model creation
  • Operational CRM data interface implementation
  • Reporting System implementation
  • Tools and technologies used: MS-SQL, Intellica DataArt, QlikView

Global Bilgi Call Center (call center in Turkey)

  • Data warehouse modeling
  • ETL consultancy, design and implementation
  • Oracle Data Integrator and ETL Training
  • Tools and technologies used: Oracle Data Integrator

MKK – Merkezi Kayıt Kuruluşu (semi-­government central official financial registry institution)

  • ETL design and implementation
  • Tools and technologies used: Oracle Data Integrator

Eurobank Tekfen (investment bank)

  • Data warehouse modeling
  • Data warehouse implementation
  • Reporting systems implementation

ING Bank (large bank)

  • ETL consultancy
  • ODI Support agreement for ongoing support and consultancy

WITTUR AG – Italy (manufacturing)

  • ODI consultancy

Zagrebačka Banka - Croatia (large bank)

   Data warehouse restructuring project

     • Data Warehouse implementation
     • Tools and technologies used: Oracle, Oracle Data Integrator, Oracle Goldengate, Oracle Exadata

 

Markafoni (private shopping)

  • Real time offer management with EVAM

 

 

Boyner (retail)

  • Real time offer management with EVAM

 

 

Bilyoner (betting)

  • Real time offer management with EVAM

 

Pre-paid, post-paid, VAS Customer, CDRs (rated+unrated), Product, Contract, Offer,Invoice, Payment, Customer Communications, Awards