Samira MERZAK

– Analyse and document functional requirements to align BI solutions with business needs. – Develop and optimize Power BI reports and dashboards using DAX calculations, measures, and KPIs. – Build and maintain data models and Data Warehouse structures to support reporting. – Map source data to target systems and ensure ETL processes meet technical requirements. – Collaborate with developers and stakeholders to deliver clear BI insights. – Improve existing reports, identify gaps, and recommend solutions in ETL and reporting architecture. – Support migration to new BI architectures and ensure data integrity and performance.

– Designing functional analysis – Developing test plans and scenarios to ensure complete, accurate and approved solutions – Debugging technical issues and putting together a list of practical solutions for BI problems – Creation of reporting module for the business. – Ensuring the data migration from data base to another one – Data Modelling of the Datawarehouse to meets the business needs – Coordinate with business leaders to prioritize and schedule development projects

– Setting up workshops, summarizing results and executing debriefing – Coordinate with business leaders to prioritize and schedule development projects – Putting together a list of practical solutions for BI problems. – Preparing the BI functional analysis – Developing test plans and scenarios to ensure complete, accurate and approved solutions – Defining the architecture – Designing and Creating the Datawarehouse.

– Setting up workshops, summarizing results and executing debriefing – Evaluate and challenge business value of requirements – Coordinate with business leaders to prioritize and schedule development projects – Putting together a list of practical solutions for BI problems. – Preparing the BI functional analysis – Supporting development team with business insight – Developing test plans and scenarios to ensure complete, accurate and approved solutions – Creation of Mapping sheet and flow – Defining the architecture – Designing and Creating the Datawarehouse.

– Management of day-to-day business relationship with the client – Preparing the BI Functional analysis – Data Vault Logical Data Modelling – Data Quality Analysis – Management of Master Data and Reference Data – BI Functional and Technical Testing – Data Analysis, data Visualization, Dashboard and BI Report Creation

– Data Quality optimization of the information system – Functional and technical analysis – Dimensional modelling of the Production and Purchase Datamarts – Design and Development of Data Integration Flows (ETL) – Operational reporting for Operators

– Project coordination – Requirements Analysis – Writing the E2E Project Specifications – Data Quality Analysis – Creation of a Test Plan and Building Test Cases – Investigating and resolving defects and incidents – Support and follow-up of the ongoing Developments

– Requirements Analysis and Functional analysis – Identifying Source Tables – Design of ETL logic for Data Marts (ETL) – Star Schema Design – Creation of the Dimensional Hierarchies and configuration repository. – Checking the consistency of the Global Business Model. – Creation and design reports, graphs and dashboards. – Migration and moving repository from DEV to PROD.

– Installing Oracle BI – Analysis of customer behaviour – Report development of the customer activities of MAROC TELECOM (calls, SMS ...) – Definition and analysis of business needs. – Writing of functional specifications – Design and creation of new data marts. – Dashboard design and creation – Creating hierarchies and levels in the Oracle BI repository – Creating groups for different users for rights management optimization in Dashboards and Reports. – Automatic daily, weekly and monthly report generation depending of the client needs. – ETL development and maintenance – Update and develop procedures in PL/SQL – Analysis and design of test scenarios