LUIGGI NAVILYS

Picture is a worldwide company selling winter goods. B2B business. As Senior Data Engineer, I am currently Working on implementing Microsoft Fabric data platform, with marketing data from social Media (Google Analytics, Meta, Instagram) , collecting data in a lakehouse and apply transformation in python notebooks . Orchestration has been done with Pipeline(ADF) . We used medallion architecture as pattern of development. Using CI/CD and git.Azure Devops for deployment. The project is aimed to gather informations between sales from (Sage on premise data) link with API connector and Marketing Data from web analysis. Using Power BI to measure KPI like ROI, Net and Margin Incomes, Transactions, CVR paid Media, AOV, Media Conversion, Media Income, Return on Ad Spent, Add-to-Cart Rate,Customer Lifetime ,Bounce Rate, Engaement Rate,Customer Repurchase Rate,Inventory Coverage. All of those metrics has been used for creating Dashboard with Power BI

In my role as a Data Engineer, I spearheaded the creation and delivery of Microsoft Fabric Platform Content, focusing on Lakehouse deployment, Datawarehouse features, and Power BI reports. By collaborating with cross-functional teams, I ensured the successful implementation of cutting-edge solutions to drive data-driven decision-making. Leveraging cloud-based tools and technologies, I optimized data engineering processes to enhance platform performance and deliver actionable insights.

As a freelance data engineer specializing in Microsoft technologies and cloud data solutions, my activities encompass: Data Integration: Designing and implementing data integration solutions using Microsoft SQL Server Integration Services (SSIS) for on-premises data sources, as well as cloud-based ETL for data stored in the cloud. Cloud Data Integration: Leveraging cloud services like Azure Data Factory to extract, transform, and load data from cloud and on-premises sources into cloud-based data warehouses or other target systems. Business Intelligence (BI): Developing BI solutions with Microsoft SQL Server Analysis Services (SSAS) for creating cubes and data models, and utilizing cloud-based services like Power BI for interactive reporting and dashboarding in the cloud. Cloud Data Warehousing: Building and maintaining cloud-based data warehouses using services like Azure Synapse Analytics or AWS Redshift for scalable, high-performance data storage and analysis. Dashboard Creation: Crafting informative and visually appealing cloud-based dashboards using tools like Power BI, Tableau, or custom solutions to provide actionable insights in a cloud environment. ETL Development: Designing and implementing Extract, Transform, Load (ETL) processes for cloud data, ensuring data quality and consistency across both on-premises and cloud environments. Data Governance: Implementing data governance best practices, including data quality checks, metadata management, and data lineage tracking in cloud-based data solutions. Project Management: Managing end-to-end projects that involve cloud data, from requirements gathering to cloud-based solution design, development, testing, and deployment. Client Collaboration: Collaborating closely with clients to understand their data needs in cloud environments, and delivering cloud-based solutions that align with their business objectives.

Implementing and providing data cloud architecture solution for Ontex Orizon project for diaper changes: - IOT datas eventhub - Backend postgre azure sql source database. - Azure Synapse ( Data Factory pipelines) - Power BI dashboards - Dedicated sql pool dwh / spark pool - sql - sqlondemand db

Hermès Al'in Project Devops Environment / github Web API Data modeling Insights with power bi

Insiders.coop business creation. Partner and member of the board of directors. Conducting HR recruitment interviews for new consultants and support.

Third Party Application Maintenance on Integration Services Database management SQL Server Building Datawarehouse objeects Work on OPC Project -> Reporting Services release

Project 1-> Migration Qlikview Sales Discovery Reports to PowerBI reports Technical Environment - Tabular Model - Database Architecture - Data model creation - Datamarts - Dataviz -> Power BI ( RLS Management) Project 2 ->Gender Diversity (Human Resources ) BLOB Storage , Running pipelines with Azure Data Factory, Polybase, Power BI, SQLDWH

Context of the mission Implementation of a complete overhaul of the sales management tools (Mercure Application) on a new Power BI Report Server on-premises platform. Mission Tasks Project management and supervision of a dedicated resource for Power BI report development. Solution architecture and design. Scrum Master role. Technical expertise in SQL, SSAS, and Power BI domains. Design of Power BI reports and Reporting Services. Documentation. Technical Environment SQL Server 2012, Analysis Services 2016, Power BI Report Server, Reporting Services, Power BI Desktop, Visual Studio Online

Implementing DWH objects ( Integration Services, Analysis Services, Reporting Services and PowerBI)

Bureau Veritas, a global leader in compliance, has the ambition to migrate all of its current data processing, which has been developed using the SAS Studio data integration tool. Specifically, the GSIT project, which refers to the branch of control and services related to international goods importers/exporters, needs to be migrated to the SQL Server 2014 platform. Leveraging my experience in data integration using SSIS, I am contributing to the modeling, design, and architecture of the new database, particularly for the GSIT and Zone France projects. Technical Environment: SAS Studio, SQL Server 2014, SSIS.

Saint-Joseph Hospital, located in the 14th arrondissement of Paris, is seeking new indicators related to the budgets of examinations, stays, and imaging procedures for its patients. To achieve this, we have implemented a new datamart that, in summary, is responsible for producing comparative measures of the budget from year to year and matching them with revenues generated. Mission Tasks: Data extraction phase from Oracle 11g sources using SSIS. Analysis and design of the associated business datamart. Creation of functional specifications. Project management, ensuring adherence to deadlines, and prioritizing tasks. Maintenance and updates of existing measures (TMA). Development of specifications and project timelines, along with commercial proposals. Implementation of the patient stay budget data feed. Design and implementation of comparative measures using DAX. Support for the business in technical choices and the organization and structuring of existing measures (creation of hierarchies, structured folders). Technical Environment: SQL Server 2012, Integration Services, Tabular Analysis Services, Excel.

Vinci Holding, a company in the construction sector, has expressed the need to migrate its reports originally developed with Business Object Desktop Intelligence XI to the SSRS 2012 platform with a report sharing server. Mission Tasks: Migration of Business Object Reports. Ensuring the consistency and accuracy of migrated data. Replicating financial dashboards exactly (Gross Debt Before and After Coverage, Cash Position, Accounts Receivable, Mark To Market, Analytical Review). Ensuring the graphical output quality when exporting to PDF. Designing the architecture for implementing data-driven subscription scheduling on the production server and sending reports to relevant groups and users in a SharePoint library. Project management and handling issues raised by the business using Visual Studio Online. Technical Environment: SQL Server 2012, Reporting Services 2012, ReportServer, SharePoint 2013, Business Object Desktop Intelligence XI

Data Integration through SSIS, Database Optimization Audit, and Data Warehouse Implementation

Consultant at SNCF Fret in Clichy la Garenne. I am currently working on Microsoft's BI suite technologies, including SSIS, SSAS, and SSRS: Migration to SQL SERVER 2008 R2. Process optimization and job reordering. Creating dashboards with SSRS on the SharePoint 2010 platform. SSAS cube development. Third-party application maintenance. Implementation of a cartography project using SSRS 2008 R2. End-to-end project involving data integration, data warehousing, and the deployment of a cube for freight management control

"Development of the SIGASSO application using C# and ASP.NET: This application allows for the management of assets and ensures the tracking of tenant associations at SIG. Creation of dashboards using the BI-BOARD reporting tool