Summary
Overview
Work History
Education
Skills
Languages
Affiliations
Certification
Accomplishments
Timeline
Generic

SHIRENDRA DE SILVA

Canberra,ACT

Summary

Energetic and detail-oriented recent graduate with a degree in Information Technology and Systems, showcasing a solid foundation in diverse technical disciplines. Demonstrated ability to collaborate effectively within cross-functional teams, coupled with excellent communication skills that facilitate seamless information exchange. Adept at analysing complex systems and processes, with a focus on optimising efficiency and enhancing overall functionality. Eager to contribute to a dynamic IT environment, leveraging academic knowledge and hands-on project experience to drive innovation and achieve organisational objectives. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Overview

6
6
years of professional experience
1
1
Certification

Work History

ICT BUSINESS ANALYST

H One(Pvt) Ltd
06.2020 - 01.2022
  • Developed and maintained a standardised template for SOW documents, ensuring consistency and clarity across all projects
  • Proactively identified and resolved potential scope gaps or ambiguities in SOW documents, minimising project delays and risks
  • Streamlined the SOW creation process by implementing a digital platform, reducing document creation time
  • Held requirements gathering sessions with stakeholders, including business users and IT teams, to identify and document project objectives, functional requirements, and data needs for RPA and BI initiatives
  • Designed and implemented automated workflows using Power Automate, reducing manual tasks and improving overall operational efficiency
  • Optimised SQL server queries by analysing query execution plans, identifying bottlenecks, and rewriting queries to improve performance and reduce query execution time
  • Collaborated with stakeholders to gather and understand dashboard requirements, translating them into visually appealing and interactive dashboards using Power BI
  • Created interactive prototypes using Balsamiq to simulate user interactions and validate design concepts before development
  • Incorporated user-centered design principles into wireframe designs, considering usability, accessibility, and user experience to create intuitive and engaging interfaces
  • Developed comprehensive user manuals for new system deliveries, providing clear instructions and documentation on system functionality, features, and usage.

INTERN

Virtusa Polaris (Pvt) Ltd
06.2016 - 12.2016
  • Organized and maintained physical and digital files, spreadsheets, and reports, improving accessibility and efficiency
  • Analyzed and resolved database issues, optimising indexes and implementing solutions that enhanced data accuracy and reduced query time
  • Provided customer service to clients through phone, email, and in-person interactions, ensuring prompt and accurate project updates
  • Conducted thorough research, collected relevant data, and updated spreadsheets to ensure accurate and up-to-date information for timely report generation
  • Assisted with user training for newly released systems, ensuring smooth adoption and minimising downtime during the transition period.

Education

Bachelor of Science, BSc (Hons) - Business Information Systems

University of Westminster

Master of Information Technology and Systems - Cloud Computing

University of Canberra
Canberra, ACT
05.2024

Skills

  • Project Management
  • Programming Languages
  • Web Development
  • System Analysis
  • Database Management
  • Data Visualization
  • Effective Communication
  • Analytical & Strategic Planning

Languages

English
Native or Bilingual

Affiliations

  • British Computer Society (BCS)

Certification

DP-900: Azure Data Fundamentals


DA-100: Microsoft Data Analyst

Accomplishments

  • FoodCrate2020: Solution produced for Cutting edge competition: Business Solutions :-A website with a primary function as an ingredient delivery service, with additional features such as blog posts and a forum, as well as an interactive Chatbot (solution built using Wix platform)

  • PCR Dashboard: Solution developed using Power Bi, DAX (Data Analysis Expressions) and SharePoint: Interactive report produced in Power Bi to track the number of positive employees, breakdown of spending for PCR tests by business unit and the monitoring of quarantine days
  • Honours Project: Languages used: SQL server, Power Bi, JavaScript, HTML/CSS, C# and SharePoint
  • Co-produced a full stack product that allows for tracking of garment sample as it is processed through the various stages, along with a productivity report which maps the targeted productivity against the actual productivity. In addition, production hours forecast for any particular sample which takes in previous production attributes such as operator efficiency, line efficiency. Final feature was a materials report which displayed the current level, minimum reorder level and maximum capacity to be stored.
  • Chatbot in python: using 2 libraries (random, time), and having 2 function definitions for user input and bot_response
  • Encryption in Python using a defined substitution cipher
  • Power Bi Projects: Sales and Revenue Analysis Dashboard:
  • Created a dashboard for a startup that provides insights into sales performance, revenue trends, and product sales breakdown. Includes features like geographic sales mapping, sales by category, and year-over-year comparisons.
  • Developed a Power BI dashboard that helps a subscription-based business understand customer behaviour, segment customers, and identify factors contributing to churn (customer attrition).
  • Foundational knowledge with the use of AWS Ec2, AWS VPC, Java.
  • Intermediate knowledge with the use of Power Bi, Tableau, Azure ML Studio, AWS IAM, Excel Solver, JavaScript, HTML/CSS, and Python.

Timeline

ICT BUSINESS ANALYST

H One(Pvt) Ltd
06.2020 - 01.2022

INTERN

Virtusa Polaris (Pvt) Ltd
06.2016 - 12.2016

Bachelor of Science, BSc (Hons) - Business Information Systems

University of Westminster

Master of Information Technology and Systems - Cloud Computing

University of Canberra
SHIRENDRA DE SILVA