Matthew Gebken sab

**** ** ***** ***. #* email: ac0g3b@r.postjobfree.com cell /voicemail 808-***-****

Portland, OR 97229 www.linkedin.com/in/matthewgebken/

PROFESSIONAL SUMMARY

Quality Assurance Engineer / Sr. Programmer Analyst with 22+ years delivering software and database solutions which have met or exceeded customer expectations. Recent Validation Engineer experience at Intel (Jones Farm) using Bash Shell, Linux RedHat 6.7, 7.2, SQL Server 2008 R2, Visual Studio 2012, SQL Server & Stored Procedures, MS Test Manager, ScrumWise, TFS (Team Foundation Server), Jira, Trello, Fogbugz, Source Tree, git, Bugzilla, Nunit. Past software QA / test experience with Selenium IDE, UNIX, Rational Robot, Eclipse, WinRunner, XRunner tools. WEB Development using Perl-CGI / HTML. A solid team leader who achieves milestones in overstressed projects while contributing to process improvement.

"I always find something to like in every person I meet."

Information Technology Expertise

Operating Systems: Windows Server, Linux, UNIX, Windows 7, 8.1, Citrix

Requirement & Tracking tools: Visual Studio TFS Team Foundation Server, Jira, Scrumwise, Fogbugz, Mockingbird, MockFlow Wireframe, Browser Stack, Bugzilla, Visual Studio: CodedUI, Mercury Interactive tools: Xrunner & WinRunner, TestDirector, SharePoint

Database Tools: Microsoft SQL Server Management Studio 2014 – SQL Server 2008 R2, BizTalk: BizTalk Business Rule Composer, BizTalk Server Administrator-2010. Oracle Forms 2.3, 3.0, 5.0, 6.0 Oracle Forms Developer, Oracle ReportWriter, SQL-Plus, SQL Navigator, Noetix Views, BrioQuery, Seagate Crystal Reports

RUP Rational Unified Process tools: Robot, TestManager, ClearQuest, ClearCase, RequisitePro, Rational Rose, Windows Snipping Tool

Microsoft Visual Studio: v12, SourceTree v 1.5 Microsoft Office suite: Outlook, Access, Excel, Groupwise, Visio, CVS, SCCS, Jedit v3.2.2, ActivePerl v5.6 w/Eclipse framework. Microsoft Virtual Machine Manager 2008 R2

Browsers: Internet Explorer 8, 9, 10, 11 Chrome, Safari, FireFox

Languages: PL/SQL, XML, HTML, Perl, UNIX, Bash shell, C shell, Korn & Bourne shell, Visual Basic-5&6, Java 2, Pascal, TCL/TK, Windows PowerShell ISE, Python

PROFESSIONAL EXPERIENCE

Sr. Validation Engineer: Intel Corp Jones Farm campus, Hillsboro, OR November 2016->Feb 2017

Contracted through: Derive -Talent on Demand

Originated, ran & updated all automated & manual validation tests for System Support Utility as migrated from Windows to Linux platform.

Worked in Agile environment with paired developer. Produced 1,200+ lines of working code in 60 days.

Using Bash shell, wrote automated test framework with specific, global and failure logs in 10 days.

Recorded all bugs in HCD ES tracking system with steps to reproduce, including screen shots of problem on 5 difference Linux platforms. (RedHat6.7, RedHat7.2, Ubuntu, Suse 11, Suse 12)

Well versed in “Raritan CommandCenter Secure Gateway”, HCD ES, Team Forge – Secure Git using Gerrit-enforced model for ‘git’ based code review, SAP Fieldglass time sheet management system.

Maintained and updated test documentation using SharePoint, Excel & Outlook for individual test cases as specified by Intel driven DCR (Document Change Request) process.

Used TEAM Foundation with git for daily code check-in and builds. Tracked time & milestones w/Jira

Participated in weekly bug scrubs to assess severity and priority of bugs.

Sales Engineer: Strategic IT Staffing Roseville, CA February 2016->July 2016

Demonstrated and sold portable solar panels, batteries and other Goal Zero products in Costco roadshows.

Scheduled 2 eleven day road shows per month at Costco warehouse stores throughout Westerns states. Co-ordinated all setup and pre-sale inventory activities with Costco store manager. Set up booth solo.

Demonstrated product to Costco members. Calculated total watts from amps drawn for each application..

QA Automation Engineer: D+H – Financial Technologies Portland, OR May 2015->Nov 2015

Automated source code and install testing for data interfaces across all interface product lines.

Wrote interface test classes and methods using C#, .net in Visual Studio 2012. Verified accuracy with Test Explorer. Maintained test data control using SQL Server with normalized parent/child tables.

Executed and reviewed 30 thousand source code tests over the course of 3 months. Created separate email reports for Errors, Results and Exceptions. Coded UI was used to automate installation of product.

Worked with management and existing processes to clean up source code inconsistencies.

Used TFS for daily check-in of all C# and SQL source code files. Test docs archived using SharePoint.

Provided weekly code review/demo with each week's status.

QA Engineer: Huron HealthCare Lake Oswego, OR Aug-2014-Jan-2015

Tested data and transactional integrity of ‘Aeos’ Revenue Cycle optimization product. Emphasis was mainly on black box and regression testing using both GUI and data extract/transformation scripts in SQL.

Extensive recent use of Visual Studio TFS (Team Foundation Server) to track and work PBI (Product Backlog Incidents) and SBI (Sprint Backlog Incidents). Extremely familiar with parent, child, related, links & change set relationships and their updates.

Verified TFS change sets using Beyond Compare and ExamXML Pro were correct in multiple development branches. Developed short scripts using Windows PowerShell ISE,.

Tested SQL Stored Procedures in Visual Studio / SQL Server environment using both modify/execute and Execute Stored Procedure methods exercising each of the required passed parameters.

Worked in 5 week SCRUM sprints using Trello, TFS, Excel & Outlook to record and monitor progress.

Used Biztalk Business Rule Composer to verify middle layer business rules implemented in Aeos database application. Tested application using BizTalk Server 2010 using published and non-published business rules.

Used VMs (Virtual Machines) for testing build branches. Restored check points using Virtual Machine Manager 2008 R2 in the build / test process. Owned and maintained 2 – 4 boxes during the test cycle.

QA Analyst: Succeed Management Solutions Lake Oswego, OR Feb-2013-Aug-2014

Positive, Negative, Black Box, White Box, Unit, Integration & System testing. Bug reporting and process improvement.

Adopted Context Driven Testing approach advocated by James M. Bach.

Used Jira, Trello and JFogbugz to report production and development bugs.

Worked in 2 week SCRUM sprints using Scrumwise & Jira to record user stories with progressive completion to ‘done’.

Wrote and debugged test scripts using Selenium IDE on FireFox browser.

Ran ad hoc queries with SQL Server 2008 R2 using SQL Server Management Studio v 10.5 to construct Inner, Left, Right & Full Outer joins with ‘Where’ and ‘Order by’ clauses.

Hand calculated TCIR (Total Case Incident Rate) reports to discover data was being pulled from the incorrect SQL database.

Researched DART (Days Away Restricted Transfer) reports to identify & correct formula producing inverted data.

Initiated process improvement – generated & distributed button click sequence steps to allow customer support specialists to reproduce bugs in development environment.

Used Visual Studio 2013, SourceTree to get latest code changes, rebuild solution and run debugger while testing in development environment.

Initiated 3 ten minute huddles per week with customer Account Executives to improve inter-departmental communication and reduced bug backlog. Website: www.succeedms.com

Sabbatical: Rosewood Park Hillsboro, OR Aug-2011 --> Feb-2013

Property Transportation Co-ordinator, drove and maintained busses for Rosewood Park retirement home.

Sabbatical: Huelo farm Huelo, HI Nov-2008-->March-2011

Property Management, landscape projects, painting, car repair

QA/ Test Engineer: Kryptiq Corporation Hillsboro, OR Feb-2005-->Aug-2008

Successfully wrote test cases and improved test coverage for DocuTrak & Document Management products.

Worked with Kryptiq’s DocuTrak product to define, test and administer a regression test suite.

Assisted co-workers with product setup and recording of test results.

Tested application with GE Logician Physician Office product – wrote & executed SQL queries

Tracked bugs using Bugzilla with follow-up test verification after each issue was fixed by engineering.

PERS: BUSINESS analyst/QA Tester Tigard, OR March-2004-->Sept 2004

PERS – Oregon Public Employees Retirement System: Successfully learned and ran Mercury Interactive Xrunner and Rational Robot test software used to implement automated regression testing in the IBM mainframe / Attachmate emulator environment.

Worked with IBM Mainframe DBA to define, test and administer a new mainframe regression test region.

-Used Oracle download with BrioQuery tool to extract test data for IBM mainframe test cases.

Used Eclipse development environment with HTML & Perl (ActiveState ActivePerl version 5.6) to update and enhance the existing retirement calculator at http://www.pers.state.or.us/.

-Reviewed design and test specifications for the update the new version of retirement calculator.

-Developed a working phase 2, 'proof of concept' prototype in 4 weeks.

PERS: Web-Developer/Sr. Perl-HTML Programmer: Tigard, OR March-2003-->Oct 2003

PERS – Oregon Public Employees Retirement System: Contracted through SolutionsIQ

Successfully installed new retirement calculator on public website ahead of schedule and within budget. Used Perl (ActiveState ActivePerl version 5.6) to re-design the existing retirement calculator at http://www.pers.state.or.us/.

Gathered requirements, interviewing actuaries, accountants and customer reps.

Evaluated a competitor product in order to incorporate highest scoring features in the re-design.

Solved a difficult network / webserver install problem with Microsoft IIS and wrote a phase 1 Retirement Benefit Calculator using rapid prototyping in perl/HTML within the first 3 weeks.

Initiated product usability testing after completing unit and system testing. Identified and corrected a product design flaw. (Specifications had not been complete at the time of original proto-type because it wasn’t clear which reform bill would pass the Oregon Legislature.)

-Implemented, tested and released the revised spec solution within 5 days.

Sr. Programmer/Analyst: Regence Blue Cross/Blue Shield Portland, OR Feb-1998 – Nov-2002

Lead programmer to develop report, query and data base applications for Medical Affairs on IBM Mainframe, UNIX and Windows operating systems, using Oracle database and development tools in the data warehouse.

Wrote and tested PL/SQL, Oracle & K-shell scripts in designing a data cleaning process for the Diabetes Lab Reporting database. This process inputs raw medical lab results, extracts and normalizes (‘cleans’) the data to Blue Cross membership specifications. Multiple high-risk test results are intersected with high-risk members providing an intervention report for better member health and significant cost savings.

-Defined Entity-Relationship diagrams, worked with Oracle DBAs and data architect in approval process.

-Rapidly prototyped a stubbed system in 4 weeks, conducted user evaluation, incorporated feedback into successive versions and delivered a functionally complete ‘on-line’ system 2 weeks ahead of schedule. (SQL, Oracle RDBMS versions 6.4, 7.3, 8i)

-Integrated Diabetes database with data warehouse containing over 1,100 tables, (widest medical claim table contained 167 columns at 4.5 million records) optimized queries, filtered results, wrote reports. (PL/SQL, Oracle Reportwriter, SQLPlus)

-Incorporated multi-level user feedback. Optimized design allowed me to add new data elements for Serum Creatinine blood test results within a 6 week window after 1 years of collection use.

Completed Oracle Forms 6.0 update training and used it to update / maintain CPT / ICD-9 medical code application. (Oracle Forms 6.0, Stored Procedures, Triggers, SQL)

Quality Assurance Tester for data warehouse transfer / integration / data verification project - REMAC.

-Used SQL Navigator, PL/SQL, SQL-Plus scripts, Stored Procedures, SQL Loader to extract data, create Oracle views and base tables of Oracle test environment.

Project leader for 2 application product families during the Y2K code verification / rewrite phase.

-Managed Lead Contract programmer for Aion Language based “Expert System” applications. Negotiated schedules, identified risk, conducted code walks / inspection, originated test documentation. Hosted Aion expert consultant, coordinated installation schedule with mainframe system programmer.

Lead Programmer for Visual Basic / Access application for Oregon Health Plan (OHP). Wrote translator, formatter from Paradox to Access using Perl.

Sales/Technical Support Engineer: Noetix Corporation Beaverton, OR Jan-1997 -– Nov-1997 Provided consultation to Noetix Views.

Installed Oracle Financials, Noetix Views, Business Objects, Impromptu and Oracle Discoverer query tools. Reproduced field problems with a simulated customer environment and phoned Oracle DBAs with solutions to Noetix View issues.

Wrote and optimized queries using Oracle Financials and Noetix Views.(SQL, SQLPlus, Discoverer)

Demonstrated Noetix Views, supported Sales at Oracle trade shows, answering technical questions.

Software QA Engineer: Mentor Graphics Corporation Wilsonville, OR Sept-1995 -– Nov-1996

Developed new test cases for the DFTAdvisor product, which uses software simulation of hardware to determine whether every node in the integrated circuit is testable.

Wrote test plans and quality plans, maintained metrics for quality tracking of DFT (Design For Test) products, measured and improved test coverage using Purify PureCoverage test tool.

Served on divisional ISO 9000 process improvement team in preparation for company wide audit.

Oracle DBA, Forms Developer, Software QA: Analogy, Inc. Beaverton, OR Feb/1989 – Sept/1995

Analogy is a mixed signal: analog/digital simulation design tool provider.

Developed problem tracking data base & associated forms, managed release testing, defined quality metrics & process improvement for this successful startup company.

Designed, developed and administered a bug tracking Oracle data base with Oracle Forms v2.3, 3.0, / SQLPlus scripts for over 6 years. Installed on Sun, HP and DEC workstations.

Weekly & daily reports were prioritized by product category & problem severity. Management used this system as a critical risk assessment metric during the product release cycle.

Designed and built regression test framework that insured forward compatibility of new product versions. Worked with product design engineers to both originate and record over 2,000 test cases.

Automated regression testing in the UNIX environment (Cshell, at) to run overnight with TCOV code coverage tool. Addressed graphical inconsistencies across multi-platform testing with phased evaluation and implementation of Mercury Interactive – XRunner screen capture tool.

Proposed and implemented metric tracking of active critical bugs with regression test failures. Quality measures were improved significantly without incurring increased costs.

CAE Manager: Lear Astronics Corp. Santa Monica, CA Dec/1986-Jan/1988

Software support and systems administration for engineering CAE Daisy workstation network.

Diagnosed all hardware failure, automated schematic capture and design checking process.

Converted Logician formatted data into SCI-Cards data base structure using UNIX stream editor.

Scripted extensive schematic compilation program which automated the design cycle, error checking and O.S. transfer. Saved 2 weeks in a 12 week design process cycle.

Member of the technical staff: Teledyne Systems Corp. Northridge, CA Dec/1984-Jan/1986

Wrote simulation models for Daisy Logicians and tested 1750a computer systems using MIL. STD Software development system. These systems were installed in Northrop's F20 Tigershark aircraft.

EDUCATION

AJAX (Asynchronous Java and XML) ; Sept 2015 Oct 2015

PCC (Portland Community College PCC-2-Go: On-line-Course)

Portland, OR

Software QA / Testing Courses; April / 2014 – August 2015

Portnov Computer School (On-line tutorials)

Los Altos, CA

James Marcus Bach; ‘Open Lecture’,’Crossroads’ (On-line tutorials)

Satisfice, Inc.

Java Programming; Winter Term - 2004

PCC Portland Community College, Sylvania Campus

Portland, OR

BS Computer Science; June / 1987

AS Electronic Technology August / 1985

Edison Technical Institute

Sherman Oaks, CA

BA Liberal Arts June / 1981

Thomas Aquinas College

Santa Paula, CA

TECHNICAL AND PROFESSIONAL TRAINING

BrioQuery Basic and Advanced Queries

Oracle 7 Foundation

Developing Oracle 7 Stored Procedures with PL/SQL

Oracle Forms 6.0

Introduction to HTML Scripting

Advanced HTML Scripting

Private Pilot Certificate – Federal Aviation Administration

Certified FAA Instructor in Basic and Advanced Ground School

Toastmasters International: former educational & membership vice-president.

Contact this candidate