Zishan Jamil

<p>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<br>
Designed Source-to-Target Mappings (STM) and transformation logic aligned with Financial Services Logical Data Model (FSLDM) across Cortex and reporting layers<br>
Developed complex SQL-based data processing, validation, and reconciliation logic, ensuring high-quality data flow across Cortex to Teradata to Tableau BI<br>
Implemented data quality frameworks, including validation checks, profiling, and anomaly detection to ensure consistency across upstream and downstream systems<br>
Supported data lineage tracking and metadata documentation, enabling traceability of data flows across Cards, Payments, and reporting layers<br>
Ensured data privacy and access controls by applying role-based access and compliance with enterprise data governance standards</p>

<p>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<br>
Designed and deployed Power BI dashboards with automated refresh, enabling real-time KPI tracking across engineering, procurement, and project management teams<br>
Implemented role-based access management (RBAC) and data security controls, ensuring controlled data visibility for different departments and stakeholders<br>
Established data quality frameworks including validation checks, data profiling, and reconciliation to ensure accuracy and consistency across integrated datasets<br>
Maintained data lineage and documentation, enabling traceability of data flows from source systems (Excel/SQL) to Power BI dashboards<br>
Ensured data privacy and governance compliance by applying access controls and managing sensitive project and financial data</p>

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

<p>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<br>
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<br>
created multiple ad-hoc reports for to target different merchant groups and analyzing customer behavior through different gateway channels<br>
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</p>

<p>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)<br>
Integrated SAC with SAP S/4HANA and external data sources, consolidating data across departments into a centralized reporting layer<br>
Implemented role-based access control (RBAC) to ensure secure, department-specific data visibility and compliance with data governance standards</p>

<p>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<br>
Developed BI dashboards and reports to track campaign performance, client activity, and revenue trends across retail (RBWM) and corporate (CIB) portfolios<br>
Conducted deep-dive analysis on customer lifecycle, journey mapping, and lifetime value (LTV) using structured SAP BW data models<br>
Supported ETL and reporting workflows within SAP BW/BI, ensuring accurate, governed, and timely data availability for business stakeholder</p>

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