Idelfonso Gutierrez

👨🏻‍💻Software Developer

From Venezuela 🇻🇪 in Chicago, IL 🗣 Spanish/English been developing, testing, publishing and leading mobile applications for the Apple platforms. Developed a couple projects involving Internet of Things devices.

The ability to keep learning is an invaluable skill.

Menú ☕️

Mobile Applications

Stranded

Background:

ORD 🛫 MAD 🛬 _ETD 14:00 _

Waiting for your flight? How to start a conversation with someone? Maybe a dance… In order to dance you only need a smile and good energy Math ➗ is international known. Music 🎼 is international heard. Dance, sculpture, literature, design, cuisine are different forms of expressions denoted as Arts which are internally perform.

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 Solution:

Stranded 🙂 brings people together at international places (airports) in different time zones! Allowing them to discover something new and exciting… and possibly a new friend.

tech: Combine, SwiftUI, APNS, database


mmMapp

Pitch:

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

The Solution: Coming soon


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

Non-Columnar Storage, DIST Style, DIST Keys 🔑 and AWS REDSHIFT

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 like Tableu, S4 MIM, 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 this OLAP and OLTP transactions.

For that, we use the combination of star schema tables, we build an strategy for a distributed data system, and do grouping for all the features thanks to REDSHIFT.

Github

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


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 changes? 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

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

Writing BDD + TDD in my current projects. (Open-source software)

Behavior-driven development (BDD), Test-driven-development (TDD)

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

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.


Display vCard

The Problem:

Do you have a business card? it probably has a cool design 📇

They are useful when you need to leave in a rush

There is an individual in the middle, or “man in the middle”

manual work is prompt to error

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

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 | Solstice Consulting | 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


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


Clients

Ally's Flower

Using WordPress and Woocommerce was able to create a simple solution for a small business.

The owner was so glad that she didn’t need the help of a tech-savvy person and that it could easily integrate with the power of Square (POS)

tech: WordPress, CRM, POS

www.allysflower.com


Proendoscopy

Created an iOS app to manage a database of items. Pros the effectiveness of adding a new item to the device database and reducing the time up to 97.5%.

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

Our dev team was able to quickly identify the main problem in their workflow and inefficiency of procedures in the sales department

tech: iOS: Objective-C, CoreData, UIKit


Education

Volunteer

Instructor | CoderDojo | Miami, U.S. | Dec 2014 - May 2016

tags: education

Tech stack

Frameworks

Contact Information

📨 idelfonsog2@gmail.com

📞 +1 954 513 9568

💼 Github

📠 @idelfonsoGM

💾 Save Contact as …

Hobbies

Reads

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

— Idelfonso (@idelfonsoGM) November 22, 2019

Tango

Photograph by Charapin 🙌🏾

Charapin