Unix Admin, Backend QA, Sqlplus, ETL, Data Warehouse QA
Resume:
Stephanie A. O'Rear
Aurora, CO *****
Email: ******@**********.***
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