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.
JC Savini Portfolio
Orlando Florida. USA 2023
Google Workspace Platform Web/Mobile Solutions for automated reporting by Case Managers, Legal Drafters, and Storytellers.
Includes KPI dashboards and administrative templates for streamlined operations management.
2010 - present
Claxton Law Group LLC. Accounts Receivable Tracker
This comprehensive Accounts Receivable Tracker, powered by Power Query, M, and Excel Enterprise, optimizes the management of outstanding receivables from third parties. Streamlines the visualization and control of 50+ key metrics and 4 dynamical reports modules, focus on track and control receivables and due portfolio recovery.
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.
Minex LLC. Coal Thermal Board.
Coal Inventory Balance per week.
Purchases & Storage by Location and Ports.
eBox Logistics. 2019 – 2023.
Miami Florida USA
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.
Serex Group | Millinton Coal International
2017 - 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.
2010 - present
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.
Zoom Group.
Caracas, Venezuela 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.
Academic training
University of Zulia
Economist. MBA in Business Management
Maracaibo Venezuela. 1983 - 1989
Andres Bello Catholic University
Master in Government Science and Techniques
Maracaibo Venezuela. 2011 - 2012
Grade Position #1
skills
MS Excel
2015 MVA Certificate
Microsoft Excel 2013 Essential
Microsoft Virtual Academy
2015
Microsoft Business Intelligence
2015 MVA Certificate
Microsoft Business Intelligence in Office 2013. Microsoft Virtual Academy
Microsoft Business Intelligence
2015 MVA Certificate
Faster insights to data with Power BI Jump Start 2013. Microsoft Virtual Academy
Languages
Italian
English
Spanish