Description

My 8 years of experience as a Data Engineer in delivering high-impact data solutions, including the successful transformation and migration of huge datasets to build robust, scalable data platforms. My track record demonstrates a consistent ability to engineer efficient ETL jobs and manage complex data architectures, ready to contribute from day one.

Throughout my career, particularly during my tenure as a Senior Consultant in Data Analytics, I have spearheaded the end-to-end development of data pipelines on cloud platforms, utilizing PySpark and SQL within Azure Data Bricks environments. This comprehensive experience in distributed data processing, coupled with advanced data modeling techniques, has equipped me to design and implement highly performant solutions for high-volume data requirements, ensuring data integrity and operational efficiency for various stakeholders.

My proficiency extends to designing intricate migration solutions, such as the document attachment migration via API from S3 Bucket to Dataverse, showcasing strong problem solving skills and a practical mindset. While my recent cloud focus has been on Azure, the fundamental principles of building and maintaining scalable data pipelines, optimizing performance, and leveraging advanced SQL and Python skills are universally applicable to production-grade cloud environments. My ability to work independently and deliver critical projects is well-established, making me confident in adapting quickly to new tooling like Google Cloud Platform.

I am eager to apply my extensive data engineering expertise to your client's initiatives. My background in orchestrating complex data transformations and my commitment to robust solution delivery make me a strong candidate to drive value in a dynamic environment.

Industry field of expertise

Languages

English
Native or bilingual

Workplace preferences

Can work on-site

Cardiff (up to 50km)

Systems Limited
Senior Consultant – Data Analytics
January 2022 - February 2026 (4 years and 1 month)
Lahore, Punjab, Pakistan
[Infinity UK - Power BI, Python, SQL, Azure Data Factory (ADF),Azure SQL Server, Connectwise DB, DynamicCRM 365] Developed End to End ETL and Power BI Reports, transformation and migration of Customer Data from Connectwise DB to Dataverse.Automated ETL jobs across a high-volume data and the solution to migrate Attachments Documents via API from S3 Bucket to Dataverse Dubai - Python,Power BI,SQL,KingswaySoft ,SSIS,SQL Server, DynamicCRM365] Developed transformation Pipelines and Power BI dashboards for Giant Healthcare(patient's data) from SQL Server to Dataverse.Developed efficient ETL jobs across a high-volume data.Designed and Developed the solution to migrate Attachments Documents via SOAP APIs from FileSystem to IBM FileNet Dubai)] Built ETL workflows from source to target via SSIS and KingwaySoft.Data Transformations based on dataverse(Dynamic CRM),Build Data Modeling and Data Migration solution [BrightHouse Financials, US - Alteryx,Access DB,Hive] Data Transformation & Migration using Alteryx ETL workflows.Building Pipelines for Data Migration and Developed ETL Processes to automate the process [Vuori Clothing, US] End to End Pipeline Development from Curated to Serving Layers on Azure Platform. Transformation via PySpark and SQL on Azure Data Bricks, Dimensional modeling to build scalable Data warehouse for reporting, Data Visualization via Power BI. Daily Client meeting for Project Discussion
Microsoft Power BI Microsoft Azure ETL SSIS Databricks
AutoSoft Dynamics Pvt. Ltd
ETL Developer
August 2020 - December 2021 (1 year and 4 months)
Lahore, Punjab, Pakistan
Orchestrated the end-to-end design and development of ETL pipelines utilising the Talend ETL tool (Source: SQL Server, Target: Oracle). Maintained detailed logs of data records for tracking and auditing purposes. Developed data validation processes using SSIS, PL/SQL, and C# (SSIS Script Component) to ensure the integrity of bulk data imports and accurately filter invalid records from CSV files, resulting in validated data exports. Generated emails throughout the data handling process to inform stakeholders of each stage: Import, Validation, and Export. Wrote stored procedures and functions in T-SQL to support SSRS report development.
Akhuwat Microfinance
BI Developer
November 2017 - November 2019 (2 years)
Lahore, Punjab, Pakistan
Managed the end-to-end design and development of ETL pipelines with a focus on performance and scalability. Executed data transformations using the Pentaho Kettle ETL tool. Scheduled and monitored ETL jobs for both source and target databases (MySQL). Enhanced data visualisation outcomes through Power BI. Produced comprehensive documentation including detailed use cases, test cases, flow chart designs, and requirements gathering and analysis for the Akhuwat Paperless project. Designed workflows for the Akhuwat Paperless initiative. Created screen flows for the Android application. Conducted manual testing for the E-Akhuwat Android app. Resolved support issues raised by end users with a focus on enhancing user experience.