SUMMARY

• Over 7 years of extensive experience in Software Quality Assurance and Testing with strong knowledge of Software development life cycle (SDLC) and Software Testing Life Cycle (STLC)
• Hand on experience in Functional testing, Integration testing, System testing, Regression testing and End to End testing
• Experience in financial application testing such as Insurance, Banking, and web applications integrated with various legacy systems
• Extensive experience in all testing methods including Waterfall, Agile and Scrum
• Expertise in creating/developing Test cases, Test scenarios using standard and modular approach
• Experience in working as a single point of contact for all testing activities and as liaison between the different teams members and the manager
• Well versed with Manual and Automated Testing methodologies and principles.
• Validated insurance claims, customers’ records, and policy renewals data moving from operational data store to Enterprise data warehouse.
• Validated the market surveys functionality, both the front end and back end for gathering information about customers’ choice and preferences of insurance products and ongoing market trends in the insurance industry.
• Validated customized insurance programs functionality to suit the customer needs.
• Experience in testing/validating the Source, Stage and Target (End - to-End) data systems
• Familiar in working with Quality Center to store Business Requirements, Test Cases, Test Runs, and Test Results for every iteration and store defects and link them back to the requirements.
• Expertise in Defect Tracking, Defect management and Bug Reporting using tools like Clear Quest, Test Director, Quality Center
• Experience in End-to-End testing of an application/process. Performed backend testing using SQL Queries and UNIX scripting
• Experience in creating & scheduling the jobs using Autosys
• Ability to work as independent and team member in challenging and cross platform environment
• Highly motivated team player with excellent analytical, problem solving, interpersonal and communication skills

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, DB2, Teradata V2R6/V2R5, SQL Server 2005/2008

ETL Tools: Informatica

Operating System: Windows, UNIX (Solaris)

Scripting: UNIX Shell Scripting, PL/SQL scripts

RDBMS Load Tools: SQL Developer, SQL * Plus (Oracle), T-SQL (SQL Server)

Reporting Tools: Business Objects, Cognos, Micro Strategy, SSRS, SSAS

Database Tools: TOAD, SQL Developer, Rapid SQL

Languages: SQL, PL/SQL, T-SQL

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, North Carolina

QA Analyst

Responsibilities:

• Involved in various meeting like project kick-off, project planning, weekly & monthly client status meetings,
• Involved in writing and reviewing the test scripts
• Developed detailed Test Cases based on the Functional Requirements and Design Documents.
• Involved in Business analysis and requirements gathering.
• Identified the test data to execute the test cases.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Involved in creating and maintaining Defect Reports using ALM
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Automated the test scripts for the GUI, Functional, Data Driven and Regression testing using QTP.
• Used ALM for bug tracking and reporting, also followed up with the development team to verify bug and update bug status.
• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables when necessary.
• Wrote and executed automated Data Driven VB Scripts for different test scenarios in QTP.
• Participated in manual functional testing and automation using Autosys
• Experienced in data analysis using SQL, TQL, PL/SQL and many other queries based applications.
• Reported bugs and tracked defects using Quality Center.
• Developed VB Scripts using QTP
• Developed the Test Scripts and Test Cases in Quality Center.
• Coordinated with other technical teams to ensure compatibility with other modules and applications
• Worked as a consultant in delivering quality data centric solutions for various business domains.
• Data reconciliation in various source systems and in Teradata.
• Written several complex SQL queries for validating Cognos Reports.
• Extensively used SQL to verify and validate the data loaded into Target
• Preparing and supporting the QA test environments

Environment: Informatica Power Center 9.1, Claims, Agile, Cognos 10.2 series, Oracle 11g, HP ALM 11/quality center, SQL Server 2012, Oracle SQL Developer, Teradata, OBIEE 11g, XML, PL/SQL, SQL,TFS, UNIX, Windows Office

Confidential, Mendota Heights, MN

QA Analyst

Responsibilities:

• Developed detailed Test Cases based on the Functional Requirements and Design Documents.
• Identified the test data to execute the test cases.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Involved in creating and maintaining Defect Reports using ALM
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Automated the test scripts for the GUI, Functional, Data Driven and Regression testing using QTP.
• Used ALM for bug tracking and reporting, also followed up with the development team to verify bug and update bug status.
• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables when necessary.
• Wrote and executed automated Data Driven VB Scripts for different test scenarios in QTP.
• Participated in manual functional testing and automation using Autosys
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Reported bugs and tracked defects using Quality Center.
• Developed VB Scripts using QTP
• Developed the Test Scripts and Test Cases in Quality Center.
• Coordinated with other technical teams to ensure compatibility with other modules and applications
• Data reconciliation in various source systems and in Teradata.
• Extensively used SQL to verify and validate the data loaded into Target
• Preparing and supporting the QA test environments

Environment: Informatica Power Center 9.1, Claims, Agile, Cognos 10.2 series, Oracle 11g, HP ALM 11/quality center, SQL Server 2012, Oracle SQL Developer, Teradata, OBIEE 11g, XML, PL/SQL, SQL,TFS, UNIX, Windows Office

Confidential, Jersey City, NJ

QA Analyst

Responsibilities:

• Involved in various meeting like project kick-off, project planning, weekly & monthly client status meetings,
• Involved in writing and reviewing the test scripts.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Developed detailed Test Cases based on the Functional Requirements and Design Documents.
• Identified the test data to execute the test cases.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Involved in creating and maintaining Defect Reports using ALM 11
• Tested Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Automated the test scripts for the GUI, Functional, Data Driven and Regression testing using QTP.
• Did Data Centric Test Solutions for Data Warehouse, Data Integration, Data Quality Assessment and Data Privacy.
• Used ALM for bug tracking and reporting, also followed up with the development team to verify bug and update bug status.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables when necessary.
• Wrote and executed automated Data Driven VB Scripts for different test scenarios in QTP.
• Participated in manual functional testing and automation using Autosys
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Experienced in data analysis using SQL, TQL, PL/SQL and many other queries based applications.
• Reported bugs and tracked defects using Quality Center.
• Developed VB Scripts using QTP
• Developed the Test Scripts and Test Cases in Quality Center.
• Worked as a consultant in delivering quality data centric solutions for various business domains.
• Data reconciliation in various source systems and in Teradata.
• Written several complex SQL queries for validating Cognos Reports.
• Extensively used SQL to verify and validate the data loaded into Target
• Preparing and supporting the QA test environments

Environment: Informatica Power Center 9.1, Claims, Agile,Cognos 10.2 series, Oracle 11g, HP ALM 11/quality center, SQL Server 2012, Oracle SQL Developer, Teradata, OBIEE 11g, XML, PL/SQL, SQL,TFS, UNIX, Windows Office

Confidential, VA

QA Analyst

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Written 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
• Experienced using database query and integration tools such as SSIS, TOAD, SQL plus etc.
• Involved in testing SSIS Packages, and in Data Migration.
• Worked in an Agile technology with Scrum
• Involved in testing the Cognos reports by writing complex SQL queries
• Extensively used Informatica power center for extraction, transformation and loading process
• Tested SSIS packages according to business requirements and data mapping requirement documents.
• Obtained detailed understanding of data sources, Flat files & Complex Data Schemas in order to write the best test scripts.
• Tested User Interfaces developed using ASP, XML and VB Scripts.
• Uploaded the automation scripts to Quality Center and executed them from Test Lab module of ALM.
• Used ALM for bug tracking and reporting, also followed up with the development team to verify bug and update bug status.
• Created parameters that inserted different data into each iteration of a test run using Parameterize tests in QTP.
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Extensively used Descriptive Programming in QTP Automation Scripts.
• Created the Regression Test cases and automated them for the purpose of regression testing using QTP.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Experienced in data analysis using SQL, TSQL, PL/SQL and many other queries based applications.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Analyzed and created the bug tracking reporting and summary report in the Quality Center
• Extensively used SQL to verify and validate the data loaded into Target.
• As a part of Data centric testing, loaded to Data warehouse is correct as per the defined business rules.
• Managed and executed the test process, using Agile Methodology
• Documented and reported various bugs during Manual Testing.
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports
• Used SQL for Querying the database for data validation, data verification and data conditioning.
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Involving in Functional testing, Backend Testing, End to End testing and Regression Testing
• Involved in Preparing and supporting the QA test environments

Environment:, Agile, SQL Server 2008, claims, Cognos 8.0 Series, Oracle 11g, XML, XSLT, XSLD, Flat Files, MS Excel, SQL, T-SQL, PL/SQL, Informatica 8.6.1/8.1, Toad, Clear Quest, Windows, UNIX, Clear Case, HP

Confidential, Arlington Heights, IL

QA

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC).
• Validating the data passed to downstream systems.
• Used data stage director to run the jobs and check the log files.
• Performed manual testing on different modules of the application.
• Reported software mismatches (from the test planning), to the development team using Quality Center.
• Reported periodic project status and updates to the QA Lead and QA Manager
• Performed Integration Testing of different modules.
• Exclusively used Analysis Studio and Report Studio to test the Cognos Reports.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed,Drill down
• Designed, developed and executed Quick Test Pro VB scripts for functional and regression testing
• Wrote and executed automated Data Driven VB Scripts for different test scenarios in QTP.
• Validated Multi-Dimensional cubes using Power Play transformer
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Defect tracking and Defect Report Generation are prepared using ALM and HP Quality Center
• Performed data integrity testing by executing SQL statements and manually verifying the contents.
• Validated Query Prompts, Cascading Prompts, Calculations, Conditions & Filters
• Developed automation scripts in Quick Test Pro (QTP) to automate smoke and regression Testing
• Analyzed Business Requirements and Developed the Test Scripts and Test Cases
• Wrote Test cases in ALM and Defect report generation using ALM (Application Life cycle Management)
• Performed Risk Analysis based on Defect Severity and Priority.
• Tested User Interface inconsistency and application functionality.
• Worked on issues with migration from development to testing.
• Tested application in various browsers.

Environment: DB2, Oracle 10g, XML, Cognos7 Series, claims, informatica power center 7.2, Flat Files, MS Excel, SQL, TSQL, PL/SQL, SQL Server 2008/2005, Toad, Clear Quest, .Net, C#, Quality Center, Windows, UNIX