Learn Data Skills
Beta
Carlos Fernando Aguirre Toro

Carlos Fernando Aguirre Toro

Data Analysis Specialist

PGD Latam | Medellín

Technologies

My Portfolio Highlights

My New Course

Understanding Data Engineering

My New Course

Understanding Data Engineering

Quantitative detective, solving mysteries and uncovering truths in data.

My Work

Take a look at my latest work.

course

Introduction to Relational Databases in SQL

course

Introduction to SQL Server

course

Understanding Data Engineering

course

Introduction to Relational Databases in SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Intermediate SQL
Joining Data in SQL
Understanding Data Engineering

My Work Experience

Where I've interned and worked during my career.

PGD Latam | May 2022 - Present

Data Analysis Specialist

Provide solutions to Client custom reporting needs as well as guide them on the use of said reports. Overtake reporting development initiatives using Power BI, AWS Quicksight and Tableau (to a lesser extent) Partner closely with business and technical teams to translate business requirements into visualization dashboards. Modernize, eliminate or condense existing outdated reports and dashboards and rewrite processes (media performance dashboards for impressions, clicks, completion rate, ctr, etc.) Share reports against agreed-upon rhythms whilst also delivering ad-hoc insights and analysis to meet specific business requirements. Document functionality, procedures, and best practices for use by both clients and internal resources Basic ETL for reporting using SQL, Alteryx, and ocassionaly Power Query Transforming data into business insights.
Show More

Solvo Global | Apr 2021 - Mar 2022

Coordinador Power BI

Support Turia Group leadership on custom reporting needs as well as guide them on the use of various reports Lead reporting development initiatives. Analyze user requirements and based on findings, design specifications for BI front-end. Partner closely with business and technical teams to translate business requirements into specifications and build visualization dashboards. Modernize, eliminate or condense existing outdated reports and rewrite processes. Plan and structure workloads according to projects and priorities. Share reports against agreed-upon rhythms whilst also delivering ad-hoc insights and analysis to meet specific business requirements. Perform daily monitoring on reports to ensure operations are not interrupted. Supervise report developers.

Virtuagym | Oct 2020 - Mar 2021

Data Quality Manager

Market lists across countries. Enrich account and contact information for Sales purposes. Improve the accuracy of Virtuagym's Contact and Company Data. Buy / Collate data sets to help maintain accuracy and up-to-date understanding of our market. Structure team processes (procedures, KPIs, quality standards). Plan and structure workloads according to projects and priorities. Supervise data entry. Assist in improving internal tools and processes. Boost professional development through onboarding, training, feedback and review.

Unilever | Mar 2019 - Jul 2020

Secondary information specialist

Secondary data analysis, reporting, as well as inventory and sales tracking for Customer Development Operations (CDO) in Middle Americas. Generate weekly and monthly Metrics to track trends and changes in Sales and Inventory, as well as Salesperson effectiveness. Ensure data accuracy through the creation of data integrity queries. Track differences between ERP and Unilever secondary information systems, using tools such as Excel VBA and Power Query. Refer information for corrections. Functional support for the roll-out of the Ecom ERP system in Acosucre, one of Unilever's distributors. Serve as primary liaison between the End-user and Unilever as well as Ecom during go-live. Manage individual cases to ensure appropriate escalations and timely closure.

Avianca | Nov 2015 - Jul 2018

Analista de Incorporación de Sistemas

Analyst for the implementation of software systems for Crew Planning and scheduling, as well as reporting. Validate and align system functionality with the business needs in order to guarantee the company requirements are met, while ensuring the project execution is carried out within the established time frames. Train end-users on the use of the implemented systems. Build operation-related reports using Excel and Power BI Create reference materials. Conduct small group and individual training sessions based off demand. Impart training, content delivery.

Avianca | Jun 2014 - Nov 2015

Analista de planeación de entrenamiento

Training Planning and scheduling for pilots and copilots from Colombia and Central America. ATR-72/600 Full Flight Simulator occupation provision and arrangement. Ensure all of the pilots and copilots comply with the training requirements mandated by the Colombian Aeronautical Authorities (UAEAC). Schedule daily, weekly and monthly training sessions. Maintain a record of the training sessions performed. Manage the training simulator availability and ensure its occupation. Construct the yearly training budget based on previous yearly trends.

SAP | May 2012 - Mar 2014

Data Quality and Contact Improvement Analyst (c-user)

Data quality analysis and contact improvement for marketing. Develop and execute data cleanup measures on the company customer database using Excel. Ensure adherence to data quality standards. Analyze and manipulate data according to defined business rules and procedures in order to provide an accurate customer database segmentation for Marketing efforts. Serve as a functional test user for the contact de-duplication tool. Ensure data quality efforts are reflected in the SAP CRM Web environment

Tecnoinformatica Latinoamerica S.A. | Jan 2011 - Apr 2012

Analista Mesa de Ayuda SAP-Comfandi

Telephone and email support for SAP ERP users from the "Caja de compensacion del Valle COMFANDI" . Elaboration of weekly and monthly service-level reports using Excel.

My Education

Take a look at my formal education

Specialization in Financial Management, Finance and Financial Management ServicesUniversidad Católica de Colombia | 2014
Bachelor's degree, EconomicsUniversidad La Gran Colombia | 2009
High School, Bachiller AcadémicoColegio Bilingüe Internacional del Quindio CBIQ | 2000

About Me

Carlos Fernando Aguirre Toro

https://www.linkedin.com/in/cfatls/

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free