Learn Data Skills
Beta
Simon Wong

Simon Wong

Database Developer / Data Engineer

Self-Employed

Technologies

My Portfolio Highlights

My New Track

Data Engineer

My New Course

Introduction to Python

My New Track

Data Engineer

Insights conductor, orchestrating a symphony of knowledge from data streams.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Introduction to Python

course

Intermediate Python

course

Introduction to SQL

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Microsoft Microsoft Certified Solutions Associate

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Intermediate Python
Understanding Data Engineering

My Work Experience

Where I've interned and worked during my career.

Freelance | Jan 2022 - Present

Database Developer

As a freelancer providing database development or data engineering service.

lululemon | Aug 2021 - Sep 2021

Data Engineer

bug fix, and testing of the ETL process to make sure performance was optimized for the peak season. • Improved performance of the PostgreSQL transformation script running on AWS cloud platform. • Developed code using Agile development methodology with Continuous Integration and Continuous Deployment. • Utilized GitHub for software version control, JIRA software for issue/task tracking, and Confluence software for documentation and information sharing. • Collaborated with other team members and participated in daily standup meeting to update development status and resolve any outstanding issues.
Show More

Maximus Canada | Jun 2017 - Dec 2019

Application/Database Developer

Assigned developer for British Columbia Medical Services Plan (MSP), daily investigating, debugging, testing, and correcting program errors to ensure applications ran efficiently. Created and maintained database schema objects. Loaded data from various sources into data warehouse. Resolved technical issues with external vendors. • Solved technical issues and provided database support in a timely manner resulting in an increase in production. • Utilized Oracle Data Integrator for ETL data loading from different databases into Enterprise Data Warehouse for data analysis and reporting purposes. • Executed database tuning including indexing, complex SQL queries, stored procedures, and functions, resulting in improvement in operation. • Analyzed data requirements for report writing purposes and assisted in modification of existing information systems to meet those requirements. • Developed and updated documentation using Confluence software to enable users to understand and resolve errors and avail developers of resolutions for previously addressed technical issues. • Applied Functional Design Specifications to generate Oracle BI reports for MSP applications enabling management to assess performance, strengths, weaknesses, and areas of improvement. • Built reports by extracting data utilizing complex ad-hoc SQL/T-SQL queries for leadership review and use for building stronger business practices. • Collaborated with Business Analysts, DBAs, Testers, other application developers and users to make sure projects were on time and on budget.

Avocette Technologies Inc. | Jul 2014 - Mar 2016

Database Developer

Maintained and updated databases for four Ministry of Children and Family Development (MCFD) software applications including Oracle and SQL maintenance and support, daily monitoring of batch jobs and documentation of operations. Coordinated efforts with team members for optimal output. • Cleansed data using complex SQL codes when needed to make sure data were clean and accurate, leading to less data errors. • Analyzed, debugged, and fixed Oracle PL/SQL stored procedure, function, and trigger errors, resulting in performance improvement. • Constructed complex Crystal reports for Accela Government Software application to display, summarize, and aggregate information for management.

Freedom 55 Financial | Jan 2011 - Jun 2014

Financial Advisor

Conducted financial planning assessments with clients, reviewing current financial situation, and offering investment solutions to achieve goals. Established and implemented customized plans. • Generated new clients by building trust and emphasizing personalized service to the individual investor. • Maintained existing client base by understanding individual needs, evaluating portfolio, and offering educated advice on future investment.

My Education

Take a look at my formal education

B.Sc. in Computer ScienceUniversity of Ottawa | 1986

About Me

Simon Wong

Hello, my name is Simon, and I am a database developer/engineer with over 5 years of experience in designing and developing databases for various organizations. I hold a degree in computer science and am skilled in SQL and Oracle databases.

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free