Freelancer profile translated to English.

Description

With 15 years of experience in decision support, I bring my expertise in decision support analysis and programming, business process automation, data processing and administration, and database organization to meet the performance and maintainability requirements of IT (Storage/Retrieval Phase).

I have always worked closely with business units (Statistics/Marketing/Insurance/Management Control/Accounting), acting as an interface with IT departments, as well as internal reactive IT and industrialization, closely aligned with client needs.

Languages

English
Native or bilingual
French
Native or bilingual

Workplace preferences

Remote only

Primarily works remotely

Réseau Compétences et Développement
SQL Server Consultant
EDUCATION AND E-LEARNING
October 2022 - January 2023 (3 months)
> General Context: Finance, Accounting, ERP migration from Cegid to Sage
> Project’s mission: Migration tool and Datawarehouse in-house
> Assigned responsibilities: Tech lead, Microsoft SQL server, SSIS (SQL Server Integration Services)
- Technical recommendations on software and equipment
- Analysis and Conception
- Database architecture
- Data quality
- SSIS data flow development and maintenance
>Technical Environment
- O/S: Windows, Windows server
- Languages: SQL, Python, Dax, Batch
- Database: Microsoft SQL server, Access
SQL server Datawarehouse Database Modeling Data Quality
Panini France
Decision Support Consultant
PUBLISHING
March 2016 - Today (10 years and 3 months)
Nice, France
> General Context: Management control, Finance, Sales, Logistics, Publishing, Datawarehouse, Windows server
> Project’s mission: Datawarehouse in-house and remote management
> Assigned responsibilities: Microsoft SQL server, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), Power BI, Remote Tech support
- Inventory of needs
- Technical recommendations on software and equipment
- Analysis and Conception
- Database architecture
- Data quality
- SSIS data flow development and maintenance
- SSRS report development and maintenance
- Power BI report development and maintenance
>Technical Environment
- O/S: Windows, Windows server
- Languages: SQL, Python, Dax, Batch
- Database: Microsoft SQL server, Access
SQL server communication management control accounting
Air France
Unica Expert
TRANSPORTATION
December 2013 - September 2022 (8 years and 9 months)
Valbonne, France
> General Context: Airline Company, Marketing, IT, Operational systems, Data administration, Unix scripts
> Project’s mission: Unica architecture
> Assigned responsibilities: Unica Architect, Technical design of Unica marketing campaigns, development and Oracle administration, Teradata query development, Level 3 support, Responsible for the platform’s performances, Technical project manager
- Production follow-up
- Servers monitoring
- Query optimization, indexes, materialized views, Oracle partitioning
- Data feed creation
- Infrastructure projects monitoring
- Architecture of the interactions with other systems
- Validation of technical solutions
- Setting-up the Unica tool
- Users’ training for the tool and solutions
- Recurring campaigns development
- New feature development
> Technical Environment
- O/S: Windows, UNIX
- Languages: SQL, Shell Unix
- Database: Oracle, Teradata, Unica eMessage, Unica Campaign, Unica Marketing Operation, Precise
Oracle UNICA Teradata