Idelfonso Gutierrez

Dedicated software developer

Work

Side-projects

Mobile Applications

Social interaction is a human need

YES! It’s something we get excited for and even further when we meet, travel or try something new. People can connect with each other despite the different languages, origins, cultures.

The Problem

Context

The Solution

Create a connection with a new person using a feature from the cultures in general

Stranded

  Airport Code:
  Gate:
  Terminal:
  Estimated Time of Departure:
  How you look like:

The rest is HX, human experience! 💆‍♀️💆‍♂️

tech: Combine, SwiftUI, APNS, database

status: development

Pitch

But most importantly! How happy… or how stress are you? ⛱ 🤯

The ability to keep learning is an invaluable skill

The Solution

mmMapp link your calendar with your social media accounts and have mmMapp shows you the events in a sequence with stopping points, happy routes to take, human experience taking int consideration.

YellowPepper Talks

Introduction to Firebase Database, IAM, and backend for the front end developers.

I talked about how to start with Firebase, Realtime Database, and its rules. Also about Storage Database and it rules

Along with it, I developed a small sample iOS project using Swift to send text and image nodes, how they are shown in the firebase console, and which methods I use to retrieve them in the client

tech: Swift, UIKit, AutoLayout, Firebase Realtime DB

GitHub

Tubmlr Client

Created an iOS client in order to search blog users in Tumblr, follow users, and post text blogs.

tech: Tumblr API, UIKit

GitHub

On the Map

“On The Map” app allows users to share their location and a URL with their fellow students

tech: MapKit, Parse, Udacity API

GitHub

Virtual Tourist

Wondering what kind of pictures have people taken in a particular place around the world?

Think about Virtual Tourist before Instagram search feature using Flicker

tech Flicker API, MapkKit, UIKit

GitHub

back to menu

Databases

Data Pipelines with Apache Airflow

When data analysts and data scientists use data, they rely that is accurate and diverse enough in order to come up with these amazing models that help drive business decisions. Data comes from many places and from different times; a system could start collecting data tomorrow or it was already started 20 years ago; Imagine that 😅

DAG

This project showcases how to design and schedule a series of jobs/steps using Apache Airflow with the following purposes

DAG

Github This project was completed under the Data Engineer Udacity Nanodegree link

tech: AWS Redshift, Python, Apache Airflow, Docker

Data Lakes 🚤 with Apache Spark + EMR Cluster

You can take a trip to a polluted lake or a clean lake and how the water looks, tastes, or where it comes from matters.

Data lakes is a new analogy to what Data Warehouse was till not too long ago. We are still using the same hardware for Data lakes, but with new tools which makes possible to cover more ground.

In my previous project STAR vs 3NF 🥊 SCHEMA I prepared the data to be ready for use by BI applications with the OLAP cubes. It’s a structure that has been validated and vetted through several implementations and successful cases. When I learned about Data lakes: the tools, the language, Serverless (Python, learning Scala) I felt that I save a bit of automation by looking into it.

Don’t get me wrong, like any other technology it’s flexible, there are pros and cons, budget, analysis of your workload, and team work.

Data is the new oil 🛢

As I mention, automation, but not really. Instead of creating tables and doing the ETL dance, lets do the ELT 💃 dance.

Big Data frameworks like Spark focuses on what, where, and how to what Hadoop couldn’t

df = spark.read.csv('s3a://.../file.csv', sep=';', inferSchema=True, header=True)
df.createTempView("log_data")
user_table = df.spark.sql("""
                        SELECT user_id as id', 'year(ts) as year
                        FROM log_data
                        """)
user_table.show(1)
user_table.write.parquet('users', partittionBy='year')

Jupyter Notebook

We will perform our transformation and have them save in S3 for which our BI apps could connect to or we could attached to the cluster, but they are expensive 💰. S3 it’s cheap and it doesn’t get shutdown.

Another step is the Schema-on-read for this process to be possible, and if you noticed there is a lot of steps.

Github

This project was completed under the Data Engineer Udacity Nanodegree link

tech: AWS EMR (Spark+HDFS), Python, Notebooks

Data Warehouse with AWS Redshift

Why would we want to use re-create our table structures for Analytical Procedures?

It happens that performance is much better, we can do fewer joins and access the same information. We still would like to have our 3NF schema for application purposes on the side, think about it like a separate microservice. Besides re-creating our tables, these can be improve… by a lot more with the following!

In the first point, I’m talking about creating an ETL process to load this data, but of course there is some setup that needs to be done

There is an overcrossing between Infra DevOps 🛠 and Data Engineers 💾

For this project I utilize AWS web services like redshift, s3 storage buckets, user roles, policies, and cloud watch

The idea is how can we prepare data to be use by Business Intelligence applications Tableu or even Jupyternotebook! 👍 In order to help the business see an overview of the data in a diagram of what important features of the product their customers might be using. Mainly, how can we improve the performance of these OLAP and OLTP transactions? For that, we use the combination of star schema tables, we build a strategy for a distributed data system, and do grouping for all the features thanks to REDSHIFT.

Jupyter Notebook

This project was completed under the Data Engineer Udacity Nanodegree link

tech: AWS services*, Python, Jupyter

Creating an ETL process with Apache Cassandra

Handling BIG DATA and storage now a days is no just feasible, it’s a must.

import pandas
import cassandra

Losing customer it’s not an option. Today in the world we have a ton of devices that are gathering and sending data. The benefit of using a document store database #NoSQL, is that developers don’t need to maintain and/or adjust entities, migrations and changes on existing products. Companies and product moves in an agile environment, where requirements are constantly changing; NoSQL allows us to spin these requirements in a quick manner.

The Business Case 💼

The following application establishes the following case where we have deploy a music app and its collecting data which it’s the store to a local text file. From that we known which songs does the user listens to and which membership they are on (at a higher level).

// "Some of the largest production deployments include Apple's, with over 75,000 nodes storing over 10 PB of data, Netflix (2,500 nodes, 420 TB, over 1 trillion requests per day), Chinese search engine Easou (270 nodes, 300 TB, over 800 million requests per day), and eBay (over 100 nodes, 250 TB)." https://cassandra.apache.org/

My job was to extract transform and load this data into the system where business teams could bring their requirements and collect solutions from the data.

🔗 Jupyter Notebook ETL Process

Github

tech: Apache Cassandra, Python, Pandas

This project was completed under the Data Engineer Udacity Nanodegree link

Data Modeling with PostgreSQL

cur.execute("DROP DATABASE IF EXISTS ...")

Executing the basic CRUD commands is nothing new when it comes to building a system. A well-thought system it’s very agnostic, and concepts are transferable within different lower level products. Some of the most popular RDBMS involve PostgreSQL, OracleSQL, MySQL. But where does the data comes from? How often does the data change? How many files do we have, and how often we get new ones? Can we blame IoT 🛰 devices?

To the infinity and beyond… - Buzz Lightyear 1995

In the following application are given directory paths of where the client-side system is storing data files based on a music application product. I analyzed the data, build its entities and form the basic link between them. The analytics team is particularly interested in understanding what songs users are listening to

Github

This project was completed under the Data Engineer Udacity Nanodegree link

tech: PostgreSQL, Python, Pandas

Hero World

Creating a test case for a new park for The Walt Disney Company in order to track schedules and budgeting for the construction of all the projects.

Our dev team was able to implement a database using normalization, which helps identifies the identities inside the projects. We developed a process of Table Creation, Views, Stored Procedures, Triggers. During the project we learned how the activity relates to a project, how a project can have many employees, and how a firm can own many employees. This is done using the concept of a relational database.

tech: MySQL*

GitHub

back to menu

Miscellaneous

Lambdas in Swift

Many iOS developers don’t realize at the beginning that they are actually using a programming language with Functional Paradigm and Principles. The Swift language became really popular thanks to iOS applications. Today, the language does not only help builds applications across an array of customer-facing hardware (iOS, WatchOS, iPadOS, CarPlay) but also enterprise-level and research level as of backend applications and machine learning models respectively. Most recently I saw a microcontroller dev kit for people to start building projects that exist with Raspberry Pi but with Swift and it’s own IDE

“a prototype is worth 1000 meetings”

Many people say: “well…. its just a Hello World program” or “it lacks the vote from an enterprise point of view” To them I must say there is not an official council who approves or disapproves what technology lives up to the standards. And newer technology aims to address the issues and lack of current technology, how far we can push it, it’s only up to us; developers to run with it an see what we like.

Thank you Fabbian Fett for given us Swift AWS Lambda

Getting started with Swift on AWS Lambda

GitHub

Writing BDD + TDD in my current projects

No method is more effective than a good example. - Ingvar Kamprad, IKEA Founder

The Problem

A developer could write the following below. But this is missing some context, and only developers could! be able to understand what is the system is doing.

func testSystem_whenReset_isInStarted() {
 sut.setToInProgress()

 sut.restart()

 XCTAssertEqual(sut.state, .blank)
}

A different approach: Give me an example

Given the application is "in progress"
When a user "restarts" the application
Then the application will set to "default"

func Given("the application is [regex]") { state in
 sut.set(state)
}

func When("a user [regex] the application") { action in
 sut.perform(action)
}

func Then("the application will set to [regex]") { expected in
 XCTAssertEqual(expected, sut.state)
}

The result out of it is that developers can make a set of reusable tests and stakeholders, product owners, QA tester can expand the tests into every state of the system.

Developers only need to keep following their TDD approach.

Electronic Business Cards

The Problem:

On a rush??

Do you have an Instagram account or…. a business card? it probably has a cool design 📇

Maybe Instagram is not your medium

Got it. Give me your whatsapp… -me: Is that the new customer management system/.com? It might be…

The Solution:

Note: also use “Share sheet” to send it using AirDrop, not too many users allow airdrop from everyone

tech: Siri shortcut

back to menu

Experience

Enterprise Mobility Developer | Ulta Beauty | Chicago, U.S. | Feb. 2020 - Present

iOS Software Developer | GrowIt! | Chicago, U.S. | Feb. 2018 - Feb. 2020

tools/frameworks/libraries:

Tags: horticulture

Technical Analyst iOS Mobile Developer | KIN+KARTA | Chicago, U.S. | Sept 2017 - Feb 2018

tools/frameworks/libraries:

tags: agriculture

Intern iOS Mobile Developer | YellowPepper | Miami, U.S. | Nov 2016 - May 2017

tools/frameworks/libraries:

tags: financial technology

Clients

Ally’s Flower

Online retail flower shop. The client wanted an easy-to-use platform to manage inventory and customer relationship manager.

www.allysflower.com

Proendoscopy

Proendoscopy is a local company in the city of Sunrise, it specializes in the service and repair of medical equipment, mainly endoscopes.

Inventory management iOS application:

tech: iOS: Objective-C, CoreData, UIKit

www.proendoscopy.com

About Me

Lección para tu vida

que bueno 🤣🙌🏾 Actitud | Victor Küppers | TEDxAndorralaVella https://t.co/orerUgfhpo via @YouTube

— Idelfonso (@idelfonsoGM) November 22, 2019

Education

Coding Mentor | Volunteering | CoderDojo | Miami, U.S. | Dec 2014 - May 2016

CoderDojo is a non-profit organization aimed to teach introductory coding-skills concepts through hands-on learning for students between 4th grade and 8th grade.

As a mentor, you will have a transformative experience by being able to teach and spark joy among the students.

Lessons objectives included working with scratch.mit.edu in order to demonstrate the following:

Additionally, students are encourage to:

IT Intern Developer | Martin Digital Group | Miami, U.S. | Jan 2014 - April 2015`

Tags: online marketing

Java II Learning Assistant | Florida International University CIS Department | Miami, U.S. | Dec 2015 - May 2016

tags: education

From Venezuela 🇻🇪

Vamos a bailar 💃

Photograph by Charapin 🙌🏾

Charapin

2020, Github Pages