Andrea Montes Email & Phone Number

Bogotá, Distrito Capital, Colombia

Project Talent Vault- Designed and built architecture to migrate from legacy product to a lakehouse with a modern data stack. For ETL, used dbt, added macros and tests. For orchestration, Dagster. Infraestructure was built with Terraform with AWS as cloud provider. Starburst was used for compute/sql engine. For data replication, DMS was used. Iceberg tables defined across ETL process, data partitioned to reduce data shuffling. Added documentation and deployed a gitlab pages so CSMs and Product teams can start self-service queries. Delivered finished services to production. Enforced "fail fast" mindset to the team, focused on having a good test environment, deployments to production got from 2 weeks cycle to twice a day. Worked on CI/CD pipeline for kubernetes deployment. Added observability features to improve debug time from 2 days to 15 mins. Able to have green/blue deployments across +250 clients.- Worked on a SQL glot tool to port Postgres SQL to ANSI SQL, ported +500 reports in 3 days. Added data audit to ensure consistency after migration. Led groomings, product discovery meetings, performed 5 interviews

Bogotá, Distrito Capital, Colombia

Machine Learning, classification:- Worked on classification algorithm to standardize events categories, workflow status and sentiment evaluation across 250+ clients. Added a heuristic layer to add general product knowledge to the classification, considering amount of data wasn't enough to have higher accuracy by its own. Implemented strategy design pattern to test different classification algorithms. Added unit tests to known outputs after every training so consistency is kept.Migration, Campus Diversity Insights:- Worked on Looker dashboards and data modelling of data from Integrated Postsecondary Education Data System (IPEDS). Deployed with Batch and CI/CD pipeline. Migration from raw SQL into dbt models. Improved data updates from 4-6 to ~1 day. Added data audits to ensure data is consistent after the migration.Support product:- Data replication done with DMS, transformations done with step functions + lambda functions for multitenant application. Added quality checks, unit tests and observability functions to improve debug times- Used airflow to orchestrate an ETL process from a postgres database to snowflake. dbt models, added custom dashboards, maintained code base, supported to issues. Trained people on use of dbt, airflow, buildkite

Bogotá, Distrito Capital, Colombia

Support for DWH star schema environment, orchestration process with step functions in AWS. Automation of deployment process improved the software development cycle. Unit/component/integration/E2E test.

Bogotá D.C., Colombia

Bogotá D.C., Colombia

Development of SW / HW in road safety project. PCB assembly. 3D print. Estimation of power consumption. Repositories git.Development of a bibliographic review about the effects on electrical demand and displacement of fuel consumption due to the entry of electric vehicles in 10 countries with experiences in their introduction, formulation of scenarios to estimate the evolution of the electric vehicle fleet in the Colombian case. Project for the CREG in conjunction with the Universidad de los Andes.

Popayán, Colombia

SW/HW developer. Sensors implementation. Prototyping experience. Test driven development methodology.

West Lafayette, Indiana

Research project on Synthesis of Nanostructured Materials and design, development and delivery of acquisition system for electromigration phenomena. Scholarship program UREP-C between Universidad Nacional de Colombia and Purdue University, United States.

Bogotá D.C., Colombia

Development of automated testing in a QA team of one of the projects in the company. Agile methodologies.

Bogotá D.C., Colombia

SABER 11 National Test Qualifier.

Bogotá D.C., Colombia

Support in logistics in the project "Evaluation and technical support to the program of Scholarships for Excellence in Teaching" in agreement between National Education Minister and Universidad Nacional de Colombia.

Bogotá D.C., Colombia

Coordination, execution and evaluation of events developed during the freshmen first week under program "Preparation for change in university life".

Bogotá D.C., Colombia

Professor in exam admission preparation for Universidad Nacional de Colombia. Classes and workshops in physics area under Bogotá Education Department program.

Bogotá D.C., Colombia

Academic tutor of computer programming, object-oriented programming, and data structures. Sessions are question-oriented

Bachelor'S Degree, Electrical And Electronics Engineering, 4.4

Activities and Societies: Development of projects related to the implementation of technologies such as Visible Light Communications.

High School Degree, Technical Software Programming, Technical And High School, 4.8

Best high school degree in the year 2011. High performance in national test in physics, biology, reading comprehension and social sciences

Technical Software Programming, Software Engineering, 4.5

Development of a software project on airline management and customer service. Design of backend, frontend and database. Selected as one.