Lhoussine EL OMARI

Central Data Office: Managed and led various worldwide Business Intelligence (BI) projects across diverse domains, including the implementation of Data Mesh principles.
Team: Data Office team located in France and Morocco - International context
Role: Data Project Manager, BI & Power BI Expert

- End-to-End Data Project Management: Successfully managed the complete delivery of data projects on Azure Databricks and Power BI, ensuring on-time and within-budget completion through effective planning and execution.
- Power BI Governance & Expertise: Drove the development and enforcement of Power BI governance policies and procedures, leveraging deep technical expertise to guide and support users.

Technologies: Power BI, Azure Databricks, Cloudera, Azure DevOps.

• Key responsibilities included developing Power BI dashboards and reports for regulatory transaction
monitoring, providing technical leadership (code reviews, datamart optimization), and supporting &
implementing Oracle APEX reports.
• Contributed to project lifecycles, managed production monitoring, and addressed ad hoc regulatory requests.

Technologies: Power BI, SQL, Oracle APEX, PL/SQL, Oracle 11g, Oracle Exadata, Python, SSIS, SSRS, Kibana,
Unix, Jira.

BASYLIQ Project - BAse de SYnthèse de LIQuidité: BI Project that aims to produce internal steering and regulatory indicators linked to Asset and Liability Management (Liquidity, Interest Rate Gap, NPV sensitivity, Foreign Exchange Position, Net Interest Margin).
Team: ALM Central. Paris (~10) & India (~6) - International Context - Agile environment (SAFe)
Role: Senior BI Engineer

- Led technical and functional aspects for key financial data domains.
- Delivered reporting and analytical solutions using Business Objects and Power BI, including data quality assurance.
- Engineered ETL and database components (Informatica, Shell, PL/SQL) to support regulatory reporting requirements.
- Drove performance enhancements for high-volume data environments across various platforms.
- Provided technical and functional support to development and testing teams, ensuring smooth project delivery.
- Developed and maintained comprehensive documentation and supported production and transversal stakeholders.

Technologies: SAP Business Objects BI4 (Designer, Web Intelligence, CMC), BO 360Suite, Informatica PowerCenter 9.6/10.4, SQL, Power BI, Oracle Exadata, Oracle 11g/12c/19c, Unix, Jira.

Role: BI development, management and expertise on Power BI, SSAS cubes and Informatica/SSIS ETLs.
• Managed data projects including the PPD Dashboards implementation (data modeling, SSAS Tabular, Power
BI), BOOST ETL optimization, and BI VIP cube improvements.
• Responsibilities spanned the full project lifecycle, including development, deployment, documentation,
security, and team onboarding.

Technologies: Power BI, SSAS Tabular 2016, MSBI, SSAS Multidimensional, DAX, MDX, DAX Studio,
SQL Server 2012/2016, SSIS, Informatica PowerCenter 10.1.

• Managed the full lifecycle of data warehouse solutions, from data modeling and ETL development to SSAS
Tabular cube implementation and deployment.
• Oversaw Informatica upgrades, implemented continuous delivery, and conducted POCs for new technologies
(Spark/Scala, Hive).
• Responsibilities included team onboarding, access management, and production support.

Technologies: SQL Server Analysis Services Tabular 2016, SQL Server Management Studio (SSMS),
Power BI, DAX Studio, Oracle Exadata - PL/SQL, Informatica PowerCenter SE 9.5/10.1, Kibana, Elasticsearch,
SQL Server, T-SQL, Tableau, Autosys, Software Factory & Continuous Delivery (Git, XL Deploy, Jenkins,
Liquibase), REST APIs, MicroStrategy, Data Lake (Hadoop, Hue, Spark/Scala, Hive, Sqoop, Oozie, HBase), Jira.

• Led Informatica V9.5 upgrades across 5 subsidiaries and optimized DataWarehouse processing (PL/SQL and
Informatica) on Teradata, achieving a 40% reduction in workflow processing time.
• Developed PL/SQL migration flows for a CEGID to SAP data migration project.

Technologies: Informatica PowerCenter 8.6/9.5, Informatica PowerChannel 8.6/9.5, Oracle 9/10/11g, PL/SQL Developer, Teradata 13, Teradata SQL Assistant 13, Bteq, Batch, Filezilla, Cygwin.

Master-I life insurance software’s maintenance and integration: ETL Informatica performance improvement project, evolution and data migration projects.
- Involved in Informatica, Business Objects, and Shell development for multiple projects.
- Improved system performance by conducting analysis and implementing optimizations, resulting in a 60% reduction in daily and monthly batch duration.
- Managed test plans, incident follow-up (HP ALM QC, Jira), and component packaging/deployment.

Technologies: Informatica PowerCenter 9.1, Informatica Metadata Manager, Oracle 10/11g, Toad, PL/SQL, BO Web Intelligence XI R3, HP ALM Quality Center 11, Jira, XML, Shell, Filezilla, Putty, Control-M.

• Led a UAT team of 5 testers and contributed to EDW projects by defining testing strategies, estimating testing
efforts, and driving meetings.
• Involved in EDW modeling, business analysis, and the creation of functional and technical specifications.

Technologies: Informatica DB2.

NSID project: New IS to standardize water management in Paris.
Migration of Parisian data (contracts, customers, etc.) to the new Wat.Erp tool
- Performed data analysis and cleaning using Informatica Data Quality (Profiling, Matching...).
- Developed and executed migration jobs using Informatica PowerCenter and IDQ.

Technologies: Informatica PowerCenter 8.6, Informatica Data Quality 8.6, Oracle 10g, Toad, SQL Developer.

• Experienced in database modeling, technical specifications (Informatica Data Stencil), Informatica interface
development, and unit testing.
• Served as technical lead, ensuring ETL best practices and client environment conformity.
• Managed change requests, test planning, deliveries, and knowledge transfer.

Technical environment: Informatica PowerCenter 8.6, Oracle, Toad for Oracle, HP Quality Center, IBM Rational ClearQuest, PowerAMC, XML, Winscp, Putty.

Project for the implementation of methods for the management of uncertainties in reservoir engineering.
Development under R of the PLS (Partial Least Square) regression to replace a numerical simulator.

Technical environment: R Statistical Software.