Qa Analyst Resume
Santa Ana, CA
SYNOPSIS:
As a Software Test Engineer offering 9+ years of experience in System Analysis, Design, Development, QA Testing of Web based and Client/Server applications, which includes more than 3 years of AMDOCS Billing System and Network Systems. Prepared Test Plans, Test Scripts and Test Cases for Functionality, Performance, Stress, and Regression Testing. Excellent professional ability to work independently and as a team member to perform Functional, UAT, GUI Testing, using Test automation tools such as Win Runner, Quick Test Pro, Quality Center, analysis, System specification analysis and Test plan formulation and testing methodology.
- Expertise in Manual and Automated Testing of Client Server/Web based Applications.
- Extensive experience in varied environments using automated testing tools like QTP, Quality Center & Test Director.
- Involved in developing testing documents such as test plans, test case specifications and developing test procedures.
- Used Test Director for planning and running tests and tracking defects.
- Experienced in Unit, Block box, White box, Sub-System, Performance, Functional, Acceptance, Stress, Regression, Integration, System Testing and user acceptance testing (U.A.T).
- Experienced in the complete life cycle of project development: System Analysis, Design, Development, Testing, Deployment and End User Training.
- Specialized in Clarify CRM application Testing and Amdocs Ensemble Components. i.e. Customer Service management (CSM), Number management, Enabler Billing, MAF, MPS, and Experience includes complete life cycles of new Implementations and up gradations.
- Experience in Amdocs Enabler. i.e. Product Catalog, Rating and Amdocs prepaid.
- Experience in Amdocs Ensemble Components. i.e. Telegence (Customer Service management (CSM)), Number management, Billing, Accounts receivable (A/R), Collection and Switch Control.
- Very good experience in Order Entry, Customer Care (OSS), CARE Amdocs Billing systems.
- Experience in implementation of Back-end Testing using Oracle/SQL Server.
- Used SQL queries for retrieving data from various databases using TOAD.
- Hands on experience in writing VBscript.
- Expertise in testing using the ETL tools like Ab Initio (Co>Op/GDE). Testing the execution of sessions and batches that loads data on the Server Manager and verifying the data in the target tables with SQL Server database.
- Hands on experience in developing C# classes and ASP.NET controls.
- Experienced in testing MS.Net (C#, ASP.NET, SQL Server 2000/2005, SS Reporting Services), SharePoint and Web Services (SOAP, WSDL and XML) applications.
- Familiar with UNIX commands for testing purpose.
- Consistent performer with good analytical and presentation skills.
- A self-starter with a positive attitude, willingness to learn new concepts & to accept challenges. Able to work within a team environment as well as independently.
TECHNICAL SKILLS:
Testing Tools Quality Center, Win Runner, Quick Test Pro and Test Director
Hardware IBM PC Compatibles, Sun Solaris Workstations
Operating Systems MS-DOS, Windows 98/00, Windows NT 4.0, MAC, UNIX and Linux
Languages SQL, PL/SQL, TSL, C, C++, Java.
Scripting HTML, XML, Shell Scripting, VB script and Java Script
Microsoft Technologies C#, VB.Net, ASP.Net, ADO.NET, IIS, SharePoint, Web Services, .NET Framework(1.1/2.0/3.0)
Databases T-SQL, Oracle 7.x/8i/9i/10g, SQLSERVER 7.0/2000, DB2, Sybase, MS-Access
GUI/Front end Visual Basic. Net, Power Builder5.0, Developer 2000(Forms4.0, Reports 2.5)
Web Tools VB Script, Java Script
Web servers Java Web Server, Microsoft IIS, Apache
Application servers BEA Web logic 5.1, IBM Web Sphere, Sun Application Server and Citrix Server.
Packages MS Office 2007.
Billing Software AMDOCS ENSEMBLE, AMDOCS ENABLER, Clarify CRM, POS, IC
Network Protocols TCP/IP, IPv4, IPv6, Mobile IP and SMTP
ETL Tools AbInitio
Documentation MS-Word, MS-Excel
Version Managers Visual source safe, CVS, Clear Case
WORK EXPERIENCE:
Confidential,Santa Ana, CA Jul 2009 – Feb 2010
QA Analyst
California Court Case Management System (CCMS): The Court Case Management System will be used to handle the case initiation, case scheduling, accounting, calendaring of the whole California Judicial System. This is the biggest case management system developed for Courts of California, State Government to automate the entire California state Superior courts and their administrative office activities.
Responsibilities
- Developed test scenarios for the Release V4 of the Case Management System, Provider Management System and Correspondence system.
- Interface with different development teams to collect information and to accomplish the task of writing scenarios and testing the functionality
- Keep up to date track of changes in the requirements.
- Plan and schedule tasks to ensure that developed products meet business requirements and design specifications.
- Perform complex functional, application, regression and functional testing
- Validate test data in the backend by writing complex SQL queries.
- Performed Regression testing while testing the functionality of assigned defects and Data fixes and opened the new defects wherever necessary.
- Designed and implemented automated regression tests using Quick Test Pro.
- Used various kinds of checkpoints like Standard Checkpoint, Page Checkpoint, Text Checkpoint, Database Checkpoint and Image Checkpoint.
- Involved in writing and updating QTP test
- Performed the Post analysis of the maintenance release and discussed the enhancements for that release to be up to date on the system functionality.
- Provide suggestions on areas to enhance or improve the product set based on behaviors observed in the testing environments.
- Modifying the XML data to meet business requirements
- Executing the QTP test scripts and presenting the results
- Used MS visual studio tools project templates for testing purposes.
- Involved in writing shell scripts and project documentation at various levels.
- Performed Data warehouse testing to verify if the reports meet the user requirement.
- Report and submit Project Statuses every week to the Management.
- Responsible for maintaining the Action Libraries and the calling scripts.
- Discussing with developers, business analysts, and customer teams to resolve the testing issues.
- Strong time management skills, ability to multi-task & handle multiple project assignments
Environment: Quality Center 9.5, QTP, VB Script, Oracle, PL/SQL, Windows XP/200, .Net, HTML, VB Script/Java Script, MS Visual Studio tools, TIBCO, Cognos, Unix Shell (Korn) scripting.
Confidential,Bellevue, WA May 2008 – Jun 2009
QA Engineer
Premium Handset Protection: This application deals with the Handset protection service with Insurance provided by Asurion. Bill payment is done through POS application.
Retail Enhancements: A customer can select any price plan based on a customer requirement. It provides a facility to add/delete feature per customer request.
Open Mobile Web: This application provides with various data plans for a T-mobile subscriber depending on the handset.
Pinless Debit: This application provides users to pay the bills with Hybrid cards without asking PIN numbers.
Responsibilities:
- Assigned to T-Mobile Flex pay Functionality Testing. Responsible for generating test cases from requirements, test execution and reporting using Mercury Quality Center
- Involved in creating BANs (Billing Account Number) using CSM and testing related T-Mobile internal applications Samson/Watson.
- Project requires backend database validation as well as front end GUI of Amdocs/Samson Customer Service Billing System requiring some data generation
- Prepared Excel Pivot tables for testing purposes.
- Used Extreme programming as an Agile Methodology in the software development life cycle for building the application based on four lines of insurance business
- Performed Data Validation and Back End Testing of databases to check the integrity of data using TOAD, Benthic Gold, SQL Developer tools.
- Effectively supported the delivery of high-quality information systems of new products by reviewing test requirements; developing test plans, test data; and executing the test plans to produce actual results.
- Responsible for testing the Retail Enhancements Phase 3 API Functionality.
- Testing required extensive database validation as well as from end testing using the Samson/CSM application. Generating test cases based off of requirements as well as generating basic db scripts for validation.
- Responsible for generating test cases from requirements, test execution and reporting using Mercury Quality Center. Project required backend database validation as well as front end GUI of Samson as well as some test data generation.
- Involved in positive and negative testing of different application for t-mobile.
- Test cases designing for Integration testing, System testing and Acceptance testing.
- Test execution and results updating.
- Testing Web services through auto script generation and validating SOAP responses and SOAP faults by doing response validation.
- Involved in status of functional test execution and links to view request XML sent and response XML received through Web Services.
- In addition to writing and executing tests for the entire development cycle, responsible for test automation using Test Partner tool.
- Assigned to testing the Premium Handset Protection functionality. Responsible for test case generation and execution. Project will require both backend database validation as well as front end GUI of Samson
- Hands-on experience leading all stages of system testing efforts including test plan, test design, test execution, and test report.
- Synchronized Tests to handle the anticipated timing problems using Quick Test Pro.
- Created VBScript library files containing VBScript functions, subroutines, classes, modules to associate the files with the test.
- Prioritizing the test cases using risk analysis.
- Using outstanding technical abilities to determine the level of testing required to validate new or revised system capabilities have been adequately tested for release to users in production environment.
- Attended weekly defects report meetings and presented progress updates.
- Responsible for ensuring that all necessary sign-offs have been achieved, understanding and adhering to test planning and execution guidelines, processes, and standards, improving and documenting the testing process, reporting status of assigned test tasks and issues and escalating issues and risks to project management/team lead as required
Environment: CSM, Quality Center 9.2, C#.NET, ASP.NET, Oracle, SQL, PL/SQL, T-SQL,TOAD, Benthic Gold, HTML, XML, VSS, IIS, Java script, Web Services, WSDI, NUnit, Java, Applets, JDBC, RMI, EJB, Java Beans, Servlets, JSP, JSTL, Custom Tags, JNDI, Java Server Faces(JSF), Struts 1.2x, ANT, IBM Web Sphere, BEA Web Logic, Windows XP/2003, MS Office 2003.
Confidential,San Ramon, CA Jun 2007 – Apr 2008
QA Analyst
Project: Amdocs Order Management System (OMS)
Amdocs Ordering is an end-to-end integrated ordering system that automates the entire ordering process, from negotiation to delivery and completion. It provides an overall solution to Communications Service Providers (CSPs) for all ordering activities across the full spectrum of wire line, wireless, cable, and convergent products and services in a single integrated environment.
Responsibilities:
- Defined Test Objectives by studying the Software requirements documents. Wrote Test Plans, Test strategy, Test Scenarios and Test cases.
- Attended walkthroughs for reviewing the software requirements and Test Plan proposal.
- Created Test Scenarios for the Functionality testing, System, Integration testing.
- Wrote test cases in Quality Center for the Sanity, Regression, functional testing based on the high-level design documents and Technical design documents.
- Executed the test cases for different components like U-Verse, HSIA, CVOIP, IPTV and Cingular combined billing and updated the test results in Quality Center.
- Reported the Defects in the Quality center after analyzing, interpreting the test results.
- Proven analytical skills in executing any assigned task such as creating Test case scenarios and using workarounds to test any given functionality or defect.
- Parameterized Steps, Checkpoints and Variables in the scrip to run the test on multiple sets of data with Quick Test Pro.
- Designed and implemented automated regression and performance tests using Quick Test Pro.
- Used various kinds of checkpoints like Standard Checkpoint, Page Checkpoint, Text Checkpoint, Database Checkpoint and Image Checkpoint.
- Involved in testing XML Web Services so that data can be accessed and consumed by clients and applications.
- Working on Online modules i.e. Telegence CSM, Billing, Price plan, Number Management system and Wireless Number portability.
- Helping developers to write C# object oriented classes.
- Responsible for writing test cases for Telegence (Customer Service management (CSM)), Number management, Billing, Accounts receivable (A/R).
- Experienced running MPS, MAF and all BLDAY jobs of Amdocs billing system in UNIX boxes.
- Used Telegence (CSM online) for activating Subscribers and check whether subscribers have been flowing to Enabler successfully.
- Used X-Term to create job recs or to run the batches in UNIX and also executed Billing sequential Jobs
through shell scripts in the X-Term.
- Worked on Emergency Request Fix (ERF) which is used to track the code fix through development and system testing where the code is determined and ready to be pushed for emergency case
- Conducted Sanity testing, Regression testing, System, Integration testing of the various Releases of Order Management System
- Support testing during UAT and production validation.
- Performed extensive Oracle back-end database testing.
- Conducted database testing using TOAD to query the database, and validating the data in the various database instances
- Checking the XML files in UNIX and validating if ordering system is sending correct rates to the enabler billing system.
- Modified and debugged the scripts used in production environment to be feasible to the test environment.
- Checking the Unix environments, running jobs, debugging shell scripts
- Importing and exporting database tables using TOAD among different database instances/schemas
- Checking the Log files for bugs/issues root cause analysis and reporting the problem areas to the concerned Developer.
- Resolved open issues by coordinating with developers and client during QA and UAT testing.
- Presenting daily status reports of the testing activities for the Day.
Environment: Clarify CRM, COBOL, AS/400, ASP.Net, C#.Net, ADO.Net, SharePoint, IIS, Rational Application Developer 6.0, Rational Clear Quest, Java, Applets, JDBC, RMI, EJB, Java Beans, Servlets, JSP, JSTL, Custom Tags, JNDI, Java Server Faces(JSF), Struts 1.2x, ANT, IBM Web Sphere 5.x, BEA Web Logic, Oracle, LDAP, TOAD, Benthic Gold, HTML, DHTML, CSS, XML, XSLT, SOAP, WSDI, Web Services, Java Script.
Confidential,Charlotte, NC Jan 2006 – May 2007
QA Analyst/ETL Tester
The project Card Data Repository (CDR) deals with credit card information of the bank customers. Extracting data from different sources like ZOOT,TSYS, Oracle, SQL Server, Flat files, External files and transformed the data based on Business requirements using Ab Initio component container and loading into Teradata target database, by running the graphs. I worked as an Ab Initio developer to develop numerous graphs to implement the business logic. Heterogeneous Operational Data Sources include data movement, data Transfer data using Ab Initio into Teradata.
Responsibilities:
- Worked closely with Data warehouse development teams to create test scripts for validating data loaded by extract processes and data (ETL).
- Performing the Functional and Regression testing
- Verifying the Data using TOAD and XML tools, executing the stored procedures and interacting with DBAs in resolving the database issues.
- Working with the legacy data warehouse applications
- Used the Mercury’s Quality Center for writing test cases.
- Testing the different scenarios on Profiles.
- Maintained log of test Results/Defects using Quality Center as per the rating and interacted with developers to resolve issues.
- Interacted with Business Requirements team regularly.
- Conducted Sanity testing, Regression testing, System, Integration testing of the various Releases of Order Management System
- Performed extensive back-end SQL Server 2005 database testing
- Closely monitoring the jobs running on UNIX server and supporting the testing team using Autosys.
- On call support for the QA environment and responsible for installing the QA builds also working closely with the Dev team
- Designed and implemented automated regression tests using Quick Test Pro.
- Used various kinds of checkpoints like Standard Checkpoint, Page Checkpoint, Text Checkpoint, Database Checkpoint and Image Checkpoint.
- Parameterized Steps, Checkpoints and Variables in the scrip to run the test on multiple sets of data with Quick Test Pro.
- Tested the values for test, Component parameters in Quality Center.
- Worked with Reusable Actions that can be called multiple times by the test in which it was created as well as by other tests.
- Synchronized Tests to handle the anticipated timing problems using Quick Test Pro.
- Created VBScript library files containing VBScript functions, subroutines, classes, modules to associate the files with the test.
- Executing the QTP test scripts and presenting the results
Environment: Quality Center, Rational Clear Quest, Quick Test Pro, UNIX, XML, XSLT, IIS, TOAD, SQL, Ab Initio (Co>OS v 2.1.14, GDE 1.1.14), UNIX, T-SQL, SQL Server 2000/2005, Teradata V2R5, Quest Central, IBM AIX 5.2, Shell Scripting, Windows NT/XP/2003 Server.
Confidential,PA Jan 2004 – Nov 2005 QA Tester/Functional and UAT Testing Analyst
GOS (Global Originating System) is a financial windows application developed for Wilmington Finance. This system is the premier processor for the sanction of loan. Originating System can maintain the customer data for loan processing. This system will verify the eligibility for loan approval after verification.
Responsibilities:
- Involved in testing business application and processing expertise throughout the development life
cycle of new applications, projects and production defect resolutions.
- Interpreted and analyzed business requirements to develop appropriate test plans.
- Executed various testing process to assure the quality of new or modified applications in multiple
environments utilizing company standard testing tools.
- Conducted Regression Testing on various builds of the application and reported the defects to the
developers using Test Director for the bug fixing and tracking
- Maintained various versions of Test Scripts using Test Director.
- Performed under aggressive deadlines and subjected to heavy workloads.
- Analyzed business requirements and assisted in defining the test parameters. Contributed to
business, development and testing Requirements reviews.
- Involved in documenting detailed Project test cases based on requirements outlined in technical
documents.
- Incorporated business and technical requirements into Objectives that exercised new and existing
functionalities of multiple personal lines on-line applications.
- Worked with the lead tester and other experienced tester to develop strategy for addressing issues
with project Requirements with appropriate business owners and developers.
- Created and maintained hard copy and on-line files that will document proper test objective set-
up and results have been achieved.
- Created, issued and located household data that will meet the requirements for individual test
scenarios.
- Recorded and executed moderate to complex test scenarios, comparing actual results with
expected results, and analyzed for any discrepancies that occurred.
- Identified, documented and tracked all system application defects, providing complete details and
attached documents relevant to defect resolution.
- Retested the duplicated scenario once programming changes have been completed.
- Prioritized daily and monthly work assignments, communicating the level of progress on test
objectives, defects, and other testing metrics to the Team Lead.
- Performed functional testing, performance testing, regression testing, stress testing, and data
validation testing of the application.
- Responsible for documenting test results and generating status reports for various phases of the
software release.
- Performed User Acceptance Testing (UAT), System testing, End-to-End testing, Functional
testing, and Ad-hoc Testing, Integration Testing as well as unit testing.
- Tracked and Managed Bug Reports in Test Director.
- Developed Test Plan and Test Cases to validate different modules
- Involved in Database Testing , loaded the test data into SQL Server database by writing SQL
queries
- Participated in various meetings and discussed enhancement and modification request issues.
- Extensively used Test Director for logging/tracking defects and worked proactively with the
- QA team lead and developers to resolve any issues that inhibited testing.
- Tracked outstanding defect reports and documented resolution after successful testing.
- Involved in creation of test scenarios to verify testable requirements.
- Involved in creation of detailed test scripts to support test scenarios.
- Actively involved in the Business Requirement Analysis meetings and scheduled the QA tasks.
- Involved in Smoke Testing on each build of the application.
- Tested Database integrity by executing SQL statements.
- Performed Backend testing using SQL.
- Documents the test results in reports.
- Analyzed the Business Requirements Document (BRD), modified the existing test plan
and prepared detailed test cases for the AUT.
Environment: Test Director 7.0, Java, J2EE, EJB, JSP, Oracle and Windows 2000.
Confidential,India Oct 2001 – Dec 2003
QA Tester
Responsibilities:
- Attended review meetings with Business Analysts, Developers and end users to understand and test according to their requirements.
- Developed Test Cases and Test Scripts for Functionality, Security and Regression Testing. Configured, developed, tested and supported the networks (Windows NT/ 2000).
- Performed Regression Testing, Ad-Hoc Testing, Integration Testing, Function Testing, Black box testing.
- Generated Test data for various types of testing like valid data, Invalid data.
- Provided clear and concise feedback to Development team on recurring errors both on an individual and team basis with the aim of minimizing the defects that can be there in final release.
- Used QTP to record the application flow and updating the VBscript.
- Documented the successful or unsuccessful completion of each test condition in the Test Director script Repository and verified actual results against expected results for discrepancies.
- Used Test director for bug tracking and Visual Source Safe for Version control.
Environment: Test Director, QTP, VBScript, MS-Word, MS-Access, MS-Excel.
Confidential,India Jun 2000 – Sept 2001 QA Engineer
Online Banking Solutions
This application was broadly divided into two-module nHome for individuals having an account and nBusiness for small business accounts. This application allowed the customers to access their various accounts like Savings, Checking, LOC, Loan, CD, and IRA on the worldwide web. It also allowed them to transfer funds between various accounts either a one-time transfer or a Recurring transfer (weekly, monthly & year).
Responsibilities:
- Analyzed the Business Requirements Documents and Functional specifications.
- Wrote Test plans, Test scenarios and Test cases from business, technical and functional requirement.
- Performed Manual Testing for the application GUI functionality testing.
- Used Quality Center for Test Planning, Test Designing, Test Analysis, Test Execution and Defect Tracking.
- Analyze Cash Management Banking product testing requirement’s to design the test plan and test strategy using time and resources available.
- Wrote and executed test cases for different types of testing like integration, functional, end to end testing, regression.
- Did the test evaluation with reference to Business Requirements, Design Specs and Functional Requirements.
- Performed Traceability Matrix between Requirements and Test Cases.
- Participated scheduled meetings and maintained good relationship with developers.
- Performed problem solving analysis and root cause for system functionality challenges by generating detailed reports of the Bugs, Pass-Fail report.
- Performed database testing using SQL Queries.
- Developed Base line scripts in order to test the future releases of the application.
Environment: Test Director , Win Runner, TOAD, XML, HTML, MS SQL Server 2005, SS Reporting Services (SSRS), I.E 6.0, C, C#, ASP.NET, HTML, XML, XSL, Java Script, SQL Server, IIS Server, Visual Studio .NET, Visual Source Safe, Windows 2000
EDUCATION:
- Master of Computer Applications (M.C.A)