CV/Mission Reports freelance

Exemple d'expériences de Ridha,
freelance REPORTS habitant le Val-d'Oise (95)

&#x2018Senior Business Intelligence Consultant&#x2019 at Dassault Systèmes
janvier 2024 - aujourd'hui
GOAL:
Within the IT department of Dassault Systèmes, the Order To Cash (OTC) organization is responsible for the customer flow from order
to cash, including contracts, invoicing, and license key generation.
The team is in charge of enhancements, support, and maintenance of the BI solution implemented to monitor client orders.
SKILLS DOMAINS
Gathering client orders from Oracle PeopleSoft CRM.
APPROACH
&#x2022 Develop, maintain, improve, and optimize ETL flows and BI solutions on the &#x2018DSx Client Order&#x2019 Datamarts (specific to
3DS) for the integration of client orders from Oracle PeopleSoft.
&#x2022 Participate in writing requirement studies, technical documentation, and unit tests.
&#x2022 Maintain (both corrective and evolutionary) and create reports (Webi) and universes (UDT, IDT).
&#x2022 Use historical and current orders data to predict future demand (via different snapshots).
&#x2022 Provide production support for the updates delivered after each drop (monthly).
&#x2022 Ensure the proper execution and optimization of daily data loading chains.
Led the migration of universes from .unv to .unx, ensuring a seamless transition:
&#x2022 Perform preliminary impact analysis with 360Eyes.
&#x2022 Convert universes to UNX format.
&#x2022 Test and validate the proper functioning of the new universes, correct any issues.
&#x2022 Migrate existing reports to the new universes using 360View.
&#x2022 Test the functionality of the reports and compare results before and after migration with 360View.
&#x2022 Manage access rights.
RESULTS
Client order data gathered, Datawarehouse up to date and all kind of analysis are available for end users.
&#11162 Environment technical details:
Data base : Oracle 12c / PostgreSQL 13
ETL : Oracle Data Integrator 12c
Business Objects : BI 4.2 and BI 4.3

&#x2018Senior Business Intelligence Consultant&#x2019 at ICADE Immobilier
GOAL
juillet 2019 - décembre 2023
Maintain and evolve the data warehouse in order to provide the KPIs necessary for monitoring promotional activity. Regular
publication of figures as a listed company on the stock exchange.

SKILLS DOMAINS
Real Estate and Land Development: management of programs and lots (reservations, sales, etc.) as well as part of the accounting.
APPROACH
&#x2022 Collection of needs, technical-functional design, technical implementation (guaranteeing the quality of both data and
restitution)
&#x2022 Evolution and creation of universes (IDT) and reports (Webi)
&#x2022 Planning and publishing reports
&#x2022 Ensure the smooth running and optimization of daily supply chains
Team management (composed of 3 consultants):
&#x2022 Monitoring of activity and project progress
&#x2022 Distribution of tasks.
&#x2022 Manage the team's schedule to meet delivery deadlines
Business Intelligence platform Administration tasks:
&#x2022 Ensure the proper functioning of the BO platform (performance, versioning, regular backups, etc.)
&#x2022 Management of rights and profiles (BO)
&#x2022 Installation of new BO Patches
&#x2022 Study and implementation of the migration of BO platform from version BI4.2 to BI4.3

RESULTS
&#x2022 Up-to-date data warehouse. Reports published regularly. Team able to respect its commitments to business teams.
&#11162 Environment technical details:
Data base : Oracle 12c / PostgreSQL 13
ETL : Oracle Data Integrator 12c
Business Objects : BI 4.2 and BI 4.3

janvier 2019 - mai 2019
&#x2018Business Intelligence Consultant&#x2019 at Disneyland Paris
GOAL
Provide the necessary indicators and reports to the various business teams.

SKILLS DOMAINS
Disneyland reservations and products.
APPROACH
The mission is carried out as part of a migration to a new system of reservation.
&#x2022 Gathering of requirements: Clarifications with business teams and direct communication with end users
&#x2022 Evolution of universes (IDT) and creation of reports (Webi)
&#x2022 Report schedules
&#x2022 Agile method: sprints, user stories, daily meetings&#x2026

RESULTS
&#x2022 Reservations monitored and anomalies detected.
&#11162 Environment technical details:
Scrum
Business Objects : BI 4.1

&#x2018Business Intelligence Consultant&#x2019
at Allianz Global Assistance
février 2017 - octobre 2018
Within the Allianz group, the role of the BI team is to provide the necessary KPIs to analyze the activity of assistance and quality
of provided service...
&#x2022 Analysis of user and business needs
&#x2022 Design Development of data flows (ODI)
&#x2022 Evolution and creation of reports and universes (Business Objects)
&#x2022 Communicate with end users
&#x2022 Propose solutions for optimizing reporting
&#x2022 Managing the scheduling of reports
&#x2022 Assist in the user testing phase.
Business Objects : BO XI 3.1
&#11162 Environment technical details:
Data base : Oracle 11g
ETL : Oracle Data Integrator 10 / Sunopsis

&#x2018SAP Business Objects Developer&#x2019 at ADP
juillet 2012 - janvier 2017
ADP provides for customers a BI solution called &#x2018Human Resource Intelligence&#x2019 based on their payroll and human resources data. It
allows them to have any kind of reports about these topics (all kind of information about workforce, contracts, experience, absence,
salaries, payroll&#x2026)
My role is to setup &#x2018Human Resource Intelligence&#x2019 for ADP customers in order to help them making future decisions. This includes:
&#9679 Building of a Data warehouse in order to host all data coming from payroll and human resources systems.
&#9679 Design of ETL scenarios in order to feed the Data warehouse with data. This includes cleansing the data, perform any modification
when needed (transcoding, integrate data from different sources to one destination&#x2026).
&#9679 Design of rule-based auditor to test the viability of simple ETL tasks.
&#9679 Using SAP Business Objects platform, create universes based on the Data warehouse schema and enhance learning and
information discovery by designing dashboards and reports (Web Intelligence and Desktop Intelligence) for use while making
decisions.
&#9679 Managing the resources, users, connections, and the Universe repository, Management tasks related to Business Objects. When the
solution is implemented and is working, the customers are granted access to the ADP Business Objects platform to view or create
their own reports and dashboards.
&#11162 Environment technical details:
Data base : Oracle 10g
ETL : Sunopsis V3 (old version of Oracle Data Integrator)
Business Objects : BO XI R2, BO XI 3.1 and BI 4.1.

&#x2018SAP Business Objects Technical Support Engineer&#x2019 at SAP
octobre 2009 - juillet 2012
During this experience I was a member of SAP technical support team (in Tunisia offshore site) that provides support services for
Business Objects customers (&#x2018Focus International&#x2019 is doing offshore for &#x2018SAP&#x2019). My mission is to help customers find solutions to a
various number and kind of incidents: Administration (CMC, CCM), Security (CMC), Managing users and accounts (CMC),
connection to system and reports databases issues (on Windows and Linux environments), all kind of Deployment and installation
problems (on both Windows and Linux environments), creating universes (Designer and IDT) and reports (Web and Desktop
Intelligence using Infoview, Webi Rich Client and Desktop Intelligence):
&#9679 Problems troubleshooting: technically assist SAP Business Objects customers. Interact with them and take in charge their incidents
and reclamations.
&#9679 Animate web and phone conferences (Net viewer and WebEx sessions): I interact with customers by email (through SAP CRM),
phone and Net viewer/WebEx sessions, which are a mean that allow me to remotely access the customers environments and help
them to resolve the problem encountered.
&#9679 Set up and tune customers&#x2019 platforms (BO servers, web servers...) in order to improve performance.
&#9679 Deploy and install Business Objects environments on virtualized test servers (VMWare Lab Manager): I am able to install the
product on different operating systems (Windows, Linux and UNIX) and deploy the web applications on different Web Application
Servers. In my role as technical support consultant, I should be able to perform such tasks in order to support the customers when
the found difficulties to perform them.
&#9679 Administer and manage Business Objects security: Mastering administration tasks creating Business Objects enterprise accounts,
managing users and groups, rights, publications, maintain servers, management of security and access levels to the various entities
(reports, folders, applications&#x2026)
&#9679 Design of Web intelligence and Desktop intelligence reports. Scheduling reports and resolving connectivity problems: the reports
to design are for internal use, for example if I need to test a behavior of Web Intelligence in particular cases/configurations&#x2026I&#x2019m
able to create reports and test it. Or when the customer needs assistant to create audit reports (based on &#x2018Activity&#x2019 universe), it&#x2019s me
who create the report for him or show him what to do exactly.
&#9679 Design universes with &#x2018Business objects Designer&#x2019. For internal use or when assisting the customer to do some tasks or resolve
issues.
&#9679 Migration process to BO XI and BI 4.0 versions: When BI 4.0 was released, one of the most important tasks I did is to help
customers using BO XI3.1 and XI R2 to migrate to BI 4.0. So, I have a good idea about the migration process to this new version.
&#11162
Environment technical details:
Environments: Windows and Linux.
Business Objects : BO XI R2, BO XI 3.1 and BI 4....