Justin K.

Data exploitation, valorization, and analysis, consulting, creation of custom reporting solutions, and training. Forecasts of key achievements driven by innovation include:

• Development of various business intelligence (BI) services combined with artificial intelligence (AI),

• Appropriate data modeling to enable the most efficient reporting,

• Development of custom universes, reports, and dashboards integrating KPI management,

• Development of the most efficient ETL/ELT scripts and flows to ensure complete satisfaction in data transfers, processing, and migrations,

• Deployment and operational maintenance of development and operational environments,

• Evolution and updates of BI platforms,

AREA OF EXPERTISE

• SAP BI4 Exploitation and Training – Webi Level I & Level II.

• Design and delivery of advanced BI training for professionals and decision-makers.

• Design and creation of marketing campaign materials for a hotel chain.

• Exploration of generative AI tools related to data management.

• Exploration of Data Vault-based modeling.

• Exploration of cloud environments (Amazon, Google Platform, MS Azure) to enhance mastery.

• Exploration of SAP CLOUD, SAP BTP, SAP HANA, SAP (BW/4Hana, S/4Hana), SAP DataSphere, and implementation roadmaps.

• Exploration of the Qlik data integration environment (formerly Talend) and development of ETL/ELT BI-BigData Talend flows.

• Exploration of online platforms for creating data warehouse (DW) PoCs on Snowflake.

• Implementation of collaboration tools.

• Installation and configuration of an SAP BI4.2 platform dedicated to training and preparation of the scoping and documentation for SAP BI4.3 installation and operation.

Consolidation, reporting, and analysis of financing, sales, and vehicle leasing data through KPIs and key reports.

AREA OF EXPERTISE

 Analysis and Design: Requirements gathering, existing system analysis, documentation writing (technical and functional specifications, mapping file, dimensional matrix). Identification of key insights through SQL/PLSQL scripts and queries. Performance analysis (profitability, customer satisfaction, risks, activities, and operations).

 Data Management – Oracle/SQL Server/Files: Consolidation of multi-source data for KPI calculation and reporting, including management of purchase and lease offers and their financing. Design of dimensional models (star and snowflake schemas) to optimize analysis and reporting query performance. Definition of calculated measures and KPIs. Modeling of time series and regional data, and analysis of trends and evolutions. Data warehouse updates.

 ETL Development – Talend: Development, scheduling, and optimization of Talend Jobs and SQL scripts incorporating business rules specific to different segmentations and KPI calculation aggregations. Implementation of data quality control processes and generation of execution logs, as well as exception or error listings. Deployment and execution of Jobs on servers in a hybrid cloud environment, including both local and remote sources. Repository configuration for centralized project management, enabling collaborative work, versioning, and Job restoration.

 Reporting – SAP BI4: Creation and operational maintenance of universes, reports, and interactive dashboards with SAP BO Web Intelligence (WebI) for KPI reporting and operational monitoring.

Data analysis: Consolidation of data from various sources into a single system for state jurisdictions and law firms. Report redesign: Update of SAP BOBI reports covering multiple legal domains. Data management: Data integration for better management and analysis. Process improvement: Optimization of scripts, flows, and reports for judicial entities.

AREA OF EXPERTISE:

 Data Management and Reporting.

• Data analysis from multiple sources for the judicial data management system.

• Redesign of SAP BOBI-Webi reports in various domains:

◦ Civil

◦ Criminal

◦ Other legal sectors (Parquet, BAJ, SDER QPC, PP, CSJF, etc.).

 Organizational Tasks.

• Active participation in the steering committee for annual reports.

• In-depth collection and analysis of needs and data.

• Detailed writing of technical specifications.

 Technical Responsibilities and Tasks.

• Platform Management

◦ Installation, administration, and operational maintenance of SAP BI4.1 and SAP BI4.2 platforms.

◦ Configuration, administration, and maintenance of 360 Suite.

• Development and maintenance for data analysis and statistics needs.

◦ Creation and update of SAP BOBI universes.

◦ Development and provision of SQL/PLSQL scripts for analysis and control purposes.

◦ Development, optimization, and operational maintenance of SAP Bobi – Webi reports.

◦ Optimization and improvement of data governance via 360Suite (360Eyes, 360Plus, 360Univ, 360view, 360Cast).

 IT Infrastructure.

◦ Regular server maintenance.

◦ Planning and execution of the migration of the SAP BI4.1 platform to SAP BI4.2.

◦ Installation and configuration