Looking for a job

John Guerra

@johnguerra

Data Analyst at MyKey Global Accommodations who developed interactive hotel performance dashboards for better decisions.

Guatemala

Message

At MyKey Global Accommodations, I analyzed data to support business strategies and developed interactive hotel performance dashboards to improve decision-making and operational efficiency. I also provided insights for optimizing revenue and resource management.

Previously, I was promoted to Hotel Coordinator and Operations Team Leader, and worked as a Logistics Coordinator and Customer Service Rep - Subject Matter Expert. My experience includes SQL, Power BI, Salesforce, performance management, and customer support.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst

Current

MyKey Global Accommodations

Aug 2024 - Present (2 years 2 months)

Analyzed data to support business strategies, utilizing pivot tables and advanced tools like Power BI. Developed interactive hotel performance dashboards to enhance decision-making and operational efficiency.

Data Analysis Power BI Pivot Tables Dashboard Development Revenue Optimization Resource Management

Hotel Coordinator

MyKey Global Accommodations

Mar 2024 - Aug 2024 (5 months)

Ensured customer satisfaction by overseeing reservation processes and addressing client needs. Streamlined operations by coordinating with Hotel and Account specialists and managed payment authorization processes.

Customer Satisfaction Reservation Management Payment Authorization Coordination Compliance

Customer Fulfillment Associate

MyKey Global Accommodations

Sep 2023 - Mar 2024 (6 months)

Processed customer orders and ensured timely fulfillment for a seamless experience. Assisted in resolving customer inquiries and supported credit card processing and accommodation procedures.

Order Processing Customer Service credit card processing Cross Functional Collaboration

Logistics Coordinator

Lean Solutions Group

Jul 2023 - Sep 2023 (2 months)

Monitored and tracked logistics activities, ensuring timely and efficient operations. Provided after-hours support and collaborated with logistics teams to optimize transportation and client satisfaction.

Logistics Supply Chain Transportation Customer Satisfaction After Hours Support

Operations Team Leader

Telus International

Oct 2020 - Jun 2023 (2 years 8 months)

Led and developed a team of customer service representatives to achieve performance goals. Analyzed metrics to implement improvements and enhanced customer satisfaction through high-quality service.

Team Leadership Performance Management BPO Operations Customer Satisfaction Metrics Analysis

Customer Service Rep - Subject Matter Expert

Telus International

Dec 2018 - Oct 2020 (1 year 10 months)

Resolved client issues with assertive communication and technical expertise in Salesforce. Acted as a SCRUM leader, managing cross-functional teams in agile projects and conducted root cause analysis.

Salesforce Scrum Agile Root Cause Analysis Customer Service Cross Functional Team Management

Education

Degrees, certifications, and relevant coursework

Universidad Galileo

Bachelor of Technology, Computer and Information Sciences

2019 -

Pursuing a Bachelor of Technology in Computer and Information Sciences with coursework in System Administration, SQL, and Data Analysis.

Microsoft

Harnessing the Power of Data with Power BI, Data Analysis

Completed the Harnessing the Power of Data with Power BI certification, covering SQL, Power BI visualization, and data analysis.

LinkedIn Learning

Business Analysis Foundations, Business Analysis

Completed the Business Analysis Foundations certification.

Microsoft

Preparing Data for Analysis with Microsoft Excel, Data Analysis

Completed the Preparing Data for Analysis with Microsoft Excel certification, focusing on advanced Excel for data preparation and analysis.

Colegio Bilingüe Campo Verde

High School Diploma, Science and Letters with Computer Orientation

2016 - 2017

Activities and societies: Academic leadership, basketball team, and extracurricular courses.

Completed a High School Diploma in Science and Letters with Computer Orientation, participating in academic leadership, basketball, and extracurricular courses.