Fanomezantsoa Emma Rafaraniaina

• - Explore and analyze SAP HANA and IQ source databases.

• - Model the datasets needed for various business requirements.

• - Design, develop, and maintain reports.

• - Train and support colleagues in using Microstrategy.

• - Participate in information system evolution projects: migration of SAP HANA & IQ data to Snowflake cloud by analyzing the impact on existing data and processes.

• - Collaborate with technical and functional teams to test, validate, and deploy new features, ensuring data quality.

• - Lead, monitor, and deploy the project in different environments using the agile methodology.

• - Design and implement reporting security (ACL): finance, sales.

• - Manage licenses, user access, mass subscription on activity reports.

• - User support and backlog monitoring (SLA improvement) using the ITIL methodology. → Tools used: Microstrategy (object manager, integrity manager, command manager, developer, workstation, analytics platform), Squirrel, HANA Studio, Snowflake, Jira, Confluence,

• - Data cleaning and modeling.

• - Creation of KPIs and dashboards. → Tool used: Microstrategy web

• - Data exploration, modeling, and analysis.

• - Creation of new KPIs with DAX formulas and automation of data updates.

• - Testing of confidentiality axes (RLS): data governance.

• - Support teams in expressing their needs and in mastering indicators. → Tools used: Power BI, Sql Server Management Studio