Safae Chguar

- Encadrer des étudiants sur des projets data, de la conception à la remise finale - Transmettre les concepts fondamentaux de la data - Présenter et démontrer des outils et plateformes data Ecole : ICD Business School, Ynov School, CFA App-rendre

- Contributing to data migration between management systems (ETL) - Analyzing business requests submitted via Jira, clarifying technical and functional specifications during alignment meetings - Exploring the global data mapping to identify relevant sources, creating specific mappings including tables, fields, and filters - Managing transcoding to align raw data with business needs after workshops - Developing and optimizing complex SQL queries on Amazon Redshift - Conducting in-depth investigations of tables to identify missing fields and null data, and creating detailed Jira tickets for IT (with the type and origin of each anomaly) - Validating extracted datasets (CSV format) with business teams and updating queries based on their feedback - Passing SQL queries to IT teams and coordinating with data engineers to automate recurring extraction processes (weekly/monthly) - Designing interactive dashboards in Tableau for KPI tracking and decision support, implementing aggregations and advanced visualizations

- Automated data processing for improved reliability - Developed Python-based GUI tools that reduced data entry errors and saved 40 hours of work per month - Developed new SAS-based control procedures that improved accuracy - Developed tools for the quarterly closing, resulting in a 50% reduction in working time - Developed a Power BI dashboard that provided real-time insights and improved decision-making - Developed processes and operating procedures for daily work, improving new employee onboarding - Monitored data quality with monthly controls - Monitored flows between banking and automatic entries, ensuring accurate accounting - Provided monthly reports on the progress of controls, identifying areas for improvement and recommended solutions

- Produced monthly management reports, including analyzing cash flow, forecasting financial trends, and preparing profit and loss statements - Conducted monthly data quality checks to ensure the accuracy of accounting data prior to account closing - Calculated margins from raw data in QlikView, providing insights into revenue and cost structures - Managed customer accounting, including creating invoices, sending payment reminders, and conducting account maintenance - Prepared and submitted VAT declarations on time - Conducted rebate and account closing activities, including verifying and reversing entries and ensuring timely completion

- Developing processes to effectively organize and manage the firm's operations - Maintaining and reviewing the accounting records to ensure accuracy and compliance with regulatory standards - Providing reliable support and guidance to clients throughout the accounting process - Preparing and submitting social declarations such as pay slips and DSN, as well as tax declarations such as VAT - Regularly updating accounting folders to ensure that the financial records are up-to-date - Conducting reviews of financial accounts at the end of each fiscal year, and ensuring timely and accurate closure of the accounts - Conducting annual balance sheets

- Assist the CAC in meetings with clients for audit assignments - Perform audits of the different cycles (financial and non-financial), in order to identify potential risks and verify the accuracy of data - Identify accounting risks and report any anomalies to the CAC - Prepare comprehensive reports detailing the results of the audit and recommendations for improvement - Prepare audit files to facilitate the certification of the accounts - Prepare EGM and OGM documents in accordance with regulatory requirements

- Maintaining and reviewing the accounting records to ensure accuracy and compliance with regulatory standards. - Providing reliable support and guidance to clients throughout the accounting process - Regularly updating accounting folders to ensure that the financial records are up-to-date - Conducting reviews of financial accounts at the end of each fiscal year, and ensuring timely and accurate closure of the accounts