Post Job Free

Resume

Sign in

Unix Admin, Backend QA, Sqlplus, ETL, Data Warehouse QA

Location:
Aurora, CO
Posted:
August 07, 2014

Contact this candidate

Resume:

Stephanie A. O'Rear

Aurora, CO *****

303-***-****

Email: ace99z@r.postjobfree.com

Seeking a position where my skills can be optimally utilized.

SUMMARY OF QUALIFICATIONS

Programming

Languages: C/C++ Pascal Delphi VB5/6.0

Java .Net PERL

Databases: Informix Paradox Oracle 8/9/10/11g SqlServer

Access

Sybase SqlPlus TOAD SQL Developer Teradata DataMarts

HW: Cisco Routers 3800 Cisco Switches 512/612, 2900 Tandem

Solaris/HP Windows Servers Sun

Platforms: UNIX NT/2000/XP Linux Cisco IOS

Other Skills: Win/X/LoadRunner Test Partner 3.0 CCNA Class Test Director

QuickTestPro SQA Robot Release Mgmt MS Sharepoint

Rational Informatica 7.0 Hyperion 9.3 Quality Ctr 9/11

Purify

PVCS Tracker ETL Testing JIRA MS Office UNIX System

Admin

Tech Writing/Editing White Box QA BackEnd QA HTTP

MS VSS RCS CVS RequisitePro Video Conferencing

SIP E-commerce Telecom Waterfall OO Methodology

Agile

PROFESSIONAL HIGHLIGHTS

Cigna Healthcare, Greenwood Village, CO

10/11 - 11/12

Performed QA lead duties as well as tested ETL code for a healthcare

company in the area. Participated in System Test, System Integration, UAT

and Release Test cycles. Performed test case peer review with other

testers, on and offshore, and developers. Wrote test plans, test strategy,

test cases, and defect documents using requirement and mapping

specification documents. Entered test cases in Quality Center (QC) for

tracking and execution purposes. Assigned RPN (risk number) to each test

case. Performed data mining activities on large teradata databases using

SQL between Facets and Proclaim dBs. Performed testing in Acquisition, DM,

and EM layers. Validated trouble spots such as tables where data

transformation occurred. Validated business rules as called out in the

Requirements document. Wrote defects as required in QC and ran defect

reports for distribution to Project Management and the Development team.

Wrote the final test report when a test cycle was concluded.

Environment: Win XP Pro SP2, Oracle 11g, Facets, Proclaim, UNIX, TOAD

9.7/11.5, Teradata DataMarts, UltraEdit, Quality Center 9/11, MS

Sharepoint, SnagIt 8.0, & IE 9.0, Risk Based Testing Methodology,

Healthcare, Offshore QA Team.

TWTELECOM, Englewood, CO 04/10 - 04/11

SR SW Test Engr

Performed senior QA activities on defect fixes and new code on a telecom

Ethernet services order entry system entitled NetCracker (NC) that ran on a

web portal. Effort involved pushing specific order types thru 3 different

systems in order to validate various order data elements in NC. Also

validated order workflow tasks based on assigned risk. Wrote up defects and

updated test case status within HP Quality Center. Utilized Soap messaging

tool to submit orders via the backend when UI was not available. Obtained

troubleshooting data from logs and submitted to Development as required.

Also assisted with QC 11 upgrade, identifying data inconsistencies.

Environment: Win XP Pro SP2, NetCracker 3.0/7.1, Java, Quality Center 9/11,

MS Sharepoint, SoapUI 3.6.1, Risk Based Testing Methodology, & SnagIt 7,

Telecom/Networks, Offshore Dev Team.

Cricket Communications, Greenwood Village, CO 05/09 - 04/10

SR SW Test Engr

Performed lead QA duties a local wireless company. Assigned to do backend

testing for reporting modules written in OBIEE and Hyperion. Reporting

dashboards were designed to present HR and Financial data on demand in

report form via a web portal. Data was pulled from more than one DataMart

using elaborate queries. Performed data validation and system testing after

the new DataMart has been loaded using Informatica. Ran those test cases

assigned a higher risk factor first. Utilized Quality Center 9.0 to record

defects and create reports for the project team, on and offshore.

Environment: OBIEE, Hyperion, Oracle 10, SQL Developer, TOAD, Quality

Center 9.0, MS SharePoint, & SnagIt 7, Telecom, Offshore Dev Team.

Dimension Data Corporation, Raleigh, NC 09/08 - 06/10

Performed as Team Lead for Cisco network equipment installs in the

Southwest region on an as needed basis.

Environment: Cisco Switches (WAE 512/612, 2900), Cisco Routers (3800),

Cisco IOS, Telnet, Hyper-terminal, & Ping.

McKesson, Broomfield, CO 11/07 - 06/08

SR SW Test Engr

Performed senior QA duties at healthcare company in the Denver area.

Responsible for the system test of various monthly, quarterly and yearly

reports that depict various healthcare data for usage by an outside client.

Reports were developed in Oracle Hyperion 9.3 Reporting Tool. Utilized

TOAD for Oracle 9.5 and SQL Developer 1.1 tool to execute queries against

the various reporting databases. Provided reporting metrics to QA manager

as required. Wrote test plans and procedures taken from reporting

requirements as provided by business analyst(s). Used Microsoft VSS to

version control test documents and delivered QA report code. Reported

anomalies found using PVCS Tracker & SharePoint. Also performed ETL

testing for an in-house development tool used to initially populate new

client data into production data marts as needed. Other duties as

assigned. Environment: Healthcare, Agile Extreme, Hyperion 9.3, Oracle

10g, Teradata DataMarts, Informatica, MS VSS, TOAD, SQL Developer, XP

Professional, PVCS Tracker, Quality Center, MS SharePoint, White Box

Testing, & GIMP.

Polycom, Inc., Westminister, CO 10/06 - 10/07

SR SW Test Engr

Performed senior QA duties. Tested video conferencing applications and

hardware including SIP protocol. Applications ran in a XP Professional,

UNIX, Linux, and SqlServer environment. Applications were written in .NET,

Java, and C++. Configured hardware devices to work on internal & external

networks. Performed configuration, functional, and system testing for

defects and new functionality for scheduled releases. Researched

requirements, wrote test plans and executed same. Reported test results

via Mercury Test Director. Other duties as assigned. Wrote other

technical documents or updates to as required: Release Notes, User, Install

and Administrator manual changes.

Environment: Video Conferencing (Polycom), SIP, Agile, XP Professional,

SqlServer, Linux, UNIX, Mercury Test Tool Suite, JIRA, & GIMP.

Jeppeson Sanderson, Englewood, CO 06/05 - 05/06

SR SW Test Engr

Performed senior QA duties. Tested aeronautical data for chart use and

worldwide distribution. Application ran on a UNIX, Java and Sybase

platform. Performed unit, functional, system, database, Backend, & White

Box testing for CQs (defects) and new functionality. Performed under a

very aggressive release schedule. Researched requirements, wrote

extensive test plans, procedures, and final test reports per FAA

regulations. Wrote other technical documents or updates as required:

Release Notes and the like. Reported test results via Rational ClearQuest

tool. Performed test data setup via the application GUI and the QA

database using the SQL Advantage tool. Modified backend test environment as

the need arose to. Utilized Informatica tool to perform ETL testing as

related to the mapping of data from several different data storage areas.

Verified the final output of this data downstream. Modified test bug

reporting tool in order to get test reports to print out using Rational

SoDA for Word. Assisted with automation of regression test scripts in

QuickTest Pro, Test Director and ClearCase. Acted as the backup QA Sys

Admin on an as needed basis. Provided QA Risk Assessment to QA manager as

appropriate. Environment: Aviation, Waterfall, Win XP, Sybase, UNIX, PERL,

Informatica 7.0, ETL, White Box, & Backend Testing, Rational Suite Test

Tools: RequisitePro, SoDA, Purify, & SnagIt.

Teletech, Englewood, CO 10/04- 02/05

Lead SW Test Engr

Performed lead QA duties. Tested a HR SW application written in .Net,

Oracle 9.0 that ran as a web application. Responsible for writing test

plans and procedures used by an offshore test team. Performed system,

integration, performance, and UAT testing prior to the software's release

into the user community. Wrote up all defects using a bug tracking system

and reported weekly statuses to the project manager and lead developer.

Wrote a final test report once the test cycle had been completed.

Supervised junior testers who assisted with the test effort. Assisted the

test manager with the Sarbanes/Oxley certification effort for the SQA

department. Environment: Telecom/Networks, Waterfall, Win XP, Oracle, UNIX

& Off-shore QA Team.

Visa DPS, Highlands Ranch, CO 09/02 - 09/04

SR Dev QA Engr

Performed senior DQA test duties. Application was written in VB 6.0,

SqlServer 7.0, Crystal Reports, and the backend ran on a Tandem mainframe.

Performed unit, integration and stress testing prior to delivery to

Production. Verified data from an Oracle dB and format of accounting

reports created using Crystal Reports. Returned marked up copies to

Developer for correction. Wrote up all defects and provided documentation

to Development complete with screenshots where applicable. Also wrote

other technical documents or updates as required: Release Notes, User

Notes, Install and Help File changes. Utilized the SqlServer Enterprise

Manager to perform database queries, updates and deletes. Attended peer

and requirement reviews for current and subsequent releases. Provided test

estimates to Lead Developer for future development effort(s). NEXT PHASE

involved system testing of a web-based application (gift card) written in

.Net with backend running on Tandem. This test effort involved very

aggressive timelines which sometimes involved revamping the test effort at

the last minute. Mentored junior test engineers to take over upon contract

completion. Responsible for programming a regression set of automated test

suites using Test Partner 3.0. Also tested changes to gift card IVR system.

Environment: Banking, Waterfall, Win XP, VB 6.0, SqlServer 7.0, .NET, White

Box, & Backend Testing, IVR Testing, Crystal Reports, Test Partner 3.0,

Windows Server 2003, Tandem Mainframe & SnagIt.

Qwest, Inc, Englewood, CO 04/01 - 06/02

SR SW QA Engr

Wrote test plans and test scripts for a telecom application used by Qwest

to meet regulatory requirements. The application was written with a Java

Front-end with backend that ran in UNIX, Forte and Oracle 8.01.

Participated in design reviews held by Development to obtain additional

technical information on a particular CR in order to write concise and

complete test plans and scripts. Also participated in the review of fellow

test engineers test plans prior to obtaining sign-off from Development.

Performed System and Regression testing using the above mentioned test

scripts as a roadmap. Wrote up and reported all defects to System Test Team

Lead and the Development Team Lead. Utilized PVCS Tracker for research

when writing test plans & scripts; also utilized when researching a current

bug to verify if it has been previously reported. Performed queries and

updates to Oracle dB using SqlPlus for test setup data. Utilized various

UNIX commands in performing tests on the Application Backend. Utilized

knowledge of advanced UNIX commands, such as UNIX directory structure, CRON

entries, etc. Mentored junior test engineers. Utilized WinRunner and Test

Director when running regression tests. Performed as Lead Test Engineer for

Release User Acceptance Testing as directed. Acted a focal point for this

testing; coordinating with System Test, the BAP and Development to ensure

the successful completion of this effort prior to the designated Go-Live

date. Assisted with troubleshooting environment issues when necessary.

Reviewed Java Code and error log files when troubleshooting bugs found

during the test cycle. Forwarded relevant information to Development for

bug fixes. Environment: Telecom/Networks, Waterfall, WFA/C, WFA/DO,

Predictor, Win 2000, Java, UNIX, Forte, Oracle 8.01, Backend Testing, White

Box Testing, WinRunner, LoadRunner, Test Director, PVCS Tracker, & CVS.

Corporate Express, Broomfield, CO 12/99 -12/00

SR SW QA Engr

Responsible for the system testing of accounting applications and their

modifications which were utilized by an international business community.

Application(s) were written in Visual Basic, C and Oracle and ran on WIN95

and UNIX platforms. Verified data and format of accounting reports created

with Crystal Reports. Also tested one of the company's E-commerce

websites. Wrote test plans, procedures and other test documentation as

required. Utilized SQA Robot in running regression test suites.

Participated in 'Go Live' meetings for the current release in order to

provide QA risk assessment to upper management. Performed a mentoring role

for new hires, and other junior test engineers. Acted as Back up to the QA

System Environment Coordinator. Performed installs and backup of

applications in QA env. Environment: E-Commerce, Waterfall, Win 95, UNIX,

VB 5.0, C, Oracle, Crystal Reports, Rational RequisitePro, Purify, SQA

Robot, Backend Testing, & White Box Testing, Sys Backup Administrator.

Exactis.com, Denver, CO 06/99 - 12/99

Lead QA Engr

Responsible for system, acceptance and environmental testing of various web-

based & Backend SW releases for a major client of this company.

Applications were written in PERL and Java and ran on an Oracle 7.3.3

database in a WinNT/Sun environment. Verified that data is stored correctly

in the QA database. Modified test database as needed for various test

scenarios. Wrote test plans and procedures as time permitted, recording all

defects in an in-house defect tracking system. Validated release

maintenance documents for release to Production/OPS. Provided input for

implementing SW processes within the Engineering Department. Provided

training and mentoring to new and junior test engineers on staff. Other

types of testing were performed as assigned. Environment: Dot Com,

Waterfall, WinNT, UNIX, PERL, Java, Oracle 7.3.3, & Backend Testing.

US West, Denver, CO 10/97 - 05/99

Lead QA Engr

Responsible for the system test of 3 major applications within an UNIX

client/server environment. Applications were written in C/C++, NeuronData,

CORBA, JDBC, Java and Oracle 8.05. A portion of these applications also

resided on a Web server for access by the Client community. Wrote test

plans, procedures and provided input to the application release schedule.

Acted as Sys Admin for QA environment. Ran DLL scripts on snapshot of the

Production database for initial setup of a new test database. Modified data

in test databases to run test cases using insert, delete, update, truncate

and select commands. Verified that data transactions were processed through

the database using queries in both the Test and Production network

environments. Validated DDLs contained in the SW release package(s). Also

acted as Release Manager for scheduled releases of software to Production

performing coordinating activities with various client entities as well as

the SW Release Team. During the remaining 6 months of the assignment I was

responsible for functional, system and acceptance testing of a third party

vendor SW package in its initial implementation in a WINNT/SqlServer

environment. Performed Sys backup of application and database as required.

Wrote all test documentation pertaining to this SW implementation per the

Capability Maturity Model guidelines. Performed all Y2K testing for subject

applications. Environment: Telecom/Networks, Waterfall, Win 95, UNIX,

PERL, C/C++, NeuronData, CORBA, JDBC, Java, WinNT, SqlServer, WFA/DO,

WFA/C, Predictor, Rational RequisitePro, RCS, Oracle 8.05, White Box &

Backend Testing, Sys Backup Administrator.

Jones Cable, Inc. 06/97 - 10/97

SR QA Engr

Environment: Cable, Waterfall, Win 95, C/C++, Sybase, & MS Access.

Baxa Corporation, Englewood, CO 03/97 - 06/97

SR QA Engr

Environment: Medical, Waterfall, Win 95, WinNT, Delphi, InterBase, & MS

Access.

US West, Denver, CO 07/96 - 01/97

SR QA Engr

Environment: Telecom/Networks, Waterfall, WinNT, UNIX, Oracle, & Backend

Testing.

The Carnegie Group, Inc., Denver, CO 10/95 - 07/96

SR Support Engr I

Environment: Telecom/Networks, Waterfall, HP 7000 UNIX, & C/C++.

US West, Denver, CO 12/94 - 10/95

QA Engineer

Environment: Telecom/Networks, Waterfall, Sun, UNIX, X-Windows, Oracle, &

C/C++, & Backend Testing.

USDA, Ft. Collins, CO 06/94 - 12/94

Systems Engr

Environment: US Gov't, Waterfall, Win 3.1, UNIX, Informix, Novell, & C/C++.

EDUCATIONAL BACKGROUND

Community College of Aurora, Aurora, CO 8/00 - 12/00

Java Programming course

Foothill/Mission College District, Los Altos, CA 88 - 91

Computer Science Prerequisites

Peninsula University School of Law, MtnView, CA 83 - 84

San Francisco State University, SF, CA 78-79

Creative Writing/English courses

Eastern Illinois University, Charleston, IL

Bachelor of Science in Finance - 1977

TRAINING

UNIX and Linux Operating System Fundamentals Course,

LiveFire Labs, 7/14

CCNA Certification Course, 10/02

SW Test & QA Techniques, AIT, 6/96

Oracle Courses

Oracle, Ver. 7 Architecture 11/96

Oracle, Ver. 7 Administration 12/96

Personal Oracle, Ver. 7 06/96 (CBT)

Visual Basic, Ver. 4.0/5.0 06/96 (CBT)



Contact this candidate