Anouar Bouzazi

Technical environment: Power BI, MSBI, SQL Server 2018, DENODO 8

Functional environment: Insurance, Enterprise, HR

Project: Design and development of Autonomy virtual Datamart and development of Power BI reports

- Lead a team of developers and data analysts in the design and implementation of Power BI solutions for business needs.

- Analyze business needs and collaborate with stakeholders to define clear requirements.

- Develop interactive dashboards and custom reports in Power BI to present data meaningfully.

- Optimize the performance of Power BI reports and queries to ensure a smooth user experience.

- Train and mentor team members to enhance their skills in Power BI and data analysis.

- Ensure and validate the use of best practices within the team.

- Participate in the design of the dimensional architecture of the Data Warehouse.

- Implementation and design of business views under Denodo (Base view, Derived view, and ELDM view).

- Participate in business workshops to define needs.

- Development of technical specifications.

- Design and creation of Power BI dashboards.

- Management of users and access rights to Power BI Service.

- Implementation of dynamic data access filtering (RLS).

- Scheduling and troubleshooting of Power BI applications.

- Training and support for users in using the Denodo tool.

- Analysis and development of the Power BI semantic layer.

Project: Design and development of Contract Data Warehouse

• Implementation and design of a Data Warehouse (Kimball concept)

• Development of the data loading process in SSIS

• Participate in business workshops to define needs

• Perform regular demos of developments to the business

• Weekly communication and presentation of project progress to Top Management.

• Development of technical specifications.

• Participate in the analysis of functional needs.

Project: Integration of HRIS data between SuccessFactors SAP and local HR tools (7 countries and 4 HR tools)

- Management of a team of 3 developers for the HRIS Project

- Management and distribution of tasks within the project team

- Participate in business workshops to define needs.

- Analyze User Stories written by Business Analysts.

- Technical assistance on complex tasks under Denodo (implement OAuth2 security for SF Odata).

- Dissemination of best practices within the development team.

- Guide the choice of technologies and target architecture.

- Implementation and design of business views under Denodo (Base view, Derived view, and ELDM view).

Tech Lead in a team of 7 developers, my main tasks consist of:

• Guiding the choice of technologies and target architecture

• Ensuring business continuity in terms of productivity, performance, and quality

• Monitoring infrastructures in close collaboration with DBA and infrastructure teams...

• Ensuring good knowledge sharing within the team

• Supporting the dev team in upskilling on the BI solution.

• Defining development best practices

Proposing technical optimizations

• Participating in business workshops to define needs

• Analyzing User Stories written by Business Analysts

• Breaking down User Stories into technical tasks and making relevant groupings to optimize development time

• Assigning tasks and ensuring operational follow-up

• Committing to a development capacity, in terms of user stories, sprint by sprint (each sprint lasts 3 weeks)

• Guaranteeing compliance with development standards and the quality of deliverables

• Performing regular demos of developments to the business

Environment: Microsoft SQL Server 2014, Microsoft BI Suite (SSIS, SSAS, SSRS Suite), MS Visual Studio 2015

Implementation, maintenance, and design of a Data Warehouse

• Implementation, maintenance, and design of SSIS packages and data flows, and integration of data from multiple sources (external databases, flat files, Active Directory…)

• Implementation, maintenance, and design of SSAS cubes

• T-SQL programming

• Performance and tuning

• Development of functional and technical specifications

• Writing documents to describe dimensions, measures, and calculated measures, and training users on their OLAP cube.