Engineer Customer Service

SUSAN RANSOM

Plano, TX 214-***-**** ***********@*****.***

CAREER OBJECTIVE

Certified QA Engineer seeking a full-time or contract position. Experienced

in manual and automated testing through all phases of the SDLC. Sound

understanding of testing processes, methodologies, and best practices.

Recent work: Web Services, Accounting Systems, Data Warehousing, ECommerce,

Supply Chain, front-end, middleware, and extensive back-end testing and

data analysis. Self-starter and ability to work with minimal day-to-day

direction on complex systems to achieve individual and project goals.

EDUCATION & CERTIFICATIONS

BS CISQA May 1988, University of Arkansas, Fayetteville, Arkansas -

emphasis in structured programming and accounting

Certified in Software Quality Assurance, Software Testing and Interpersonal

Skills from www.brainbench.com

SUMMARY OF QUALIFICATIONS

. Test web-based applications in multi-tier, multi-platform environments

for enterprise and non-enterprise systems used both internally and

externally. Extensive back-end testing experience with Oracle and MS

SQL

. Implement testing standards for new applications, products, and/or

enhancements to existing applications from design phase through UAT

. Led both on and offshore resources of small and medium size teams.

Demonstrate sound judgment and the ability to analyze complex tasks

and/or priorities and execute appropriately.

. Understand development lifecycles and how QA fits into the process

. Understand of front-end, middleware, and back-end technologies and how

they fit together

. Understand how to create and store data for relevant and repeatable

testing

. Develop test plans, scenarios, cases and test data based on business

requirements, use cases and technical requirements

Operating systems: Windows 95/98/NT/2000/XP, Unix/Linux

Platforms: Java, MS .NET, Windows XP/2000/NT, Linux, UNIX, Teradata

RDBMS: Oracle 8.0/8i/9i, MS SQL 2005

Testing Tools: HP Quality Center 9.x, 10.x, Visual SourceSafe, PVCS

Tracker, TOAD, Oracle Queries, XML Spy, MS Office Suite, MS

Project, VISIO, MS SQL Query Analyzer, Team Foundation

Server

Languages: SQL, XML, HTML Web Servers: WebSphere, WebLogic

Other: SharePoint

EXPERIENCE

Rent-A-Center Headquarters, Plano, TX

QA Engineer 12/09 - 6/10

. Completed testing all requirements of multi-state online payday loan

application. Application included user module, customer service module

and administration module.

. Manual testing environment that included entering test cases, test lab

results and defects in Quality Center

. Worked closely with both onshore and offshore resources as well as

closely with business owners to ensure compliance with user

expectations

. Created production like data where possible, and made data requests

for data when needed

. Tested full cycle of loan including loan initiation, origination,

eSignature and closing

. Tested specific state rules for loan buybacks, renewals, payments,

payment plans, APR's, collections, debt recovery plans,

ACH transactions, rebates and legal documents

Penson Financial Services, Dallas, TX

QA Engineer 8/09 - 9/09

. Completed testing of web services for Cash Transfer Application by

verifying XML request and response messages against requirements

. Utilized SQL via MS SQL Query Analyzer to verify inserts and

modifications were made to data on in the database based on

requirements

. Worked with all levels of business and IT in a multi-sourced

environment

T-Mobile, Frisco, TX 04/08 - 11/08

QA Engineer

. Completed testing and data analysis from front-end through middleware

to the back-end general ledger posting in SAP for a vendor-applied

accounts payable system.

. Created test plans, test cases, and data creation based on SOW,

technical and functional specs and defined data constraints and

definitions.

. Worked with all levels of business and IT in a multi-sourced

environment. (Interfaces, TIBCO, XML, IDOC, SAP R3 and HR modules.)

. Validated XML messages against requirements.

. Tested SIVR and Remedy systems, Oracle, SAP, Java, XML, TIBCO, Remedy,

SharePoint, MS Apps.

Brinks, Coppell, TX 11/06 - 04/08

Senior QA Engineer

. Performed testing and analysis of front and back-office web-based cash

logistics and supply chain systems that included the movement of money

from banks to banking distribution centers and the Federal Reserve.

. Actively worked with all levels of IT to analyze, record, and test

applications for conformity to business and technical requirements.

. Tested application with multiple web services and data sources, with

both on-site and offshore resources plus multiple banking and

financial institutions.

. Created relevant test data from scratch based on requirements, data

dictionary, data model and database constraints using file editing

software for use as input to an interface, processing by middleware

and back-end.

. Back-end testing with SQL queries and data analysis.

. Assisted in creating processes and procedures for QA department from

inception.

. Full SDLC including creating test cases, test plans, test data,

testing approach and strategy.

. Scheduled and prioritized QA tasks, status reports and progress

matrices.

. Agile, iterative and waterfall methodologies. SharePoint, MOSS, .NET,

Oracle, MS SQL, TOAD, Oracle Worksheet, Oracle Financials, PL/SQL,

Excel, PVCS, Mercury Quality Center 9.2.

PepsiCo, Plano, TX 01/06 - 10/06

Lead QA Engineer/Data Analyst

. Teradata Data Warehouse, ETL process. Led team of 4 people performing

quality assurance and software testing for data warehouse development

applications, including being familiar with the new data model and

database structures for use in back-end data analysis and validations.

. Wrote several thousand requirements driven, data driven, and business

scenario driven test cases.

. Wrote, executed and reported on test cases and results.

. Verified Source to Target Informatica mappings and results of BTEQ

Teradata scripts.

. Responsible for requirements, end-to-end, regression, integration, and

system testing.

. Performed data quality and data cleanliness analysis by comparing

incoming data from data source with data requirements, data model and

target definitions.

. Created production-like data from scratch using notepad, Excel, XMLSpy

and other tools, when there was no relevant production data available

. UNIX, Oracle, PL SQL, Teradata, Oracle Query Analyzer, Erwin, data

modeling and mapping concepts, HP Mercury QC.

Cingular, Richardson, TX 08/05 - 11/05

Lead Software Tester

. Front-end and back-end testing for wireless telephone activation and

billing system.

. Lead contact for compiling and communicating status reports and hours

for budget planning.

. Created testing strategy and approach.

. Created test cases from written and verbal requirements.

. Logged defects in Rational ClearQuest. C#, .Net, Visual Studio, ASP,

API, EDI, XML, B2C, SQL, Oracle, Mercury Tools, Rational Tools,

TeamTrack tools.

Hotels.com, Dallas, TX 08/04 to 08/05

Senior QA Engineer

. Tested web-based, Ecommerce, B2C, B2B external website applications

for refactoring of the back-end and front-end of the live main site.

. Validated SOAP XML message pairs via newly introduced API.

. Created Master Test Plan and test strategy based on business and

technical requirements, project plan, project schedule and other

relevant project artifacts.

. Performed test case reviews, gap and risk analysis.

. Worked closely with development and architects on details of system

design and functionality.

. Analyzed log files to detect and troubleshoot defects.

. Mercury Tools, SOA, API, EDI, XML, SOAP, XMLSpy, Java, J2EE, JSP,

Oracle, Dynamo, ATG, AS400, XML, SOAP, SQL Server, Weblogic, UNIX, VI.

GMAC-RFC, Dallas TX 06/2004 - 08/2004

Lead Software Tester

. Tested the back-end processing for a residential mortgage application.

. Created test plan and strategy based on business and technical

requirements, project plan and schedule, and other project and system

artifacts.

. Built XML files from scratch that included over 1000 elements,

verified accuracy of file processing to output file, then further

transformed to legal documents accessible from a portal.

. Platform: Mercury Test Director 7.6, Java, Oracle, B2C environment.

Pegasus Solutions, Dallas TX 08/2003 - 03/2004

Senior Software Tester

. Tested back-end of invoice and payment system that also reconciled

travel agent commissions for proper payment amounts. Created overall

testing strategy including creating the data from scratch for the

initial testing of the back-end to see if the figures were posting

correctly in the General Ledger and the conversion from foreign

currency to USD was working correctly. Complex data set-up to trigger

the data to hit all the accounts set up in the General Ledger and all

approved types of foreign currency input.

. Created XML data from scratch with account posting elements that

converted to IDOC format via WebMethods, then posted to the general

ledger (SAP).

. Liaison between accounting department and development staff.

. Created Test plan, test strategy, test cases, SOX compliances, and

integration traceability matrix based on business and technical

requirements, project plan and schedule and other project and system

artifacts.

. Verified 3rd party data files and feeds from banks that contained

source data for the billing and payment reconciliation application.

For example, Reuters, OFAC, and foreign currency rates.

. Reviewed and edited BRD, FRD, TRD. Mercury, log files, Reuters, SOX,

OFAC, Java, J2EE, WebMethods, IDOC, SAP, B2B, EAI, Informix, UNIX, VI,

SQL.

University of Arkansas, Fayetteville, AR 09/02 - 08/03

Blended QA/BA/Developer role

. Web-testing for PeopleSoft enterprise-wide student registration system

transitioning from a mainframe legacy system.

. Web development utilizing Macromedia suite for writing and correcting

web content, links and images.

. Worked directly with management and users to gather and analyze

functional and technical requirements, and act as a liaison between

developers and end-users.

. Macromedia, DreamWeaver, Flash, Adobe, HTML, some JavaScript and

Photoshop, PeopleSoft 8.0 Student Administration module, SQL, UNIX,

Sun, MS SQL Server, DB2, Oracle.

Payroll and Tax Services (self-employed), Fayetteville, AR 03/01 - 08/03

Proprietor - Bookkeeping

. Managed and performed all bookkeeping, including multi-state payroll,

multi-state taxes, in-depth financial analysis, budget preparation,

break-even analysis, monthly profit & loss, balance sheet and budget

forecast statements for small business restaurant owners.

. QuickBooks Pro, A/R, A/P, General Ledger, journal entries, bank

reconciliation, budgeting preparation and follow-up.

ORGANIZATIONS AND AWARDS

Award, Procter & Gamble quarterly IT award for Call Center productivity and

customer service ratings

Member, North Texas PC Users Group, Dallas, Texas, 1995 to present

Member, University of Arkansas, Alumni Association, 1988 to present

Member Volunteer Center of North Texas, 2009

Contact this candidate