SUMMARY:

• Around 7 years of professional experience in Software Testing as Software Quality Assurance Engineer on different platforms and environments .
• Excellent analytical skills for understanding the business requirements, business rules/processes, and detailed design of the application.
• Good understand with Web Services and expert in writing test cases and executing Web Services using REST protocol on SOAPUI.
• Experience in creating functional/technical specifications, data design documents based on the requirements.
• Working experience in Waterfall (Software Development Life Cycle - SDLC), TDD, BDD and Agile Project Environment. 
•  Experienced in Waterfall, V -Model, RUP and Agile Methodology 
• Expert in writing Test Plans, defining Test Cases, developing and maintaining Test Scripts, Test Case Execution, Analyzing Bugs and interacting with team members in fixing the errors as per specifications and requirements.
• Experienced with Full Life Cycle and Methodology for implementing Data warehouse and Business Intelligence Reporting System.
• Extensive experience in quality assurance using Manual Testing, Automated testing tools like Quick Test Pro, QualityCenter.
• Hands on experience in Optimizing Database querying, data manipulation and population using SQL and PL/SQL in Oracle, Teradata, DB2 UDB and SQL Server databases.
• Responsible for configuration and implementation of SAP In-House Cash module for central cash, P-Cards and Credit card payments process, Central incoming receipts which include customer.
• Extensively strong on databases including Oracle 11g/10g/9i/8i, MS SQL Server 2012/2008R2 and IBM DB2.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Experience in complete Software Testing life cycle: Unit Testing, Functional Testing, Regression, Integration, System Testing, Performance testing and Data driven testing.
• Extensive experience in testing applications on UNIX environment.
• Excellent in meeting deadlines, time management and presentation skills.
• Excellent team player with problem-solving and trouble-shooting experience
• Worked on different platforms such as Windows XP,8 and UNIX, Sun Solaris, AIX, HP
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

Quality Assurance Tools /Test Management: HP ALM 11.5/ALM Quality center 11.0/HP Quality Center 10, Test Director 7.5, IBM ClearQuest

Environment: Windows 98/2000/NT/XP, IBM Mainframes, Unix, Linux.

Languages: SQL, PL/SQL, Unix Shell Script, PERL, Visual Basic, XML

RDBMS: Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008 , Teradata, Sybase, DB2

GUI/RDBMS Query Tools: SQL* Plus, Oracle SQL Developer, SQL Server Management studio, Teradata SQL Assistant 13.0, TOAD, WinSQL

Tools: Ms-Office suite(Word excel, Project and outlook)

BI Tools: Business Objects XIR2/XIR3, Cognos, OBIEE, Microstrategy, SSRS and Hyperion

PROFESSIONAL EXPERIENCE:

Confidential, Hopkins, MN

Sr.QA Analyst

Responsibilities:

• Responsible for Manual Testing and some Automation Testing using QTP 
• Prepared Test data preparation strategy and data masking strategy for the shared test environment
• Interacting with senior peers or subject matter experts to learn more about the data
• Worked on data migration from drive to AWS
• Manual Test Execution & Automated Test Script Runs for Regression Test. 
• Developed test scripts using QTP for Functionality and Regression Testing
•  Performed Functional, Integration, Regression, and End-to-End testing of the application against Use Cases through both manual testing and automation testing using HP UFT. 
• Performed web services testing with SOAP UI by validating request and response for XML files.
• Co-ordinate with development and QA team for handling of defects with respect to data.
• Extensive experience working with Waterfall/V Model and Agile Methodology.
• Maintained QA environments in AWS.
• Excellent understanding of Virtualization using AWS with experience in testing virtualization automation.
• Provide support during parallel and reverse parallel runs.
• Developed and maintained automated regression test cases using Web Driver with Java programming language
•  In depth knowledge and involved in all phases of Software Testing Life Cycle(STLC), which includes RUP, Agile and Water Fall methodologies. 
• Created UFT automation scripts using Descriptive programming, Custom Functions, Recovery Scenarios, Logics, Branching, and Looping. 
• Running Automated Test Scripts Using Quick test professional. 
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Verified all FINRA Data was copied to AWS Environment
• Created and executed automated test Scripts using QTP for Functional, Integration, and Regression testing
• Performed tests on various features of agile development process.
• Created spreadsheet with all the production issues/solutions as part of lessons learnt and to help form FAQ for the maintenance team.
•  Perform work in an Agile, Scrum, and Safeenvironment.
• Used Teradata, SQL assistant for running the SQL Queries to check the data loaded to the Target Tables.
• Identifying duplicate records in the staging area before data gets processed.
• Executed test validations at various levels including DB validation, rules validation, security validation, and UI validation.
• Responsible for working with Business team and SAP competency center Team to design business process for finance and cost accounting to implement SAP not limited to PTP, OTC, and RTR cycle.
• Extensively written test scripts for back-end validations.
• Maintained and improved existing HP UFT scripts in scale with reusable functions, modules, and better test data collection using Excel and database connections. 
• Created data rules to handle SCD Type II data using PL /SQL.
• Helped sequence the workflows for batch based on dependency to improve the time taken for end to end loading.
• Reviewed all artifacts created with respect to Logical and physical data models including Tables, procedures, indices, synonyms, views, functions, triggers, sequence, constraints.
• Extracted data from various heterogeneous sources like Oracle, Teradata and Flat Files.
• Tested and validated the BO reports by running similar SQL queries against the source system(s).
• Involved in the Web services testing, System testing, end to end testing and Regression testing, UAT, batch testing on the modified sprint build. 

Environment:HPALM, SQL, QTP, PL/SQL,Web Services, HP UFT, Java, TOAD, Oracle, TFS, Agile, MS Office,.NET, XML, HTML, Windows and Unix, AWS, Shell Scripting,

Confidential, PROVIDANCE, RI

QAAnalyst

Responsibilities:

• Involved in analyzing system design specifications and developed
• Test Scenarios and Test Cases to cover overall quality assurance testing.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Created Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer, cleanup and summarize data.
• Hands On Experience in Automation tools like HP QTP, HP UFT 
•  Analyzed the application and determined where to initiate manual testing and automated testing. 
• Strong testing Quality Assurance experience within agile environment. 
• Writing and executing test cases to verify SAP UAT pre-requisites to test data behaving, confirming to business requirement.
• Facilitated virtualization using AWS with experience in testing virtualization automation
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.
• Communicate testing status and results to Scrum team.
• Perform work in an Agile, Scrum, and Safe environment. 
• Create standard testing life cycle flow diagram for projects and presented to test team to follow testing process.
• Participated to create Test Analysis reports (TAR) and stored them into the Quality Center.
• Updated RTM in daily, send status report and daily tracking report to test manager.
• Maintained QA environments in AWS.
• Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing.
• Performed Functional Testing using Quality Center.
• Attended in Scrum Stand-ups Meeting and Code & Design Review meetings for QA updates, defect status, priority and Test Deliverables. 
•  Automation Regression test execution performed using HP QTP and HP UFT automation tools 
• Experienced in writing Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• Participated to develop automation scripts in QTP to automate smoke and regression testing.
• Used Quality center to execute automation scripts in batch mode or unattended mode.
• As part of database testing executed stored procedures to validate UI and database details. 
• Defined the “Test Engagement Process” for new application launch and maintenance releases.
• Developed SQL Queries to retrieve or create test data from different Oracle Test databases.
• Worked closely with the application development and design and testing team to resolve technical issues and interacted with them to ensure overall quality of the software.

Environment: Web Services/Web methods, AWS, HP UFT, Jira, QTP, Java, XML, HTML Oracle, SQL, TOAD, Agile, TFS,Windows 2003/2007, UNIX

Confidential, Silver Spring, MD

QA Analyst

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Experienced testing functional features of the application as well as UI level testing.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Performed web service testing using SOAPUI.
• Expertise in Defect Reporting and Tracking using Test Director/ HP Quality Center.
• Tested and validated the BO reports by running similar SQL queries against the source system(s).
• Testing the source and target databases for conformance to specifications
• Designed and prepared scripts to monitor uptime/downtime of different system components.
• Tested the reports developed using Business Objects.

Environment: BusinessObjects XIR3, WinSQL, HP QualityCenter, Teradata V2R6, TOAD, Teradata SQL Assistant, Oracle, PL/SQL, IBM DB2.

Confidential, RICHMOND, VA

QA Analyst

Responsibilities:

• Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.
• Validated data from front end systems to the backend databases.
• Performed both Positive Testing and Negative Testing.
• Performed Code review of automation Scripts and made comments for changes made in the script.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing)
• Involved in User Acceptance Testing, GUI Testing, and Regression testing, on different versions of the application.
• Validated all the web services by testing the WSDLs using SOAP UI.
• Participated in SCRUM and SPRINT meetings.
• Created Scenarios as per business requirements with various user loads using Performance Center.
• Proficient in different phases of Testing including Black Box, Functional, Integration, System,
• Tested and compared the cubes to the original requirements for complete functionality.
• Developed Test Plan, Test cases and Test Scenarios for new features.
• Enhanced the Ramp Up and Ramp Down time’s to simulate the real time scenarios.
• Extensively used SQL to query the Database to setup the test data for at least 500 virtual users for each applications.
• Assigned critical performance Defects to the developer using Quality Center.
• Weekly meeting with the management team and share the Status Report on the weekly basis.

Environment:SOAP UI, Quick Test Pro (QTP), Quality Center (QC), VB script, SQL, TOAD, Microsoft Visio, MS Access, Windows XP/2003/2007, and Oracle.

Confidential

QA Tester

Responsibilities: 

• Responsible for providing the testing team with the required business data, rules and logistics from the business, architecture and development teams and to inspect final scripts and confirm to laid down standards.
• Developed, modified and executed test cases and scripts using Test Director, VSS and Win Runner for Assembly, Functionality and Regression testing.
• Directly used backend servers, like AS400, Mainframes, DB2 and SQL Server for White Box and Backend Testing and other validations.
• Involved in designing and developing validation and test plan documentation.
• Prepared detailed reports of Bugs and Defects, pass/fail reports and comparison analysis, and interacted with the development teams, application and data architecture teams, migration and build teams and the DBA team to report and correct defects.
• Tested the application with different user profiles to simulate real time usage.
• Interacted with the Business Requirement and Client Advocate teams to understand, test and compare old and new business rules.

Environment: SQL Server 2005, Quick Test Pro, VB Script, Quality Center, MS Visio, MS Project, MS Windows 2003