Market research
Company sourcing
Search for companies in the same market to identify competitors or potential buyers, for a start-up.
Open source advanced internet search (OSINT) to perform company intelligence for the purchasing division of a major group.
Search for suppliers in receivership to measure the counterparty risk (consequence of a supplier's breakdown in service) for the executive management of a major group (using the BODACC API).
Mass SIREN searches using the INSEE Sirene API by APE/NACE code, for the purchasing division of a major group.
Business plan, controlling
Finance
Risk management
Production of a business plan with sales, expenses and cash flow forecasts, and construction of a projected balance sheet and financing plan for a start-up company.
Study, design and development of a sales calculation model based on technical data from the plants, annual maintenance planning, waste reception forecasts and customer, transport and operating consumables supply contracts, taking into account price indexation (INSEE indices) for a medium-sized waste-to-energy company.
Training in various financial investments (bonds, equities). Technical and fundamental evaluation of financial assets, risk management strategy, financial analysis, for a SME executive.
Financial analysis of supplier companies to assess financial risk for the purchasing division of a major group. SMEs, ETIs, large French and foreign groups. Governance analysis.
Automatic data collection (API and web scraping, python) on European stocks for analysis and selection of stock market investments (over 300 stocks tracked), internal project.
Purchasing and logistics
Training in purchasing and logistics, expert level: purchasing, quality, MRP, optimization of logistics diagrams (linear optimization calculation).
Drafting of specifications for finishing work, from drawing up plans, detailing elementary works and budget estimates for a renovation project, non-pro custommer.
Request for quotation (finishing work, cleaning services, IT services, industrial work (revamping of an industrial boiler water treatment plant, maintenance, automatic command & control systems) for a medium-sized waste-to-energy company.
Operational performance management
Benchmarking of waste treatment plants on the basis of operating indicators, multi-factor comparison using data science (PCA), with Microsoft Excel, for a medium-sized waste treatment company with energy recovery. Implemantation of technicals KPI to manage performance.
Measurement of Overall Qaulity Costs in a medium size waste to energy company. Identification of the various costs of internal malfunctions, targeting major malfunctions as well as the "background noise" of non-quality, based on a key-word study of purchasing expenses.
Development of an automated tool for calculating back rebates (VBA in Microsoft Excel, connected to a database in an OLAP cube) linked to contracts, Purchasing Department of a major group.
Automatic production of customized internal customer reports, based on a data model built in Microsoft Excel with Microsoft Power Query, Microsoft Power Pivot and generation in Microsoft PowerPoint of the result for the Purchasing Department of a major group.
Training in the use of Microsoft Power BI to collect and format data and produce dynamic dashboards for the purchasing division of a major group.
Automation of environmental reporting based on hourly data produced by smoke analyzers to produce daily and monthly summaries, including threshold deviations. Design, implementation and commissioning of a Microsoft Excel macro for a medium-sized waste-to-energy company.
Production of various purchasing studies using a Business Intelligence tool (Microsoft BI). Analysis of expenditure by supplier, by market sector, by geographical region, by allocation in general and cost accounting. Studies carried out for internal and external clients (public bodies). Services provided for the purchasing division of a major group.
Apps and data visualization
Production of an application (R Shiny) to illustrate road accidentology in mainland France from 2005 to 2018. Based on the government's OPEN DATA and put online Road Link to French road accidentology
Creation of an application to geolocate the higher education schools of the Conférence des Grandes Ecoles. Link to Kartekol.
Development of an application to geolocate "Installations Classées pour la Protection de l'Environnement" (ICPE) . Data from georisques.gouv.fr,