Hazem Kallini
Verified Expert in Engineering
Data Analyst and Developer
Mississauga, ON, Canada
Toptal member since October 14, 2019
Hazem is a data professional with nearly 18 years of experience in BI, data analytics, and data visualization. He specializes in BI, SQL, and ETL development, helping businesses turn complex data into clear, actionable insights. Hazem's strength lies in combining deep technical expertise with strong business awareness and emotional intelligence, ensuring seamless collaboration and impactful solutions.
Portfolio
Experience
- SQL - 18 years
- Data Analysis - 15 years
- Microsoft Power BI - 9 years
- Amazon Web Services (AWS) - 5 years
- Snowflake - 5 years
- Scrum - 5 years
- Python - 5 years
- Data Modeling - 4 years
Preferred Environment
Business Intelligence (BI), SQL, Microsoft Power BI, Snowflake, Power BI Desktop, ETL Tools, Microsoft 365, Microsoft Power Platform, Data Analysis, Data Engineering
The most amazing...
...project I've worked on was migrating a legacy marketing data mart to an enterprise data warehouse.
Work Experience
Data Analyst/Data Modeler
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.
BI Developer and Data Modeler
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.
Lead Consultant
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.
Senior Data Specialist
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.
EDW and BI Senior Analyst Programmer
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.
Experience
Code Samples
https://github.com/kall1802-gitMigration to Enterprise Data Warehouse
Executive Dashboard: Mobile Operator
Shopify Project: Print On-demand
Managed all online store including product listing, store design, order fulfillment, and customer service
Quinde Foundation Education Project (TopVolunteer)
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.
Education
Bachelor of Science Degree in Computer Science
Cairo University - Giza, Egypt
Certifications
AWS Certified Developer - Associate
Amazon Web Services
AWS Certified Solutions Architect Associate
AWS
AWS Certified Cloud Practitioner
AWS (Amazon Web Services)
Professional Scrum Master I
Scrum.org
Data Warehouse Concepts, Design, and Data Integration
Coursera
Database Management Essentials
Coursera
R Programming
Coursera
Project Management Professional (PMP)
Project Management Institute
Skills
Libraries/APIs
Fabric, Complex SQL Queries, Pandas
Tools
Informatica ETL, Microsoft Power BI, Git, Microsoft Excel, Tableau, Erwin, Qlik Sense, Power BI Desktop, Power Query, Microsoft Access, Power BI Report Server, IBM InfoSphere (DataStage), Smartsheet, Microsoft Power Apps, Sublime Text, AWS Glue, Microsoft Power Pages, Apache Airflow, Jenkins, GitLab CI/CD, AWS CodeCommit, AWS CodeBuild, Amazon Virtual Private Cloud (VPC), Amazon Simple Notification Service (SNS), Amazon Simple Queue Service (SQS), AWS IAM, Wrike, Asana
Languages
SQL, Python, Snowflake, Transact-SQL (T-SQL), Power Query M, Stored Procedure, R, Java, CSS, HTML, HTML5, Excel VBA, VB, Visual Basic for Applications (VBA)
Paradigms
Database Design, ETL, Business Intelligence (BI), Agile, Scrum, Testing, Requirements Analysis, DevOps, Agile Project Management
Platforms
Amazon Web Services (AWS), Shopify, Microsoft Power Automate, SharePoint, Microsoft Fabric, Docker, Microsoft, Qlik, Azure, Azure Service Fabric, Linux, Visual Studio Code (VS Code), Oracle, Oracle Data Integrator (ODI), QlikView, Kubernetes, AWS Lambda, Amazon EC2, SharePoint 365, Microsoft Power Platform, Azure SQL Data Warehouse, Databricks, Azure Data Lake Storage
Storage
Databases, Relational Databases, Database Modeling, PostgreSQL, Microsoft SQL Server, SQL Stored Procedures, DB, Data Pipelines, Database Architecture, MySQL, Teradata, Oracle RDBMS, Database Administration (DBA), Amazon S3 (AWS S3), PL/SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Functions, SQL Triggers, Database Replication, Datastage, IBM Db2, Database Testing, Azure SQL, Amazon DynamoDB, Microsoft Entra ID
Frameworks
Hadoop
Industry Expertise
Project Management
Other
Data Visualization, Data Modeling, Data Analysis, Stripe Payments, Shopify Payments, Data Warehousing, Data Warehouse Design, Data Engineering, Data, Data Architecture, DAX, 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, Data Migration, Database Normalization, Performance Tuning, Query Optimization, Data Transformation, Architecture, Airtable, ETL Tools, Communication, Relational Database Design, Relational Database Services (RDS), ELT, CSV, ETL Pipelines, Fact Tables, Excel 365, Analytics, Automation, Data Integrity, Documentation, Indexing, Project Management Professional (PMP), PSM-1, Containers, Amazon RDS, APIs, SharePoint Online, Report Design, Dashboard Design, Product Lifecycle Management (PLM), Amazon EventBridge, Business Analysis, Training, Data Governance, API/Services Architecture, SaaS, Read Replicas, Supabase, Informatica, SAP BusinessObjects (BO), Cloud, AWS Cloud Architecture, Cloud Architecture, IT Project Management, R Programming, Oracle BI, AWS CodePipeline, Amazon API Gateway, Program Management, Data Science, Data Build Tool (dbt), ClickUp, Microsoft 365, API Integration, Zoho
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
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring