Ashan Meegoda Email and Phone Number

- Gather and interpret business requirements to produce a variety of reporting products, including reports, dashboards and paginated reports using Power BI - Analyse, understand and effectively communicate technical material to non-technical internal stakeholders - Design, build and manage SSAS tabular models, including relationships and hierarchy design, partitioning and processing. - Develop insightful and robust DAX measures that are underpinned by sound business logic, and documentation of same. - Assist with maintaining, and further developing the Enterprise Data Warehouse (EDW).

• Contributes to the TIO’s internal and external reporting on complaint trends, insights and dispute resolution outcomes by  undertaking data extraction, analysis, manipulation, and reporting;  utilizing data analytics and market intelligence;  preparing reports for a range of internal and external stakeholders;• Supports an environment of continuous improvement in data principles, analysis, and forecasting methodologies• Monitors developments in the telecommunications market and regulatory environment• Develops productive, respectful and positive relationships with all stakeholders• Contributes to TIO’s aim of Employer of Choice• Supports the TIO’s improvement agenda• Provides support, advice, and briefings to the Ombudsman, Assistant Ombudsman, and other senior leaders as required• Undertakes analysis of internal and external data sources with a focus on complaint/dispute handling trend analysis and reporting:• Produces reports for the Ombudsman, senior leaders, and TIO Board• Creates data dashboards aligned with TIO strategic goals• Undertakes data analysis and identification of trends in relation to systemic issues• Forecasts based on internal and external market information• Contributes to data and trend analysis in support of TIO submissions to government and industry inquiries• Reports to external stakeholders including ACMA and government departments• Works closely with the TIO Stakeholder Engagement, Member Services andInformation, Systems and Technology team to ensure the provision of accurate and reliable reports to stakeholders• Creates and contributes to high-quality products for external publication (i.e Annual Report)• Contributes to projects aligned with the TIO's strategic goals• Other projects and duties as required

• Writing and maintaining SQL and DAX codes to meet industry best practices and system requirements by analysing SQL execution plan• Continuously conduct performance analysis using application management software tools (SQL profiler) to ensure queries are optimised up to best practise standards.• Developing and maintaining technical processes and reports along with end user documentation and training• Being active in Sprint planning sessions in providing advice and expertise in developing strategies to overcome current issues and building new functionalities• Develop Utilities to automate scenarios to reduce manual effort• Develop complex project plans for recommending software purchases and upgrades• Researching and analysing requirements through participating in industry seminars and conducting surveys and one-to-one sessions with end users• Identification of limitations and deficiencies in applications through regression testing and propose better ways to solve the identified issues• Involved in developing, managing and modifying Impos Analytics mobile application• Working with various data sources like SQL Server 2008/2012 R2, Microsoft Dynamics 365, Labtech and social data sources

• Manage and maintain SymmetricDS databases on each client on the cloud server• Building standard and custom reports, dashboards and views for internal and external use• Troubleshooting client’s data, database and report related issues• Analysing capabilities of latest technologies and recommending changes to BI tools• Data transformation of new clients joining Impos Analytics• Managing broadcast of reports to clients• Managing the users of BI tool and analysing the usage patterns to improve the services.

First point of support over a variety of channels (including phone, SMS, email and chat)Documentation of case interactionResolution of cases where possible within SLAClearly define the needs of customersHigh quality and frequency of communications to customersConfiguration of terminals and printersTroubleshoot client issues by remotely accessing

• Effectively perform PAT testing in line with AS/NZS 3760:2010 (200 – 300 tests per day)• Demonstrated professional client service during every interaction with regular updates• Accurately log all test information and hand over professional reports to clients• Work effectively in a team environment and individual as required• Successfully Complete inductions and/or site-specific forms• Uphold customer service standards and personal presentation

- Identified main data source to analyse and came up with insights that will improve quality of solutions - Applied design thinking and collaborative problem solving to rapidly develop ideas and solutions with a team of 30 members from different fields of expertise.- Applied the solutions to Suitability, Feasibility and Acceptability (SFA) to select the 2 best solutions.- Presented the business case to the board of directors.

• Carried out 5 events to improve student involvement in the university activities that will enhance the bond between local and international university student.• Used social media and one-to-one engagements to gain insights on events that interests students, collected information from more than 300 students during in 2 orientation programs and created a group on Facebook for students with similar interests (More than 450 students).• Evaluating the effectiveness of engagement activities using available data points such as attendance and post evaluation form.Technologies – MS Excel, Eventbrite, Facebook

• Sending more than 20 daily, weekly and monthly reports to management which includes sales, collection and distribution trends of island and 18 distributors.• Forecast sales and collections to provide information production planning and evaluate the accuracy of predictions with the actual.• Analysing marketing campaigns to evaluate their success using KPI’s and giving insights to managementTechnologies – MS Excel, Salesforce