Omar Sultan
Verified Expert in Engineering
Data Warehousing Developer
Cairo, Cairo Governorate, Egypt
Toptal member since June 18, 2020
Omar is a business intelligence and data warehousing professional specialized in Microsoft and IBM products. He is experienced in data model design, ETLs, data warehouses, OLAP cubes, reports, and dashboard design and implementation. Omar has also great experience in designing and implementing business dashboards, focusing on delivering dashboards that answer key questions and guide the users through the journey of exploring their data and getting key information out of it.
Portfolio
Experience
Availability
Preferred Environment
Spark, Cognos 10, Microsoft Power BI, Microsoft SQL Server
The most amazing...
...project I've led is the design and implementation of the enterprise data warehouse for Dubai's railroad authority where we integrated eight systems.
Work Experience
Analytics Architect and Co-founder
HYVE Technology Consulting
- Built data analytics solutions (big data, data warehouse solutions, and BI solutions).
- Consulted on BI best practices for HYVE customers.
- Researched new technologies to provide our customers with the latest and most efficient analytics solutions.
- Designed vertical solutions for various industries (banking, retail, and government).
- Worked with our customers to transfer their business requirements into analytics solutions.
- Implemented a sales dashboard solution for a leading FMCG company in the Middle East.
- Contributed to a reporting platform for a chatbot product implemented in one of Egypt's top three largest banks.
- Implemented CEO and CFO dashboards for a multinational bank in the Middle East.
- Built several Power BI dashboards for government monitoring KPIs.
- Took part in education analytics for one of the leading universities in the Middle East.
Dashboard/Power BI Developer
Runtriz
- Developed over 30 dashboards and reports for on-chain performance and performance establishment level.
- Analyzed data to determine the best structure for reporting, data transformation requirements, and how to get the most out of the data.
- Handled security and access methods for dashboards and reports.
- Analyzed new datasets and new systems to determine the best possible use for reporting.
Business Intelligence Solutions Consultant | Team Lead
OMS
- Gathered requirements and analyzed systems during the initial phases of data warehouse projects.
- Designed and architected projects, working on ETL design and data extraction flows, data mart/warehouse design, dimensional modeling, OLAP cube design, and dashboard design.
- Designed and architected projects for big data solutions using Hadoop (Hortonworks) and contributed to the project definition team responsible for researching and developing big data scenarios for telco and banking.
- Led the technical team during the implementation and delivery phases. Handled the complete implementation of the project, resource task assignment, and solution deployment.
- Collaborated with the quality assurance team to develop the best testing scenarios for projects.
- Handled pre-sales activities for the BI team, analyzed requirements, worked on technical writeups for proposals, and presented our technical offerings to potential clients during the bidding phase.
- Researched and evaluated new technologies and methodologies to help improve the quality of service provided by the BI team.
- Trained and created technical development paths for BI members.
- Managed an 8-member BI team and handled performance evaluations, resource planning and assignment, development plans, and monitoring.
Business Intelligence Senior Developer
OMS
- Gathered requirements and analyzed systems during the initial phases of the project.
- Implemented the BI project, working on ETLs, data mart/warehouse, OLAP cube, and dashboards.
- Handled pre-sales activities for the BI team, analyzing requirements, working on technical writeups for proposals, and presenting our technical offerings to potential clients during the bidding phase.
- Conducted several POCs for potential clients, including research, preparation, and implementation.
- Trained in design and delivery for the internal BI technical development program.
Business Intelligence Specialist
Commercial International Bank CIB
- Designed and implemented data extraction packages from the core banking system.
- Implemented a retail OLAP cube to support reporting for various banking products using Microsoft Analysis Services.
- Implemented retail dashboards and reports using Microsoft Reporting Services and PerformancePoint Services.
Business Intelligence Developer
OMS
- Gathered requirements and provided systems analysis during the initial phases of the project.
- Implemented the BI project, working on ETLs, data mart/warehouse, OLAP cube, and dashboards.
- Handled pre-sales activities for the BI team, analyzing requirements, working on technical writeups for proposals, and presenting our technical offerings to potential clients during the bidding phase.
Experience
Sales Dashboards for a Leading FMCG Company in the Middle East
CEO and CFO Dashboards for a Multinational Bank in the Middle East
Sur+ Banking Solution
Project and Portfolio Insights
Chatbot Reporting Solution
Media ME (Big Data)
Education ML
RTA ITIC SPD Data Warehouse and Reporting Solution
Travel Vault: Ultimate Travel Assistant
It offers features and tools that help you make your trip easier, ensuring you buy and have everything you need and visit all the places you want.
Yallapp — Planning and Outings
Yallapp is an app that makes planning activities and occasions with friends and family way easier. It's free and feels like any other way you plan your activities or respond to others, but it is way more practical.
No more creating groups on chatting applications, texting back and forth, or scrolling through endless conversations to find who is going where and when. Yallapp covers it all.
Yallapp allows users to plan their activities and events with friends in a few clicks. Here's what you can do using Yallapp:
Create — Do you feel like going out, planning a party, or a gathering? With Yallapp, you can create a plan in less than 30 seconds that your Yalla friends will know about or invite them through SMS, having all the details and the link to download the app.
View Plans — Know who's in and out, edit details anytime, chat with friends, add it to your calendar, and much more. All features have been carefully designed for users to view plans in a friendly, practical way.
KPI Monitoring Platform
Telco CEO Reporting Dashboards
Reports and Dashboards for Hospitality — Runtriz
Education
Bachelor's Degree in Computer Science
The American University in Cairo (AUC) - Cairo, Egypt
Skills
Libraries/APIs
Node.js
Tools
Microsoft Power BI, Cognos Analytics 11, Xcode, Azure Machine Learning, Tableau, IBM Cognos, IBM Data Studio, Azure App Service, SSAS
Languages
T-SQL (Transact-SQL), Python, SQL, Swift 2, Objective-C, JavaScript
Paradigms
ETL, Business Intelligence (BI), ETL Implementation & Design, OLAP
Storage
SQL Server Reporting Services (SSRS), Microsoft SQL Server, Datazen, SQL Server Integration Services (SSIS), Apache Hive, SQL Server Analysis Services (SSAS), Datastage, Vertica, IBM Db2
Frameworks
Cocoa Touch, Core Data, Spark, iOS SDK, Hadoop
Platforms
iOS, Azure, SharePoint
Other
Data Warehousing, Requirements & Specifications, Machine Learning, MicroStrategy, Data Mining, Cognos, SAP BusinessObjects (BO), Big Data, Dashboards, Microsoft Project Server, Data Warehouse Design, IT Security, BI Reporting, Predictive Analytics, Azure Data Factory
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