Hi, I'm Oscar De Alva đź‘‹

I'm a BI and Backend Software Engineer

About

Portfolio

Resume

Contact me

HOME / RESUME

RESUME

Skills

Programming Languages

  • Scala
  • JavaScript ES6
  • Java 8
  • Python 3

Cloud Computing

  • AWS Lambda
  • AWS S3
  • Heroku

Backend Development

  • Spring Boot
  • Node.js
  • Express.js
  • Http4s
  • Cask

Databases

  • PostgreSQL
  • AWS DynamoDB

Frontend Development

  • HTML 5
  • CSS
  • Hugo
  • JQuery
  • Pug

Project Management

  • Git
  • Github
  • BitBucket
  • Trello
  • Asana

Experience

Enroute Systems

BI Engineer

October 2020 - Present

Lead engineer for the migration of a Java Spring backend to Looker for the creation of different reports. Cooperated with UI/UX teams to create different dashboards within Looker for the company’s clients. Empowered different teams to use Looker for their own reporting needs through documentation, courses, knowledge transfers, and shared-service work.

  • Use of Looker’s LookML language to model the Snowflake database.
  • Helped with the development of a Java Spring application to test Looker’s API endpoint and compare its data with Production environment, to ensure data correctness during the migration process.

NUBIX

Junior Developer

August 2019 - May 2020

Maintenance of the company’s main platform, mainly bug fixing and improvement of code’s quality. Implementation of new functionalities for the main platform and different services. Mainly coded in JavaScript ES6, using Node.JS, both locally and at AWS Lambda.

  • Developed a GCP Function in Python for the classification and storage, in AirTable, of mastography results the moment they were interpreted and uploaded to the main platform.
  • Developed a small Scala application to add climate and geolocation information to patients’ interpretations. Using Google Maps Elevation and Geocoding APIs, and Dark Sky API. Developed as a preprocessing step that lead to Data Science analysis, processing around 40,000 patients.

NUBIX

Internship

QA Engineer

May 2019 - July 2019

Comprenhensive analysis of the main platform code’s quality considering various points of view, such as security analysis.

  • Around 50 minor vulnerabiities detected.
  • Reduced around 300 lines of code of the mains service.
  • Usage of RetireJS, AuditJS, ESLint configured with StandardJS, and ShellCheck.

Education

Universidad de las Américas Puebla

August 2016 - May 2020

B.S. Computer Systems Engineering

  • Secretary, Computer System’s Student board. (August 2018 - May 2019)

    • Organized 4 sessions that were aimed towards competitive programming, where 15 students attended on average.
    • Helped organizing a Welcoming Party for new students of the major, being on charge of selling tickets and organizing the area. On average, 210 students attended.
    • Was in charge of organizing important documents for the student board, like calendars and memories.
    • Organized meetings with the members of the student board and making minutes.

  • Participant, Hackathon BBVA 2019. (September 2019)

    • Developed a basic blockchain with Ethereum, using Go, in order for banking transactions to be under a blockchain.
    • Only a small prototype was developed.
    • Collaborated with a senior developer and a UX designer.
    • Project developed for the Accenture Challenge.

  • Participant, Hackathon BBVA 2018. (September 2018)

    • Developed a mobile application, using Java, which goal was to help small and medium sized stores manage their sales and inventory within their smartphones.
    • Collaborated within a group of 6 people of different backgrounds, such as Industrial Design and Marketing.
    • Project developed for the Reader Challenge.

  • Participant, Hackathon 3.0 Puebla. (April 2018)

    • Developed a Java application that searches through Twitter and identifies possible costumers for a bank insurance from BBVA.
    • Outputs both a CSV and a Txt file with the username of the person, the tweet and the location of it, both the place and the coordinates.
    • Collaborated within a group of 4 people, all developers.
    • Project developed for the CRM Challenge from BBVA Bancomer.