ANDRES ERNESTO LOPEZ PEDROZA

Mobile: +573********* – Bogota/Colombia

adjljp@r.postjobfree.com – Skype ID: anlopez10

PROFESSIONAL PROFILE

Bachelor Degree in Business Management with Posgraduate degree in Business Intelligence Project Management, experience applied to different departments like sales, budget management, operations, logistics, finance, credit & risk, portfolio management, business development, marketing Intelligence, revenue management, pricing and competitive intelligence, customer experiencie and services, skills in business Intelligence, projects management, data engineering, data modeling, data mining and transformation. Planning, development and start up of dashboards, translating business needs in analysis tools, on desktop, web and mobile enviroments, leading ETL processes with different platforms for data transformation. PLATFORMS AND TECHNOLOGY EXPERIENCE

Data Visualization: Power BI, QlikView, QlikSense, Tableau, Microstrategy, Excel, Power Query, Power Map, Power Pivot, SAP BO, Crystal reports, Oracle BI, Google Datastudio, Google Spreadsheets.

Data Processing and Modeling: Microsoft SQL Server 2008, 2012, 2014, Oracle Developer, Azure, SAP Hana, Microsoft Access, Google BigQuery.

Project Management Experience: MS Project, Trello.

Customer Experience Platforms: Zendesk.

CRM experience: Siebel, Oracle OnDemand, Salesforce, Google Zoho.

ERP experience: SAP PSCD, SAP CRM

Specific industry software: IMS Pharmaceutical Data, Marsha, Opera PMS, Zeus, Marriott HCM, Merlin, STR (Smith Travel Report), Travel Click, Latitude (CCL), iCare (CCL).

Certifications: Crisis Management & Human Behavior Training - Exp. Date: 09/24/2024, Passanger Ship Crown Management Training – Exp. Date: 09/17/2024 WORK EXPERIENCE

Company: Carnival Cruise Line

Title: Guest Services Associate

From: August 2019 to Present

Duties: Assistance, interlocutor and follow up to guest related with inquiries, complaints, needs and requirements until final resolution as per guidelines of CCL. Responsible of telephone requirements and needs of the guest, and handle with other areas. Responsible and participate in handle and resolution of essential process of the area related with: lost and damage luggage, back to back guest, executives reports, lost and found items. Knowledge and responsible of night shift reports and management on duty. Responsible in charge of handle and follow up during stay of Guest with special needs. Company: Oxohotel

Title: Customer Intelligence Coordinator

From: November 2016 to August 2019

Duties: Deparment head, in charge of all ETL processes and data consolidation for all hotels operated, data quality assurance, implementation of Data Governance Policy, planning and development of data interface among 19 databases developed under Oracle technology, planing, development and maintanance of dashboard alinged to business needs and corporate goals and strategies, design and development of statistical, forecasting and probabilistic reports conform the Market, competitive and revenue Intelligence. Company: Getronics

Title: Applications Developer I

From: July 2015 to October 2016

Duties: Team leader of Metrics and Indicators Area, in charge of quality assurance of databases, planning and development of data interfaces among different business platforms like CRM, Operations software and Sales software, planning and development of dashboards aligned to management need, quality assurance of indicators measurement process, maintanance of data process driven company standards and data governance policies. Company: Cable and Wireless

Title: Customer Service Analyst

From: May 2014 to May 2015.

Duties: In charge of department’s data analysis process, leading different process like budgets, sales loyalty, leader of ETL process from different sources like CRM (Salesforce, Oracle on Demand) and SAP, creating data connections using SQL, Excel and Access. Development of dashboard for controling sales goals and service quality. Company: Proximity (BBDO Global)

Title: Database Marketing Analyst

From: Dec 2013 to Apr 2014

Duties: In charge of data engineering, data mining and data modeling, planning, development and implementation of ETL processes from different sources, planning, design, implementation and maintenance of dashboards focused to measure indicators and KPIs translating business needs on strategies for build up Market penetration, revenue, sales efectiveness and marketing campaings investment return (ROI). FORMAL EDUCATION

POSGRADUATE DEGREE IN BUSINESS INTELLIGENCE PROJECT MANAGEMENT POLITECNICO GRANCOLOMBIANO

2017-2018

BACHELORS DEGREE IN BUSINESS MANAGEMENT

UNIVERSIDAD NACIONAL ABIERTA Y A DISTANCIA UNAD

2010-2016

LANGUAGES

Spanish, level: Native

English, level: Fluent

ANDRES ERNESTO LOPEZ PEDROZA

C.C. 111*******

Contact this candidate