Monica Rossetti
Ventura
Summary
Solution-oriented, self-driven and passionate about helping your organization succeed by drawing together and tracking key business metrics and insights to drive business decisions and strategy. Adept at cross-departmental collaboration and improvement of business processes, while conducting complex data analysis on goals and targets outcomes. Fluent in English, Spanish, Portuguese.
Overview
26
26
years of professional experience
1
1
Certification
Work History
Commercial Director Cruise
Virtuoso, LLC
Fort Worth
04.2022 - Current
- Pioneered an analytical platform to track and forecast pacing towards contracted goals
- Developed comprehensive Tableau dashboards to communicate to members and partners needed sales strategic focus for achieving KPIs and goal targets
- Achieved 50% YOY increase in number of goals achieved and associated bonus commissions during first year
- Conducted revenue forecasts and projections based on several analytical data points from cruise lines such as past and current sales patterns, peer set analysis, booking windows, cancellation rates, price evolution and market trends
- Developed performance analysis and growth opportunities reviews for cruise partners which were praised as 'first in class' among travel industry executives and stakeholders
- Created compelling commercial business reviews for annual strategic meetings with top accounts, representing +$1B in revenue sales
- Led sales targets negotiations with partners for regional and global/international channels
- Oversaw the contracting process and engaged in contracts reviews and negotiations with 40+ partners
Senior Business Intelligence & Data Analyst, Sales
Crystal Cruises LLC
Miami
05.2019 - 01.2022
- Generated complex custom reports summarizing and tracking business and financial KPIs for use by executives, managers, business partners, and other stakeholders (revenue goals and targets, executive bonuses, sales trends, etc.)
- Created tools for monthly and annual revenue/sales forecasting
- Demonstrated ability to uncover data-driven insights
- Played a pivotal role in saving the organization millions of dollars identifying areas of financial exposure and high material risk through complex data analysis of guests and travel agents’ credits, commissions, and refunds exceptions
- Produced automated tools and dashboards to support decision making at the strategic level
- Provided ad hoc support of research or investigation into emerging trends and rapidly changing business conditions, especially during the extreme challenges presented to the industry due to the COVID pandemic
- Participated in internal audit task force to map and identify defects in processes and systems functionality by building analytical tools that allowed progressive pinpointing and follow-up of cross systems/departmental issues
Business Intelligence Consultant
Crystal Cruises LLC
West Los Angeles
05.2016 - 03.2019
- Fleet wide Crystal Reports development: guest/crew invoices, accounting, revenue reconciliation, operational reports automation
- Data clean up, analysis and validation across shore side and fleet side systems
- SSRS reports development, requiring multiple systems data sources integration across ORACLE and SQL databases
- Developed main ETL process between shore reservations system and onboard Property Management System (Hotel)
- Interfaced with Oracle support to trouble shoot, report, and test fixes to data transfer anomalies
.NET Senior Software Developer
Crystal Cruises LLC
West Los Angeles
04.2006 - 03.2016
- Supported, maintained, and enhanced guest-facing websites (Priority Check-in Center) for guests pre-boarding check-in and multiple services reservations
- Developed and maintained document platform (XLS, XSLT and WCF) to standardize all system generated corporate emails to guests and travel agents as well as international authorities guest clearance interfaces (XML, SOAP)
- Created and maintained stored procedures, tables, functions, triggers, and scheduled jobs in SQL server
eCommerce Developer Internet Order Center
B3 Corp
Burbank
05.2000 - 04.2005
- Developer, turnkey E-commerce platform for merchants for complete back-office management and administration including orders, shipments, invoices, accounting reports, batch credit card authorization and order settlement, etc
- Technology used: ASP, VB Script, Visual InterDev, MTS, SQL 2000, DHTML, Visual Basic, XML, SQL DTS Packages, XML/SOAP based web services, .NET
Programmer/Analyst
Interscore
Culver City
05.1999 - 04.2000
- Developer, Internet E-commerce Order Center for BofA
- (VB, building COM+, IIS, Site Server Commerce Edition)
Education
Data Visualization with Tableau Specialization -
UC Davis
05.2022
Microsoft Certified Training - Implementing a Data Warehouse with MS SQL Server 2015
University of CA Extension
03.2021
MA - Clinical Psychology
Pepperdine University
CA11.2018
BS - Computer Science
FATEC SP – Universidade do Estado de São Paulo
Brazil12.1990
Skills
- Financial and revenue management and planning
- Contract revisions and negotiations
- Advanced Excel
- Integration of multi-system databases
- Comprehensive state of business dashboards
- SQL
- Stored Procedures
- Crystal Reports
- ETL
- Data visualization with Tableau
- Tableau Desktop
- Tableau Prep
- Tableau Cloud
Certification
- Tableau Desktop Specialist Certificate, Tableau, 03/01/22
- Data Science Certificate, University of California Irvine, 04/01/21
Languages
- English
- Spanish
- Portuguese
Personal Information
Title: Commercial Director (Analytics)
Portfolio - Data Science
- Https://drive.google.com/drive/folders/1KOSKpkm8XlnLGe76qx6jJoDjV7nIvA_x?usp=sharing
- Https://drive.google.com/drive/folders/1JuDuZiw12ETCK6TvL9EAoiMOWZTn8ivm?usp=sharing
Languages
English
Professional
Spanish
Professional
Portuguese
Professional
Timeline
Commercial Director Cruise
Virtuoso, LLC
04.2022 - Current
Senior Business Intelligence & Data Analyst, Sales
Crystal Cruises LLC
05.2019 - 01.2022
Business Intelligence Consultant
Crystal Cruises LLC
05.2016 - 03.2019
.NET Senior Software Developer
Crystal Cruises LLC
04.2006 - 03.2016
eCommerce Developer Internet Order Center
B3 Corp
05.2000 - 04.2005
Programmer/Analyst
Interscore
05.1999 - 04.2000
Data Visualization with Tableau Specialization -
UC Davis
Microsoft Certified Training - Implementing a Data Warehouse with MS SQL Server 2015
University of CA Extension
MA - Clinical Psychology
Pepperdine University
BS - Computer Science
FATEC SP – Universidade do Estado de São Paulo
Similar Profiles
Bibek BarikBibek Barik
Financial Analyst at Virtuoso Outsourcing Consulting Services LLPFinancial Analyst at Virtuoso Outsourcing Consulting Services LLP
Kara HeaslipKara Heaslip
Senior Coordinator at Virtuoso AustraliaSenior Coordinator at Virtuoso Australia
Penelope TaylorPenelope Taylor
DIRECTOR EVENT CONTENT & MARKETING at VIRTUOSODIRECTOR EVENT CONTENT & MARKETING at VIRTUOSO