Colas Ledoux
Senior Consultant in Management, Sopra Consulting
Management Consulting : Audit, analysis of the client’s needs, writing of reference documents, meetings facilitation, training, mastering of the consulting methods
Project Management : Technical and functional coordination, planning, budget monitoring, change management
BI Consulting : Designing of the analysis and reporting tools, testing
Sectoral skills : Industry (energy), Services (retail, HR), Public Sector, Banking
Languages
French : Mother tongue
English : Fluent (6 months experience in Canada)
Spanish : Basic knowledge
Italian : Basic knowledge
Softwares
Project follow up : MS Project, TestDirector
Office Tools : Word and Excel (University Trainer), PowerPoint
BI : BusinessObjects (3 years), SAP BI
Programming : SQL (8 years), Visual Basic/VBA, HTML
Statistics/Mapping : SAS (6 years), StatGraphics, SPAD, Sphinx, MapInfo, GeoConcept
101 contacts- Operational management of a transformation project, EDF (Industry), 1 year
Description : Deployment on the pilot region of a new preventive maintenance model in the hydraulic energy sector, part of the RenouvEau project (€800M)
Roles : Operational management, project planning (MS Project) and organisation, meetings facilitation, communication, change management regarding to the new roles and technology tools (EAM: Ventyx Asset Suite ; planning: Planisware)
- Operational management of an application, EDF (Services), 2 years
Description : Technical and functional coordination of the maintenance in operational conditions and the evolutions of a customer billing data warehouse (Janus)
Roles : Management (2 people), operational reporting, budget monitoring (€600K), steering committee facilitation, writing of the technical documentation: operating file, technical architecture file (technologies : Sybase, Informatica, CFT, Control M), business continuity plan
- Redesign of a data warehouse, Ministry of Justice (Public Sector), 6 months
Description : Overhaul of the penal data warehouse (APPI)
Roles : Business requirements analysis, harmonization of the dimensions and indicators, writing of the RFP and the functional specifications of the data base and the BusinessObjects reports, animation of meetings and workshops
2005 - 2007- Set up of a data warehouse, Bank of France (Banking), 15 months
Description : Development of the data warehouse of Target2, payment platform involving the whole European banking system
Roles : Writing of the functional specifications, development of the BusinessObjects reports, creation of the test plan and testing of the data quality (SQL requesting), animation of seminars and end-users trainings in English
- Launch of the BI solutions, Randstad (HR), 11 months
Roles : Testing of the existing BI systems (SQL), writing of the functional specifications according to new customers needs (Business Objects)
2005 - 2005Description : Follow up of the expenses of the Social Scheme for Independent Professionals
Roles : Data extraction, building of an automated reporting tool (Excel, VBA), mapping (MapInfo), forecasting (SAS)
2004 - 2004Description : Update and modification of the processes of the Survey on Employment, Payrolls and Hours (SEPH)
Roles : Audit of the current processes, modification of the calculation processes of the indicators (SAS), meetings and presentations to customers in English