Freelancer profile translated to English.
Back to original languageAbout Alexandre
Data Engineer with 13 years of experience in the Microsoft ecosystem, expert in SSIS ETL, complex workflow orchestration, multi-format data integration, and BI development (SSRS/SSAS). Proficient in collaborative environments Confluence/Jira and development management via Git & Bitbucket. I support my clients in the design and deployment of BI solutions, while ensuring the maintenance and evolution of existing systems. Versatile, I can adapt to projects of any nature.
French
Native or bilingual
English
Fluent
Can work on-site
Tours (up to 50km)
Experience
- La Financière de l'Echiquier - LFDEBusiness Intelligence EngineerDecember 2021 - Today (4 years and 6 months)Paris, FranceOperational maintenance and RUN support: supervision of tools and systems, resolution of N2/N3 incidents, implementation of corrective and preventive actions to ensure the availability and reliability of processes. Organization and monitoring carried out via Jira.Design data integration pipelines: data collection, transformation, loading with SSIS, manage JSON/XML/CSV and database flows. Development management orchestrated with Git & Bitbucket.Orchestration and automation of processes: design and operate multi-platform workflows (Stonebranch UAC — Universal Workflows, Task, Script, Monitor) to control application and batch jobs and produce associated documentation under Confluence.Develop in Python: automate and consume REST/SOAP APIs via Python scripts, secure exchanges (OAuth2, tokens, encryption) and enrich/transform datasets with pandas, requests, and sqlalchemy.Bloomberg Enterprise Access Point Project: Design and deploy connectors to retrieve repositories, prices, and market data, configure subscriptions and secure access, then map and reconcile data in internal repositories and SSIS/BI ETL pipelines.Supervise collective data management: manage the needs of institutional clients (client/mandate repository feeds, contractual and regulatory reporting), control data quality.Development and operational maintenance of monthly reports via Vermilion: design, automation, and supervision of reports.Development and operational maintenance of commercial reports via Bricks: design, automation, and supervision of reports.
- LINCOLNBusiness Intelligence EngineerSeptember 2020 - December 2021 (1 year and 3 months)Project• Management, modeling, design, and population of SQL Server databases with SSIS• Processing of XML / SQL Server / WebService / Tibco EBX data• Execution of technical tests and acceptance: verification of data population and consistency• SSIS platform administration• Design of the data warehouse architecture• Processing of deliverables under GIT• DevOps deployment in higher environments• N3 Support• SCRUM Azure DevOps (Agile Board)
- SFRBusiness Intelligence EngineerOctober 2018 - September 2020 (1 year and 11 months)Client Project:• Business Workshops• Creation / study / Development / Maintenance of SSAS Tabular cubes• Creation, development of Excel Reports / Mailing• Data processing under SSIS• Development of recurring reporting via SSIS by email• Development of a Business Excel Interface to query the datamart or the project's QOD• Data retrieval from Teradata / SQL Server / Hive• Update processes for SSAS Tabular cubes under SSIS• Processing of QOD before updating cubes• Implementation and monitoring of KPIs / QOD KPIs• Implementation of GDPR regulations within the project• Business support and training
Recommendations
Be the first to recommend Alexandre
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Information Systems Manager, RNCP Level I, Information Systems ManagerExia.Cesi2013Manager des systèmes d'information, RNCP niveau I, Manager des Systèmes d'informations
- Information Systems Manager, RNCP Level II, Development EngineeringExia.Cesi2012Manager des systèmes d'information, RNCP niveau II, Ingénierie Développement