SUMMARY:

• Extensive industry experience in both Manual and Automated testing of Object Oriented, Client - Server, Web based and N-Tier complex large scale applications.
• Expertise in defining Testing Methodologies, Designing Test Plans and Test Cases, Verifying and Validating Web-Based and Client-Server applications.
• Over 8 years of an experience in Software Quality Assurance and Software Testing in various industries.
• Expertise in Bug reporting tools such as BugZilla and ALM/Quality Center.
• Proficient in manual testing on Windows and UNIX environment.
• Excellent experience in Back-End Testing using SQL on UNIX and Windows platform to validate the consistency of data.
• Experience in Integration testing, GUI testing, Functional testing, and Regression testing.
• Extensive hands-on experience in Black Box, Smoke, Integration, Functional, End-to-End, Regression, UAT, Interface, Back-end and Performance testing.
• Proficient knowledge in various types of Software Testing such as Unit testing, Integrated testing.
• System Testing, Black box testing, Positive Testing, Negative testing, Performance Testing, Stress Testing, Load Testing, Volume Testing, Data Driven Testing, Back end Testing and Regression Testing
• Good working knowledge of major Operating Systems such as Windows and UNIX.
• Experience in End-to-End testing of mobile and kiosk applications.
• Knowledge of Automated Testing technologies, such as UFT/QTP and macro record/playback software such as TinyTask and Windows Macro Recorder.
• Experience with Healthcare systems with prime focus on claims adjudication, provider, eligibility and prior authorization.
• Excellent team player with strong written, communication, interpersonal and analytical skill.
• Experience running SQL queries for data validation and comparison to perform back end testing.
• Experience in writing SQL queries for inner joins and outer joins.
• Excellent team player with strong written, communication, interpersonal and analytical skill.
• Specialized in Web based and Data Management Projects. Also extensive experience in Manufacturing, financial applications as an ETL Tester.
• Experience working with ALM/Quality Center and JIRA for bug tracking and reporting defects.
• Experience in analysing requirements - Business requirements, Functional requirements and Technical specifications and created test strategies.
• Maintained Test Matrix and Requirement Traceability Matrix.
• Expertise in Writing Test Plans, Test cases, Test Scenarios. Creating and Managing Defect Cycle, Responsibility Assignment Matrix, traceability Matrix.
• Performed functional testing of individual modules (Accounts, Trading, Quotes and More) of the Application on iOS, Android, Blackberry OS, Windows OS operating systems.
• Strong Knowledge on MS Office suite, MS Visio, MS Project, and MS Access.
• Designed and executed manual and automated test cases through ALM/Quality Center by integrating UFT/QTP.
• Hands on experience in using tools such as Microsoft Office pack, ALM/Quality Center (QC), TOAD, SQL* Loader, and SQL*plus, TFS/MTM.
• Experience in Data Analysis, Data Validation, Data modelling, Data Cleansing, Data Verification and identifying data mismatch.
• Strong skills in performing Functional testing, GUI testing, System testing, Integration testing, End-to-end testing, Regression testing, Data-driven testing, Smoke testing, Sanity testing, User.

TECHNICAL SKILLS:

Testing: RQM, Rational Manual Tester, ALM/Quality Center, UFT/QTP

Languages: C++, JavaScript, HTML, Visual Basic, SQL and PL/SQL

Databases: Microsoft Access, SQL Server, Oracle Web ASP, VBScript, JavaScript, MTS, WebSphere Application Server, SoapUI

Defect Tracking: Rational ClearQuest, ALM/Quality Center

Microsoft Office: Excel, FrontPage, PowerPoint, Publisher, Word, etc.

Operating Systems: Microsoft Windows, MS-DOS, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, San Mateo, CA

SR.QUALITY ANALYST / Functional Tester

RESPONSIBILITIES:

• Reviewed the Business Requirement documents with the business and development team to understand the architecture and functionality of the application in an agile environment.
• Conducted Functionality testing during various phases of the application using UFT.
• Created and maintained detailed test cases to perform various types of testing in Test Plan module of ALM/Quality Center.
• Utilize agile testing by closely integrating with the developers for continuous testing and to ensure continuous process.
• Performed data driven testing by data driver wizard and parameterization in UFT for web based application.
• Generated Automation Scripts from Scratch for UFT.
• Designed, maintained and executed Automated Integration framework of API/Web Services across multiple test and production environments using SOA test.
• Created various Custom functions using VB scripting in UFT.
• Responsibility includes Database Testing (SQL, Oracle), End to end testing, Smoke testing, Regression Testing, and UI Testing on various builds, Requirement analysis, Boundary Value Analysis, Equivalence Partitioning, Functional Manual Testing, Regression Testing, and Fraud Module Integration Testing.
• Manually tested the In-Market Java application and performed complete test execution includes verifying and validating the Interface data, Functional, Regression, Integration, System, UAT and End to End Testing.
• Worked in JIRA for Bug reporting. Executed Manual test cases and identified the test cases needed for regression testing.
• Performed Back end testing using SQL queries to make sure that data entered has been uploaded correctly into the database tables.
• Database testing and for SSIS packages and SSRS reports.
• Performed black box testing and GUI testing of the web application.
• Interacted with the developers to report and using HP ALM/Quality Center.
• Involved in validating SOAP XML specifications as per the standards.
• Involved in review testing artifacts (Test Cases and Defects) via ALM/Quality Centre, system test plans and test kick-off
• Used JIRA for logging Defects and tracking
• Detected, reported and tracked defects using HP ALM/Quality Center.
• Executed automated test cases in HP ALM/Quality Center and reported defects in JIRA
• Used HP ALM/Quality Center to store Test Plans, Test Cases, Test Scripts and for bug tracking.
• Conducted the defect report in HP ALM/Quality Center.
• Identified software problems, wrote easy-to -follow bug reports, logged them into bug tracking tool HP ALM/Quality Center.

Environment: HP ALM/Quality Center, UFT/ QTP/UFT, Manual Testing, Mainframe, Android, iOS, Device Anywhere, JIRA, Web Services, SOAP UI, XML, UAT, OS, MS SQL Server, MS SQL, MS project, MS Office etc.

Quality Analyst / Functional mobile Tester

RESPONSIBILITIES:

• Reviewed the Business Requirement documents with the business and development team to understand the architecture and functionality of the application in an agile environment.
• Prepared AS-IS PMS (Mainframe Policy Management System) and to identify current functionalities for Quote, Submit and Issuance of Insurance Policies and TO-BE documentation.
• Conducted Functionality testing during various phases of the application using UFT/ QTP.
• Expert in writing test scripts manually.
• Involved in testing end to end processes in the Mobile and Wed Application Testing.
• Created and maintained detailed test cases to perform various types of testing in Test Plan module of ALM/Quality Center.
• Performed data driven testing by data driver wizard and parameterization in UFT/ QTP for web based application
• Performed regression tests on the application to assure proper functionality of the site after new builds.
• Performed manual testing (emulators & IOS Simulators) & Mobile Application Testing using Appium.
• Generated Automation Scripts from Scratch for UFT/ QTP.
• Involved in Smoke Testing, Functional Testing, System Testing, Integration Testing, Regression Testing.
• Involved in Mobile App testing Web applications and Mobile applications on iOS and Android Platforms.
• Performed system analysis of mobile web, Android and iOS applications.
• Conducted mobile apps testing across the web both automation and manually and using Power shell scripting.
• Created various Custom functions using VB scripting in UFT/ QTP
• Performed multi-platform (iOS, Android) compatibility testing.
• Interacted with the developers to report and using ALM/Quality Center.
• Worked in mainframe environment and used SQL to query various reporting databases
• Involved in validating SOAP XML specifications as per the standards.
• Functionally validated Web services delivered in SOAP XML format as provided in specification document
• Experienced in Agile Development process for diverse requirements
• Used JIRA for logging Defects and tracking
• Detected, reported and tracked defects using ALM/Quality Center.
• Tested the UI of the end product on mobile, PC, Android and Apple platforms to ensure that language translation and currency conversions were displaying as required
• Executed automated test cases in ALM/Quality Center and reported defects in JIRA
• Worked in an agile team to test the functionality of the Web based customer facing site
• Used ALM/Quality Center to store Test Plans, Test Cases, Test Scripts and for bug tracking.
• Tested and coordinated mobile applications in both Native and Web environments and validated the mobile application functionality on physical smart phone hardware devices and virtual device emulators like: Device Anywhere, perfecto mobile and Simulators like: Android SDK, IPhone SDK etc.
• Conducted the defect report in ALM/Quality Center.
• Identified software problems, wrote easy-to -follow bug reports, logged them into bug tracking tool ALM/Quality Center.

Environment: ALM/Quality Center, UFT/ QTP/UFT, Manual Testing, Mainframe, JIRA, Web Services, SOAP UI, XML, UAT, OS, Emulator like Device Anywhere, perfecto mobile, MS SQL Server, MS SQL, MS project, MS Office etc.

ETL TESTER / QA

RESPONSIBILITIES:

• Created Test Plan and developed a test suite for testing purpose.
• Extensively used T-SQL to verify and validate the data loaded to the MS SQL Server
• Extensively worked on documenting understanding document and testing metadata based on creating fact and dimension table implementation in Star Schema.
• Generated test data to support testing initiative.
• Tested pre-session, post-session routines and batch execution routines using UNIX scripts.
• Tested stored procedures & views in MS SQL Server.
• Heavily involved in interacting with UNIX Shell scripts.
• Involved in testing data migration.
• Developed and Tested Various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Tested the ETL AB Initio mappings and other ETL Processes (Data Warehouse Testing)
• Tested Microstrategy reports for business reporting needs.
• Tested dashboards using Microstrategy for business analysis.
• Performed ETL Testing to reconcile source files with and target GOLD.
• Performed ETL Testing to reconcile the existing futures DB system with GOLD.
• Validated end user report requests using SQL and Microstrategy tools.
• Worked on the performance tuning of the Microstrategy reports
• Tested Microstrategy Filters, Documents, Facts, Attributes, Hierarchies etc.
• Utilized HP ALM for Tracking and Reporting Defects, which are assigned to developers. Designed and developed Test Plans, Test Scripts and Test Cases in Quality Center and executed them.
• Involved in testing the functionality of Ab Initio Graphs.
• Designed and developed Test Plans, Test Scripts and Test Cases in Quality Center and executed them.
• Tested various ETL Scripts to load the data into Target Data Warehouse (Oracle / Teradata).
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries
• Involved in tracking bucks using Quality Center and Reported defects and impediments in JIRA.
• Worked with Data analyst for clarifications on for data loading for both dimensions and facts.
• Prepared extensive set of validation test cases to verify the data
• Validated Data in Database using SQL queries (Teradata, Oracle).
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted
• Involved in Functional testing, End to End testing and Regression Testing
• Preparing and supporting the QA and UAT test environments

Environment: Informatica Power Center, Microstrategy, ALM/Quality Center, XML, JIRA, XSD, XML Spy, SQL, PL/SQL, Teradata, Ab Initio, Oracle, UNIX, Windows, etc.

Quality Analyst

RESPONSIBILITIES:

• Wrote Test Plan and Test Cases according to business requirement.
• Wrote Test Cases using MS Excel.
• Performed data driven testing by data driver wizard and parameterization.
• Imported test cases from MS Excel, MS Word to Quality Center.
• Imported test cases from Quality Center to MS Excel or MS Word.
• Perform Black Box and on application API and Soap Web services.
• Participated in weekly meeting with the management team and walkthroughs
• Creating and enhancing numerous test scripts to handle changes in the objects, in the tested application and in the test environment.
• Conducted various types of testing like UAT, GUI, Functional and System.
• Created the performance testing, Quality Center deployment, and QTP implementation schedules using MS Project.
• Customizing Object repository objects under the Screen Names to which the objects are associated with.
• Created UAT Test Plan for mobile application testing. Outlined the new features in UAT Test Plan.
• Worked on Security Testing in SOAP-UI.
• Performed SIT, UAT, Functional/Regression, Smoke/Sanity, Backend, and Interface testing for web application by creating various positive/negative test cases.
• Working in regression automation QTP scripts, fixing regression failed cases. Carried out Testing of Webs services or SOA Testing using SOAP UI.
• Involved in tracking bucks using Quality Center and Reported defects and impediments in JIRA.
• Performed manual testing, Mobile Testing and Black box testing methods -Functional, Integration, System and Acceptance.
• Worked with WSDL files to validate the web services by using different features such as Service mocking, functional testing and Data Driven testing.
• Involved in validating SOAP XML specifications as per the standards.
• Functionally validated Web services delivered in SOAP XML format as provided in specification document.
• Performing Test Execution for different service contracts in HP service Test integrated in Quality Center.
• Involved in system &API testing for different modules
• Involved in parameterization of the objects and inserting checkpoints to verify the functionality of the applications in QTP.
• Coordinating with business users to answer all queries throughout deployment life cycle.
• Tested applications and documented results and bugs including documentation of information useful in the debugging process.
• Performed backend testing to validate the data using SQL queries.
• Manually wrote SQL queries to check the integrity of data.
• Quality Center was used to create the test plan, store test cases and run the test sets.
• Generated the test execution report in Quality Center to be reviewed by the QA Manager and development team.
• Prioritize testing priorities based on business risk, Access testing assets anytime, anywhere via a browser interface using ALM/Quality Center.

Environment: Quality Center, QTP, Service Oriented Architecture (SOA), Oracle, JIRA, Microsoft Visio, Rapid SQL, PL/SQL, SDLC, SOAP UI, API, XML, etc.

Quality Analyst

RESPONSIBILITIES:

• Prepare test plans and writing test cases based on business functional requirements.
• Work with development, users and support groups to understand the application architecture.
• Attend meetings to outline and present Regression testing strategies and objectives
• Develop scenarios for Regression/Functional testing for automation.
• Worked in Agile scrum methodology for both manual and automation testing.
• Generate automation scripts and test scripts using QTP for Regression Testing and the additional scripts are generated for each version.
• Use add­in from test advantage along with Quick Test Pro to handle the generic objects and user interface controls.
• Identified, Analyzed, and documented defects, errors, and inconsistencies in the application using JIRA.
• Performed System, User Interface, End to End, Functionality, Regression, Smoke, UAT, Stress, Black Box and Back-End Testing.
• Worked on Agile/ SCRUM technology and participated in daily SCRUM meeting, Sprint planning meeting.
• Use the concept of parameterization to run the script with different set of input data values.
• Used Check Points, Regular Expressions, and Object Repository Administration extensively in QTP
• (Quick Test Pro).
• Develop database test scripts using database checkpoints and performed database Integrity Testing.
• Interact with developers to resolve for the defects, which would affect income generating functionality in production.
• Detect defects analyse and report the defects to the Developers using Quality Center.
• Used Quality Center for maintaining, execution of test cases and for defect management.
• Interact with Business Analysts and Developers during defect review meetings during the project.

Environment: Quality Center, Quick Test Pro (QTP), UNIX, Oracle, Manual testing, DB2, SQL, JIRA, HTML. .Net, MS Office, Windows, Etc.(ILLC)