Detail-focused Data Analyst with knowledge in data warehousing, process validation and business needs analysis.
Dedicated and hard-working with passion for Big Data.
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
10
10
years of professional experience
Work History
Operations Analyst
Pensions Alliance Trust Limited
Cantonments - Accra, Ghana
01.2022 - Current
Custodian statement reconciliation
Daily Portfolio valuation
Reconciliation with the Fund managers and Custodians using their portfolio valuation reports after end of the valuation period to compute final Net Asset Value (NAV)
Preparation of investment and Board of Trustees report
Consolidated financial data and materials for key leadership meetings.
Streamlined operations by identifying inefficiencies and implementing process improvements.
Collaborated with cross-functional teams for the successful completion of complex projects.
Contributed to revenue growth by analyzing trends, forecasting demands, and recommending strategies to optimize performance.
Participated in the creation of detailed reports outlining performance metrics related to operations support activities.
Data Analyst
Pensions Alliance Trust Limited
Cantonments - Accra,Ghana
12.2019 - 12.2021
Contributions schedule data cleaning
Employer Demand letter preparation
Scheme Contributions data Uploads
Contributions entry on the control sheet
Monthly fees preparations for Pensions Regulator, Corporate Trustee, Various Custodians and Fund managers
Following up on employer contributions data submission.
Developed spreadsheet models for diverse projects and analysis.
Created and maintained precise and accurate models, charts and reports on regular basis.
Project Coordinator
Star Life Assurance Limited
03.2018 - 07.2019
Developed project plans, schedules and procedures in achieving project goals.
Conducted research and gathered key information for use in upcoming project planning.
Guided and supervised project team of 10 to drive project success.
Processed and cleaned bank transaction and premium receipts data for data migration and decision making.
Oversaw workflow and conducted month-end reconciliation of jobs via creation commission reports of team members.
Provided outstanding service to all parties involved with project, promoting effective and lasting business relationships.
Coordinated meetings with all pertinent parties and set up remote calls using TurnQuest.
Reviewed documentation to verify conformance with established project criteria.
Kept projects on schedule by managing deadlines and adjusting workflows.
Oversaw productivity streams for ongoing and special projects.
Transitioned projects from estimation and pre-construction phase to well-defined project execution plan.
Investigated and assessed claims data to enhance regular systems premium comparison for accurate data migration.
Implemented a tracking system to document clients’ loans and repayments for decision making.
Prepared and endorsed Sales Activation, Refunds, and deduction for authorization and dispatch.
Worked with project director to formulate technical reports
Data Analyst
Star Life Assurance Limited
09.2016 - 08.2017
Preparation and backing up of Telesales data using SQL for business development.
Confirmed and updated receipts from premium payments from various pay points unto the clients' ledger.
Generated and sent policy schedules to clients after proposal approval.
Compiling and reporting on successful and unsuccessful bank's data.
Coordinated statistical data analysis, design and information flow.
Created various Excel and SQL documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
Produced monthly reports using advanced Excel spreadsheet functions.
Participated in sale of retail products together with business development team.
Participated in requirements meetings and data mapping sessions to understand business needs.
Records Officer
SIC LIFE
06.2015 - 08.2015
Sorted and scanned all paperwork and documents according to dates and significance.
Retrieved and updated clients records periodically.
Maintained accurate record-keeping with proactive attention to client information updates.
Delivered cheques to banks on behalf of clients.
Assisted Actuarial department with relevant calculations concerning clients’ information.
Helped with admnistrative duties.
Assisted clients daily with positive attitude and focus on customer satisfaction.
Acturial & Risk Management
Star Life Assurance Limited
06.2014 - 08.2014
Prepared group business data for Actuarial valuation.
Performed product pricing considering all pertinent factors.
Prepared cash receipts for clients.
Assisted dispatch and procurement team by preparing policy documents for respective clients.
Underwrote policies to confirm eligibility of clients for insurance packages.
Developed and controlled execution of reporting and analytics for multiple operations departments.
Designed and monitored underwriting scorecards and related predictability.
Education
Bachelor of Science - ACTUARIAL SCIENCE
KWAME NKRUMAH UNIVERSITY OF SCIENCE AND TECHNOLOGY
Kumasi, Ghana
06.2017
High School Diploma -
ACCRA ACADEMY
Accra, Ghana.
06.2012
Skills
Professional Skills
MATLAB
HTML & CSS
Microsoft Office Suite
SQL
Python
Power BI
PERSONAL SKILLS
Data Analytics
Team player
Great communication skills
Sense of responsibility
Good organization skills
Forecasting Skills
Facilitating Coordination
Timeline
Operations Analyst
Pensions Alliance Trust Limited
01.2022 - Current
Data Analyst
Pensions Alliance Trust Limited
12.2019 - 12.2021
Project Coordinator
Star Life Assurance Limited
03.2018 - 07.2019
Data Analyst
Star Life Assurance Limited
09.2016 - 08.2017
Records Officer
SIC LIFE
06.2015 - 08.2015
Acturial & Risk Management
Star Life Assurance Limited
06.2014 - 08.2014
Bachelor of Science - ACTUARIAL SCIENCE
KWAME NKRUMAH UNIVERSITY OF SCIENCE AND TECHNOLOGY