At INFORMATICA Y BUEN GOBIERNO – Veeduría Ciudadana, where I served as Founder, Director, Coordinator, and Java Developer for over two and a half years 🏛️, I led the development of a high-performance analytical platform built on public procurement data from Colombia’s SECOP National Procurement Platform. This platform processed large volumes of open government data with the challenge of delivering fast, reliable, and scalable reporting solutions to support citizen oversight and transparency, directly handling complex queries on thousands of contracts across multiple years and entities 📊. Leveraging technologies like Java, ExpressJS, Swagger, Angular (TypeScript/JavaScript), and robust database systems including Oracle, MySQL, PostgreSQL, and MongoDB, I architected backend services designed for high concurrency and data-intensive operations, ensuring the platform could support simultaneous access by many users during peak reporting and auditing periods 🛠️. I implemented RESTful APIs with comprehensive unit testing (JEST) and advanced authentication and routing patterns to ensure secure, performant access even under heavy load 🚀. My work included designing consolidated and exportable reports (Excel, CSV) that scaled to handle tens of thousands of contract records efficiently, offering actionable insights such as contract histories, regional breakdowns, and budget comparisons 📈. This experience equipped me with deep expertise in building backend systems that serve large, public-facing applications requiring robust performance and scalability, closely aligned with environments that demand backend support for high-volume concurrent users and intensive data processing, making me confident in tackling backend challenges for platforms facing heavy user traffic and complex data workflows 💪.
📌 Position: Founder / Director / Coordinator / Java Developer – Platforms Consultation in SECOP National Procurement Platform
📅 Duration: March 2017 – October 2019 (2 years 8 months)
🌐 Website: informaticaybuengobierno.net
Developed an analytical web platform processing Colombian public procurement data (SECOP I & II).
✅ Contractor & Legal Representative Report – Contract history by NIT / ID number.
✅ Municipality & Entity Reports – Consolidated public contracting data per region.
✅ Historical Reports (2011-2018) – Breakdown by year & contract category.
✅ Global Contracting Queries – Export data to Excel for deeper analysis.
✅ TOP Entities & Contractors Reports – Ranked by contract amount.
✅ Budget vs. Contract Reports – Comparative analysis for capital district budgets.
| Category | Details |
|---|---|
| 🏢 Company | INFORMÁTICA Y BUEN GOBIERNO – Veeduría Ciudadana |
| 📌 Position | Founder / Director / Coordinator / Java Developer |
| 📅 Duration | March 2017 – October 2019 (2 years 8 months) |
| 🌐 Website | informaticaybuengobierno.net |
| Area | Key Tasks & Achievements |
|---|---|
| 💻 Software Development & Big Data Analysis | - Developed web applications based on open government data (www.datos.gov.co). - Ensured compliance with Law 1712 of 2014 (Transparency & Public Information Access Law). - Designed fast, consolidated, and accurate reporting solutions for public procurement oversight. |
| 📊 Citizen Oversight & Control Actions | - Conducted government entity audits using public contracting data. - Applied citizen participation mechanisms to report potential irregularities. |
| 📢 Public Awareness & Training | - Trained citizens & businesses on: ➤ Using consultation platforms. ➤ Identifying contracting opportunities. ➤ Detecting potential irregularities in government contracts. |
| 🚀 SECOP National Procurement Platform Development | - Developed an analytical web platform processing Colombian public procurement data (SECOP I & II). |
| 📌 Key Features & Reports | ✅ Contractor & Legal Representative Report – Contract history by NIT / ID number. ✅ Municipality & Entity Reports – Consolidated public contracting data per region. ✅ Historical Reports (2011-2018) – Breakdown by year & contract category. ✅ Global Contracting Queries – Export data to Excel for deeper analysis. ✅ TOP Entities & Contractors Reports – Ranked by contract amount. ✅ Budget vs. Contract Reports – Comparative analysis for capital district budgets. |
| Category | Tools |
|---|---|
| 💻 Backend Development | ExpressJS (Authentication, content negotiation, routing) |
| 📡 REST API & Testing | Swagger (API testing), JEST (Unit tests for REST API queries) |
| 🖥️ Frontend Development | JavaScript & TypeScript, Angular (Strong typing, AJAX) |
| 🔗 Version Control | Git (Command-line & GUI tools: SourceTree, GitKraken, GitHub Desktop) |
| 📊 Databases | Oracle, Informix, MySQL, PostgreSQL (15+ years of experience) |
| 📂 NoSQL Databases | Familiarity with MongoDB & AWS DynamoDB |
| Category | Impact |
|---|---|
| 💻 Government Data Integration | Developed public procurement analytics using SECOP data. |
| 📊 Big Data Analysis | Built data-driven insights & reports to enhance public transparency. |
| 📢 Citizen Engagement | Trained citizens & businesses to improve government contract awareness. |
| 🚀 Web & API Development | Engineered high-performance REST APIs & frontend interfaces. |
| 🛠️ Technology Leadership | Led the development of a full-scale analytics platform for public procurement oversight. |