fathi Albsomy, Business Intelligence Manager

fathi Albsomy

Business Intelligence Manager

Savola Foods

Location
Egypt - Cairo
Education
Master's degree, Business Administration
Experience
14 years, 9 Months

Share My Profile

Block User


Work Experience

Total years of experience :14 years, 9 Months

Business Intelligence Manager at Savola Foods
  • Egypt - Cairo
  • My current job since July 2019

Job Description and Responsibilities

• Develop and prepare strategies for Business Intelligence processes for organization.
• Perform analysis on organization processes and provide appropriate results.
• Prepare architecture for data, prepare strategies and provide business object solutions as per requirements.
• Supervise efficient working of all Business Intelligence projects and analyse requirements and perform appropriate tests on same.
• Administer projects, prepare updates and implement all phases for project to achieve all project objectives.
• Manage and customize all ETL processes as per customer requirement and analyse all processes for same.
• Analyse all complex data and identify requirements for business enhancement in project.
• Perform assessment on all reporting requirements and develop long term strategy for various reporting solutions.
• Coordinate with data generator and ensure compliance to all enterprise data model according to data standards.
• Provide support to all business resources and monitor all requirements for various value-added service.
• Work with process development and resource teams and prepare appropriate schedule.
• Monitor work of Business Intelligence team and ensure effective implementation of all Information Technology projects to achieve all client objectives.
• Manage all data for transactional sources and prepare effective reports

Acting Business Intelligence Manager at Savola Foods
  • Egypt - Cairo
  • January 2019 to June 2019

Job Description and Responsibilities

• Prepare architecture for data, prepare strategies and provide business object solutions as per requirements.

• Supervise efficient working of all Business Intelligence projects and analyze requirements and perform appropriate tests on same.

• Manage and customize all ETL processes as per customer requirement and analyze all processes for same.

• Analyze all complex data and identify requirements for business enhancement in project.

• Provide support to all business resources and monitor all requirements for various value added service.

• Monitor work of Business Intelligence team and ensure effective implementation of all Information Technology projects to achieve all client objectives.

• Manage all data for transactional sources and prepare effective reports

Business Intelligence Administrator at Savola
  • Egypt - Cairo
  • January 2017 to December 2018

Job Description
Work with database management software and figure out ways to store, analyse, utilise and present data. add new DB users, work with the network administrator to make sure that security measures are in place. Share in database design
Responsibilities
Help business owners make the most informed decisions about the current market situation, generate standard and custom reports summarising business data for review by executives and shareholders, collect business intelligence data from available industry reports, public information and field reports. Conduct tests periodically to make sure that the intelligence is in line with the company's needs. Create BI tools and systems, including designing customised spreadsheets. To make sure that BI system is up to date, identify and investigate industry trends with business strategy implications.

technical reference consultant at Savola
  • Egypt - Cairo
  • January 2016 to December 2016

planning, organizing, leading & controlling of Technical resources, risk & cost to implement several small to medium size business applications projects.

system analyst (ITIL foundation) at Savola group - AFIA-
  • Egypt - Cairo
  • January 2014 to December 2015

JOB PURPOSE:-
• Plan, manage, Document, develop, modify, test, install, implement, and support implementation of new and improved systems/applications by applying analytical processes to meet business requirements and to keep customers satisfied.
• Plan, coordinate installation, configuration, troubleshooting, customer assistance, and customer training by document, communicate, follow up in order to meet customer requirements
• Develop third party applications to cover missed points in standard ERP applications or making data integration

Job description:-
 Design user interfaces
 Preparing business cases for the application of IT solutions.
 Defining systems scope and objectives.
 Planning and scheduling the installation of new or modified hardware and operating systems and applications software.
 Analyzing and refining systems requirements.
 Translate systems requirements into applications prototypes.
 Evaluating new applications software technologies.
 Evaluate established methods and procedures and prepare recommendations for changes in methods and practices where appropriate.
 Document customer business rules, .business cases, incidents, problems, events and alerts.
 Test and debug programs according to detailed requirements.
 Manage problem solving for problems raised from multi incidents in operations.
 Manage event managements for critical and important events.
 Write, debug, and maintain code.
 Assuring applications quality and functionality.
 Writing and maintaining documentation.
 Ensuring systems availability, functionality, integrity, and efficiency;
 Provide customer/user training when needed.
 Prepare and update manuals, instructions, and operating procedures.
 Develop and maintain problem tracking and resolution databases;
 Manage the installation and integration of systems fixes, updates, and enhancements.
 Ensuring the integration of all systems components; e.g., procedures, databases, policies, software, and hardware.
 Ensure the sharp application of information security/ information assurance policies, principles, and practices.
 Supervises the day-to-day operations of IT Applications to ensure that work processes are implemented as designed and comply with established policies, processes and procedures

oracle programer at zamil steel building co. egypt
  • Egypt - Cairo
  • August 2009 to December 2013

Working on oracle E-business suite R12 DB and in addition our in-house developed
System-was developed by 6i and 10G developing tools on 11g database-,

1. Create new reports to oracle application using 10G or 6I report builder
2. Making quick queries and extract urgent data when needed
3. Some functional tasks on item definition
4. Working now on upgrading all 6i developed modules to 10G and apply it through the application server
5. Performing necessary changes on the system to adequate with the business requirements and changes
6. Developing new reports and forms and register it into the system to satisfy the various needs of the work or modifying the exist ones
7. Developing stored packages, procedures and functions using SQL and PLSQL
8. Tracing data for problem solving according to user or system errors and fix it to ensure healthy data
9. Technical supporting for system users
10. Developing on the fly quires for immediate or specific data inquiry on excel then implement it into in the system if applicable
11. Make documentations for systems updates occurred

Education

Master's degree, Business Administration
  • at Arab Academy For Science, Technology & Maritime Transport
  • August 2021

in progress

Diploma, software developing
  • at information technology institute
  • July 2009

it is a 9 months Scholarship from the ministry of communication after the college after admission you should pass an English and IQ tests then an interview with the departments managers it is divided to 3 sections first 3 months you study programming as a concept with some old languages like C and C++ and programming modeling and soft skills and then in the second 3 months you start studding modern tools in detail then in the last 3 months either you make a project with a 3 members team or you go to outside training in a software house and then a report should be delivered at the end of the training period to evaluate the student it was a powerful addition to my skills as all people in ITI teaches you how to think and how to work not giving the solutions or teaching a solid knowledge

Bachelor's degree, computer engineering and science
  • at faculty of electronic engineering
  • May 2008

faculty of electronic engineering is a unique faculty as it teaches electronic and electricity from the first year in detail after second year you are going to take more details about one of it's 3 departments 1 computer engineering and science 2 control engineering 3 communication engineering so you take a concentrated amount of knowledge about your department in enough time to test and make experiments

Specialties & Skills

Dashboards
Reporting
Business Intelligence
Developing BO universes using SAP universe designer
Developing universes using information designer
power BI
Using oracle EBS APIs and interfaces
Developing reports using XML publisher
SQL and PLSQL developing
data base developing
forms and reports developing using report builder and report builder 6I and 10G
Developing analytical reports using SAP business object web intelligence and deski
data warehouse
business objects 4.2 and 3.1
QlikSense
databases
qlikview
INCORTA

Social Profiles

Personal Website
Personal Website

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

Languages

English
Expert
Arabic
Expert

Memberships

egyptian engineer syndicate
  • member
  • August 2008

Training and Certifications

UIPATH Academy RPA Developer Foundation (Variables and Data Manipulation) (Certificate)
Date Attended:
July 2020
Incorta 4 Essentials for Business Users and Analysts (Certificate)
INCORTA developer foundation (Certificate)
Date Attended:
August 2020
Power BI (Training)
Training Institute:
UDEMY
Date Attended:
June 2020
SAP 3.1 and 4.2 business objects (universe and reports developer) (Training)
Training Institute:
SAP online
Date Attended:
May 2016
Qlik Sens (QLIK-Continuous classroom Online Business developer path) (Training)
Training Institute:
QLIK-Continuous classroom Online
Date Attended:
May 2019
ITIL foundation (Certificate)
Date Attended:
November 2015
Valid Until:
January 9999
Oracle database administration workshop 1 O11GAWS1 (Training)
Training Institute:
global knowledge
Date Attended:
December 2014
PMP preperation course (Training)
Training Institute:
PM house
Date Attended:
November 2015
Duration:
40 hours
oracle workflow ED1 (Training)
Training Institute:
Oracle university
Date Attended:
November 2015
Toefol with score 520 (Certificate)
Date Attended:
June 2009
Valid Until:
January 9999

Hobbies

  • driving
  • soccer