Imran Sadiq

Cloudera Installation and Administration in Allied Bank, Islamabad, Pakistan

Installing CDP Private Cloud and build data lakehouse in Allied Bank
Maintenance of Data Lake Administration, Access, Security, Backups, Patches, etc.
Managing and setting compression of the storage.
Hands-on working in Cluster expansion activities for node addition and re-commission and decommission of nodes from cluster in case of disk hardware and volume failures.

MAF-UAE Migration on-premises to Azure remotely working with Predicagroup - Poland

Analysis of existing Sources and in House DWH
Migration of existing SSIS packages and SQL Server Databases to Azure Cloud
Migration Plan and strategy through Azure Migrate, DMA and Self hosted VM for SSIS, Azure Synapse Analytics for Pipeline and Runtime Integration for SSIS.
Reverse Engineering of TimeXtender ETL packages and creating Mapping Doc and find business rule.
TimeXtender with Azure Synapse Analytics

BI Reporting for Commercial Bank of Dubai using ADF and Azure Synapse Analytics

Access and Migrating On premise databases to Azure Data Lake using Azure Data factory
Create dynamic Pipelines in ADF to Extract and Transform the data to azure synapse analytics and load data into different sources like Azure SQL, Blob storage, Azure Synapse.
Extract, Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL and Azure Data Lake Analytics.
Hands-on experience on developing SQL Stored procedure and Create schedule triggers for pipelines.
Hands on experience on implementing the SCD type 1, SCD type 2 in ADF & azure synapse.

Huawei Hybrid Cloud CMPAK Telco, Islamabad, Pakistan

Big Data and Analytic for Bank HBL, Islamabad, Pakistan

Data Analysis of core banking system Misys Equation for Data Modeling and Profiling
Dashboard Analysis: HBL NTB Tracker, Current Accounts Averages CA dashboard, Rural Banking dashboard
Identification of field in source system and monitor availability of data
Developed Component wise test queries & data reconciliation from latest business dashboard
Identification of field/business names in cube interfaces post cube development
Ingest Data through SSIS ELT tool from RAW Zone to Refine Zone and to Presentation Layer
Create Data Warehouse Model and Mapping of these business areas from Core Banking System-Misys.

Collateral, Biometric, PA Portfolio and Transaction Account Stat, Konnect BB

Collateral ETL development in Impala for Raw Zone, Refine Zone and Presentation Layer
Data Analysis & Profiling of Konnect BB sources in Informatica IDQ
Worked on HBL DWH operations for data loading and ETL batch optimization

Big Data and Temenos T24 for Bank Alfalah, Islamabad, Pakistan

Internal Report rationalization, Field level analysis based on reports
Data reconciliation as per current Teradata extraction and migrate existing Teradata reports to T24
Developed reports in Temenos T24 for Premier Banking, Treasury, Finance, Bank at work
Build data lakehouse with Hadoop raw zone, refine zone and presentation layer
User profile in ranger Ac, in ambari and in Linux

Recommendation Engine, Artilytics, Karachi, Pakistan

About