SSIS
Husam Al-Dubai
DWH/BI Team Leader
Riyadh
Summary
Experienced senior technology professional with expert proficiency in developing and implementing innovative DWH-BI / reporting solutions. Background in business analysis, and documentation. Strong background in driving projects, from initial requirement gathering through implementation. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy.
Overview
19
19
years of professional experience
1
1
Certification
Work History
DWH/BI Team Leader
NWC (National Water Company)
01.2020 - Current
- Guide BI team development efforts towards successful delivery.
- Monitor team performance and provided constructive feedback to increase productivity and maintain quality standards.
- Work with team to identify areas of improvement and devised solutions based on findings.
- Provide functional and technical leadership to teammates.
- Assist Project Manager in developing project plan including timelines, forecast and assign tasks.
- Work as NWC SME on all projects that related to IMO department.
- Stay up to date with latest trends and best practices, and be willing to experiment with new approaches and tools.
- Coordinate with Business Managers to translate business requirements into coherent Business Intelligence (BI) reports.
- Ensure development and implantation of DWH meet business requirement.
- Building, supporting, maintaining and administering cubes and Models by using SQL Server Analysis service (SSAS).
- Developing reports and Dashboard by using SSRS and Power BI.
DWH/Senior BI Consultant
NWC(National Water Company)
01.2014 - 01.2020
- Translate business needs into technical specification.
- Coordinate with Business Managers to translate business requirements into coherent Business Intelligence (BI) reports.
- Design and build effective DWH.
- Loading, extracting and validation of data by using Oracle Data Integrator (ODI 11g).
- Helping to converting ETL tool from ODI to SQL Server Integration Services (SSIS).
- Building, supporting, maintaining and administering cubes and Models by using SQL Server Analysis service (SSAS).
- Developing reports by using SQL Server Reporting service (SSRS).
- Developing Dashboard by using Power BI.
- Providing user training and supporting in BI reporting tools (Power View and Excel) and reports as needed.
- Validate data warehouse system for data integrity, quality and accuracy.
DWH/BI Consultant
SAGIA DQ & Cleansing project
01.2013 - 01.2014
- Managed full lifecycle of BI phase from requirement gathering to final implementation and post-launch support
- Build Universe connect to DW database (SQL Server) by using Universe Design Tool 4.0.
- Build Universe connect to SAP ERP by using Information Design Tool 4.0.
- Create Required Reports by using Web Intelligence 4.0.
- Training End Users how to use developed reports.
DWH/BI Consultant
Saudi Customs DWH/BI Project
01.2012 - 01.2013
- Resolved issues in data warehouse design.
- Designed and Developed required end user reports and dashboard for main systems in client side by using (OBIEE 11.1.1.6) Oracle business enterprise edition.
DWH/BI Consultant
MOT (Ministry Of Transportation) DWH/BI Project
01.2011 - 01.2012
- Gathered system requirement and gap analysis.
- Designed Dimensional model.
- Implemented cubes in SQL Server Analysis service (SSAS).
- Developed all KPIs that in scope.
- Developed reports for top management in SSRS.
- Developed Dashboard for top management in PerformancePoint.
- Contributed in creating deliverables documents.
- Leading users through various rounds of trainings and testing sessions before deployment.
Business Analyst
MOT (Ministry Of Transportation) E-tickets Project
01.2010 - 01.2011
- Analyzed and designed E-Tickets requirements.
- Worked on Oracle database 11g by creating and maintaining tables, functions and stored procedures.
- Involved in creating deliverables documents (Process Definition, Business process Diagram, ERD, Screen Hierarchy and screens layout, System Architecture, Data Model, Test Cases, Program Specs, User Manual, and Technical Manual)
- Quality control.
BI Consultant
Saudi Hollandi Bank ,National Data Pooling Project
01.2010 - 03.2010
- Creating Business Objects Universes.
- Generating reports for Data that send to SIMAH in Business Objects.
DWH/BI Specialist
PPA (Public Pension Agency) DWH / BI Project
01.2009 - 01.2010
- Gathered system requirement.
- Designed dimensional model.
- Implemented cubes in SQL Server Analysis service (SSAS).
- Developed reports for top management in SQL Server Reporting service (SSRS).
- Developed Dashboard for different departments by using Dashboard designer in SharePoint 2010.
- Involved in creating deliverables documents.
- Lead users through various rounds of trainings and testing sessions before deployment.
Business Analyst
MOT (Ministry Of Transportation) E-Services Project
01.2008 - 01.2009
- Analyzed and designed E-Services for Land Transportation.
- Worked on Oracle database 11g by creating and maintaining tables, functions and stored procedures.
- Involved in creating deliverables documents (Process Definition, Business process Diagram, ERD, Screen Hierarchy and screens layout, System Architecture, Data Model, Test Cases, Program Specs, User Manual, and Technical Manual).
- Quality control.
BI Specialist
MDW (Mobily Data Warehouse)
01.2005 - 01.2006
- Created Business Objects Universes.
- Developed DSS reports in Business Objects.
- Monitor and troubleshooting in all DW operational tasks like executing, running manual jobs, scheduled ETL jobs
Education
Bachelor of Science - Computer Science
Mu'tah University
Karak, Jordan 05.2001 -
Skills
Requirements Gathering
SQL Expertise
Data Visualization
BI Tools Proficiency
ETL development
Data Warehousing
Data Modeling
Software
SSAS
SSRS
Power BI
DAX
SAP Business Object
OBIEE
Soft Skills
Leadership
Communications
Teamwork and Collaboration
Adaptability
Time Management
Problem Solving
Certification
MCITP: Microsoft Business Intelligence Developer 2008
Timeline
DWH/BI Team Leader
NWC (National Water Company)
01.2020 - Current
DWH/Senior BI Consultant
NWC(National Water Company)
01.2014 - 01.2020
DWH/BI Consultant
SAGIA DQ & Cleansing project
01.2013 - 01.2014
DWH/BI Consultant
Saudi Customs DWH/BI Project
01.2012 - 01.2013
DWH/BI Consultant
MOT (Ministry Of Transportation) DWH/BI Project
01.2011 - 01.2012
BI Consultant
Saudi Hollandi Bank ,National Data Pooling Project
01.2010 - 03.2010
Business Analyst
MOT (Ministry Of Transportation) E-tickets Project
01.2010 - 01.2011
DWH/BI Specialist
PPA (Public Pension Agency) DWH / BI Project
01.2009 - 01.2010
Business Analyst
MOT (Ministry Of Transportation) E-Services Project
01.2008 - 01.2009
BI Specialist
MDW (Mobily Data Warehouse)
01.2005 - 01.2006
Bachelor of Science - Computer Science
Mu'tah University
05.2001 -
Similar Profiles
MASHARI EID AL-OsaimiMASHARI EID AL-Osaimi
Project Manager at NWC, National Water CompanyProject Manager at NWC, National Water Company
EMAD AlaqeelEMAD Alaqeel
Sir Data and statistics at National Water Efficiency and ConservationCanterSir Data and statistics at National Water Efficiency and ConservationCanter
Abeer Omar AlmadhiAbeer Omar Almadhi
IT Project Manager at National Water Company (NWC)IT Project Manager at National Water Company (NWC)
Reham ElhadidyReham Elhadidy
Branches Manager & Business Development Manager at Aqdamy Sports CentersBranches Manager & Business Development Manager at Aqdamy Sports Centers
Wassal AhmedWassal Ahmed
Regulatory Affairs Pharmacist at AxantiaRegulatory Affairs Pharmacist at Axantia