Liliane Huang

Lead Data Engineer / Data Analyst - PSP Investments Data Analyst - Ivanhoé Cambridge (9 mois) Data Engineer – Humania Assurance (8 mois)

• Lead the migration of BI solutions (SSIS/SSAS) from SQL Server 2014 to 2019 • Design and optimize end-to-end data pipelines (SQL Server, SSIS, Snowflake, Databricks) • Develop and automate dashboards and reports (Power BI, Tableau) • Manage CI/CD deployments and production releases (Azure DevOps, GIT) • Collaborate with business teams to gather requirements and ensure data quality • Mentor two developers and manage project delivery in an Agile environment

• Analyze business users needs into data solutions • Design and optimize data models (SQL Server, SSIS, DAX) • Build and maintain Power BI Dataflows and Datasets (Power Query, Tabular Editor) • Create and optimize interactive dashboards and KPIs in Power • Design Power BI Metrics Scan with ChatGPT to improve data governance

• Design and implement ETL pipelines (SQL Server, SSIS) • Develop stored procedures for the IFRS17 project • Create report and dashboard (Power BI) • Participate in technical and user acceptance testing

• Design and develop ETL processes (SSIS) for the enterprise data warehouse • Create and optimize stored procedures, tables, and views to increase performance • Develop SSRS reports and MDX/DAX queries for analytics • Contribute to the design of the SSAS cube and maintain technical documentation

• Data Engineer - Orange Bank (3 ans 8 mois) • IT Business Analyst - BNP PARIBAS (6 mois)

• Analyze business needs and write technical specifications • Design and implement the enterprise Data Warehouse (SQL Server, SSIS) • Develop financial and marketing reports (SSRS) • Create fraud detection data flows (SAS Viya, ISoft) and monitoring dashboards (Kibana) • Optimize data processing performance in a Big Data environment (Hive)

Project SRS (Shared Reporting Space): Centralized Datawarehouse in accounting and risk for local and group entities - credit risk subject • Gather and document business requirements for data solutions • Map data models (Teradata) and ensure functional consistency • Perform functional and technical testing (HP ALM)

Project: Implementing Key Performance Indicator and dashboards for Business team • Identify user needs and define performance KPIs • Design and populate a data warehouse (Oracle 11) • Develop performance dashboards (Tableau)

- Ensuring quality of documents (business proposal, contract, agreement...) - Checking deontology of projects - Improving process of the Junior-Enterprise - Audit of the Junior-Enterprise