Essam Gad, Senior Data Analytics Specialist

Essam Gad

Senior Data Analytics Specialist

Alyasra Group

Location
Kuwait - Al Kuwait
Education
Bachelor's degree, Computer Science
Experience
10 years, 4 Months

Share My Profile

Block User


Work Experience

Total years of experience :10 years, 4 Months

Senior Data Analytics Specialist at Alyasra Group
  • Kuwait - Al Kuwait
  • My current job since September 2014

Responsibilities:
• Developed analytics solution for Alyasra Group
• Developed ETL jobs using Python and Oracle PL/SQL Procedures
• Data Integration from Dynamics AX, Google Analytics and other on-premises databases
• Supported and maintained TM1 planning analytics application
• Reduced the manual work by 90%
• Develop complex reports (list, crosstab, drill through, master-detail, charts, multi-query
multi-prompt reports and burst reports), dashboards, and active reports
• Integration automation using Python
• Create, enhance and modify Metadata models
• Implemented security at different levels
• Create data source connections, publishing packages, scheduling reports, user creation,
deployment of packages and reports in different environments
• Create technical, functional and non-functional requirement documents, high level and detailed design documents and user guides
• Manage a successful upgrading from Cognos 10.2 to Cognos Analytics 11.0.9

Business Analytics Specialist at Armada Retail Concept
  • Kuwait - Al Kuwait
  • January 2020 to May 2020

My Role was to Lead the Business Intelligence team to drive insights and analytic dashboards to the business leaders.
• Data warehouse designing (Oracle 12c)
• Gather and translate business questions into analytics KPIs
• Integrate data from custom Oracle databases and SAP business one
• Install, configure and administrate Cognos Analytics 11.0.9
• Create analytics reports and dashboards

Business Intelligence Specialist at Informatique Egypt
  • Kuwait - Al Kuwait
  • July 2014 to August 2014

Responsibilities
• Develop reports and dashboards for Kuwait Ministry of Justice
• Data Warehouse designing
• Create, enhance and modify Metadata models
• Create and design ETL jobs

Business Intelligence Developer at IT-Blocks
  • Egypt - Cairo
  • July 2013 to December 2013

Responsibilities
• Get and analysis the business requirements.
• Create and enhance Framework Manager Model to support business requirements.
• Design and develop Cognos BI 10.1 Reports.
• Create and Design the connection with Web Services using Cognos Virtual View
Manager.
• Create and Design alerts and notifications

Education

Bachelor's degree, Computer Science
  • at Helwan University
  • June 2009

Specialties & Skills

Visual Analytics
Data Warehousing
Talend OS
QlikSense and Qlikview
BUSINESS INTELLIGENCE
IBM Cognos 10
DATA WAREHOUSING
Data Analytics
Cognos Analytics 11
IBM Framework manager
Database Designing
Reporting
Data Integration
Power BI

Social Profiles

Personal Website
Personal Website

URL removed due to policy violation. Please contact support for further information.

Languages

Arabic
Native Speaker
English
Expert

Training and Certifications

ITIL® Foundation Certificate in IT Service Management (Certificate)
Date Attended:
August 2022
ITIL® Foundation Certificate in IT Service Management (Certificate)
Date Attended:
August 2022
ITIL® Foundation Certificate in IT Service Management (Certificate)
Date Attended:
August 2022
Python for Data Science and AI (Training)
Training Institute:
IBM - by Coursera
Date Attended:
May 2020
Crash Course on Python (Training)
Training Institute:
Google - by Coursera
Date Attended:
May 2020
IBM COGNOS 10 BI METADATA MODEL DEVELOPER (COG-632) (Certificate)
Date Attended:
January 2013
IBM COGNOS 10 BI AUTHOR (COG-612) (Certificate)
Date Attended:
January 2013