SUMMARY:

• Over 7 years of experience in Quality Assurance and Software Testing of various business applications inClient/Server environmentsand Data Warehousing solutions.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases.
• Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle.
• Have solid experience on database query tools such as TOAD, SQL Navigator, SQL Assistant and SQL Plus.
• Experience on UNIX commands and Shell Scripting.
• Experience in authoring UNIX shell scripts for automating metadata testing.
• Experienced in Functional testing, Performance testing, Load testing, Integration testing, System Testing, Regression testing, Black Box testing, Stress Testing, Smoke Testing, Recovery Testing, ETL Testing, DWH Testing, BI Reports Testing and GUI Testing.
• Strong experience in preparing documentation, preparing test environments, executing and analyzing the results.
• Very good understanding of Data Warehousing concepts
• Have experience in testing reconcile (initial) and delta (daily) loads.
• Have tested several complex reports generated by Cognos, including dashboards, summary reports, master detailed, drill down and score cards.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports.
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center, Clear Quest and JIRA.
• Expert in writing complexSQL queries for back - end testing.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Experience in Testing ETL, PL/SQL, UNIX batch jobs using Autosys scheduling tool.
• Manually conducted Functionality and GUI testing during the various phases of the development of the application manually.
• Experienced in writing and executing SQL queries to verifying Source-to-Target Mapping.
• Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
• Experience in working agile methodology environment.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS:

Languages & Packages: IPhone, IPod, IPad, IOS, Android, Blackberry OS, Device Anywhere, Android (Ginger Bread, Honey Comb), Perfecto, Windows Mobile, Ranorex, Robotium, Appium, Eggplant, WebKit, HTML5, Struts, WorkLight, Eclipse, WML, WAP, J2Me,C++, Java, Java Script, Servlets, ASP, VB Script, HTML, DHTML, XML, MS-Office, Project, Dynamics, SharePoint MOSS, Team Foundation Server, Visual Studio), WebLogic, Websphere (MQ Series, Message Broker), COTS, Siebel, Live Link, AMDOCS

Testing Tools: UFT/ QTPALM/QC, Jira, Bugzilla, SOAP UI, Selenium IDE, Selenium web driver, Junit, TestNG, Testify, Spira Test, Test Rail, Microsoft test manager, Team foundation server

OS & Database: IBM PC Compatibles, HP, Windows 7/8/10, Windows Server 08/12/16R2, Mainframes (TSO, SPUFI, File-Aid, IMS), HP-Unix, Sun Solaris 2.6, Linux, Oracle 7.x, Oracle 8.x, Oracle 11g, DB2, SQL Server 14.0, MS SQL, Crystal Reports, Cognos Reports, EDIS Confidential Bank

PROFESSIONAL EXPERIENCE:

Sr. QA Analyst

Responsibilities:

• Documented detailed Test plan based on the project documents and organized internal and external review sessions
• Interacted with the end users in requesting the Content Type for the applications
• Documented detailed Test Content Scenarios and Functionality Test Cases based on the requirements and provided a walkthrough session to the client
• Test automation scripting and execution using Selenium WebDriver and QTP
• Created content in the Content Management Server based on the Test scenarios and Test cases
• Mapped specific content to specific Test cases for execution purpose by creating Test Case Content Matrix
• Executed Test cases in the QA environment and validate the application functionality by performing shakedown, functionality, system, field level, usability, content, security, web framework, system integration, smoke, end to end, user acceptance and performance testing
• Executed Regression testing suites by retesting the functionality and content after defect fixes on CMS applications
• Created detailed CMS UAT test plan by interacting with end users and documented the plan based on the UAT time lines and deliverables
• Identified defects in UAT testing and reproduced in SIT environment to ensure the coverage of testing in SIT environment
• Generated Defects reports and provided to the management team and involved in the daily Defect triage meetings
• Tested mobile applications of the core banking application for both business and personal users using Appium

Confidential

Integration Tester

Responsibilities:

• Wrote Test scope documents based on IRD’s and IDD’s and got it signed off from the Business and the management
• Based on the test scope document written test cases and reviewed it with the BA’s and the team leads to ensure complete coverage
• Tested the ETL transformation process using the SSIS server
• Used Selenium web driver as an automation tool to automate regression tests in JAVA language
• Performed both Manual testing and Automation testing on the core banking application and also the interfaces interacting with the application, the automation was done on the regression suite built and most of the interface testing was done manually
• Raised defects based on the observations from the test cases and attended defect triage meetings to get it assigned to the proper team and proper developer
• Worked with the developers to replicate the issue in multiple environments
• Made sure the BUG fixes are retested in the expected environment with the expected data
• Updated the Test case linked to the BUG fixes if the fixes work
• Participated in Scrum meetings to update my work to the management and also report about roadblocks if any
• Expertise on Mobile App automation testing using Appium
• Identified all the Test Scenarios and Test Conditions to gather test environment and data requirements
• Manual testing of the desktop application was performed after an elaborate test plan and test case writing
• Created detailed Test cases based on Test scenarios and Test condition by applying both positive/negative approach, equivalence partitioning
• Work with the Executive Staff and various teams throughout the organization to provide a clear vision of QA and facilitate the execution of a results-driven Quality Management Process that is focused on: customer satisfaction, continuous improvement, employee development and business growth.
• Attended code reviews in the early stage of development to get an in-depth knowledge of the code
• Performed Sanity testing using selected critical Test cases to verify the stability of the build provided by the developers for testing
• Performed Functional, System, Integration testing by executing all the Functional test cases by validating and tracking the results
• Performed Smoke testing to identify the stability of the environments by executing few end-to-end test cases
• Performed End-to-End testing by coordinating with all the testing teams
• Provided Test Matrices like Test planning, Test execution and Defect status reports to the management

Confidential

QA Analyst

Responsibilities:

• Using Agile Timebox approach, all deliverables has been met Within deadline on various ongoing simultaneous tasks
• Responsible for gathering Conversion Strategies, Conversion Routines, Business Requirements, Software Requirement Specification, Data Model, DI Reports, and Use Cases
• Involved in the Software Development Life Cycle, created documents based on SDLC/CMM model.
• Created all the deliverables as per the WBS (Work Breakdown Structure)
• Created System Test Plan, which outlines Scope, Objective, Focus and Approach of the testing effort for this particular project
• Created test scenarios and test cases to test the mobile application using the IPhone (2G, 3G, 3GS, 4), IPod touch, IPad, Blackberry and Android phones in the test environment
• Created test scenarios and test cases in Device Anywhere tool for Click Mobile application and ensured the coverage of testing on each devise
• Requested different versions of IPhone, IPod touch, IPad, Android and Blackberry devices for Hardware testing
• Performed sanity, functionality, system integration, cross platform, cross browser and end to end testing on both Native and Mobile online applications using different phone devices and also used Devise Anywhere tool
• Created automated scripts using Perfecto and Utest and executed test scripts on new builds
• Worked closely with Developers and DBA in identifying the test environments for test execution of Click mobile application and requested the developers to load the application build in Device Anywhere tool
• Performed extensive security testing on the ClickMobile application in different versions of phone devices
• Created Functional Decision Tree which is a tool that helps the Test Planner to determine the most appropriate tests for a Requirement/Function based on their risk profiles
• Functional Requirements are created based on the Risk Factors and Risk Weights
• Used SQL extensively on Oracle database for back-end testing after ETL and Data conversion process
• Identified data mapping issues after conversion and reported to the development, data warehousing teams using Quality center
• Documented defect reported by incorporating bug clusters and defect severities
• Provided status reports to the management for assigned tasks
• Responsible for implementing Load Runner, Performance center, JMeter based infrastructure including: Architecting the load testing infrastructure, hardware & software integration with Load Runner
• Prepared Test Cases, Load Test Data, Execute tests, validate results, Managed defects and reported.