Technology, Information and Media
Financial Services
ActiveMelvin profile photo

Melvin

Data analyst with experience in insurance and intellectual property

About Me

Data-driven Risk Analyst with proven experience in quantitative data analysis. Skilled in cleaning, auditing, and modeling large datasets using Excel, Python, and Power BI. Experienced in translating complex data into dynamic executive dashboards and clear, actionable strategic reports for leadership teams and key stakeholders.

Jurisdiction

Canada

Experience

Seniority LevelAssociate
Years of Experience6-10 years
Current StatusActive
Employee Benefits Analyst Mercer
2025 - Present

Leverage advanced tools (Excel and Python) to clean, audit, and visualize health benefits claims experience data across a 500+ client portfolio. Manage and execute plan design database updates for a diverse portfolio of clients, ensuring accurate reflection of current coverage provided by insurers. Conduct end-to-end financial oversight and tracking, spanning complex plan renewals, contract reviews, costing analyses, and comprehensive client data audits. Collaborate closely with Account Executives and internal partners to prepare clear renewal analyses, financial reports, and costings that support critical rate decisions.

IP/Patent Analyst Intellectual Property Ontario (IPON)
2023 - 2024

develop robust IP strategies using tools such as Excel, Power BI, and PowerPoint. Developed comprehensive patent landscape studies for Ontario-based SMEs, aiding them in understanding their technological position and competitive landscape. Utilized Power BI to create compelling visualizations and dashboards that effectively communicated complex data to stakeholders. Prepared and delivered meticulously crafted reports in Microsoft Word and Excel. Presented these reports to various stakeholders of IPON, including Femtech, WeTech Alliance, and the Ministry of Agriculture, Food, and Agribusiness.

Accounts Receivable AssociateTrojan Technologies
2022 - 2023

Administered cash collections, tracked outstanding corporate accounts, and conducted routine financial reconciliations to maintain total payment accuracy. Maintained and validated accurate logic, rates, and historical data logs within master Microsoft Excel files following strict financial controls and version management. Developed process automations using advanced Excel macros to streamline partner communication workflows, eliminating manual calculation and distribution errors.

Intellectual Property Analyst Honeywell Technology Solutions
2015 - 2021

Worked extensively with Honeywell Aerospace attorneys, engineering team, and leadership team on Patent Landscape reports, White Space analysis, and Technology/Market/Company research Implemented new procedures and processes to enable monthly patent alert reporting that decreased reporting cycles by over 20% Developed an Excel pivot chart based interactive Patent dashboard to draw key insights from raw patent data Prepared and delivered patent reports in Microsoft Word and Excel and presented the reports in PowerPoint to external law firms, in-house engineering teams, and Honeywell attorneys Delivered projects with sharp attention to detail, leading to the Honeywell Bravo Bronze award for delivering high-quality patentability search reports Received Honeywell Bravo award for determining enforcement potential of patents in a short period of time

Education

Degree of Business ManagementFanshawe College
2021 - 2023
Degree of Mechanical Engineering National Institute of Technology
2011 - 2015

Skills

Core skills0
Interests0
Languages1

Languages

English