Khalid Amin, Data Modeling Developer in Melbourne, Victoria, Australia
Khalid Amin

Data Modeling Developer in Melbourne, Victoria, Australia

Member since February 6, 2020
Khalid has over 20 years of industry experience in databases, including data modeling, schema design, database programming, data integration, and business intelligence. He primarily focuses on Oracle and SQL Server (SQL, PL/SQL, T-SQL). Khalid's developed large-scale enterprise databases with terabytes of data and is comfortable working with Python, Apache Spark, Pandas, Java, and PHP.
Khalid is now available for hire

Portfolio

Experience

Location

Melbourne, Victoria, Australia

Availability

Part-time

Preferred Environment

SQL, PyCharm, SQL Server Management Studio, MacOS, Unix, Linux, Windows

The most amazing...

...solution I've coded was a utility that used Oracle Forms APIs to automatically modify, compile, and save form modules—saving hundreds of hours of manual work.

Employment

  • Senior Technical Consultant

    2014 - PRESENT
    Engine Group APAC
    • Designed, programmed, and supported back-end databases for various projects for government and private sector organizations.
    • Worked with big data technogoliges like Apache Spark, Python, and Pandas to produce BI/reports for a large enterprise.
    • Devised coding standards for SQL Server stored procedures, SQL, and user-defined functions.
    • Rewrote several poorly-performing databases to improve the performance by many folds.
    • 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.
    Technologies: Apache Spark, Python, Microsoft SQL Server
  • Senior Database Developer

    2013 - 2014
    Salmat
    • Wrote the SQL/T-SQL code for the BI reporting of a communications system for large, Australia-based enterprises.
    • Rewrote and performance-tuned various slow-performing routines.
    • Created data integration pipelines using SSIS.
    Technologies: SQL Server Integration Services (SSIS), T-SQL, SQL, Microsoft SQL Server
  • 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: PHP, PL/SQL, SQL, Oracle
  • 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.
    Technologies: Oracle Forms & Reports, PL/SQL, Oracle SQL

Skills

  • Languages

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

    Oracle, Windows, Linux, Unix, MacOS
  • Storage

    PL/SQL, Oracle PL/SQL, Database Modeling, Databases, Microsoft SQL Server, Oracle SQL, SQL Server Management Studio, SQL Server Integration Services (SSIS)
  • Other

    Data Modeling, Data Queries, Oracle Forms & Reports, Integration, Big Data
  • Frameworks

    Apache Spark
  • Libraries/APIs

    Pandas, PySpark
  • Tools

    PyCharm

Education

  • Bachelor of Science (BSc) degree in Computer Science
    1996 - 1998
    Bahauddin Zakariya University - Multan, Pakistan

Certifications

  • 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