John Karlo San Juan

Work Experience Accounting Dashboard and Analytics Section Head Unistar Credit and Finance Corporation | Pasig City PH 1605 September 2016 – December 2022 JOHN KARLO SAN JUAN ACCOUNTING DASHBOARD AND ANALYTICS SECTION HEAD Cardona, Rizal Philippines 1950-- Skills • • • • • • • • • • • • • • • Tableau Desktop Tableau Prep Builder PostgreSQL Google Workspace Spreadsheet SAP Environment NetSuite Environment Data Analysis Problem-Solving Analytical Skills Advanced vision Attention to detail Invoice and payment processing GL and SL account reconciliation Journal Entries • Designed and developed numerous data visualization, contributing to rate improvements in usability and effectiveness. • Collaborated with Finance, BI, and Operations Department to collect all the data needed for Tableau Prep Builder in data preparation. • Create a prosperous dashboard using Tableau Desktop and prepare stories to create compelling dashboards to deliver actionable insights. • Build prompts, customized calculations, conditions, and filters for various analytical reports or dashboards. • Effectively used data combining, filters, actions, parameters, and hierarchies feature in tableau. • Published workbooks with user filters so that only appropriate teams can view, manage extracted data, and grant access. • Daily gathering and preparing of data for Tableau Prep Builder to update data and visualization on Tableau Online. • Provide accounting assistance to Finance Section Head and Comptroller; respond to financial and operation questions/concerns to meet business needs. • Keep and manage the finance data for financial statements, and other immediate reports, and maintain historical records. Education History Bachelor of Science in Mathematics June 2012 – April 2016 University of Rizal System – Morong Campus Morong, Rizal Philippines 1960 Secondary School June 2008 – April 2012 San Francisco Parish School Cardona, Rizal Philippines 1950 Primary School June 2002 – April 2008 Dalig Elementary School Cardona, Rizal Philippines 1950 Training & Courses • • • • • • • • Tableau Desktop I: Fundamentals Tableau Desktop II: Intermediate Core track of the Data Analytics SEA 14-Day Tableau Virtual Bootcamp Google Sheets Training Workshop Google Slides Training Workshop Google Workspace Training Workshop 7 Habits of Highly Effective People Workshop