SUMMARY

• Over 6+ years of industry experience in software testing with a solid understanding of Test Analysis, Test Planning, Test Design, content management, execution and defect tracking.
• Experienced in all stages of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Defect Life Cycle.
• 5+ years of experience in Information Technology with emphasis on Software Testing/Quality Assurance
• Experience in testing Standalone, Client Server, Mainframe, Tools and Web based applications
• Worked in Agile Methodology and Hadoop Technology
• Experience in conducting different types of testing including Black Box Testing, GUI Testing, Mobile Testing, Data Driven Testing, Back End Testing, Integration, Regression, Sanity, Functional and System testing
• 2 years of LEAD EXPERIENCE for QA testing teams including Onshore, Offshore and Third party teams.
• Provide test leadership of the QA and testing of multiple projects.
• Experience working with large distributed conversion team in Wellcare and Citrix.
• Experience working in testing projects in different domain levels Banking, Financial Services and Retail.
• Worked in all phases of software testing life cycle - Requirement, Design and Execution.
• Experience in HP Quality Center, QC ALM, QTP
• Involved in EDI 834 enrollment and maintenance transactions
• Good knowledge of writing SQL queries in Oracle, SQL-Server and DB2 database systems and experience conducting backend database testing
• Client-focused,Self-directed,Deadline-driven,Proficient - Communication and Technical skills. Interpersonal relations,Smart worker,Result-oriented as an individual or in team, Adaptable to new Concepts and Ideas,Flexible,Excellent decision making skills with a positive approach,Dedicated and highly ambitious to achieve personal goals as well as the organizational goals
• Involved in Project Management Review Meetings
• Diversified experience in Web based testing which includes ETL Tools, SSRS Reports, SSAS OLAP Cubes, OLAP ToolsBusiness objects
• Efficient in using PEGA and IBM business management tools.
• Proficient in Product, Sales & Health Insurance Domains.
• Tested web applications, mobile applications & Windows Standalone applications using Waterfall and Agile development techniques
• Expertise in Backend testing (Database Testing) using SQL Queries.
• Very good at Backend testing on OLAP Cubes and SSRS Reports, ability to write SQL Queries.
• Strong communicator and creative problem-solver skilled at analyzing business needs and transforming them into technical designs, applying technical skills and business knowledge to achieve sound results.
• Expertise in developing testing Artifacts - Test strategies, Test approach, test plans, test design specifications, Test scenarios, test case specifications test procedures and defect reports.
• Performed System Testing, Regression Testing, Integration Testing, Functionality testing, Compatibility/Mobile Device based testing, Redirect Testing, Negative Testing, Front end UI Testing, Backend Testing, Exhaustive testing and User Acceptance Testing (UAT)
• Proficient Multitask and flexible in adjusting as per demand
• Having good experience in Project documentation of designing and Test Procedures Very strong knowledge in relational databases (RDBMS), data modeling and in building Data Warehouse, Data Marts usingStar SchemaandSnow Flake Schema.

TECHNICAL SKILLS

Methodologies: Agile and Waterfall method

Business Management Tools: PEGA, IBM Tools, Tableau Application

Testing Tools: Quality Center, QTP

Office Tools: MS Excel, MS Word, MS Power Point

Databases: SQL server management systems (SSMS) 2008,2012,2014 and Teradata v2r5/v2r6

Languages: SQL, T-SQL, PL/SQL

Data Comparison Tools: Beyond Compare 4

Defect Tracking tools: HP Quality Center, Mantis Bug tracker, Smart Test Manager(STM)

Configuration Mgt Tools: Rational Clear Case, VSS and star team

Performance Testing Tools: Load Runner, Astra Load Test

Functional Testing Tools: Mercury Win Runner, QTP, Rational Robot,Astra Quick Test.

Version Control: Microsoft TFS, Guide wire Policy Center

FTP /Database/Design Tools: TOAD 8.x/9.x, SQL Developer.

Transaction Methods (health domain): EDI-834 enrollment and maintenance transactions

Operating Systems: Windows XP/NT/2000/98/95, Vista, 7 and 8

PROFESSIONAL EXPERIENCE

Confidential, Tampa, Florida

Onshore Test Lead

Responsibilities:

• Creating Testing Strategy and review with project teams/business and gain the approval.
• Create the Test Plan document and assist the PM for the test schedules, execution cycles etc.
• Testing business functionality using Pega Application
• Active member in Command Center and supporting the production issues on time.
• Involve in test execution for all types of testing: functional, system integration, user acceptance, regression, data integration and performance testing.
• Lead the Offshore testing teams and automation teams for the test planning, test execution and defect management activities.
• Work with users to identify and document BI requirements and solutions.
• Conceptual understanding of test coverage, test cases/scripts, test design, and automation techniques.
• Develop and implement reports and queries to drive business processes.
• Execute SQL queries, generate reports using tableau application based on the business requirements.
• Have Daily status call with offshore team to make sure the team completes the given task timely and properly.
• Conduct daily defect triage meetings with the development team/third party teams for the issue troubleshooting and defect closure.
• Generate test metrics and publish to the senior management teams, QA managers and business.

Confidential, Tampa, Florida

Sr. Quality Assurance Tester

Responsibilities:

• Understand and analyze the Business, Functional and Technical requirements.
• Testing Method - Agile Methodology: Manual Testing - EDI 834 Enrollment and Maintenance Transactions.
• Participate in Backlog Grooming, Sprint planning, everyday Storyboard status, Release planning and Scrum meetings.
• Prepare Test Estimates, Test Strategy, Test Scenarios, Test Summary report,
• Test data set up
• Peer review of Test cases
• Design and execute Test Cases for system testing, regression testing and Integration Testing/End to End Testing.
• Perform Employee Enrollment and validate the data.
• Tested reports and on demand letters that are generated by the Carriers
• Interacted with Business and helping the client in testing the new changes in the project
• Working directly to the developer and reporting the issues ASAP.

Confidential

Responsibilities:

• Understand and analyze the Business, Functional and Technical requirements.
• Testing the scenario through EDI transaction using CDH files.
• Assigned as Production resource in all stages of releases.
• Prepare Test Strategy, Test Scenarios and execute the test cases.
• Perform enrolling the employee with respect to scenarios and validate the data using DB tools and GUI screens
• Schedule Batches, Perform billing cycles, Generate bills and letters.
• Perform System, Functional, Integration and End to End Testing.
• Interacted with Business and helping the client in testing the new changes in the project
• Working directly to the developer and reporting the issues ASAP.

Environment: QTP 9.2, Quality Center 9.2, SQL, DB2, Mainframes, Business Rules Allocation, MS Excel, MS PowerPoint, Microsoft Share Point, Java, EDI Transactions, PEGA,CDH Files, 834 Transactions, CSR Tools Windows NT/XP, Visual Studio 2013, Windows.

Confidential, Fort Lauderdale, Florida

SQL BI Tester

Responsibilities:

• Prepared Test Plan from the Business Requirements, Functional Specification and Project Specifications
• Being successful in the team and coordinating the testing activities to complete System, Integration and UAT Test preparation on schedule.
• Experienced in defining, creating and implementing testing process and methodology for onsite/off-shore team.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Experience testing data conversions and migrations in cross platform scenarios.
• Quantitative and Qualitative testing of the ETL packages usingSSIS 2005/2008
• Having good knowledge on SSAS OLAP Cubes Testing, good in understanding the cubes and involved in validation the cubes in different platforms.
• Have knowledge on back end process of a cube.
• Hand on experience on SSRS Reports Testing.
• Involved in debugging the SQL Stored Procedures with developers for accuracy.
• Special contribution for creating Data Warehouse Details it is a complete reference document for all the SQL Jobs related in the project.
• This document contains a detailed information on the Jobs, packages related to the Jobs, Source and Destination tables of the packages Usage and advantages:
• Involved in extensive DATA validation using SQL queries and back-end testing
• Involved in Front to Back testing for all Asia pacific regions
• Review the test cases written based on the Change Request document.
• Tested data migration to ensure that integrity of data was not compromised.
• Defining processes to set up testing practice including automation and testing tools.
• Performed Functional, Regression, Data Integrity, System, Compatibility.
• Creating test scripts using Quality Center and performing regression testing on new versions of the software.
• Creating GUI Map File so that QTP can recognize the GUI objects in the application being tested
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Preparing and supporting the QA and UAT test environments.
• Tested different detail, summary reports and on demand reports.
• Communicated discrepancies determined in testing to impacted areas and monitored resolution.

Environment: XML, Excel 2010 and 2013,SQL Server 2008, 2012, 2014, QTP 9.2, Quality Center 9.2, DB Autosys, Metal (Meta Data Driven ETL), PEGA, BI Reports, MS Excel, MS PowerPoint, Microsoft Share Point, UNIX Shell Scripting, Windows NT/XP//2003, Visual Studio 2013.

Confidential - Chicago IL

QUALITY ANALYST

Responsibilities:

• Analyze business requirements document (BRD), functional specifications document(FRD) and the design document to prepare Test plan, Test scenarios, Business Test cases, Functional Test cases
• Quantitative and Qualitative testing of the ETL Informatica Power Center.
• Performed extensive DATA validation using SQL queries for ETL Process to back track the defects.
• Verified the Requirement Traceability matrix to ensure 100% Requirement coverage
• Involve in Bug Triage meetings with development team, providing vital information for defect fixes and prioritizing the defects with Business team
• Track all the requirements & Created Test suites in Quality Center
• Verified database using SQL queries in MS SQL server.
• Performed the Backend testing using SQL Queries
• Performed GUI testing, user acceptance testing, integration testing, navigation testing using mobile web, web and client-server applications, Web services Testing
• Involve in Black box and End-to-End, and test the application in multiple environments
• Responsible for handling team of re-execution of test cases once the defects are fixed
• Involved in testing and deployment of successful release of Heal Data migration
• Worked closely with Business Analysts & Customers to understand the business rules for each and every requirement and their implementations
• Log Defects for failed test cases in Quality Center & STM
• Updated the test plan if there are any changes in the timeline or delivery

Environment: Informatica Power Center 5.1, MS Excel, MS PowerPoint, Oracle 8, Visual Basic 6.0, XML, SQL, UNIX, IBM AIX 5.0, Windows XP/2003, HP Quality Center.

Confidential

Quality Analyst

Responsibilities:

• Involved in all stages of the software development life cycle to develop necessary test strategy
• Identify Use Cases and developed Use Case Diagram using UML
• Involved in writing the Test Plan, Test Cases, and Transferring User Requirements to Use Case Diagrams
• Attended Client calls to understand the requirements and responsible for the writing the Understanding document
• Developed Install scripts in Install shield to create MSI installers in Deployment Phase
• Conducted Database testing by executing SQL queries to check data in database
• Actively involved in all the stages of SDLC, STLC & Defect Life cycle
• Extensive experience in coordinating testing effort, responsible for test deliverables, status reporting to management, issue escalation
• Tracked failed test cases and reported bugs in Jira Bug tracker
• Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues
• Updated the all the testing artifacts as and when change requests are received

Environment: Quality Center 9.2, BI Reports, MS Excel, MS PowerPoint, Microsoft Share Point, UNIX Shell Scripting, Windows NT/XP//2003, Excel 2010 and 2013,IBM Tools,SQL Server 2014.

Confidential

MANUAL TESTER

Responsibilities:

• Analyzed the Business Requirements and functionalities involved in Engineering Applications such as Aircraft & Missile
• Involved in Code Development using AML (Adaptive Modeling Language) for Maintenance & Change Requests
• Conducted testing on development projects against project specifications
• Developed Test Cases and prepared data for test cases based on the user requirements and System architecture and functionality
• Interfaced with Project Managers and developers to understand system changes, review deployment plans and solicit approvals, communicate system issues and recommend upgrades
• Created and executed regression tests, verified bugs in jira bug tracker escalated critical issues
• Assist QA team members with projects, test case creation and execution
• Contribute to the overall quality and fidelity of client deliverables
• Review issues raised by the 3rd party teams, classify and assign appropriate issues and report the results
• Trained and worked with team for round-the-clock stress tests prior to delivery
• Understand the Test Cases prepared by client/myself for each Iteration stories.
• Responsible for sending the weekly & Monthly Status reports to all the stakeholders
• Periodically updated all the testing artifacts if there are any changes in the requirements, design and the functionality

Environment: / Tools: Test Director, Java, HTML, XML, Oracle 8i, DB Visualizer, Windows 7.