Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Anushka Thiththagalla

Vancouver,BC

Summary

Data warehousing and BI engineer with over 6 years of experience in designing, developing, and managing data warehousing and reporting solutions. Proficient in MS SQL, SSIS, SSAS, SSRS, MS Azure, and Power BI. A strong communicator with the ability to convey ideas clearly, placing a strong emphasis on client satisfaction. Enthusiastic team player and creative thinker.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Reporting Analyst & IT Administrator

Blitz Payment Solutions
06.2023 - Current
  • Integrated and analyzed data from various sources, creating comprehensive and meaningful Power BI reports.
  • Designing and maintaining a reporting data warehouse, as well as documenting all reporting procedures.
  • Perform data quality checks to ensure the integrity of the data used for reporting purposes.
  • Collaborated with stakeholders to understand their reporting needs and translated requirements into effective data visualizations and reports.
  • Managed Microsoft user accounts and communication channels.( Microsoft Azure Active Directory, O365, Teams )
  • Designed and maintained Jira project management, customer helpdesk, and operated service desk for addressing technical issues within the organization

IT Administrator

FPM Marketing & Design Inc (FPM3)
04.2022 - 06.2023
  • Supported implementation of warehouse management system software applications to enable centralized management of tasks.
  • Managed and monitored e-commerce inventory while providing user support.
  • Worked closely with management teams to plan, develop and execute technical strategies aligned to client's vision.
  • Managed and maintained IT resources and Microsoft subscriptions.
  • Integrated source systems and created Power BI reports.

Tech Specialist

London Drugs
10.2021 - 04.2022
  • Led the Mobile Champion role in the Tech department and improved mobile sales by providing excellent customer service.
  • Provided advice and guidance to customers on products, services, and store promotions.
  • Performed inventory counts, merchandising, and maintained the professional sales image of the department.

Associate Consultant, Technology

Virtusa (Pvt) Ltd
05.2018 - 07.2021
  • Managed project requirements with clients on their complex business requirements to transform into innovative solutions.
  • Led the 3 member code merge team of the integration project and successfully completed the code merge.
  • Integrate SQL code changes, test code changes, and document code changes.
  • Gather report requirements from client and build Power BI reports.
  • Designed and created production deployment scripts and guides, and conducted deployments.

Software Engineer

Virtusa (Pvt) Ltd
05.2017 - 05.2018
  • Updated old code bases to modern development standards, improving functionality.
  • Improved performance of ETL by troubleshoot existing data loads and suggesting better workaround.
  • Updated SQL code related to metric calculations of the company.
  • Provide documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, Dev test cases, etc.).
  • Conducted Developer Show & Tells / UATs

Associate Software Engineer

Virtusa (Pvt) Ltd
05.2016 - 05.2017
  • Provided production support for the Data Warehouse.
  • Gathered requirements, designed, and developed Datazen dashboards.
  • Modified SSIS packages and SSAS Cubes in accordance with new requirement changes.
  • Monitored the ETL process and troubleshooted failures.

Education

Bachelor of Science - Management Information Systems

University College Dublin
Ireland
07.2015

Skills

  • SQL, SSIS, SSAS, SSRS, PL/SQL, BigQuery, DAX
  • Power BI
  • Cloud (Azure/Google)
  • Azure Active DIrectory, O365
  • Azure DevOps, MS TFS and Jira
  • Experience with WordPress and HTML
  • Database Monitoring and Maintainers
  • Strong time management skills and multitasking abilities

Certification

  • Microsoft Certified: Power Platform Fundamentals

Timeline

Reporting Analyst & IT Administrator

Blitz Payment Solutions
06.2023 - Current

IT Administrator

FPM Marketing & Design Inc (FPM3)
04.2022 - 06.2023

Tech Specialist

London Drugs
10.2021 - 04.2022

Associate Consultant, Technology

Virtusa (Pvt) Ltd
05.2018 - 07.2021

Software Engineer

Virtusa (Pvt) Ltd
05.2017 - 05.2018

Associate Software Engineer

Virtusa (Pvt) Ltd
05.2016 - 05.2017

Bachelor of Science - Management Information Systems

University College Dublin

Similar Profiles

CREATE PROFILE
Anushka Thiththagalla