toptal.com
Contact us: +1.888.604.3188
Khalid Amin, Data Engineering Developer in Melbourne, Victoria, Australia
Khalid Amin

Data Engineering Developer in Melbourne, Victoria, Australia

Member since February 6, 2020
Khalid is a seasoned data professional with 20 years of experience. His expertise includes data architecture and strategy, data engineering, modern data warehousing, big data, and analytics. Khalid has Microsoft certifications in Azure data engineering and Power BI. Additionally, he is skilled with SQL Server and Oracle database technologies. Khalid has good interpersonal skills and is a true team player.
Khalid is now available for hire
Hire Khalid

Portfolio

  • Engine Group
    Data Modeling, T-SQL, PySpark, Big Data, SQL, Data Queries, Apache Spark...
  • Salmat
    Data Modeling, Big Data, Databases, SQL, Data Queries...
  • State Bank of Pakistan
    MacOS, HTML, Database Modeling, SQL DML, SQL DDL, Data Modeling, T-SQL, Linux...

Experience

Location

Melbourne, Victoria, Australia

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...

...solution I've contributed to was the development of an electronic credit information system. This database served the whole banking industry of Pakistan.

Employment

  • Senior Data Consultant

    2014 - PRESENT
    Engine Group
    • Actively involved in data architecture and strategy, designing end-to-end data platform solutions from 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, 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, T-SQL, PySpark, Big Data, SQL, Data Queries, Apache Spark, Microsoft SQL Server, Microsoft Power BI, Azure Databricks, Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, Azure, Data Engineering, Data Architecture

  • 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, TSQL, 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), T-SQL, Microsoft SQL Server, Data Engineering, Data Architecture

  • 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, 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

Experience

  • 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.

Skills

  • Languages

    SQL, SQL DDL, SQL DML, T-SQL, Java, Python, PHP, JavaScript, HTML, CSS

  • Tools

    Oracle Forms, Oracle Reports, Microsoft Power BI, PyCharm

  • Paradigms

    Database Development, ETL, Business Intelligence (BI)

  • Platforms

    Oracle, Azure, Windows, Linux, Unix, MacOS

  • Storage

    PL/SQL, Oracle PL/SQL, Database Modeling, Databases, Microsoft SQL Server, Oracle SQL, Data Integration, Data Pipelines, SQL Server Management Studio, 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 Synapse Analytics, Azure Databricks, Data Warehousing, Data Architecture, Data Migration, Oracle Forms & Reports, Integration, Big Data, User Authentication, Authorization, Azure Data Factoy, Azure Streaming Analytics, Azure SQL Data Warehouse (SQL DW), Azure Data Lake Storage, DAX

  • Frameworks

    Apache Spark

  • Libraries/APIs

    Pandas, PySpark

Education

  • Bachelor of Science Degree in Computer Science
    1996 - 1999
    Bahauddin Zakariya University - Multan, Pakistan

Certifications

  • Microsoft Certified Data Engineer
    AUGUST 2021 - PRESENT
    Microsoft
  • Microsoft Certified Data Analyst (Power BI)
    FEBRUARY 2021 - FEBRUARY 2023
    Microsoft
  • AWS Certified Cloud Practioner
    MAY 2019 - MAY 2022
    Amazon Web Services, Inc.
  • Orace Certified Application Developer 6/6i
    MAY 2009 - PRESENT
    Oracle Corporation
  • Sun Certified Programmer for Java 2 Platform
    MAY 2001 - PRESENT
    Sun Microsystems

To view more profiles

Join Toptal
Share it with others
Hire the top 3% of freelance developers TM