Elzain Ezeldin Eltaher

Business Intelligence

Dubai, UAE

Profile summary

I am a passionate engineer, BI enthusiastic, passionate developer, and curious learner who holds , and I have three years of experience in the IT industry. I am passionate about business intelligence and designing, creating, building, and maintaining data pipelines to collect row data from various sources and creating reports and dashboards using various BI technologies including T-SQL, MSBI (SSIS, SSAS, SSRS), RDBMS (SQL Server, Oracle, MySQL), ETL tools (SSIS, ODI), data visualization tools (Power BI, Tableau), PowerPivot, Power Query, DAX, Excel, and adaptable to new technologies when required.

Career highlights

Spearheaded ETL Optimization Project: Led a project to streamline ETL processes using SSIS, resulting in a 20% reduction in data loading time and improved data accuracy for downstream reporting.

Key skills

Skills
Data CollectionData CleaningRDBMS (SQL Server)Data WarehousingData ModelingData AnalysisProblem solvingPythonSQL CodingExcel SheetData visualizationCloud Computing (AWS, Azure, GCP)ETL Tools (e.g., Informatica PowerCenter, Azure Data Factory, AWS Glue)Big Data Technologies (Spark, Hadoop)NoSQL Databases (MongoDB, Cassandra)Machine Learning (Regression, Classification, Clustering)

Professional experience

Sales Data Analyst projectJan 2022 - Apr 2023
Alyfhi company | Wad Medani, Sudan

Responsibilities: • Design, develop, and maintain BI solutions for the organization. • Develop and maintain BI solutions including operational reports, dashboards, scorecards, and ad hoc reporting. • Develop, customize, and manage integration tools (SSIS, ODI) monitoring tools, databases, warehouses, and analytical systems. • Develop and execute database queries upon request for data and conduct analysis.

  • Developed, identified, designed, built, tested, optimized, and maintained a Data Warehouse and OLAP Cube using the entire BI tools (RDBMS, MSBI, ODI, and Power BI)
  • Designing and developing data ETL routines.
  • Developed reports interactive business and with drill-down abilities reports using Reporting tools based on existing data sources.
  • Working with programmers, engineers, and management heads to identify process improvement opportunities, propose system modifications, and devise data governance strategies.

Education

Bachelor's Degree, Administration Accounting
Wadmedani Ahlia University