Business Intelligence and Data Warehouse Consultant
Devoteam Saudi
Total years of experience :10 years, 7 Months
Analyzing business requirements and processes
Work with management and different business units to analyze business processes and
requirements
Identify opportunities to improve processes and strategies
Develop and manage BI solutions and dashboards
Creating and maintaining documentation that includes the design, requirements and user
manuals for the organization
Analyzing business and gathering requirements remotely
Developing ETL Jobs via Microsoft SSIS
Developing fancy Dashboards in power BI
Consult any issue regarding Business Intelligence firm
Built the Data Architecture and data flows of DWH Layers
Identify Business Needs in each different business areas
Define data modelling and design methodologies for the organization
for which they work
Set standards for document naming, lifecycle and retention architecture
▪ Revamped two important Data marts for Parts and Service that reduced running time
for the packages from 17 hours to 6 hours
▪ Built tableau Dashboard that saved time and effort for business user that took 1 week to
prepare the report with just one click
▪ Built 4 big Dashboards in power BI
▪ Meet business users and gather requirements then cascade them, elaborate main
requests to one of my colleagues
▪ Prepare and help team to prepare the model design
▪ Report the status with alarms, explanations and solutions
▪ Interface between team and management
▪ Handle ad hoc inquiries
▪ Mentor people & Build and maintain team spirit
▪ Define main targets for team
▪ Analyze performance issues and develop strategy for any revamp plan
▪ First and second line of support in operational issues
▪ Find the root cause and try to fix it to keep operational environment stable
▪ Build new models that should be integrate to entire DataMart
▪ Designed for the first time ERD for the 3 biggest Data Marts in DWH that helps them for
documenting and saving Metadata also help in transforming to the new infrastructure of
DWH
▪ Manage between DWH internal teams and Demand teams
▪ Translating Business Requirements into logical and physical data models
▪ Full Documentation for production Models
▪ Study Impact analysis on database during any system migration or transformation
▪ Maintaining Metadata for Tables, jobs and reports and provide users with full impact
for any change
Graduation Project: Diagnosis System for diseases of poultry Grade: Excellent
Graduation Project: Diagnosis System for diseases of poultry Grade: Excellent