Summary
Overview
Work History
Education
Skills
Expertise Area
Nic Passport
Personal Information
Awards
Languages
Timeline
Generic

Dulanjani Rajapakshe

Waterloo,Ontario

Summary

Highly skilled Database Engineer / SQL Developer / SSRS Report Developer with expertise in database management, ETL processes, and report development. Experienced in end-to-end testing, performance tuning, and data integration. Seeking a challenging position to utilize my technical skills and contribute to organizational success.

Overview

7
7
years of professional experience

Work History

Data Engineer

Rockybrands,Inc
11.2023 - Current
  • Design and develop SQL reports using SQL/SSRS, providing stakeholders with meaningful and comprehensive data analysis
  • Design and develop integration solutions, creating seamless connections between disparate systems
  • Document solution architecture and specifications, ensuring a clear understanding and maintainability of developed solutions
  • Support User Acceptance Testing (UAT) and collaborate with functional consultants to gather and understand customer requirements, ensuring solutions align with business needs
  • Develop complex SQL queries for data analysis, retrieving and manipulating data to meet specific business requirements
  • Conduct data testing and test cases for each report, ensuring the accuracy and reliability of the reporting solutions.
  • Support User Acceptance Testing
  • SQL Query Performance enhancement
  • SSIS Package development for data warehousing

SQL Developer / Database Engineer

Fortude
12.2018 - 09.2023
  • Design and develop SQL reports using SQL/SSRS, providing stakeholders with meaningful and comprehensive data analysis
  • Design and develop integration solutions, creating seamless connections between disparate systems
  • Document solution architecture and specifications, ensuring a clear understanding and maintainability of developed solutions
  • Support end-to-end testing (UAT) for EDI integration developments, ensuring smooth integration and functionality
  • Set up ETL databases for UAT and production environments, ensuring seamless data extraction, transformation, and loading processes
  • Analyze Infor ETL Tool (Spoon) for ETL processes, identifying areas of improvement and implementing enhancements
  • Develop SSRS reports using ETL databases, enabling data-driven decision-making and reporting capabilities
  • Develop SSIS solution for Master Data Management (MDM), ensuring accurate and consistent master data across systems
  • Integrate databases for EDI developments using SQL and XML, facilitating smooth data exchange and integration between systems


QA Automation Associate

Virtusa (Pvt) Ltd
03.2017 - 05.2018
  • Automated manual test case using Virtusa Test Automation Framework Capture objects using X-path and CSS paths
  • UAT Support
  • Analyzed bulk execution reports and stabilized Sanitization and Q&A handling
  • Test Planning and Scripting.

Education

G.C.E Advanced Level Examination ( Mathematics Stream) -

G.C.E Ordinary Level Examination -

Graduate Certificate - Big Data Solution Architecture

Conestoga College
Kitchener, ON
07.2024

BSc(Hons) in Computer Science -

University College Dublin
01.2017

Skills

  • SQL
  • SSRS
  • Postgres SQL
  • SSIS
  • ETL
  • Team Management/ Training

Expertise Area

  • Database development and optimization
  • SSRS report design and development
  • ETL processes and Tools (Infor ETL -Spoon)
  • Data Integration and database development
  • XML Data manipulation
  • Performance tuning and Optimization
  • End-to-end testing and UAT support
  • Design solutions for EDI Integration
  • Problem Solving and collaboration
  • SSIS solutions developments
  • Communication and collaboration

Nic Passport

199254500561 / N9191149

Personal Information

  • Title: Data Engineer
  • Date of Birth: 02/14/1992
  • Marital Status: Married

Awards

Recognized at Fortude’s Excellence Club Award winning for the title of Results & Execution Orientation by 2021.

Languages

English
Professional Working

Timeline

Data Engineer

Rockybrands,Inc
11.2023 - Current

SQL Developer / Database Engineer

Fortude
12.2018 - 09.2023

QA Automation Associate

Virtusa (Pvt) Ltd
03.2017 - 05.2018

G.C.E Advanced Level Examination ( Mathematics Stream) -

G.C.E Ordinary Level Examination -

Graduate Certificate - Big Data Solution Architecture

Conestoga College

BSc(Hons) in Computer Science -

University College Dublin

Similar Profiles

CREATE PROFILE
Dulanjani Rajapakshe