Lamyaa BOULAJOUAHEL

 Analyzed client requirements and translated them into technical and functional specifications.  Maintained and updated technical and functional documentation.  Designed, deployed, and configured systems (including Guidewire), ensuring proper data flow integration  Conducted functional testing and validation of system features.  Provided production support : incident resolution, change request management.  Ensured data quality, consistency, and security within enterprise systems.  Continuously monitored system performance and proactively identified optimization opportunities.  Collaborated with IT, business, and QA teams in an Agile environment.  Supported end-users in understanding and utilizing systems and related data.  Tools: Guidewire, SQL (Oracle), Jira, Confluence, Excel

Analyzed reporting needs and proposed solutions aligned with business objectives. Oversaw the tracking and in-depth analysis of key performance indicators (KPIs) to support business units in strategic decision-making. Designed and optimized data extraction, cleansing, and transformation processes from multiple sources (SQL, data warehouses, flat files, etc.). Developed, maintained, and automated customized, interactive dashboards and reports, ensuring scalability and performance. Mastered and enhanced the use of BI tools by integrating best practices and quality standards. Provided user support, resolved complex technical issues, and trained operational teams in the effective use of BI tools. Tools: Oracle Warehouse Builder (ETL), Cognos, Tableau, Excel

Understood data requirements and proposed technical solutions accordingly. Led the migration of existing SQL queries, PL/SQL functions, and procedures into high-performance ETL processes, ensuring data integrity and flow optimization. Modeled and documented ETL workflows to ensure traceability, maintainability, and scalability of data processing. Developed and automated ETL processes to streamline data integration operations. Proposed continuous improvements to data integration tools and processes. Tools: SQL, PL/SQL, Oracle Warehouse Builder