SUMMARY

• Over 7 years of experience in Quality Assurance and Testing specializing in Client/Server, Database, ETL/Data Warehouse and Web based applications on Windows and Unix/Solaris/Linux Platforms.
• Experience working with web services using SoapUI.
• Experience with all phases of Project Life Cycle including requirement gathering, analysis, design, development, implementation, testing.
• Experience in working with end users in developing various test scenarios and test cases for UAT.
• Complete understanding of QA methodologies and Waterfall, Agile Scrum and RUP methodologies.
• Strong experience in performing different kinds of testing like Black box testing, White box testing, Functionality testing, GUI testing, Unit testing, Integration testing, Backend testing, Performance testing, Load testing, Facet testing, End to End, Stress testing, Regression testing.
• Experience in working with open source tools Selenium (Selenium IDE,Selenium Web Driver), JUnit, Eclipse and preparation of automation test framework.
• Excellent Understanding of Service Oriented Architecture (SOA) on ESB
• Hands - on experience on JAVA programming and tools like - Selenium and SOAP UI.
• Work experience in JSP, Servlets, JAXB, Hibernate, Struts, JSTL, spring, POI, Jasper Reports, etc.
• Hands on experience in Keyword Driven, Data Driven Automation Frameworks.
• Experience with EDI HIPAA 270, 271, 276, 277, 837 and 835 Transactions.
• Strong experience working with ETL Data warehouse implementation and complex SQL queries.
• Strong experience in working with HP/ALM, Quality Center and QTP.
• Strong working knowledge of Team Foundation Server (TFS) and Microsoft Test Manager (MTM)on Visual Studio Team Foundation (VSTF) in managing product lifecycle.
• Experience performing Security, Compatibility and Heavy load website testing including performance validation and Load testing.
• Strong Experience in writing test plan, traceability matrices, test scenarios and test cases.
• Expertise in providing Team QA estimates, facilitating daily status meetings and status report communication with PMO.
• Excellent analytical and programming abilities in using technology to create elegant, flexible and maintainable solutions for complex development problems
• Effective leadership skills with good written, verbal communication and presentation skills

TECHNICAL SKILLS

Operating Systems: MS-DOS, UNIX, and Windows 7, XP, 2000, NT, 98, 95, MAC

RDBMS: Oracle, SQL Server, DB2, TOAD

Languages: C, C++, Java,J2EE, ASP.Net,VB.Net, C# .Net, SQL, PL/SQL, HTML, XML, Unix Shell Scripting, JAVA Script

Testing Tools: HP ALM 11.0, HP Quality Center 11.0, HP Quick Test Pro 11.0, Load Runner, JIRA, Bugzilla, SOATest, SoapUI, Tools Selenium(Selenium IDE, Selenium.io; TestNG, Java Script)

Server-Side Technology: VB.Net

GUI: Visual Basic 6.0

Web Technologies: HTML, XML, XSD, WSDL

Packages: MS Office 2000, 2003

ETL Tools: Informatica, Crystal Reports, Cognos, Business Objects

PROFESSIONAL EXPERIENCE

Confidential, Santa Monica, CA

Sr. QA Analyst

Responsibilities:

• Responsible for analyzing business, technical design specification, mapping documents and developing test plans, test cases and test scripts and reporting defects using JIRA
• Preparation of test data forDaily Data Load checksin OMX-GUI
• Verifying the ETL loads of data to BI Oracle database is successful as per business logic
• Verifying data integrity of different subjects areas like- Orders/Order Status/ Payments/ Shipments/ Contra revenues/ Customer information of Orders that are placed in OMX
• Monitoring Telemarketer, Web and Customer service orders flow from different order sources through OMX and loaded to BI
• ValidatedCognos Cubes and reports that are generated out of BI data using Congos which is one of BI analytics tool
• ValidatedWeekly production reports against Cubes that are generated based on BI weekly loads and involved inFunctional testing, System testing, Integration testing, End to End testing and User Acceptance Testing (UAT) and production support
• Running and monitoring dailyETL Informatica test jobsin various environments
• Testing various daily processingSQL jobsand verifying the results.
• PerformingETL/Back end testingon various Batch Processing Modules using SQL queries.
• Creating and executingSQL queriesto perform Data Integrity testing.
• Performing data warehouse validation of source to target transformations using SQL queries.
• Wrote source to target SQL queries and validated data in the staging tables and target warehouse tables.
• Archiving and maintaining the history of the incremental staging extracts in BI Oracle environment.
• Transformations testing inSTG to ODS, STG to EDW and ODS to EDW dataloads by writing SQL queries.
• Worked on various web applications- UI, Functional testing, System testing, Integration testing, End to End testing and User Acceptance Testing (UAT) and production support
• Tested Integration Web Services and Demandware files- request and response payloads using XML validator, SOAP UI
• Tested the data in various downstream system files that were critical for business operations
• MaintainingTest plan, Test execution, test scripts, test cases, defect report and Test Summary reports and participated in Daily Stand ups, Inter/Intra QA meeting, defect review Meetings.

Environment: Informatica, Cognos, VBScript, Oracle, UNIX,Quick Test Professional, JIRA,Oracle, SQL, Toad, WinSql, Unix, Filezilla, Soap UI, XML, Web Services.

Confidential, Torrance, CA

Sr.QA Analyst

Responsibilities:

• Analyzed software and business requirements documents and created traceability matrix and high level test scenarios.
• Responsible for creating and executing test plans, test cases, test scripts, test scenarios and test reports for system testing and user acceptance testing.
• Worked closely with the QA Manager in coordination and implementation of the QA methodologies/QA processes.
• Tested on Verizon, Amazon, Liferay and IBM websphere web application environment.
• Worked on Core FTP server-connect; Putty to access the web application and data.
• Prepared test plan for performance testing based on SRS and project delivery plan.
• Responsible for deployingweb applications in QA environment.
• Performed Backend Testing, by executing complex SQL queries in Oracle, SQL server management databases, Oracle SQL developer.
• Performed extensive Database Testing by writing complex SQL Queries in TOAD, to test different scenarios of the application
• Responsible for creating Soap UI Pro script, required excel files and users list files and XML workflows using Web Services and also performed API level testing on Fiddler tool
• Worked on web applications- UI testing, Functional, End to End, Regression, and also worked on Vehicle (Acura) testing and Mobile (ios and Android) testing.
• Tested request and response payloads using Web Services.
• Performed load testing using SOAP UI to validate the performance of the web application
• Developed and Executed automated test scripts using Selenium IDE and Webdriver.
• Regression test cases were automated using Selenium WebDriver.
• Created and enhanced numerous test scripts to handle changes in the objects, in the tested application’s GUI and in the testing environment using Selenium.
• Developed automated scripts using QTP to perform functional and regression testing.
• Responsible for creating test data for various applications.
• Created and executed UAT test cases and coordinated with users on change requests.
• Interacted with developers, business analysts and the project manager.
• Actively participated in daily defects scrubs, reviews and walkthroughs.
• Coordinated with the offshore team by assigning them the daily tasks and reviewing their work.
• Provided time and resources estimation to the QA manager regarding new and existing projects.
• Responsible for creating release notes for production.
• Used QC for Test Plan creation, execution and defect tracking.

Environment: Visual Basic, Oracle 10g,DB2, Toad, MS-Word, Ms-Excel, MS-Project, Quality Center, QTP, ETL, Cognos, SoapUI, SOA, XML, Selenium (Junit, JAVA Script), webdriver

Confidential, Hartford, CT

Sr.QA Analyst

Responsibilities:

• Analyzed software and business requirements documents and created traceability matrix and high level test scenarios.
• Worked on ETL transformations implementation and Cognos reports validation.
• Responsible for creating and executing test plans, test cases, test scripts, test scenarios and test reports for system testing and user acceptance testing.
• Involved in Oracle application configuration and data integration with other services.
• Designed changes to Oracle application (EBS) and its related sub-systems
• Worked closely with the QA Manager in coordination and implementation of the QA methodologies/QA processes.
• Conducted Functionality testing during various phases of the application using QTP
• Used Parameterization in QTP extensively to perform Data-Driven testing.
• Performed SCRUM testing to validate the applications using Agile tracking tools.
• Performed manual and Selenium testing of web based application.
• Recorded and plays back test in Fire fox using Selenium IDE
• Exported Test case Scripts (Java-Selenium) in Eclipse IDE and modified the selenium scripts and executed. Prepared automation test framework.
• Tests developed in Eclipse to start and to stop the selenium server and to execute the tests in browser.
• Prepared test plan for performance testing based on SRS and project delivery plan.
• Responsible for deploying web applications in QA environment including the deployment of war files in web logic, deploying the static content and loading the data into the database using shell scripts.
• Performed Backend Testing, by executing complex SQL queries in Oracle and DB2 databases.
• Responsible for testing XML workflows using Web Services.
• Responsible for creating test data for various applications.
• Processed 837P, 837I and 837D transactions, verified those 837 transactions were converted correctly to XML file format and verified the claims data loaded to Facets for further processing.
• Worked with Accumulators, Deductibles, Coordination of Benefits, Overrides of the Claim Line detail and used them for testing various claims scenarios in Facets.
• Involved in testing the Pharmacy claims and Hospital Claims.
• Involved in testing the Medical and Dental claims.
• Validated the integration of SOA Web Service applications using SOAP UI
• Created and executed UAT test cases and coordinated with users on change requests.
• Involved in thorough compatibility testing of the site on different browsers and different OS.
• Interacted with developers, business analysts and the project manager.
• Actively participated in daily defects scrubs, reviews and walkthroughs.
• Coordinated with the offshore team by assigning them the daily tasks and reviewing their work.
• Provided time and resources estimation to the QA manager regarding new and existing projects.
• Responsible for creating release notes for production.
• Used QC for Test Plan creation, execution and defect tracking.

Environment: Visual Basic, ASP.Net, XML, Oracle 10g,DB2, Toad, MS-Word, Ms-Excel, MS-Project, QTP 11.0, Quality Center 11.0, ETL, Informatica, Cognos, SoapUI, SOA, Selenium webdriver, Selenium (JAVA Script)

Confidential, NY

QA Analyst

Responsibilities:

• Analyzed Business Requirements document for developing Test Plan, Test Cases and providing the Test estimations per session and prioritize the Test Cases.
• Worked closely with the QA Manager in coordination and implementation of Agile SCRUM QA methodology and other QA processes.
• Worked on Salesforce integration in SOA Architecture and validated the SOAP based web services.
• Reviewed requirements for Testability and Usability, consulted dev team regarding system functionality.
• Created the Test data using Altova XML Spy in XML format and made the required modifications that helped extensive backend testing.
• Worked on Team Foundation Server (TFS) and Microsoft Test Manager (MTM) to effectively manage the product life cycle.
• Interacted with developers, business analysts and the project manager and used VSTF 2010 to manage the product life cycle.
• Tested GUI results and compared with database values using SQL Query Analyzer
• Conducted daily Defect Meetings with project team to review defects identified during validation
• Conducted variance management by analyzing and verifying Test Results, providing status and progress reports using Quality Center.
• Performed extensive Database Testing by writing complex SQL Queries in TOAD to test different scenarios of the application
• Created and executed SQL queries to fetch data from an SQL Server database server to
• Validate and compare expected results with those actually obtained.
• Involved in web applications- UI testing, Regression testing of the builds and patches in staging and production environment.
• Involved in Setting up of Test and Staging environment.
• Worked with the project team to accomplish quality assurance and process improvement initiatives.
• Coordinated with Business Analyst, Development team and other project team members to discuss and resolve defects.
• Participated in the Team Meetings to discuss the issues raised during testing

Environment: XML, Java, Oracle Application Server, Oracle, Toad, XML Spy, Quality Center, TFS, MTM, QTP, SQL Server, Business Objects.

Confidential, Charlotte, NC

Sr. QA Analyst

Responsibilities:

• Analyzed software and business requirements documents and created traceability matrix and high level test scenarios.
• Responsible for creating and executing test plans, test cases, test scripts, test scenarios and test reports for system testing and user acceptance testing.
• Worked closely with the QA Manager in coordination and implementation of the QA methodologies/QA processes.
• Performed Backend Testing, by executing complex T-SQL queries in Oracle and DB2 databases.
• Tested XML messages using SoapUI.
• Responsible for creating test data for various applications.
• Responsible for writing UAT Test Cases and creating production like realistic test scenarios data.
• Involved in thorough compatibility testing of the site on different browsers and different operating systems.
• Interacted with developers, business analysts and the project manager and used VSTF 2010 to manage the product life cycle.
• Actively participated in daily defects scrubs, reviews and walkthroughs.
• Implemented smoke tests to validate the Test environment readiness and performed extensive positive and negative scenario testing
• Involved in Functional, Integration, User Acceptance, Compatibility and Comparison testing.
• Coordinated with the offshore team by assigning them the daily tasks and reviewing their work.
• Provided time and resources estimation to the QA manager regarding new and existing projects.
• Responsible for creating release notes for production.

Environment: Visual Basic, Oracle 10g,DB2,Toad,MS-Word,Ms-Excel, MS-Project, Quality Center, QTP, ETL, Informatica

Confidential

QA Analyst

Responsibilities:

• Performed system, integration, functional and user acceptance testing.
• Prepared test plans and test cases based on requirements.
• Prepared requirements traceability matrix.
• Debugged problems to determine root cause analysis and provided development team sufficient details to understand, replicate and resolve the issue.
• Performed analysis of software quality and testing progress to provide status to project team.
• Participated in change request meetings to document changes and implemented procedures for test changes.
• Supported UAT with users to receive customer approval and sign off.
• Performed both Manual/Automated Testing.
• Responsible for QA server setup after development code drop.
• Extensively wrote SQL and Unix Shell scripts, to minimize manual and data validations.
• Tested Informatica mapping by writing complex SQL queries
• Lead daily defect meetings and assigned the defects to developers and testers.
• Created defect reports out of QC and distributed to the team on a daily basis.

Environment: QTP, Quality Center, Test Director, Informatica, Crystal Reports, SQL Server, MS-Word, Ms-Excel, MS-Project.