Freelancer profile translated to English.
Back to original languageAbout Lahcen
SKILLS SUMMARY
I have extensive experience in SQL Server database administration and Microsoft BI solutions, covering performance optimization, modeling, ETL, and reporting. I have worked in demanding environments, particularly e-commerce and ERP, and have supported teams on complex technical projects. My technical expertise and ability to implement standards and provide team support meet client expectations for the management and industrialization of SQL Server and BI environments.
English
Fluent
Arabic
Native or bilingual
Can work on-site
Paris (up to 50km)
Experience
- VeepeeDatabase Administrator –E-COMMERCEAugust 2012 - October 2025 (13 years and 2 months)Saint-Denis, France• Resolving application blockages on databases to ensure service continuity.• Improving SQL performance by analyzing and optimizing queries and stored procedures.• Optimizing stored procedures and SQL queries to reduce response times and improve processing efficiency.• Implementing tuning and indexing techniques to optimize data access and overall database performance.• Designing and validating new data structures adapted to business needs and application evolutions.• Training and supporting BI teams on best practices for using databases and decision-making tools.• Contributing to projects using Greenplum, SSAS, and PowerPivot for reporting and data analysis.
- Axiwell (mission Veepee)SQL Server DBA Expert – Back Office StudiesOctober 2011 - July 2012 (9 months)Consulting and expertise mission for the implementation and optimization of the SQL Server database infrastructure at Veepee, with a focus on Microsoft BI and Data Warehouse feeding.• Designing databases under SQL Server 2005 and 2008 to meet business needs.• Implementing high availability solutions via SQL Server clustering.• Implementing partitioning strategies to optimize the management and performance of large datasets.• Implementing database replication to ensure data redundancy and availability.• Developing and managing BI flows with Microsoft SSIS, SSRS, and SSAS tools.• Designing and feeding the Data Warehouse to centralize and structure decision-making data.Environment: SQL Server 2005-2008, SSIS, SSRS, SSAS, Oracle.
- ProdwareHead of BI / Collaborative DBA DepartmentOctober 2006 - September 2011 (4 years and 11 months)Design and deployment of decision-making solutionsDevelopment and deployment of decision-making solutions for various clients, administration of multi-technology databases, and performance audits.• Designing and developing decision-making solutions tailored to client needs.• Deploying BI solutions to improve decision-making and data management.• Administering SQL Server, Oracle, and MySQL databases to ensure their performance and security.• Performing performance audits on databases to identify and correct bottlenecks.• Implementing best practices and standards for database administration. Environment: Server, MySQL, ERP Dynamics AX & Navision
Recommendations
Be the first to recommend Lahcen
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- ENSIMAG Engineer– Institut National Polytechnique de GrenobleIngénieur ENSIMAG
- Microsoft SQL Server – 70-432 Implementation and MaintenanceMicrosoft SQL Server – 70-432 Implementation and Maintenance