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.