David Fernández Guillén

Professor at CEU Cardenal Herrera University
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Greater Valencia Metropolitan Area, ES
Languages
  • Catalan/Valencian Native or bilingual proficiency
  • French Limited working proficiency
  • English Full professional proficiency
  • Spanish Native or bilingual proficiency
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Microsoft Certified: Azure Data Fundamentals
    Microsoft
    May, 2023
    - Oct, 2024
  • Mastering DAX Video Course
    SQLBI
    Aug, 2022
    - Oct, 2024
  • Case Study: School Budgeting with Machine Learning in Python
    DataCamp
    Dec, 2020
    - Oct, 2024
  • Cluster Analysis in Python
    DataCamp
    Dec, 2020
    - Oct, 2024
  • Data Scientist with Python Track
    DataCamp
    Dec, 2020
    - Oct, 2024
  • Machine Learning with Tree-Based Models in Python
    DataCamp
    Dec, 2020
    - Oct, 2024
  • Supervised Learning with scikit-learn
    DataCamp
    Dec, 2020
    - Oct, 2024
  • Unsupervised Learning in Python
    DataCamp
    Dec, 2020
    - Oct, 2024
  • Analyzing Police Activity with pandas
    DataCamp
    Nov, 2020
    - Oct, 2024
  • Data Analysis in Excel
    DataCamp
    Nov, 2020
    - Oct, 2024
  • Statistical Thinking in Python (Part 1)
    DataCamp
    Nov, 2020
    - Oct, 2024
  • Statistical Thinking in Python (Part 2)
    DataCamp
    Nov, 2020
    - Oct, 2024
  • Introduction to Tableau
    DataCamp
    Aug, 2020
    - Oct, 2024
  • Data Cleaning in Python
    DataCamp
    Jul, 2020
    - Oct, 2024
  • Exploratory Data Analysis in Python
    DataCamp
    Jul, 2020
    - Oct, 2024
  • Intermediate Data Visualization with Seaborn
    DataCamp
    Jul, 2020
    - Oct, 2024
  • Intermediate Importing Data in Python
    DataCamp
    Jul, 2020
    - Oct, 2024
  • Introduction to Data Visualization with Matplotlib
    DataCamp
    Jul, 2020
    - Oct, 2024
  • Introduction to Data Visualization with Seaborn
    DataCamp
    Jul, 2020
    - Oct, 2024
  • Introduction to Importing Data in Python
    DataCamp
    Jul, 2020
    - Oct, 2024
  • Python Data Science Toolbox (Part 1)
    DataCamp
    Jul, 2020
    - Oct, 2024
  • Python Data Science Toolbox (Part 2)
    DataCamp
    Jul, 2020
    - Oct, 2024
  • Working with Dates and Times in Python
    DataCamp
    Jul, 2020
    - Oct, 2024
  • Writing Functions in Python
    DataCamp
    Jul, 2020
    - Oct, 2024
  • Data Manipulation with pandas
    DataCamp
    Jun, 2020
    - Oct, 2024
  • Intermediate Python
    DataCamp
    Jun, 2020
    - Oct, 2024
  • Introduction to Python
    DataCamp
    Jun, 2020
    - Oct, 2024
  • Merging DataFrames with pandas
    DataCamp
    Jun, 2020
    - Oct, 2024

Experience

  • CEU Cardenal Herrera University
    • Spain
    • Higher Education
    • 700 & Above Employee
    • Professor
      • Nov 2022 - Present

      • Professor of the Data Analysis Workshop of the Journalism subject called Documentation and Investigation Techniques. • Teaching students how to import, manipulate, analyze and visualize data with Python in order to tell stories. • Professor of the Data Analysis Workshop of the Journalism subject called Documentation and Investigation Techniques. • Teaching students how to import, manipulate, analyze and visualize data with Python in order to tell stories.

  • Avanade
    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Data Analyst
      • Jun 2022 - Present

      • Creation of reports and dashboards after having direct contact with clients of a big Spanish corporation. • Using Power BI (DAX/Power Query), SQL (Microsoft SQL Server) and Python. • Creation of reports and dashboards after having direct contact with clients of a big Spanish corporation. • Using Power BI (DAX/Power Query), SQL (Microsoft SQL Server) and Python.

  • Impress
    • Brazil
    • Graphic Design
    • 1 - 100 Employee
    • Data Analyst
      • Mar 2022 - Jun 2022

      • Create productivity reports capturing data from CRM's (Hubspot), call centre's, commercial, customer care and medical teams, to evaluate accumulated sales and the quality of patient care, as well as conversion levels. • Using SQL (AWS Athena), Python, Apache Superset and Jira (to plan and track the projects). • Create productivity reports capturing data from CRM's (Hubspot), call centre's, commercial, customer care and medical teams, to evaluate accumulated sales and the quality of patient care, as well as conversion levels. • Using SQL (AWS Athena), Python, Apache Superset and Jira (to plan and track the projects).

  • Smart Protection
    • Morocco
    • Security and Investigations
    • Data Analyst
      • Oct 2021 - Mar 2022

      • Main point of contact for data queries (SQL (AWS Athena)) in marketing, market research and customer success departments, working cross-functionally to help others access and understand the data efficiently. • Create advanced automated dashboards in Power BI (DAX/Power Query) to measure the performance of marketing campaigns with data from CRM’s (Salesforce). • Proactively implemented a new third party tool (Datadoo) to gather multiple data sources in one central place. Now, the team has a centralized and unique source of truth - and the whole data ingestion pipeline is automated, increasing speed and avoiding human errors manipulating csvs. • My analysis helped to renew contracts with clients and increased revenue for the company. • My work was key in creating a new product called Social Listening. Our clients would be able to measure their products' presence in social networks. I proactively created a report using python that brought a new big client on board. Show less

    • Junior Data Analyst
      • Dec 2020 - Oct 2021

      • Winner of a company internal competition where I analyzed data from a big Spanish corporation. • Used python to analyse the Google Transparency Report (database published by Google containing copyright information). The dataset was very big and messy. I gathered requirements from business stakeholders and created a user friendly dashboard with Plotly Dash. The CEO of the company praised this work and found it very useful. • I reduced the company's costs by using a cheaper approach to collect Web Domain traffic data by using Amazon's Alexa API rather than other expensive third party solutions. Show less

  • Paterna Football Club
    • Communications Lead
      • Dec 2019 - May 2020

      Paterna FC is a Spanish Club in the third division league. • Despite being a small team on a limited budget, I planned and executed a professional communication strategy that achieved very good results. Paterna FC is a Spanish Club in the third division league. • Despite being a small team on a limited budget, I planned and executed a professional communication strategy that achieved very good results.

  • Radio Intereconomía
    • Spain
    • Broadcast Media Production and Distribution
    • 100 - 200 Employee
    • Talk Show Guest
      • May 2017 - Feb 2020

      Live speech on a sports radio show. • I gained fluency and confidence broadcasting. Live speech on a sports radio show. • I gained fluency and confidence broadcasting.

  • À Punt Mèdia
    • Spain
    • Broadcast Media Production and Distribution
    • 200 - 300 Employee
    • Internship reporter, writer and video editor
      • Jul 2019 - Aug 2019

      À Punt Mèdia is a Spanish public TV and Radio channel. • I learned to work against the clock, to be selective choosing images and to be concise writing texts. À Punt Mèdia is a Spanish public TV and Radio channel. • I learned to work against the clock, to be selective choosing images and to be concise writing texts.

  • CV Radio 94.5 FM
    • Internship broadcaster
      • Oct 2018 - Mar 2019

      Live speech in a sports radio show and interviewing at press conferences. • I gained agility and confidence in front of the microphone. Live speech in a sports radio show and interviewing at press conferences. • I gained agility and confidence in front of the microphone.

  • Superdeporte Empresa Editorial, S.A.
    • Internship writer
      • Jul 2017 - Jul 2017

      Superdeporte is a famous Sport Newspaper. • I wrote in the Soccer section and I learned to work against the clock and in a team with the different people of the editorial department. Superdeporte is a famous Sport Newspaper. • I wrote in the Soccer section and I learned to work against the clock and in a team with the different people of the editorial department.

  • Technical Committee of Referees of the Football Federation of the Valencian Community
    • Football referee
      • Sep 2011 - Jun 2013

      • It brought me maturity and knowledge of the society that is part of the grassroots football. • It brought me maturity and knowledge of the society that is part of the grassroots football.

Education

  • Universidad CEU Cardenal Herrera
    Journalism
    2016 - 2020
  • Saturdays.AI
    Machine Learning Program
    2021 - 2021
  • DataCamp.com
    Data Scientist with Python Career Track
    2020 - 2020
  • Pureza de María - Avda. del Cid
    Science Baccalaureate
    2011 - 2013
  • Valencia Music Conservatoire
    3 years Piano
    2003 - 2006

Community

You need to have a working account to view this content. Click here to join now