Tanguy Daniellou

Consultant in payroll control and correction of DSN history outside payroll: solution driven by Excel with a PostgreSQL relational database

- Definition of an Excel format for DSN control by blocks

- History correction scripts by adding DSN blocks

- DSN compliance audit according to NEODES standard

- Support for DSN correction for FIAB DSN reports, substitution DSN, etc.

Example achievement: recovery of €1 million in employer contribution reductions by adding 250,000 lines of DSN coding

©BDUExpert DSN Edition: Excel-driven social management control solution and Economic and Social Database fed by DSN for SMEs/ETIs

- Monthly production of HR indicators from DSN files (absenteeism, headcount, gender equality,)

- Automated production of HR reports for employee representative consultations (BDES, etc.)

- Creation of a specific ETL for HR data: feeding, consolidation, custom processing

- Excel interface for feeding and data management of an SQLite solution

- Automatic generation of Excel and PowerPoint reports

- Security of access rights file and authentication driven by Webservice (NodeJs, etc.)

Clients: Warner Music France, Editions Albin Michel et Lamartinière, Pages Jaunes + 100 references

Design for Pôle Emploi General Directorate of Management Control of the MSDelta solution

- Leading a national working group to define budgetary rules

- Design of an Access module for regional analysis and forecasting of personnel expenses

- Design of an Access module for consolidating and arbitrating regional forecasts

Budget > €3 billion for 50,000 FTEs

Design of Excel models for financial analysis and simulations