Norberto Yamugan

NORBERTO YAMUGAN DATA ANALYST EXECUTIVE SUMMARY WORK EXPERIENCE Professional with more than 6 years of work experience, mainly in health insurance, pursuing a career in data analytics especially in data visualization. With passion in providing the right insights for better decision-making. Actuarial Analyst EXPERTISE Data Senior Analyst • Health Insurance • Data Analysis • Data Visualization SOFT SKILLS • Analytical and critical thinking • Team player and leadership • Openness and adaptability • Communication and responsibility • Resourcefulness • Organizational and decisionmaking TECHNICAL SKILLS • Microsoft office tools (Excel, Word, PowerPoint, Outlook, Sharepoint) • VBA Programming • Power BI and Tableau • PowerQuery, PowerPivot • Basic Accounting • Project Management and Training EDUCATION BS in Applied Math major in Actuarial Math (2011 – 2015) Polytecnic Universtiy of the Philippines BS in Accountancy (2009 - 2011) Polytecnic Universtiy of the Philippines AIA Philippines / August 2021 – September 2021 - Provides actuarial technical support and analysis in product/reinsurance pricing using actuarial models using Prophet - Prepares required documents for product/reinsurance filing and approval to Insurance Commission - Communicates the resulting financial metrics and modelling changes - Handles tasks for pricing initiatives and ad hoc requests from both internal and external stakeholders Generali Philippines / December 2020 – July 2021 - Prepares and maintains dashboards using Power BI and Tableau for Finance, Operations and Management Committee on a regular basis using the medical and life claims of Generali accounts - Extracts, cleans and transforms the claims data for a consistent and reliable dataset to be used by several stakeholders in the company - Provides utilization report to clients (brokers, agents, corporate accounts) for the purpose of analysis, renewal projection and monitoring and control - Provides necessary data and reports to various automation projects and determination of risks and cost-benefit analysis. Key Achievements - Improvement of reports from tabular to visualization - Timeliness, accuracy and consistency of datasets - Strict implementation of Data Privacy, especially to sensitive data of clients Pricing Analyst Generali Philippines / June 2017 – December 2020 - Underwrites prospect accounts to determine the risk rating based on industry, employee profile, and/or job designation of insured individuals - Analysis of claims history of accounts, both for renewal and new businesses, to project their claims for the coming policy periods depending on the request of period of coverage and provide profitable yet reasonable premium rates or renewal recommendation to clients - Conducts studies on the effects of several policies concerning the availment and procedure for claims. - Ad hoc tasks concerning claims, premium refund and experience refund Key Achievements - Creation of automated templates to ease the manual computation of premiums using VBA Programming, as well as creation of templates for repetitive tasks that complements the revised pricing templates that resulted to shorter turn-aroundtime of quotation release and increased productivity - Provided fast and reliable services to important accounts - Provided sound recommendation to accounts’ premium rates and renewal rates - Trained new members of the team --https://www.linkedin.com/in/noyamugan/ AWARDS and RECOGNITION • Top Performer, 2020 (Pricing Team), Generali Philippines • Q3 2020 Lifetime Partner Award for Ownership, Genereali Philippines • Deliver on the Promise 2018 and 2019, Most number of handled requests for Pricing Team, Generali Philippines • Academic Excellence Award 2015, Polytechnic University of the Philippines CHARACTER REFERENCES Agelio Halos- Honey Rose Junio- Faye Tanjuaqio- Actuarial Analyst PhilHealthCare, Inc. (PhilCare) / January 2017 – June 2017 - Underwriting of prospect accounts and endorsement based on account’s qualification for HMO, TPA and SME products - Analysis of historical claims of prospect accounts and provides reasonable rates based on projected claims - Conducts exposure study based on industry Key Achievement - Revision of underwriting guidelines for SME Products to avoid anti-selection and high claims ratio. Actuarial Assistant Philippine Prudential Life Insurance Company, Inc. / June 2015 – December 2016 - Performs initial underwriting of corporate accounts under Medical Insurance Channel using the provided data - Analysis of claims, company profile and employee profile of accounts and projects future claims to derive for the appropriate premium - Makes actuarial studies for the purpose of updating assumptions for premium computation, as well as for accommodation of several enhancements that are not present to client’s existing plans - Prepares annual valuation of Medical Insurance Channel’s portfolio Key Achievement - Recorded a 150% growth in written premiums as well as positive loss ratio in a year with 80% retention rate of accounts due to good premium offers and renewal recommendation for accounts - Endorsement of existing accounts to other insurance providers to avoid legal consequences for disruption of services due to conservatorship status. Also provided an advantageous amount recommendation for the remaining portfolio of Medical Insurance Channel LICENSES, CERTIFICATION, and TRAININGS - - FLMI Level 1 Insurance Fundamentals (LOMA 281 and LOMA 291 Passer) Life Office Management Association Civil Service Exam Professional Level Civil Service Commission, Philippines - SPARTA Project Scholar (Data Scientist Pathway) – under DOST-DAP Data Analysis and Visualization Foundations Specialization (Introduction to Data Analysis, Excel Basics for Data Analysis, Data Visualization and Dashboards in Excel and Cognos) – under Coursera - Introduction to Data Analytics – September 2021 by Coursera Tableau Enablement Training – June 2021 by Generali Philippines Power BI for Beginners – May 2021 by Insights Manila The Essential Elements of Predictive Analytics and Data Mining – March 2021 by Coursera SP201 Essential Excel Skills for Data Preparation and Analysis – December 2020 by Development Academy of the Philippines (SPARTA) Creating Dashboards in Google Spreadsheets - November 2020 by Coursera Introduction to Project Management – November 2020 by Coursera SP101 Getting Grounded to Analytics – April 2020 by Development Academy of the Philippines (SPARTA) Introduction to Project Management – November 2019 by Generali Philippines Macros and VBA Programming – September 2018 by Insights Manila - --https://www.linkedin.com/in/noyamugan/