FlowCV Logo
resume profile picture
Abanoub Ibrahim Data Analyst
Summary

A highly analytical Data Analyst passionate about shaping future-oriented solutions. I leverage SQL and various data visualization tools to perform complex analyses, define key performance indicators (KPIs), and develop interactive dashboards. I'm eager to apply my skills in data analysis and strategic BI consulting to drive data-driven decision-making within a dynamic, geoinformatics-focused team.

Key Skills: SQL, ETL development, Data Warehousing (DWH), Data Modeling, Power BI

Professional Experience
10/2024 – presentCairo, Egypt
Business Intelligence Engineer, CIB Bank
  • •Developed and maintained over 10+ ETL workflows using Informatica to load data into a DataVault schema-based data warehouse, ensuring accurate and timely integration from multiple source systems.

  • •Edited and adjusted SQL queries in Teradata based on changing business requirements to ensure accurate reporting and data transformation.

  • •Gained hands-on experience with SAP BusinessObjects by building sample dashboards as part of internal training.

  • •Coordinated with the quality team to validate data and ensure that implemented changes met business requirements.
    • 06/2024 – 09/2024Cairo, Egypt
    Data Analyst, Fawry for E-Payments
  • •Led development of a Tableau dashboard for a new financial product, creating all KPIs independently to enhance executive tracking and support decision-making during its first year.

  • •Collaborated with 4+ cross-functional teams to gather requirements and ensure data accuracy across multiple sources.

  • •Created and maintained daily SQL reports for 5+ business units, enabling faster access to critical data and improving operational decision-making.
    • 08/2023 – 05/2024Cairo, Egypt
    Business Intelligence Developer, Bingo Global for Trading & Supplies
  • •Designed and delivered executive dashboards for the CEO, enabling real-time decision-making and improved strategic alignment.

  • •Created customized weekly performance dashboards for 15 branches, helping teams hit targets and contributing to a 25% sales increase across locations.

  • •Solely managed the enterprise Data Warehouse and scheduled SSIS packages, ensuring 100% data reliability and timely data refresh.

  • •Developed and delivered ad hoc reports across departments—including sales, warehouse, and finance—based on CEO and management requests.

  • •Built a comprehensive BI system for sister company Anime Spot, contributing to growth from 1 to 3 branches and increasing monthly revenue from EGP 250K to EGP 1M.

  • •Participated in the hiring process: screened 100+ CVs, created technical tests, conducted interviews, and onboarded new team members.

  • •Led and mentored a team of 5 junior BI engineers, supporting their development and ensuring smooth BI operations.
    • Education
    03/2023 – 06/2023
    Diploma, Business Intelligence Developer, Information Technology Institute(ITI)
    2018 – 2022
    Bachelor's degree, Computer Sciences, Helwan University
    Skills
    Technical Skills: Python | R | Microsoft SQL Server | SQL Teradata | SQL Server Integration Services (SSIS) | SQL Server Analysis Services (SSAS) | SQL Server Reporting Services (SSRS) | Extract Transform Load (ETL) | Informatica | Data Warehouse | Power BI | Data Analysis Expressions (DAX) | Tableau | Excel | Azure | Robotic Process Automation (RPA) | SAP BO
    Personal Skills: Communication skills | Presentation skills | Time Management | Adaptability | Willingness To Learn | Leadership | Attention to Details
    Languages
    English(C1)
    German (Currently Studying A1)
    Volunteering
    09/2018 – 05/2019
    Minders, Project Manager
  • •Collaborated with student organizations, clubs, and volunteers to coordinate project activities, delegate tasks, and ensure effective teamwork
    • Courses
    01/2023 – 07/2023
    Google Data Analytics, Coursera
    04/2023 – 05/2023
    Power BI Fundamentals Track, Datacamp
    Projects
    06/2023
    Northwind Traders | Maven Analytics Challenge, Power BI

    Building a top-level KPI dashboard for the executive team. Its purpose should be to allow them to quickly understand the company's performance n key areas like Sales trends, Product performance, Key customers, and Shipping costs

    05/2023 – 06/2023
    ITI Graduation Project | Exam System Management, MS SQL Server, SSRS, MS Power BI, Tableau
  • •Developed a whole exam management system, starting with modeling an ERD, then creating a database using MS SQL Server.
  • •Created procedures and functions to generate exams, save student answers, correct them, and easily manage all database tables
  • •Creating reports and dashboards using SSRS, MS Power BI, and Tableau.
    • 04/2023
    World Happiness Analysis between 2018 and 2019, Tableau

    Conducted in-depth analysis of global happiness levels using the World Happiness Report, identifying key factors influencing happiness scores and presenting findings through interactive visualizations using Tableau.

    04/2023
    Churn Rate for Telecom provider, Power BI

    Analyzed customer churn in a fictitious telecom dataset (Databel), Understanding why customers are leaving and providing insights for business improvement.

    Awards
    05/2023
    SQL Golden badge, HackerRank