Omar Sultan, Developer in Cairo, Cairo Governorate, Egypt
Omar is available for hire
Hire Omar

Omar Sultan

Verified Expert  in Engineering

Data Warehousing Developer

Location
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

HYVE Technology Consulting
Azure Machine Learning, MicroStrategy, Microsoft Power BI, Datazen, IBM Cognos...
Runtriz
Big Data, Microsoft Power BI, IBM Data Studio, Data Warehousing...
OMS
Vertica, MicroStrategy, Datazen, Microsoft Power BI, Microsoft SQL Server...

Experience

Availability

Part-time

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

2015 - PRESENT
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.
Technologies: Azure Machine Learning, MicroStrategy, Microsoft Power BI, Datazen, IBM Cognos, Microsoft SQL Server, Data Warehousing, T-SQL (Transact-SQL)

Dashboard Developer

2017 - 2020
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.
Technologies: Big Data, Microsoft Power BI, IBM Data Studio, Data Warehousing, T-SQL (Transact-SQL)

Business Intelligence Solutions Consultant | Team Lead

2011 - 2015
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.
Technologies: Vertica, MicroStrategy, Datazen, Microsoft Power BI, Microsoft SQL Server, Data Warehousing, T-SQL (Transact-SQL)

Business Intelligence Senior Developer

2010 - 2011
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.
Technologies: MicroStrategy, Microsoft SQL Server, Data Warehousing, T-SQL (Transact-SQL)

Business Intelligence Specialist

2009 - 2010
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.
Technologies: Datastage, IBM Db2, IBM Cognos, SAP BusinessObjects (BO), Microsoft SQL Server, Data Warehousing, T-SQL (Transact-SQL)

Business Intelligence Developer

2007 - 2009
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.
Technologies: SAP BusinessObjects (BO), Microsoft SQL Server, Data Warehousing, T-SQL (Transact-SQL)

Sales Dashboards for a Leading FMCG Company in the Middle East

I implemented sales dashboards on top of three different operating systems to report on the company's sales, financials, and operations. The dashboards serve different levels, starting from the sales rep level and moving up to the CFO and CEO levels.

CEO and CFO Dashboards for a Multinational Bank in the Middle East

I implemented profitability dashboards that focus on the bank's profitability, broken down into various subviews to cover customers, branches, products, and more. The solution was built using Power BI and SQL Server 2019.

Sur+ Banking Solution

I am currently leading the development and implementation of Sur+, a retail banking analytics solution built on top of Microsoft SQL Server, Power BI, and Datazen. My role includes design and feature development.

Project and Portfolio Insights

I contributed to the development of PPI, a set of portfolio and project analytics dashboards built on top of Microsoft Project Server. This included requirements gathering, implementation, and analysis. I was also involved in the project deployment.

Chatbot Reporting Solution

A reporting platform for a chatbot product implemented in one of the top three largest banks in Egypt.

The solution was built using Power BI and provides both analytical and real-time dashboards for the marketing and operations team.

Media ME (Big Data)

I implemented and designed a big data solution hosted on Hortonworks for crawling news agencies, as well as provided statistics and sentiment analysis for particular figures, companies, projects, and more.

Education ML

I was part of the team that worked on implementing Education ML. This solution provides predictive analytics to education governing bodies around the expected performance of students and their likelihood of passing.

RTA ITIC SPD Data Warehouse and Reporting Solution

I led the team that implemented an enterprise data warehouse for Dubai's Roads and Transport Authority. The solution integrated eight systems into the DW and provided around 60 dashboards and reports.

Travel Vault: Ultimate Travel Assistant

I developed the application Travel Vault as a personal side project.
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

I developed the front-end mobile app and the back end (Azure App Services using Node.js) for this social planning app.

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

I developed a Power BI platform used for reporting and monitoring key government indicators such as SDGs and nationwide KPIs. Power BI, SQL Server 2019, and SSAS 2019 were used for the implementation.

Telco CEO Reporting Dashboards

I implemented Power BI reports on revenue, performance, and growth for the CEO and CFO of a leading telco company in the Middle East. Reports access data in near real-time and provide updates every 10 minutes.

Reports and Dashboards for Hospitality — Runtriz

I implemented reports and dashboards for a global solution provider that works with the top hotel chains to report on top of their hospitality management system and analyze user behavior. The solution serves more than four global chains with around 3,000 establishments.

Languages

T-SQL (Transact-SQL), Python, SQL, Swift 2, Objective-C, JavaScript

Tools

Microsoft Power BI, Cognos Analytics 11, Xcode, Azure Machine Learning, Tableau, IBM Cognos, IBM Data Studio, Azure App Service, SSAS

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

Other

Data Warehousing, Requirements & Specifications, Machine Learning, MicroStrategy, Data Mining, Cognos 10, SAP BusinessObjects (BO), Big Data, Dashboards, Microsoft Project Server, Data Warehouse Design, IT Security, BI Reporting, Predictive Analytics

Frameworks

Cocoa Touch, Core Data, Spark, iOS SDK, Hadoop

Libraries/APIs

Node.js

Platforms

iOS, Azure

2001 - 2006

Bachelor's Degree in Computer Science

The American University in Cairo (AUC) - Cairo, Egypt

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring