Muhammad Adil

Experience

• 

  COMSATS Software Solutions

  May 2019 - Jun 2020

  Android Developer

  Trainee

• 

  Allied Bank Limited

  Jun 2021 - Apr 2024

  As a Data Architecture at Allied Bank, I am leading the design and implementation of data systems that drive strategic insights and operational efficiency. I specialize in building and optimizing data pipelines, integrating diverse data sources, and ensuring data quality across the organization. My expertise in Oracle SQL, PL/SQL, Big Data Analytics, Hadoop, and Cloudera Manager allows me to architect scalable solutions that support business growth. With a strong focus on ETL process development, I create efficient, automated workflows that ensure seamless data extraction, transformation, and loading to support business intelligence and reporting needs.I work closely with cross-functional teams to maintain robust data warehouses, ensuring seamless access to data for business intelligence and reporting needs. My focus on performance tuning, efficient query execution, and data optimization ensures that the bank’s data systems are both high-performing and aligned with regulatory standards. I am committed to driving innovation and transformation in data management, helping Allied Bank leverage data to achieve its strategic objectives. Show less Officer, Data Integration (Digital Business, Analytics & AI) 4th Floor, Information Technology GroupResponsible for managing and optimizing data within the Centralized Data Base (CDB) following data integration and architecture processes. Focused on developing and overseeing ETL processes to ensure seamless data flow and transformation. Expertise in technologies such as Oracle, MySQL, Big Data Analytics and ETL to integrate, process, and analyze large datasets effectively. Collaborating with cross-functional teams to drive digital business solutions, enhance analytics capabilities, and leverage AI to support business intelligence and decision-making. Show less

  • Senior Officer Data Architecture

    Nov 2023 - Apr 2024

  • Senior Officer Data Integration

    Jan 2023 - Nov 2023

  • Officer Data Integration

    Jun 2021 - Jan 2023
• 

  Softech Systems (Pvt.) Limited

  Apr 2024 - Nov 2024

  Senior Data Engineer

  PSX Compliance Reports Development (Backconnect Application)Brokerage Houses: Summit Bank, Alfalah Bank, JS Bank, Zafar Securities etcDeveloped 20+ (Pakistan Stock Exchange) PSX Compliance Reports for brokerage houses using oracle forms & Report builder in the Backconnect application, adhering to the specific formats provided by PSX.Collaborated with internal teams and clients to meet regulatory standards, utilizing PL/SQL to deliver efficient and compliant solutions.

• 

  MCB Bank Limited

  Nov 2024 - now

  Senior Officer System Development

  Senior Officer, System Development MCB Bank LimitedAs a Senior Officer in System Development at MCB Bank, I am responsible for designing, developing, and managing ETL processes using SQL Server Integration Services (SSIS) to streamline data extraction, transformation, and loading workflows. My role focuses on maintaining and optimizing databases to ensure data integrity, performance, and accessibility across various business functions.Key responsibilities include:- Developing and maintaining ETL solutions using SSIS to integrate data from multiple sources into the bank’s data warehouse.- Ensuring data quality, accuracy, and consistency across all systems by implementing best practices for data management and optimization.- Managing database performance, conducting regular health checks, and tuning queries for efficiency.- Collaborating with internal teams to define system requirements, implement solutions, and troubleshoot issues.- Supporting business intelligence and reporting needs by ensuring data is readily available and properly structured for analysis.- Staying updated with the latest database technologies and trends to ensure systems are modern, scalable, and aligned with business goals.In this role, I contribute to enhancing data workflows, improving operational efficiency, and ensuring that MCB Bank's data infrastructure supports strategic business decisions. Show less