أمير شريف, Senior Business Intelligence Developer

أمير شريف

Senior Business Intelligence Developer

BI Solutions

البلد
مصر - القاهرة
التعليم
بكالوريوس, Accounting Department
الخبرات
19 years, 4 أشهر

مشاركة سيرتي الذاتية

حظر المستخدم


الخبرة العملية

مجموع سنوات الخبرة :19 years, 4 أشهر

Senior Business Intelligence Developer في BI Solutions
  • مصر - القاهرة
  • أشغل هذه الوظيفة منذ يوليو 2019

• Project Name: Egyptian Ministry of Justice BI and Transactional Reports Projects (in progress):

The Scope of the project is to show reports of all transactions for The Real Estate Registry and Authentication offices, also to have a business intelligence solutions allow you analyze business and Fees you can get from all the electronic services the government provide via The Real Estate Registry and Authentication offices, All the key performance indicators which work by combining relevant measures with an appropriate measurement using OBIEE 12c Analytics portal.

Also show the performance of the all the MOJ Real Estate Registry and Authentication Offices based on creating about multiple dashboards This will empower the management, tactical users, strategic users, operational users as well as the relationship managers and various other stakeholders with the smart answers.

- Creating OLTP reports using BI Publisher 12c for all kinds of procuration transactions.

- Create reports and dashboards and designing them with enhancing interface to meet the intranet web application colors

- Migrate Reports, Dashboards and RPDs from test server to stage server and from staging server to
production server.
Thus eventually this will lead to a smart ministry.

Business Intelligence Consultant at Saudi Governmental Sector, Cairo Development Office في Software House
  • مصر - القاهرة
  • أبريل 2018 إلى يونيو 2019

The Purpose of the work in the ministry projects is to analyze and create analytical Business Intelligence Solutions to allow high management to analyze all the business and Fees that the ministry have needs to build visions that allow it know how the revenue and income coming from and the time of it and from which service in MOMRA electronic services via e-services and internal applications databases also to know how performance for employees and people and customers of these services,
The brief of my work and responsibilities are:
- Using the Qlik Management Console (QMC) to Create Users and Streams and give users access to
the streams and Apps.
- STORE data in QVDs on physical HDD
- Create tasks to LOAD data from QVD to QVF App files.
- Create Apps and Create Sections in Data Load Editor to load data and customize it to begin work
- Create data model then create Dashboards and Reports in different App sheets
- Create Web Mashups via QlikSense dev-hub
- Put Qliksense sheets and Qlik Dashboard objects in the Mashups html pages
- Create QlikSense Mashup and build Apps for analytical dashboards and reports
- Build an E-DWH with ODI 12c from GRP (E-Business Suite) to report from it (In progress)
- Support old BI solutions (OBIEE) projects for some municipalities and ministry
Some of projects we created in MOMRA portal:
01- Create QlikSense Mashup and build dashboards and reports for all digging holes (بلاغات الحفر)
02- Build and create QlikSense Mashup, build dashboards and reports for Ministry Financial
Revenue(مالية الوزارة ودخلها من الرخص)
03- Build QlikSense dashboards and reports for Balady Portal IDEAS (الأفكار على موقع بلدى)
04- Build QlikSense dashboards and reports for Investment Contracts مؤشرات العقود الإستثمارية
05- Build QlikSense dashboards and reports about customer evaluation for the Balady Portal Services
06- Build QlikSense dashboards for Ministry Contracts and Projects (عقود المشاريع للقطاع البلدى)
07- Build QlikSense dashboards and reports for Complain Calls 940 مؤشر أداء نظام بلاغات القطاع البلدى
08- Build QlikSense dashboards and reports for Exported Licenses on Balady Portal (مؤشر قياس آداء الرخص الفورية المصدرة على بوابة بلدى)
09- Build QlikSense Apps for e-services based on google analytics for visits, locations, devices
10- Build QlikSense dashboards and Mashup for Ministry Decision Drafts (مسودات القرارات للوزارة)
11- Build QlikSense dashboards and Mashup for Ministry Administrative Communications (الإتصالات
الإدارية ومعاملاتها)
12- Build QlikSense dashboards and Mashup for Ministry SADAD (إيرادات النظام المالي وسداد المركزي)
13- Build QlikSense dashboards and Mashup for Ministry Executive KPI (المؤشر التنفيذى للقطاع البلدى)

Senior Business Intelligence Consultant في Software House
  • مصر - القاهرة
  • يوليو 2017 إلى مارس 2018

Senior Business Intelligence Developer (Senior BI Consultant) OBIEE and BI Publisher

Senior Business Intelligence Analyst/Developer في Software Company
  • مصر - القاهرة
  • ديسمبر 2015 إلى يونيو 2017

The Scope and purpose of the 3 projects is to show reports of every transaction for Authentication, Registration and Forbidden from Disposal Modules, also to have a business intelligence solutions allow you analyze your business and Fees you can get from the services in MOJ electronic services the government provide via e-government gateway, All the key performance indicators which work by combining relevant measures etc. with an appropriate measurement.

Also show the performance of the all these 3 departments based on creating about 18 dashboards This will empower the management, tactical users, strategic users, operational users as well as the relationship managers and various other stakeholders with the smart answers.
- Creating reports with offices location on Qatar Geographical Map by Google Maps APIs and creating
another static one to show them with sliced zones all over Qatar with number of the real estate to
show how many real estates they have in Qatar.
- Create reports and dashboards and designing them with enhancing interface to meet the portal colors and design to be in the same theme of design also to make user feels they are same environment.
- Migrate Reports, Dashboards and Administration Tool repository (RPD) from test server to stage
server and from staging server to production server.
- Using IBM infosphere datastage (ETL tool) to migrate data from Production databases (Authentication & Registration DBs) to the test DWHs (Authentication and Registration DWHs), And there is more.
Thus eventually this will lead to a smart ministry.
© Database Design and Development (Task Owned by informatique development team)
© Design and Build Physical DWH (Task Owned by Kotb and Me)
© Design and Build ETL ((Task Owned by Yehia, Kotb and ME- IBM DataStage 11.5)
© Design and Build RPD Metadata Model by OBIEE Admin Tool, Reports and Dashboard (Task Owned by Me)

Business Intelligence Developer في Pharmaceutical distributer Company
  • مصر - القاهرة
  • يناير 2015 إلى نوفمبر 2015

Below is the Scope of my activities for this huge project:
* Business requirement study and analysis
* Building a new infrastructure for BI environment from scratch using OBIEE 11g to use the maximum memory for OBIEE with AS/400 using IBM AS/400 client.
* Study and analysis of existing Pharmaceutical AS/400 database
* Conceptualize, design and develop the Metadata Model for every report for fast start up.
* Suggesting and doing a best solution for loading data to escape the bad connection issues
between db in Data Center (GPX Center) in Downtown of Cairo and the BI project in East of cairo mirroring the AS/400 DB to ORACLE DB by ODI 12c on another server beside the same location of BI project server (This task under management and supervision of AS/400 DBA)
* Support to deploy the company approved Production Environment
* Perform Project Management Activities throughout the Lifecycle of the project
* Designing and enhancing the reports interface to be familiar with the company website using the website color schema, logo to design banner and footer created by PHOTOSHOP CC for the reports graphic.
* Verifying the data with the AS/400 database
* Support the company and obtain users sign-off
* Production support including bug fixes and technical issue resolution

I am the only one who must do all these tasks because there was no BI Environment and there is no team in it.

Business Intelligence Developer في SMC
  • مصر - القاهرة
  • نوفمبر 2013 إلى ديسمبر 2014

- IBM Cognos Business Intelligence Developer
- ORACLE Business Intelligence Enterpise Edition 11g Developer

Business Intelligence Developer في Khaled Saad Al-Dawood in KSA (KDOT)
  • المملكة العربية السعودية - جدة
  • أبريل 2012 إلى أكتوبر 2013

- Business Intelligence Analyst / Developer at Khaled Dot Net using IBM Cognos 8.4.1 & Cognos 10.1.1 And Cognos 10.2.

- Report Developer on ORACLE Business Intelligence Publisher Tool (OBIEE) 11.1.1.6.0

Senior Web & Web Application Designer, BI Developer في SMC
  • مصر - القاهرة
  • سبتمبر 2008 إلى مارس 2012

• Business Intelligence Developer Using IBM Cognos 8.4.1 & 10.1
• IBM Cognos Business Intelligence Developer (Technical Support)
• Web sites and web applications layouts Designer.

Senior Web and Web Application Designer في Omega Soft Projects in Cairo
  • مصر - القاهرة
  • أكتوبر 2007 إلى أغسطس 2008

Web and Web Application Designer, Senior Web sites and web applications layouts Designer.

Web and Web Application Designer في Omega Soft Projects
  • المملكة العربية السعودية - الطائف
  • نوفمبر 2006 إلى أكتوبر 2007

Web and Web Application Designer, Designing the TAIF university web site and university web applications Layouts, Working under authorize of Al Romaih Co.

Web Designer في Ain Arabia
  • مصر - القاهرة
  • فبراير 2006 إلى أكتوبر 2006

Web Sites Layout Designer.

Web Designer في The PEN IT
  • مصر - القاهرة
  • فبراير 2005 إلى يناير 2006

Web Sites Layout Designer.

الخلفية التعليمية

بكالوريوس, Accounting Department
  • في Zagazig University
  • يناير 2001

B.SC of Commerce, Accounting Department, Zagazig University 2001.

Specialties & Skills

Cognos ReportNet
BI Publisher
Data Modeling
Business Intelligence
CONTENT MANAGEMENT
DATA MODEL
ORACLE DATA INTEGRATOR (ODI)
PUBLISHER
BUSINESS INTELLIGENCE

حسابات مواقع التواصل الاجتماعي

الموقع الشخصي
الموقع الشخصي

لقد تم حذف الرابط بسبب انتهاكه لسياسة الموقع. يرجى التواصل مع قسم الدعم لمزيد من المعلومات.

اللغات

العربية
اللغة الأم
الانجليزية
متمرّس
الفرنسية
مبتدئ

التدريب و الشهادات

CIW Internet Skills Certification : ( Test 410 ) (الشهادة)
IBM Certified Solution Expert - Cognos BI (الشهادة)
BA BP - IBM Cognos BI Fundamentals in Riyadh (COG-612 and COG-632) (تدريب)
معهد التدريب:
IBM KSA
تاريخ الدورة:
September 2012
المدة:
45 ساعة
Oracle Business Intelligence (OBI) Foundation Suite 11g (1Z0-591) (الشهادة)
Database Developer 2008 - MS SQL Server 2008 R2 (تدريب)
معهد التدريب:
ITShare
المدة:
90 ساعة
PMP - Project Management Professional (تدريب)
معهد التدريب:
Camp Egypt
المدة:
35 ساعة