SUMMARY:

• Five years’ experience with very large web - based systems.
• Software QA Analyst with over 15 years quality assurance and test experience.
• Expert at developing test strategies and writing test cases based on business requirements, functional specifications and design documentation and user documentation.
• Extensive experience with web services, Customer Relationship Management applications and B2B enterprise-scale Service Oriented Architecture on Windows and mainframe platforms.
• Solid understanding of the software development life cycle and software testing methodologies.
• Adept at functional, integration, regression; positive & negative testing; black & white/glass box and exploratory testing techniques, and supporting user acceptance testing.
• Experienced at writing SQL queries in SQL Server, Oracle Developer, Tandem and DB2.
• Skilled at validating database and file output information throughout the testing cycle.
• Superior analytical, troubleshooting, verbal & written communications and presentation skills.
• Identified and helped manage customer change requirements for sizing and tracking through the development process.

TECHNICAL SKILLS:

Databases: SQL Server, DB2, Oracle, Tandem.

Languages: SQL, Oracle SQL, Tandem SQLCI, HTML, XML

Hardware: PCs, LANs, mainframes

Operating Systems: Windows 10, 7, XP, NT, LANs, Tandem O/S

Software: Office 365, Microsoft Word, Excel & Power Point, SharePoint, IE 11, 10, 9 Firefox, Chrome, & Microstrategy Reports, Remote Connection, VPN, Citrix, Telnet, Toad, FTP, Zip, Skype for Business

Testing Tools: Rational ClearQuest, Rational Quality Manager, SAP Business Objects, OnTime, HP Quality Center 8 & 10, TFS 10, Gemini Defect Tracker, Clarify Clear Defects

PROFESSIONAL EXPERIENCE:

Software Quality Assurance

Confidential, Folsom, CA

Responsibilities:

• Designed and executed manual test cases and wrote test cases for electronic CDPH forms written in HTML & .PDF that dynamically adjusted the questions displayed based on users’ answers to questions.
• Documented test results and recorded defects for corrective action and re-testing after bug fixes were applied.
• Supervised and provided feedback to software testers on test results they observed.
• Provided management and sales with daily progress reports and reported risks that were identified.

Insurance Agent

Confidential, Sacramento, CA

Responsibilities:

• Very large web-based system ($100+ million cost, 10+ million tax payers, 1+ million lines of code)
• Created and executed test cases using Rational Quality Manager (RQM) based on validation criteria, defects and change requests.
• Generated & verified SAP Business Objects (SAP/BO) reports for proper formatting and calculations.
• Verified Franchise Tax Board report information against data in the DB2 database.
• Documented and tracked software defects to resolution using ClearQuest tracking system.
• Validated ClearQuest change requests were implemented correctly on FTB reports and documentation.
• Ensured SAP/BO reports displayed correctly when exported to Excel and PDF files.
• Performed connectivity testing to ensure end users could run reports from the Case Management and ITF platforms.
• Stored report validation results in SharePoint document repository.
• Maintained maintain traceability matrix to ensure test cases cover all requirements and use cases
• Participated in daily software tester meetings and weekly all staff meetings.
• Successfully delivered EDR v3.0.0 and v3.0.1 to Franchise Tax Board on time.

System Testing Engineer

Confidential, Roseville, CA

Responsibilities:

• Executed manual UI test cases and ad hoc testing to ensure Catalyst met audit & business reqs.
• Documented software defects, bug fixes test results, and enhancement requests in SharePoint.
• Tested user security roles to ensure that users could only access authorized functionality.
• Verified reports correctly displayed information and exported data to Excel and PDF files.
• Wrote test plans based on customer’s business requirements and design documentation.
• Participated in daily standup meetings with UAT group and weekly status meetings with SourceNet (a software development company located in Dallas, Texas).
• Worked with the offshore QA team in Mumbai, India to coordinate end-to-end testing.
• Successfully implemented Catalyst, a COTS product on time to Rabobank’s Accounts Payable department.

Quality Assurance Analyst Contractor

Confidential, Concord, CA

Responsibilities:

• Manually performed functional, integration and regression testing on AgentAchieve web portal; and Broker, Company, Office and Regional websites written in Java; including web based GUI application containers.
• Executed multiple browser testing in Chrome, Firefox and IE 8 & 9 for AgentAchieve releases.
• Unit tested new Multiple Listing Services (MLS) implementations in the development environment
• Wrote SQL queries using SQL Server 2008 to perform backend testing.
• Documented software defects and enhancement requests using OnTime and VolumeOne tracking systems.
• Tested bug fixes in development, integration and production environments.
• Participated in daily Agile scrums and weekly backlog grooming meetings.
• Successfully delivered AgentAchieve releases 5.8-5.10.3 to Confidential ’s production environment.

Quality Assurance Consultant

Confidential, Sacramento, CA

Responsibilities:

• Wrote new test cases based on customer’s existing software and user documentation.
• Updated existing test plans to reflect the current state of web applications.
• Documented software defects and enhancement requests using TFS 2010.
• Wrote SQL queries in SQL Server 2008 to analyze data updated by the web applications.

Quality Assurance Contractor

Confidential, Sacramento, CA

Responsibilities:

• Very large web-based system ($20+ million cost, 1+ million clients, 1+ million lines of code).
• Interacted directly with clients, users and members of the project team organization.
• Helped document business objectives and business processes.
• Reviewed Wage Tool business requirements and design documentation.
• Created test cases based on requirements and design documentation.
• Executed functional and regression UI tests to verify Wage Tool was fetching/writing data correctly from/to legacy applications and databases in EDD’s SOA, which supports 800+ EDD employees.
• Ensured the Wage Tool web services followed business rules and maintained data integrity.
• Collaborated testing efforts with the offshore members of QA team in Mumbai, India.
• Documented test results, submitted defects and escalated serious issues when necessary. with the customer to ensure end users’ satisfaction.
• Validated calculated benefit amounts and data output was corrected.
• Wrote and executed test cases using HP Quality Center 10.
• Documented test results using HP Quality Center 10.
• Created traceability matrix to ensure all requirements were addressed by test cases using HP Quality Center 10.
• Tracked defects and enhancements using HP Quality Center 10.
• Participated in weekly “Pigs & Chickens” progress meetings.
• Successfully delivered Wage Tool on time to the EDD’s production environment.

Sr Quality Assurance Engineer

Confidential, Rancho Cordova, CA

Responsibilities:

• Sole QA providing support to the Valuation Team’s two Java developers.
• Wrote test cases based on design discussions in the agile daily scrums.
• Performed functional, integration and hardening testing on all enhancements and bug fixes for the Valuation web reports delivered in Confidential ’s SOA Release 7.0.
• Validated XML files used to request and return data from real estate query requests.
• Performed platform testing to ensure Confidential subscribers could successfully logon and access their Valuation web services from any location in North America.
• Performed cross browser UI testing using Internet Explorer, and IE Tester to ensure AVMs were compatible with current and older releases of Internet Explorer.
• Estimated time for test plans’ completion and prioritized test cases in agile / daily scrums.
• Submitted enhancement requests from the customer and/or management.
• Documented test results, reported defects in TFS, and tracked issues to resolution.
• Successfully delivered AVM release 7.0 to Confidential ’s production environment.

Sr. Quality Assurance Level 3

Confidential, Roseville, CA

Responsibilities:

• Interfaced with clients to define their needs, and articulate requirements.
• Worked with development team to define scope, managing expectations, identifying potential changes.
• Sole QA for CET & CHDC projects and developed testing strategies.
• Wrote test plans based on customer’s business requirements and design specifications.
• Executed functional, integration and regression UI tests of browser based Customer Management Systems written in C#.net, ASP.net and Java Script.
• Ensured web services obeyed business rules and maintained data integrity.
• Tested user roles to ensure the security module correctly granted / denied user permissions.
• Documented test results and recommended enhancements to improve usability and performance.
• Logged all software defects and enhancements in TFS to track all issues to resolution.
• Wrote SQL queries using SQL Server to perform backend testing.
• Validated that projects’ canned and ad hoc reports meet audit & compliance requirements
• Verified reports displayed info, calculated values and exported data correctly in Excel & PDF files.
• Assisted in planning and scheduling of black box and glass box testing of web applications
• Estimated time for test plans’ completion and prioritized test cases in agile / daily scrums.
• Tested bar code readers and signature pads to ensure CET forms handled input data properly.
• Successfully delivered CET and CHDC Projects on time to the customers.

Test QA Specialist

Confidential, Roseville, CA

Responsibilities:

• Sole QA providing support to Cisco WWRL & Juniper projects’ four developers.
• Wrote and executed test plans for workflow applications that automated manual inventory processes for clients’ projects.
• Executed functional / integration UI tests of web portal applications written in C#.net and ASP.net
• Used IFS and PL/SQL Developer to query receiving, inventory & shipping data.
• Documented defects and enhancements requests using the Gemini tracking system.
• Validated XML data sent and received in XML files (RosettaNet PiPs).
• Tested backend using SQL Server 2005 to verify the accuracy of data in error and log files
• Collaborated testing efforts with the offshore QA team in Mexicali, Mexico.
• Worked closely with developers on an agile software development team to ensure projects met customer’s needs and company’s goals.
• Answered customers’ questions, determined whether reported issues were bugs or enhancement requests, and tracked issues to their resolution.

Quality Assurance Contractor

Confidential, Rancho Cordova, CA

Responsibilities:

• Executed regression and functional UI testing of the Informa and SQL servers to ensure the new
• Tested Informa’s business rules for authorizing medical procedures and approval/denial letters.
• Executed regression testing of health carrier statistical reports.
• Verified accuracy of SQL Server 2005’s data against SQL Server 2000’s data using SQL queries.
• Worked closely with Magellan staff to ensure the new servers’ functionality meets or exceeds customer’s expectations and the upgrade was transparent to the end users.
• Successfully delivered upgraded Informa & SQL Servers on time to the Magellan’s data center.

Senior Testing Engineer

Confidential, El Dorado Hills, CA

Responsibilities:

• Very large web-based system containing a suite of over 300 web-based, workflow applications used to process orders, manage back office and provision services for cable, satellite and phone companies
• Executed black and white box functional UI tests on a large-scale web portal in an n-tiered SOA environment coupled to high-volume relational databases.
• Designed, developed, maintained and executed test cases that covered provide adequate coverage of the project’s suite of over 300 web-based applications based on user requirements, design documentation and use cases.
• Planned, created, documented, and managed project work tasks related to testing.
• Coordinated testing efforts with the offshore QA teams in Crete, India and Israel.
• Verified API calls processed XML data files correctly using Confidential ’ API Tester.
• Identified and reported risks that could impact project deadlines.
• Ensured project timelines were realistic for the testing specified.
• Wrote and executed test cases using HP Quality Center 8.
• Documented test results in HP Quality Center 8.
• Created traceability matrix to ensure all requirements were addressed by test cases in HP Quality Center 8.
• Tracked defects and enhancements using HP Quality Center 8.
• Validated application data displayed against Oracle data using TOAD toolset.
• Corrected SQL errors using TOAD.
• Configured software parameters for test environments.
• Monitored, mentored and provided feedback to junior team members on testing techniques and strategies.
• Wrote materials and user guides based on design doc and actual test results.

Software QA Analyst

Confidential, El Dorado Hills, CA

Responsibilities:

• Designed and executed test cases for AppDev programs written in C, C++ and asp.
• Documented test results, defects and customers’ change requests in Clarify Clear Defects for tracking and corrective action.
• Performed functional and regression UI testing on Tandem and Windows client / server applications for Bitmap Database Analysis, Database Update, FCR/FPM and Fixmaster projects.
• Replicated Tandem databases and import data for DDP/SQL test environments.
• Wrote Oracle SQL queries to create test data and verified backend data created during testing
• Managed the maintenance.
• Created project release notes that documented the applications’ system requirements, installation instructions, user guides and a list of any defects discovered during testing.
• Anticipated potential problems and designed generic tests to identify program defects.
• Worked with developers to design testing strategies to identify software defects and end users’ enhancement needs.
• Acted as a SME for projects and assisted customers with User Acceptance Testing.