Abdoul Sy

Project:

Pilotage of the Grand Paris Express project (Finance, Purchasing, CSR, Excavation, Accidentology, Planning, Electronic Document Management, Risk Management data).

Achievements:

• Cloud Azure & DevOps:

- Preparation, installation and Configuration of DevOps with GitLab.

- Configuration, orchestration and automation of deployment of Cloud Azure applications with Terraform and Kubernetes.

- Design of robust, secure and scalable architectures

- Code review and version control with GitLab.

- Design and implementation of Cloud Azure architecture:

- Setup and configuration of subscriptions, resource groups,

- Migration of EA subscriptions to CSP partner, migration of resource groups.

- Analysis and optimization of Azure resource costs (FinOps).

• Data Engineer:

- Design and implementation of business intelligence solutions.

- Data Modeling (Datawarehouse / Datamarts)

- Design, development and optimization of data pipelines (SQL, ADF, Databricks with Python/Pyspark, SSIS, PowerShell).

- Migration of SSIS flows to Azure Data Factory.

- Decommissioning of the Primavera application.

- Microsoft Graph API, Power BI REST API, SharePoint, Primavera API.

- Implementation of a Power BI report for monitoring the production environment.

• Documentation and project management:

- Technical specifications, operational documentation, and user guide,

- Naming conventions, architecture standardization, adherence to standards and best practices for project management.

- Support for upskilling team members.

- Requirements gathering workshops / business training

- Project management with Agile methodology.

Environment:

Cloud Azure, Azure Data Lake Storage (ADLS Gen2), Azure Data Factory, Databricks, KeyVault, VNET, Bastion, Self Hosted IR, Azure CLI, API, Azure functions, DevOps, SAP HANA, Terraform, Kubernetes, PowerShell, SSIS, SSAS, SSRS, Python/Pyspark

Project:

Oil equipment tracking application

Mission:

• Migration of SSIS Flows (to SSIS 2016 – Project Deployment Model).

• Optimization and simplification of SSIS Flows.

• Migration of the Tabular cube to an Azure server (Azure Analysis Services).

• Analysis and implementation of a project to merge data from two applications (work management applications).

• Optimization and Evolution of the SSAS Tabular cube: implementation of new metrics by commercial function, Optimization of execution times (DAX queries)

Data Warehouse Management

• Development and management of reports with PowerBI

• Documentation: Functional and technical specifications

Environment:

SQL Server 2016 (SSIS, SSAS), SQL, MDX, DAX, Azure Analysis Services, Azure Data Factory, MongoDB, Azure Data Lake, Power BI

Project:

Investment fund management application

Mission:

• Management of a relational model (evolution and maintenance).

• Management of a database regeneration tool.

• Implementation of views, stored procedures for the Web application.

• Migration of SSIS 2008 packages to SSIS 2014.

• Optimization of database model loading time.

• Documentation: Technical specifications

Environment:

SQL Server 2008, 2014 (T-SQL, SSIS)