Tarek Mahmoud
Verified Expert in Engineering
Business Intelligence and Data Warehouse Developer
Tarek is a business intelligence and data warehousing expert with 10+ years of experience at Touch, the leading mobile telecommunications and data operator in Lebanon. He has broad experience and deep expertise in building data warehouses, data models, and business intelligence solutions, including advanced reports, KPIs, and dashboards.
Portfolio
Experience
Availability
Preferred Environment
Business Intelligence (BI), Data Warehousing, Oracle, Microsoft BI Stack
The most amazing...
...experiences I've had were designing and creating data warehouses, models, reports, and dashboards, using ETL and Microsoft BI tools.
Work Experience
Power BI Developer
Daggerwing Group
- Collected and analyzed the business requirements from the end user and proposed the best dashboards to fulfill his business needs.
- Created multiple data models on Power BI Pro, using the M Language and DAX formulas.
- Created dashboards, using Power BI Pro, related to revenue, expenses, time and labor, skills, and other factors.
- Set up all the refreshes of the data model and access for end users.
Business Intelligence and Data Warehouse Manager
Touch Lebanon
- Led and managed the business intelligence and data warehouse team within the IT department.
- Developed and managed the data warehouse using Oracle Database and business intelligence systems using Microsoft BI tools.
- Headed all Oracle SQL and PL/SQL development within the company.
IT Instructor
Lebanese University
- Assisted students in learning Oracle technologies (Database, SQL, PL/SQL, Forms, Reports, and Data Warehouse), database concepts, and BI tools.
- Supervised final projects and mentored numerous students.
- Taught courses focused on database management systems.
Data Engineer
Jurlique
- Created a new data warehouse using a Microsoft SQL Server database and solved many problems related to the old data warehouse.
- Developed tens of SSIS packages to load data from files and APIs into the data warehouse.
- Created many reports using Microsoft SSRS to help the end users extract the warehouse data.
- Developed many dashboards using Microsoft Power BI.
Professor of IT Courses
Arab Open University
- Assisted students in learning Oracle technologies (Database, SQL, PL/SQL, Forms, Reports, and Data Warehouse), database concepts, and BI tools.
- Supervised final projects and mentored numerous students.
- Taught courses focused on database management systems.
Oracle Programmer
BML Istisharat SAL
- Created programs and applications using Oracle Forms 6i and 9i.
- Developed a wide variety of reports using Oracle Reports 6i and 9i.
- Created Oracle packages, procedures, and functions.
Experience
Telecom Data Warehouse and Business Intelligence System
Created a robust ETL tool on Unix scripts to upload all files related to CDRs, CRM, billing, roaming, and recharges, where over 150 million records are loaded every day.
Set up multiple packages, using the Microsoft SSIS tool to sort data into the data warehouse from different data sources, including QMS, ADM, OF, and the website mobile app.
Designed 600+ daily used and complex reports, including one for customer contacts and another for customer invoices, using the Microsoft SSRS tool.
Produced dozens of tabular cubes and cube models using the Microsoft SSAS tool to meet the business unit’s needs when using Power BI, the self-service business intelligence tool.
Created dozens of interactive dashboards, using the web-based and mobile app versions of Power BI, which are relied upon heavily and constantly used by many business units.
Generated models that facilitate the use of analytical services via Microsoft Azure services.
Data Engineer
Power BI Data Models and Dashboards
Skills
Languages
SQL, Stored Procedure, T-SQL (Transact-SQL), SQL DML, Snowflake, Python 2, Python
Tools
Microsoft Power BI, Oracle Forms, Oracle Reports, Microsoft Access, Microsoft Excel, Power Query
Paradigms
Business Intelligence (BI), Database Design, ETL, Agile
Platforms
Oracle, Microsoft BI Stack
Storage
Oracle SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Oracle PL/SQL, SQL Server Reporting Services (SSRS), SQL Stored Procedures, Microsoft SQL Server, PL/SQL, Data Lakes, Databases, Database Administration (DBA)
Other
Data Warehousing, Data Engineering, Data Modeling, Data Visualization, Data Reporting, ETL Tools, SSRS Reports, Data Architecture, Big Data, Datasets, Data Analytics, Data Cleansing, Data Cleaning, Data Profiling, BI Reports, DAX, Dashboards, PL/SQL Tuning, Performance Tuning, Database Optimization, Query Optimization, Communication, Information Visualization, Data Management, Tutoring, University Teaching, Data Analysis, Education, Project Management Professional (PMP)
Education
Master's Degree in Information Technologies
Sagesse University - Furn-EL-Chebak, Lebanon
Master's Degree in Information Technologies
Saint Joseph University of Beirut - Beirut, Lebanon
Certifications
Project Management Professional (PMP)
Project Management Institute (PMI) | via New Horizons
Microsoft SQL Server 2012/2014 Analysis Services
Microsoft
Developing SQL Data Models
Microsoft
Analyzing and Visualizing Data with Microsoft Power BI
Microsoft
Data AI: Enterprise Business Intelligence (BI) with Azure Analysis Services
Microsoft
Analyzing and Visualizing Data with Microsoft Power BI
Microsoft
Oracle Database 11g: SQL Tuning
Oracle
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