Ashish Sauba

Context & Objective

Key Achievements

• Centralized Power BI semantic model (sales, stocks, customers, foot traffic), multi-source: CEGID ERP (SQL Server), XLSoft (API), SharePoint, FTP – with composite model (import + DirectQuery for near real-time)
• Full automation via Power BI Service (dataflows), hourly refresh, On-Premise Gateway
• Power Query processing: harmonization, business cleaning, specific rules (migrations, exclusions, sales)
• Interactive and paginated reports (PDF export) in a Power BI application for 2 audiences (~10 managers: purchasing, product, stocks, store operations)
• Business DAX measures: Net Sales/Gross Sales, margin, average basket size, foot traffic rate, Year-over-Year changes
• Ancillary Python accounting automation (~20 files/day prepared for Sage integration)
• Comprehensive technical documentation and user support

Impact

• ~€200,000 of miscounted merchandise detected through stock transfer analysis (deposits/stores)
• Near real-time indicators for management (sales, margins, stocks, foot traffic)
• Adjustment of markdown strategy (30% → 40% → 50%) on hundreds of poorly selling items
• Time savings of several tens of minutes per day per analyst

Lead Data Analyst — Client and Internal Projects

• Atout France (Outdoor Hospitality Barometer): Python/pandas pipeline processing ~10 million overnight stays/week, resilient ingestion design, co-built Toucan Toco dashboards (team of 3). Project became a sector benchmark, renewed and expanded annually.
• AFPA (Integration survey, 3.5 years): Automated coding model using supervised neural networks, designed and industrialized independently (Keras/TensorFlow, Word2Vec, spaCy) — ~70% of verbatim responses coded automatically, tens of thousands per month, in a human-in-the-loop production environment.
• CEREQ (Survey ~€2 million): Responsible for all technical aspects (~50-60 critical points), technical coordination of a subcontractor, Python automation (1,000+ variables).
• Qualtrics Partnership: Technical referent (leboncoin, CNSA with RGAA accessibility audit, Antargaz via 100% automated SMS).

Head of Digital Transformation

• Facilitation of weekly Digital Steering Committee (General Management, Sales, Finance).
• Functional lead for a team of ~10 people, participation in 5-6 recruitments, ~10 training sessions conducted (Python, SQL).
• Technological transition: introduction of Python + SQL to replace VBA, creation of a development hub in Dakar.
• Change management: needs gathering, specifications, SaaS benchmarking, adoption support.

Impact:

Upstream Project Structuring

• Design of OBS (Organizational Breakdown Structure), WBS, and PBS
• Facilitation of multi-trade workshops for collaborative PERT chart construction
• Duration estimation and intervention sequencing

Coordination & Steering

• Coordination of 15-20 stakeholders and 30-40 technical interfaces: railway signaling, onboard equipment, civil engineering, high voltage, software.
• Preliminary Design / Detailed Design / Construction schedules using MS Project (+ Planisware/OPTEAM).
• Project governance (meetings, frequencies), progress reporting to the Project Owner.