Guilherme Cruz

Backend API development in ADVPL language (Totvs Protheus) and interface using Angular framework and PO UI library. Intranet website design and development using Sharepoint Designer, HTML, CSS, Javascript and AngularJS framework. Power BI report development, gateway connection configuration and incremental refresh scheduling for several reports such as Accounts Receivable/Payable, Sales, Imports, Inventory, using SQL, Python and Power Query for ETL.

Stock projection by product category and line of business, considering past sales statistical analysis and strong alignment with sales managers Power BI reports/development, with SQL queries, using Power Query M and DAX functions, for information on sales, revenue, costs, margin, simulation and KPIs, bringing more visibility to the company and identifying improvement opportunities

Responsible for invoicing and delivery process, import schedule and reports to the sales team Import schedule of all products and follow up until arrival Quarterly forecast report for non-GMO production Focal point between the Import department and the sales team, monitoring not only the product clearance but also changing the orders due to forecast reviews Inventory management in São Paulo, Paranaguá and Curitiba, with FEFO control, inventory levels, orders, sales forecast and inventory turnover

Sales, inventory and import demand analysis S&OP review with commercial managers Negotiation with product managers in the USA, regarding volume, plant capacity and lead time Database development and reports connecting Access and other reports in Excel, for better access to the information for the sales team Report development, using PowerBI sofware, integrating information directly from ERP system database (JDE Oracle and Origin) and also Excel spreadsheets with customers, products and sales forecast

Support to the sales team, Key Account manager and Trade Channel clients Price and margin calculation for all SKU’s, considering taxes and updating prices in the system Database creation to support Sales Analysis and reports Database management for reports and information Reponsible for creating reports on Cognos, using Report Studio Internal Auditor (SGS Certificate), auditing other departments (NQMS, based on ISO 9001 and 22000) and in the department (NGA) – continuous improvement focus

Statistics, Logistics Projects Evaluation, Production Management, Storage and Distribution, City Logistics, Logistics Systems Simulation, Decision Support Systems