Baptiste Solomalala

📌 Context

Each month-end closing, the European Finance team manually analyzed hundreds of customer orders to identify margin discrepancies between SAP actuals and contractual forecasts, then manually wrote correction entries—a time-consuming and error-prone process.

🎯 Objectives

Automate the entire closing cycle: anomaly detection, correction calculation, and production of accounting files ready for import into SAP.

🎯 Solutions

❇️ Automatic anomaly detection

Classification of each order according to business rules: revenue without costs, unfavorable margin difference, costs without billing. Each order receives a recommended action without manual analysis.

❇️ Management dashboard

Integrated Google Sheets interface guiding the user step-by-step, with real-time statuses and a "Run All" button to launch the entire process in one click.

❇️ SAP entries generation

Automatic production of accounting files in SAP import format—accounts, profit centers, amounts, and labels automatically populated, ready to load without modification.

❇️ Summary reports

Aggregation by order and profit center with automatic filtering of insignificant discrepancies. 100% Google Workspace solution, no additional installation.

📌 Context

A European team of 50 Proposal Engineers manually managed workload distribution and time tracking on commercial opportunities. The lack of a centralized tool made it difficult to anticipate overloads and analyze performance by product type or geographic area.

🎯 Objectives

Develop a management tool allowing simplified time entry, real-time workload tracking, and analysis of time distribution by product line and geographic cluster.

🎯 Solutions

❇️ Development of a comprehensive Google Apps Script application

Creation of a solution integrating Google Sheets and two distinct web interfaces (engineers and managers).

❇️ Engineer interface

• Simple or multiple entry with interactive calendar

• Intelligent opportunity search with auto-completion

• Modification of recent entries and personal history

❇️ Manager interface: advanced management

• Panoramic monthly calendar with workload overview

• Weekly analysis with progress bars per employee

• Dynamic KPIs (total hours, utilization rate, averages)

• Advanced filter system (PE, cluster, product line, stage)

❇️ Automated Salesforce import

Intelligent mapping with automatic enrichment (geographic clusters, regions) and cache system for performance optimization.

❇️ Robust architecture

Management of 16 metadata columns, immutable history with full traceability, data validation, and protection of sensitive sheets.

✅ Key Benefits

• Time saving: 80% reduction in entry

• Real-time visibility of overloads/underloads

• Detailed analysis by product and geographic area

• Full traceability with timestamping

• 100% Google Workspace solution, at no additional license cost

📌 Context

A European sales team covering about ten geographic clusters tracked its performance through raw Salesforce exports without a centralized visualization tool. The lack of a dashboard made it difficult to track Expected Booking, compare salesperson performance, and analyze geographic commercial opportunities in real-time.

🎯 Objectives

Develop an interactive dashboard allowing real-time visualization of sales performance, tracking of Expected Booking by salesperson, country, and geographic cluster, with an advanced filtering system and export capabilities to Google Sheets.

🎯 Solutions

❇️ Expected Booking calculation engine

Differentiated business logic based on sales stage: Closed Won and Active – Commit valued at 100% of Total Price, Active – High Probability at 75%. Multi-level aggregation: salesperson, country, cluster.

❇️ Advanced filtering system

Multiple selection of periods and geographic clusters, filter by product line and account type (Internal / External), "Europe" option automatically grouping the 10 clusters, visual badges for active filters, and reset button.

❇️ Interactive visualizations

World or Europe-centered world map with color intensity, bar chart by cluster, salesperson ranking with Top 3 medals and progress bars by stage, detailed maps by country and cluster.

❇️ Export and auditability

One-click export to Google Sheets for salespeople, countries, and clusters. Detailed export of individual opportunities with explicit calculation column, automatic total row, and auto-sized columns.

❇️ Architecture

Automatic country → cluster mapping for 40+ European countries, centralized generic filter function, loading filters in a single server request, non-blocking toast notifications. 100% Google Workspace solution.