Senior Business Intelligence Technical Consultant
ITWORX
Total years of experience :13 years, 11 Months
Extensive experience in DWH design, gathering customers’ requirements for BI projects, analyzing Meta Data of systems, and dashboards/data warehousing for different industries. Areas of expertise include data warehouses/OLAP cubes design, development, management, software, and support. The candidate has the overall responsibility for assessing requirements and defining the strategy, technical architecture, implementation plan, and delivery of data warehouse projects for major organizations. The candidate have prior experience leading successful data warehousing implementations as well as a broad background and experience with IT application development. I’m responsible for establishing the long-term strategy and technical architecture as well as the short-term scope for a multi-phased data warehouse effort. I have strong professional consulting skills and the ability to communicate well at all levels of the organization. The candidate has Excellent analytical and problem solving skills, excellent business Intelligence development and programming knowledge. The candidate is IBM Data Stage (Parallel extender) certified and Oracle Certified Professional, and holds a B.Sc. in Computer Science from Ain Shams University, 1999
o Business Intelligence and Data Warehouse solution architecture
o Gather requirements for Business Intelligence projects
o Analyze and understand Meta Data of current systems to refine logical data model and analyze data quality
o Design and develop Data Warehouse ETL Processes, Multi-Dimensional OLAP Cubes, and Performance dashboards
o Design and develop the programs in business intelligence tools that support client requirements
o Lead, coach, motivate and support team members in technical issues, challenges and problems
o Completed a life cycle of a Data Warehousing n Business Intelligence project
o Assist Project Managers in developing project plan including budgets, timelines and forecast.
o Communicate directly with clients about project progress and issues.
o Provide excellent service to clients by developing long-term customer relationships
o Develop and maintain proper levels of documentation and contribute to documentation
o Compare operational progress against planned project objectives and suggest corrective actionsforvariances.
o Review the project information to identify the risks and opportunities and present it to the key leaders.
o Analyze the business performance and develop reports on performance metrics.
o Develop best practices to achieve project objectives and deliverable.
o Stay updated with ongoing business developments and latest market trends.
o Create a repository of the BI research results and findings
Customers :
o Egyptian Ministry of petroleum
o Syngenta
o Develop ETL architecture
o Data Management and Data quality architect
o Data Modeler
o Develop Business objects universes, WebI and Dashboard reports
o Develop Oracle objects
o Implement at customer side
Customers:
o CIB
o Mobinil
o HR S/W System, Business analysis (Egypt and Gulf)
o Implement at customer side
o Develop reports using crystal reports
o Develop Oracle and SQL server Database objects
o Support
o Project management
Projects
1. Vitric (HERO) - Cairo + Implement HR module
- Overview: Implement Position management, personnel management, Time Management, Manage salaries and integration with fourth shift
2. Qatar International Islamic Bank Doha + Implement HR module
3. Thuraya Telecommunication (Dubai), Implement HR module
4. Lord - Egypt (Alex) Implement HR module
Responsibilities
o System Development (HR Application)
o System Implementation
o Creating reports using Crystal reports
o Support
Projects
1. Intercom Contract Management Internal System
2. Pepsi Cola: Human Resources, Personnel, Benefits, and Organization Structure modules
3. Novartis: Human Resources, Personnel, Incentive, Benefits, Organization Structure modules, and Time Attendance
4. Orascom: Human Resources, Personnel, and Organization Structure modules
5. British Petroleum (Bp): Human Resources, Personnel, and Organization Structure modules
6. Mobinil: Human Resources, Personnel, and Organization Structure modules
7. Schlumberger Customer Documentation Management System
B.Sc. In Computer science, Ain Shams University, Science College (1999)