Software Engineer (Data Science)

• Jan 2022 - Present

● Leading a project to implement a data model in a AWS Redshift cluster to extract insurance data of more than 950k superannuation members ● Working on LUCI development project, which is our proprietary analytics platform ● Optimize long running queries on our SQL database (ex: reduce running time from 20 mins to 2 mins) ● Enhanced SQL related ETL job by automating the process of analyzing fragmented indexes to rebuild them and reduce ETL running time by 16% ● Create and maintain AWS lambda functions for many different ETLs ● Executing monthly data refresh process for the customers and suggesting improvements over the current process ● Engineering a customer engagement data model based on user behavior on the dashboards we created for our customers ● Working on developing a Curated Automated Insights model Show less

Data Scientist

• Jul 2021 - Dec 2021

● Extracted important textual information from customer reports (80k per day), using NLP and image processing techniques, to eliminate repetitive and mundane manual tasks ● Predicted the hourly receiving counts of customer reports, by creating a time series forecasting model, to clear the accumulating backlog and to reduced the SLA to less than 10 mins when uploading customer reports into the company website ● Created a software BOT, using python selenium, to upload reports to the customer portals and filled the missing files up to 96% resulting improved customer satisfaction over 3 months Show less

Data Engineer

• Sep 2020 - Jul 2021

● Design and build a reliable and highly scalable modern data platform including the use of data lakes and warehouses across range of technologies hosted in GCP ● Developed an ETL pipeline using python to extract data from JIRA APIs to Google Big Query ● Optimize the data warehouse queries and improve the performance of data retrieval process ● Used star schema to model data in Power BI and create and share a dashboard within the whole organization to monitor project performance ● Utilize SSMS and SSIS to test the ETL pipeline before putting it to production ● Participate in agile meetings with project managers, developers and product owners in the form of daily scrums, sprint planning, backlog grooming and sprint retrospective Show less

Data Analyst

• Jun 2017 - Sep 2020

My responsibility was to provide Intel for our internal clients of the organization helping them to improve their strategies. I provided insights on employee productivity, project accuracy, transport/shift planning, KPI status and much more. Many of our support and management teams including CEO and COO were briefed on various processes from my data visualizations. The essentials that was in my analysis toolkit are Excel/VBA/Macros, Tableau, R/Python, Octave, MySQL/MongoDB, etc. I incorporated tactics from simple statistics to advance machine learning techniques, such as ANOVA, regression, random forests, decision trees, SVM, neural networks, clustering and more, as appropriate. For my personal reference, I developed and maintained conventional relational databases as well as big data, using Hadoop/spark. Show less

Scientific Officer

• Jun 2014 - Jun 2017

Coordination of an year round annual program to celebrate World Science Day for Peace and Development declared by the UN, along with a science education competition for over 790 government & private schools in Sri Lanka. Coordination of the financial scheme which funds up to LKR 1 million for science education & popularizing activities carried out by other institutions. Coordination of the Working Committee of Science Popularization at NSF. Media representative on behalf of the National Science Foundation... Show less

Temporary Demonstrator

• Feb 2013 - Jun 2014

Trainee Bank Assistant

• 2008 - 2008

Temporary staff member

• 2007 - 2008

While i was selected to university i have had the opportunity to work in the bank about 10 months as a temporary member. I learned most of the banking things at that period and it is my first experience as a worker. While i was selected to university i have had the opportunity to work in the bank about 10 months as a temporary member. I learned most of the banking things at that period and it is my first experience as a worker.