Perfil_eng | visualmetrica

Juan Carlos Savini G.

ECONOMIST.

MGS BUSINESS MANAGEMENT

Planning. Business Analytics. BI Info Visualization.

Economist MBA Business & Administration

Planning. Business Analytics. Info Visualization & Reporting

+58 424 6980031

jcsavini@visualmetrica.com| gmail.com | hotmail.com

Summary

Consultant in business analytics, business intelligence and visual interpretation of indicators.
Visualmetrica®. 2008 – 2018. Owner.

Oil and Energy:Petroleos de Venezuela. 1989-2002.
Areas of performance:finance, administration, planning and management control.
• Divisional Finance Manager 1989 - 1993. Cost and budget analyst.
• Corporate transformation project 1993 - 1997. ABC cost consultant.
• SAP/PDVSA project. Sitereadiness Exploration and Production Business Unit. 1997- 2000.
• Planning Management. Technical secretary of the divisional planning committee. 2000 – 2002.

Governmental.Zulia Governorate. 2002-2010.

Areas of performance:planning, analysis and control of plans and projects.
• State Secretariat for Planning and Statistics. 2003 – 2010.
• Municipal Department of Planning and Statistics of the Municipality of Maracaibo 2009 - 2013.

business.Visualmetric. 2008 – 2018. Analytics and business intelligence consultant. Visual interpretation of corporate metrics.

Performance sectors:oil and energy, mining, logistics and distribution, technology, trade and union

• Chamber of Commerce of Maracaibo. Director executive 2016 – 2017.
• Other sectors: oil and energy, mining, logistics and distribution, technology, trade and trade 2008 – 2018.

Experience

Zoom International Services | Visualmetric.

Visual BI Consultant
Business Analytics | Information Display. Caracas, Venezuela 2016 - 2017
Sector: Trade | National and International Logistics.

• Cost project.Review and design of visual panels to improve control of labor costs, materials and production logistics. Generation of interactive panels with key indicators. Query design by activity, processes and cost elements.

• Analytics and visual interpretation.Cost Sankey (TD Cost). Design of interactive traceability panels for inputs, processes, activities and cost objects.

Exp

2010 - present

Minex LLC. Coal Thermal Board.

Coal Inventory Balance per week.
Purchases & Storage by Location and Ports.

eBox Logistics. 2019 – 2023

Business Intelligence and Data Visualization Advisor.

International Logistic.

• Business Intelligence platform conversion: 22 sets of panels designed in Power BI swapping to Tableau . Data extraction, verification, and migration to Tableau Desktop (@ 95 variables cross checked in13 data groups, and 18 hierarchies).
• Optimization. 22 dashboards (Power) BI, to 17 (Tableau). This optimization meant graphical simplifications performed using DataViz techniques and principles.
• Data visualization. Design and simplification of 17 dashboards for monitoring historical data and processes for: sales, reception, and processing of deliveries, mobilization, inventories, waybills, customers, lockers, declared value, and stores.
• GCP. Google Cloud Platform. Configuration and Connectivity of 17 dashboards and 11 views through GCP-Big Query.

eBox Logistics. Corporate Dataviz Platform.

Sales, Revenue, inventory, Operation by Country, Storage, Tons and Logistic and production Cost.

2010 - present

Grupo Serex | Millinton Coal International 2019

Analytics and Visual BI Advisor.

Energy. Coal and Thermal Cokes

• Cost controlling. Cost accounting model for Coal Business Unit, by core processes: purchases, reception, classification, and shipment; by cost elements: labor, materials, equipment, services.
• Data prep. Accounting reclassification and implementation of cost drivers and business rules for balance accounting charges to cost elements (ABC / TDC Cost Methodology).
• Reporting. Cost reporting modules: analytical summary, fixed and variable; by cost element, and process.
• Data visualization. All cost information was linked to Microsoft’s Business Intelligence ecosystem, using the Power BI gateways. This allowed improve the reportability and visualization of KPI indicators: cost per ton, overhead, fixed and variable costs index, pattern and trend cost evolution.

Millinton Coal International

Sales & Plan Dashboard
Cash Flow by Business Unit.

CIS Latam. Corporate Project 2019 – 2021.

Corporate Business Intelligence (BI) & Data Visualization Advisor.
1,400 points of sale in Argentina, Bolivia, Chile, Ecuador, and Paraguay.

Worldwide logistic and remittances.

• Western Union and DHL Business Units. 4 sets of panels with 45 dashboards containing transaction and revenue indicators and metrics for the Western Union and DHL business units. Time intelligence KPI (last year, last month, year to date, month to date, last & past week, and week to date). Users: Board of Directors, Country Managers, and Process Managers.
• Finance. Effectiveness KPI (revenue per transaction, per day, per business day) for WU and DHL business units.
• Compliance. 18 dashboards for control and visualization of data related to the CIS compliance indicators.
• Production & Services. 8 dashboards with georeferenced indicators (interactive maps), by country and city, WU and DHL business units (Country Managers and Regional Managers).
• Management. 4 sets of panels with 19 dashboards (KPI's and metrics of transactions & revenue for the DHL business unit).
• Marketing. Data processing for 2 sets of dashboards for Market Share CIS vs WU.
• Training. Delivery of 2 Power BI training cycles. 9 modules (content: introductory, ecosystem, canvases, visuals, data processing, connectivity to sources, dashboard and report design, web and mobile interfaces).

CIS Latam

Western Union / DHL Datawall by Country.

Grupo Zoom. Maracaibo - Caracas 2016 – 2017

Visual BI. and Cost controlling Advisor.

International Logistic

• Costs. 5 submodules for query and cost control of payroll expenses, inland operations, international operations, social security, operational monthly cost, and time transaction.
• Materials. Implementation of 4 control modules for the Equipment and Materials area: Vehicle Fleet, Scale Maintenance, Tools, and Materials Control.
• Data visualization workshop. Board level @23 managers and Regional managers @ 86.

Zoom International Services. TDC Cost Board.

Trade and Logistics.

Tools for cost control and visualization.

Chamber of Commerce of Maracaibo | Executive Director.

Management Control | Information Display. 2016 - 2017

Sector: Commercial | Union.

Interactive tool -office automation and Web-, for monitoring, progress control and reportability of the United Nations "Global Compact" program.Monitoring and alignment of union management to the guiding principles of the program, facilitating the monitoring of commitments and goals to the adhesion pact before the UN. Maracaibo Venezuela. 2017

United Nations Organization Chamber of Commerce of Maracaibo..

Union Management Control System - Institutional.

2016-2017

NCT Energy Group CA

Business analytics | Visual Business Intelligence.

Pacific Rubiales Energy.Bogota Colombia. 2014 - 2015
Sector: Oil and Energy.

•Cost project.Artificial lifting (Gas Lift) and production logistics. Generation of display panels of key indicators. Design of cost queries by activity and processes.
•Administrative audits 2014 2015. Analytics and data management. Accounting reclassification and development of visualization and control tools by activity and processes.

OPEX Oil & Gas.

Costs by Business Units, fields, processes and activities
PRE. 2014 - 2015

Carboex. Serex Group | Visualmetrica

Business Analytics | Information Display.

Colombia venezuela. 2013 – 2014
Sector: Mining | Energetic.

• SIGECORP Corporate Management System.
Extracción, tratamiento de datos, interpretación visual de información y diseño de páneles_cc781905-5cde-3194 -bb3b-136bad5cf58d_

(BI Dashboards) for the control of operational logistics, transportation, billing, payments and

inventories of mineral coal with multi-currency indicators.
Colombia / Venezuela. Modality: WEB-Mobile interactive multiplatform.

SIGECORP

Corporate Management System. Mining / Energy
Inventory control and logistics.
Mobile – WEB. 2014

Zulia Governorate

Planning Secretary | Situational room of the Zulia State 2003 – 2010
Utilities for project monitoring and Government management control.

• Treatment, data storage and visual interpretation of georeferenced information.

• Design of management control maps, works and social programs
Modality: WEB interactive multiplatform.

Situational Room.
Interactive Maps.
Government Management Control of Social Programs. WEB. 2.0

Municipality of Maracaibo 2010 – 2013

Director of Municipal Planning and Statistics.

Government

• Chief manager for regional development plans and public investment projects
• Headman on Maracaibo's Situational Room .
• Planning Advisor at Maracaibo Public Planning Council.
• Annual Management Report. Team leader for Zulia State Government. Counselor at Public Council for Planning and Public Policy of Zulia's State.
• Mayor in charge of the city of Maracaibo. December 2011 - January 2012

Interactive Maps.Maracaibo Municipality
Control of Social Programs. WEB. 2.0

PDVSA. Petroleos de Venezuela S.A.

Corporate Finance, Planning, Technology and Production Projects.
Sector: Energy and Oil. 1989 - 2002

Divisional Planning Management. Area: New business.
Planning Advisor. Technical Secretary of the Planning Committee. Division E & P West.

Production. Lagomedio exploitation unit. Management Coordinator.
Tracking tools for cost analysis. Control and monitoring of key indicators EVA, ROCE, EBITDA and Production Costs.

Technology Projects. SAP Sitereadiness. PDVSA. Main office. Caracas. Venezuela.
SAP Corporate Project. Cost Modules (CCA and PCA).
SAP Project Implementation Leader (Sitereadiness). Finance and Materials, Western Business Unit. PDVSA E&P.

Finance budget and management control. Budget analyst and cost controller.
Implementation of the ABC cost model in production, procurement and maintenance.
Maraven - IBM Consulting Group (PDVSA E & P Occidente).
Administrative and financial management of projects.