Data Analyst Power Bi

John Paul Magat

Williams Lake, BC, Canada ***************@*****.***

778-***-**** https://www.linkedin.com/in/johnpaul-magat/ SKILLS

Programming: Python, JavaScript (React, Angular, Node.js), PHP (Laravel), TypeScript, C#, Excel VBA, PL/SQL, PL/PGSQL Data & Databases: SQL, PostgreSQL, Redshift, Oracle, MySQL, SQL Server, ETL, ELT Analysis & Visualization Tools: PowerBI, Oracle Analytics Cloud, JasperServer, JasperStudio, QuickSight, GoogleLooker, BI Publisher Cloud Platforms: Azure, AWS, Power BI Service

Tools & Management: Git, GitHub, SVN, Jira, Notion, Zoho, SonarQube ERP Systems: Oracle EBS, Oracle Fusion Cloud

Operating Systems: Windows, Linux, WSL, Virtual Machines EXPERIENCE

Business Intelligence and Reports Analyst Deployed Philippines Inc. [Nov-2022 ~ Present] - Remote

• Optimized company’s custom web application for reports and dashboards, improving performance by 70%.

• Established report standardization and best practices, reducing support inquiries by 40%.

• Developed 50% of the stored procedures and functions in the database schema.

• Mentored new hires in Power BI, SQL, and JasperServer reporting.

• Built and maintained ETL pipelines for seamless data integration. Operator and Cleanup WestFraser Williams Lake Lumber (Canada) [Nov-2024 ~ Present] Sales Associate Staples (Canada) [Jun-2024 ~ Nov-2024] Casual Weekend Cleanup WestFraser Williams Lake Plywood (Canada) [Aug-2024 ~ Oct-2024] Digital Marketing Data Analyst DGR Australia [Mar-2024 ~ Apr-2024]

• Established 4 Reports in analyzing daily CPL and CPA conversions.

• Improved the quality of Data by 50%, identified 10 items that can be improved to properly analyze the data.

• Established a standard step for gathering, analyzing, and consuming the data in Excel through basic to advance Excel formulas, pivot tables, and computations.

• Worked closely with the company COO to directly report any findings and daily/weekly data reporting. Data Analyst & Full Stack Developer FinXP [Sep-2022 ~ Dec-2023]

• Designed and deployed executive dashboards in Power BI, improving data visibility for leadership.

• Optimized SQL queries and Power BI reports, enhancing system performance.

• Developed a custom ETL application using Laravel, reducing data processing time.

• Managed web support and implemented changes for banking solutions. Senior Application Data Analyst Accenture, Inc [Oct-2021 ~ Nov-2022]

• Led system patches and upgrades for Oracle Fusion Cloud and BI Publisher.

• Acquired Oracle Cloud Platform Enterprise Analytics 2021 Certified Specialist certification.

• Integrated a new banking payment system within Oracle Cloud, enhancing financial reporting Application Developer RS2 Software APAC, Inc [Nov-2020 ~ Oct-2021]

• Developed and optimized PL/SQL banking solutions, improving database performance.

• Proposed and implemented three key process improvements to streamline development. Software Engineer & Technical Support Denso Ten Solutions Philippines Inc. [Aug-2014 ~ Nov-2020]

• Designed and maintained 30+ custom applications within Oracle EBS.

• Led ETL pipeline development, improving warehouse data integration.

• Reduced backlog requests by 70% through process improvements.

• Pioneered a project integrating BHT Scanner with ERP systems. TRAINING & CERTIFICATIONS

Oracle 12C RC: PL/SQL Fundamentals Ed2 Education to Go: Introduction to Networking Oracle Cloud Platform Enterprise Analytics 2021 Certified Specialist University of Michigan: Introduction to HTML5 Wesleyan University: Python Programming: A Concise Introduction EDUCATION

Bachelor of Science in Information and Technology – (2021 - 2024) - Technological University of the Philippines Diploma in Information Communication Management Technology – (2011 ~ 2014) - Polytechnic University of the Philippines

Contact this candidate