Cherif C.

Power BI Report Migration: Migrating Power BI reports as part of a new ERP implementation. Design and Development: Creating and optimizing interactive dashboards and reports to meet business needs. Data Integration: Extracting, cleaning, and transforming data. Populating the Lakehouse: Designing and implementing processes to populate a Lakehouse, ensuring data centralization and structuring for advanced analytics. Security: Implementing Row-Level Security (RLS) to ensure secure data access.

Project: Financial Recovery and Sales Performance Optimization: Existing Situation Analysis: Analyzing financial data to assess the current situation. Cost Analysis: Identifying cost reduction opportunities through expense analysis. Acquisition Funnel Optimization: Collecting and analyzing CRM data (HubSpot) to optimize the customer acquisition process, increasing conversion rates. Prospecting Automation: Developing web scraping processes using Octoparse, ParseHub, Dropcontact, and implementing automation tools with Airtable, Waalaxy, and Lemlist. Data Extraction: Extracting data from ERP, HubSpot, and Sage using Talend. Data Integration: Implementing integration flows and jobs for data transformation with Talend. Dashboard Development and Workspace Creation: Designing Power BI dashboards and reports. Administering Workspaces for each department (accounting, operations, management). RLS Management: Implementing and managing security rules (RLS). Database Management: Using SQL Server for database management and analysis. Environment: SQL Server Management, Power BI, HubSpot CRM, Talend, Octoparse, ParseHub, Dropcontact, Airtable, Waalaxy, Lemlist, Sage.

• Analysis of specifications

• Supporting the client in evolving their needs

• Report implementation

• Suggestions for new indicators Technical Environment: Reporting Tool: Power BI, Database: SQL Server