ayesh Karunaratne

Optimized 40 SOX compliance processes by automating key control testing using Connexa, reducing manual effort by 30% and improving audit readiness. Identified and resolved 10 data anomalies through detailed financial and operational data analysis, ensuring 100% accuracy in SOX compliance reporting and reducing audit exceptions.

Conducted gap analysis for an Actuarial software automation project, improving system efficiency. Designed system architecture for Prophet, including configuration tables to streamline processing.

Led migration of Oracle/SAS system to Snowflake, replacing SAS rules with AWS Data Lake. Designed a Kimball-based BI platform for Qlik, improving reporting and insights.

Identified inconsistencies in Westpac’s APRA reporting through GAP analysis of the CDM platform. Recommended process improvements by analysing and documenting business and technical workflows.

Led Life Insurance data migration to One Office – Ebix, ensuring data integrity. Optimized business processes and guided stakeholders through system changes.

Investigated and documented data migration issues from legacy systems to Salesforce, proposing solutions to address compliance requirements in the Education sector. Applied corrections to migration data, ensuring accuracy and alignment with business needs.

Managed application support for over 40 applications, leading technical support for key systems such as Unger Boeck EBMS, SUN Systems, and IPOS. Oversaw Microsoft SQL Server SSRS/SSIS database administration and customized new SSRS reports to support users’ Business Intelligence needs.

Redesigned and corrected a cost & revenue system, while maintaining the governance and control framework (PaRCon System). Administered the Salesforce CRM system, including creating testing environments and designing user interfaces.

Successfully migrated all reports from the legacy Impromptu system to Cognos. Developed ETL processes and SAP queries, improving data extraction efficiency.

Led the migration and development of Cognos reports, improving reporting efficiency. Developed ETL solutions that resolved critical data issues across branch offices.

Led IEF projects, demonstrating strong project leadership and technical expertise. Contributed to the development and implementation of critical systems within the authority.

Worked as a Senior Analyst Programmer, contributing to system analysis and programming efforts. Played a key role in developing and maintaining software applications.

Completed a Graduate Certificate in Data Analytics, focusing on advanced data analysis techniques and tools. Gained expertise in interpreting complex datasets and deriving actionable insights.

Obtained a Graduate Certificate in Management, developing strong leadership and strategic planning skills. Focused on organizational behavior, financial management, and operational efficiency.

Grade: Senior Associate

Completed a Diploma of Financial Services with a specialization in General Insurance. Acquired comprehensive knowledge of insurance principles, risk management, and financial regulations.

Grade: Part Qualified

Undertook studies towards becoming a Chartered Management Accountant, gaining foundational knowledge in management accounting principles and practices. Developed skills in financial reporting, budgeting, and performance management.