John Paul Macapagal Email & Phone Number

Central Luzon, Philippines

Brisbane, Queensland, Australia

- Maintains and conducts troubleshooting on BI reports and local data warehouse.- Translating business needs to technical specifications by creating documentations, standard procedures, ETL processes, SQL jobs and SPs.- Analyzing the company CRM to build applicable warehouse tables and views.- Developing reporting systems that provide accessible information for decision-making via different analytic platforms such as PowerBi and Report Server.- Acts as a bridge between local IT and external IT in merging data warehouse and models of three different companies to create an executive/high-level reports.- Attends to different stakeholders' automation, reporting, and ad-hoc requests.- Tools Used: SSRS, SSMS, PowerBi, MS Excel, VBA, VS Code (ETL), AuditData

Highlight: Standing POC of the Business Analytics Department- Directly reports to the Director of Analytics and Solutions.- Works across departments, conferring with managers and executives to gather requirements and specifications while developing enhanced data and reporting tools.- Prepares business documents and presentations for upper management and executives; Collates Key Performance Indicator scores to support business processes and client workflows.- Creates and maintains a wide range of data-related trackers, dashboards, databases, and file references.- Generates periodic reports needed by various departments and ensures data integrity and reliability.- Provides analysis of data to back up and assist the decision-making of the key departments and functions.- Analyzes and validates data to suggest recommendations essential to performance improvement; extracts and combines data from various data resources.- Automates tasks and reports generation from manual processing to reduce cycle time and defects.- Safe keeps and sorts data for the company and management’s use.- Prepares various ad hoc reports as needed- LookerML, Mode Analytics, Fivetran, Snowflake, dbt, GitHub, Postman, PowerBi, MS Excel, Google Spreadsheet, Appscripts (Javascript), Visual Basic, HTML, Notion, Different CRMs (Zendesk, Salesforce, etc.)

Region Iii - Central Luzon, Philippines

- Directly reports to the Admin director and Chief Operations Officer.- Keen knowledge of H.R. procedures and strictly implements them.- Sends the end of the week, month, and quarter attendance and attrition reports to executives.- Creates dashboards, trackers, and reports upon request and maintains all existing ones.- Reviews the time records of all employees and adjusts all schedule-related requests.- Maintains and updates the company employee database placed in GDrive.- Creates processed documents related to the workforce department.- Handles the billable hours' report of the Finance department for client billing- Settles necessary seat plans mostly during account movements or cluster relocation based on a schedule.- Presents to executives the KPI database of operations, from agent level to senior operations manager.

Region Iii - Central Luzon, Philippines

Also works as a 'Reporting Analyst' in addition to the said title starting January 2018 until April 2019, no formal promotion was done.- Utilized Google Spreadsheets to track and analyze data, able to program own function scripts.- Manages, maintains, and updates the timesheets and quality trackers of employees.- Coded programs using Google App scripts for a couple of accounts to make work easier.- Improved the company’s database through consolidation and sheet linking.- Generates reports upon request of the management/clients.- Sends and creates invoices and reports for billing to our Clients as a regular task. - Standing support of the Order entry department of the ‘Pop Promos’ account.

Region Iii - Central Luzon, Philippines

Region Iii - Central Luzon, Philippines

Region Iii - Central Luzon, Philippines