Summary
Overview
Work History
Education
Skills
References
Languages
Timeline
Generic

CHAMATH WIJESENA

14589, 76A Street,Surrey,BC

Summary

Experienced data professional with over 4 years of experience in the field. Currently serving as a senior data engineer, leveraging expertise in ETL tools, various databases, visualization tools, and statistics to provide actionable insights and support data-driven decision making. Committed to staying up to date with industry advancements and best practices to deliver outstanding data solutions.

Overview

4
4
years of professional experience

Work History

Senior Engineer - Data Engineering

Sysco LABS Technologies (Private) Limited
11.2022 - 03.2024

Industry- Food & Beverage (Sysco LABS is the innovation office of Sysco USA)


  • Develop and maintain reports using SQL Server Reporting Services to meet diverse business needs
  • Develop and maintain T-SQL and SQL queries for diverse database operations
  • Develop and maintain views, composed stored procedures, updated tables, and managed table creation using both T-SQL and standard SQL to ensure efficient database operations
  • Implement the creation of indexes and perform performance tuning on SQL queries for optimal database performance
  • Design, create, and manage SQL Agent jobs to automate various database tasks, ensuring streamlined operations
  • Write complex SQL queries tailored to meet specific business needs
  • Collaborate with cross-functional teams to gather and analyze requirements for database solutions
  • Monitor and troubleshoot database issues, providing timely resolutions to ensure minimal downtime
  • Adhere to Agile development practices, contributing to sprint planning, retrospective, and sprint review activities
  • Utilize existing legacy reports as a foundation to design and develop Tableau dashboards, replacing outdated reporting systems
  • Respond to new Tableau dashboard requests, addressing areas where reporting solutions are currently non-existent
  • Assist in the organization and management of the Tableau library, ensuring efficiency and accessibility of existing dashboards
  • Administer user security and handle access requests in Tableau-related tasks
  • Stay abreast of Tableau advancements and continuously enhance skills through learning and development initiatives
  • Provide guidance and actively participate in data governance, contributing to the development of robust data sources
  • Conduct training sessions for other Tableau users, fostering a knowledgeable user base
  • Run dashboard demos to end-users, ensuring a clear understanding of the functionalities
  • Investigate data issues and address user queries promptly, ensuring data integrity and user satisfaction
  • Liaise with the Tableau Server platform team to ensure seamless integration and optimal performance
  • Undertake additional duties and provide coverage as required by the team, contributing to the overall success of the department.

Specialist - Senior Data Analyst

Dialog Axiata PLC
07.2022 - 11.2022

Industry- Telecommunication


  • Develop and automate predictive models for key business processes
  • Provide training in SQL, Python, R, and other relevant tools
  • Coach users on SQL/Tableau for self-extractions and data visualization
  • Ensure data quality management and cleansing for division-relevant data
  • Foster knowledge sharing, collaboration, and continuous learning
  • Conduct quantitative and qualitative analysis, including industry research and R&D tasks
  • Prepare roadmaps, investment papers, and adapt methodologies based on research findings
  • Translate research findings into actionable insights for business understanding
  • Apply problem-solving methodologies to diagnose and solve operational issues
  • Recommend resource requirements and collaborate with stakeholders for implementation
  • Enhance systems, track performance, and lead initiatives for continual improvement
  • Design experiments, define tracking metrics, and measure impact/ROI for optimization
  • Manage operational report requests and participate in analytics projects
  • Identify and leverage data-driven opportunities for business improvement
  • Collect, clean, and analyze data, presenting findings through visualization tools
  • Develop Tableau dashboards, maintain documentation, and adhere to agile practices
  • Deliver reports, presentations, and guide commercial growth strategies
  • Execute campaigns, assess effectiveness, and influence stakeholders for new initiatives.

Specialist - Data Analyst

Dialog Axiata PLC
04.2022 - 07.2022

Senior Executive - Data Analyst

Dialog Axiata PLC
06.2021 - 04.2022

Associate Data Analyst

Ayra Group (Pvt) Limited
11.2019 - 06.2021

Education

M.Sc. - Data Science & Artificial Intelligence

The University of Moratuwa
2025

B.Sc. - Financial Engineering

The University of Colombo
2021

G.C.E Advanced Level -

Gurukula College
2013

G.C.E Ordinary Level -

Gurukula College
2010

Skills

  • SQL
  • Python
  • Microsoft SQL Server
  • MySQL
  • Oracle
  • ETL/ELT
  • SQL Server Integration Services
  • SQL Server Reporting Services
  • Tableau
  • Power BI
  • AWS
  • Azure
  • Machine Learning
  • Deep Learning
  • Natural Language Processing
  • Statistics

References

REFERENCES Available upon request

Languages

English
Professional Working

Timeline

Senior Engineer - Data Engineering

Sysco LABS Technologies (Private) Limited
11.2022 - 03.2024

Specialist - Senior Data Analyst

Dialog Axiata PLC
07.2022 - 11.2022

Specialist - Data Analyst

Dialog Axiata PLC
04.2022 - 07.2022

Senior Executive - Data Analyst

Dialog Axiata PLC
06.2021 - 04.2022

Associate Data Analyst

Ayra Group (Pvt) Limited
11.2019 - 06.2021

M.Sc. - Data Science & Artificial Intelligence

The University of Moratuwa

B.Sc. - Financial Engineering

The University of Colombo

G.C.E Advanced Level -

Gurukula College

G.C.E Ordinary Level -

Gurukula College
CHAMATH WIJESENA