Juan Sebastian Lopez Rodriguez
Riverwoods,IL
Summary
Civil Engineer with a post-graduate degree in Financial Management and over 10 years of experience in the construction industry. Strong background in planning, auditing, and supervising engineering projects, combined with solid expertise in cost estimation, budgeting, and resource allocation. Highly skilled in data analysis and data management to support informed decision-making, leveraging Excel and Power BI to deliver actionable insights, enhance project monitoring, and improve executive reporting. Goal-oriented, collaborative, and results-driven professional.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Estimator/Data Analyst
Bancare Inc
01.2025 - Current
- Analyzed project specifications to prepare accurate cost estimates for materials and labor.
- Review and evaluate data related to subcontractors, employees, and ongoing projects, creating Power BI dashboards and using Excel to enhance project visualization, monitoring, and tracking for effective management oversight.
- Automated repetitive reporting tasks using Excel and Power BI, saving time and improving data reliability.
- Consolidated data from multiple sources, ensuring accurate and consistent information for project tracking and reporting.
Estimator
Bancare Inc
11.2023 - 01.2025
- Evaluated project specifications to prepare detailed cost estimates and proposals.
- Analyzed blueprints and drawings to identify necessary materials and labor requirements.
- Collaborated with project managers to ensure alignment on budgetary constraints and timelines.
- Conducted market research to assess pricing trends and negotiate vendor contracts effectively.
- Managed over 50 projects, ranging from small renovations to ground-up construction.
Field Construction Superviso
Ranger Construction
08.2022 - 11.2023
- Assisted in calculating project quantities as part of the estimator role, contributing to the improvement of operational processes within the company
- Conducted regular site inspections to assess progress, quality, and compliance with regulatory requirements.
- Supervised daily operations on construction sites to ensure adherence to safety standards and project specifications.
Construction Engineer
VANTI S.A. ESP
07.2015 - 08.2021
- Ensure that the work assignments comply with the current Colombian regulations and procedures from the start of the project through its completion.
- Control and supervise the construction projects with weekly reports and follow-ups to the team.
- Prepare and control the budget from the project and resources allocation through the final payment.
- Lead and supervise the construction field crew, ensuring high quality and safety standards.
- Canadian Multinational company - Distribution leader of natural gas in Colombia
- ACHIEVEMENTS
- I optimized the operational time, consolidating different construction processes with Microsoft Excel Office.
- I generated savings of approximately 20,000 USD with a project to change the gas distribution line.
- I led gas works of more than 15.000 m2 of networks.
Sites Supervisor
Peninsula investment Group
06.2014 - 07.2015
- Daily control and supervise of the projects progress.
- Lead the technical construction.
- Financial analysis for the construction projects with new planning methods.
- Monitor and verify the Colombian technical regulations and procedures (NSR-10) in each construction project assigned.
- Implemented new control mechanisms that significantly reduced validation times across field operations and processes.
- Supervised daily site operations ensuring compliance with safety regulations and quality standards.
Professional in Supply Chain training
SIEMENS
02.2013 - 02.2014
- Daily control and supervise of the projects progress.
- Lead the technical construction.
- Financial analysis for the construction projects with new planning methods.
- Monitor and verify the Colombian technical regulations and procedures (NSR-10) in each construction project assigned.
- Contributed to team objectives, achieving savings in over 10 major negotiations.
Quality Coordinator
VAVILCO LTDA
04.2011 - 02.2013
- Coordinate and lead the correct development of the quality process in the construction projects.
- Support the quality certification process.
- Coordinated quality assurance processes, ensuring compliance with industry standards and regulations.
- Achieved company certification in the Quality Management System.
- Developed and implemented training programs to enhance staff understanding of quality control procedures.
Education
Post-Graduate Degree - Financial Management
Universidad Piloto
Bogotá, Colombia01.2017
Bachelor of Science - Civil Engineering
Pontificia Universidad Javeriana
Bogotá, Colombia09-2012
Skills
- Creativity & innovation
- Highly adaptable
- Cost estimation
- Material takeoffs
- Estimating software
- Data Visualization
- Power BI Dashboard
- KPI Tracking / Metrics Monitoring
Accomplishments
- Developed and implemented methods to integrate ongoing and completed projects into a unified system, enabling comparison of estimated versus actual supervision hours through Power BI to evaluate operational efficiency.
- Enhanced and optimized existing databases for subcontractors and active projects, streamlining workflows, reducing data processing and search time, and significantly improving data organization and accessibility.
Certification
- Technical supervision for building construction: Escuela colombiana de ingenieria, 2015.
- Strategic financial planning: Universidad Nacional, 2015.
- Financial Project evaluation: Universidad Nacional, 2015
- Project planning and control assisted by Ms-PROJECT: Universidad Nacional, 2015
- Internal auditor HSEQ: SGS Colombia, 2012.
- Microsoft Office: SENA, 2014
LANGUAGES
Spanish: Native
English
Timeline
Estimator/Data Analyst
Bancare Inc
01.2025 - Current
Estimator
Bancare Inc
11.2023 - 01.2025
Field Construction Superviso
Ranger Construction
08.2022 - 11.2023
Construction Engineer
VANTI S.A. ESP
07.2015 - 08.2021
Sites Supervisor
Peninsula investment Group
06.2014 - 07.2015
Professional in Supply Chain training
SIEMENS
02.2013 - 02.2014
Quality Coordinator
VAVILCO LTDA
04.2011 - 02.2013
Post-Graduate Degree - Financial Management
Universidad Piloto
Bachelor of Science - Civil Engineering
Pontificia Universidad Javeriana