Zishan Jamil

Built and managed ETL pipelines using Informatica PowerCenter integrating data from Cards, Payments, and Core Banking systems into enterprise Data Hub architecture, while coordinating delivery across cross-functional teams
Designed Source-to-Target Mappings (STM) and transformation logic aligned with Financial Services Logical Data Model (FSLDM) across Cortex and reporting layers
Developed complex SQL-based data processing, validation, and reconciliation logic, ensuring high-quality data flow across Cortex to Teradata to Tableau BI
Implemented data quality frameworks, including validation checks, profiling, and anomaly detection to ensure consistency across upstream and downstream systems
Supported data lineage tracking and metadata documentation, enabling traceability of data flows across Cards, Payments, and reporting layers
Ensured data privacy and access controls by applying role-based access and compliance with enterprise data governance standards

Developed end-to-end ETL pipelines using Microsoft stack (Power BI, SQL, Excel-based data models) to integrate project, cost, and operational data across multiple departments
Designed and deployed Power BI dashboards with automated refresh, enabling real-time KPI tracking across engineering, procurement, and project management teams
Implemented role-based access management (RBAC) and data security controls, ensuring controlled data visibility for different departments and stakeholders
Established data quality frameworks including validation checks, data profiling, and reconciliation to ensure accuracy and consistency across integrated datasets
Maintained data lineage and documentation, enabling traceability of data flows from source systems (Excel/SQL) to Power BI dashboards
Ensured data privacy and governance compliance by applying access controls and managing sensitive project and financial data

Developed end-to-end ETL pipelines using Microsoft stack, Designed and deployed Power BI dashboards, Implemented role-based access management and data security controls, Established data quality frameworks, Maintained data lineage and documentation, Ensured data privacy and governance compliance

Created ETL Pipelines in IBM DataStage and Tableau dashboards in accordance with IFRS9 for monitoring risk for SABB Credit Lending Team by tracking past due loans, past due import loans, overdrafts, facilities and incomplete security documents and formulating necessary strategy for minimizing credit risk
Manage the data from Mastercard System in order to analyze the source of funds, transactions, orders, merchants and card schemes on a daily, weekly and monthly basis
created multiple ad-hoc reports for to target different merchant groups and analyzing customer behavior through different gateway channels
Also created an automated data pipeline using Python get request by integrating SABB’s system (Teradata DB) to Mastercard system (MPGS) in order to analyze and share merchant related financial transactions with the Saudi Central Bank

Developed SAP Analytics Cloud (SAC) dashboards for multiple departments including Finance, Operations, Sales, and Supply Chain, enabling unified KPI tracking (revenue, occupancy, cost, and performance)
Integrated SAC with SAP S/4HANA and external data sources, consolidating data across departments into a centralized reporting layer
Implemented role-based access control (RBAC) to ensure secure, department-specific data visibility and compliance with data governance standards

Analyzed customer behavior, segmentation, and multi-channel journeys across RBWM, and CIB datasets using SAP BW/BI, enabling targeted insights for retail and corporate banking segments
Developed BI dashboards and reports to track campaign performance, client activity, and revenue trends across retail (RBWM) and corporate (CIB) portfolios
Conducted deep-dive analysis on customer lifecycle, journey mapping, and lifetime value (LTV) using structured SAP BW data models
Supported ETL and reporting workflows within SAP BW/BI, ensuring accurate, governed, and timely data availability for business stakeholder

Built and managed ETL pipelines using Informatica PowerCenter, Designed Source-to-Target Mappings (STM) and transformation logic, Developed complex SQL-based data processing, validation, and reconciliation logic, Implemented data quality frameworks, Supported data lineage tracking and metadata documentation, Ensured data privacy and access controls