Hazem Kallini, Data Analyst and Developer in Mississauga, ON, Canada
Hazem Kallini

Data Analyst and Developer in Mississauga, ON, Canada

Member since July 26, 2016
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. He pays attention to effective communication and high quality.
Hazem is now available for hire

Portfolio

Experience

Location

Mississauga, ON, Canada

Availability

Part-time

Preferred Environment

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

The most amazing...

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

Employment

  • Data Analyst/Data Modeler

    2020 - PRESENT
    Fortune 100 North American Construction Equipment Manufacturer - Freelance via Toptal
    • Built and maintained 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, Data Analyst
  • BI Developer and Data Modeler

    2015 - 2020
    KPN B.V.
    • 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, Data Analyst
  • Lead Consultant

    2013 - 2015
    Altran B.V.
    • 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 provide analysis to various stakeholders.
    Technologies: Data Visualization, Relational Databases, Informatica ETL, Business Intelligence (BI), ETL, Data Warehousing, Data Warehouse Design, SQL, SAP BusinessObjects (BO), Oracle, Teradata, Informatica, Data Engineering, Data, Data Architecture, Data Analyst
  • Senior Data Specialist

    2012 - 2013
    IBM
    • 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 Warehouse Design, Data Warehousing, SQL, IBM Db2, Datastage, Data Engineering, Data, Data Analyst
  • EDW and BI Senior Analyst Programmer

    2008 - 2012
    Orange
    • Contributed in the migration to a Teradata enterprise data warehouse.
    • Developed frequent business reports using BusinessObjects.
    • Created KPI dashboards using QlikView.
    • 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, Data Analyst

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.

  • 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

Skills

  • Languages

    SQL, Stored Procedure, Python, R, Java, CSS, HTML, HTML5
  • Tools

    Informatica ETL, Microsoft Power BI, Git, Microsoft Excel, Erwin, IBM InfoSphere (DataStage), Tableau, Apache Airflow, Jenkins, GitLab CI/CD
  • Paradigms

    Database Design, ETL, Business Intelligence (BI), Agile, Scrum, Testing, DevOps
  • Platforms

    Shopify, Amazon Web Services (AWS), Docker, Linux, Visual Studio Code, Oracle, Oracle Data Integrator (ODI), QlikView, Kubernetes
  • Storage

    Databases, Relational Databases, Database Modeling, SQL Stored Procedures, MySQL, Teradata, Oracle RDBMS, Datastage, PostgreSQL, IBM Db2, Microsoft SQL Server, Database Administration (DBA), Database Testing
  • Other

    Data Visualization, Data Modeling, Stripe Payments, Shopify Payments, Data Warehousing, Data Warehouse Design, Data Engineering, Data, Data Analyst, Indexing, Project Management Professional (PMP), PSM-1, Data Analysis, Containers, AWS, Data Architecture, Informatica, SAP BusinessObjects (BO), Cloud, AWS Cloud Architecture, Cloud Architecture, IT Project Management, R Programming, Oracle BI
  • Frameworks

    Hadoop
  • Industry Expertise

    Project Management

Education

  • Bachelor of Science Degree in Computer Science
    2003 - 2007
    Cairo University - Giza, Egypt

Certifications

  • AWS Certified Solutions Architect - Associate (SAA)
    AUGUST 2020 - AUGUST 2023
    Amazon Web Services
  • AWS Certified Cloud Practitioner
    MARCH 2020 - MARCH 2023
    AWS (Amazon Web Services)
  • Professional Scrum Master I
    MAY 2016 - PRESENT
    Scrum.org
  • Data Warehouse Concepts, Design, and Data Integration
    DECEMBER 2015 - PRESENT
    Coursera
  • Database Management Essentials
    NOVEMBER 2015 - PRESENT
    Coursera
  • R Programming
    MAY 2014 - PRESENT
    Coursera
  • Project Management Professional
    DECEMBER 2012 - PRESENT
    Project Management Institute

To view more profiles

Join Toptal
Share it with others