Kavin Annugala Karunakaran

Data Analyst

FE Fundinfo•  January 2019 - Present

• Involved in fund performance data reconciliation and identifying spikes in NAV and distribution data. • Involved in static data reconciliation. • Liaising with fund groups and internal teams for on-boarding new funds. • Involved in creating model portfolios. • Involved in creating weekly and monthly reports. • Created an macro that increased the number of personalized content emails sent from 10 per analyst per day to 60 per analyst per day. • Helping clients to meet the UCITS KIID guidelines and generate their KIID. • Helping clients to meet PS 19/4 regulatory requirements.

Data Analyst

Broadridge Financial Solutions•  August 2017 - July 2018

• Created an electronic Virtual Control Envelope for Quality Control department to track and to reconcile jobs at various stages of QC processes. • Created Pay Rate Application to track the salaries of employees, to track the staffing agency commission and to generate Daily Labour Unit Cost Report. • Created an application that generates and sends Machine Area Productivity Report to floor leaders to track the productivity of machines at various times. • Created various stored procedures in SQL for Time Management Application to track the time of an employee and to track machine start and end meter. • Created a Visual Basics module to scrap data from Bowe and IQ website, and created various reports using the extracted data. • Created various SQL Reports such as Daily, Weekly, and Monthly Salary expense report, and employee and department productivity report. • Created VB Scripts for automatically sending emails, scraping data from emails and for automatically running various SQL and VB stored procedures. • Worked on a project to migrate Microsoft Access back end tables to SQL Server.