Senior Business Intelligence Consultant
itworx
Total years of experience :15 years, 10 Months
-Communicate with customer to gather requirements through a series of forms, interviews, and surveys
-Develop use-cases using UML standards
-Estimate effort and time of project implementation
-Design data flow diagrams, ETL Package, cubes, data mining models, dashboards, scorecards, reports,
and Websites to interface the cubes
-Ensure that unit and performance testing and tune package are done correctly to maximize performance
-Provide BI training sessions on BI best practices and specific tools in BI area
Projects:
-ELM Outsourced - Hafiz Project:
Hafiz Eligibility process is the core process to determine eligibility of each Hafiz applicant both for financial and employment benefits for a scheduled Hafiz payment cycle. It is implemented as an ETL (Extraction, Transformation & Load) process using Microsoft SQL Server Integration Services (SSIS).
-ELM Outsourced - Eskan Project:
This is a National Project established for the Ministry of Housing in order to receive Citizens applications for Housing loans and to specify eligibility and priority to have such loans. The DW/BI is built on top of the transnational application for supporting Operational, Tactical, and Strategic Performance management and Decision making.
-ELM Outsourced - Q5 Project:
Q5 process is a reward process to determine eligibility of each applicant for a financial reward. It is implemented as an ETL (Extraction, Transformation & Load) process using Microsoft SQL Server Integration Services (SSIS).
-Coordinated with business analysts/customers to develop business requirements
-Developed standard reports and functional dashboards
-Generated reports for internal/external customers for performance monitoring/decision making
-Worked with project manager in developing and executing project plans
-Managed new report generation and report enhancement based on change requests
-Mentored junior developers/analysts
-Conducted knowledge transfer sessions to juniors and customers
Projects:
Mawhiba - Bayanat Project:
A complete implementation of BI infrastructure for Mawhiba- A subsidiary Branch of Ministry of Education, Kingdom of Saudi Arabia. This project is using latest Microsoft technologies like Power View, Performance Point and Data tools from MS BI Stack 2012. My role in this project is Onsite Team Lead in Riyadh, Saudi Arabia.
-Generated BI solutions using Microsoft BI Suite
-Developed SSRS reports and dashboards and create SQL queries
Projects:
-Intelligent Reporting Dashboards for Egyptian Taxation Authority:
Dashboards and Reports showing and analyzing Tax Payments Collection data and Human resources data.
-National Education Indicators BI Solution for Egyptian Ministry of Education:
Support MOE’s National Educational Strategic Plan, by providing a solution for monitoring and analyzing the progress of National Educational Indicators such as Intake Rates, Enrollment Rates, Dropout Rate, Promotion Rate, Transition Rate ..etc
-El Borg Laboratories Project:
Providing Al Borg laboratories with a complete BI solution including data cleansing, data extraction, self-service BI, in addition to a number of management, medical, operational and financial dashboards and reports.
2004-2008 Graduated from Faculty of Computer and Information System- Cairo University. Information Technology Department (IT) & Information System Department (IS) Grade: (Very Good) 2001-2003 Graduated from General Secondary Certification with an Accumulative score of 94%.