Client oriented:1-data mining strategyDevelop and prepare strategies for Business Intelligence processes for clientsManage new report generation and report enhancement based on the change requests.Determine business intelligence and data warehousing solutions to meet business needs.Supervise efficient working of all Business Intelligence projects and analyze requirements and perform appropriate tests on same.2-data modelManage all data for transactional sources and prepare effective reports.Analyze all complex data and identify requirements for business enhancement in project.Manage and customize all ETL processes as per customer requirement and analyze all processes for same.3-implementation tool BIPerform quality assurance checks on new or enhanced reports.Benchmark and tool implementationCreation standard Business report delivered on a recurrent basisCreation both functional and technical requirement/needInternal responsibilities:1-general accounting efficiencyPerform analysis on organization processes and provide appropriate results.Work with process development and resource teams and prepare appropriate schedule.Analyze operational accounting process and propose efficiency gains through a better use of dataDevelop automation in the accounting processes2-accounting upgrade (reporting oriented)Develop standard reports and functional dashboards based on business requirements.Maintain business intelligence models to design, develop and generate both standard and ad-hoc reports.Generate reports for internal and external customers for business performance monitoring and business decision making.Implement analytic accounting (reporting oriented)Ensure to generate and deliver quality reports to customers in timely and accurate manner. 3-Automation/OCR/robotizationRecommend improvements to provide optimum reporting solutions.Administer projects, prepare updates and implement all phases for project to achieve all project objectives.

• Lead the change strategy from statutory accounting to analytical accounting in order to consolidate the data and feed reports to internal client.• Design and create data model to structure the data and the calculation associated• Implement smart set of reports based on the data model• Lead and initiate the budget exercise. The P&L is split in 3 category Revenue and charge driven by the production, direct cost, and indirect cost.• Implement Power BI as our BI tool for the group. The set of reports are made directly in the Power BI Portal.• Oversee the training on Power BI for the final users.-----Data model based on Accounting & Payroll data-----Automatic feed from web services-----Calculation based on user input/choice-----Implementation Group chart of account-----Group Owner Account Payable tool and processes-----Cash flow and consolidated cash statement-----Contribution per Project-----Multi versioning based on data collected from OPS Staff

Initiate and lead creation of client oriented smart reporting. Threw understanding functional and business need to create technical requirement.• Oversee the development of the data model, manage the Agile approach leading to the creation of the final reports.• Manage and create a Cube data model for Finance Team:-----Revenue per employee/FTE-----Contribution per employee/FTE-----Robust data model based on both cost centre and profit centre accounting-----Multiple data source management (Excel files, SQL DB, SQL Datawarehouse)• Integrate US entity from M&A into AD analytic Chart of Accounts:-----Data transformation based on US GAAP export to Lux GAAP-----Reporting process improvement/automation• Initiate and lead high level Dashboard for Private client Segment:-----Tailored KPI and dashboard based on requirement-----Reviewing data quality (budget and actual)• Creation Cube data model for HR analytic team:-----Collection of functional need and specific logic-----FTEs calculations-----In, Out Forecasting based on the recruitment performance and turnover historical data

• Oversee recurrent and ad-hoc finance reporting for the Board members and Top management• Oversee the budget exercise for the Group:-----Data collection from all the country executives-----Calculation and data transformation• Assist on the balance sheet budget exercise (Revenue, account receivable, Work in Progress)• Assist creation of Long-term plan (5 years) based on the budget.• Create and lead the change of inter-company transfer pricing policy:-----New calculation rule presented to the Board and executive committee-----Creation of the program calculating the amount of the recharges-----Management of the operating staff-----Reconciliation with the accounting-----Explanations and assistance with the auditors• Create and manage the execution of the board deck:-----Creation of excel files with high level of granularity-----Process improvement (From 5 days to deliver to 1 day)-----Excel automation with direct links to SQL Datawarehouse

• Accounting side: o Booking (Invoices, loan interests, tax operations, …) o Regular accounting reporting o Cashflow Management• Legal side: o Performing board minutes o Reviewing loan agreement o Reviewing shareholder register• Tax side: o Tax return o VAT return

Développement de 2 programme VBA sous excel : Automatisation de saisies et de calculs du contrôle de gestion- Création d'un programme sur un outil déjà existant listant l'ensemble des charges et produits de l'entreprise.- La saisie et le contrôle était alors longue et fastidieuse (+ de 400 feuilles excel)- automatisation de saisie des nouvelles missions et informations clés- automatisation de calculs de la marge opérationnelle mensuels selon 2 cheminement afin de vérifier et contrôler son authenticité. Création de mise en forme du reporting mensuel de performance- Après la création d'un logiciel interne réunissant toutes les données clés de l'entreprise (facturation, salaire, time-sheet, congés,frais des salariés,...) le logiciel était capable de sortir un reporting de performance de l'entreprise sous forme excel brute- Automatisation de mise en forme à partir du fichier brute - création d'une feuille excel par : directeur de centre de profits, ingénieur d'affaire, ...- création d'une feuille synthèse capable de répartir les indices de performances par centre d'activité, directeur de centre de profits, ingénieur d'affaire, région géographique,...Elaboration de statistiques de performance :- Statistique de performance des Ingénieur d'Affaires- Statistique d'Inter-contrat- Statistique de démarrage et fin de mission

Chargé de croissance externe : Recherche de concurrents suivant un cahier des charges, contact du concurrent et négociation de cession.