Sr. Qa Analyst Resume
OBJECTIVE: To obtain Senior Software QA/Test Engineer position in a fast-paced technology company with varied responsibilities and the potential for advancement. SUMMARY:
- Over 11 years as a Software QA Tester/Analyst and has extensive knowledge in entire SDLC.
- Experience in data analysis, software quality assurance of client/server and web based applications and strong ability to troubleshoot complex systems.
- Experience and knowledge on various QA methodologies like Waterfall, Agile, RUP methodologies.
- Have the knowledge on CMMI, COTS, Sec. 508 concepts.
- Have testing experience in manual, sanity/smoke, functional, Black Box, White Box, GUI, interface, migration, backend, regression, Reports, performance, integration, End-to-End testing, SOA, UAT, data validation for the software developed using Unix (Solaris, AIX, HP), Linux, Oracle, Sybase, DB2, Teradata, HTML, XML, .Net, Java and C/C++.
- Performed testing using the Test tools like QC, CQ, BLT, Capstone, BOXI, Xml Spy, PegaReach, Actimize Case Manager, WebTrak, BMC-Remedy and VMware.
- Have experience creating and maintaining software test documents like Test Strategy, Test Plan, test cases, test procedures and test scripts based on Use Cases, product specifications, Requirements, Design docs and meeting deliverables in time.
- Co-ordinate with the business analysts and developers to understand new software requirements and communicated application and/or requirements issues to the appropriate teams in a timely manner.
- Formulated and documented detailed test cases, test scenarios, recorded test results and provided test metrics to the program management and test management teams periodically and reviewed the progress.
- Expertise working on Quality Center, ClearQuest, iCART for requirements management, planning, scheduling, running tests, defect tracking, managing the defects and executing the test cases.
- Managed requirements and testing phases of projects, related to industries like Financial (Mortgage, Banking, Credit Card) Telecommunications (Verizon), Media Businesses (AOL).
- Flexible and versatile to adapt to any new environment and any project.
- Ability to work under tight deadlines, ability to work on multiple projects simultaneously, ability to translate high-level requirements, design into test cases and test scripts, ability to work in cross-functional teams across multiple levels of the organization.
- Possess excellent communication, presentation, analytical, issue finding, solving and learning skills.
Operating Systems: AIX, HP-Unix, Solaris, Linux, MS-DOS, Mac, WINDOWS
Databases: Oracle, Sybase, DB2, Teradata, Netezza, MYSQL, SQL Server, MS Access
Languages: SQL, T-SQL, PL/SQL, Shell Scripting, HTML, XML
Tools/ETL: Quality Center, ClearQuest, iCART, BOXI, QTP, Capstone, Autosys, Orchestrate, Ab Initio,
Ms-Visio, Ms- Office, TOAD, DB-Artisan, WinSQL, Oracle SQL Developer, WinSCP,
VMware, Altova XMLSpy, Actimize, EditPlus, PVCS Tracker, BMC-Remedy, WebTrak
- Mar 2010 - Present - Sr. QA Analyst, Confidential,VA
- Feb 2009 - Mar 2010 - Sr. QA Tester/Analyst, Confidential,CA
- Jan 2007 - Jan 2009 - Sr. QA Tester/QA Team Lead, Confidential,VA
- May 2004 - Dec 2006 - Sr. QA Tester/Analyst, Confidential,VA
- Apr 2003 - Apr 2004 - Sr. QA Analyst, Confidential,VA
- Oct 2000 - Mar 2003 - QA Tester/Analyst Confidential,MA & MD
Confidential,VA Mar 2010 – Present
As a Senior QA Analyst working on ULDD (Acquisitions Technology - Loan Delivery Application - Single Family), is a web based application that allows lenders to submit their loans to FannieMae in fulfillment of Whole loan Commitments (Cash) and Pool purchase (MBS – Mortgage Back Securities) contracts.
- Reviewed the requirements, Technical specifications documents which were generated by DOORS tool.
- Responsible to write test cases using Quality Center, linked to the requirements, established Test Sets, and tracked through completion of testing
- Entered and tracked all defects through Clear Quest
- Extensively used ALTOVA XMLSpy tool for schema validation and edit xml file (MISMO 3.0 Standard)
- Extensively used XMLSpy tool to import/delivery of loan data through xml and also used 2k file through TextPad
- Performed Desktop Underwriting (DU) through LD application
- Performed testing of transferring loans between the Pools and between the Commitments
- Extensively used Unix (Solaris) commands and shell scripts to perform backend validations for Transmission testing after submitting the loans into two different LD releases 9.0/11.0.
- Used BMC Remedy to create tickets to modify the ‘CutOverDate’, ‘ArchiveModeDate’ for Customer transition testing
- Performed Data Persistence testing after importing loans to LD and taking DB snap shots before and after modification of loans and compared the results
- Performed Customer Transition testing on LD Legacy applications
- Performed archive process testing by running Unix scripts after submitting the loans
- Used AUTOSYS jobs through Unix CLI for which calls SQL scripts for extracting and transforming data into Sybase databases
- Extensively used SQL queries/Scripts against database to validate the test results
- Debug the failed importing files of xml and 2k
- Debug the log files to find the cause for failed Unix and Autosys jobs
- Responsible to perform functional, system, backend, interface, integration, Beta testing
Environment: XML, Altova-XmlSpy, Sybase, SQL, SybaseQueryTool, QualityCenter, ClearQuest, Solaris (Unix), Linux, Autosys Jobs, WinSCP, vi, BMC-Remedy, FTP, TCP/IP, I.E, IIS, Java/JDK, ODBC, JDBC, Weblogic, Win XP, MS-Project, MS-Office
Confidential,VA
As a Senior QA Tester/Analyst worked on GPP (Global Pay Plus) Project of Capital Markets is a 3rd party COTS product designed to replace existing IWT which handled wire transfer.
- Attended Project Walkthroughs and meetings of users
- Reviewed Business Requirements, Use Cases, Solutions Specs, Configuration Docs (GPP Configuration Matrix, User Roles and Entitlement Matrix) and created Test Scenarios and Test Cases for System, Integration and Regression testing.
- Also responsible to write Test Scenarios and Test Cases for System, Integration and Regression based Report specifications doc for Report testing.
- Created wires with different departments like MFO/CMO/SFO/FIN/CSH/ETS and used those accounts for testing at various Cut-Off times
- Entered and tracked all defects through Clear Quest
- Extensively written complex SQL queries/Scripts (Joins, Group By, Order By, Aliases etc) using Toad against Oracle database to validate the test results of GPP application and GPP Reports
- Extensively used Unix (Solaris) commands/scripts for EOD and SOD jobs on daily basis
- Performed Reports testing with Business Objects Reporting tool BOXI
- Extensively used Quality Center for writing Test Cases and mapping them with Requirements and moving them to Test lab for execution
- Extensively used iCART/Clear Quest for entering and tracking defects
- Performed RTM (Requirement Traceability Matrix) after end of testing
Environment: Oracle, SQL, Toad, BOXI (Business Objects), Actimize Case Manager, QualityCenter, ClearQuest, Unix Solaris, WinSCP, vi, FTP, TCP/IP, LDAP, I.E, IIS, Java/JDK, ODBC, JDBC, Weblogic, Windows XP, MS-Project, MS-Office
Confidential,San Francisco CA Feb 2009 – Mar 2010
As a Senior QA Tester/Analyst of BCT QA team worked for MSR project. MSR (My Spending Report) is an online tool with which Wells Fargo online account holders can view transactions and control their budget and also can see the details of inflow and outflow. Customer can view his online transactions of his Credit Card, Check Card, Checking A/c - DDA and Bill Pay. Also worked on FXOL project is a Foreign Exchange on Line.
- Reviewed the requirements, wrote test cases using QualityCenter, mapped the requirements with Test Cases, established Test Sets, and tracked through completion of testing
- Entered and tracked all defects through ClearQuest
- Extensively used Unix for Batch testing for the files received for BK/FDR, Hogan, Powers, Billpay
- Extensively used AUTOSYS jobs through Unix CLI and UWCC for executing Autosys jobs which calls Ab Initio (ETL) scripts for extracting and transforming data into Teradata database
- Executed test cases and validated the functionality on Backend by writing complex SQL queries (Joins, Order by, Group By, Aliases etc) against Stage and Target tables of Teradata & Oracle databases
- Extensively worked on merging projects of Wachovia-Wells Fargo for comparing the results
- Extensively performed migration testing on new database server after code migration
- Validated alert messages/mails on different operating systems ( Win7/XP/Vista and Mac OS) and browsers (IE/FF/Safari) through VMware for FXOL project
- Performed Integration and End2End testing duly coordinating with other downstream systems
- Debug the log files to find the cause for failed jobs
Environment: Teradata, Oracle, SQL, PL/SQL, Oracle SQL Developer, QualityCenter, ClearQuest, Ab Initio, UWCC, Autosys, Solaris, vi, Linux, Shell script, EditPlus, FTP, TCP/IP, I.E, IIS, Java/JDK, ODBC, JDBC, Weblogic, VMware, Windows XP, Mac, MS-Office, IE/FF/Safari
Confidential,Ashburn VA Jan2007 – Jan2009
I worked as Senior QA Analyst and Team Lead for the OrderPro project. OrderPro is a Web-based Verizon Business Order Entry system supporting the various Market Segments, Options, Order Types, Products/Protocols, Circuits, Port types, Access Types and Features to create orders.
- Attended walkthroughs of Use Cases and Requirements.
- Reviewed the requirements, wrote test cases using Quality Center, linked to the requirements, established Test Sets, and tracked through completion of testing.
- Entered and tracked all defects through Quality Center.
- Responsible to perform System, Interface, Integration, End2End, Regression and Implementation testing.
- Created Networx & Non-Networx Orders by using various networking & commercial products (ATM, FR, FRASI, PIP, USPL, VPWS, IDA, IDE, INP, EACS, BACS)
- Performed regression testing using QTP
- Performed backend validations on SQL Server after submitting the Orders
- Created orders by choosing various Market Segments, Order Types, Options, various Access types DS0, DS1, DS3, OCn, Ethernet, various conditions like CPE, PVC, ESP
- Created orders (ATM, FR, FRASI, PIP, SIP, VOIP etc) using various Port Speeds, Port Types, Access Speeds
- As a Team Lead, responsible to assign the projects to the team members, Post the projects under test to Quality Center, performed RTM (map the req with Test Cases), review the Test Cases internally and externally, conduct the meetings with onshore/offshore teams to review the testing progress, prepare and send the daily testing progress reports
- Responsible for training and helping the newly assigned personnel in acclimating to the Testing Environment and Application process
Environment: XML, C++, J2EE, SQL Server, IIS Web Server, WebLogic, Windows XP, Ms-Office, Ms-Visio, IE, QualityCenter, Products/Protocols (FTP, SSH, SMTP, SIP, SS7, HTTP, TCP/IP, IP, ATM, FR, PIP FRASI, VOIP, IPVPN)
Confidential,Dulles VA May 2004 – Dec 2006
As a Senior QA Consultant from CSC (Computer Sciences Corporation) served AOL as a Senior QA Tester on an Automated Member Management Project.
- Assured that all assigned campaigns meet QA entry and exit criteria prior to initiating campaign testing. This includes reviewing QAR for correctness and completeness.
- Prior to developing test cases performed pre-test reviews of applicable campaign requirements and design documents
- Responsible for preparing QA Test Strategy Documents, Test Plans, and User Acceptance Test Reports for assigned campaigns and wrote test cases using Quality Center, linked to the requirements, establishing Test Sets, and tracked through completion of testing
- Extensively used SQL scripts which call PL/SQL stored procedures to install/load the data into test environment
- Responsible for integration testing using Batch Load process which calls Unix shell scripts
- Performed QA Testing, entered and tracked all defects through the Bug Logging and Tracking system and provided clear and concise status reports of testing to the QA Manager
- Analyzed the LOG files for debugging after executing the scripts
- Responsible for Regression testing after fixing the defects
Environment: XML, C++, J2EE, HP-Unix, Linux, Shell Script, Perl, WinSCP, Putty, Sybase, Oracle, Netezza, SQL, Pl/SQL, WinSQL, DBArtisan, WebLogic, IIS, Apache, Windows XP, Ms-Office, Ms-VSS, IE, Netscape, WebTrak (Remedy), TAS, TestDirector/Quality Center, BLT, PegaReach, AOL Client 6/7/8/9, Protocols (FTP, TCP/IP,SMTP, HTTP)
Confidential,Richmond VA Apr 2003 – Apr 2004
Senior QA Analyst: Capstone (Credit Card Application Decision making engine) is a rules-engine based decision server implemented using UNIX and Oracle. This Engine will decision the Credit Limit of the applications received via mail, voice response units and third party vendors, partner systems etc (Lowe’s, TjMax, Amerifee etc), and once the application is approved, based on the Credit Limit and if the application has Balance Transfer (BT), CAPSTONE will decision the Credit Card Application which comes through web site and BT results will respond back to the Customer with Approved BT amount. I worked on TABASCO (Transfer All BAlanceS to Capital One) project.
- Reviewed the requirements, wrote test cases using Test Director, mapped the requirements, established Test Sets, and tracked through completion of testing.
- Entered and tracked all defects in Clear Quest.
- Extensively performed System, Interface, Integration, Regression and Implementation testing
- Used SAS for taking snapshots for Data validation before and after the Data load
- Extensively used complex queries in SQL (Joins, Group By, Order By) to validate the test results
- Prepared Test data based on positive and negative testing using TDG, vi editor and ISPF editor
- Responsible to execute Unix scripts/Batch jobs which calls the Ab Initio (ETL) scripts for performing BulkLoad process
- Responsible for performing migration testing on different DB servers and compared the test results
- Responsible for debugging the log files after executing the scripts
Environment: TestDirector, ClearQuest, ClearCase, HNC–Capstone (CWS, AWS), TDG, Ab Initio, Oracle, SQL, PL/SQL, TOAD, Power Builder, UNIX, ISPF editor, vi editor, Shell script, FTP, TCP/IP, I.E, IIS, Win2000/XP, Ms-Office
Confidential,MD Jul 2002 – Mar 2003
I have worked as a QA Tester for BSAS (Broadband Service Assurance Systems) application of DNMS (Data Network Management System) for data services of the Verizon East region. DNMS was developed to support Verizon East’s DSL, Frame Relay, ATM, TLS, ISP, AD-FP, Network ADN, Access ADN, LAN, Meetpoint and FDDI networks. It integrating with CTT and provides Alarm Survivalence, Trouble Ticketing, Inventory, PVC Provisioning, and Configuration Management of Verizon-East’s DSL and Fast Packet networks.
- Reviewed the requirements, wrote test cases. Also entered and tracked all defects in Continuus.
- Prepared the scripts (UNIX) based on the SRS and Design documents.
- Executed the NCON, Delivery scripts on UNIX platform supported by Exceed/X Start to create circuits such as ATM, FR, DSL ORT, etc. with IP/IE status
- Created different circuits FP, DSL, IPVPN, TSPID using ATM, FR, FRASI protocols
- Analyzed the LOG files after executing the scripts for finding the errors
- Compare the data of scripts file with the front-end data on DNMS side
- Used SQL complex queries to validate the data in the output tables are correctly populated
- Created/modified the circuits with using different protocols ATM/FR and FRASI through CTT and compare the same on front-end side
- Configured and setup the different Test boxes for accessing UNIX servers on Windows
- Involved in Network Integration testing, Performed Network performance test of DNMS applications by executing the Delivery/NCON scripts
- Performed the Functional, System, Unit & Integration, and Implementation testing in the production environment after installing the Product/Release
Environment: SQL, Oracle, UNIX (Sun Solaris 5.6), Shell Script (sh), C/C++, Java, XML, PVCS, TCP/IP, FTP, ATM, FR, FRASI, IPVPN, Sqlldr, PVCS, Windows NT/2000, X Windows, Exceed/X Start 6.1, Exceed Server, Perl, Citrix, Lotus Notes R5, Sun Enterprise Servers, IIS Web Server, TestDirector, Continuus, Ms-Office, IE 5.5, Netscape 4.7
Confidential,Boston MA Oct 2000 – Jun 2002
QA Tester: DWBI/MSLD (Data Warehouse and Business Intelligence/Marketing Service Long Distance) is a Data Warehousing application in Verizon. As an Operations Quality Test Team member, to test any application that resides on a DWBI/MSLD production server regardless if it is a new or enhancement releases for VERIZON
- Analyzed user Requirements, General Design, Detail Design documents, Developed Test Proposal & Test Plan includes actual test cases and scenarios
- Used Export & Import methods to transfer the data from production environment to Test environment for test data preparation
- Used Orchestrate (ETL) tool for extracting, transforming and data loading
- Involved in installation of software and Setup the servers (UNIX and Windows) including system and user administration
- Performed the Functional, System, GUI, Unit & Integration testing
- Performed Cross-Browser testing on Netscape & IE and Cross-Platform testing on Windows & Unix
- Executed the test scenarios on Unix platform that fulfill the test designs and test plan
- Used Oracle Applications to validate the data in front-end reports
- Analyzed the LOG files for debugging after executing the scripts
- Extensively interacted with the developers to resolve the bugs
Environment: Oracle, Oracle Applications, Unix (AIX), Shell Script (ksh), C/C++, PVCS, TCP/IP, FTP, Win 95/NT, IIS,
Lotus Notes 4.6, Perl, Orchestrate, Ms-Office, IE 5.5, Netscape 4.7
- Certifications: Cognos BI (Business Intelligence)
- Master Diploma in Computer Applications
- MS in Applied Sciences
- BS in Math