08/11/2024 updated
100 % available
Data Analyst
Buga, Colombia Industrial engineer
Sql Server Data Tools (SSDT)Data AnalysisAutomationBig DataCalculationsComputer ProgrammingDatabasesData VisualizationFinanceExcel FormulasExcel MacrosExcel Pivot TablesPython (Programming Language)MySQLPivot TablePower BISAP ApplicationsSimulationsSQL DatabasesStatisticsWeb ApplicationsExcel SolverMacrosVba Programming LanguageSAP AribaData Management
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.
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.
Languages
EnglishGood
Project history
- 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.
- 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
- database.Development of an optimization tool to generate the work plan of the logistics area based on the production plan of the 7 production plants