Abdul Hannan Ijaz，巴基斯坦旁遮普拉合尔的开发商
Abdul is available for hire
Hire Abdul

Abdul Hannan Ijaz

Verified Expert  in Engineering

软件开发人员

Location
拉合尔，旁遮普，巴基斯坦
至今成员总数
June 18, 2020

Hannan has more than half a decade of experience in RDMBS development, focusing on retail, HR, and POS systems. 他使用的是微软的SQL Server, MySQL, AzureSQL, Amazon RDS, and GCP, and has implemented BI dashboard reporting and PowerShell scripting. 他具有企业级CI/CD方面的经验. 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 AnalyticsData ModelingData WarehousingData ReportingData AnalysisWeb DevelopmentData Engineering数据可视化DAXSQL Triggers商业智能(BI)DatabasesETLGoogle SheetsRDBMSCockroachDBSQL CLRAlteryxExcel

Portfolio

BRP Inc. - Main
Microsoft Power BI, Microsoft SQL Server, Databases, Azure SQL数据库...
Glopal S.A.S
SQL, Google Data Studio, Python, R, Tableau, Microsoft Power BI, Looker...
Sagehen Holdings LLC
Google BigQuery, Python 3, 谷歌云功能, Google Data Studio...

Experience

Microsoft SQL Server - 7年SQL - 7 yearsMicrosoft Power BI - 5年MySQL - 5 yearsTableau - 5 years谷歌数据工作室- 3年Python 3 - 2年谷歌云平台(GCP) - 2年

Availability

Full-time

首选的环境

PySpark, Tableau, Alteryx, Microsoft Power BI, Azure, 谷歌云平台(GCP), SQL Server Management Studio (SSMS), Database Design, Microsoft SQL Server

The most amazing...

...我写的代码都是孤立的, 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.
  • 在Power BI中实现动态行级安全.
  • 用SQL和Power Query M语言编写复杂查询.
  • Performed data modeling with multiple facts in Power BI and maintained RLS.
  • 将R语言脚本转换为MS SQL查询变体.
  • 开发具有复杂RLS和数据流的经销商仪表板.
  • 开发了具有多事实环境和明暗主题的RVT.
技术:Microsoft Power BI, Microsoft SQL Server, Databases, Azure SQL数据库, 专用SQL池(以前称为SQL DW), Azure SQL数据仓库, Azure Synapse, Power Query, Power Query M, 查询优化, Data Modeling, 逆向工程, Azure, ETL, Database Design, SQL, Excel 2016, Microsoft Excel, SQL Server Management Studio (SSMS), 数据可视化, DB, ETL Tools, Google Cloud SQL, Git, SAP方案管理, Excel 2013, RDBMS, Data Analytics, Dashboards, Reporting, OLTP, Snowflake, OLAP, Google Sheets, Data Extraction, CSV, CSV Export, Database Modeling, 商业智能(BI), Data Analysis, DAX, Data Reporting, Data Management, Data Warehousing, SAP, Warehouses, 仪表板发展

数据分析师|商业智能专家

2022 - 2022
Glopal S.A.S
  • Wrote Python code for cloud functions to convert Excel to CSV and process CSV among different buckets.
  • 开发了Google BigQuery表、查询和作业.
  • Created 谷歌云功能 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 谷歌云平台(GCP) function activity on Slack via webhooks.
Technologies: SQL, Google Data Studio, Python, R, Tableau, Microsoft Power BI, Looker, 谷歌云功能, 谷歌云存储, Google BigQuery, Python 3, 谷歌云平台(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, 商业智能(BI), Data Analysis, DAX, Excel 2016, Database Design, Microsoft SQL Server, Data Management, Data Warehousing, Warehouses, 仪表板发展

数据库架构师

2021 - 2022
Sagehen Holdings LLC
  • Wrote dynamic Python ETL using the Google Cloud tech stack for loading various feeds into BigQuery.
  • Developed 谷歌云功能 to run—based on a 谷歌云存储 bucket trigger on the arrival of new files—and process them according to ETL.
  • 在Google BigQuery上创建视图，表和查询.
  • Built different charts based on the client's requirement on Metabase.
技术:Google BigQuery, Python 3, 谷歌云功能, Google Data Studio, 谷歌云存储, Data Engineering, 数据可视化, Data Modeling, Metabase, ETL, 谷歌云平台(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, 商业智能(BI), Data Analysis, DAX, Data Reporting, Excel 2016, Microsoft SQL Server, Data Management, Data Warehousing, Warehouses, 仪表板发展

数据库开发人员，迁移(GC Spanner, MySQL)

2021 - 2021
Ziiware(通过Toptal)
  • Set up a local instance of MariaDB using the backup scripts provided.
  • 提取表、索引、约束和ERD脚本.
  • 将MySQL脚本转换为Spanner脚本进行迁移.
  • Implemented an interleaving relationship between tables where required.
技术:MariaDB, MySQL, 谷歌云扳手, 数据库迁移, 谷歌云平台(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, 商业智能(BI), Data Analysis, Excel 2016, Microsoft SQL Server, Data Management, Data Warehousing, Warehouses, 仪表板发展

Power BI架构师

2021 - 2021
云解决方案组(通过Toptal)
  • Assisted in the development of the data ETL process to extract data from different sources such as Excel, CSV, ODBC, 和REST API到Azure SQL数据库.
  • Created Power BI dashboards and developed reports using Azure SQL database.
  • 在Power BI中开发自定义度量和模板.
  • 完成了从Azure到本地SQL实例的数据库迁移.
技术:Microsoft Power BI, Python 3, Azure SQL数据库, Excel 365, Data Engineering, 数据可视化, Databases, ETL, Python, Database Design, SQL, Azure, Microsoft Excel, SQL Server Management Studio (SSMS), 数据库迁移, Power Query, 逆向工程, 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, 商业智能(BI), Data Analysis, DAX, Data Reporting, Excel 2016, Microsoft SQL Server, Data Warehousing, Warehouses, 仪表板发展

Data Engineer

2021 - 2021
Decentral Park Capital(通过Toptal)
  • 开发Power BI仪表板和报告，以报告多个kpi.
  • 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.
技术:Microsoft Power BI, PHP, Unix, Azure, Azure SQL, Crypto, Python, Data Engineering, 数据可视化, Python 3, Databases, Azure SQL数据库, 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, 商业智能(BI), Data Analysis, DAX, Data Reporting, Excel 2016, Microsoft SQL Server, Data Warehousing, Warehouses, 仪表板发展

BI Developer

2020 - 2021
MyDoc (via Toptal)
  • Developed the BI dashboard using Google Data Studio and CockroachDB, 显示增长趋势, usage, demands, 以及其他跨不同维度的报告方法.
  • 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.
技术:段, Mixpanel, Google Sheets, CockroachDB, PostgreSQL, Google Data Studio, 数据可视化, 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, 商业智能(BI), Data Analysis, Data Reporting, Excel 2016, Database Design, Microsoft SQL Server, Data Warehousing, Warehouses, 仪表板发展

SQL Developer

2016 - 2020
主要通信
  • Developed a database with Amazon cloud technologies using RDS and EC2.
  • 协助开发萃取技术, transformation, 并使用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.
  • 通过数据完整性检查迁移了远程服务器数据.
  • Guided database tuning and performance optimization for MySQL and Microsoft SQL Server.
技术:亚马逊网络服务(AWS), Amazon S3 (AWS S3), Microsoft, SQL Server集成服务(SSIS), Microsoft Excel, Drupal, PHP, MySQL, SQL, Data Engineering, 数据可视化, Databases, ETL, Database Design, Excel 2016, SQL Server报表服务(SSRS), Windows PowerShell, SQL Server Management Studio (SSMS), 数据库迁移, Excel Expert, 逆向工程, 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, 商业智能(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.
  • 管理控制流—使用不同的工具，如SSIS, Alteryx, Python, and GCP Spark—which allowed us to direct transformed loaded data from extracted sources to the desired destination.
  • 使用Tableau、Power BI和SSRS开发报表和仪表板.
  • Created PySpark jobs for data ETL and loaded them to the Cloud Firestore document database.
  • 使用cron作业自动执行每日BAU任务, agents, scripting, 和调度与PowerShell和云功能.
  • Provided data modeling, requirement engineering, and structure refinement services.
技术:蔚蓝的, 谷歌云平台(GCP), 微软数据转换服务(现为SSIS), Python, PySpark, Azure SQL数据库, Microsoft SQL Server, Cloud Firestore, BigQuery, Databases, Data Engineering, Microsoft Power BI, ETL, 谷歌云功能, Database Design, SQL, SQL Server报表服务(SSRS), Python 3, Windows PowerShell, Microsoft Excel, SQL Server Management Studio (SSMS), 数据可视化, 数据库迁移, 逆向工程, DB, ETL Tools, Hue, Jira, Google Kubernetes Engine (GKE), Cloud Dataflow, 谷歌云数据, 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, 商业智能(BI), SQL CLR, Excel 2016, Data Warehousing, Warehouses, 仪表板发展

Software Engineer

2015 - 2016
Raaziq国际
  • 通过细化需求开发ERP结构.
  • 使用Microsoft SQL Server从以前的ERP中迁移数据.
  • 在数据库层为BPA实现了业务规则.
  • 在Microsoft SQL Server中实现全文检索.
技术:SQL Server集成服务(SSIS), Zend Framework, PHP, Microsoft SQL Server, Databases, ETL, Database Design, SQL, SQL Server Management Studio (SSMS), 数据库迁移, 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

数据库管理员

2012 - 2015
高峰解决方案学院
  • 启动了一个基于计算机的自动测试系统.
  • 设计并开发了计算机化考试系统.
  • Administered the system and gathered real-time feedback for future changes.
  • 完成增量更改和测试框架开发.
技术: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

Relisys

Relisys是为Raaziq international设计的ERP系统. 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.

考试管理系统

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.

谷歌数据工作室仪表板

Reporting dashboards for different metrics and KPIs using Google Data Studio. 每个报告/图表都有不同级别的信息和视图, 哪一个需要设置不同的连接器, blending data, 创建用户交互.
2017 - 2019

工商管理硕士学位

南亚大学-拉合尔，巴基斯坦

2011 - 2015

计算机科学硕士学位

拉合尔政府学院大学-拉合尔，巴基斯坦

Libraries/APIs

PySpark, jQuery, Windows Forms (WinForms)

Tools

BigQuery, Google Sheets, Tableau, Microsoft Power BI, Excel 2016, Excel 2013, 谷歌云数据, Cloud Dataflow, Google Kubernetes Engine (GKE), Visual Studio, Git, Hue, Bitbucket, Jira, Microsoft Excel, Power Query, Query Plan, SAP方案管理, Looker

Frameworks

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

Paradigms

Database Design, ETL, 敏捷软件开发, 数据库开发, OLAP, 商业智能(BI), Scrum

Languages

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

Platforms

Azure, Windows, Visual Studio 2017, 谷歌云平台(GCP), Alteryx, Jupyter Notebook, Drupal, Microsoft, 亚马逊网络服务(AWS), Unix, Mixpanel, Azure SQL数据仓库, Azure Synapse, 专用SQL池(以前称为SQL DW)

Storage

Databases, MySQL, Microsoft SQL Server, SQL Server报表服务(SSRS), SQL Server集成服务(SSIS), PostgreSQL 10, Google Cloud SQL, 谷歌云存储, 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数据库, Amazon S3 (AWS S3), CockroachDB, MariaDB, 谷歌云扳手, 数据库迁移, 数据库管理

Other

Google BigQuery, 查询优化, Data Engineering, Web Development, Google Data Studio, 谷歌云功能, 数据可视化, Data Modeling, ETL Tools, Dashboards, 数据级安全, APIs, Data Analytics, Reporting, Data Extraction, CSV, CSV Export, SQL Server 2015, Data Analysis, DAX, Data Reporting, Data Management, Data Warehousing, SAP, Warehouses, 仪表板发展, MVC Frameworks, Scrum Master, Excel Expert, 微软数据转换服务(现为SSIS), Segment, Crypto, Computer Science, Excel 365, 逆向工程, Metabase, Workflow

有效的合作

如何使用Toptal

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

1

Share your needs

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

Choose your talent

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

开始你的无风险人才试验

与你选择的人才一起工作，试用最多两周. 只有当你决定雇佣他们时才付钱.

对顶尖人才的需求很大.

Start hiring
" class="hidden">今日▪天下通