Resume - CV

Alejandra María Ávila Pérez Industrial Engineer & Data Analyst

PROFILE

EDUCATION

As part of the P&G IT Vendor Management Office (VMO). The role provides support to different users (GBS - GBU - IT) that require to improve current processes/tasks in terms of automation, developing solutions using the Microsoft power platform (Power BI - Power Automate - Power Apps). Data Analytics, data management, develop Dashboards to visualize KPIs, metrics and measures.

Instituto Tecnológico de Costa Rica (TEC)

Additional Experience:

Universidad Fidélitas

Accounting Area: accounting cycle, payable accounts, receivable accounts, Inventories, etc.

Quality Control: collaboration in the project "Quality and Food Safety Management System" Central American Technical (FSSC-22000 Regulations RTCA) in San Rafael Rendering Plant (Cargill).

Training as financial services advisor taught by Banco Popular about 4 weeks (April 2014), management of securities (Cash and other financial instruments).

HSBC CR (Today Davivienda) in Investment Funds - Back office.

Experience as an internal audit assistant (ISO9001: 2015), quality management system and quality reports, compliance indicators as well and experience as a team leader.

CONTACT PHONE: (506) 8569-9719 LOCATION: San José, Costa Rica.

EMAIL: alejandra.avilaperez@gmail.com

HOBBIES Rugby player and referee Running Hiking Cycling Watch movies

LANGUAGES

April 06-2021 – In progress (Scholarship from MICITT)

Data Science (Specialization)

Universidad Internacional de las Américas (UIA) 2017 – 2021

Degree in Industrial Engineering July 2020 – In progress

Big Data Specialization Universidad Fidélitas

2016 - 2017

Control Quality Technician

WORK EXPERIENCE Grupo Preseleccion Ely / Supplier Governance PMO / Customer Support III - Data Management (Contractor – Procter & Gamble) 04/03/2019 – 01/31/2021 // 02/01/2021 – Ongoing (respectively) As part of the P&G IT-Vendor Management Office (VMO). This role provides support to different users (GBS - GBU - IT) that require to improve current processes/tasks in terms of automation, developing solutions using the Microsoft power platform (Power BI - Power Automate - Power Apps). Data Analytics, data management, develop KPIs, metrics and measures.

Additionally, the role manages some other subprocess listed below: 1. SRV Admin - SRV is a tool where the IT Resource Units (RUs - Volume) are processed and approved on monthly basis. The RUs are approved per the Owners and the SRV admin runs the process and complete the follow ups.

2. CSAT Surveys (SOBR and SPMS): The surveys are launched depending of the frequency (quarterly - annual or semi-annual). The purpose is to evaluate the performance for P&G suppliers within the scope of the VMO (Vendor Management Office), such as: Accenture, HP-DXC, Oracle, Cisco, Verizon and others.  Issue escalation/resolution.  Report and dashboard in Power BI.

Infotree Services / Supplier Governance PMO (Contractor - P&G) 04/03/2018 – 04/02/2019

As a supplier governance PMO, I collaborate with GBS Project Managers, Subject Matter Experts, Service Managers, Sourcing Buyer and Finance Managers by acting as liaison to suppliers. I also provide training and guidance for engagement process as needed, always in adherence to internal controls policies to comply with company requirements.

As global contact this role also requires doing all the quality checks of the projects and ensuring clear communication with all requestors. The role also requires working with P&G supplier contacts to execute activities such as:  Billing / Change Requests  Issue escalation/resolution  Report and dashboard creation in Power BI

Alejandra María Ávila Pérez Industrial Engineer & Data Analyst

IT Skills / TRAINING

 Microsoft Excel 2016-Advanced: • Power Pivot • Power Query • Visual Basic & SQL  Power BI - Advanced: • Data Analytics • DAX Functions • DAX Studio • Data Bases  Microsoft Power Platform: • Power Apps - Intermediate • Power Automate - Intermediate  R Programming – Intermediate  Python Programming – Intermediate  SAP Business One – Hana  Visio: Flowcharts – Diagrams  Minitab 19

Awareness in Microsoft Azure and Tableau.

REFERENCES

Jose Barrantes, Supervisor GPS – P&G Account.

Tel: (506) 2204-1816 / Mobile: (506) 8823-2583 Dannel Quesada, Contract Owner.

Vendor Management Office – Procter & Gamble.

Tel: (506) 2204-0132/ Mobile: (506) 8834-4836 Mario Leon, P&G Boomi Integration Engineer.

FPSS – Procter & Gamble.

Tel: (506) 2204-1986/ Mobile: (506) 8330-5812 Jaime Salazar, Vendor Relationship Manager.

Vendor Management Office – Procter & Gamble.

Tel: (506) 2518-6433 / Mobile: (506) 8823-8629 David Espinoza Bonilla, Contador General.

(Plantas & Flores Ornamentales CABH) Tel: (506) 2518-6433 / Mobile: (506) 8823-8629 Carlos Córdoba G., Gerente Recursos Humanos. (Humantech S.A.) / Outsourcing IS Corporación S.A. y Plantas & Flores Ornamentales CABH Tel: (506) 2273-4692 / Mobile: (506) 8815-0397

Cargill Latin-American / Intern Quality Control (practice)

08/2017 - 11/2017 Quality and Food Safety Management System - FSSC 22000 Provide support to the quality department in the formalization and creation of: Quality Manual, HACCP Safety Hazards Manual, procedures, job-aids and forms, reports and Flowcharts.

Grupo Mundo del Atletismo S.A. / Warehouse Responsable

05/2014 - 06/2017 Responsible for all the processes of entry and custody of merchandise, as well as the dispatches to retail stores of the corporate group and wholesale customers. Creation of SKU codes in SAP. Responsible of several reports: Inventory, Clothing, accessories and shoes.

Sales: daily and monthly

I.S. Productos de Oficina C.A. S.A. / Operations Manager Assistance 10/2012 - 02/2014 Function: Internal Auditor ISO Standard: 9001-2015.

Collaboration in Quality Management ISO Standard: 9001-2015.

In charge of coordinating Infrastructure expenses and corporate maintenance plan. Responsible for Reporting the Quality Indicators of the QMS processes.

Other tasks: To coordinate external and internal training.

Management and supervision of personnel as well as managing occupational health requirements.

Collaboration of the Project Digitization of files and information of evaluations of collaborators - Docuware. Support work for the IS Corporation Commercial Model Project (Sales).

Plantas & Flores Ornamentales CABH SA / General Accountant Assistant.

06/2008 - 09/2012 Function: Responsible of reviewing and reconciling air freight costs (DHL).

In charge of accounts payable suppliers, supplier registration, supplier payment transfers.

In charge of review and control of fixed assets, closing of fixed assets and depreciation accounting records. In charge of petty cash audits, local sales review, sales tax report preparation, supplier payment transfers.Review and analysis of SGC information.

SOFT SKILLS Fast Learner.

Experience in accounting and finance have made me a very trainable person always willing to take constructive criticism to improve.

Proactive.

Always a step ahead anticipating potential issues and creating new solutions.

Team Player.

The teamwork must be always on top of an individual effort.

Working with multifunctional teams.

Solve problems, ability to work under pressure.

Imagination and creativity.

Alejandra María Ávila Pérez Industrial Engineer & Data Analyst

ACHIEVEMENTS Developer of the CSAT & 3PG Oversight Dashboards Power BI - Dashboard

Customer Satisfaction Surveys, IT-Projects, Amendments (CRs), Purchase Orders approval and payment process in Coupa Host, KPIs and signatory approval timings.

Developer of the CLM Metrics & Statistics (Coupa) Power BI - Dashboard

Metrics and measures related to the contract requests, SOW (contracts), Amendments (CRs), Purchase Orders approval and payment process in Coupa Host, KPIs and signatory approval timings.

Developer of the Spending Report - Power BI Dashboard

Designed to provide visibility to our sourcing buyers in terms of ownership and the tracking of all the spending with our supplier for the last 3 Fiscal Years.