ABDUL RAFEY

Summary

Detail-oriented and results-driven Data Engineer with extensive hands-on experience in designing and maintaining robust ETL pipelines. Proficient in SQL, IBM DataStage, and IBM Cognos, with a strong background in data warehousing, data modeling, and visualization. Proven track record of solving complex data challenges to empower data-driven decision-making, consistently delivering high-quality insights that drive organizational success. Committed to leveraging technical expertise and analytical skills to enhance data processes and support strategic initiatives.

Overview

year of professional experience

Certification

Work History

Associate Data Engineer

BytezGrid Pvt. Ltd.

02.2024 - 03.2025

Designed and managed complex ETL pipelines using IBM DataStage, consolidating multi-source data for Adamjee Insurance.
Led BI operations using IBM Cognos, ensuring accuracy of daily reports and troubleshooting SQL-based reporting issues.
Built and deployed an interactive Power BI dashboard for tracking client issue resolution, boosting communication transparency.
Regularly utilized Aqua Data Studio for SQL scripting and schema updates to meet evolving business requirements.

Intern Data Analyst

Systems Limited

09.2023 - 11.2023

Developed an Azure Data Factory pipeline to ingest and transform Olympic Games 2021 data using Apache Spark, and performed analytics using Synapse SQL.
Integrated and cleaned Uber ride-sharing data using Python, loaded to Google BigQuery via MAGE ETL pipeline, and visualized insights through Looker dashboards.

Education

BBA - Business Administration - Marketing and Media

Lahore School of Economics

Lahore

01.2019

Skills

ETL tool proficiency: IBM DataStage, Talend, MAGE, Azure Data Factory
Database management: Vertica, Neo4j, Google BigQuery, SQL Server
Proficient in Python and SQL for data processing
Experience with Power BI, IBM Cognos, and Looker

Cloud platform expertise
ETL development
Data pipeline design
SQL programming