Luis Marcano Email & Phone Number

Highly accomplished and collaborative Senior Data Engineer & BI Manager with a wealth of experience leveraging technical skills and expertise to solve complex technical problems. Proven success in data analytics, database engineering, business intelligence, and data strategy using Oracle and Microsoft product solutions.SELECT ACHIEVEMENTS:------------------------------------------✔ Oversaw the development of a capital projects web tool that managed the entire energy department's $200M CapEx portfolio and implemented by executives to track key metrics including expenses, savings, and IRR. ✔ Spearheaded the development of a web application to manage the corporation's GHG Emission Reduction Initiative resulting in a savings of $50M/year (300k MT of CO2e).✔ Developed and implemented a Business Intelligence strategy to digitize the fuel plan model and compliment the BAT Tool to provide drill-down visibility into the yearly $900M fuel expense (1.5M MT of fuel); tools projected a 1-3% fuel savings reduction in the upcoming year to validate < 2% accuracy from previous year forecasts. ✔ Operationalized the fuel plan model to forecast the company’s yearly fuel consumption position based on itineraries of 50+ ships fleetwide which generated an expense based on the daily fuel market prices and contracts worldwide; the company's 2nd largest expense behind salaries. ✔ Designed a BI strategy to provide hourly insights on the company’s revenue metrics with dashboards providing the revenue teams with insights to update the pricing structure and analyze intraday revenue performance. ✔ Migrated outdated Hyperion Reports into corporate-wide Power BI Dashboards with role-level security access.✔ Optimized the existing pricing strategy system to be more efficient and decreased execution time by 30%, allowing dashboards to be refreshed more often using the latest revenue numbers.✔ Overhauled an unsuccessful $1M pricing strategy tool using guidance from an internal team of statisticians, re-used the existing code, created BI & Analytics on the system output using Power BI resulting in a more reliable model.

Listed skills include Software Development, C#, Javascript, .Net, and 15 others.

• 

  Florida International University

  Computer Science