Projects

EDW for Thailand’s First ‘Social Banking’ Platform

The Client

A new social banking brand that is extremely easy to use and fun. Customers will enjoy instant banking service within the LINE platform, such as, simple step to apply banking products, fund transfer, and personal loan with fast approval process.  

The Challenges

Since it’s the 1st time this kind of service available in Thailand, the business is very challenging since no one has background before and have to learn together along with customer. The datawarehouse will store all transactions ranging from Savings Accounts, Special Rate Accounts, Debit Cards and Credit Line (personal loan). The data will allow new business to identify more opportunities and better service to serve customers. 

Our Solution

  • IBM Information Suite – DataStage
  • MS SQL Enterprise
Big Data for Major Telco

The Client

A major internet service provider and mobile operator in Thailand, with largest cable TV network and subscriber base.

The Challenges

Our client have more than 3000 distribution agents across the country. Traditional reporting and tracking project has been time consuming and, as a result of manual reconciliation, incoming figures are not consistent.

We helped our client implement enterprise data warehouse, data mart, and near realtime dashboards for tracking Telesales Agent ‘s performance. We designed a completely new real time ETL framework that greatly improved the productivity day to day operation and business analytics, helping our clients free up valuable time to focus on business execution.

Our Solution

  • Cloudera
  • Exadata
  • Informatica
  • Tableau
Analytics for Insurance using retail shopping transactions

The Client

One of the largest internation insurance company.

The Challenges

Our client asked us to help analyzing retail shopping transaction to find linkage between propensity to buy insurance versus shopping data. From some sample data we received, we able to find a way to improve selling insurance by utilizing shopping data using some statistic to predict the patterns. 

Our Solution

  • R language
EDW and BI Implementation for Bangkok Mass Transit

The Client

The largest smartcard system in Thailand processing millions of retail and rail transit transations. 

The Challenges

Due to the fast-paced nature of our client business, we were consulted to provide a solution that can fulfil high-performance, near-realtime analytics capabilities on very large dataset consisting of millions of retail and transit transactions per day. The challenge is to be able to analyze the consumer behaviour quickly and disemminate the reports across business teams and stations quickly.

We help our clients implement the end-to-end stack for Netezza PureData for Analytics, which one of the best datawarehouse with analytics capability, alongside IBM Information Suite for ETL processing with Cognos 11 reporting for distribution to business executives and businesses. With our long standing experience in datawarehouse, we employed our proven ETL framework and custom tools to gather from sources, stage, collect, cleanse and tranform to data marts.

Our Solution

  • IBM Netezza
  • IBM Information Suite – DataStage
  • IBM Cognos
Datawarehouse Transformation for Major Commercial Bank

The Client

Thailand’s largest banks in terms of market capitalization and third-largest measured by asset size, providing a full range of financial services that include corporate and personal lending, retail and wholesale banking, foreign currency operations, international trade financing, cash management, custodial services, credit and charge card services and investment banking services.

The Challenges

This project was initiated to satisfy two main objectives. First, to customize, integrate and support the complex analytic applications for data across various business units. Second, to increase support functions as diverse as personalized customer relationship management and marketing programs, credit risk management strategies and financial analysis and reporting, as well as improved operational efficiencies that will result in helping reduce operating costs.

We extracted and transfer all critical data from various legacy systems across bank’s various business units consolidating them into the centralized Teradata EDW platform. The value delivered to our business is improved productivity and efficiency with a single view of business, enabling decision-makers to leverage integrated data from across the enterprise to make mission-critical analyses and decisions.

In another project, a new Azure Datalake has been introduced to serve new requirements and enhance capabilities of data. 

Our Solution

  • Teradata
  • IBM DataStage
  • Oracle Data Integrator
  • Azure Platform
  • Databricks
  • PowerBI
  • SAP BO
Datawarehouse Transformation for Major Telco

The Client

A leading telecommunication services providers in Thailand with the widest coverage nationwide and allocade of the best mobile operator for consecutive years.

The Challenges

This project was initiated to fulfill four main objectives. First, define and prioritize the business and functional requirements of the new EDW. Second, identify the source data. Third, to customize the Teradata Communications Logical Data Model based on the requirements, And fourth, design and implement the high level solution architecture.

For this mission-critical EDW transformation project, the client selected us as the program partner who manages all business activities and implementation delivery of the datawarehouse. We conducted workshops with source owners to understand the origins, designed the ETL framework with extensive data quality check and cleansing protocols, and integration into clients existing Physical Data Model via the Teradata Communications Framework.

Our Solution

  • Teradata
  • IBM Information Suite – DataStage
  • Oracle Data Integrator
  • SAP Business Objective(BO)
  • SAP Crystal Repor
EDW Transformation for Major Banking Group

The Client

A major banking group in Thailand and one of the largest in terms of loans and deposits providing a full range of services to wealth, commercial and individual customers.

The Challenges

Our client is embarking on a journey to modernize their datawarehouse in line with their enterprise IT enhancement foundation initiative. They have chosen us to be prime provider in this initiative. We managed the large scale object migration from various source systems which has a variety nature into the new FSLDM framework. In addition, we also designed and developed a datawarehouse and datamart layer for business users.

Overall, the business team gained improved access to enterprise data in a single platform with 360 degree information view. The operations, on the other hand, benefit from our ETL framework that serves as the foundation to map new data sources, stage, collect, cleanse and tranform to data marts moving forward.

Our Solution

  • Teradata
  • IBM Information Suite – DataStage
EDW Replacement Project From Regional Banking Group in APAC

The Client

A regional banking group in Southeast Asia headquarted in Malaysia with long-standing presence in the Thailand market, offering consumer banking, investment banking, Islamic banking, asset management and insurance products and services.

The Challenges

Our client initiated a stategic program to enhance Thailand’s Data Warehouse in order to align with the replacement of core banking system under the Regional 1-Platform project. Hence, the Thailand Data Warehouse architecture needs to be redesigned, modified, and enhanced corresponding to the new core banking system. The business requirement includes sensitive and business critical information such as account number structure and its nature, change in CIF number structure, as well as changes in business concepts and data structure.

For this transformation that take place in the Thailand headquarters, we are chosen as the only partner to provided end-to-end process execution for Data Warehouse system enhancement – revise all interface files from all source systems, redesign model, business and technical data mapping, modify/ new develop ETL process and architecture. Comprehensive analysis of system transition Data Warehouse’s ETL-OUT process modification for RALM system.

Our Solution

  • IBM Information Suite – DataStage
  • Oracle DW
  • Unix Shell Script
DW Operational Improvement for Regional Insurance

The Client

A regional IT development and shared services hub for the parent insurance provider company, which is the largest in Asia Pacific.  

The Challenges

One of the key initiatives to be undertaken by the shared service hub is the regional rollout of 4 key business applications. Our client have the pressing need to optimize application performance to provide users with on-time delivery of information as well as optimal performance when accessing information.

As part of this initiative, we were consulted to review the ETL architecture for these systems and develop the ETL strategy to determine where and how the areas can be streamlined and optimized. Our job scope include review of the Datastage jobs in detail for design optimization, review the DataStage ETL architecture, review the Datastage configuration & parameters
Review of the volumetric loads and ETL data manipulation language (DML) to ensure optimal queries and transformation scripts are written. Our work have enabled a new ETL design to better support on-going ETL needs, ETL strategy, architecture and to optimise existing Datastage jobs 

Our Solution

  • IBM Information Suite – DataStage
  • IBM CDC
  • IBM AS/400
  • IBM DB2

Join to start building
your own Universe?

© Inteltion. All rights reserved.