YouTeam Logo

Summary

Expertise

Project Highlights

Education

Agency

LV

English:

Advanced

Liam Emanuel V.

vetted by Youteam

Vetted by YouTeam

Mexico

UTC -06:00

America/Mexico_City

English:

Advanced

Designed and implemented a complaint handling framework, including KPIs, policy and a dashboard for monitoring the system.

Designed and executed data pipelines using Apache Airflow (deployed with Docker), Airbyte (deployed with Docker), Python (with SQLAlchemy), SQL, AWS (S3, Lambda), and Google Cloud Platform (Sheets API, Drive API), enabling seamless reporting, automated analytics, and data accessibility for stakeholders across the organization. This initiative streamlined processes and enhanced data-driven decision-making.

Want to hire this engineer?

Check if Liam Emanuel is available

Expertise

Years of commercial development experience

3 years of experience

Core technologies

Python 3 years
Docker 1 year
Apache 2 years
Git 2 years
SQL 3 years
Microsoft 3 years

Project Highlights

icon
Data Engineer

ETL Pipeline of Vehicle Inspections and Vehicle Inspection Appointments

Aug `23 - Dec `23

4 months

Gobierno del estado de Jalisco

Implemented an orchestrated ETL pipeline with Apache Airflow, Airbyte with AWS leverage (S2, Lambda), GCP (Drive API, Sheets API, service accounts), Python (SQLAlchemy, Pandas, Numpy, etc.) to ensure availability, quality and integrity of data within the organization for ingestion into Looker Studio reports, Power BI, ad-hoc, etc. These technologies were used on a Ubuntu server machine and deployed with Docker, as well as AWS Lambdas.

Responsibilities & achievements

Implemented an orchestrated ETL pipeline with Apache Airflow, Airbyte with AWS leverage (S2, Lambda), GCP (Drive API, Sheets API, service accounts), Python (SQLAlchemy, Pandas, Numpy, etc.) to ensure availability, quality and integrity of data within the organization for ingestion into Looker Studio reports, Power BI, ad-hoc, etc. These technologies were used on a Ubuntu server machine and deployed with Docker, as well as AWS Lambdas.

Apache
API
AWS
Database Developer
ETL
Python
Docker
icon
Data Engineer

Vehicle Emissions Regulation Directorate

Mar `22 - Jun `23

1 year

Gobierno del estado de Jalisco

"Development of the complaints management framework for the Vehicle Emissions Regulation Directorate of the Jalisco state government. I identified an area of ​​opportunity for improvement because there was no defined process for the reception and processing of complaints/claims/requests for information, resulting in liability problems and unnecessary expenses. I raised the problem, wrote a preliminary project that included the framework, a policy and the KPIs. Later I designed the relational data model and it was implemented in the form of spreadsheet logs in Google Sheets for the different private vehicle inspection operators. All the data collected is used to produce insights in a Looker Studio dashboard. The relational data model and the framework are designed in such a way that the data can be migrated to a web application for which the declared requirements for its development are already met. Weekly complaint data extraction from the central spreadsheet was also implemented with airbyte to load said data into a MySQL database".

Responsibilities & achievements

Development of the complaints management framework for the Vehicle Emissions Regulation Directorate of the Jalisco state government. I identified an area of ​​opportunity for improvement because there was no defined process for the reception and processing of complaints/claims/requests for information, resulting in liability problems and unnecessary expenses. I raised the problem, wrote a preliminary project that included the framework, a policy and the KPIs. Later I designed the relational data model and it was implemented in the form of spreadsheet logs in Google Sheets for the different private vehicle inspection operators. All the data collected is used to produce insights in a Looker Studio dashboard. The relational data model and the framework are designed in such a way that the data can be migrated to a web application for which the declared requirements for its development are already met. Weekly complaint data extraction from the central spreadsheet was also implemented with airbyte to load said data into a MySQL database.

MySQL
Database design
icon
Python Developer

Identification of aberrant data and calculation for correction of parameters in databases for diesel vehicles

Dec `21 - Dec `23

2 years

Gobierno del estado de Jalisco,Dekra, Applus, AIRE

After analyzing the data generated from vehicle inspections of vehicles that use diesel as fuel, I identified anomalies within the tests when the personnel carried out the corresponding test. This case was reviewed by the then Secretary of the Environment of the state of Jalisco and also by the CEO of Dekra América, due to the possible repercussions that could be generated. I made regular ad-hoc reports on the data with Jupyter Notebooks, I developed a Python script to extract data from said inspections as weekly reports stored in Google Drive and notified by email to the owners of vehicle inspection centers, Dekra and Applus being the most important. I then designed a Python script to accurately calculate configuration parameters in diesel tests, in order to assist technicians in the configuration for vehicle inspection, reduce anomalies and identify bad practices. All this was translated into a Looker Studio dashboard embedded with iframe in a web application.

Responsibilities & achievements

After analyzing the data generated from vehicle inspections of vehicles that use diesel as fuel, I identified anomalies within the tests when the personnel carried out the corresponding test. This case was reviewed by the then Secretary of the Environment of the state of Jalisco and also by the CEO of Dekra América, due to the possible repercussions that could be generated. I made regular ad-hoc reports on the data with Jupyter Notebooks, I developed a Python script to extract data from said inspections as weekly reports stored in Google Drive and notified by email to the owners of vehicle inspection centers, Dekra and Applus being the most important. I then designed a Python script to accurately calculate configuration parameters in diesel tests, in order to assist technicians in the configuration for vehicle inspection, reduce anomalies and identify bad practices. All this was translated into a Looker Studio dashboard embedded with iframe in a web application.

Database Developer
Python
icon
Local and International Collaboration

Product Testing and Evaluation

Jan `20 - Dec `20

11 months

Vectro Rastreo Vehicular

Worked with European, Asian and U.S. suppliers, some of them are Teltonika, Tongli, Concox, Suntech, Atrack, etc. Also, with local clients like Grupo Armstrong (armored security trucks for money transportation).

Responsibilities & achievements

Tested new GPS and IoT products to give my technical overview to the business owner and the general manager

Microsoft
icon
Engineering and Technical Documentation

Planning and Execution

May `19 - Dec `19

7 months

Vectro Rastreo Vehicular

Standardized equipment installation through the development of technical documentation.

Responsibilities & achievements

Standardized equipment installation through the development of technical documentation.

Microsoft

Education

Higher education in Computer Science

Agency

agency #2373

10-50

GMT-6

HOUSTON/United States

Core Expertise

AngularJS
API
AWS
C#
C++
Django
Express.js
Flask
Hibernate
Ionic
Java
Java EE
JavaScript
Kotlin
Magento
MEAN Stack
MongoDB
.NET
Node.js
Oracle
PL/SQL
Python
Rackspace
Ractive.js
React.js
React Native
SaaS
Salesforce
Selenium
SQL Server
Tableau
Ubuntu
UI
UML
VBA
VB.NET
Zendesk
.NET Compact Framework
IBM AS/400 Control Language
IBM DB2 Administration
J2ME
JasperReports
Java Servlets Development
LAMP Administration
Landing Pages
Laravel Framework
Machine learning Engineer
Microsoft Dynamics ERP
OAuth
Object oriented design
Object Oriented Programming (OOP)
Oracle APEX
Oracle Application Framework
QA Management
R-Hadoop
Salesforce Apex
Salesforce App Development
Salesforce.com
Scrum
Swift
VBScript
Web Crawler
Web Crawling
zapier
RabbitMQ
UI Bootstrap
Zabbix
Nagios
LDAP
Project Manager
Scrum Master
Spring Boot
Hadoop
Flutter
.NET Core
JavaScript MVC
Web Analytics

Industries

E-Commerce & Retail, Banking & Finance, Information services & Technologies, Service & Support, SaaS

Want to hire this engineer?

Check if Liam Emanuel is available