Hazem is available for hire

Hazem Kallini

Verified Expert in Engineering

Data Analyst and Developer

Location

Mississauga, ON, Canada

Toptal Member Since

October 14, 2019

Hazem has over ten years of experience working with data and analytics. His primary expertise includes ETL, data warehousing, and business intelligence. He has worked on large enterprise projects that involved processing and analyzing the data of more than thirty million customers. Hazem pays attention to effective communication and high quality.

Code Review Data Warehousing Data Warehouse Design Data Reporting Data Engineering Data Analytics Integration Data Visualization Data Modeling SQL Microsoft Excel Databases Relational Databases ETL Business Intelligence (BI)

Portfolio

Fortune 100 North American Construction Equipment Manufacturer (Toptal Client)

Data Visualization, Relational Databases, Microsoft Power BI, Data Modeling...

Geoff Meyerkord Law Firm LLC

SharePoint, SharePoint 365, SharePoint Online

Royal KPN Netherlands

Data Visualization, Stored Procedure, Indexing, Relational Databases, Erwin...

Experience

SQL - 12 years Microsoft Power BI - 6 years Scrum - 5 years Database Modeling - 5 years Data Analysis - 5 years Data Modeling - 4 years Python - 2 years Amazon Web Services (AWS) - 1 year

Availability

Part-time

Preferred Environment

Git, Linux, Business Intelligence (BI), SQL, Agile, DevOps, Cloud, Tableau, Smartsheet

The most amazing...

...thing was a migration project of a legacy marketing data mart to an enterprise data warehouse.

Work Experience

Data Analyst/Data Modeler

2020 - PRESENT

Fortune 100 North American Construction Equipment Manufacturer (Toptal Client)

Built and maintained a common data model using Erwin according to company and industry standards.
Gathered requirements from dealers and company teams to create and maintain interfaces and other documentation based on those needs.
Worked with the Dealer Data Strategy team, dealers, and developers to define and ensure adherence to change management processes and versioning control.
Created, maintained, and published release notes for dealer data models.

Technologies: Data Visualization, Relational Databases, Microsoft Power BI, Data Modeling, SQL, Oracle Data Integrator (ODI), Erwin, Data Engineering, Data, Data Architecture, Microsoft Excel, Database Testing, Microsoft SQL Server, Database Modeling, Testing, Data Analysis, DAX, DB, Microsoft Power Apps, Data Analytics, Database Schema Design, Snowflake, Data Reporting, Business Requirements, Azure SQL, Source Code Review, Code Review, Task Analysis, Interviewing, Data-level Security, APIs, Microsoft Power Automate, SharePoint

SharePoint Specialist

2023 - 2023

Geoff Meyerkord Law Firm LLC

Built a SharePoint intranet for the law firm team to collaborate on.
Provided training to the end-users on how to use the new SharePoint intranet.
Created multiple Power Automate flows to support the firm workflows.

Technologies: SharePoint, SharePoint 365, SharePoint Online

BI Developer and Data Modeler

2015 - 2020

Royal KPN Netherlands

Developed ETL flows to support reporting requirements.
Created visuals, reports, and dashboards using different reporting tools such as Power BI and Oracle BI.
Built deployment and test automation scripts using Python.
Built data models for various BI solutions using erwin Data Modeler.
Supported the operations using various DevOps and monitoring tools, such as Jenkins and Apache Airflow.
Worked as a data modeler for a master data management program using erwin Data Modeler.

Technologies: Data Visualization, Stored Procedure, Indexing, Relational Databases, Erwin, Informatica ETL, Data Modeling, Scrum, Business Intelligence (BI), ETL, Data Warehousing, Data Warehouse Design, SQL, Docker, Git, Jenkins, Microsoft Power BI, Python, Hadoop, Apache Airflow, Oracle, Teradata, Informatica, Data Engineering, Data, Data Architecture, Microsoft Excel, PSM-1, Database Testing, PostgreSQL, Database Modeling, Testing, Data Analysis, DAX, DB, Data Loading, Data Analytics, Database Schema Design, Integration, Reporting, Data Reporting, Business Requirements, Dashboards, Technical Hiring, Source Code Review, Code Review, Task Analysis, Interviewing, Sublime Text, Data-level Security, APIs

Lead Consultant

2013 - 2015

Altran Netherlands

Developed and supported data warehousing innovation using Informatica PowerCenter, Teradata, and SAP BusinessObjects.
Supported the DWH day-to-day operations by monitoring daily jobs.
Participated in an IT transformation project with a client for the data domain in the telecommunications industry.
Oversaw campaign management teams within the organization by optimizing test and target group customers.
Developed and maintained SQL scripts on different platforms, including Teradata and Oracle, to analyze various stakeholders.

Technologies: Data Visualization, Relational Databases, Informatica ETL, Business Intelligence (BI), ETL, Data Warehouse Design, Data Warehousing, SQL, SAP BusinessObjects (BO), Oracle, Teradata, Informatica, Data Engineering, Data, Data Architecture, Microsoft Excel, SQL Stored Procedures, Database Testing, Database Modeling, Testing, Data Analysis, DB, Data Loading, Data Analytics, Integration, Reporting, Data Reporting, Business Requirements, Dashboards, Source Code Review, Code Review, Task Analysis, Data-level Security

Senior Data Specialist

2012 - 2013

IBM Egypt

Developed ETL flows using IBM InfoSphere DataStage.
Designed and implemented a DWH model on a DB2 database.
Maintained the operations of a medium-sized DWH solution.
Performed migrations of higher versions of ETL and database tooling.
Developed SQL scripts for reporting and testing purposes.

Technologies: Relational Databases, Business Intelligence (BI), ETL, Data Warehousing, Data Warehouse Design, SQL, IBM Db2, Datastage, Data Engineering, Data, Data Analysis, Microsoft Excel, SQL Stored Procedures, Database Testing, IBM InfoSphere (DataStage), DB, Data Loading, Data Analytics, Database Schema Design, Integration, Reporting, Data Reporting, Source Code Review, Code Review, Task Analysis, Data-level Security

EDW and BI Senior Analyst Programmer

2008 - 2012

Orange Egypt

Contributed to the migration to a Teradata enterprise data warehouse.
Developed frequent business reports using BusinessObjects.
Created KPI dashboards using QlikView and Built ETL flows using IBM Infosphere DataStage.
Developed SQL scripts to build various Data Marts for different business users.
Wrote ad-hoc reports for campaigning and operational optimization purposes.

Technologies: Data Visualization, Stored Procedure, Relational Databases, Business Intelligence (BI), ETL, Data Warehouse Design, Data Warehousing, SQL, Oracle, SAP BusinessObjects (BO), QlikView, Datastage, Teradata, Data Engineering, Data, Microsoft Excel, SQL Stored Procedures, Database Testing, IBM InfoSphere (DataStage), Data Analysis, Data Loading, Dashboards

Experience

Code Samples

https://github.com/kall1802-git

This is my GitHub account, including all my code repositories of programming languages I'm currently using. It's utilized to demonstrate my developer skills and continuous learning of technology latest skills.

Migration to Enterprise Data Warehouse

A migration project of a legacy marketing data mart to an enterprise data warehouse. The project involved business discovery, data modeling, and implementation of ETL flow phases.

Executive Dashboard: Mobile Operator

An executive dashboard to support board members of a major mobile operator company. It monitored the key performance indicators of the company operations.

Shopify Project: Print On-demand

Built and operated an online shop using Shopify platform to sell print-on-demand merchandise between 2018 and 2019.
Managed all online store including product listing, store design, order fulfillment, and customer service

Quinde Foundation Education Project (TopVolunteer)

Quinde Foundation´s social work model looks to change the reality of children and youth during their growth and stay in an orphanage. The base of their program is to offer physiological support during the implementation of educational activities.
The project helped the foundation to start creating their educational platform (MVP), where they can include their programs and give access to all the children that benefit from their work.

Skills

Languages

SQL, Stored Procedure, Python, R, Snowflake, Java, CSS, HTML, HTML5

Tools

Informatica ETL, Microsoft Power BI, Git, Microsoft Excel, Tableau, Erwin, IBM InfoSphere (DataStage), Smartsheet, Microsoft Power Apps, Sublime Text, Apache Airflow, Jenkins, GitLab CI/CD, AWS CodeCommit, AWS CodeBuild, Amazon Virtual Private Cloud (VPC), Amazon Simple Notification Service (Amazon SNS), Amazon Simple Queue Service (SQS), AWS IAM

Paradigms

Database Design, ETL, Business Intelligence (BI), Agile, Scrum, Testing, DevOps, Agile Project Management

Platforms

Shopify, Microsoft Power Automate, SharePoint, Amazon Web Services (AWS), Docker, Linux, Visual Studio Code (VS Code), Oracle, Oracle Data Integrator (ODI), QlikView, Kubernetes, AWS Lambda, Amazon EC2, SharePoint 365

Storage

Databases, Relational Databases, Database Modeling, Microsoft SQL Server, SQL Stored Procedures, DB, MySQL, Teradata, Oracle RDBMS, Amazon S3 (AWS S3), Datastage, PostgreSQL, IBM Db2, Database Administration (DBA), Database Testing, Azure SQL, Amazon DynamoDB

Other

Data Visualization, Data Modeling, Stripe Payments, Shopify Payments, Data Warehousing, Data Warehouse Design, Data Engineering, Data, Data Loading, Data Analytics, Database Schema Design, Integration, Reporting, Data Reporting, Business Requirements, Dashboards, Technical Hiring, Source Code Review, Code Review, Task Analysis, Interviewing, Data-level Security, Indexing, Project Management Professional (PMP), PSM-1, Data Analysis, Containers, Data Architecture, DAX, APIs, Informatica, SAP BusinessObjects (BO), Cloud, AWS Cloud Architecture, Cloud Architecture, IT Project Management, R Programming, Oracle BI, AWS CodePipeline, Amazon API Gateway, Amazon RDS, SharePoint Online, Technical Program Management, Program Management

Frameworks

Hadoop

Industry Expertise

Project Management

Education

2003 - 2007

Bachelor of Science Degree in Computer Science

Cairo University - Giza, Egypt

Certifications

AUGUST 2022 - AUGUST 2025

AWS Certified Developer - Associate

Amazon Web Services

AUGUST 2020 - AUGUST 2023

AWS Certified Solutions Architect Associate

AWS

MARCH 2020 - MARCH 2023

AWS Certified Cloud Practitioner

AWS (Amazon Web Services)

MAY 2016 - PRESENT

Professional Scrum Master I

Scrum.org

DECEMBER 2015 - PRESENT

Data Warehouse Concepts, Design, and Data Integration

Coursera

NOVEMBER 2015 - PRESENT

Database Management Essentials

Coursera

MAY 2014 - PRESENT

R Programming

Coursera

DECEMBER 2012 - DECEMBER 2024

Project Management Professional (PMP)

Project Management Institute

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.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

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