Diego Toro Montoya

Creation of 11 Business Management Modules with Excel Forms Connected to Access using SQL Statements.

Conversion of Unstructured Data from CSV to Structured Data.

Some Modules Created from Scratch:

Articles, Services, Costs, Clients, Suppliers, Orders, Inventories, Projects, Budgets, Delivery Notes, Invoices, Conversion of Unstructured Data from CSV to Structured Data in Access, etc...

I am a Developer of Programs in Excel (VBA for Excel Macros)

I Create Management Indicators using Excel Forms connected to Access Databases.

I have 20 years of experience creating programs for the Supply Chain.

Connecting Merchants, Manufacturers, and Distributors (Retail) to EDI, ERP platforms with VBA Macros. I use Power BI, Power Query, Power Pivot.

DAX, XML, HTML, CSS

Some Management Indicators created with Excel Forms with VBA Macros for Supermarkets and Distributors:

Orders, Purchases, Sales, Inventories, Costs, Prices, Service Level, Planograms, Space Profitability on Shelves, Return on Investment, Display Index, POS Analysis, Offer Success Analysis, Out-of-Stock Items Analysis, Active Portfolio Analysis, Price Differences, Sales Loss due to System Errors, Elaboration of Planograms, Elaboration of Supermarket Section Layouts, Space Occupancy Index, Sales Analysis in Hot Zones, Sales Analysis by Changes Made in Sections and Shelves, Database Alignment between the Supermarket and Suppliers, Sales Comparisons of Different Businesses, Participation Percentages, Sales per Square Meter, Sales per Employee, Sales per Section, Sales per Shelf, Sales per Location within the Shelf, Competitor Price Analysis, Pareto Supplier Sales Analysis, Pareto Business Plan Analysis with Suppliers, Analysis of Active Inventory Days vs. Space, Analysis of Time Worked by Promoters and Merchandisers vs. Sales, Cost to Serve Merchandisers, Purchases vs. Payments to Suppliers. Sales vs. Profit Ranking of Franchises, Distributors, Final Consumers, Brands, Suppliers, Categories, Subcategories, Segments, Groups, Among Others.