Business Intelligence Developer with 1+ years in Data Warehousing & BI Solutions
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Business Intelligence Engineer with strong hands-on experience in data warehousing, ETL pipelines, and data visualization. Skilled in building end-to-end BI solutionsExperienced in designing models, integrating data from REST APIs, and ensuring data quality. Familiar with modern data platforms Detail-oriented, fast learner, and collaborative team player with exposure
ITI
Business Intelligence Training Program
May 1, 2024 – September 1, 2024
Zagazig University
Bachelor of Computer Science · Computer Science
August 1, 2019 – June 30, 2023
NTI
Data Analyst Instructor
July 1, 2025 – Present
India
Corelia
penetration tester Trainee
October 1, 2024 – June 1, 2025
India
Customer Churn Analysis & Prediction
June 24, 2026 – Present
Built end-to-end ETL pipelines using SQL Server. Cleaned and transformed data for analysis. Developed Power BI dashboards with advanced DAX. Built a Random Forest model in Python for churn prediction. Visualized predicted churners and customer segments.
Pharmaceutical Sales Data Warehouse and Analysis
June 24, 2026 – Present
Developed a comprehensive Data Warehouse (DWH) for retail sales data. Created a star schema, defined facts and dimensions. Implemented an ETL pipeline By python for data cleaning and population. Utilized SQL for analytical queries, including top products and sales representatives rankings. Designed a Power BI dashboard for descriptive analysis and data visualization, enhancing decision-making capabilities. Delivered complete documentation, including a backup of the DWH, ETL scripts, SQL queries, and presentation materials.
Examination System (ITI Graduation Project)
June 24, 2026 – Present
Developed an automated online exam system with SQL database and Power BI dashboard for KPI analysis. Designed an Entity Relationship Diagram (ERD) to visualize entity relationships. Mapped data fields to create a robust data model. Implemented database using SQL Server Management Studio, creating tables and defining schema. Developed stored procedures for data management (Insert, Update, Select, Delete). Automated exam generation, response capture, and grading processes. Established a star schema data warehouse for improved data organization using SSIS and SSAS. Generated insightful reports with SSRS and Power BI Report Builder for enhanced user access to data.
Sales Data Mart Using SSIS
June 24, 2026 – Present
Data Structuring: Developed a Sales Data Mart to support the sales department, organizing data for efficient reporting and analysis. Reporting Solutions: Created tailored reports and dashboards to deliver insights for sales management, enhancing decision-making capabilities.
360 Security Compliance Portal (National Bank of Egypt)
June 24, 2026 – Present
Developed a security compliance portal to manage third-party compliance, including control framework updates, document uploads,and incident reporting. Implemented SQL queries for data retrieval and analysis. Developed a SQL database and Power BI dashboard for KPI analysis in security compliance. Created interactive dashboards with DAX measures for key metrics. Enabled real-time tracking of overall vendor performance. Enhanced the bank's capability to monitor and maintain compliance status across all third parties.
Data Pipeline project
June 24, 2026 – Present
Configured dbt and connected it to Snowflake. Built staging, intermediate, and mart models. Used dbt sources and refs for modular pipelines. Automated workflows using Apache Airflow (DAGs). Applied best practices for scalable data pipelines.
Cultural Fit Analysis
The candidate demonstrates a strong interest and commitment to the Business Intelligence domain through a dedicated training program (ITI), relevant academic projects, and personal projects. The 'Data Analyst Instructor' role further solidifies their expertise and ability to articulate complex BI concepts. The diversity of projects, from customer churn analysis to pharmaceutical sales and security compliance, shows adaptability and a broad understanding of how BI can be applied across different industries. The inclusion of a professional project at the National Bank of Egypt indicates experience in a structured corporate environment. The penetration tester trainee role is an outlier but could suggest a broader technical curiosity.
Soft Skills & Operational Fit
The candidate's resume highlights being 'Detail-oriented, fast learner, and collaborative team player,' which are positive indicators for operational fit. The instructor role at NTI suggests good communication and teaching skills, which can translate to effective collaboration and knowledge sharing within a team. The penetration tester trainee role, while not directly related to BI, indicates a problem-solving mindset and attention to detail.