Summary
Overview
Work History
Education
Skills
Certification
Technologies And Skills
Timeline
Generic

Safee Ullah Saleem

Senior Consultant - Data Analytics
Rawalpindi, Punjab

Summary

Experienced in designing, implementing, and optimizing data warehousing solutions to meet complex business needs. Skilled in data integration, transformation, and management, ensuring high data quality and consistency. Developed and deployed ETL packages for data migration and integration, supporting seamless data workflows using tools such as Informatica PowerCenter, Informatica BDM and Microsoft SSIS. Skilled in executing and optimizing SQL queries on large datasets, enhancing data processing performance. Experienced in managing data integration and processing within Huawei Cloud environments. Demonstrated expertise in managing and optimizing large-scale databases, including Teradata, HDFS, and SQL Server. Proficient in writing complex queries and managing relational databases, ensuring efficient data retrieval and manipulation. Adept at understanding client needs and delivering customized data solutions that respond to evolving business requirements. Conducted detailed external system analysis to gather and transmit critical information, supporting informed decision-making. Excel at understanding and adapting to changing business requirements, delivering tailored solutions that drive business success. Ability to communicate complex technical concepts to non-technical stakeholders, ensuring project goals are aligned and met effectively. Committed to staying updated with the latest industry trends, bringing innovative and effective solutions to every project. Familiar with Snowflake database concepts, including its cloud-native architecture, separation of storage and compute, and support for structured and semi-structured data. Understand key features such as elastic scalability, secure data sharing, time travel for historical data access.

Experienced with building and maintaining data pipelines to ensure seamless data flow. Utilizes advanced knowledge of big data technologies to drive data-driven decision-making. Track record of enhancing data architecture for improved performance and reliability.

Overview

5
5
Certifications

Work History

Senior Data Engineer - Consultant

Abu Dhabi Islamic Bank
  • Engaged with stakeholders from ADIB Investment Banking Group (IBG) to evaluate project progress and identify any potential blockers. This involved regular communication and collaboration to ensure alignment with client expectations and project objectives.
  • Utilized Informatica BDM to ingest data from multiple sources into the Data Lake. This process required a thorough understanding of data integration techniques and the ability to manage diverse data formats effectively.
  • Tasked with designing optimal solutions for developing data pipelines that align with specific business needs. This involved analyzing requirements, selecting appropriate technologies, and implementing best practices to ensure efficient data flow and processing.
  • Developed dynamic mappings to facilitate the loading of data into the staging layer. This required a deep understanding of data transformation processes and the ability to create flexible mappings that adapt to varying data inputs.
  • Participated in enhancing existing solutions already deployed in production. This included analyzing user feedback, identifying areas for improvement, and implementing changes to enhance functionality and performance.
  • Worked on preparing views to meet the data requirements for reports developed in Microsoft Power BI. This involved incorporating necessary transformation logic within views created in Impala, ensuring that the data presented was accurate and relevant for business analysis.
  • Responsible for the preparation of release packages, which included assembling all required artifacts and obtaining necessary approvals on documentation. This ensured that all components were ready for deployment and met organizational standards.
  • Collaborated closely with the team to ensure that delivered work met client requirements and adhered to established quality checks and development standards. This commitment to quality assurance helped maintain high levels of client satisfaction and project success.
  • Environment: Cloudera, HDFS, Impala, Informatica BDM

Data Engineer - Consultant

United Bank Limited
  • Facilitated weekly meetings with clients from IBM and UBL to discuss and review design changes. These engagements provided a platform for gathering feedback, addressing concerns, and ensuring that the design aligns with client expectations and project goals.
  • Led the development of Extract, Transform, Load (ETL) processes using Informatica BDM. This involved designing workflows that efficiently extract data from various sources, transform it to meet business requirements, and load it into target systems.
  • Focused on the continuous improvement and optimization of ETL processes. This included assessing existing workflows, identifying bottlenecks, and integrating new ETL solutions into the current architecture to enhance performance and scalability.
  • Managed the deployment and monitoring of applications through Informatica Administrator. This responsibility entailed ensuring that applications were deployed successfully, monitoring their performance, and troubleshooting any issues that arose post-deployment.
  • Engaged in data warehousing initiatives utilizing Teradata. This involved designing and implementing data models that support business intelligence and analytics, ensuring data integrity, and optimizing query performance for end-users.
  • Designed and finalized release packages to be presented to clients for User Acceptance Testing (UAT). This process required meticulous attention to detail to ensure that all components met client specifications and were ready for rigorous testing.
  • Actively addressed bugs reported by the testing team, working in parallel to ensure timely resolution of issues. This involved analyzing the root causes of bugs, implementing fixes, and validating changes to maintain the quality of deliverables.
  • Provided system understanding and domain knowledge to new team members. This included conducting training sessions and mentoring to ensure that new joiners were well-equipped to contribute effectively to the team’s objectives.
  • Environment: Informatica BDM, TeraData SQL Utilities

Data Engineer - Consultant

Datamatics Private Limited
  • Created a revenue assurance audit model that presents a concise comparison between unmediated traffic from GGSN and post-mediated traffic in OCS, unmediated traffic from SMSC versus post-mediated traffic in OCS, and unmediated traffic from MSC compared to post-mediated traffic in OCS.
  • Conducted collaborative discussions with clients to articulate and refine the elements of the ETL architecture.
  • Executed data analysis tasks to formulate jobs and mapping strategies.
  • Established end-to-end workflows utilizing Huawei Cloud DGC.
  • Developed shell scripts, SQL scripts, and Huawei Cloud ETL jobs encompassing the entire cycle from file loading to the summary layer.
  • Assessed data quality and mapped sources such as GGSN, SMSC, MSC, and OCS (Prepaid/Postpaid).
  • Environment: Huawei DGC, PostgreSQL, Shell Scripting

Data Engineer - Consultant

Datamatics Private Limited
  • Requirement analysis, Customer interaction for requirement clarifications.
  • Design and implement robust ETL (Extract, Transform, Load) workflows using SQL Server Integration Services (SSIS) to efficiently manage and transform data across systems.
  • Writing queries and procedures in MS SQL Server.
  • Data Validation against different testing scenarios.
  • Actively part of a team responsible for development of mapping specifications and Source-to-Target mappings, using SSIS and SQL to enhance ETL processes.
  • Devised ETL process workflows and data-flows that catered to various file structures and business processes.
  • Participated in providing post deployment support.
  • Environment: MS SQL Server, SSIS

Data Engineer - Consultant

Datamatics Private Limited
  • Analysis of existing EDW (FSLDM 13), and migration to FSLDM 16.
  • Understanding underline sources.
  • Understanding existing ETL implementation.
  • Reverse engineering of CORE SMX for scope finalization.
  • Development of SCD type 0 - History Handling (SCD type 1 and SCD type 2).
  • ETL Design & Development of newly purposed FSLDM 16 on Informatica PowerCenter.
  • Implemented Informatica Data Quality (IDQ) solutions to improve data accuracy, consistency, and reliability across various subject areas.
  • Conducted external system analysis to gather and transmit critical information.
  • Leveraged Informatica Data Quality (IDQ) to define, cleanse, and deduplicate data, ensuring high standards of data integrity and accuracy.
  • Transformed Teradata BTEQ scripts into Informatica workflows, encompassing a range of functionalities from simple to complex. A key achievement was developing an Informatica mapping to handle 23 distinct SCD2 scenarios, ensuring robust and efficient data processing.
  • Environment: Informatica PowerCenter, TeraData Utilities

Data Engineer - Consultant

Convergent Business Technologies
  • Provided assistance for up to level 2, for ETL batch monitoring, ensuring smooth data extraction, transformation, and loading processes.
  • Furthermore, deliver extensive assistance for Database Administration (DBA) and Backup and Recovery (BAR) operations within the ETL framework. This includes proficient management of job creation, scheduling, and retirement for backup and restore tasks, ensuring seamless data flow and system reliability.

Data Engineer - Consultant

Convergent Business Technologies
  • Managed the development and upkeep of ETL workflows and mappings using Informatica PowerCenter, facilitating the extraction, transformation, and loading of telecommunications data from various origins into data warehousing systems.
  • Collaborated closely with cross-functional teams, including database administrators, business analysts, and developers, to conceptualize and deploy scalable and efficient ETL solutions.
  • Performed thorough data analysis and profiling to pinpoint data quality issues, implementing cleansing and enrichment strategies to enhance data accuracy.
  • Offered comprehensive production support and troubleshooting for ETL jobs, swiftly resolving issues to minimize downtime and ensure uninterrupted data availability.
  • Thoroughly documented technical specifications, design documents, and operational procedures for ETL processes and workflows, ensuring clarity and consistency.

Education

Master's - Computer Science

Virtual University of Pakistan
Islamabad, Pakistan

Skills

  • Informatica PowerCenter

  • Informatica Developer

  • Apache Impala

  • Teradata

  • SQL

  • PostgreSQL

  • Windows

  • Linux

  • MS SQL Server

  • MYSQL

  • HDFS

  • SnowFlake

ETL development

Advanced SQL

Data warehousing

Data integration

SQL programming

SQL and databases

Certification

Informatica IDMC – PC MOD Foundation Certification

Technologies And Skills

Informatica PowerCenter, Informatica Developer, Apache Impala, Teradata, SQL, PostgreSQL, Windows, Linux, MS SQL Server, MYSQL, HDFS, SnowFlake

Timeline

Data Engineer - Consultant

United Bank Limited

Data Engineer - Consultant

Datamatics Private Limited

Data Engineer - Consultant

Datamatics Private Limited

Data Engineer - Consultant

Datamatics Private Limited

Data Engineer - Consultant

Convergent Business Technologies

Data Engineer - Consultant

Convergent Business Technologies

Senior Data Engineer - Consultant

Abu Dhabi Islamic Bank

Master's - Computer Science

Virtual University of Pakistan

Similar Profiles

  • Hiba Al-Asmar

    Hiba Al-AsmarHiba Al-Asmar

    Operations Officer → Sr. Operations Officer → Documentation Specialist at Abu Dhabi Islamic Bank (ADIB)Operations Officer → Sr. Operations Officer → Documentation Specialist at Abu Dhabi Islamic Bank (ADIB)

  • Mohamed Hady Abdulrazak

    Mohamed Hady AbdulrazakMohamed Hady Abdulrazak

    Salse officer at Abu Dhabi Islamic BankSalse officer at Abu Dhabi Islamic Bank

  • AHMED LAHLOUB

    AHMED LAHLOUBAHMED LAHLOUB

    Team Leader Auto Finance at Abu Dhabi Islamic Bank (ADIB) Direct Sales Unit Auto FinanceTeam Leader Auto Finance at Abu Dhabi Islamic Bank (ADIB) Direct Sales Unit Auto Finance

  • Muhammad Azeem

    Muhammad AzeemMuhammad Azeem

    Refrigeration Incharge (Ammonia Plant) at Afaq Ul Gaza Horizon Food Company | Dammam, KSARefrigeration Incharge (Ammonia Plant) at Afaq Ul Gaza Horizon Food Company | Dammam, KSA

  • Zahin Alwa

    Zahin AlwaZahin Alwa

    Head of Technology at IION Digital Pty. Ltd.Head of Technology at IION Digital Pty. Ltd.

CREATE PROFILE
Safee Ullah SaleemSenior Consultant - Data Analytics