English:
Advanced
Mario J.
Vetted by YouTeam
Guatemala
UTC -06:00
America/Guatemala
English:
Advanced
I'd describe myself as someone who is reliable and able to undertake complex situations with unique solutions, with over 6 years of experience in Data
Over the past 3 years I have gained ample experience in the field of Airflow and Data Warehouse. And have been responsible for Data Lake Support and creating new ETL/ELT processes within AWS. My previous work includes over 4 years in the field as Application Architect and Data Engineer / Data Analyst with the creation and support of ETL/ELT pipelines via Airflow and other ETL tools like Xplenty, Sisense and custom server scripts, all within AWS infrastructure. As a Data Analyst I have learned to create dashboards and widgets in Sisense, QuickSight, PowerBI, and Tableau. As well as Data Architecture with Sisense and Redshift. I would describe myself as someone who is reliable and able to undertake complex situations with unique solutions, with over 6 years of experience in the Data sector, as well as over 15+ years of SQL experience, and 20+ as Developer.
Want to hire this engineer?
Check if Mario is availableExpertise
Years of commercial development experience
7 years of experience
Core technologies
Project Highlights
I&P; CTO, Senior Application Architect, and Data Engineer
Oct `22 - Sep `23
11 months
QAssertify
QAssertify specializes in QA but has a few other clients with other roles, I am in 2 different projects, one as a CTO, Senior Application Architect and Data Engineer, and the other project as a QA Automation Engineer.
Responsibilities & achievements
Main tasks executed in the project: − Responsible for control and creation of Slack migration, Office 365 users and groups, 1Password implementation, Git Implementation, Jira / Planner implementation, QuickSight Implementation. − Responsible for creating ETL processes for the 13 different clients. − Creating and maintaining new AWS organizations. − Helped front-end and back-end developers with Git implementation and servers as well as servers and services for the Data Scientist team. I helped migrate from email to slack, as well as 1Password as a cybersecurity measure, as well as QuickSight implementation to help boost their BI team, as well as better security standards for their servers and services
SCOTTS MIRACLE-GRO
Oct `20 - Oct `22
2 years
SCOTTS MIRACLE-GRO
On this position I created new ETL processes for extracting data from different APIs like Shopify, iAuditor, Migration from MSSQL to Redshift, also giving support to other team members with data lake access.
Responsibilities & achievements
Main tasks executed in the project: − Creation of new data pipelines for Airflow − Maintaining and expanding current pipelines − Permissions access to the data lake to other team members − Main git support to other team members − AWS support on S3, Docker, Glue, Athena, EMR, Lake Formation, Redshift I helped achieve some optimizations within the airflow operators that the Lead Dev said were not possible, I also suggested moving from Athena to Redshift which boosted the performance on queries.
IMPROVEMENT & PROGRESS
Mar `07 - Oct `17
11 years
Project: Toledo (2016 – 2017) o Solution and co-developed packaging planning in R. o The Software minimizes slack and sorts packaging requirements for all Central America. Increased production 1.4M pounds over a year. Project: Banco Agromercantil, BAM (2014 – 2017) o Developed cash transportation requirements in VB.net with R integration and SQL. o Minimizes movements between all branches and reduces transportation costs by over 50% over 2 years. Project: Toledo (2016 – 2017) o Solution and co-developed packaging planning in R. o The Software minimizes slack and sorts packaging requirements for all Central America. Increased production 1.4M pounds over a year. Project: Banco G&T Continental (2012 – 2017) o Solution and developed cash transportation requirements in VB.net with R integration. o Minimizes movements between all branches and reduces transportation costs by over 70% over 4 years. Project: TAV, S.A. (2015 – 2017) o Solution and developed ATMs requirements in VB.net. o Plans route and requirements for supplying over 600 ATMs reducing the cash outs by over 95% in 3 months. Project: 5B, Transacciones y Transferencias, S.A. (2009 – 2014) o Solution and developed planning and ATMs requirements in VB. o The Software controlled over 2500 ATMs with forecast and helped increase the uptime from 95% to 99.5% over the span of 6 months. Project: Farmacias Meykos (2013 – 2017) o Solution and developed inventories and purchase strategies of more than 100 stores and 45,000 SKUs in VB with SQL. o Also developed a DLL in VB.net for use in an SQL environment. o The Software reduced overall inventory and the sales of best sellers. Project: Ingenio Pantaleón (2007 – 2009) o Developed inventory planning in VB.net with SQL. o The Software minimizes inventory and helps with the Purchasing Order. Project: Canella, S.A. (2015 – 2017) o Developed inventory planning in VB.net. o The Software minimizes inventory and helps with the Purchasing Order. Project: Grupo Emisoras Unidas (2009 – 2014) o Developed radio spots on ASP and Flex. o The Software was developed to control the increased sales of radio spots and to centralize operations.
Responsibilities & achievements
o Solution and developed cash transportation requirements in VB.net with R integration. o Minimizes movements between all branches and reduces transportation costs by over 70% over 4 years.
Education
Higher education in Computer Science
Agency
100-400
GMT-4
Lima, Peru
Core Expertise
Industries
Logistics & Transportation, E-Commerce & Retail, Banking & Finance
Want to hire this engineer?
Check if Mario is available