Overhaul of PDF/DOCX Exports with FreeMarker
I led the overhaul of PDF/DOCX exports with FreeMarker to unify templates and make client deliverables more reliable. Concretely, I built a template library (headers/footers, reusable blocks, standardized styles), structured the data mapping (schemas, business keys, date/amount formats), and implemented conditional rules (line-item display, VAT, discounts, legal mentions, multilingual).
I industrialized the DOCX → PDF pipeline (pagination, images/logos, auto-resizing tables), added consistency checks and fallback messages for missing data, and set up template versioning and user documentation.
Result: consistent exports, 100% aligned with business requirements, with fewer data-entry errors and shorter production time (template updates in minutes instead of hours), plus simplified support for future changes.
Documentation & Improvement of PRAXEDO → SQL Web Services
I took charge of documenting and improving the PRAXEDO → SQL web services to make intervention flows reliable and traceable. On the design side, I mapped the SOAP endpoints (WSDL/XSD), standardized the business mapping (technicians, work orders, items, VAT, statuses), defined idempotency rules (natural keys, timestamps), and clarified error codes/response messages. On the robustness side, I added input validation (schemas, formats, bounds), implemented detailed application logging (correlated by intervention ID), retries with backoff, duplicate handling, pagination/batching, and throughput safeguards.
For operations and quality, I produced structured documentation (flow diagrams, contracts, request/response examples), a test collection (Postman), and Squash scenarios covering nominal and degraded cases. Results: lower failure rate, reduced MTTR thanks to traceability, faster onboarding for teams, and higher maintainability of the PRAXEDO → SQL interfaces.
Interfaces & KPIs through to SIH Imports into Sage X3
I designed and industrialized the interfaces + KPI pipeline (SQL/Excel/VBA) all the way to SIH imports into Sage X3. On the data side, I modeled exchange tables (items, work orders, time, parts, VAT), wrote SQL procedures for aggregation/validation (formats, bounds, idempotency), and produced SIH import files compliant with X3 requirements (schemas, account mapping, rounding rules). I added fine-grained traceability (logs, correlation IDs) and volume safeguards to secure processing.
On the monitoring side, I delivered an Excel dashboard connected to SQL (Power Query) with key KPIs: imported volumes, error rates, processing times, valued amounts, and reconciliation variances. VBA macros automate refreshes, generate reports (PDF/CSV), and send alerts on anomalies. Result: an end-to-end controlled flow, easier team onboarding, and actionable indicators to track operational and accounting impact through to Sage X3.
Branch Pilot: Field Testing & Quality
During the pilot rollout, I conducted on-site tests at the Forbach and Heillecourt branches to validate the end-to-end chain on real volumes and scenarios. Quality was secured through a Squash Test campaign: test plan, nominal/degraded scenarios, acceptance criteria, defect logging, and fix loops up to the go/no-go.
On the business-rules side, we decided: VAT managed exclusively in Sage X3 (single source of truth), items valued per unit (clarified UoM), and harmonized rounding rules (precision, rounding direction, consistency between exports and SIH import). Result: a controlled deployment, reduced accounting discrepancies, and a safe path to broader rollout.
Graphical interface to trigger X3 imports
I designed and delivered a graphical interface that triggers SIH imports into Sage X3 with a single click, featuring pre-run checks (formats, duplicates, volume), detailed logging (logs, correlation IDs), and real-time execution feedback (progress bar, statuses, anomaly reports). The tool includes simple parameter management (files, scopes, dates), a secure mode (roles/profiles), and automatic export of run reports.
Results: smoother operations, fewer manual errors, reduced MTTR thanks to traceability, and fast adoption supported by a user guide and handover to the teams.