Ariel Segoun

Develop predictive models to anticipate failures and improve decision-making in the purchasing and usage process of electronic components. With an excellent ability to communicate technical results to non-specialist stakeholders, I can make data intelligence accessible to everyone.

-Administration and optimization of SQL performance: Monitoring and optimizing SQL performance, including re-indexing, query tuning, and database parameter adjustments for optimal response times, even with growing data volumes. -Design and management of a SharePoint site for project documentation: Development of a SharePoint collaborative space to centralize and organize technical documentation for database management projects for the Montpellier teams. -Securing sensitive data: Implementation of advanced security controls, such as encryption of data in transit and at rest, and access management with specific user roles - Continuous monitoring. -Automation of maintenance tasks: Creation of maintenance scripts (in SQL and PowerShell) to automate log checking, backups, and table growth monitoring. -Optimization of storage architecture: Restructuring databases and implementing partitioning. -Training of internal users: Customized training sessions for database users, covering SQL best practices, permission management, and reporting tools. -Technical documentation and disaster recovery plan: Writing detailed documentation, including a disaster recovery plan (DRP), backup procedures, and incident management.

-Data exploration and transformation for advanced modeling: Analysis of heterogeneous, cleaned, and transformed datasets. -Development of Power BI dashboards for real-time monitoring: Design of interactive dashboards with PBI for dynamic KPI visualizations, adapted to the specific needs of business teams, allowing real-time monitoring of their process performance. -Data cleaning and anomaly management: Use of Python scripts to identify and handle missing values and anomalies, ensuring clean data for downstream analysis. -Rigorous documentation and communication of results: Writing technical reports and presentation documents tailored for non-technical teams, facilitating a clear understanding of the results and recommendations from the analyses. -Cross-departmental collaborations for business analysis alignment: Close collaboration with teams from various departments (HR, logistics, finance) to adapt analyses to specific needs, ensuring practical application of the results.