Mohamed AbdelAziz Hassan Galal

+201*********

Cairo, Egypt

acuytx@r.postjobfree.com

https://eg.linkedin.com/in/mabdelazizbi

Summary

I am a highly motivated self-starter Business Intelligence, Data Warehouse, and Data analytics consultant. I have almost nine years of professional experience in analysis, design, develop, support and operate business intelligence, data warehouse solutions and services using Oracle and Microsoft Business Intelligence technologies.

I have a demonstrated leadership and team work skills as well as the ability to carry out tasks under minimal direction and supervision.

I have a proven history of utilizing strong analytical skills, attention to details, and hard work ethics. I always work with high level of ownership to pursue required missions while considering effectiveness and achieving mission parties’ values.

My key skills include BI/DW analytics modeling and design, OLAP cubes design and development, DBs scripting, SQL queries, Statistics and regression modeling, data visualization, Telecom business and analytics, fundamentals of general business and finance.

I am looking for working in a progressive organization where I can use my potentials and skills. I aim to add value through my job to organization’s business, customer chain, my colleagues, and the society for which the organization belongs.

Education

2004 Bachelor's degree in Computer Engineering.

Banha Faculty of Engineering, Grade: 80.88% (Very Good) ranked the 13th of faculty intake.

project: "Mitral Valve Surgery Expert System”, Artificial Intelligence.

2016 Professional Diploma Big data and Data science.

Nile University,

Big Data and Hadoop : Hadoop HDFS, MapReduce, Spark.

Machine learning: Statistics, regression and Machine learning concepts.

Advanced Big Data analytics (Spark, Machine learning with spark).

Mining Big Datasets ( advanced Machine learning, text mining ).

Practical Data Science Using Machine Learning Techniques.

2013 Professional Diploma of Statistical Quality Control and Quality Assurance.

ISSR, Cairo University, Grade: (Very Good).

Subjects : Control charts, Statistical data analysis, Project management, Sampling, Continuous improvement, Reliability, TQM, and Quality Control.

project: Balanced Scorecards (BScards)

2014 RITI Advanced Management Program – RAMP

RITI /ITIDA, Grade: (Very Good).

Finance, Marketing, Sales, Business planning, Business Strategy, leaderships, creative thinking, and Global business.

2006 Professional Training Program – Software Engineering & Quality management.

MCIT/Fujitsu - MCIT training programs.

Subjects : Soft skills building, System Analysis and Design, Modeling DFD, ERD ..3NF, SWE methods and measurements, Oracle Designer CASE tool, NCC SWE certification.

2005 Professional Training Program – Huawei Network Engineering professionals.

NTI - MCIT training programs.

Subjects : Huawei Senior Network Engineer, ( Computer Networking, Switching, Routing, protocols,configurations).

Work Experience:

1/10/2014 . 10-2015 MS BI,DWH Consultant and Team Leader

CrossWorkers, Cairo -office New Cairo, Cairo, Egypt.

Description and role responsibilities:

Lead Cairo Business Intelligence/optimization development team that provides Offshoring development services for Orifarm Group A/S client. Orifarm is leader Supplier of parallel imported and generic pharmaceuticals for Scandinavian and Europe market, HQ located Denmark at Odense city.

Reports to Orifarm ‘s IT, Business Optimization department manager. Represents the Cairo development team for Orifarm team, managers, and business users. The role includes offer business consultation and support for company’s business users through IT management system ( service now).

Part of the role is to do assessment for changes, and new development requests following company industry GxP standards .

Participate and interact with Orifarm’s Danish BI team for knowledge sharing and scrum meetings, R&D, new features and requirements planning.

Technologies and tools :

Microsoft BI technologies includes, SQL server 2012, SSIS, SSRS, SSAS, Power pivot, Power BI ( power Query, power pivot, power map ), and SharePoint integration.

1/3/2013 30/9/2014 Oracle BI Lead Consultant

Data Gear El-Nozha, Sheraton, Cairo. Egypt.

Description and role responsibilities:

Lead Data Gear Oracle BI development team offering BI solutions and severs for company clients.

Manage day-to-day tasks of the team and provide technical aid and support for team to pursue assigned missions.

Control team deliverables quality and compliance with business requirements.

Pursue system analysis and design for data sources and BI,DWH, OLAP cubes, and data marts.

Design backend process, ETL mapping, and reports for solutions that fulfill the business requirements.

Participate pre-sales activities and consultation for potential customers of the company and support sales team with in POCs.

Technical projects lead and co-ordinate teams tasks and interact with project managers for running projects.

Technologies and tools :

Oracle BI technologies stake, that includes :

Oracle DB 11g, PL/SQL, weblogic OBIEE repository, analytics and answers, dashboards, BI publisher, Essbase for online OLAP cubes.

OCDM :Oracle Communication Data Model.

Projects and Customers:

oZAIN KSA, OCDM operational support, Outsourced – lead service team.

oEricsson IN, OCDM integration project, .

oEtisalat Egypt, Exalytics and OBIEE, Presales, technical presales engineer.

1/10/2011 1/3/2013 Sr.BI Functional Specialist.

Huawei New Cairo, 5’th district, Cairo, Egypt.

Description and role responsibilities:

Continue for previous job after ITS – Telecom department acquired by Huawei.

Work within data warehouse and BI team for implementing, marketing, and consulting Huawei telecom business analytics solutions and applications.

Sources analysis, model changes design, development, and interacting with customers during delivery phases.

Technologies and tools:

Oracle BI technologies stake, that includes :

Oracle DB 11g, PL/SQL, weblogic, OBIEE repository, answers, dashboards, BI publisher.

Oracle BI stander edition ( oracle Discoverer) and application server portal.

Oracle database development and special data development, and map viewer for GIS services.

Projects and Customers:

ZAIN KSA, develop and implement custom CDRs /CRM analytical solution.

TABS Operational BI project analysis and development.

1/1/2007 1/10/2011 BI Functional Specialist.

International Turnkey systems ITS - ITS GBS Cairo Office Free zone, Naser City, Cairo, Egypt.

Description and role responsibilities:

Work within the company BI/DW team for 6 years to develop and implement, operate and support ITS custom Telecom DW and analytics solution/ service based on Oracle DB and BI technology stack. That is usually sourced from TABS system (CRM, Mediation, Billing and payments) in addition to CDRs data source like (Huawei OCS, Ericsson IN). Started as junior level worked in different DW/BI tasks including analysis, design, develop, implement and support ITS telecom custom BI/DW solutions.

Technologies and tools:

Oracle BI stander edition ( oracle Discoverer) and application server portal.

Oracle database development and special data development, and map viewer for GIS services.

Projects and Customers:

ZAIN KSA, Calls’ online reporting solution with GIS.

BI/DW solution upgrade at ZAIN SD.

DW/BI solution Customizing, and Implementation at Zantel, Tanzania

DW/BI solution Implementation, supporting and consultation at Etisalat, Nigeria.

2005 2006 Academic teaching assistant.

Benha Faculty of Engineering (was known as Benha Higher institute of technology), Benha University, Egypt.

Description and role responsibilities:

Working as TA for my professors whose was supervising me in my under graduation and post-graduation studies I was making.

Subjects:

Data Base Management Systems

Operating systems

Under-grade graduations projects.

Certificates:

2006, NCC, Software Engineering methods and management techniques (Certificate).

2013, Oracle Business Intelligence (OBIEE) Foundation Suite 11g certified Implementation specialist (Oracle OCP certification).

Courses and Self-Studies:

11-2014, Administrating Microsoft SQL Server 2012 data base(10775A)

10-2014, Implementing Data Models and Reports with Microsoft SQL server 2012 (10778A).

2014 - ITIDA-RITI Advanced Management professional Program – RAMP - ( Mini MBA track)

2014 - IBM SPSS Statistical Data Analysis course at – ISSR– Cairo University.

2015 - Coursera data science -R Programming - Johns Hopkins University.

2015 - Coursera - Cluster Analysis in Data Mining - University of Illinois at Urbana-Champaign.

2015 - Coursera data science - Exploratory Data Analysis - Johns Hopkins University.

2015 - Coursera data science - Statistical Inference - Johns Hopkins University.

2015 - Coursera data science - Reproducible Research - Johns Hopkins University.

2015 - Coursera data science - Getting and Cleaning Data - Johns Hopkins University.

2015 - Coursera data science - Practical Machine Learning- Johns Hopkins University.

2015 - Coursera data science -Regression Models - Johns Hopkins University.

Skills

BI and Data warehouse Skills

Modeling and design 3NF,and Multidimensional DWH.

OLAP cubes and Data Marts development and design.

Oracle BI tools standard & enterprise ( Discoverer, Portal,OBIEE).

Data Integration and ETL development and design (OWB, PLSQL)

Oracle communication data model (OCDM).

Microsoft BI stack : SQL Server, SSRS, SSIS, SSAS.

Microsoft Self-service BI : Power BI office 365/site, Power Pivot, Power Query.

Data Bases scripting (T-SQL, PLSQL, SQL, MDX)

Spatial data analysis, Oracle Map Viewer and Oracle Map builder.

Big Data and Data Science:

Statistical inference & data analysis, R programming, Machine learning and regression modeling.

Big Data concepts, Hadoop HDFS, Map reduce v2 and spark.

IBM SPSS, MiniTab and R for statistical data analysis.

Business :

Telecommunication, CDRs and IN, Mediation, CRM, Billing,,Payment collections, products and service management.

General Business administration : Managerial Finance, Business strategies, business planning, marketing and sales

Pharmaceutical trading and production, Parallel Import and generics, European market.

Programming Languages:

OOP: Java SE, C++, C/proC.

Statistical Data Analysis: R programming, MatLap, ( Python on progress) .

AI : Knowledge base Inference engine development- CLIPS., And Neural Networks.

Languages:

oArabic: Mother tongue language.

oEnglish: Very Good Speak, read, and writes.

Personal Attributes:

Working effectively in teams.

Coaching supervision and empowering Leadership.

Active listener and positive understanding to build win-win relationships.

Creative thinking and problem-solving skills

High level of personal enthusiasm and self-motivation.

Communication and Soft skills,

Enthusiastic to learn new technologies and develop Business Knowledge.

Ownership and focus on added value through performed jobs.

References:

Check recommendations on linked in profile.

https://eg.linkedin.com/in/mabdelazizbi

any additional references will be upon request.

Thanks for reading my resume!

Contact this candidate