bhagya warnakulasooriya

I recently migrated to Singapore. I am currently on a dependent pass. I will be immediately available for the position.

TIQRI Corporation (Pvt.) Ltd. as Software Engineer Mar 2022-Dec 2022 ▪ Developed SQL queries, stored procedures and viewing as per the business requirements. ▪ Implemented SQL table joins, data partitioning, switching tables, Error Handling in stored procedures, no count on for performance benefits, ANSI Warnings, No Lock, indexing etc. ▪ Optimization of SQL queries. ▪ Power BI report development and troubleshooting report-related issues. ▪ Collaborated with business users, collected requests, created reports and updated the set of existing BI reports to accommodate business needs. ▪ Performed DAX queries and functions in Power BI. ▪ Connected to different data sources, transformed data, designed models, scheduling, implemented row-level security, identified KPIs, used parameters, added buttons/bookmarks, drill through feature and customized tooltips, analyzing (Key Influencer/Decomposition tree), deployed Power BI scripts etc ▪ Brought the data needed for the report/dashboards into views using stored procedures. ▪ Developed and maintained Azure Data Factory Pipelines associated with Azure SQL Database. ▪ PySpark development in Azure Databricks/ Influx DB and Grafana dashboard development for Internal Proof of Concept project (presales stage project for a new Chinese client). ▪ Interfaced with the client directly to support the scope and objectives and suggested solutions to meet the business requirements. ▪ Provided support to the business when they come up with change requests and troubleshoot issues. ▪ Recommended business-critical solutions that deliver value to stakeholders. ▪ Presented delivery status of New requests/change requests/Bug fixes/data validations/ QA releases/ PROD Releases in the bi-weekly scrum meetings.

IPD Colombo (Pvt.) Ltd. as Data Engineer Dec 2021-Feb 2022 Build ETL (SSIS), troubleshooted ETL related issues, performance optimization of databases and SQL queries, SQL server migrations (Prepared the migration guide on migrating 2008 SQL Server to 2019 SQL server that was used by Tech Ops and Management.), Technical requirement analysis on migrating from On-promise to Azure and building power BI reports.

Daraz (Alibaba Group) as Business Intelligence Analyst Sept 2021-Nov 2021 Worked for an online retail business running different kinds of promotions, campaigns based on prevailing data while getting large number of complex data extraction requirements to be retrieved from the database involving multiple tables and views. Managed tracking effective KPIs related to the website traffic to ensure the performance of the pages. Also, prepared, analyzed, and summarized various weekly, monthly, and periodic operational results, creating reports, visual dashboards, and come up with useful insights and suggestions for improvement

Bachelor in Science (Physics) with a Second Class Honors from University of Peradeniya, Sri Lanka in 2015