Narjes G.

Involved in various BI projects.

- BINEO Project: Design, development, and optimization of SSIS flows, orchestrating data ETL into data warehouses and data marts. Full responsibility for the deployment and management of SQL jobs to ensure efficient data loading processes.

- Finance & Marketing Project: Led the design and delivery of an aggregated semantic model in Microsoft Power BI. This initiative enabled business users to easily access data and create their own visualizations and analyze in MS Excel.

- Stock & Supply Chain Project: Design and creation of paginated reports with Power Builder (SSRS) to provide detailed analysis.

- Perfetto Project: Managed the SSIS ETL from BINEO to a dedicated Data Mart for employee and store statistics, ensuring a comprehensive and relevant view of performance.

- Budgeting Project: Successfully led the migration of the Budgeting solution from IBM Cognos to Microsoft SSIS, demonstrating expertise in smooth transitions between different platforms.

Technical environment: Microsoft SQL Server 2017, SSIS, SQL, Microsoft Power BI, Microsoft Power BI Report Builder/SSRS, DAX/M and Azure DevOps.

Project to implement an ETL for data from various sources, including AS400, SAGE, and SAP, into the company's data warehouses. The goal was to create a solid foundation of consolidated data to enable the generation of effective and relevant business reports via the QlikView tool.

- Technical and functional specifications

- Design of SSIS flows for populating the data warehouse and associated data marts

- Upgrade of SSIS packages from SQL Server 2014 to SQL Server 2019

- Development, enhancements, and optimizations of SSIS solutions

Technical environment: Microsoft SQL Server 2019, SSIS, SQL.

As part of the redesign of the support website, our project involved developing and deploying SSRS reports for data presentation.

- Report Server configuration.

- Design and creation of reports using RDL files and Datasets dedicated to data processing.

- Deployment of reports on the Report Server to make them accessible to users.

Technical environment: Microsoft SQL Server 2017, SSRS, SQL