Erick Alexander Ramírez Tebalán Email & Phone Number

United States

• Build, test, and maintain scalable data pipelines, data warehouses, data marts, data lakes, workflows, and management using GCP, Apache Airflow, and streaming data integration pipelines using Pub/Sub.
• Optimization of the pipelines' performance by refactoring queries and Airflow DAG's structuring, reducing runtimes and costs by 30 percent in GCP infrastructure.
• Enrich system metrics and data quality by integrating unit, functional, performance, integration, and security testing. Configure metrics, alarms, monitors, and dashboards to provide insights into SLAs and SLO.

Guatemala City, Guatemala, Guatemala

• Develop and maintain the data warehouse and data lake. Support data ingestion, ETL pipelines, data modeling, and BI dashboards.
• Research on digital marketing data and identified ways to improve data reliability, efficiency, and quality.
• Automatization of processes related to data preparation for predictive and prescriptive modeling.
• Implement automated pipelines for machine learning projects related to ranking pages to lead generation.

Guatemala City, Guatemala, Guatemala

• Led the design and development of enterprise data warehouse solutions for marketing, including data ingestion and traffic acquisition from online advertisers such as Google Ads, Microsoft Advertising, Facebook Ads, and.
• Automated and optimized tracking metrics for marketing experiments, including Multivariate Testing, A/B, and Auto-Targeting.
• Develop and maintain the data warehouse. Support ETL pipelines, data modeling, and data quality.
• Software solutions were designed and refactored based on clean code, test-driven development (TDD), and consideration of high availability and scalability.

Guatemala, Guatemala

• Administered up to sixty SQL Server database instances, including maintenance and performance troubleshooting.
• Designed and developed new infrastructure planning (physical and virtual), licensing, security policies, backup, and restore strategies.
• Monitored and performed tuning about replication, migration, security, backups, code optimization, and refactoring.

Guatemala City

• Worked as Scrum Master; I oversaw sprint planning for the features assigned to the team.
• Followed up the software development process: checked team capacity project tracking, ensured proper designs were built by the team, and ensured the latest technology was used for development whenever possible.
• Replaced legacy systems to have new capabilities for the end-user and reduced maintenance costs by 35%.
• Led a team of 4 software engineers and one QA automation engineer to develop and implement data entry solutions to improve business outcomes.

Guatemala

• Designed and developed software solutions at the Metropolitan Life Insurance Company (Metlife) division.
• Analyzed, designed, and developed a document processing solution for insurance coverages, including automated intakes.
• Performed the SQL champion role for keeping the databases and source control synchronized and checking the scripts for automated deploys.

Guatemala City, Guatemala, Guatemala

• Taught the "Databases II" course for a bachelor's degree in computer science.
• Provided detailed and regular feedback to the professor on students' progress.
• Planned and reinforced lessons presented by the professor: reviewing material with students one-on-one or in small groups.

Guatemala, Guatemala

• Designed and developed computer-based solutions customized for specific requirements for several organizations in various industries.
• I worked with a quality delivery approach on desktop and web applications. I was involved in the entire software development life cycle.
• Integrated software solutions from multiple companies to create a collaborative environment.

Quetzaltenango, Guatemala

• Developed and implemented an Enterprise Resource Planning using ODOO (previously Open ERP), which enabled the business integration process, including an e-commerce solution.
• Planned and implemented software solutions for automated marketing campaigns.
• Designed infrastructure for high availability using Amazon Web Services (AWS).

Quetzaltenango, Guatemala

• Tutored first-year students and sophomores with advice and explanations in mathematics and physics courses for the initial understanding of engineering.
• Encouraged critical thinking and ensured the student's knowledge was challenged and probed.
• Facilitated a learning climate that is open and non-threatening but rigorous.

Postgraduate Degree, Specialization In Scientific Research

Master'S Degree, Information Systems Management, Cum Laude

Postgraduate Degree, Databases

Bachelor'S Degree, Informatics And System Engineering, Magna Cum Laude

Activities and Societies: Mathematics Tutor from 2009 to 2011

Bachelor'S Degree, Industrial Engineering, Seventh Semester