Mostafa Helal, Sr. Manager, Business Intelligence and Reporting

Mostafa Helal

Sr. Manager, Business Intelligence and Reporting

Orange Egypt

Location
Egypt - Cairo
Education
Master's degree, Business Information Technology
Experience
30 years, 0 months

Share My Profile

Block User


Work Experience

Total years of experience :30 years, 0 months

Sr. Manager, Business Intelligence and Reporting at Orange Egypt
  • Egypt - Cairo
  • My current job since December 2008

Setting the yearly expansion plan for Orange DWH with the Business Team.
 Participating in setting the DWH roadmap for introducing new technologies like Big Data required for building new complicated analytical models like SNA, Churn Prediction, and Location Base Analysis.
 Setting and managing the yearly budget of the BI function.
 Monitoring the overall performance of the BI team to ensure their high support to the business.
 Managing a BI team who is responsible of the following:
 Building and maintaining the company dashboard that monitors the company performance and supports the top management in their decisions
 Delivering the required business analytics to all business user to support them in their decision making process
Integrating the DWH to feed other systems like campaign management and CRM
 Designing and Developing the BI layer and data marts that supports the analytical requirement
 Continuously monitoring and enhancing the BI reporting process.
 Ensuring and maintaining the data quality across the whole DWH cycle, by setting the proper checks, rules and alarms.

Data Warehouse & Business Intelligence Product Manager at ITS (International Turnkey Systems)
  • Egypt
  • July 2006 to November 2008

1- Setting the road map for ITS Telecom Data Warehouse (TDW) & Business Intelligence (BI) solutions.
2- Presenting TDW & BI Solution to ITS Telecom customers.
3- Managing the TDW & BI development and implementation team.
4- Discussing, analyzing, and preparing business requirements with the customers.
5- Setting project scope & identifying the project gaps with customer.
6- Following up & monitoring all running Data Warehousing projects to ensure its successfulness until final delivery to the customer.

Data Warehouse & Business Intelligence Project Manager at Mobinil
  • Egypt - Cairo
  • July 2001 to July 2006

1- Managing DWH projects for incorporating new source systems data into DWH.
2- Presenting MobiNil DWH functionalities & Outcome to company executives, directors, senior managers and to our foreign shareholders (Orange Telecom).
3- Ensuring awareness of different company departments with MobiNil DWH by preparing different presentations and demonstrations.
4- Acting as a DWH interface to Marketing, Sales, and Customer Services Department to study and fulfill any of their new requirements.
5- Design the best and optimum architecture of any new DWH solution.
6- Documenting the DWH daily, weekly, and monthly Processes and introducing quality checks techniques to most of these processes.
7- Assessment of business user’s requirement and transforming it to development requirements and documenting the gaps between it and source system capabilities.
8- Managing different DWH vendors.
9- Excellent knowledge in MobiNil Billing System (BSCS), which is the main source for DWH.
10- Excellent experience with BusinessObjects (Reporting Tool) and Ascential DataStage (ETL Tool)

Business Systems Analyst Section Head at GlaxoWellcome Saudi Arabia (GWSA)
  • Saudi Arabia - Jeddah
  • September 1999 to May 2001

1-Implementing, and customizing the Caliach MRP System as a packaged software solution for the inventory management and purchasing at the GWSA Factory.

2-Designing & Developing the GWSA website (www.glaxowellcome.com.sa/index1.htm), which constitutes the strategic marketing & public relations channel of our company in the future.

3- Designing & Developing of an Intranet site for disseminating daily sales results.

4- Analysis, Design and Development of a Dynamic Report Generator System, which improved and speeded up the access to the HR data by non-IS end-users.

5-The latest technologies were used for developing all the previous systems, like Visual Basic 6.0, ASP, Java, JavaScript, VBScript, HTML4.0, and Access97 as a database engine.

System Analyst and Programmer at Egyptian Banks Co. For Technological Advancements
  • Egypt - Cairo
  • February 1997 to August 1999

1-Analysis, design, development, training and support of the Automatic Check Clearing System for the Central Bank of Egypt, which speeded up the check collection process in Egypt. Analysis and development was done for both member nodes and the central node.

2-Analysis, design, development, training and support of the Card Issuance System for maintaining the personal of every bank’s cardholders. The application generates cards and PIN numbers for each new client.

3-Pre-sales support for both of the above systems.

4-During my last working year in the company I took over the management of the Automatic Check Clearing System.

4-Visual Basic 5.0, and Visual C++, as well as MS-SQL Server 6.5, and Access 97 as database engines were used in developing the previous two systems.

Web Developer specialist - Part Time at MidEast Net
  • Egypt - Cairo
  • March 1997 to June 1997

Developing Web sites for a number of Egyptian organizations and companies using Microsoft FrontPage, Java, and JavaScript.

Technical & Customer Support at Al-Alamiah (Sakhr) software house
  • Egypt - Cairo
  • May 1995 to April 1996

1-Participated in the development of Al-Alamiah’s popular software programs such as the Quran, and the Hadith.

2-Customer support for software programs developed by our company.

3-Network Administration, and Desktop support for in-house PC's, servers and users.

Operation and Maintenance Engineer at ART (Arab Radio & Television)
  • Egypt - Cairo
  • August 1994 to May 1995

Maintaining Production Plans, Beta-Cam Videos M/C, and Cameras.

Education

Master's degree, Business Information Technology
  • at MiddleSex University
  • January 2006

It was a distance learning program

Diploma, Computer Science
  • at Information Technology Institute
  • January 1997

The curriculum contained a set of software engineering related courses, with a graduation project of a web based application for the Egyptian Stock Exchange.

Bachelor's degree, Computer and Communication
  • at Faculty of Engineering - Cairo University
  • August 1994

Specialties & Skills

Data Warehousing
Telecom Applications
Software Development
Information Systems Development
Business Systems Implementation
Programming
Analysis & Design
DB implementation and adminstration
End user training and support
Pre- and after Sales support

Languages

English
Expert

Training and Certifications

Conference - London (Training)
Training Institute:
Business Intelligence Summit (Gartner Group)
Date Attended:
January 2005
Conference - Washington University – Seattle (Training)
Training Institute:
Payment Institute Conference (Organized By NACHA – National Automated Clearing House Associations)
Date Attended:
June 1997
Class Based Training - Mobinil (Training)
Training Institute:
IBM WebSphere (DataStage)
Date Attended:
July 2001
Class Based Training - Mobinil (Training)
Training Institute:
Business Objects Training
Date Attended:
September 2001