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.

TECHNICAL SKILLS:

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

Confidential, Hillsboro, OR

Responsibilities:

• 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

Confidential, Roseville, CA

Responsibilities:

• 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

Confidential, Portland, OR

Responsibilities:

• 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

Confidential, Lake Oswego, OR

Responsibilities:

• 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

Confidential, Lake Oswego, OR

Responsibilities:

• 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.

QA/ Test Engineer

Confidential, Hillsboro, OR

Responsibilities:

• 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.

BUSINESS analyst/QA Tester, Tigard, OR

Confidential

Responsibilities:

• 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 Ecli pse development environment with HTML & Perl (ActiveState ActivePerl version 5.6) to update and enhance the existing retirement calculator
• 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.

Web-Developer/Sr. Perl-HTML Programmer, Tigard, OR

Confidential

Responsibilities:

• Gathered requirements, interviewing actuaries, accountants and customer reps.
• Evaluated a competitor product in order to in corporate 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

Confidential, Portland, OR

Responsibilities:

• 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

Confidential

Responsibilities:

• 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

Confidential, Beaverton, OR

Responsibilities:

• 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

Confidential, Wilsonville, OR

Responsibilities:

• 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

Confidential, Beaverton, OR

Responsibilities:

• 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

Confidential, Santa Monica, CA

Responsibilities:

• 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.