Imran Sadiq

I am a Senior Data Engineer & experience in Banking Industry and Telco. Big data , Data Warehousing, Hadoop, PySpark, Cloudera Administration, Vault Data Modeling WhereScape, Azure Synapse Analytics, Huawei Cloud Gauss DB, GCP, WhereScape and TimeXtender, eCommerce, I have worked on Core banking System Temenos T24 [Bank Alfalah Pakistan] & Misys Equation, Konnect [HBL Bank Pakistan] in data warehouse & Data Lake . Master’s in Software Engineering.

Projects

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

• Analysis of RAC [ Revenue Assurance Controls] developed in Teradata
• Migration of Teradata data warehouse to Huawei Hybrid Cloud Gauss DB
• Migration Plan and strategy and Convert Teradata script to Gauss DB

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

• Developed recommendation engine prototype in R
• ETL Development Life Cycle in oracle
• Business dashboard using power BI

Master in Software Engineering

General: Data Analysis, DWH, Data Lakehouse, SQL Server, Oracle, Ecommerce, Vault Data Modeling & Metadata Management, data governess, Azure Synapse analytics, Huawei Cloud Gauss DB, Cloudera & Hadoop, and Teradata

Data Engineering: SSIS, Impala, Hive, Azure Synapse,GCP BigQuery, AWS, PySpark, Informatica IDQ, Huawei Gauss DB, Mongo db, Scoop, WhereScape, and TimeXtender.

Programming Language: Shell Scripting, Python, R, PHP

BI Tools: Power BI, Tableau