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.
<p>Extensively involved in requirements gathering, writing ETL specifications and drafting design documents.<br>
Determine for each field of the source system what the corresponding field is in the target system.<br>
Dimensional data modeling performed using the Kimball methodology to introduce new data sources/data lake in the data warehouse.<br>
Developed ETL packages for cleaning, data integration, transformation and incremental load in the data warehouse using Microsoft SSIS.<br>
Responsible for maintaining SSI's ETL, QA, production data warehouse and BI reporting environments.<br>
Designed process to upload/download files from SQL to a secure FTP server/site.<br>
Scheduling the tasks to run the saved SSIS packages, which are designed to update the database on a daily basis using SQL server agent.</p>
• 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.
<p>Creating t-SQL scripts, which generated tables and relationships, based on the final er diagram.<br>
Implementation of the temporary tables, indexes, execution plan, resolve of the problem with sniffing parameters to query queries optimize.<br>
Designing the data mart using a bottom-up approach with modeling of star schemes based on datavault layer.<br>
Identification of the source, destination, staging area by ETL strategy and performed data cleaning and data profiling.<br>
Designing the ETL mapping document per business requirement using FRD document.<br>
Identifying and maintaining the SCD and role-playing dimension during designing the data mart.<br>
Developing dashboard per department with associated KPIs in Tableau.</p>
<p>Developing a Data Warehouse from scratch in the Microsoft Stack.<br>
Apply analytics such as product mapping, tunnel, funnel, validation and conversion.<br>
Dimensional Modeling.<br>
Developing executive dashboard in Powerbi to display all branches in the better understand and govern the country.</p>
<p>Build and maintain the self-service BI applications that will collaborate with data warehouses and other BI solutions.<br>
Collaborate within and between development and project teams in a fast work environment, using agile BI design.<br>
Experience working with data extraction packages and the generating reports for business users.<br>
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.<br>
Participate in the development lifecycle activities, including estimation, coding, unit testing, implementation and maintenance.<br>
Collaborate with key developers to create a</p>
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
