Skip to main content
ES EN DE
Logical Structure + Operational Leadership

Astrid Yajaira Trigos Angarita

Civil Engineer | Project Management, Cost Control & Data Analytics

Civil Engineer with a multidisciplinary analytical profile. I combine process engineering with technological tools to optimize business decisions.

  • Advanced Excel: financial modeling, template automation, and budget control
  • Software QA and data governance in agile environments (Jira, Scrum)
  • Predictive planning with CPM/PERT, Gantt, and Kanban in Microsoft Project
asyajus@gmail.com
+57 315 926 4773
Ocaña, Norte de Santander, Col.

Methodological Framework & Professional Value Proposition

Predictive & Agile Planning

Schedule Modeling & Control

Mastery of critical path methodologies (CPM/PERT) and visual organization (Gantt and Kanban) to optimize schedules and ensure projects meet their deadlines with mathematical efficiency.

Process Assurance

Data Governance & QA

Specialist in mapping data and business flows through Canvas and advanced spreadsheets. I ensure the final quality (QA) of any system by auditing its operational logic.

Financial Feasibility

Smart Costing & Automation

Proven ability to control complex financial resources, automate business and personal expense templates in Excel, and structure budgets aligned to real profitability.

Technical Skills

💻 Digital Tools & QA

QA / Functional Testing Jira Software (Epic & Bugs) Productivity Expert Artificial Intelligence (Kiro, Visual) Canvas / Layout Design Google Workspace & Sheets

⏱️ Project Management & Methodologies

Microsoft Project Gantt Charts Kanban Boards (Scrum) CPM / PERT (Critical Path) Feasibility Analysis Process Engineering

📊 Advanced Excel, Costing & Finance

Unit Price Analysis (APU) Budget Control Cash Flow Management Advanced Excel (Logical Formulas) Financial Modeling in Templates Accounts Receivable & Invoicing

🌟 Soft Skills & Focus

Teamwork Assertive Communication Deep Flow States Meticulous Organization Methodological Rigor

Education

2016 - 2022

Civil Engineering

Universidad Francisco de Paula Santander (Ocaña)

2020 - 2021

Building Construction Technician

Servicio Nacional de Aprendizaje (SENA)

Key Certifications

  • ✓ Diploma in Business Management and Organization with Microsoft Excel — Edutin Academy (Delaware, USA). Focus on financial modeling and managerial control.
  • ✓ Specialized Course in AutoCAD — SENA. Geometric design and detail drawings.
  • ✓ Occupational Health and Safety (OHS) — SENA.

Detailed Work Experience

Data Analyst and Quality Assurance (QA)

GO ELEGIDOS

May 2025 - Present

Responsible for the company's financial data control, taking an active support role in data structuring, and backing quality assurance (QA) testing on the company's new software solutions.

Data Support & Governance:

Direct support in the processing, analysis, and interpretation of operational business data, structuring information databases in spreadsheets to ensure that the system's data transition and loading responds with mathematical accuracy to management needs.

Quality Assurance (QA) & Functional Testing:

Design, structuring, and execution of comprehensive functional test matrices to validate the correct operation of solutions developed during the last month. I ensure the consistency of internal accounting flows and business logic rules before production release.

Agile Requirements Management in Jira:

Complete mapping of logical requirements, technical bug and software incident reporting using Scrum and Kanban workflows, and lifecycle tracking and resolution in close collaboration with the systems engineering team.

Co-founder & Project Director

ARKEHIA (Productivity & Project Management)

January 2026 - Present

Business initiative aimed at structuring and democratizing advanced productivity concepts, project management tools, and financial feasibility for everyday life and entrepreneurship.

Feasibility Modeling & Logical Structuring:

Implementation of structured engineering methodologies and project management tools (CPM/PERT, Gantt charts, Kanban) to analyze, measure, and structure the critical path and technical-economic feasibility of each project or strategic decision within the business portfolio.

Financial Control Systems Development (Excel):

Design and architecture of high-end automated Excel templates oriented toward meticulous recording and predictive analysis of personal finances, operational cash flows, and small business accounting, reducing users' financial risk.

Exact Sciences Instructor & Administrative Director

ACADEMIA DE CIENCIAS AVANZADAS EXACTAS (ACAE)

May 2024 - December 2025

Direct accounting management of the institution's cash flow and design and instruction of the advanced logical tools training plan.

Advanced, Basic & Intermediate Excel Instructor:

Designed and delivered a structured training plan in Microsoft Excel. Trained students and professionals in the use of conditional logical formulas, matrix lookups (BUSCARX/INDICE/COINCIDIR), Pivot Table design and data segmentation, automated conditional formatting, and best practices for creating scalable data models.

Internal Financial & Administrative Management:

Annual budget control, weekly cash flow modeling, expense reconciliation, invoice processing, and preparation of internal accounts receivable, centralizing accounting and mitigating losses from operational gaps in automated spreadsheets.

Cost, Budget & Project Administration Engineer

RE-INGENIERÍAS (Construction & Oversight Firm)

May 2023 - September 2024

Financial control of civil works, design of analytical budget models, and technical and financial feasibility auditing for multi-million-dollar government infrastructure projects using Microsoft Project and CPM/PERT methodologies.

Budget & Cost Control (Aguas Blancas & La Curva Sewer System):

In charge of analytical cost control, construction budgets, and the construction firm's financial cash flow on multi-million-dollar government sanitation projects. Auditing and technical structuring of Unit Price Analysis (APU). Design of advanced Excel templates to consolidate quantity calculation reports, structuring accounts receivable and official construction certificates.

Comprehensive Project Administration (Open Dikes & Weirs - Qda. Taruca):

Coordination of all contractual, technical, and oversight documentation for critical hydraulic works. Budget review and technical-economic feasibility of structural plans in Excel and AutoCAD, ensuring the financial balance of the mitigation project and direct liaison with UNGRD.

Mathematics & Physics Instructor, Excel Trainer & Administrative Support

ACADEMIA WILTIC

November 2022 - April 2023

Instructor and collaborator in user database control, enrollment management, and internal administrative accounting support for the academy.

Basic Excel & Office Suite Instruction:

Designed pedagogical guides and delivered practical Basic Excel courses for professionals and students, covering data formatting, tables, conditional sorting, conditional logical functions, and basic report automation.

Academic Data Governance (Excel):

Created and structured a relational system in spreadsheets to manage the enrolled student database, grades, and attendance.

Administrative & Accounting Support:

Collaborated in daily cash reconciliation, invoice processing, outstanding debt control, and issuance of monthly tuition accounts receivable for the campus.

Civil Engineering Intern (Physical-Operational Area)

EMPRESA DE SERVICIOS PÚBLICOS DE OCAÑA - ESPO S.A.

March 2020 - May 2020

High-performance technical support under the planning department, focused on material budget control, planimetry, and field auditing for the El Algodonal Water Treatment Plant (PTAP).

Suction Tank & Machine Room Construction:

Provided daily on-site technical support at the El Algodonal Water Treatment Plant (PTAP), supervising concrete pouring quality and reinforcing steel placement according to design specifications.

Analytical Calculation & Material Quantification:

Designed automated calculation templates for mathematical quantification of aggregates, structural concrete volumes, and reinforcing steel weight control, cross-referencing data to prevent construction material losses.

AutoCAD Management & Document Control:

Review of structural, geometric, and pressure pipe drawings in AutoCAD. Responsible for auditing and maintaining the daily construction logbook and structuring monthly reports for the Planning Department.

Quality Assurance, Finance, and Technology

Portfolio of Achievements & Applied Solutions

Analytical and quantitative demonstration of real-world problem solving combining the rigor of cost calculation and process engineering.

🌱
Entrepreneurship & Productivity

Arkehia: Feasibility & Financial Automations

As the founder of Arkehia, my main goal is designing tools that integrate the technical precision of engineering with everyday financial organization, using high-performance Excel templates.

Models & Milestones:
  • • Excel Modeling: Creation of automated predictive simulators for personal and business finances.
  • • Feasibility Analysis: Application of CPM/PERT for prioritizing complex operational goals.
Tools: Advanced Microsoft Excel, CPM/PERT Methodologies, Gantt Charts, Corporate Finance.
💻
Quality Assurance

Software QA & Traceability

At GO ELEGIDOS, I took responsibility for certifying the quality and stability of technological solutions developed during the last month. I go beyond basic UI testing; I audit the behavior of internal APIs against the complex logical rules of the operation.

Methodologies & Milestones Achieved:
  • • Test Planning: Design of functional and regression test matrices based on real user stories.
  • • Jira Management: Detailed incident logging, priority assignment, and bug resolution control (Bug Lifecycle).
Tools: Jira Software, Agile Methodologies (Scrum, Kanban), Functional System Testing.
⚙️
Business Automation

Accounting Optimization & Data Modeling

During my roles at ACAE and RE-INGENIERÍAS, I developed dashboards and complete cash flow tracking and budgeting systems in Microsoft Excel and Google Sheets. My models are optimized to prevent formula errors and automate repetitive manual processes.

Capabilities & Technical Impact:
  • • Matrix Design: Financial modeling through complex conditional lookup and indexed formula combinations.
  • • Data Visualization: Design of informational dashboards using Canvas and automated spreadsheets to bring transparency to managerial decision-making.
Tools: Advanced Microsoft Excel, Canvas, Google Sheets.
📊
Infrastructure Cost Engineering

Cost Control & Construction Forecasting

Comprehensive accounting control of the construction consortium in San Martín (Cesar). Responsible for ensuring that actual field construction progress corresponded exactly with budget and cash projections on multi-million-dollar government projects.

Construction Financial Methodologies:
  • • APU Analysis: Unit Price Analysis auditing to control cost deviations of road and hydraulic materials and supplies.
  • • Schedule Planning: Use of Microsoft Project and Gantt charts to map the sewer system project timeline.
Tools: Microsoft Project, Advanced Microsoft Excel, Gantt Charts, APU Analysis, Sewer System (Aguas Blancas & La Curva).
🏛️
Public Management & Documentation

Budget Auditing & UNGRD

Led the administrative construction control and technical liaison for the "Construction of mitigation works in the Quebrada Taruca watershed: Open Dikes and Dissipator Weirs" with UNGRD and the oversight entity.

Key Results:
  • • Plan Feasibility: Detailed auditing in AutoCAD and spreadsheets to verify unit costs and geometric consistency of hydraulic dikes.
  • • Official Documentation: Preparation of legal and technical compliance files for consolidated reports required by the government.
Tools: AutoCAD, Microsoft Excel, CPM/PERT Methodologies, Contractual Document Management, UNGRD.

Why work with me?

Any project or software solution requires meticulous validation. With my Civil Engineering background, my hands-on experience managing cash flows, and the methodological design of schedules and processes (CPM/PERT, Gantt charts, Canvas), I bring a unique rigor to strategic planning and corporate quality assurance. I validate each process not only to ensure the tool works, but to strictly verify that the underlying business logic is robust, efficient, profitable, and secure.

Astrid Yajaira Trigos Angarita — asyajus@gmail.com