Asad Ali Email & Phone Number

Riyadh, Saudi Arabia

• Enhancements in RAC current Flights DWH and ETL processes using Microsoft SSIS and SQL Server. • Reconciliation of Data Pipelines • Migration of Traditional Sql Server Data warehouse to Microsoft Azure using Data Lake, and Data Factory. • Advance Transformations/Business Insights on Microsoft Databricks using Spark. • Requirement gathering from business user to develop End to End business use cases. • Responsible for Technical and business UAT process. •… Show more • Enhancements in RAC current Flights DWH and ETL processes using Microsoft SSIS and SQL Server. • Reconciliation of Data Pipelines • Migration of Traditional Sql Server Data warehouse to Microsoft Azure using Data Lake, and Data Factory. • Advance Transformations/Business Insights on Microsoft Databricks using Spark. • Requirement gathering from business user to develop End to End business use cases. • Responsible for Technical and business UAT process. • Collaborations with BI Team for Data reconciliation between DWH and PowerBI Reports/Dashboards. Show less

Lahore, Punjab, Pakistan

••••••••••Client: Allied Bank Limited••••••••••• Developing data pipelines from the raw data zone to the staging area.• Optimization of current pipelines.• Evaluating the possibility of migrating all data for reconciliation.• Working on Spark for ETL tasks and wokring on issues related to reconciliation failures using Spark.

Islāmābād, Pakistan

••••••••••Client: Explore AI••••••••••• Implemented and optimized data processing pipelines using Azure Databricks.• Working on Medallion Architecture.• Designed and orchestrated data workflows and ETL pipelines using Azure Data Factory.• Extracted data from various sources, performed transformations, and loaded data into target destinations.• Implemented data movement and data transformation activities using Azure Data Factory pipelines.• Scheduled and monitored… Show more ••••••••••Client: Explore AI••••••••••• Implemented and optimized data processing pipelines using Azure Databricks.• Working on Medallion Architecture.• Designed and orchestrated data workflows and ETL pipelines using Azure Data Factory.• Extracted data from various sources, performed transformations, and loaded data into target destinations.• Implemented data movement and data transformation activities using Azure Data Factory pipelines.• Scheduled and monitored data pipeline executions for reliable and timely data integration.• Managed source code repositories, branch policies, and code reviews within Azure Repos.• Utilized Azure Boards for efficient project management and agile workflows.• Created and maintained user stories, tasks, and backlog items to track project progress. Show less

Islāmābād, Pakistan

••••••••••Client: Majid Al Futtaim Group Dubai••••••••••• 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 tool to analyze the current architecture.

Islāmābād, Pakistan

••••••••••Commercial Bank of Dubai••••••••••• Access and Migrating On premise databases to Azure Data Lake using Azure Data factory• Create dynamic Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract and Transform the data to azure synapse analytics and load data into different sources like Azure SQL, Blob storage, Azure SQL Data warehouse.• Extract, Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data… Show more ••••••••••Commercial Bank of Dubai••••••••••• Access and Migrating On premise databases to Azure Data Lake using Azure Data factory• Create dynamic Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract and Transform the data to azure synapse analytics and load data into different sources like Azure SQL, Blob storage, Azure SQL Data warehouse.• 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.• Create schedule triggers for pipelines.• Implemented the SCD type 1, SCD type 2 in ADF, azure synapse. Improve the data ingestion time. Show less

Islāmābād, Pakistan

••••••••••Client: Zong CMPAK••••••••••• Migration of RAC from Teradata to Huawei Cloud stack online at CMPAK. • Data Warehousing service (GaussDB) for RAC.• Create ETL pipelines using DGC CDM service to Stage data on Staging Layer. And transforms data on process layer and then generate the summary data for reporting.• Data Integration using Data Studio.• Create relational and dimension data model for RAC and DPI use cases.

• Developed procedures and scripts for data migrations.• Development of high-quality database solutions.• Build appropriate and useful reporting deliverables.• Build paginating reports in Power BI Report Builder.

Islamabad, Islāmābād, Pakistan

• Managed each project’s scope and timeline.• Coordinated sprints, meetings and coach team members in Agile frameworks.• Worked with product owners and to handle backlogs and new requests.• Designed and implemented end-to-end data solutions on Microsoft Azure platform, leveraging services such as Azure Data Factory, Azure Databricks, and Azure Synapse Analytics.• Developed and maintained complex ETL pipelines to extract, transform, and load data from various sources into Azure… Show more • Managed each project’s scope and timeline.• Coordinated sprints, meetings and coach team members in Agile frameworks.• Worked with product owners and to handle backlogs and new requests.• Designed and implemented end-to-end data solutions on Microsoft Azure platform, leveraging services such as Azure Data Factory, Azure Databricks, and Azure Synapse Analytics.• Developed and maintained complex ETL pipelines to extract, transform, and load data from various sources into Azure DataLake.• Collaborated with cross-functional teams including data scientists and analysts to understand data requirements and provide them with reliable and well-structured datasets.• Collaborated with DevOps teams to deploy, manage, and monitor data solutions using Azure DevOps or similar CI/CD pipelines. Show less

Managed and implemented new features in their currently running and also worked on other client’s projects.

Islamabad

• Implemented core module in their brands app and also added feature to track that how the user is using our app.• Developed directory app for their brands app and also developed an app to view the attendance of the employees in organization.

• Worked on their running app ‘Human Focus’ and resolved all the bugs. Implemented new feature in app i.e Google Analytics and Amazon AWS SDK. Developed database-driven applications. Also worked on their NCCB and ELabel App for ROSPA.

Islamabad, Pakistan

• Worked on their running app “SkyBoss‟ app for an American client. Created an app “Update” from scratch and completed that almost 80%.Implemented Core Data (Sqlite) in their app. Developed database-driven applications.

Bachelors Of Computer Science, Computer Software Engineering

Activities and Societies: Programming Competition

Ics, Computer Science

Activities and Societies: Sports