Dynamic and result Business Intelligence Professional with more than 6 years of experience in the analysis, design, development of datawarehouse using , SQL, ETL and RDBMS tools. Flexible person with the ability to work …
Dynamic and result Business Intelligence Professional with more than 6 years of experience in the analysis, design, development of datawarehouse using , SQL, ETL and RDBMS tools. Flexible person with the ability to work both in a team and independently. Realizing projects from concept to execution using scrum/agile methodologies in several sectors. Proven ability to quickly adopt new technologies and best understand practices, excellent communication skills.
Extensively involved in requirements gathering, writing ETL specifications and drafting design documents.
Determine for each field of the source system what the corresponding field is in the target system.
Dimensional data modeling performed using the Kimball methodology to introduce new data sources/data lake in the data warehouse.
Developed ETL packages for cleaning, data integration, transformation and incremental load in the data warehouse using Microsoft SSIS.
Responsible for maintaining SSI's ETL, QA, production data warehouse and BI reporting environments.
Designed process to upload/download files from SQL to a secure FTP server/site.
Scheduling the tasks to run the saved SSIS packages, which are designed to update the database on a daily basis using SQL server agent.
• Extensively involved in requirements gathering, writing
ETL specifications and drafting design documents.
• determine for each field of the source system what the corresponding field
is in the target system.
• Dimensional data modeling performed using the
Kimball methodology to introduce new data sources/data lake in the
data warehouse.
• Developed ETL packages for cleaning, data integration, transformation
and incremental load in the data warehouse using Microsoft SSIS
• Responsible for maintaining SSI's ETL, QA,
production data warehouse and BI reporting environments.
• Designed process to upload/download files from SQL to a
secure FTP server/site.
• Scheduling the tasks to run the saved
SSIS packages, which are designed to update the database on a daily basis
using SQL server agent.
Creating t-SQL scripts, which generated tables and relationships, based on the final er diagram.
Implementation of the temporary tables, indexes, execution plan, resolve of the problem with sniffing parameters to query queries optimize.
Designing the data mart using a bottom-up approach with modeling of star schemes based on datavault layer.
Identification of the source, destination, staging area by ETL strategy and performed data cleaning and data profiling.
Designing the ETL mapping document per business requirement using FRD document.
Identifying and maintaining the SCD and role-playing dimension during designing the data mart.
Developing dashboard per department with associated KPIs in Tableau.
Developing a Data Warehouse from scratch in the Microsoft Stack.
Apply analytics such as product mapping, tunnel, funnel, validation and conversion.
Dimensional Modeling.
Developing executive dashboard in Powerbi to display all branches in the better understand and govern the country.
Build and maintain the self-service BI applications that will collaborate with data warehouses and other BI solutions.
Collaborate within and between development and project teams in a fast work environment, using agile BI design.
Experience working with data extraction packages and the generating reports for business users.
Ensure architectural goals are met at all development projects and participate in activities of the development lifecycle, including estimation, coding, unit testing, implementation and maintenance.
Participate in the development lifecycle activities, including estimation, coding, unit testing, implementation and maintenance.
Collaborate with key developers to create a
نظام التوظيف التشغيلي المعتمد على الذكاء الاصطناعي أولاً، الذي يوحّد ويؤتمت دورة التوظيف بالكامل للمؤسسات الحديثة حول العالم.
د.جوب منطقة حرة ذ.م.م. 2026 © جميع الحقوق محفوظة
