Khalid Amin
Verified Expert in Engineering
Data Modeling Developer
Khalid是一位经验丰富的数据专业人士,拥有20多年的行业经验. His expertise includes data architecture, data engineering, modern data warehousing, big data, and analytics. Khalid拥有Azure数据工程和Power BI方面的微软认证. 此外,他精通SQL Server和Oracle数据库技术. 哈立德有很好的人际交往能力,是一个真正的团队成员.
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...
...我真正引以为傲的成就是,我对一个企业数据库进行了重构和性能调优,并将其性能提高了约500%
Work Experience
Data Architect
BJSS
- 曾为一家领先的全球客户担任数据架构师.
- Involved in data architecture, data engineering, 并通过数据策略构建全局通用数据模型.
- 参与在全局公共数据模型之上设计和开发kpi和语义层.
Senior Data Consultant
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创建分析和商业智能仪表板和报告.
Senior Consultant - Data and BI
Salmat
- 设计端到端数据集成和ETL管道,以从各种来源摄取数据.
- Wrote Microsoft SQL Server (SQL, TSQL, 存储过程(Stored Procedures)代码用于BI报告的一个通信系统的大, Australia-based enterprises.
- 重写SQL查询,在某些情况下将性能提高100%以上.
Software Engineer
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技术为多个项目设计和编程后端数据库.
Software Engineer
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开发团队.
Database Developer
Fauji Software Company Islamabad
- 为企业级项目开发Oracle数据库查询、表单和报告.
- 创建了一个实用程序,该实用程序自动记录和创建来自底层数据库对象的数据字典.
- 为公司软件开发部门开发编码标准做出了贡献.
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
数据库开发、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
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
How to Work with Toptal
在数小时内,而不是数周或数月,我们的网络将为您直接匹配全球行业专家.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring