Business Analytics & Solutions | Information Technology

Goal & Results Driven | Technical Support & Solutions | Project Management | Process Administration & Risk Mitigation | Strategic Planning & Forecast | Performance Tracking & Evaluation | Mentoring & Training


TECHNICAL SKILLS

Platforms

Windows (1995 – 11)

Windows Server

MacOS (9 – 14)

UNIX (Linux, Ubuntu, Redbox)

Tools

Microsoft Office: Word, Excel, PowerPoint, Access, Outlook, Power BI, Visual Studio

Adobe Photoshop

MySQL Database Management

VMware, VirtualBox

Eclipse IDE, NetBeans

Tableau

Lotus Notes

Axure

CrunchTime

JD Edwards, Hyperion/Brio, Essbase

Cerner Millennium, Medaptus, Dive Port

Programming Languages

Java

C Sharp

Visual Basic

SQL

HTML

C Sharp

PHP

JavaScript

XML


EMPLOYMENT HISTORY

Baptist Health South Florida | Miami, FL | February 2021 – Present

Performance Analyst, Hospital Medicine Physician Practice Operations

Responsible for developing and reporting complex analytical quantitative and qualitative reports for the Baptist Health Medical Group - Inpatient Medicine practice spanning 3 hospitals and 150+ physicians. Create, maintain and report using Excel and business intelligence dashboards on key practice statistics and trends. Compile and prepare departmental financial reports for periodic presentations to stakeholders, practice leaders and hospital executives.

Royal Caribbean International Ltd. | Miami, FL | September 2003 – April 2020

Analyst, Finance and Planning, Energy Management | 2018 - 2020

Responsible for planning and reporting $700 Million in Fuel expense for 62 cruise ships worldwide for Royal Caribbean Cruises Ltd. Updated, maintained and reported fleet wide fuel plan model, ship performance and financial fuel trends, fuel consumption forecast to actual analysis, long range fuel financial models.  Perform variance analysis on expenditure discrepancies to executive team.

  • KEY ACHIEVEMENTS

Developed efficiencies with the Fuel Expense and Long-Range Models

Collaborated in creating a business intelligence daily fuel expense dashboard for finance and corporate executives.

Developed and managed new KPI grading standards based on new fleet-wide online operational dashboard.

Collaborated with ship and brand executives on planning and preparing fleet for new IMO global regulations to limit sulphur in fuel oil consumption.

 

Sr. Commodity Buyer, Food and Beverage, Supply Chain Management | 2007 - 2018

Responsible for procuring and managing $90 Million in Food and Beverage commodities in the U.S. and International markets for Royal Caribbean Cruises Ltd. Coordinated and analyzed product bidding process, maintained pre-forecasted expense budgets, arranged product samplings and presentations on potential cost savings opportunities, innovations or improvements, coordinated urgent product recoveries and resolved invoicing disputes.

  • KEY ACHIEVEMENTS

Implemented New Frozen Mix program with Equipment for all RCCL brands $3.5M Spend

Implemented New Complimentary Tea brand resulting in a 16% YoY Savings $1.1M Spend

Implemented Coca-Cola Freestyle Soda Program for Royal Caribbean $25M Spend

Implemented Fleet wide transition from Steel Beer Kegs to collapsible PET Beer Kegs $20M Spend

Provided 27% YoY reduction on spring water program $1.8M Spend

Provided 10% YoY reduction on Cost Savings Initiative for Produce and Dairy commodities $80M Spend


AWARDS & ACCOMPLISHMENTS

Team Excellence Award | 2019

Positive Attitude Award | 2015

Captain Corporate Award | 2015

Team Excellence Award | 2012

Employee of the Month | May 2005 & October 2007

Top Achiever Annual Review | 2005 & 2007

Prior Work Experience

Sales Associate Pro Audio | Sam Ash Music Store | Doral, FL. | 2003 - 2003

Assistant Engineer/Engineer | RMP Recording Studios | Orlando, FL. | 2001 - 2003

Export Specialist | Paddington Paper & Supplies | Miami, FL. | 1999 - 2000

Assistant Manager | PressStock | Miami, FL. | 1996 - 1999


EDUCATION

Florida International University, Modesto A. Maidique Campus | Miami, FL

Bachelor of Science Degree in Information Technology | GPA: 3.3

Miami Dade College, Wolfson Campus | Miami, FL

Associate of Science Degree in Computer Networking Technology | GPA 3.3

Associate of Arts Degree in Business Administration | GPA: 3.3

Full Sail Real World | Winter Park, FL

Associate of Science Degree in Recording Arts |  GPA: 3.8

Full Sail University Perfect Attendance Award

Internship at Walt Disney Entertainment, Music Department  

Musical & Artistic Endeavors

icastillo472@gmail.com | www.linkedin.com/in/ivan-castillo-8aa01865