Data Manager
Resume:
Tarek Mahmoud
Beirut, Lebanon
adgn93@r.postjobfree.com
adgn93@r.postjobfree.com
adgn93@r.postjobfree.com
OBJECTIVES My goal is to attain a leading and distinctive managerial position at an innovative and competitive organization which provides a stimulating environment as well as opportunities for career advancement and organizational improvement. My extensive team leadership skills and experience in the business intelligence and data warehousing domains enable me to act effectively and proactively as a transformational IT leader who can inspire positive change among employees, and by proxy, create excellence throughout the organization. EXPERIENCE From 4/2007-Present Down Town, Beirut, Lebanon
Organization: Touch Mobile Interim Company 2 SAL
www.touch.com.lb
Position: Business Intelligence And Data Warehouse Manager Department: Information Technologies
Responsibilities:
Currently leading and managing the Business Intelligence & Data Warehouse team within the IT department.
In 2019, I created a new data warehouse and business intelligence system from the ground up. This system effectively collects all the NGBSS system data from Huawei and then provides all Touch business units with relevant reports, dashboards, KPIs and figures.
The data warehouse was built using Oracle Database on DELL VBLOCK servers. The database architecture of the data warehouse is divided into 3 mains areas: staging, production, and summary areas where they contain more than 700 tables and 450 procedures, packages and functions. Using Unix scripts I created a robust ETL tool in order to upload all file events related to CDRs, billing, CRM, roaming, and recharges, etc. Over 150 million records are loaded every day.
I created dozens of packages using the Microsoft SSIS tool in order to load data into the data warehouse from different data sources such as the website, the mobile app, QMS, ADM, OF, etc. It is also used to send data from the data warehouse to other systems such as the OF, the website, the “welcome SMS”, and the ESB.
Using the Microsoft SSRS tool, I created more than 600 reports which are used daily and are invaluable to all Touch business units. Using the same tool, I designed very complex reports such as “Customer’s Contact” and
“Customer’s Invoice.”
In order to satisfy the daily needs of my business units while using the self- service business intelligence tool, I produced dozens of tabular cubes/cubes models using the Microsoft SSAS tool.
Dozens of interactive dashboards were made using the Power BI tool (web- based and mobile-app) these are heavily relied upon and constantly used by many Touch business units.
Using Microsoft AZURE, I created several models which facilitate the use of the analytical services provided by AZURE.
In 2012 I single-handedly produced a data warehouse and reporting system which loads data and events from TABS (the CRM and billing system) and REDKNEE Unified platform (a Touch prepaid system.) This data warehouse was built using Oracle Database and contains hundreds of tables and procedures.
I generated over 300 reports using Microsoft SSRS. These were created for and are used by numerous Touch business units.
I head all Oracle development within the company. This includes the creation of forms, reports, and procedures using Oracle Tools (Forms 9i, Reports 9i, PL/SQL).
Using Oracle Forms, I created the CRM customers 360 degree form, which is the main form that includes all customer data, profiles, history, pictures, and scanned documents etc.
Using Oracle reports, I was able to generate very complex reports such as
“Customer Contact” and “Customer Invoice.”
I produced hundreds of packages, procedures and functions which facilitated and improved business.
Maintaining the Oracle E-Business Suite Application and its corresponding modules. (During the first 2 years)
From 2/2007-Present Tayouneh, Beirut, Lebanon
Organization: Arab Open University
www.aou.edu.lb
Position: Professor of IT Courses
Responsibilities:
Teaching course material based on Oracle technologies (Database, SQL, PL/SQL, Forms, Reports, Data Warehouse.)
Instructing the Information and Communication Technologies Course.
Supervising Final Projects.
From 1/2013-Present Hadath, Beirut, Lebanon
Organization: Lebanese University
www.ul.edu.lb
Department: University Institute of Technology
Position: Professor of IT Courses
Responsibilities:
Teaching course material based on database management systems.
Supervising Final Projects.
From 8/2011-9/2015 Hamra, Beirut, Lebanon
Organization: American Educational Institute
www.aeiucm.com
Position: IT Consultant
Responsibilities:
Provide IT consultancy for AEI’s University Campus Management Division in Educational Systems Development and Quality Assurance for software products being used in schools and universities.
From 1/2009-7/2013 Chiyah, Beirut, Lebanon
Organization: RYMCO Rasamny Youness Motor Company
www.rymco.com
Position: IT Consultant
Responsibilities:
Worked as an IT consultant in the domain of database applications (Oracle) Data- warehousing, and dashboard creation.
From 6/2003-3/2007 Hamra, Beirut, Lebanon
Organization: BML Istisharat SAL
www.istisharat.com
Position: Project Leader
Department: IMAD Industrial Manufacturing and Distribution System Responsibilities:
Created a modular software package ( Using Oracle Forms, Reports, PL/SQL … ) which supports the financial, administrative, production, and distribution activities of manufacturing firms involved in car and/or garage management. From 6/2004-1/2007 Hamra, Beirut, Lebanon
Organization: Brain Power (a Kuwaiti firm which also operates in Lebanon) Position: Lecturer/Trainer
Responsibilities:
I gave lectures and conducted training sessions on topics such as computer, internet, security, backup, archiving, hosting, and database management. From 6/2002-9/2002 Hamra, Beirut, Lebanon
Organization: Banque Du Liban Main Branch
www.bdl.gov.lb
Position: Consultant/Developer
Department: IT
Responsibilities: Created programs in the following domains: o Database Backup
o User Security & Access
o Statistics
o Network Management
o Data Archiving & Reporting
EDUCATION From 2004-2006 Beirut, Lebanon
Institution: Sagesse University
2006: Diplôme Des Etudes Supérieures Spécialisées ( DESS ) in Business Computer
(Informatique de Gestion)
o Thesis : Developed Car Sales and Services Management Module From 2000-2004 Beirut, Lebanon
Institution: University Saint Joseph ( U.S.J. )
2004: M.S. in Business Computer (M.I.A.G.E. – Mastère des Méthodes Informatique Appliquées à la Gestion)
o Thesis : Data replication between remote sites via Oracle Databases.
2003: B.S. in Business Computer (Informatique de Gestion)
2003: Level A in English (accredited by Georgetown University, USA) LANGUAGES Fluent speaking, reading, and writing skills in the following languages:
English
Arabic
French
Contact this candidate