Loading...

Hello & Welcome

I Am

About Me

"What we know it's just a blob, what we don't know is an ocean”

Hi there, I'm

  • Software Engineer
  • Tech Enthusiast
  • Videogames Lover
  • Travel Addict

I am a computer science engineer based in Barcelona, currently working as a data engineer. I like to spend some of my free time developing other things such: web, mobile, automation using IoT... Feel free to see my page where you'll find some of my work and personal experiences and don't hesitate to contact me if you think I can help you!

And remember... the cake is a lie!

GCP
Proficient
Terraform
Proficient
BigQuery
Proficient
Airflow
Proficient
Python
Proficient
3rd Party Data Ingestion / REST APIs
Familiar
AWS
Familiar
Jenkins
Familiar
BI (Looker)
Average
Streaming Data
Average

Skill Set

Those are the areas I'm more familiar with, for my work experience.

Big Data

With over 250+ million monthly active users and 50 billion events being uploaded daily, it’s key that you care about writing highly optimized code and ETLs

Batch Processing

Working mainly with ETLs to process data on a hourly, daily, weekly and monthly basis. Worked on a semi-realtime processing ETL(<3 min) in my previous company with an in-house solution (Python + Redis consumers).

SQL and Python

Currently mainly working in Python and SQL languages. Previous experience with PHP and Symfony.

Cloud Services

Currently working on GCP with services such as Big Query, PubSub, Storage, Cloud Functions and Compute Engine. Previous experience with AWS.

Airflow

Using Apache Airflow 2.X as workflow management platform, migrated from a Jenkins infrastructure. Previous experience with Azkaban.

Infrastructure as Code

Experience with Docker as container and Terraform for infrastructure provisioning.

Companies

201

Working Years

Working Hours

Average Month Stay

Education & Experience

"Experience is something you always think you have until you get more of it"

March 2021 - Present

Senior Data Engineer

Promoted to senior data engineer with same responsibilities plus:

  • Lead some projects from the definition to the delivery
  • Contact point with 3rd parties both for new integrations and maintenance
  • Close contact with the client (usually other king departments such as finance, data scientist, game business, etc.)
  • Execution of some PoC to test some tech and new projects
  • Close contact with the PO and PM to deliver products aligned to company objectives
  • Technical debt
December 2018 - March 2021 (2 years and 3 months)

Data Engineer

Joined core data products team, responsible for delivering top data models, tools, and products across different games and business teams at King.
I wanted to grow and try a very different tech stack:

  • GCP as cloud provider
  • Docker containers
  • Terraform as orchestrator
  • Terraform as orchestrator
  • Solid event ingestion
  • Airflow (and subsequently 2.0) ETL management
August 2018 - November 2018 (4 months)

Marketing-Analytics Product Manager

Traditionally, sync between marketing needs and data engineering deliveries was hard, so we embedded a small team inside marketing to do so.
I Had the opportunity to try a completely different path in my career, being the manager of this new department:

  • Be the owner of the analytic work inside marketing
  • Introduce agile (scrum) methodologies
  • Manage 1/2 data analyst to get things done
  • Do unplanned work (analysis and some maintenance)
  • Be the owner of marketing BI tool: QlikView
March 2014 - August 2018 (4 years and 5 months)

Data Engineer

Worked in "datalab" team: a data engineering team responsible for the data ingestion, KPI creation, and maintenance of the BI tool of the company.

  • All processes were in-house: from the RT consumers to the BI tool
  • Maintenance of semi-rt ETL (in Redis with Python), hourly and Daily ETLs (in Redshift with PHP)
  • Maintenance of aggregation process from raw events to summary tables (hourly updated)
  • AWS as cloud provider
  • ETLs scheduled with crontab. Migrated to Azkaban later on.
  • Ingestion of 3rd party data
March 2013 - March 2014 (1 year)

Data Analyst Developer Intern

Joined as an intern on a project to document the main database of the company. Instead of spending hours doing it manually, I developed a bot to extract the schema and metadata from the database and write all this info structured in a Google Sheet. Later on, joined as a developer of the team being able to:

  • Learn the fundamental of the big data environment
  • Understand the gaming industry and more precisely how the free to play industry works
  • Automate manual processes
  • Improve knowledge on relational and no relational databases
  • Basic KPIs needed for a successful game
June 2012 - February 2013 (9 months)

Software Developer Internship

Everis Spain
Development of an open-source solution for the management and deploy of multiple hosts (servers and clients) on the same infrastructure.

2007 - 2013

Do you have an interesting opportunity?

Let's talk!

Portfolio

Projects I developed along the way as freelance or on spare moments.

image

I developed my wedding website where the guests could have all the info about our history, information about the event and the venue, see some pictures about our adventures and confirm assistance:

  • All using GCP services
  • Able to send mail to my wife and myself every time a guest confirmed assistance
  • Keep it simple in only one page

Website Code
image

'Joventut Nacionalista de Catalunya' is the first youth political organization in the country. Founded in 1980, working for a just and noble cause, freedom of Catalonia and its people.
I collaborated on an iOS app that displayed all the information about the organization: News, agenda, ideas and direct contact with the people in it.
More precisely I made the backend part of the app:

  • Ruby on Rails
  • Admin panel to send notifications to the users
  • REST Api to enable all the endpoints for the ios client
  • The notifications system itself using Amazon web services and SNS

Code
image

I collaborated on a pioneer smart city project to detect in real-time the state of public parking.
This project was the first one of his own, allowing the public agents to know the cars that exceed parking time.
My contributions to the project were:

  • PHP + Symfony as main tech stack
  • Backend of the app: database to store all the events, admin panel and RESTFul API
  • Frontend of the webapp, using technologies such Bootstrap, Symphony 2, Jquery, etc.
  • Support endpoint for the iOS app to allow public agents to access more easily the information that they need
image

Using the standard basic technologies (CSS, JS, HTML, etc.) and with the help of boostrap, JQuery, some JS libraries and an HTML template I did my old personal web page!

image

Web app tool for easily deploy and manage changes on multiple machines.
I worked on an open-source solution for the management and deployment of multiple hosts (servers and clients) on the same infrastructure.
The objective was to make a tool to easily deploy changes in multiple machines with a web App tool.

  • Implementation of version control with git
  • Added some standards: until then only coded via vim in a server machine
  • Open-source project
image

PopKorn is the perfect companion for people who love TV shows. It is a great tool to find shows, as it has a database of over 2000 American, British and Spanish shows.
You can search through them either alphabetically or you can have them sorted by genre. You can also very easily check out a certain show's plot, season and episode list, etc.
Some reviews:

Get In Touch

Connect

LinkedIn

Based in Barcelona

2021 © Antar Moratona Franco. Design by ThemesBoss.