About Xavier
Catalan
Native or bilingual
English
Fluent
Spanish
Native or bilingual
Experience
- Editorial Vicens VivesData Scientist and Data AnalystEDUCATION AND E-LEARNINGSeptember 2020 - January 2024 (3 years and 4 months)Barcelona, SpainAfter the company's data integration project, I took charge of initiating data science and data analysis projects.My responsibility is to address the needs of the different company departments in terms of analysis and data science.Featured Projects:
- Modeling the probability distribution of student grades based on parameter estimation of a beta distribution. Prediction and updating using Bayesian statistics.
- Classification and segmentation of schools to optimize sales visits using decision trees, clustering, and linear classifiers. Results are presented in dashboards with Plotly.
- Estimation of the contribution of digital products to the sale of physical products based on statistical analysis of cross-variables.
- Using R libraries googlesheets4 and gargle to read and write data, create and manage files in Google Drive as a method for data exchange with any company department.
- Predictive model of traffic volume on our servers due to the change generated by the pandemic.
- Integration with QlikSense working with a vendor.
- Editorial Vicens VivesR developer and Data EngineerEDUCATION AND E-LEARNINGJune 2019 - July 2020 (1 year and 1 month)Barcelona, SpainThe main purpose of this role was to lay the groundwork for the start of BI and data science operations in the company. The choice of my profile was essentially due to two reasons. The first is my knowledge of most of the company's departments and workflows from having collaborated with them on previous projects. The second is my technical knowledge (SQL, systems, etc.) and R language to carry out the task.The main projects I developed are:
- Unifying the relational databases of all departments into a single physical system.
- Implementing the API of the Force Manager sales management application in R to obtain the necessary data for nightly batch processes.
- Creating an abstraction layer in R above the databases that allows access to multiple sets of interest, including many cross-queries.
- Defining a series of nightly batch processes that use this abstraction layer to build redundant, denormalized datasets, and then save them in Apache Parquet format for later agile querying. I use the Apache Arrow library to interact with Parquet.
- Finally, I define a series of business queries on the Parquet data lake to feed the first BI and data science projects.
- In parallel, I started working on transferring the same queries on the data lake to Python language using PyArrow, although at that time the library was in its very early stages.
- Editorial Vicens VivesProject Manager and Agile CoachNovember 2014 - May 2019 (4 years and 6 months)Barcelona, SpainDirector of projects for the digital department, specializing in Kanban as an Agile coach for the department's four squads for the last two years.Helping to define the department's strategy, ensuring the correct definition of projects to guarantee their viability by working with IT and product managers, developing the roadmap for each project by working with development teams, tracking projects to adjust their forecasts and dedication, ensuring correct coordination between people and teams, administering the task management system (Jira), training squads in Agile and Kanban methodology, assisting teams in following the methodology, monitoring team performance to make delivery forecasts based on performance rather than promises.
Recommendations
Be the first to recommend Xavier
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
- MicroMasters Program in Statistics and Data Science (SDS)MITx MicroMasters® ProgramsMITx MicroMasters Program
- Master's in Computer EngineeringUOCMáster oficial EEES
Certifications
- IDS.S24x: Learning Time Series with InterventionsMITx MicroMasters® Programs2024
- The Machine Learning Pipeline on AWSIT institute2023