Amal Gunasinghe Email & Phone Number

Melbourne, Victoria, Australia

Melbourne, Australia

Melbourne

 Create queries to extract, organize and synthesize data from multiple sources such as Harmony ERP /POS system, MS SQL Data Warehouse, Net suite CRM, Maple Lake Planning system, Easy wage system and Arcade customer portal.  Source data analysis, Data cleansing and Data Mapping to MS BI stack platform. Prepare reports, analyze, compare data on customer orders, Purchase orders, shipping and stock movements to provide insights based on weekly sales figures from customers for different stories /Categories/ various styles. Design, build and maintain interactive BI dashboards and paginated reports to present the findings to multiple stakeholders. (Executive Team, Board, CFO and to COO, Finance Manager) Refine SQL queries and Excel Reports to develop operational and strategic KPI, Post season reviews, Season planning, BI dashboards that improve performance and user experience. Design and develop queries in SQL to extract data form multiple sources and to collate information to reports and publish to Power BI and to SharePoint. Populating SQL cleansed data into the new Platform and Gather business requirements for reporting, while analyzing data to design and develop reports in Excel, SSRS and Power BI. Extract customer feedback data from CRM and collate with data from HR system to disseminate insights during daily weekly and monthly customer engagement team meetings. Troubleshoot existing systems and fix system errors related to data sources that enhance the accuracy of source data for reporting. Pre UAT and post UAT (post migrations) and documentation. Develop SQL /ETL agent jobs and monitor data extraction from multiple data sources to Data Warehouse, Update and maintain ETL jobs and its relevant processes and procedures. Gathered detailed requirements from business users & stakeholders to develop a comprehensive Gap Analysis and Identified & opportunities in reporting and data analysis.

Melbourne, Australia

 Liaised with stakeholders to obtain business requirements to prepare a system requirement specification. Managed projects using Agile methodology & validated user stories to develop reporting solutions  Planned and prioritized product feature backlog and development for the product. Provided backlog management, iteration planning, and elaboration of the user stories. Carried out report testing and data validations.

Colombo

 Facilitated requirements elicitation forums with stakeholders, while translating changing business requirements and reporting requirements. Assisted stakeholders to evaluate enterprise reporting solution proposals, third party software and business cases. Identified, investigated, analyzed & evaluated core business processes Map “As-Is” and “To-Be “Process taking on board the best practices in insurance industry. Coordinated with various functional stakeholders and compliance agencies, research and present information to management on general insurance business dynamics.  Identified gaps and system solution options, while developing business cases with feasible reporting solution options.

Coordinate the projects, gather client’s business requirements, and liaise with development team and deliver system solutions to clients

Master’S Degree, Business Analytics

Deakin’s Master of Business Analytics is a collaborative education program with industry. The course develops business analytics.

Bsc(Hons), Management & It

Information Technology

Certificate Iv - Eal- For Overseas Professionals In Australia, Certificate Iv - Eal- For Overseas Professionals In Australia

Activities and Societies: Group ActivitiesEAL Certificate 4

Diploma In Insurance, Insurance

Activities and Societies: GroupCII

Cma (Aus), Management Accounting

Activities and Societies: Group activitiesCMA

Pmp, Project Management

Activities and Societies: Group work ,Entertainment relatedMBA

Mba -Pim, Management

Master of Business Management