Angela Liu Email & Phone Number

Edmonton, Ab, Ca

Edmonton, Alberta, Canada

- Integrated Casper and Goodkind systems with Slate using Python to automate data matching and transfers via SFTP, massaging data by using libraries such as logging, pysftp, os, sys, and shutil and mapping data within Slate. Also implemented the School Finder-Slate integration via API endpoints, enhancing data accuracy and streamlining workflows.- Developed and implemented an Exam Scheduling Algorithm for the ETT department, processing data for 50K+ students and staff by extracting datasets from Campus Solutions, refining them in the SQL database, and optimizing results using Python.- Administered the Transfer Credit Database System by extracting SQL code from Campus Solutions, massaging SQL data in DBeaver by using queries, and deploying it to Coveo using Eclipse IDE with Java, managing exceptions through an exception controller, and handling data access via repositories and DAOs, and facilitating direct CSV uploads for streamlined data integration.- Led records management across digital platforms by resolving tickets, automating workflows, streamlining user access, addressing billing issues, creating/editing new forms, updating website content and maintaining 3rd party softwares - Slate, Jira, JotForms, Waitwell, UI Path and Trello, and providing daily support to various University of Alberta departments.- Collaborated with Con-Ed (OCE) for website development and customizations for CERegistrar (Destiny One) for improved user experience.- Developed user-level and technical documentation for system processes in Confluence, conducted staff training sessions, and participated in stakeholder meetings to discuss next steps, ensuring efficient electronic records management.

Kamloops, British Columbia, Canada

- Assisted with developing software solutions using low-code platforms like ProntoForms, Microsoft Power Automate for data manipulation, and routing Microsoft Power Apps for business end-user interaction with data.- Developed interactive business reports and dashboards using Microsoft Power BI, resulting in improved data visualization and decision-making processes for the organization.- Served as the point of contact for resolving bugs and implementing updates, ensuring uninterrupted operations, and maintaining high-performance measures across multiple business areas.- Administered and enhanced business systems to respond to bugs, updates, or evolving user needs.

Kamloops, British Columbia, Canada

- Designed, developed, and maintained web applications including a Linux platform and Java programming.- Managed the Kamloops City full-stack web development project for Network and Fibre Connectivity by providing an overview of estimated cost options for connecting the buildings (Kamloops City Network- KCN, Wireless, Others).- Analyzed in various capacities for IT Gap Assessments by designing a disaster recovery plan and backup procedure to ensure complete protection of servers and workstations.

British Columbia, Canada

- Attended peer mentor meetings & and participated in different training sessions.- Supported students with a multitude of writing styles knowledge like APA, MLA, and AP.

Bachelor Of Science - Bs, Mathematics And Computer Science

Activities and Societies: Participated in Annual Governors Challenge representing 2021 Thompson Rivers University and presented.

French Studies

High School Diploma

Activities and Societies: Vice President of Student Council, Assistant Secretary of Computer Club, ASISC National Basketball Participant.