Bibind GEORGE

Power BI Expert. 🗣️: French, English, Spanish More than 10 years of Power BI Experience - Propose analytical expertise to clients. - Best practice - PBI Licensing - Optimised approach - Gateway configuration - Data Governance - Training (End users and technical) - Data Optimisation

- Training internal consultants on Power BI (Fundamentals + Advanced) - Installing and configuring Power BI Gateway on a stand alone server in Azure VM for Groupe ADP (Aéroports de Paris) for their existing reports

Client: LFP (Ligue de Football Professionnel) -- Analysing online users based on the types of contents viewed on the LFP official website • Developing Power BI reports based on business needs from Azure Data Lake - Blob Storage

UMANIS taken over by CGI Client: Louis Vuitton -- Developing Power BI report for the PLM team to compare and calculate data discrepancies between two different systems regarding materials and its compositions-quantities. • Data Modelling (Fact-Dimension Tables) • DAX for KPIs Client: Microsoft France -- Integrating sales data from various sources (cube) to create interactive in-depth reports on Power BI with respect to End Customers and Partners for business use and insights based on Microsoft business sales • ETL-SSIS and Data Migration • Creating and publishing reports via PowerBI • DAX to create Measures as per the requirements Client: ENTSOG (Oil & Energy) -- POC on PowerBI to display the gas flow network across Europe on a map based on Excel data source. • Structure the fact-dimension tables to create the data model • Power Query to perform transformation on the source file. Client: Remy-Cointreau (Wine & Spirits) -- ETL with Power Query to integrate different formats of excel provided by each duty free Remy-Cointreau stores worldwide into one standardised format to have the overview of number of sales (per volume bottle) and the sales amount (US Dollars/Euros) in Power BI • ETL with Power Query (M Language) on various types of source files (Excel) to standardise the data as per the desired format in Power BI. • Applying new Power Query functions on each newly added source to integrate it with the existing PowerBI Client: StanHome (Consumer goods) -- Customized visual Maps with Power BI on ShapeMaps and ArcGIS based on the data provided by the Client containing postal codes. • Integrated .shp file into SQL server and converted the resulting Spatial Data from SQL Server back to Shapefile. • Visualisation of these maps along with the KPI's as per the requirements on Power BI dashboard

SOFT COMPANY taken over by CTG France then NSI France Client: BBGR (Optical Lens Manufacturer) --- Working with Lens Production department for BBGR to get the latest up to date count of the total number of production units in volume. MSBI : SQL Server- SSIS /SSAS (Multi-Dimensional)/ SSRS • Updating and maintaining the existing SSAS cube. • Modifying Stored Procedures and troubleshooting issues on SQL Server. • Updating SSIS packages for higher optimization. • Connecting Pivot Table to the existing SSAS cube via Excel to deliver the latest up to date data to Finance and Production teams.

Client: Trésor public du Sénégal --- Project for a Senegalese client based on Treasury called "Trésor public du Sénégal" to generate reports from raw data as per the client's needs via MSBI tools. (SSIS-SSRS) • Developing SSIS packages for migration of data from Oracle to SQL Server • Loading data from flat files (.txt/.csv) to SQL Server. • Archiving flat files in SSIS once the data is loaded onto the SQL Server • Developing report in SSRS for Amount Received and Amount Spent for each Accounting item by date. • Creating report for the same project for each mode of transaction (Cheque, Wire transfer etc.) and then for by each Accounting item by enabling Drill-Down. • Adding Zoom functionality on one report to get a detailed view of the same report on a new page.

Client: SCOR (Reinsurance Company) --- Project for SCOR with regards to data reconciliation to calculate and verify discrepancies if any on wire transactions between two different bank accounts of two separate entities. • Development of SSAS Tabular Model in Analysis services under Microsoft Business Intelligence (MS-BI) • Creation of Star Schema/Tabular Database Model in PowerPivot from a raw flat file data source (Fact and Dimension Tables) • Applying DAX (Data Analysis Expression) on Tabular Data models to alter the created table and for creating new Calculated Columns and Measures under SSAS-Tabular in PowerBI/PowerPivot. • Generating reports/KPI for data visualization as per client’s requirement via MS PowerBI. • Adding row level securities on SSAS Tabular Model database.

--- Client consultation of Lab Interfaces for EMR (Electronic Medical Records) which follows HL7 (Health Level 7) standards • Implementation of HL7 interfaces (Electronic Data Interchange (EDI) interfaces) on Apache Tomcat, MySQL and MS-SQL servers. • Analyze and customize data in clients’ database servers (MySQL, MSSQL) to verify the accuracy of Interface • Operations on MySQL (Data Dump, MySQL version upgrade, myissam – innodb) • Setting up Apache Tomcat and MySQL Servers. • SSL Extraction