Hans Walter
Data Engineer at eSage Group- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Advanced SQL: SQL Expert Certification Preparation Course
UdemyOct, 2022- Oct, 2024 -
Data Strategy
LinkedInOct, 2022- Oct, 2024 -
Building Batch Data Pipelines on GCP
CourseraJun, 2022- Oct, 2024 -
Building Resilient Streaming Analytics Systems on Google Cloud
CourseraJun, 2022- Oct, 2024 -
Smart Analytics, Machine Learning, and AI on GCP
CourseraJun, 2022- Oct, 2024 -
Google Cloud Big Data and Machine Learning Fundamentals
CourseraMay, 2022- Oct, 2024 -
Launching into Machine Learning
CourseraMay, 2022- Oct, 2024 -
Modernizing Data Lakes and Data Warehouses with Google Cloud
CourseraMay, 2022- Oct, 2024 -
How Google does Machine Learning
CourseraMar, 2022- Oct, 2024 -
Microsoft Certified: Azure Fundamentals
MicrosoftMar, 2022- Oct, 2024 -
JavaScript Algorithms and Data Structures
freeCodeCampJan, 2021- Oct, 2024 -
Data Analysis with Python
freeCodeCampDec, 2020- Oct, 2024 -
Machine Learning with Python
freeCodeCampDec, 2020- Oct, 2024 -
Scientific Computing with Python
freeCodeCampDec, 2020- Oct, 2024 -
Microsoft Office Specialist: Excel Expert (Excel and Excel 2019)
MicrosoftOct, 2020- Oct, 2024
Experience
-
eSage Group
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Data Engineer
-
Nov 2022 - Present
Development of data solutions in Azure. Working hand to hand with clients to meet their data needs through various phases. Configuration of Azure Data Factory pipelines and dataflows. Development of data solutions in Azure. Working hand to hand with clients to meet their data needs through various phases. Configuration of Azure Data Factory pipelines and dataflows.
-
-
-
Universidad Francisco Marroquín
-
Guatemala
-
Higher Education
-
400 - 500 Employee
-
Assistant Professor
-
Jul 2022 - Nov 2022
Assistant professor of Analysis of Operations II Assistant professor of Analysis of Operations II
-
-
-
Max Warehouse
-
United States
-
Retail
-
1 - 100 Employee
-
Big Data Developer and Catalog Specialist
-
Jun 2022 - Nov 2022
- In charge of the automation of data extraction of all marketplaces (Amazon, Google Shopping, Walmart, etc). - Successfully implemented an .edi and .txt parser to transform data from various suppliers, resulting in a dashboard that provides insight into the company’s catalog and effective listings. - Continuous cleaning and adjustment of the catalog database to fix listings mismatches due to dimensions, title and descriptions, discrepancies in model/sku number, and various others through text analysis with SQL and Python. Show less
-
-
-
-
Data Engineer at Legaltech, Methodologies and Analytics Compliance Unit
-
Oct 2021 - Jun 2022
- Responsible of the elaboration of analytic solutions in all of its phases. - In charge of establishing the foundation and structure of all KPI's of the various areas within the VP of Methodologies, Compliance and Analytics. - Management and overseer of moving local databases to centralized platform (Landing Zone) for further data use in ML models and Power BI reports. - Identification of data sources, optimization of data flows through communication of external areas of the VP and creation of diagrams that document the data journey through the various systems and its corresponding outputs. - Creation and maintenance of applications in PowerApps alongside solutions in PowerAutomate. - Development of documentation when creating new raw data tables or result tables. - Created KNN model that classified the banks client portfolio by demographic segments, spending behaviors and what products (cards, loans, with respective income and expenses, etc) were associated with them. Show less
-
-
-
GBM
-
Austria
-
Machinery Manufacturing
-
1 - 100 Employee
-
Software Specialist Automation
-
Feb 2021 - Jan 2022
- Responsible for numerous projects of complex solutions involving automation of on premise resources, as well as in clouds such as AWS, and Azure for client needs and of the company. Here's a few examples of the projects developed: 1. Developed a totally automated solution that fetches facts and data of servers and network devices independent of their OS or cloud provider. This data is then published in a dynamic web page where the info can be viewed in detail. 2. Created environment in AWS with EC2 servers that are in compliance with CIS standards, this solution also creates a report that specifies which vulnerabilities are detected on the servers. 3. Implementation of an auto scale solution in Azure behind an elastic load balancer, hosting a sample web app where if the CPU usage is above 50% for the initial VMs, then new instances are created with the same configuration as the initial ones. 4. Created an automated solution to add numerous users in Bitbucket. 5. Developed an environment in AWS and Azure containing the necessary setup and hardware and software configuration to host a Red Hat Satellite instance and 2 capsule instances ready for use. 6. Created the documentation and publication of parametrized code of all the projects made during the internship for future use of other developers. Centralized repository containing all demos which can be deployed in an automated manner as well as delete all the resources and environments once the demo is finished. Show less
-
-
-
Colgate-Palmolive
-
1 - 100 Employee
-
Colgate Analytics Project
-
Aug 2021 - Dec 2021
- In charge of the analytics project regarding supplier's services. - Identification of types of services via text analysis, including cost analysis per service and frequency in order to negotiate prices with suppliers. - Elaboration of an automated worfklow system which alerts users which products will soon expire, creation of Data Studio dashboards to reflect results. - In charge of the analytics project regarding supplier's services. - Identification of types of services via text analysis, including cost analysis per service and frequency in order to negotiate prices with suppliers. - Elaboration of an automated worfklow system which alerts users which products will soon expire, creation of Data Studio dashboards to reflect results.
-
-
Education
-
Universidad Francisco Marroquín
Baccalaureus Scientiae and Business Engineering Degree Cum Laude, Minor in Data Science -
American School of Guatemala
Bachiller en Ciencias y Letras, High School Diploma