Khalid Amin，澳大利亚维多利亚州墨尔本的开发者
Khalid is available for hire
Hire Khalid

Khalid Amin

Verified Expert  in Engineering

Data Modeling Developer

Location
Melbourne, Victoria, Australia
Toptal Member Since
June 18, 2020

Khalid是一位经验丰富的数据专业人士，拥有20多年的行业经验. His expertise includes data architecture, data engineering, modern data warehousing, big data, and analytics. Khalid拥有Azure数据工程和Power BI方面的微软认证. 此外，他精通SQL Server和Oracle数据库技术. 哈立德有很好的人际交往能力，是一个真正的团队成员.

Data AnalysisData ModelingData QueriesData EngineeringDatabase DevelopmentSQLDatabasesOraclePL/SQLOracle PL/SQLOracle SQLMicrosoft SQL ServerT-SQL (Transact-SQL)Data WarehousingData MigrationLaminas (Zend)

Portfolio

BJSS
数据建模，数据架构，数据工程，Databricks, Azure...
Engine Group
数据建模，T-SQL (Transact-SQL)， PySpark，大数据，SQL，数据查询...
Salmat
数据建模，大数据，数据库，SQL，数据查询...

Experience

Database Development - 20 yearsSQL - 20 yearsData Modeling - 20 yearsData Engineering - 20 yearsMicrosoft SQL Server - 10 yearsData Integration - 10 yearsAzure - 4 yearsDatabricks - 3 years

Availability

Full-time

Preferred Environment

Microsoft Power BI, Microsoft Azure, Azure Data Factory, Azure Synapse Analytics, Azure Databricks, Big Data, Data Warehousing, Data Analytics, SQL Server 2012, SQL

The most amazing...

...我真正引以为傲的成就是，我对一个企业数据库进行了重构和性能调优，并将其性能提高了约500%

Work Experience

Data Architect

2021 - PRESENT
BJSS
  • 曾为一家领先的全球客户担任数据架构师.
  • Involved in data architecture, data engineering, 并通过数据策略构建全局通用数据模型.
  • 参与在全局公共数据模型之上设计和开发kpi和语义层.
Technologies: 数据建模，数据架构，数据工程，Databricks, Azure, Consulting, Azure Data Explorer

Senior Data Consultant

2014 - 2021
Engine Group
  • Involved in data architecture and strategy, 设计端到端数据平台解决方案，如发现, ingestion, integration/ETL/ELT, transformations and data wrangling, modeling and star schema design, analytics, and BI reporting.
  • 曾在Microsoft SQL Server, TSQL, Microsoft Azure Data Factory和Azure Synapse Analytics工作. Wrote ETL and ELT pipelines.
  • 为SQL Server存储过程、SQL和用户定义函数设计编码标准.
  • 重写了几个性能较差的数据库，显著提高了它们的性能.
  • 整合来自多个来源的数据，提供客户行为数据的整体视图, browsing habits, survey responses, and more.
  • Created analytics reports such as correlations, NPS, cross-tabulations, trends, and theming verbatim responses for various projects.
  • 使用Microsoft Power BI创建分析和商业智能仪表板和报告.
Technologies: 数据建模，T-SQL (Transact-SQL)， PySpark，大数据，SQL，数据查询, Apache Spark, Microsoft SQL Server, Microsoft Power BI, Azure Databricks, Azure Data Factory, Azure Data Lake, Azure Synapse Analytics, Azure, Data Engineering, Data Architecture, Consulting, Azure Data Explorer

Senior Consultant - Data and BI

2013 - 2014
Salmat
  • 设计端到端数据集成和ETL管道，以从各种来源摄取数据.
  • Wrote Microsoft SQL Server (SQL, TSQL, 存储过程(Stored Procedures)代码用于BI报告的一个通信系统的大, Australia-based enterprises.
  • 重写SQL查询，在某些情况下将性能提高100%以上.
Technologies: 数据建模，大数据，数据库，SQL，数据查询, SQL Server Integration Services (SSIS), T-SQL (Transact-SQL), Microsoft SQL Server, Data Engineering, Data Architecture, Consulting

Software Engineer

2002 - 2013
State Bank of Pakistan
  • 作为eCIB(征信局)设计开发团队的一员. 主要从事Oracle SQL和PL/SQL技术.
  • Developed and designed a system to maintain the inventory and drawing of the government's prize bonds scheme; I also traveled and deployed this system across all locations in the country.
  • 为人力资源部门创建了员工自助服务门户. This portal was built using Oracle SQL, PL/SQL on the back end, PHP/Zend Framework at the application level, and HTML, CSS, JavaScript, jQuery, and Twitter Bootstrap on the front end.
  • 使用Oracle SQL和PL/SQL技术为多个项目设计和编程后端数据库.
Technologies: MacOS, HTML, Database Modeling, SQL DML, SQL DDL, Data Modeling, T-SQL (Transact-SQL), Linux, Windows, Oracle Forms & Reports, Python, CSS, JavaScript, Java, Oracle SQL, Oracle PL/SQL, Oracle, Databases, Data Queries, PHP, PL/SQL, SQL

Software Engineer

2000 - 2002
Gulnet
  • Wrote a utility using Oracle Forms APIs that opened, modified, compiled, and saved the Oracle Forms modules. 这个实用程序为公司节省了数百小时的手工工作.
  • 作为包括应付账款在内的各种模块的开发团队的一员, accounts receivable, and inventory. 主要学习Oracle技术，包括SQL, PL/SQL, Oracle Forms and Reports.
  • 管理一个小型的Oracle SQL和PL/SQL开发团队.
Technologies: Database Modeling, SQL DML, SQL DDL, Data Modeling, Windows, JavaScript, Java, Oracle PL/SQL, Oracle, Databases, SQL, Data Queries, Oracle Forms & 报表，PL/SQL, Oracle SQL，数据工程，数据架构

Database Developer

1998 - 2000
Fauji Software Company Islamabad
  • 为企业级项目开发Oracle数据库查询、表单和报告.
  • 创建了一个实用程序，该实用程序自动记录和创建来自底层数据库对象的数据字典.
  • 为公司软件开发部门开发编码标准做出了贡献.
技术:数据建模，数据库建模，Oracle报表，Oracle表单，Oracle表单 & Reports, Oracle SQL, Oracle, PL/SQL, SQL

Global Common Data Model

目前正在与一家知名跨国品牌合作，倡议建立一个通用数据平台，并在其全球区域中心实施. 这个通用数据平台有助于在全球范围内整合数据，并允许跨区域提升和转移报告和仪表板.

User Authentication and Authorization System

我创建了一个健壮的用户身份验证和授权系统，它优先考虑安全性. By implementing industry best practices, I ensured that users can securely authenticate, authorize, and reset their forgotten passwords.

Electronic Credit Information Bureau (eCIB)

eCIB是一个非常大规模的信用信息数据库，为巴基斯坦所有商业银行提供服务. 这是巴基斯坦国家银行(State Bank of Pakistan)管理的唯一信用信息系统，商业银行在向消费者/企业客户提供任何贷款之前，都必须使用该系统.

Microsoft Power BI Analytics Platform

我是为客户设计和实现一个完整的商业智能平台的团队的一员. 我必须参与数据建模、数据库设计、Power BI报告和仪表板. 该系统被用于客户参与分析.

Languages

SQL, SQL DDL, SQL DML, T-SQL (Transact-SQL)， Java, Python, PHP, JavaScript, HTML, CSS, Python 3

Tools

Oracle Forms, Oracle Reports, Microsoft Power BI, PyCharm

Paradigms

数据库开发、ETL、商业智能(BI)

Platforms

Oracle, Azure Synapse Analytics, Azure, Databricks, Windows, Linux, Unix, MacOS, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW)

Storage

PL/SQL, Oracle PL/SQL, Database Modeling, Databases, Microsoft SQL Server, Oracle SQL, Data Integration, Data Pipelines, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server 2012

Other

Reporting, Database Schema Design, Data Analysis, Data Modeling, Data Queries, Data Engineering, Data, CSV File Processing, Performance Tuning, Data Analytics, Microsoft Azure, Azure Data Factory, Azure Databricks, Data Warehousing, Data Architecture, Data Migration, Data Management, Consulting, Azure Data Explorer, Oracle Forms & Reports, Integration, Big Data, User Authentication, Authorization, Azure Stream Analytics, Azure Data Lake, DAX

Frameworks

Apache Spark

Libraries/APIs

Pandas, PySpark

1996 - 1999

Bachelor of Science Degree in Computer Science

Bahauddin Zakariya University - Multan, Pakistan

AUGUST 2021 - AUGUST 2022

Microsoft Azure Data Engineer Associate

Microsoft

FEBRUARY 2021 - FEBRUARY 2023

Microsoft Certified Data Analyst (Power BI)

Microsoft

MAY 2019 - MAY 2022

AWS Certified Cloud Practioner

Amazon Web Services, Inc.

MAY 2009 - PRESENT

Orace Certified Application Developer 6/6i

Oracle Corporation

MAY 2001 - PRESENT

Sun Certified Programmer for Java 2 Platform

Sun Microsystems

Collaboration That Works

How to Work with Toptal

在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.

1

Share your needs

在与Toptal领域专家的电话中讨论您的需求并细化您的范围.
2

Choose your talent

在24小时内获得专业匹配人才的简短列表，以进行审查，面试和选择.
3

Start your risk-free talent trial

与你选择的人才一起工作，试用最多两周. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring