Job Seekers / Profile

Civil/Structural Engineer, VBA Excel macro programmer

Name: Florentino Cabrera
Age: 61
Experience: 20 years as Structural Engineer, 10 years VBA developer
Education: Bachelors degree
Salary: ₱ 50,000.00 (per month)
Category: Customer Support & Admin Support
Website: /
CV: /

Profile Description

• Deutsche Bank – Assigned the tasks to fix spreadsheet VBA applications called PRG and COP used by equity Sales for order capture and pre-confirmation report generation. These macro spreadsheets are vital core tools for Equity which have been working erratically due to incompatibility issues with the latest MS Office and Bloomberg API. Due to the macro spreadsheets’ high level of complexity I was given this urgent task to fix the codes and stabilize the macro to original working conditions and eventually conduct knowledge transfer training to HK IT hub for Asia support. • Deutsche Bank – Provides support to Non-Yen Fixed Income Sales by maintaining some legacy macro spreadsheets called Salesbook and CPCalc which are used for order capture of intra-day and closing orders trades. These macro spreadsheets also are vital core tools for the FI Sales team and are used to generate pre-confirmations as well. Fixed all issues encountered due to migration to newer MS Office system. Migrated legacy Bloomberg API VBA codes for compatibility with the new currently supported Bloomberg API. • Manila, Philippines – Provides Engineering support for a small engineering design and building construction firm which is privately owned and managed by my wife. Being an accomplished and licensed Civil Engineer, I provide all the civil/structural analysis designs and consultancy, estimations, specifications, CAD drawings and 3D renderings and project management support (using an Excel spreadsheet macro tool I developed myself to show workflow progress, determine manpower utilization, cost control and projected accomplishment). I manage to do all these tasks during weekends and time-offs outside of workdays.

Web, Mobile & Software Development
  • C#