×
Khairul Fathi

Khairul Fathi

Data Architect

Abu Dhabi, Abu Dhabi, UAE
+971 52 837 4364
Malay, English, Korean

Background


About

About

Results-driven Data Warehouse and Business Intelligence leader with over 14 years of experience in data architecture, integration, and project management within the financial services and banking sectors. Seeking a challenging role as a Senior Data Modeler or Enterprise Data Architect to leverage my expertise in designing and implementing robust data solutions.

Proven track record in directing high-impact projects, including serving as the Data Architect at well-known organizations such as the Central Bank of Malaysia, First Abu Dhabi Bank, and Abu Dhabi Securities Exchange, where I played a pivotal role in a Digital Transformation journey. Known for my ability to drive efficiency, enhance data governance practices, and deliver innovative solutions. Eager to contribute strategic insights and technical acumen to support the continued success of a forward-thinking organization.

Work Experience

Work Experience

  • Senior Data Modeler, Abu Dhabi Securities Exchange (ADX)

    Dec, 2023 - Present

    • Spearhead the design and implementation of robust data models to support enterprise information management, business intelligence, and machine learning initiatives.

    • Collaborate with cross-functional technical teams to ensure seamless integration of functions, identify system enhancements, and deploy new products and process improvements.

    • Work closely with business and solutions teams to translate business needs into effective data strategies, building data flows, and developing conceptual, logical, or physical data models.

    • Act as a bridge between technical and non-technical stakeholders, ensuring alignment with business objectives and data requirements.

    • Analyze source systems comprehensively to understand data structures and intricacies, facilitating the development of accurate and efficient data models.

    • Identify the architecture, infrastructure, and interfaces necessary for data sources, supporting automated data loads, security concerns, analytic models, and data visualization models.

    • Map data sources and targets for data movement, analyzing thoroughly to ensure appropriate integrity and quality of all data.

    • Technologies used: Azure Synapse, Stream Analytics, Azure Event Hub, Azure SQL Server, Power BI, IBM Connect CDC, Postgres, Python

  • Enterprise Data Architect, RHB Bank

    Oct, 2021 - Dec, 20221 year 3 months

    • Spearheaded the development of a comprehensive data architecture framework, aligning it with the overall business strategy of RHB Bank

    • Collaborated with cross-functional teams to ensure that data solutions met the needs of diverse business units

    • Provided strategic guidance and introduced best practices during data sourcing activities, overseeing 35 data sources from both external and internal systems

    • Conducted thorough gap analysis to identify areas for improvement and implemented data sourcing enhancements

    • Effectively articulated trade-offs, benefits, and risks associated with various architecture and design solutions, especially in light of tight project timelines

    • Facilitated informed decision-making by presenting clear analyses and recommendations to project stakeholders

    • Technologies used: Cloudera Hadoop, Qlik Replicate, Java, Dataiku

  • Senior Data Architect, Standard Chartered Bank

    Oct, 2020 - Sep, 20211 year

    • Operate as data architect for Application-Infrastructure Vulnerabilities Management (AIVM) project overseeing end-to-end data management lifecycle

    • Provide guidance and introduce best practices during data sourcing activities which consist of 35 data sources from external and internal systems

    • Articulate the trade-offs, benefits, and risks of all architecture and design solutions given a tight project timeline

    • Delivered MVP of data engineering solution, assigning vulnerabilities scanned from Qualys to the respective remediation domain owner. This MVP increased operational efficiency, achieving the same outcome in 10 minutes instead of 16 manhours from manual works

    • Technologies used: Cloudera Hadoop, Python, Dataiku, Microstrategy

  • Data Architect, First Abu Dhabi Bank (FAB)

    Sep, 2019 - Aug, 20201 year

    • Translation of business requirements from internal stakeholders in high quality Data Design

    • Gap analysis between the requirements and the existing capabilities

    • Working with teams in the development and maintenance of the Enterprise Data Model (EDM)

    • Engage with projects to support new requirements and ensure they are reflected in the EDM

    • Adhering to data governance practices and standards

    • Provide effective delivery within timelines of the project / initiative

    • Technologies used: Amazon Web Services, Power BI, Oracle Database, Kong, Python

  • Data Architect, Central Bank of Malaysia (BNM)

    Jan, 2018 - Nov, 20191 year 11 months

    • Serve as technical consultant for Data Science and Analytics initiative that will leverage on Hadoop for next-generation analytical works

    • Drafted and presented paper on Data Analytics in EMEAP Meeting, Apr 2017 – Singapore, sharing new ideas with EMEAP members

    • Recommend implementation of Open API to kick-start adoption industry-wide and promote innovation culture

    • Act as technical lead for Centralized Development Environment/CDE that leverages hybrid cloud approach

    • Develop and introduce new IT Strategy and containerization technology to enable as-a-service model in CDE and expand CDE usage to accommodate Big Data and Open API initiative requirements

    • Deliver advice to line department on big-data platform for Data Science and Analytics initiative usage

    • Offer guidance to line department for implementation of Basel Committee on Banking Supervision regulation number 239,BCBS 239, to replace existing MIS policy

  • Senior Solution Architect (DWH/BI), Central Bank of Malaysia (BNM)

    Jan, 2015 - Jul, 20183 years 7 months

    • Operate as lead data integration architect for ISS Project, overseeing end-to-end integration from submission, data warehouse, data mart until dissemination portal

    • Function as lead solution architect for ISS Project Phase 3 implementation that focuses on Credit subject area; other subject areas covered under Phase 1 and 2 are Financial, External Sector, Basel, RWCAF, Macroeconomics, Intermediaries, Insurance and Entity database

    • Design and introduce best integration design practice during Phase 1 optimization project that improves efficiency by 400%, includes, push down approach to have heavy load at database; database fine tuning using optimum degree of parallelism, appropriate indices and partitions; resiliency in design for operational efficiency; and distribute load by capturing hourly changes and update daily summary table for monthly data release

    • Other key activities completed:

      • Data profiling on few legacy systems being used since 1994
      • Data cleansing and mapping for data migration purposes from legacy systems that contain several time series
      • Evaluation on potential tools and solutions to meet BNM’s critical requirements such as real-time data replication between different type of databases
      • Connect and engage with top management during Project Steering Committee meetings for critical decisions and discussions
    • Technologies used: SQL Server, Oracle Database, Microsoft SSRS, Microsot SSIS, Microsoft SSAS, IBM TM1, IBM DB2/400, Qlik Replicate

  • Senior Software Engineer, Censof Berhad

    Jul, 2011 - Dec, 20132 years 6 months

    • Directed team of five to provide third- level support for company flagship product Century Financial

    • Managed end-to-end numerous Business Intelligence and Reporting sub-projects and implemented using QlikView and Jitterbit

    • Acquired knowledge of accounting and financial processes such as Account Payable, Receivable, Procurement, Budget, and Cash Management

    • Notable and high-profile clients: Inland Revenue Board (IRB); Companies Commission of Malaysia (CCM), and Social Security Organization (SOCSO)

  • ETL Developer, Silverlake Business Intelligence

    Aug, 2008 - Jun, 20112 years 11 months

    • Devised, developed, and implemented ETL processes and OLAP multidimensional cube using Microsoft technology

    • Specialized in database design and fine tuning to achieve tight business SLA

    • Contributed to system and user documentation

    • Notable clients and projects:

      • Bank Islam Malaysia Berhad (BIMB) – CCRIS, FISS, MIS, PIDM
      • OSK Investment Bank – CCRIS
      • Affin Bank – CCRIS
      • People’s Bank of Sri Lanka – MIS, Budget
      • Bank of Mandiri, Jakarta – MIS
Skills

Skills

  • Data Management

    Data Architecture

    Data Modeling

    Data Engineering

    Data Visualization

    Data Governance

    Data Quality

  • Database Design

    Oracle

    SQL Server

    Postgres

    MySQL

    IBM DB2

  • Programming

    Python

    PHP

    Bash

    Shell

    T-SQL

    PL/SQL

  • Data Visualization

    Power BI

    Tableau

    Microstrategy

    D3.js

  • Data Engineering

    Python

    Talend

    Microsoft SSIS

    Dataiku

  • Cloud Services

    Azure

    Amazon Web Services (AWS)

Education

Education

  • Computer Engineering, Bachelor's Degree, Hanyang University, South Korea

    Jan, 2006 - Feb, 2008

  • Business Intelligence and Analytics, Master's Degree, International Islamic University of Malaysia, Malaysia

    Sep, 2018 - Mar, 2020

  • Data Anlytics, PhD, Universiti Malaya, Malaysia

    Feb, 2022 - Jan, 2026