Ulrich 6

Optimize human resource management by improving candidate allocation to client projects while ensuring accurate tracking of project profitability. 🎯 Key Contributions - Conducted in-depth analysis of the financial manager’s requirements to identify business challenges. - Collected and processed data from multiple sources (Excel, CSV, SharePoint, PostgreSQL, SQL Server) using Power Query and SQL scripts to ensure optimal data quality. - Developed a Power Apps application to standardize and secure data entry processes. - Designed KPIs using DAX and built Power BI dashboards to monitor project profitability and resource allocation in real-time. - Automated reporting workflows via Power BI Service, integrating Row-Level Security (RLS) to protect sensitive data. - Created comprehensive technical and functional documentation. - Trained and sensitized users on the importance of data quality and how to effectively use the tools. 💡 Results - Enhanced user experience with Power Apps, reducing errors and accelerating the resource allocation process. - Achieved a 50% reduction in report creation time through automation and Power BI integration. - Improved decision-making capabilities with interactive dashboards, providing instant visibility into project profitability and resource management.

Enhance the management of operational data to optimize fiber optic network operations and strengthen project management. Implementation: - Collecting, framing, and analyzing reported needs. - Audited systems and mapped available data, uncovering gaps and opportunities for improvement. - Consolidated and processed data from multiple sources (PostgreSQL, SQL Server, CSV, Excel, internal tools such as GMAO, Mantis, and Geoportail) using SQL, Python, and Power Query to ensure data quality and consistency. - Designed interactive Power BI dashboards - Authored functional and technical documentation to ensure project continuity. - Trained business teams, empowering them to independently use analytical tools and dashboards. Results: - Reduced critical incident resolution time by 40%. - Harmonized billing processes, minimizing errors and improving processing times. - Enhanced project tracking with improved visibility and facilitated decision-making.

Implementation of reports for operational teams to optimize stock management within the FTTH deployment project. Achievements - Conducted an in-depth analysis of business needs from operational teams. - Extracted and transformed stock data from SAP and deployment indicators from Excel using Power Query and SQL. - Calculated key KPIs using DAX, including stock availability rates, restocking lead times, and stock vs. needs comparison. - Designed interactive Power BI reports with automated updates through Power BI Service, enabling real-time tracking and sharing with operational teams. Results: - Reduced stock shortages and optimized costs. - Improved planning through better anticipation of material requirements.

The main missions focused on developing Power BI reports for business teams. Achievements: - Gathering business requirements from stakeholders to define key indicators and structure data. - Extracting, transforming, and optimizing data using Power Query and SQL. - Developing Power BI dashboards with advanced DAX for Budget tracking, Project progress ,Resource optimization. - Optimizing the performance of existing reports (DAX Studio, VertiPaq Analyzer). - Deploying reports on Power BI Service, implementing RLS (Row-Level Security) to restrict access to sensitive data. - Writing functional and technical documentation. - Training users on Power BI dashboard usage and raising awareness about data quality to enhance insight utilization. Results: - Automated tracking of over 74,000 FTTH connections, reducing financial and operational gaps. - Improved decision-making with better visualization of costs and budget variances.