Erick Rea

Buit and scheduled ETL pipelines for product updates in Apache Airflow Wrote PySpark checks and SQL migrations Developed Python packages (API client, server to server auth, analytics exporters, etc) deployed on Airflow Developed Semantic Search Engine using: Vector database, OpenAI embedding models Created KPI dashboards in Dash Plotly and ad-hoc reports in PowerBI Provisioned AWS infrastructure using Terraform, CI CD scripts on AWS: Lambdas, API Gateway, Glue jobs, S3 buckets, Eventbridge, etc.

Lead 4-person team using agile methodologies, Jira and Confluence MySQL database modelling and implementation of Meta Search Engine Built ELT pipeline for web scraping of 100k pages, ingested into Databricks Developed UI and filtering for Algolia using React and instantsearch.js Created indexes using explicit mappings in OpenSearch with the Python client Deployed resources to MS Azure Cloud, data analysis with MS Fabric Won innovation grants and graduated the DigiHub Ignition Accelerator

EMPIRE.de web development using WordPress, HTML and CSS. Python scripting for benchmarking of desktop software. Writing copy, software documentation, and user manuals. Hardware installation and upgrades. Virtual reality software usability and functional testing.

Developed and grew hotel directory website with WordPress, HTML, CSS, and JavaScript. Reached 15k visitors a month in the site. Maintained websites for clients. Project management, web scraping using Python, Linux, Google analytics reporting. Basic social media management, photo editing, video editing, SEO, Facebook ad campaigns.

Testing of APIs, testing of web services using SOAP and quality assurance. Writing user manualsforsoftware in the banking industry. Black box testing using IBM Integration Bus, DB2 and AS/400 - iSeries. SQL scripting.

Administration of Linux Debian servers. Research of existing market solutions and evaluation of different Open Source projects for the implementation of an IoT project. Exploratory implementation of the JavaScript library Johny-Five and the MQTT protocol.

Development of software to manage the booking of tours using the .NET Framework and SQL Server 2012. Front end developed with Visual Studio Web Forms. Assisting the marketing team with market research using SEMrush, processing and visualizing .csv data in Excel. Maintaining the company websites, mainly visitgalapagos.travel using Bootstrap.

Training high school students for the Ecuadorian national standardized University admission exam. Tutoring students for the TOEFL exam. Joomla website maintenance. HTML, Bootstrap and JQuery development for main site. Facebook presence management.