Paul Agbekpornu
North York,CA
Summary
Motivated and analytical data professional with over five years of experience in data analysis, financial modeling, and providing actionable insights to foster business growth. Skilled in extracting, transforming, and analyzing large datasets to identify trends, ensure data accuracy, and support strategic decision-making. Proficient in using tools like Excel (including VBA and Pivot Tables), SQL, and Power BI to create interactive dashboards, enhance processes, and deliver data-driven solutions. Experienced in data validation, visualization, and statistical modeling, with a strong capacity to collaborate across departments to improve business operations and performance. Recognized for attention to detail, problem-solving skills, and a dedication to delivering insights that promote efficiency and growth.
Acquired analytical skills in fast-paced environment, focusing on data-driven insights and trend identification. Developed expertise in statistical analysis and data visualization tools to support decision-making processes. Seeking to transition into new field, leveraging analytical capabilities and technical acumen to drive success.
Overview
8
8
years of professional experience
Work History
Actuarial/Data Analyst Intern
PLIG - Prudential Life Insurance
06.2024 - 08.2024
- Developed data pipelines and automated ETL processes to clean, transform, and analyze large datasets, increasing data processing efficiency by 30%
- Collaborated with the actuarial team to identify coding errors, refine model accuracy, and improve data integrity by 20%
- Conducted financial analysis and forecasting using SQL and Power BI, improving data accuracy by 20% and forecast reliability by 30%
- Used Power Query, macros/VBA, and LOOKUP functions to transform and analyze large datasets, enhancing the accuracy of business forecasts and financial valuations by 20%
- Conducted statistical analysis and risk assessments to identify data anomalies and improve data-driven decision-making
- Streamlined monthly persistency rate reporting by automating data loading, cleansing, and summarization through Power Query and Pivot Tables which improved risk management strategies and client retention by 25%
- Developed and maintained dashboards using Power BI, visualizing KPIs for management, and enabling more informed decision-making
Financial Analyst Consultant
PLIG - Prudential Life Insurance
01.2020 - 01.2021
- Developed ETL batch processes and executed data integration tasks for insurance data, improving data accuracy and availability for financial reporting
- Explained complex claims processes to clients, helping them understand risk factors related to serious illnesses and accidents, and ensuring policies were aligned with their unique circumstances, resulting in a 30% improvement in client comprehension
- Trained team members on data analysis techniques to forecast claim amounts for education and wealth policies, increasing the team's ability to accurately predict maturity and settlement timelines by 20%
Actuarial Intern
SSNIT - Social Security and National Insurance Trust
06.2016 - 08.2016
- Analyzed client portfolios and calculated pensions for various events (retirement, termination, death), ensuring accurate documentation in alignment with regulatory requirements
- Assisted the actuarial team in verifying pension rights and average earnings-based calculations, reconciling member accounts, adjusting pension benefits, and preparing actuarial reports for defined benefit plans
- Supported actuarial valuations and analyzed pension member data, providing data-driven insights for improved risk management and regulatory compliance with PNDC Law 247 and Act 766
Education
Master of Financial Insurance - Insurance & Data Science
University of Toronto (U of T)
Toronto, ON12.2024
MPhil. - Mathematical Statistics
Kwame Nkrumah University of Science and Technology (KNUST)
12.2023
BSc. - Actuarial Science
Kwame Nkrumah University of Science and Technology (KNUST)
12.2018
Skills
- Data Analysis & Reporting
- Data Validation & Accuracy
- Performance Analysis
- Data Cleaning & Transformation
- Statistical Analysis
- Business Process Optimization
- Data Visualization & Dashboards
- SQL Database Querying
- Cross-functional Collaboration
- Financial Management & Reporting
- Power BI
- Microsoft Excel/VBA
- Financial Modeling Tools
- Business Intelligence
- Data Visualization Tools
- Reporting Dashboards
Personal Information
Title: Data Analyst
Awards
- Best Poster & Presentation Award, MFI U of T, 01/01/24
- MasterCard Foundation Scholarship, U of T
- Masters Scholarship, AIMS Accra
Publications
- The Risks of Microplastic Pollution in the Aquatic Ecosystem, Agbekpornu Paul, Kevudo Isaac, 2023, IntechOpen, https://doi.org/10.5772/intechopen.108717
- Mathematical Modeling of Transmission of Water Pollution, Bonyah, E., Agbekpornu, P., Unlu, C., 2021, Journal of Prime Research in Mathematics, 17, 2, 20-38
Communityexperience
- Volunteer, Penny Smiles Foundation
- Sports, Football, Volleyball
Languages
English
Full Professional
Interests
- Team Sports
- Volunteer Work
- Swimming
Timeline
Actuarial/Data Analyst Intern
PLIG - Prudential Life Insurance
06.2024 - 08.2024
Financial Analyst Consultant
PLIG - Prudential Life Insurance
01.2020 - 01.2021
Actuarial Intern
SSNIT - Social Security and National Insurance Trust
06.2016 - 08.2016
MPhil. - Mathematical Statistics
Kwame Nkrumah University of Science and Technology (KNUST)
BSc. - Actuarial Science
Kwame Nkrumah University of Science and Technology (KNUST)
Master of Financial Insurance - Insurance & Data Science
University of Toronto (U of T)
Similar Profiles
Ketan AdiyechaKetan Adiyecha
Manager 1 at ICICI Prudential Life Insurance Co. Ltd.Manager 1 at ICICI Prudential Life Insurance Co. Ltd.
Mahima TiwariMahima Tiwari
Intern at ICICI Prudential Life InsuranceIntern at ICICI Prudential Life Insurance
Rubie Lyn VillorenteRubie Lyn Villorente
Financial Advisor at Prudential Life UK InsuranceFinancial Advisor at Prudential Life UK Insurance