Omar HOUAMEL

– Analysis and Reporting: Creation, maintenance, and improvement of Power BI dashboards to monitor KPIs and sales performance. – Commercial Excellence: Supporting the commercial strategy through the optimization of the sales force (segmentation, targeting, action plans, incentives, ad hoc studies). – Strategic Collaboration: Close collaboration with the Dermatology BU, CRM teams, Digital teams, and external partners to drive innovation and enable informed decision-making. – Participated in an ETL project aimed at automating data extraction from multiple websites and systems. Developed Python scripts for data extraction and transformation, with automated delivery to SharePoint, enabling seamless integration into Power BI dashboards. Leveraged Power Automate to orchestrate weekly data workflows and ensure up-to-date reporting.

– Maintained and updated PowerBI, Nayact, and Veeva tools, resolving technical issues. – Served as the local administrator for the Nayact platform, managing user administration requests. – Extracted and prepared necessary data for analyses and reports. – Collaborated with the team to meet specific data analysis needs. – Participated in the development of new dashboards on Power BI.

– Implemented encryption for symmetric and asymmetric cryptosystems on smart cards using Python with PyCryptodome, Cryptography, and PyNaCl libraries. – Managed data using SQL to support cryptographic algorithm implementation on smart cards efficiently. – Protected against physical attacks through simple power analysis (SPA). – Conducted performance and security tests to optimize smart card encryption.