Skive FAMEUX

Background: In order to facilitate the work of bank advisors, SCIAM decided to offer an email POC to its banking customers.

Scope of Work:
- Implementation of a scraping script to extract FAQ pages from bank websites.
- Creation of PDF files from the extracted data to feed the LLMS model.
- Testing of the application developed with Streamlit to ensure its smooth operation.
Technical environment: Streamlit, Python, OpenAI API, Selenium

Background: I joined another data analyst team at Catalina, setting up a data platform to centralize all the company's data. I helped set up the UAT and Prod environments.

Project 2: Setting up a data platform to facilitate analysts' work

Team: 2 Managers, 1 lead Data, 3 Data Engineer

Scope Of Work :
- Ensure data quality via configuration files
- Implementation of a DBT chain to ensure a high-performance data catalog and data lineage
- Code in Python elements of the orchestration to manage the execution of the data transformation chain.
- Schedule regular execution of these processes using cron jobs.

Technical Environement :
Python, DBT Core, Kubernetes, Bitbucket, SQL, SnowFlake
Methodology: Agile Scrum

Background: Catalina Marketing is a company in charge of managing all the discount vouchers customers can obtain when shopping at the checkout. My mission was to migrate SAS code to Python while optimizing SQL queries.

Team: 1 Manager, 5 Developers, 1 Tech Lead, 7 Analysts

Project 1: SAS to Python migration project


Scope Of Work :
- Migration of fifteen SAS scripts to Python to ensure an efficient transition.
- In-depth understanding of existing scripts and user requirements.
- Use of pandas for efficient data formatting.
- Collaboration in Peer Programming for in-depth code review.
- Optimization of SQL queries to improve performance.
- Performed data transformations in accordance with requirements.
- Correction of bugs identified during the process.
- Source code management with Bitbucket for effective version control.

Technical Environement:
Python (Pandas, Numpy), SQL, SnowFlake, YellowBrick, Git Bitbucket, Windows, linux, Excel, Visual Studio code
Methodology: Agile scrum

Background: As part of my second work-study program, I joined Leadeal Marketing, a company specializing in marketing and data processing with several POs and Data Developers. This experience enabled me to strengthen my SQL skills and broaden my knowledge of data processing.

Scope OF Work:
- Efficient cleansing of raw data using Python and Spark.
- Realization of data transformations to meet specific needs.
- Creation of an SSIS package to facilitate data integration.
- Successfully fed the Data Lake and database to ensure data availability.

Technical environement:
IN-HOUSE ETL, SPARK, SQL, DATA LAKE, DATAMART, GITLAB, ZEPPELIN, SQL SERVER
Methodology: Agile Scrum

Background: My first work-study placement was with IMX France, a company specializing in international parcel delivery. During this period, I developed in-depth skills in Python programming, in both version 2 and version 3.

Scope Of Work:
- Development of intuitive user interfaces.
- Business layer implementation with support for Python 2 and 3.
- Production launch of developed applications.
- Identification and proactive correction of bugs.
- Created scripts for package tracking using web scraping.
- Continuous addition of new features to enhance applications.
- Efficient data retrieval via external APIs.
- Designed and developed an integrated scanning application (IDM).

Technical environment:
Front-End: Bootstrap, HTML, CSS, JS
Backend: Python 2 & 3, Postman, API Rest, Beautiful Soup, HTML, CSS, Selenium, PostgreSQL, SQLITE
Methodology: V-cycle