Freelancer profile translated to English.
Back to original languageAbout Laetitia
I have 6 years of experience in the data field, I have worked on the different stages of a data project and I master the data creation and management part as well as the data visualization and analysis part. I have worked on the technical side as well as the functional side, I have often been in direct contact with the business.
I mainly work on the following technologies:
-SQL (PostgreSQL, SQL Server)
-Python
-ETL (Talend)
-Data Visualization (Power BI)
I am available for long and short term assignments.
French
Native or bilingual
English
Fluent
Spanish
Conversational
Can work on-site
Paris (up to 15km)
Experience
- TotalEnergiesData AnalystENERGY AND UTILITIESJanuary 2023 - Today (3 years and 5 months)
- SenettisSQL / Java DeveloperDIGITAL AND ITMarch 2022 - September 2022 (6 months)Context:Senettis is a small cleaning company that had no system for managing its data. The project therefore consisted of implementing a database and a User application to add or modify elements in the database. The goal was to store all company information (employees, projects, expenses, etc.) and to calculate the profitability of each project.Achievements:*Definition of user needs*:• Needs gathering• Needs analysis and prioritization*Database Creation*:• Database modeling• Database implementation (SQL Server)*Adding data to the Database (Talend)*:• Retrieval of existing data (Excel)• Data cleanup• Addition to the database*User Application Development (Java)*:• Creation of Employee and Project Modules to store/modify/delete employees and projects• Creation of Supply, Equipment, and Product Modules to store/modify/delete products and equipment used• Creation of the Assignment Module to assign an employee to a project occasionally or for a given period• Creation of the Delivery Module to group products and equipment delivered to each project• Creation of Turnover and Profitability Modules to easily view and analyze figures per project to identify potential problems*Monitoring and fixes*:• User training• Potential fixesResults:• Data centralization: simplified management, improved data quality and security• Automated monitoring and alerts (e.g., salary modification based on seniority, change of necessary equipment)• Automation of the financial indicator calculation process (e.g., turnover calculation, project profitability calculation to check if projects are profitable and identify the most and least profitable ones)Technological stack and tools used:• Versioning:Git• Database:SQL Server, Talend• Data visualization:Power BI• Development:Java
- ColasBusiness Intelligence ConsultantCIVIL ENGINEERINGDecember 2020 - February 2022 (1 year and 3 months)Vélizy-Villacoublay, France**Context**:At Colas DS, I joined the team responsible for Finance reporting. Our goal was to manage all reports related to COLAS financial data, from database construction to user training on visualization tools.**Achievements**:*Creation of a new data cube*:• Needs gathering• Needs analysis and prioritization• Modeling of dimensions and fact tables• Table creation(SQL Server)• Testing and corrections*Creation of aPower BIreport based on cube data*:• Needs gathering• Needs analysis and prioritization• Creation of a first version of the report(Power BI, DAX)• User workshops: Visual modifications• Final report construction(Power BI, DAX)• Deployment and user communication*Creation of aPower BIreport based on files*:• Needs gathering• Needs analysis and prioritization• Creation of a first version of the report(Power BI, Python script to format data correctly from the file, DAX)• User workshops: Visual modifications• Final report construction(Power BI, Python, DAX)• Deployment and user communication*Evolution of data or visuals*:• Needs gathering• Modeling of dimensions and/or fact tables to add• Table creation (SQL Server)• Testing and corrections• PBI visual modifications (Python, DAX)• Deployment and user communication**Results**:• Quick identification of late invoices and blocking points in processing thanks to the creation of a report to track invoice payment progress• Monitoring of the company's agencies' Turnover, Revenue, and Expenses• Easier identification of data entry anomalies thanks to the creation of a report• Consolidation of data to eliminate diverse sources for similar data**Technological stack and tools used**:• Project Management:Azure Devops• Database:SQL Server• Data visualization:Power BI• Development:Python, DAX
Reviews
Recommendations
Be the first to recommend Laetitia
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
- Master MIAGE apprenticeshipDauphine
- Bachelor MIAGE apprenticeshipDauphine