Mauricio Sanchez

Buga

available

Last update: 11.08.2024

Data Analyst

Graduation: Industrial engineer

Hourly-/Daily rates: show

Languages: English (Limited professional)

Keywords

Vba Programming Language SQL Databases Data Analysis Computer Programming Databases Python (Programming Language) Pivot Table Macros Data Management Sql Server Data Tools (SSDT) + 16 more keywords

Skills

Professional with experience in statistical analysis of data related to the purchasing of direct materials, indirect services, and Capex, generation of cost structures, trend analysis, variations, and budget construction.

I have knowledge and experience in advanced Excel, including macros, programming code in Excel (VBA), task automation, indicator calculations, pivot tables, and designing customized tools to optimize processes, generate financial simulations, comparative quotes, cost structures, statistical analysis, generation of scripts for automatic and periodic task execution, and solid knowledge in SQL database management and data analysis using Python.

Project history

12/2020 - Present

BIG DATA ANALYST PURCHASING GROUP QBCO

QBCO (Consumer goods and retail, 1000-5000 employees)

Statistical analysis of databases for the 4 companies in the QBCO group, focused on analyzing volumes, prices, suppliers, commercial categories, purchasing categories, consumption, and payment terms.
Design of dashboards in Power BI, indicators, with monthly results from the area.
Periodic reports and presentations for the Negotiations Management.
Process automation through Excel programming using macros and VBA.
Monitoring, generation, reporting, and identification of improvements in indicators for the Purchasing and Negotiations Management.
Strategic support for the negotiation of raw materials and packaging.
Management of Master Data for Negotiations within the QBCO Group.
Comparison of impacts on the cost structure of finished products.
Bulk uploads of price lists.
Management of quotation and bidding events through the SAP ARIBA platform.
Conducting national and international market research in databases to model the best supply scenarios for the group.
Management of negotiation, planning, and cost databases.
Design of the QBCO Group Negotiations area Dashboard, in Power BI, for decision making, indicators and strategic information for decision making in the negotiations and purchasing area.

work Achievements

(vba excel) Tool for the automation of supplier evaluation
(vba excel) Tool to simulate cost structures of finished products.
(vba excel) Tool to automate comparisons between quotations and identify the best alternative for multiple materials and suppliers.
(vba excel) Cost Master Data with periodic automatic updating
(vba excel) Tool to automate the extraction of information from purchasing master data
(vba excel) Tool for import simulation and tracking
(vba excel) Tool for mass automation of prices in master data.
(vba excel) Automation, standardization and enhancement of multiple files with macros and programming code.

03/2018 - 11/2019

LOGISTICS ASSISTANT

Carval de Colombia (Pharmaceuticals and medical technology, 500-1000 employees)

Automation of tasks and analysis through formulation and programming in Visual Basic Excel.
Scheduling of materials enlistment and delivery activities, based on the productive demand on a monthly, weekly and daily basis using Excel programming.
Generation of weekly and monthly indicator reports for the logistics, production, planning and maintenance departments.
Statistical analysis of databases by areas.
Support to the planning area in management and analysis of the maquiladora products

Work Achievements