Software Developer

• Oct 2022 - Present

Data Specialist Intern

• Sep 2021 - May 2022

Understanding the consultation business by actively working with clients to meet project needs. Streamlining internal processes by creating reusable code to increase business efficiency. Building relationships in the Traction Community. Actively looking for opportunities to learn Data Warehousing, Mulesoft integrations, Tableau Analytics and engage with the sales and marketing team to learn about lead acquisition and conversion. Client projects, Data Migration: - Extract client data from CRM systems to MS SQL server; Understand, Analyze and Transform client’s data to Salesforce Object Model; Use and tweak Traction’s in-house data migration tool to load data to a new Salesforce instance. Internal Process improvements: - Data Traction Tires: Developed a dataset using Mockaroo, Python and SQL Server that mimics client data coming from a non-Salesforce CRM system to be migrated to a target Salesforce org to give new onboarders a realistic data ETL and migration experience. Created a custom AppExchange package that mimics NPSP relationships (junction object) using Flow Builder to be installed in the target Salesforce org to support data load. - Knowledge Article Migration: Developing a Python script for easier org-to-org Knowledge Articles migration. The script downloads the files associated with legacy Knowledge Article Version records and uploads the files to the new target org to get new URLs. The URLs are replaced in the XML image tags found in the Rich Text Area field of KAV records before migration to achieve perfect functionality. -- MS Azure, SSMS, SQL, DBAmp, Salesforce Show less

Web Application Developer Co-op

• Sep 2019 - Apr 2020

* Aided in the development of an enterprise-level, web-based faculty management system called eTRACS (Enterprise Teaching Research And Collaborations System). * Designed and Implemented various modules for the eTRACS system using MySQL and PHP with the Laravel framework for back-end and ReactJS for front-end. * Collaborated with 5 developers and 6 Business Analysts in an agile environment incorporating Scrum methodology where the tasks were divided into 2-week sprints. * Worked remotely and independently, maintaining good coding practices, to create a Faculty Budget * Allocation module by creating a reusable custom react component. Users are able to select multiple fiscal years and faculties depending on which structured data are returned from the back-end to translate to editable panels in the front-end. Show less

Crew Member (Part-time)

• Jan 2018 - Aug 2019

Worked in a team to serve about 100 customers every shift in a fast-paced timely manner. Worked with point-of-service (POS) system to take orders. Followed food safety procedures to prepare, cook and assemble food. Took initiative to do extra tasks when assigned tasks were completed such as cleaning and dishwashing. Worked in a team to serve about 100 customers every shift in a fast-paced timely manner. Worked with point-of-service (POS) system to take orders. Followed food safety procedures to prepare, cook and assemble food. Took initiative to do extra tasks when assigned tasks were completed such as cleaning and dishwashing.

Drupal/PHP Web Developer (Work-study)

• Jan 2019 - Apr 2019

Project Purpose: To assist with the development and maintenance of CJSF’s Drupal/PHP based website including adding and customizing new modules; UI, CSS and design improvements; custom coding, etc. Duties: Installing and customizing modules and site features. Objective: experience implementing modules and new code in Drupal CMS. Researching and installing existing modules to meet planned goals. Objective: knowledge of the Drupal module system Researching and implementing overall site design. Objective: Understanding of site architecture and Drupal structure and sytems Researching, planning and coordination of new promotional items and initiatives. Objective: Research skills, professionalism, planning and coordination skills Accomplishments: Learned HTML, Drupal CMS, PHP, Apache, MySQL and Terminal commands by researching on the Internet. Added a Listen Live button which pops up a new window so that users can listen to the radio while browsing the site. Integrated Jplayer module with Views module in Drupal to create a playlist that is used to play CJSF’s top chart music on the website. Configured Apache’s httpd.conf file and set up MySQL database on a different server to create a staging server to do all development work for the website. Working on developing a custom module that retrieves data from another site (djland.cjsf.ca) and puts the data on a form so that it can be displayed on the cjsf.ca website on click of a button. Show less

Vice President

• Jan 2018 - Dec 2018

In charge of event management. Helped with budgeting for events. Guided club volunteers about the assigned tasks in events. Communicated with other clubs in SFU regarding collaboration or joint events. In charge of event management. Helped with budgeting for events. Guided club volunteers about the assigned tasks in events. Communicated with other clubs in SFU regarding collaboration or joint events.

Private Tutor

• Jan 2016 - Jun 2016

Provided home and private tutoring to O Level Students in Math, Physics and Chemistry. Provided home and private tutoring to O Level Students in Math, Physics and Chemistry.