Ramata D.

I implemented Data Analytics and Visualization solutions on Power BI for the reporting needs of the firm and consulting clients, and for statutory audit mandates:

. Implementation of a data collection warehouse and a single repository for creating monitoring and sales management reports using the Oracle database

. Extraction, Storage, Cleaning, and Transformation of data for the implementation of querying and analysis solutions for turnover and fixed asset status on the open-source MySQL database

. Creation of data models, KPIs, and reporting dashboards for activity management and data quality audits in Power BI

. Design of reporting automation and accounting and management data analysis solutions on Power BI

. Audit of the compliance of accounting entry files (FEC): technical evaluation and data consistency control

Consulting mission

• Review of the specifications for the expected FEC format based on Article L. 47 A I of the Tax Procedures Book (LPF)

• Technical Framework: control of structure, field population

• Alignment with accounting statements (trial balance, general ledger, journals)

• Verification of FEC compliance with tax regulations (Article L. 47 A of the LPF)

• Evaluation of compliance with accounting records

• Verification of the completeness of documentation associated with the FEC and electronic data archiving procedures

• Issuance of a summary report and recommendations

I was involved in the IT system audits for the statutory audit mandates of Servier group companies to perform the following due diligence:

• Understanding of the IT systems and the general security policy of the Servier group

• Review of the IT Department's organization and strategy

• Review of IT General Controls (ITGC)

• Review of IT Application Controls (ITAC)

• Audit of the ERP JDE to SAP HANA migration project

• IT audit of the Inventory Management cycle workflow

• IT audit of the account consolidation process

• IT audit of the configuration and data transfer method of the PeopleSoft tool for payroll

• Assessment of risks inherent in information systems

• Analysis of IT environment compliance

• Implementation of internal control procedures and tools