Khalid is currently unavailable
Khalid Amin
Verified Expert in Engineering
Database Development Developer
Melbourne, Victoria, Australia
Toptal member since March 6, 2020
Bio
Khalid is a seasoned data professional with 25 years of industry experience. His expertise includes data architecture, data engineering, modern data warehousing, big data, and analytics. Khalid is experienced in Microsoft Azure and Fabric, Snowflake Cloud Data Platform, Neo4j/graph databases, and GenAI. Additionally, he is skilled with SQL Server and Oracle database technologies. Khalid can speak fluently in English and is a true team player.
Portfolio
A well respected multinational tech consultancy
Data Modeling, Data Architecture, Data Engineering, Databricks, Azure...
Engine Group
Data Modeling, Transact-SQL (T-SQL), PySpark, Big Data, SQL, Data Queries...
Salmat
Data Modeling, Big Data, Databases, SQL, Data Queries...
Experience
- Database Development - 20 years
- SQL - 20 years
- Data Modeling - 20 years
- Data Engineering - 20 years
- Microsoft SQL Server - 10 years
- Data Integration - 10 years
- Azure - 4 years
- Databricks - 3 years
Work Experience
Lead Data Architect
2021 - PRESENT
A well respected multinational tech consultancy
- Architected and implemented a global common data model for a reputable multi-national client in health/retail domain. Designed and implemented data pipelines using Microsoft Azure, Data Factory, Databricks, and Azure Data Lake Storage (ADLS) Gen2.
- Designed and implemented an end-to-end data platform for a multinational client using Snowflake, Microsoft Azure, Data Factory, Key Vault, Event Grid, ADLS Gen2, Blob Storage, and Microsoft Power BI.
- Worked as a lead data architect for an air traffic control organization to validate and redesign data architecture. This architecture required strict availability requirements and involved real-time data with minimum latency.
- Designed and implemented knowledge graphs using Neo4j for RAG solution to augment LLMs with contextual data.
- Worked on building a Neo4j graph model for a reputable pharmaceutical retail client. The purpose of this graph is to identify the nearest stores with the availability of items currently in the user's shopping cart.
Technologies: Data Modeling, Data Architecture, Data Engineering, Databricks, Azure, Consulting, Azure Data Explorer, Snowflake, Dimensional Modeling, Data Pipelines, Neo4j, Graph Databases, Microsoft Fabric, Cypher
Senior Data Consultant
2014 - 2021
Engine Group
- Involved in data architecture and strategy, designing end-to-end data platform solutions such as discovery, ingestion, integration/ETL/ELT, transformations and data wrangling, modeling and star schema design, analytics, and BI reporting.
- Worked on Microsoft SQL Server, TSQL, Microsoft Azure Data Factory, and Azure Synapse Analytics. Wrote ETL and ELT pipelines.
- Devised coding standards for SQL Server stored procedures, SQL, and user-defined functions.
- Rewrote several poorly-performing databases to dramatically improve their performance.
- Integrated data from several sources to provide a holistic view of customer behavioral data, browsing habits, survey responses, and more.
- Created analytics reports such as correlations, NPS, cross-tabulations, trends, and theming verbatim responses for various projects.
- Created analytics and business intelligence dashboards and reports using Microsoft Power BI.
Technologies: Data Modeling, Transact-SQL (T-SQL), PySpark, Big Data, SQL, Data Queries, Apache Spark, Microsoft SQL Server, Microsoft Power BI, Azure Databricks, Azure Data Factory (ADF), Azure Data Lake, Azure Synapse Analytics, Azure, Data Engineering, Data Architecture, Consulting, Azure Data Explorer
Senior Consultant - Data and BI
2013 - 2014
Salmat
- Designed end-to-end data integration and ETL pipelines to ingest data from various sources.
- Wrote Microsoft SQL Server (SQL, T-SQL, Stored Procedures) code for the BI reporting of a communications system for large, Australia-based enterprises.
- Rewrote SQL queries to improve performance by more than 100% in some cases.
Technologies: Data Modeling, Big Data, Databases, SQL, Data Queries, SQL Server Integration Services (SSIS), Transact-SQL (T-SQL), Microsoft SQL Server, Data Engineering, Data Architecture, Consulting
Software Engineer
2002 - 2013
State Bank of Pakistan
- Worked as part of the design-and-development team for credit eCIB (Credit Information Bureau). Primarily worked on Oracle SQL and PL/SQL technologies.
- 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.
- Created a portal for employee-self services for the HR department. 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.
- Designed and programmed back-end databases for several projects using Oracle SQL and PL/SQL technologies.
Technologies: MacOS, HTML, Database Modeling, SQL DML, SQL DDL, Data Modeling, Transact-SQL (T-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. This utility saved hundreds of hours of manual work for the company.
- Worked as part of the development teams for various modules including accounts payable, accounts receivable, and inventory. Mainly worked on Oracle technologies including SQL, PL/SQL, and Oracle Forms and Reports.
- Managed a small team of Oracle SQL and PL/SQL developers.
Technologies: Database Modeling, SQL DML, SQL DDL, Data Modeling, Windows, JavaScript, Java, Oracle PL/SQL, Oracle, Databases, SQL, Data Queries, Oracle Forms & Reports, PL/SQL, Oracle SQL, Data Engineering, Data Architecture
Database Developer
1998 - 2000
Fauji Software Company Islamabad
- Developed Oracle database queries, forms, and reports for enterprise-scale projects.
- Created a utility that automatically documented and created a data dictionary from underlying database objects.
- Contributed to developing coding standards for the company's software development division.
Technologies: Data Modeling, Database Modeling, Oracle Reports, Oracle Forms, Oracle Forms & Reports, Oracle SQL, Oracle, PL/SQL, SQL
Project History
Global Common Data Model
Currently working with a well-reputed multinational brand on the initiative of building a common data platform that is implemented throughout its regional hubs across the world. This common data platform helps the consolidation of data globally and allows the lifting and shifting of reports and dashboards across regions.
User Authentication and Authorization System
I created a robust user authentication and authorization system that prioritizes security. By implementing industry best practices, I ensured that users can securely authenticate, authorize, and reset their forgotten passwords.
Electronic Credit Information Bureau (eCIB)
eCIB is a very large scale credit information database serving all commercial banks of Pakistan. This is the only credit information system governed by State Bank of Pakistan and commercial banks are required to use it before committing to any lending to consumer/corporate customers.
Microsoft Power BI Analytics Platform
I was part of the team that designed and implemented a complete business intelligence platform for a client. I had to take part in data modeling, database design, Power BI reports, and dashboards. This system is being used for customer engagement analytics.
Education
1996 - 1999
Bachelor of Science Degree in Computer Science
Bahauddin Zakariya University - Multan, Pakistan
Certifications
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 (AWS)
MAY 2009 - PRESENT
Orace Certified Application Developer 6/6i
Oracle Corporation
MAY 2001 - PRESENT
Sun Certified Programmer for Java 2 Platform
Sun Microsystems
Skills
Libraries/APIs
Pandas, PySpark
Tools
Oracle Forms, Oracle Reports, Microsoft Power BI, Azure Data Explorer, PyCharm
Languages
SQL, SQL DDL, SQL DML, Transact-SQL (T-SQL), Snowflake, Java, Python, PHP, JavaScript, HTML, CSS, Python 3, Cypher
Paradigms
Database Development, ETL, Business Intelligence (BI), Dimensional Modeling
Platforms
Oracle, Azure Synapse Analytics, Azure, Databricks, Windows, Linux, Unix, MacOS, Azure SQL Data Warehouse, Dedicated SQL Pool (formerly SQL DW), Microsoft Fabric
Storage
PL/SQL, Oracle PL/SQL, Database Modeling, Databases, Microsoft SQL Server, Oracle SQL, Data Integration, Data Pipelines, Azure SQL, Azure SQL Databases, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server 2012, Neo4j, Graph Databases
Frameworks
Apache Spark
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 (ADF), Azure Databricks, Data Warehousing, Data Architecture, Data Migration, Data Management, Consulting, Oracle Forms & Reports, Integration, Big Data, User Authentication, Authorization, Azure Stream Analytics, Azure Data Lake, DAX
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.
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 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