Freelancer profile translated to English.
Back to original languageAbout Tanguy
👉 My job: to check and correct the history of your social declarations (DSN), for the control of your contributions and the defense of your employees' rights.
Payroll/DSN Analysis & Anomaly Detection (DSN MONITORING, FIAB DSN, SUBSTITUTION DSN)
Mass regularization of DSN history (RGCP, MOBILITY, LUMP SUM SOCIAL, ...)
Corrections with organizations (URSSAF, AGIRC-ARRCO, IRCANTEC, CNRACL…)
Payroll Steering via DSN
Excel Simulation Model Design
English
Conversational
French
Native or bilingual
Can work on-site
Bordeaux (up to 50km)
Experience
- IRP LINKConsultant DSN, Payroll, DSN Control and RegularizationHUMAN RESOURCESApril 2009 - Today (17 years and 3 months)Bordeaux, FranceConsultant for payroll-independent DSN history control and correction: 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 with NEODES standard- Support for DSN correction for FIAB DSN, substitution DSN reports, etc.Example achievement: recovery of €1 million in employer contribution reductions by adding 250,000 DSN coding lines©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, etc.)- Automated production of HR reports for consultation with employee representatives (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 managed by Webservice (NodeJs, etc.)Clients: Warner Music France, Editions Albin Michel et Lamartinière, Pages Jaunes + 100 referencesDesign for Pôle Emploi's General Directorate of Management Control of the MSDelta solution- Facilitation of a national working group for the definition of budgetary rules- Design of an Access module for regional analysis and forecasting of personnel expenses- Design of an Access module for consolidation and arbitration of regional forecastsBudget > €3 billion for 50,000 FTEsDesign of Excel models for financial analysis and simulations
Recommendations
Be the first to recommend Tanguy
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Arts et Métiers EngineerENSAM2001Ingénieur généraliste