Welcome to My Portfolio

PMP® || PRINCE2® || ISTQB®, IIST Certified || MBA || BSc || Agile Scrum Master (CSM)® || ITIL® ||
Senior QA Consultant

25+ years in the IT industry. 20+ years of which is in the system QA and Testing space; with a combined 10+ years as a (QA/Test) Manager or Lead.

Through years of consulting exposure with multiple clients and industries, Noel has developed transferrable skills and competency in system Quality Assurance, in conjunction with analyzing business requirements and bridging gaps between the business and technology using appropriate test approach, documentation, tools, and methodologies; contributing to the successful delivery of several major and multi-million projects in Canada.

Fun fact - did you know that the car company Ford, in 2023, tops the recall category and had a total of 54 products called back which impacted about 5.7 million vehicles? (source: carscoops.com).

According to the United States FDA data, global recall trend is going up since 2021.

One of the reason on why such a steady incline is that some companies tend to prioritize profit (ie., driving up productivity through quicker turnaround time) over product reliability and quality. At what cost? Financial loss, damaged reputation, legal implications, and product harm that leads, in some cases, in the loss of lives to name a few. Two cents.

For what it is worth, it must be the other way around. By prioritizing realiability and quality of product or service offerings, the increase in likelihood that profitability will organically follow.

There is not a doubt that quality and testing should start early in any work or project settings. It is easier and cheaper to correct quality issues and flaws early in the project lifecycle, rather than when the finished product is being tested or, worse, when the product is already in operational use. Prevention of such issues is achieved through quality planning, which also reduces the resources and risks involved in quality control. It was true then, is still true now. Watch here to learn more about the benefits, its principle, and concept.

Something to keep in mind - QUALITY is the revenue generator no one talks about so commit into it.

My Skills Summary

Noel is a highly motivated professional with a strong work ethic and the desire to make a positive impact in any professional environment. He bring a diverse range of skills, experience and knowledge that have been developed over the years through both his formal education and professional experience. A hardworking and dependable individual with a keen eye for detail and a passion for problem-solving aimed in yielding quality. An innovative and creative individual with a zeal for technology and a commitment to staying up-to-date with industry trends. Noel is a resourceful problem solver who is capable of quickly adapting to changing environments and making the most of any opportunity.

Key skills highlight:

  • Leadership
  • Problem Solving
  • Adaptability
  • Passion for learning
  • Comfortable with the unknown
  • Zeal for testing (let's hunt bugs!)
  • Team Player
  • Laser-focus on quality

My Portfolio Projects

Here are some of Noel's projects. Showcasing his work and skills on API and Test Automation, SQL Queries, Data Harvest, Data Cleansing, Data Visualization, Data Correlation, Data Scraping, CI/CD, Auto-API Pull, and Web Page creation.

Test Automation:
Python, Selenium, PyCharm, and PyTest (2024)

Test automation with Python, Selenium Webdriver, Selenium IDE, PyCharm, PyTest, and Github repository. Features the use of interacting with elements in a web page, record, playback, fixtures, setup, tear down, parameterization, test run using cmd line terminal, HTML reports, and Page Object Model (POM) design pattern to name a few.
Learn more...

Test Automation:
Java, React, NodeJS, VS Code (2024)

Test automation with Java, React, Node.JS, Auth0, Visual Studio Code, Vitest, Libraries, and GitHub.
Learn more...

API Test Automation:
Python, Playwright, PyCharm, PyTest (2024)

API test automation with Python, Playwright, PyCharm, PyTest, and GitHub repository. Covers testing that leverages XPath locators, Ajax handling, exception handling, parameterization, values from dropdown, radio buttons, and check boxes to name a few.
Learn more...

API Test Automation:
Python, VS Code, and PyTest (2024)

API test automation with Python, PyTest, Visual Studio Code, Github, and Libraries (ie., requests, json, uuid, os, datetime). Highlighting the use of methods such as GET, POST, PUT, and DELETE.
Learn more...

API Test Automation:
Python, PyCharm, and Postman (2024)

API test automation with Python, PyCharm, PyTest, Postman, JSon Beautifier and Editor, OAuth, Github, and Requests library. Features the use of methods such as GET, POST, PUT, and DELETE. Top it up with passing of parameters, payloads, among others.
Learn more...

API Test Automation:
Python, PyCharm, and FastAPI (2024)

API test automation with Python, PyCharm, FastAPI, Uvicorn, Github, and Pydantic library. Zero in on the use of methods such as GET, POST, PUT, PATCH, and DELETE.
Learn more...

MySQL:
Data Cleansing (2024)

Social media dataset. Spotlights the cleaning of data using SQL queries. With sampling that zooms in on removing special characters and updating undetermined record values. Leveraging SQL clauses (ie., Select, Create, Update, Join), aggregate functions (ie., Count, Sum), and virtual view.

The following tool(s) were used:
• MySQL Workbench
• Github
Learn more...

MySQL:
Data Cleansing (2024)

Housing dataset. Spotlights the cleaning of data using SQL queries, with sampling focus on standardizing date format, breaking out address into individual columns, removing duplicates, and so forth.

The following tool(s) were used:
• MySQL Workbench
• Github
Learn more...

MySQL:
Query Set (2024)

Grouped as basic and intermediate sets, it highlights the various ways of querying data from a table, from multiple tables, using operators (ie., like, and, or), aggregate functions (ie., sum, ave, min, max, count), subqueries, windows function, to name a few.

The following tool(s) were used:
• MySQL Workbench
• Github

For the basic set, learn more...
For the intermediate set, learn more...

Visualization:
Social Media (2024)

A subset of dataset (as of August 2022), activities that were covered includes SQL data exploration, data cleaning, moving results over into MS Excel, dashboard visualization creation; showcasing a variety of sampling scenarios in reference to the aforementioned topic.

The following tool(s) were used:
• Tableau Public
• MySQL Workbench
• MS Excel
• Github

For the SQL data exploration, learn more...
For the 1st Tableau documentation, learn more...
For the 2nd Tableau documentation, learn more...
For the 1st Visualization, click here...
For the 2nd Visualization, click here...

Visualization:
Covid-19 Portfolio (2024)

A subset of dataset (as of August 2024), activities that were covered includes SQL data exploration, moving results over into MS Excel, dashboard visualization creation; showcasing a variety of sampling scenarios in reference to the aforementioned topic.

The following tool(s) were used:
• Tableau Public
• MySQL Workbench
• MS Excel
• Github

For the SQL data exploration, learn more...
For the Tableau documentation, learn more...
For the Visualization, click here...

Visualization:
Airbnb Portfolio (2024)

A subset of dataset, the work featured few factors to consider if going into a rental business in a particular area.

The following tool(s) were used:
• Tableau Public
• Github
Learn more...

For the Visualization, click here...

Visualization:
Bike Sales (2024)

A subset of dataset, the dashboard spotlight flavors of scenarios on demographics that have purchased bikes; a sampling of by gender, commute distance, and age group presented in a chart visualization.

The following tool(s) were used:
• MS Excel (pivot table and charts)
• Github
Learn more...

For the Visualization, click here...

Visualization:
Power BI (2024)

A subset of dataset, the dashboard underscore flavors of scenarios from a survey of working class folks; a sampling of by gender, country of survey takers, average salary by job title, and more. Layering it with activities of data cleanup and data visualization work.

The following tool(s) were used:
• Power BI
• MS Excel
• Github
Learn more...

For the Visualization, click here...

Data Correlation:
Movies Data (2024)

A subset of dataset, the work underlines the data cleanup and data correlation activities in line with the subject and dataframe under test.

The following tool(s) were used:
• Jupyter Notebook
• Python
• Github
Learn more...

Data Scraping:
Amazon Web (2024)

Using Amazon webpage, the project showcased the how-to of web data harvesting, automating its run, and auto-create (and append) a csv file; taking advantage of BeautifulSoup and Requests Python libraries.

The following tool(s) were used:
• Jupyter Notebook
• Python
• Github
Learn more...

Continuous Integration/Continuous Delivery (CI/CD) (2024)

A regression suite, highlighting a working test code that is scheduled to run a daily routine validation, ensuring a continuous code injection does not break any of the existing set of codes.

The following tool(s) were used:
• Github
Learn more...

For the Action outcome, click here...

Automation:
API Pull (2024)

Features a set of code zoomed-in on automating an API Pull. Layering it with flavors of data cleanup and data visualization work.

The following tool(s) were used:
• Jupyter Notebook
• Python
• Github
Learn more...

Web Page:
My Portfolio (2024)

A showcase in creating a personal portfolio website, leveraging the HTML5 code.

The following tool(s) were used:
• Visual Studio (VS) Code
• Github
Learn more...

For the live portfolio webpage, click here...

Have Questions?

Cool! Noel got answers.

Sure can. First job back in 1995 was in Retail Banking, I started in Bookkeeping and Accounting, then got moved over into Customer Service as a Bank Teller. Flipped over into Technology in 2000; I was a Developer (AS400, Visual Basic), DBA, Systems Analyst, and Business Analyst from past life. I have been in the Senior QA domain since 2008.

Notable question. Industries I have worked with - IT Consulting, Hospitality & Gaming, Healthcare, Wealth Management, Financial Services & Banking, Accounting, Pension & Benefits, Oil & Gas, Insurance, Agribusiness, Higher Education, and Inventory Management & Distribution.

I got one, and it was back in 2011. As a QA Lead, I worked for a project in a Higher Education setting. After it concluded, the project was awarded of the 2011 PMI Manitoba Project of the year. Follow this link for a quick overview. Here is a list of past winners (see 2011).

Nifty ask. I worked in the Healthcare domain for a cumulative total of 8+ years. Project roles that I had was a Senior QA Analyst, a QA Lead, and at one point was a QA Team Manager. Second to it is a collective 6+ years in the Wealth Management domain also as a Senior QA.

Good stuff. It was in the Healthcare domain. A multi-million dollar package implementation project spanning to 6 enterprise solutions, 20+ interfaces, millions of converted data in multiple pillars, thousands of configurations, 6000+ users, 1500+ workstations, 250+ printers, and 250+ clinics.

Sure did. In 2009, as an IT Consultant, I started with a Consulting company based in Manitoba, Canada. Part of my tenure, I was the Quality Assurance Practice Leader for Central Region (2013-2017), as well as a Career Mentor (2015-2017).

Excellent ask. I have been working as an independent Senior IT QA Consultant since the mid of 2017. With my company (incorporated), I partner with clients in delivering technology solutions, aimed towards excellence through quality assurance, analysis, and testing.

You bet. Here are some in my toolstack - Azure DevOps Server, Jira and TM4J, Test Link and Clear Quest, Trac and Eventum, Python, Playwright, Selenium Webdriver and IDE, Java, React, Node.js, HTML5, IDE editors (ie., Visual Studio Code, PyCharm, Jupyter Notebook), Web Server (ie., Uvicorn), Frameworks (ie., FastAPI, PyTest, Vitest), Platform (ie., Postman), Python libraries (ie., Requests, Pydantic, Pandas, Numpy, BeautifulSoup, Seaborn, to name a few), OAuth and AuthO, GitHub, Visualization tools (Tableau Public, Power BI, MS Excel pivot table and charts), HTML test reports, and MySQL Workbench.

Certainly. I have the following certifications:
• Project Management Professional (PMP)®, Project Management Institute (PMI-PMP)
• PRINCE2® Project Management Foundation 7th Edition, PeopleCert
• Test Manager, International Institute for Software Testing (IIST)
• Test Manager, International Software Testing Qualification Board (ISTQB)®
• Test Automation Engineer, ISTQB®
• Tester, Mobile Application, ISTQB®
• Tester, Foundation Level, ISTQB®
• Agile Scrum Master (CSM)®, Scrum Alliance
• ITIL® v3, EXIN

Great question. I got the following degrees:
• Masters Degree, Business Administration (MBA)
• Bachelors Degree, Management (BSc)

Absolutely. I have had the chance to attend conferences organized by Techwell Software Quality Engineering (SQE) in San Diego CA, Anaheim CA, Las Vegas NV, and Orlando FL. On top, I have been in one of the John Maxwell Leadership conference in Canada.

Insightful ask. To compliment my academic credentials and years of work experience, I made use of my downtime learning and polishing my technical, data harvest, and testing knowhow using tools for API and Test automation, data cleansing, data visualization, data correlation, data scraping, API Pull, CI/CD, webpage creation, and SQL queries. Going through online materials and boot camp aided me to have a better understanding and familiarity of various latest concepts and tools; having projects and tangible documentation that I have completed, compiled, and published.

For sure, it's entitled "Purpose Driven Testing". Follow this link and have a peek.

I thought you'd never ask. Here are some that I hope can help:
• Why Testing Early in the Software Development Lifecycle Is Important
• Early & Static Testing: Life-Changing Benefits for Your Application
• No Pain, No Gain: Early Test Automation Is Worth The Effort
• 11 Reasons Why Software Testing is Important

Indeed. Canada is home since 2005. I love exploring other parts of the world, I got passion to be around with family and friends, I delight meeting people, and have a soft spot with video games. I am able to work remotely and willing to travel as work requires. Resides in Metro Vancouver BC.

Thanks for checking out my page!

Before I let you go, I leave you with this quote from John Ruskin...

"Quality is never an accident; it is always the result of an intelligent effort."