Summary
Overview
Work History
Education
Skills
Certification
Career Highlights
Interests
Timeline
Generic
Liji Sasankan

Liji Sasankan

Lead Data Engineer

Summary

Data professional with 12+ years of Global banking experience, specializing in end-to-end data solutions across Data Engineering, Data Architecture, Data Warehousing, Business Intelligence, and Project Management. Proven track record of delivering successful data initiatives for top-tier banks across regions, including First Abu Dhabi Bank (FAB), First Gulf Bank, Qatar International Islamic Bank, and Lloyds Bank.

Currently serving as a Project Manager at Wipro, leading a team of 10 engineers while also functioning as the Lead Data Engineer for FAB in a strategic outsourcing engagement. At FAB, I’m driving a large-scale Data Warehouse transformation project, migrating from an on-premise Oracle DWH (with ODI-based ETL processes) to a modern Azure Databricks Lakehouse architecture. My role encompasses both technical leadership and delivery management, ensuring scalable, compliant, and high-performing cloud-based data solutions.

Overview

14
14
years of professional experience

Work History

Lead Data Engineer / Data Architect

First Abudhabi Bank
01.2019 - Current
  • Led the strategic transformation of enterprise data architecture by migrating from traditional Oracle-based systems to a cloud-native Databricks lakehouse platform on Azure, improving scalability, agility, and cost-efficiency.
  • Architected and implemented a unified Customer 360 in databricks, integrating data from diverse source systems to deliver a single source of truth for customer analytics and AI-driven decisioning.
  • Designed and developed data pipelines using Apache Spark and Delta Lake in Databricks to support both real-time and batch data processing across banking and analytics domains.
  • Managed large-scale data integrations from PostgreSQL, on-premise, and cloud systems into Oracle DWH using ODI, PL/SQL, SQL Loader, and Unix shell scripting.
  • Implemented SWIFT GPI (Global Payments Innovation) capabilities and integrated international payments modules into the enterprise data platform, supporting end-to-end tracking, reconciliation, and regulatory compliance for cross-border transactions.
  • Enabled secure data sharing with government entities (ADHA, MOPA, SZHP), ensuring data governance, privacy compliance, and technical reliability.
  • Collaborated with data scientists and ML engineers to build robust, curated data layers supporting model development in the AI Innovation Hub.
  • Optimized performance and cost of Databricks workloads via cluster tuning, caching, and data partitioning; tuned complex Oracle SQL and PL/SQL code to enhance ETL efficiency.
  • Implemented Slowly Changing Dimensions (SCD Types 1 & 2) and other advanced DWH concepts; designed scalable star/snowflake schemas handling large datasets.
  • Defined and enforced data governance standards, including data lineage, metadata management, and PII handling in line with enterprise and regulatory policies.
  • Mentored junior engineers and led cross-functional collaboration with business, IT, and analytics teams to deliver high-impact, data-driven solutions.
  • Delivered real-time analytics and dashboarding by integrating streaming data with Power BI and enterprise reporting platforms.

BI and ETL Developer

First Gulf Bank
11.2017 - 12.2018
  • Led OBIEE Reports Migration: Spearheaded the end-to-end migration of reports from legacy FGB and NBAD systems into FAB’s centralized OBIEE platform, ensuring seamless transition and minimal disruption to business operations.
  • Customer De-Duplication & MDM Implementation: Designed and implemented over 10 OBIEE-based de-duplication reports using MDM rules (Name, DOB, Emirates ID, Legal ID, etc.) to help branch users identify existing vs. legacy customers and define onboarding strategies post-merger.
  • Customer 360 Reporting: Developed comprehensive 360-degree customer view reports in OBIEE, consolidating instruments and outstanding balances across both legacy banks for retail and corporate customers.
  • Corporate Data Enablement: Delivered OBIEE reports covering corporate customer details including sanctions, collaterals, and holdings to support risk assessment and business decision-making.
  • Automated Business Alerts: Built and managed automated OBIEE RECON alert systems via email to notify business users of actionable rule-based triggers.
  • Business User Support & Ad-hoc Analysis: Acted as a key Data SME from the Data Warehouse (DHW) team, assisting new business users in understanding data structures, facilitating customized data downloads, and resolving complex ad-hoc data queries across legacy systems.
  • Project : FGB with NBAD migration to FAB

BI Developer and Admin

Central MI
04.2017 - 10.2017
  • Developed End-to-End Financial Reports: Built critical financial reports such as Balance Sheet and Profit & Loss (P&L) from scratch using OBIEE and BI Publisher, enabling accurate and timely reporting for the bank's finance team.
  • Designed and Managed ETL Processes Using ODI and PL/SQL: Created and optimized ETL workflows in Oracle Data Integrator (ODI), incorporating PL/SQL procedures and packages for complex data transformations, validations, and performance tuning.
  • Established Central MI as a Single Source of Truth: Played a key role in building and maintaining the Central MI reporting layer, ensuring it served as a consistent and reliable single source of truth for financial data across the bank.
  • Performed Data Reconciliation and Validation: Conducted thorough data reconciliation between OBIEE reports and source systems (e.g., General Ledger, sub-ledgers), ensuring data integrity and compliance with financial controls.
  • Collaborated with Cross-Functional Stakeholders: Interfaced with Finance, Risk, IT, and Compliance teams to gather business requirements, clarify reporting logic, and validate report outputs, ensuring alignment with business goals.
  • Maintained Technical Documentation and Provided Support: Documented ODI/PLSQL logic, report specifications, and reconciliation procedures; delivered ongoing production support and enhancements based on user feedback and audit requirements.
  • Tools : PL SQL , Unix , OBIEE , ODI

BI Developer and Admin

Hibu
04.2017 - 10.2017
  • Supporting OBIEE applications by monitoring the reports
  • Solving OBIEE reports related issues within stipulated time
  • Trouble shooting the Application related Issues
  • Technologies Used: OBIEE

BI Developer

Qatar International Islamic Bank (QIIB)
07.2015 - 03.2017
  • Understanding the business requirement
  • Acquiring application specific functional knowledge
  • Building RPD
  • Creating OBIEE Dashboards, Analysis and BI Publisher Reports
  • Creating Views necessary for reports
  • Managing Users, groups and security roles in OBIEE
  • Work closely and communicate effectively with client, business users, team and the management
  • Technology: PL SQL, OBIEE

DWH Developer

Lloyds Bank
09.2014 - 04.2015
  • Understanding the functionality and tasks to do by going through the design documents.
  • Developing Various Views and tables in Teradata
  • Experienced in development of Staging and target tables using mapping documents.
  • Experience in making dimension and fact tables.
  • Analyzing defects and finding out the root cause for the issues.
  • Project: DSSL (Downstream System Subscription Layer)

DWH Developer

Lloyds Bank
10.2013 - 08.2014
  • Understanding the functionality and tasks to do by going through the documents.
  • Developing Various Views and tables.
  • Working on loading the data from stage to Target Tables using BTEQ, FAST LOAD and MLOAD scripts.
  • Did data reconciliation, unit testing by various queries.
  • Project: FATCA (Foreign Account Transaction Compliance Act)
  • Technology: Teradata, Mainframe

DWH Developer

Apple Inc.
02.2012 - 09.2013
  • Understanding the business requirement
  • Fetching the data from database according to the customer requirement
  • Building Reports according to customer requirement
  • Project: CMS (Customer Management System)

Education

Master of Technology - Software Engineering

Bits Pilani
04.2001 -

Skills

  • Data Engineering
  • Data Architecture
  • Data Warehousing
  • Data Management
  • Business Intelligence
  • Data Analysis
  • Solution Design
  • Project Management
  • 10 years of deep domain experience in Banking & Financial Services

Certification

Certified Databricks Data Engineer, with hands-on expertise in building cloud-native data pipelines and Lake house solutions.

Career Highlights

  • Successfully delivered data solutions for leading banks across multiple regions including First Abu Dhabi Bank, First Gulf Bank, Qatar International Islamic Bank and Lloyds Banking Group.
  • Extensive experience delivering Lakehouse architectures, Data Warehouses, and Business Intelligence solutions on both cloud (e.g., Azure) and on-premise platforms.
  • Proven track record in owning and delivering large-scale, complex data transformation and integration projects across diverse environments and stakeholder groups.
  • Strong exposure to Retail Banking, Corporate Banking, Islamic Banking, International Payments (SWIFT/SWIFT GPI), Credit Cards, Loans, Internet & Mobile Banking, Customer Experience platforms, and Digital Onboarding systems.
  • Partnered with UAE government agencies such as ADHA, MOPA, and SZHP for end-to-end loan data enablement, analytics development, and BI reporting solutions.
  • Deep understanding of data governance, reporting standards, and compliance frameworks enforced by UAE Central Bank, AECB, and other local regulators.
  • Worked closely with various banking units including Retail, Corporate, Finance, Compliance, and Risk to align data strategies with organizational goals.
  • Well-versed in implementing robust data security controls at table, column, and row levels to ensure compliance with enterprise data governance policies and regulatory requirements.
  • Skilled in designing and implementing effective Master Data Management strategies to ensure data consistency, accuracy, and reliability across systems and business functions.

Interests

Exploring distant lands, Capturing moments

Timeline

Lead Data Engineer / Data Architect

First Abudhabi Bank
01.2019 - Current

BI and ETL Developer

First Gulf Bank
11.2017 - 12.2018

BI Developer and Admin

Central MI
04.2017 - 10.2017

BI Developer and Admin

Hibu
04.2017 - 10.2017

BI Developer

Qatar International Islamic Bank (QIIB)
07.2015 - 03.2017

DWH Developer

Lloyds Bank
09.2014 - 04.2015

DWH Developer

Lloyds Bank
10.2013 - 08.2014

DWH Developer

Apple Inc.
02.2012 - 09.2013

Master of Technology - Software Engineering

Bits Pilani
04.2001 -
Liji SasankanLead Data Engineer