Khalid Amin
Verified Expert in Engineering
Data Modeling Developer
Khalid is a seasoned data professional with 20+ years of industry experience. His expertise includes data architecture, 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 very good interpersonal skills and is a true team player.
Portfolio
Experience
Availability
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...
...achievement that I'm really proud of is that I restructured and performance tuned an enterprise database and improved its performance by ~500%
Work Experience
Data Architect
BJSS
- Worked as a data architect for a leading global client.
- Involved in data architecture, data engineering, and data strategy to build the global common data model.
- Participated in designing and developing KPIs and semantec layers on top of the global common data model.
Senior Data Consultant
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.
Senior Consultant - Data and BI
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.
Software Engineer
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.
Software Engineer
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.
Database Developer
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.
Experience
Global Common Data Model
User Authentication and Authorization System
Electronic Credit Information Bureau (eCIB)
Microsoft Power BI Analytics Platform
Skills
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
Database Development, ETL, Business Intelligence (BI)
Platforms
Oracle, Azure, Databricks, 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, Data Management, Consulting, Azure Data Explorer, Oracle Forms & Reports, Integration, Big Data, User Authentication, Authorization, Azure Stream Analytics, Azure SQL Data Warehouse (SQL DW), Azure Data Lake, DAX
Frameworks
Apache Spark
Libraries/APIs
Pandas, PySpark
Education
Bachelor of Science Degree in Computer Science
Bahauddin Zakariya University - Multan, Pakistan
Certifications
Microsoft Azure Data Engineer Associate
Microsoft
Microsoft Certified Data Analyst (Power BI)
Microsoft
AWS Certified Cloud Practioner
Amazon Web Services, Inc.
Orace Certified Application Developer 6/6i
Oracle Corporation
Sun Certified Programmer for Java 2 Platform
Sun Microsystems