Erick Knackstedt Email and Phone Number

Solve organizational information challenges and requirements by analyzing needs, designing programs, and recommending business system controls and protocols. • Presented a current state analysis with a future state roadmap to ownership with strategic objectives, KPI’s, and a weekly KPI tracking program.• Conducted deep-dive analysis on 5 years of transactional data as part of the preparation for the current state analysis; resulted in a segmentation model for commercial distribution and supplier management, as well as identification of metrics to use as KPI’s. • Developed KPI’s and implemented weekly KPI tracking for all local departments.• Deliver weekly KPI dashboards and reports across the organization to drive analytics and optimization efforts. • Developed a data model for business’ commercial activities and assets using SQL queries, DAX measures, Power BI dashboards, and Excel reports. • Lead a team of yield analysts in optimizing commercial distribution for over 1,000 hotels through 30+ vendors into 20+ customer markets.• Developed multi-year commercial yield optimization roadmap; program in Power BI and Excel drives yielding companywide.• Risk analysis and mitigation with a custom-built tracking program developed in Power BI; custom metrics and visuals based on risk type in context of the project. • Mentor team members by developing and teaching beginner, intermediate, and advanced excel courses; over 30 team members trained, and the program was featured in HR corporate newsletter. • Developed a new ERP software project roadmap which included milestones, deliverables, resourcing, dependencies, development, escalation and communication.• Conducted deep-dive analysis to produce a value assessment for the business case, which included assumptions and scenario analysis.• Gathered functional requirements for new ERP software; over 15 capabilities analyzed, and dozens of interviews conducted with stakeholders.

Revenue management and yield optimization in $500M North American Bedbank unit, with accountability for over 800 hotels across the US • Created forecasting program in Excel to assist yield team in optimizing inventory and pricing; sourcing team adopted the program.• Designed report to align key accounts inventory exchange system with revenue targets; stakeholders incorporated report, recovering $18k in inefficiencies and facilitating reconciliation.• Developed performance metrics for use on a yield KPI dashboard; KPI dashboard adopted and now being rolled out as part of the corporate BI strategy.• Prepared forecasts and budgets for hotels to enhance their optimization of Hotelbeds products; portfolio consistently in the top 1% in both revenue growth and hotel satisfaction.• Presented analysis and reports to senior management and worked on ad hoc projects, including post-M&A data integration project, optimizing BAR contracts project, and minimizing operating costs project.

Led marketing, product development and strategic efforts supporting >$100m Latin American business.• Led strategic initiative to re-assess long-term Latin American sales strategy; recommendations progressed to next phase. • Achieved double-digit year over year growth in Mexico and Columbia, supporting the company’s strategic focus areas.

Led the design and production of management information reports, process flows and contract maintenance for $500M global destination development team.• Developed and implemented pricing process improvement solution within 3 months of identification of customer concerns; resulted in the ability to measure customer response time and customer satisfaction improved significantly.• Coordinated client office visits to ensure a positive impression of Hotelbeds; achieved over 50 office visits with 100% success rate of overall client impression and visit satisfaction.

Responsibility for loading contracts worth $300M in revenue while improving quality control.• Developed quality control recommendations and strategy to improve company loading procedure which was implemented.• Processed contracts to improve time-to-market; recognized for decreasing time-to-market by double digits leading to promotion.

Provide exceptional service to all Rosen guests, a premier hotel chain in the Orlando area.• Chosen to coach a team of 15 in service exceptionalism; guest satisfaction improved by double digits.• Broadened hotel and travel industry perspective and knowledge through direct associations with the owner, management, employees, and the guests themselves.

Provide culturally competent, holistic, and wellness-focused mental health services.• Guided clients in the development of skills, strategies, and interventions for dealing with their problems and challenges• Administered biopsychosocial evaluations to accurately diagnose disorders; accurate analysis led to strategic treatment plans• Achieved 97% success rate of overall client’s wellbeing and mentoring satisfaction.