Abdul is available for hire

Abdul Hannan Ijaz

Verified Expert in Engineering

Software Developer

Location

Lahore, Punjab, Pakistan

Toptal Member Since

June 18, 2020

Hannan has more than half a decade of experience in RDMBS development, focusing on retail, HR, and POS systems. He's used Microsoft SQL Server, MySQL, AzureSQL, Amazon RDS, and GCP, and has implemented BI dashboard reporting and PowerShell scripting. He has experience in CI/CD at the enterprise level. Hannan can work across time zones with teams of different sizes and hierarchy structures and believes in punctual delivery of a quality product above all.

Data Analytics Data Modeling Data Warehousing Data Reporting Data Analysis Web Development Data Engineering Data Visualization DAX SQL Triggers Business Intelligence (BI)Databases ETL Google Sheets RDBMS CockroachDB SQL CLR Alteryx Excel

Portfolio

BRP Inc. - Main

Microsoft Power BI, Microsoft SQL Server, Databases, Azure SQL Databases...

Glopal S.A.S

SQL, Google Data Studio, Python, R, Tableau, Microsoft Power BI, Looker...

Sagehen Holdings LLC

Google BigQuery, Python 3, Google Cloud Functions, Google Data Studio...

Experience

Microsoft SQL Server - 7 years SQL - 7 years Microsoft Power BI - 5 years MySQL - 5 years Tableau - 5 years Google Data Studio - 3 years Python 3 - 2 years Google Cloud Platform (GCP) - 2 years

Availability

Full-time

Preferred Environment

PySpark, Tableau, Alteryx, Microsoft Power BI, Azure, Google Cloud Platform (GCP), SQL Server Management Studio (SSMS), Database Design, Microsoft SQL Server

The most amazing...

...things I’ve coded are isolated, self healing, data ETL and integration routines using different tech stack combinations.

Work Experience

Power BI Expert

2021 - 2024

BRP Inc. - Main

Developed various Power BI dashboards and reports to be embedded in the client's portal.
Implemented Dynamic Row Level Security in Power BI.
Wrote complex queries in SQL and Power Query M language.
Performed data modeling with multiple facts in Power BI and maintained RLS.
Converted R language scripts to the MS SQL query variant.
Developed Dealer Dashboards with complex RLS and dataflows.
Developed RVT with a multi-fact environment and light-dark theme.

Technologies: Microsoft Power BI, Microsoft SQL Server, Databases, Azure SQL Databases, Dedicated SQL Pool (formerly SQL DW), Azure SQL Data Warehouse, Azure Synapse, Power Query, Power Query M, Query Optimization, Data Modeling, Reverse Engineering, Azure, ETL, Database Design, SQL, Excel 2016, Microsoft Excel, SQL Server Management Studio (SSMS), Data Visualization, DB, ETL Tools, Google Cloud SQL, Git, SAP Solution Management, Excel 2013, RDBMS, Data Analytics, Dashboards, Reporting, OLTP, Snowflake, OLAP, Google Sheets, Data Extraction, CSV, CSV Export, Database Modeling, Business Intelligence (BI), Data Analysis, DAX, Data Reporting, Data Management, Data Warehousing, SAP, Warehouses, Dashboard Development

Data Analyst | Business Intelligence Expert

2022 - 2022

Glopal S.A.S

Wrote Python code for cloud functions to convert Excel to CSV and process CSV among different buckets.
Developed Google BigQuery tables, queries, and jobs.
Created Google Cloud Functions with triggers on buckets, file creation, and finalization.
Produced Python code for cloud functions to load data from flat files to BigQuery, clean up the data, and manage jobs.
Logged all Google Cloud Platform (GCP) function activity on Slack via webhooks.

Technologies: SQL, Google Data Studio, Python, R, Tableau, Microsoft Power BI, Looker, Google Cloud Functions, Google Cloud Storage, Google BigQuery, Python 3, Google Cloud Platform (GCP), Jupyter Notebook, Excel 2013, BigQuery, RDBMS, Data Pipelines, Data Analytics, Dashboards, Reporting, Data Modeling, OLAP, Google Sheets, Data Extraction, CSV, CSV Export, Database Modeling, Business Intelligence (BI), Data Analysis, DAX, Excel 2016, Database Design, Microsoft SQL Server, Data Management, Data Warehousing, Warehouses, Dashboard Development

Database Architect

2021 - 2022

Sagehen Holdings LLC

Wrote dynamic Python ETL using the Google Cloud tech stack for loading various feeds into BigQuery.
Developed Google Cloud Functions to run—based on a Google Cloud Storage bucket trigger on the arrival of new files—and process them according to ETL.
Created views, tables, and queries on Google BigQuery.
Built different charts based on the client's requirement on Metabase.

Technologies: Google BigQuery, Python 3, Google Cloud Functions, Google Data Studio, Google Cloud Storage, Data Engineering, Data Visualization, Data Modeling, Metabase, ETL, Google Cloud Platform (GCP), Databases, Python, Database Design, SQL, Microsoft Excel, DB, ETL Tools, Cloud Dataflow, Google Cloud SQL, Excel 2013, BigQuery, RDBMS, Data Pipelines, Data Analytics, Dashboards, Reporting, OLTP, OLAP, SQL Triggers, Google Sheets, Data Extraction, CSV, CSV Export, Database Modeling, Business Intelligence (BI), Data Analysis, DAX, Data Reporting, Excel 2016, Microsoft SQL Server, Data Management, Data Warehousing, Warehouses, Dashboard Development

Database Developer, Migration (GC Spanner, MySQL)

2021 - 2021

Ziiware (via Toptal)

Set up a local instance of MariaDB using the backup scripts provided.
Extracted tables, indexes, constraints, and ERD scripts.
Converted MySQL scripts to Spanner scripts for the migration.
Implemented an interleaving relationship between tables where required.

Technologies: MariaDB, MySQL, Google Cloud Spanner, Database Migration, Google Cloud Platform (GCP), Databases, Database Design, SQL, DB, ETL Tools, Google Cloud SQL, Git, RDBMS, Data Analytics, Dashboards, Reporting, Data Modeling, Google Sheets, Data Extraction, CSV, CSV Export, Database Modeling, Business Intelligence (BI), Data Analysis, Excel 2016, Microsoft SQL Server, Data Management, Data Warehousing, Warehouses, Dashboard Development

Power BI Architect

2021 - 2021

Cloud Solutions Group (via Toptal)

Assisted in the development of the data ETL process to extract data from different sources such as Excel, CSV, ODBC, and REST API to Azure SQL database.
Created Power BI dashboards and developed reports using Azure SQL database.
Developed custom measures and templates in Power BI.
Completed database migrations from Azure to local SQL instances.

Technologies: Microsoft Power BI, Python 3, Azure SQL Databases, Excel 365, Data Engineering, Data Visualization, Databases, ETL, Python, Database Design, SQL, Azure, Microsoft Excel, SQL Server Management Studio (SSMS), Database Migration, Power Query, Reverse Engineering, DB, Power Query M, ETL Tools, Git, Excel 2013, RDBMS, Data Pipelines, Data Analytics, Dashboards, Reporting, OLTP, Data Modeling, OLAP, SQL Triggers, Google Sheets, Data Extraction, CSV, CSV Export, Database Modeling, Business Intelligence (BI), Data Analysis, DAX, Data Reporting, Excel 2016, Microsoft SQL Server, Data Warehousing, Warehouses, Dashboard Development

Data Engineer

2021 - 2021

Decentral Park Capital (via Toptal)

Developed Power BI dashboards and reports to report multiple KPIs.
Worked on the extraction of data from various cryptocurrency endpoints using PHP RESTful APIs.
Loaded data to Azure SQL and processing JSON responses using SQL methods and techniques.
Worked on data aggregations and calculations using PHP Cron jobs on Unix.
Wrote data extraction routines from various crypto APIs using Python and Azure.
Revamped the existing structure to a more robust design capable of rerunning and reprocessing any time required.

Technologies: Microsoft Power BI, PHP, Unix, Azure, Azure SQL, Crypto, Python, Data Engineering, Data Visualization, Python 3, Databases, Azure SQL Databases, ETL, Database Design, SQL, SQL Server Management Studio (SSMS), Power Query, DB, Power Query M, ETL Tools, Git, Visual Studio, JavaScript, Excel 2013, RDBMS, Data Analytics, Dashboards, Reporting, OLTP, Data Modeling, OLAP, SQL Triggers, Google Sheets, Data Extraction, CSV, CSV Export, Database Modeling, Business Intelligence (BI), Data Analysis, DAX, Data Reporting, Excel 2016, Microsoft SQL Server, Data Warehousing, Warehouses, Dashboard Development

BI Developer

2020 - 2021

MyDoc (via Toptal)

Developed the BI dashboard using Google Data Studio and CockroachDB, showing trends in growth, usage, demands, and other reporting measures across different dimensions.
Wrote complex PL/SQL queries to compare various data points across different sources.
Reversed engineered existing BI dashboards to understand how the current setup is made and configured.
Guided the selection of the optimal BI tool to meet the client's needs and limitations.
Wrote complex PL/SQL queries on the CockroachDB engine to extract and produce reports of required data.

Technologies: Segment, Mixpanel, Google Sheets, CockroachDB, PostgreSQL, Google Data Studio, Data Visualization, Data Engineering, Databases, SQL, DB, ETL Tools, Jira, PostgreSQL 10, Excel 2013, RDBMS, Data Analytics, Dashboards, Reporting, OLTP, Data Modeling, OLAP, SQL Triggers, Data Extraction, CSV, CSV Export, Database Modeling, Business Intelligence (BI), Data Analysis, Data Reporting, Excel 2016, Database Design, Microsoft SQL Server, Data Warehousing, Warehouses, Dashboard Development

SQL Developer

2016 - 2020

Prime Communications

Developed a database with Amazon cloud technologies using RDS and EC2.
Assisted in the development of extraction, transformation, and load functionalities using SSIS, Microsoft SQL Server, and MySQL.
Automated back-up and daily optimizations in Microsoft SQL Server and MySQL.
Developed and overviewed Excel reporting using ODBC sources for MySQL and Microsoft SQL Server.
Created a data warehouse using Microsoft SQL Server, SSIS, PS, and Python scripting.
Configured, developed, and optimized BI reports using SSRS and Microsoft SQL Server.
Migrated the remote server data with data integrity checks.
Guided database tuning and performance optimization for MySQL and Microsoft SQL Server.

Technologies: Amazon Web Services (AWS), Amazon S3 (AWS S3), Microsoft, SQL Server Integration Services (SSIS), Microsoft Excel, Drupal, PHP, MySQL, SQL, Data Engineering, Data Visualization, Databases, ETL, Database Design, Excel 2016, SQL Server Reporting Services (SSRS), Windows PowerShell, SQL Server Management Studio (SSMS), Database Migration, Excel Expert, Reverse Engineering, DB, Power Query M, ETL Tools, Git, Visual Studio, Visual Studio 2017, Excel 2013, RDBMS, Data Analytics, Dashboards, Reporting, OLTP, Data Modeling, OLAP, SQL Triggers, Google Sheets, Data Extraction, CSV, CSV Export, Database Modeling, Business Intelligence (BI), Microsoft SQL Server, Data Warehousing, Warehouses

SQL Developer

2017 - 2019

Bitlogix

Enabled data extraction from multiple sources using cloud technologies and a dedicated set up for FMCG clients, such as Walmart, Target, Kroger, and Woolworths.
Managed control flows—using different tools like SSIS, Alteryx, Python, and GCP Spark—which allowed us to direct transformed loaded data from extracted sources to the desired destination.
Developed reports and dashboards using Tableau, Power BI, and SSRS.
Created PySpark jobs for data ETL and loaded them to the Cloud Firestore document database.
Automated daily BAU tasks using cron jobs, agents, scripting, and scheduling with PowerShell and Cloud Functions.
Provided data modeling, requirement engineering, and structure refinement services.

Technologies: Azure, Google Cloud Platform (GCP), Microsoft Data Transformation Services (now SSIS), Python, PySpark, Azure SQL Databases, Microsoft SQL Server, Cloud Firestore, BigQuery, Databases, Data Engineering, Microsoft Power BI, ETL, Google Cloud Functions, Database Design, SQL, SQL Server Reporting Services (SSRS), Python 3, Windows PowerShell, Microsoft Excel, SQL Server Management Studio (SSMS), Data Visualization, Database Migration, Reverse Engineering, DB, ETL Tools, Hue, Jira, Google Kubernetes Engine (GKE), Cloud Dataflow, Google Cloud Dataproc, Google Cloud SQL, Git, Visual Studio, MongoDB, Teradata, Scrum, ASP.NET MVC, Visual Studio 2017, Jupyter Notebook, Excel 2013, RDBMS, Data Pipelines, Data Analytics, Dashboards, Reporting, OLTP, Data Modeling, OLAP, SQL Triggers, Google Sheets, Data Extraction, CSV, CSV Export, Database Modeling, Business Intelligence (BI), SQL CLR, Excel 2016, Data Warehousing, Warehouses, Dashboard Development

Software Engineer

2015 - 2016

Raaziq International

Developed the ERP structure by refining requirements.
Migrated data from the previous ERP using Microsoft SQL Server.
Implemented business rules in the database layer for BPA.
Implemented full-text search in Microsoft SQL Server.

Technologies: SQL Server Integration Services (SSIS), Zend Framework, PHP, Microsoft SQL Server, Databases, ETL, Database Design, SQL, SQL Server Management Studio (SSMS), Database Migration, DB, ETL Tools, MVC Frameworks, Git, JavaScript, Excel 2013, RDBMS, Data Analytics, Dashboards, Reporting, OLTP, Data Modeling, OLAP, SQL Triggers, Data Extraction, CSV, CSV Export, Database Modeling, SQL Server 2015, Excel 2016

Database Administrator

2012 - 2015

Peak Solutions College

Initiated an automated computer-based testing system.
Designed and developed a computerized exam system.
Administered the system and gathered real-time feedback for future changes.
Completed incremental changes and tested framework development.

Technologies: jQuery, CSS, HTML, .NET, C#, Microsoft SQL Server, Databases, ETL, Database Design, SQL, SQL Server Management Studio (SSMS), DB, ETL Tools, MVC Frameworks, Visual Studio, Windows, ASP.NET MVC, Visual Studio 2017, JavaScript, Excel 2013, RDBMS, Data Analytics, Reporting, OLTP, Data Modeling, SQL Triggers, Data Extraction, CSV, CSV Export, SQL Server 2015, Excel 2016

Experience

Relisys

Relisys is an ERP system designed for Raaziq international. My role in Relisys was to take its back-end development and migrations from an existing system. The ERP module contained HRM, inventory, CMS, permissions, and other system flows.

EMS (Exam Management System)

This system was developed to cater to a custom need for short courses in college. The system contained detailed levels of workflow for HR as well as the student and teacher management system. My role in this project was to lead the complete development process.

Google Data Studio Dashboards

Reporting dashboards for different metrics and KPIs using Google Data Studio. Each report/chart had a different level of information and views, which required setting up different connectors, blending data, and creating user interactions.

Skills

Languages

Python, SQL, C#, HTML5, Python 3, CSS, JavaScript, PHP, HTML, Power Query M, R, Snowflake

Frameworks

ASP.NET MVC, Laravel, Windows PowerShell, Zend Framework, .NET, Hadoop

Tools

BigQuery, Google Sheets, Tableau, Microsoft Power BI, Excel 2016, Excel 2013, Google Cloud Dataproc, Cloud Dataflow, Google Kubernetes Engine (GKE), Visual Studio, Git, Hue, Bitbucket, Jira, Microsoft Excel, Power Query, Query Plan, SAP Solution Management, Looker

Paradigms

Database Design, ETL, Agile Software Development, Database Development, OLAP, Business Intelligence (BI), Scrum

Platforms

Azure, Windows, Visual Studio 2017, Google Cloud Platform (GCP), Alteryx, Jupyter Notebook, Drupal, Microsoft, Amazon Web Services (AWS), Unix, Mixpanel, Azure SQL Data Warehouse, Azure Synapse, Dedicated SQL Pool (formerly SQL DW)

Storage

Databases, MySQL, Microsoft SQL Server, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), PostgreSQL 10, Google Cloud SQL, Google Cloud Storage, Azure SQL, DB, RDBMS, Data Pipelines, OLTP, SQL Triggers, Database Modeling, SQL CLR, PostgreSQL, Teradata, MongoDB, SQL Server Management Studio (SSMS), Cloud Firestore, Azure SQL Databases, Amazon S3 (AWS S3), CockroachDB, MariaDB, Google Cloud Spanner, Database Migration, Database Management

Other

Google BigQuery, Query Optimization, Data Engineering, Web Development, Google Data Studio, Google Cloud Functions, Data Visualization, Data Modeling, ETL Tools, Dashboards, Data-level Security, APIs, Data Analytics, Reporting, Data Extraction, CSV, CSV Export, SQL Server 2015, Data Analysis, DAX, Data Reporting, Data Management, Data Warehousing, SAP, Warehouses, Dashboard Development, MVC Frameworks, Scrum Master, Excel Expert, Microsoft Data Transformation Services (now SSIS), Segment, Crypto, Computer Science, Excel 365, Reverse Engineering, Metabase, Workflow

Libraries/APIs

PySpark, jQuery, Windows Forms (WinForms)

Education

2017 - 2019

Master's Degree in Business Administration

University of South Asia - Lahore, Pakistan

2011 - 2015

Graduate Degree in Computer Science

Government College University Lahore - Lahore, Pakistan

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring