Freelancer profile translated to English.

Description

SQL expert with a knack for performance issues, I have completed my skill set with a Data Analyst program including Python, PowerBI, Knime, and SQL.

I have over 5 years of experience in the banking sector, specifically in asset management.

I also possess strong skills in low-level languages like C.

I contribute to the development of open-source software such as Polars and Pandas.

My solid technical skills allow me to be autonomous and adapt easily to new technologies.

Industry field of expertise

Languages

French
Native or bilingual
English
Conversational

Workplace preferences

Can work on-site

Paris (up to 50km)

Natixis CIB
Data Engineer - SQL Server Expert
BANKING AND INSURANCE
February 2022 - August 2023 (1 year and 6 months)
Paris, France
Implementation of column indexes for data processing for decision-making purposes.
Optimization of RFQ processing (OLAP Cube) for quote management.
Support in the migration from Sybase IQ to SQL Server 2019.
Optimization of numerous Transact-SQL processes for the commercial department.
C# development of a streaming import feature for Big Data into SQL Server for centralized ETL (used by the Datawarehouse project for all incoming and outgoing flows).
Management and supervision of a new Always-On architecture with automatic routing of decision support tools to the read-only node.
Transact-SQL (T-SQL) Microsoft SQL Server C# Git XL Deploy
OSTRUM Asset Management
Data Engineer - SQL Server Expert
BANKING AND INSURANCE
March 2018 - December 2021 (3 years and 10 months)
Paris, France
SQL development of an investor asset management datamart.
Implementation of business features and data extractions for feeding other projects or dashboards.
Improvement of the share calculation and the configurable exclusion system via a GUI.
Implementation of automatic integration of funds not supported by the repository.
Optimization of SQL processes for volumes exceeding 1.5TB.
Microsoft SQL Server Asset Management
Société du Grand Paris
Technical Engineer
PUBLIC SECTOR
July 2016 - March 2018 (1 year and 8 months)
Paris, France
Mapping of application flows for all SGP projects as part of compliance with the European decree on data privacy.
Database audit, definition of best practices.
Transact-SQL development.
Implementation of SQL Server Always-On Failover clustering and high availability.
SQL Server Transact-SQL (T-SQL) GDPR Compliance

Check out Pascal's experience

Be the first to recommend Pascal

Help this freelancer shine by sharing your experience working together.

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

Baptiste Duhen

Fullstack developer

4.6

(4)

Amed Hamou

Senior Lead Developer

(2)

Audrey Champion

Web developer

4.3

(3)

Signup to reveal

Data Analyst - Professional Title Level 6
Openclassrooms
2024
Machine learning, tests statistiques, K-Means, ACP, Régression linéaire et logistique, CAH... Technologies utilisées: Python (avec Pandas, Seaborn, Streamlit), Jupyter Notebook, Knime, SQL

BI Consultant

Pascal Brochart

Data Consultant - SQL Expert

About Pascal

Experience

Recommendations

These freelancer profiles also match your criteria

Education

Skill set

Categories