SUMMARY:

I am a well - rounded, experienced QA Engineer with a proven track record in testing a wide variety of software projects. I have extensive experience with databases and data warehouse, ETL, and SQL databases. I thrive in both XP/Agile and waterfall environments. I enjoy any opportunity or task that involves coding, and I am known for being able to keep calm and focused in high stress, deadline driven work environments. On many of my teams I have been regarded as the subject matter expert in database testing, and have demonstrated success in ensuring quality releases of software.

SKILL:

ETL Process Testing

Database and Data Warehouse Testing

Integration Testing

UAT Testing/Lead

Netezza/Postgre

SAP/HANA

Tableau/PowerBI

AWS Snowflake database

Oracle

MS SQL Server

MongoDB

Ultipro

JIRA/Confluence

TFS Azure Devops

HP

HTML, XML

PHP/MySQL

WORK EXPERIENCE:

Confidential, Seattle, WA

QA Lead

Responsibilities:

• Testing required keeping track of 1 to 3 simultaneous small projects managed by different teams.
• The largest project was a migration of an enormous amount of data from an Oracle database to SAP HANA database as calculated views, where it would become accessible to PowerBI report generation and analysis by data scientists.
• Testing required using limited hardware resources to validate correctness and accuracy of billions of rows of data.
• I was also responsible for a successful UAT test cycle, coordinating about 20 very busy engineers and data specialists in their evaluation and testing of this new set of data.
• I was involved in early design/requirement gathering on several of these projects and was able to participate in PowerBI report design, providing ideas that would clarify and focus on meaningful data trends, many of which were adopted in the final design.

Confidential, Seattle, WA

Sr QA Analyst

Responsibilities:

• validating ETL migration and Tableau Reporting processes for product orders and fulfillment, demand and sales, store traffic, and other metrics at Store, District and Corporate level.
• I tested for completeness of data, data transformations, and accuracy of data, aligning resulting Data Warehouse data with source data primarily from SAP and Sterling databases.
• Validation included slow-moving dimension tables and transaction history tables.
• Project work was tracked in JIRA, and documentation was placed in either Confluence or Sharepoint.
• Test Cases were developed using the Zephyr JIRA Plug-in.

Senior QA Analyst

Confidential

Responsibilities:

• I was a Sr QA Analyst for BI/BW department, validating ETL migration and Tableau Reporting processes for product orders and fulfillment, demand and sales, store traffic, and other metrics at Store, District and Corporate level.
• I tested for completeness of data, data transformations, and accuracy of data, aligning resulting Data Warehouse data with source data primarily from SAP and Sterling databases.
• Validation included slow-moving dimension tables and transaction history tables.
• Project work was tracked in JIRA, and documentation was placed in either Confluence or Sharepoint.
• Test Cases were developed using the Zephyr JIRA Plug-in.
• I also worked as a Senior QA Analyst on numerous e-commerce related projects, most recently the Supply Planning project which integrated SAP, Enovia, Assortment Planning tool, AWS Aurora database, and Vanguard supply planning application to track Confidential branded merchandise development from initial product design through assortment planning, to finished goods for an 18 month product development cycle.
• I performed integration testing, provided environment and configuration plan to identify all interconnected facets of the project and their configurations.
• I was testing software to support product picking, packing and shipping on sales or warehouse floor using mobile devices.
• I also tested the Ariba Contract Compliance implementation using SAP and Ariba to create purchase order requests and route them through the approval cycle for publication to vendors.
• At this company, change management was controlled by the design and management teams.

Confidential, Seattle, WA

SDET

Responsibilities:

• I tested both OLTP and reporting databases in Oracle, MongoDB and HDFS, validating scripts thatdodata cleanupand schema restructuringduring an aggressive cycle of product growth and adjustments to data schemas, and validating aggregation of Mongo customer database, rendered in charts and graphsfor the reporting dashboard.
• I started this work with no prior knowledge of MongoDB and became the QA subject matter expert within a few weeks, training two other SDETs prior to the end of my assignment.
• Other areas of test includedupdating automated test scripts in Java/Junitto verifyAPI foronline purchasing of new products and subscription-based products, regression/system testing monthly Vertex sales tax updates, and system and integration testing user password reset feature to perform simultaneous reset of password in multiple product lines/websites/devices.
• I performed functional testing ofOracle OLTP cleanup scripts and updates to perform bulk cancellations, deactivations of discontinued products,and adding new products and subscription plans.Database testing included white box testing of code, functional and white box testing of deployment scripts, release support, and regression testing all scenarios involving purchase, refund, subscription billing, and upgrades/downgrades of subscription products including proration.
• I made significant improvements to an already excellent testing methodology of new product releases.
• I wrote a SQL script to perform cascading delete of fifteen interrelated tables in order to allow rollback/rerelease of database scripts in QA environment.
• At this company, change management was controlled by the design and management teams.
• Project sprints were tracked in JIRA.

Confidential, Tacoma, WA

Software Test Engineer

Responsibilities:

• performing black box system and integration testing for Confidential, a point-of-sale application used in all Labor Ready branches in the United States.
• My participation on this team helped to improve stability of Confidential, and increased accuracy of state and local payroll tax calculations.
• In addition I wrote or updated several hundred test cases for new and altered features in Confidential .
• Areas of test included worker drug and background checking, hiring, skill and performance tracking, dispatch to job sites, payment, garnishments; payroll taxes at federal, state and local levels; customer quoting, credit, invoicing, payment, refunds, unclaimed property (escheatment), ccg (cleared check gateway), collections, and general ledger/accounts receivable.
• Also assigned to test eCustomer, a customer facing website that allows customers to initiate and track job orders and pay/review invoices.
• Integration testing involves flat-file data transfer to and from numerous external sites including Vertex, Talx, LTTax, Tescor and Greenshades.