Christian Lagman Capistrano

Christian Capistrano Contact Information Data Analyst • Experienced professional with 10+ years in data analysis, cost estimation, and project scheduling. Proficient in using Excel,Power BI and Primavera P6 to streamline processes, deliver actionable insights, and ensure project timelines. Skilled in developing estimating software, managing bid proposals, and analyzing EPC project data. Adept at creating efficient workflows and providing technical training. Holds a Bachelor’s degree in IT, recognized for excellence in programming and project management. WORK EXPERIENCE Bids and Proposals Officer (EPC- Bids and Proposals) Meralco Industrial Engineering Services Corporation 07/2014 – 06/2025 MIESCOR is a prominent company specializing in Engineering, Procurement, and Construction (EPC) projects in the field of power generation, transmission and distribution. • • • • • • Developed estimating software to streamline and accurately calculate budgetary amounts for bid projects. Developed and maintained bid proposal schedules to monitor planned and actual progress, ensuring adherence to timelines and preventing delays among stakeholders. Analyzed cost estimates provided by the engineering team and delivered insights to relevant stakeholders. Finalized bid price proposals by incorporating indirect costs, contingencies, profit margins, and payment schedules, presenting them to top management for informed decision-making. Created BI reports using Power BI with data from Excel, focusing on key bid and project metrics like win-loss rates, bid response times, submission counts, and revenue versus cost comparisons, to deliver actionable insights. Managed proposal estimates and documents in compliance with ISO standards Software Developer (Volunteer at 65Square) DEFEND (Canada) 02/2024 – 06/2024 A non-profit organization dedicated to reducing online risks for children and vulnerable people. • Front-end software developer specializing in developing applications using Unity. Focused on creating user interfaces and ensuring a seamless user experience within Unity-based projects. Lead Data Analyst (Marketing and Sales) Manpower for Advertising and Services Agency Inc. 10/2013 – 04/2014 MASA Inc is a leading advertising agency that recruits, trains, deploys personnel for direct-toconsumer sales, in-store merchandising, and events management. • Managed data management processes to ensure accuracy and completeness, and created reports, pivot tables, and charts to monitor stocks, sales, and profit. Department of Education Trainer Columbia Technologies Incorporated • Skills Financial and Analytical Skills • • • • • • • • • • • • • • • • • • • Bachelor of Science in Information Technology Systems Technology Institute (STI College) 06/2009 – 04/2013 Awards: Lead Programmer, Meritorious IT Project, Most Liked IT Project, Best Presenter. SQL and Databases Bootcamp (2024) Data Analysis | SQL, Tableau, Power BI & Excel (2023) Negotiation & Influencing Skills Training (2023) Occupational Safety and Health (OSH) Training (2021) CTI is a systems solutions provider committed to meeting customers computing needs through innovation and total system solutions. EDUCATION MS Excel and other MS Office Applications SQL, Power BI, Tableau VB.Net, VBA, C#, Unity Primavera P6 Professional Certifications and Trainings • Installed and configured computer systems developed and delivered training materials and seminars for DepEd teachers, and provided remote technical support for software and hardware issues Budget Development Financial Reports and Forecasting Data Analysis Data Visualization Problem Solving Strategic Planning Project Management Attention to Detail Technical Skills 04/2013 – 09/2013 • christiancapistrano983 @gmail.com - • Data Privacy Act (2017) Basic Project Management (2016) Professional Office Administration (2016) Office Files and Records Management (2016) Microsoft Access Training (2015)