SUMMARY

• Senior Software QA Engineer with around 10 years of experience in Information Technology, with specializing in Software Quality Assurance Testing, proficient in testing Web based Applications, Client/Server Applications, Data Warehousing and Business Intelligence solutions.
• Experience in all phases of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Defect Life Cycle and Methods like Waterfall and Agile.
• Extensive experience in implementing QA Methodologies, Test Plans, Test Cases, Test Scenarios, Test Summary reports and Defect Status reports.
• Experience in Functional testing, Regression testing, Integration testing, Smoke testing, Graphical User Interface testing (GUI), Black Box testing, White Box testing, Exploratory testing, API Testing, Browser compatibility testing, User Acceptance Testing(UAT), Performance testing, Web Services testing and Database testing.
• Extensive experience in automating regression and functional test cases using Selenium Web driver with Java and TestNG.
• Good knowledge of Jenkins for Continuous Integration in test automation process.
• Good experience in testing Web Services like SOAP and REST using SOAPUI tool.
• Tested RESTful Web Services using Http methods for CRUD operations.
• Conversant with HTML, XML, WSDL and Soap.
• Good knowledge of different Data Warehousing methodologies and concepts including Star Schema, Snowflake Schema, ETL processes and BI reporting.
• Expert in writing SQL queries for ETL testing and Reports data validations.
• Good experience using database query tools such as TOAD and SQL Developer.
• Validated and created Reports using Cognos and SSRS.
• Extensively used Framework Studio, Report Studio, Query Studio and Analysis Studio for Cognos Reports.
• Tested different reports including Summary reports, Adhoc reports and Sub - Reports using by SSRS Report Studio.
• Assisted in writing, executing and verifying complex SQL queries and PL/SQL statements to validate ETL test cases prepared based on Business requirements.
• Involved in the Extract, Transform and Load process utilizing Informatica Power center and validated data with Informatica Data Validation Option DVO.
• Extensively worked on Informatica Components like Repository manager, Designer, Workflow Manager and
• Workflow Monitor.
• Involved in creating and executing test scenarios for verifying data quality, accuracy, integrity and transformation rules using ETL testing best practices.
• Verified Table relations - Joins and keys are preserved during Data Transformation.
• Executed test scenarios to verify the transformation logic is working as per Mapping document.
• Experience in identifying bottlenecks in ETL Processes.
• Performed Manual testing in all projects as needed.
• Good experience working in multiple domains such as Energy services, Healthcare and Insurance.
• Worked on various Test case management and Defect tracking tools like Rational Quality Manager, Bugzilla, Jira, and Quality Center.
• High level of work commitment, good communication skills, strong team player, enthusiastic learner, confident, ability to adapt to new environment quickly,problem solving ability, analytical skills, sincere and ability to handle multiple projects within deadlines.

TECHNICAL SKILLS

QA Methodologies: Agile and Waterfall

Testing Tools: Selenium WebDriver, TestNG, Jenkins, HP Quality Center, SOAP UI

Bug Reporting: Rational Quality Manager, Bugzilla, Jira

Languages: Java, HTML, XML, SQL, P/L SQL, UNIX.

ETL Tools: Informatica PowerCenter 8.x/9.x, DVO

BI/Reporting Tools: SSRS, Cognos Report Studio, Cognos Analysis Studio, Microsoft Visual studio

Database Query Tools: Toad, SQL Developer

Databases: Oracle 12.x,11.xMicrosoft SQL Server 12.0, 13.0, MS Access, MySQL

Operating Systems: Windows, Unix

PROFESSIONAL EXPERIENCE:

Confidential - New York, NY

Sr QA Analyst

Responsibilities:

• Involved in multiple QA projects for various applications mainly used by Energy services department users and other associated Gas and Electric departments.
• Performed Manual, Automation and Database testing of different applications.
• Prepared ETL test cases based on business requirements and Mapping logic of the ETL process of Data Warehousing project.
• Executed Data validation test cases for verifying the record count, duplicates, missing data, aggregate functions and null values for ensuring data accuracy and integrity and confirm if data is loaded correctly in target tables.
• Involved in testing different Flat files like CSV files, Tab Delimited and Pipe Delimited files on daily basis and reporting issues.
• Identified and reported bottlenecks in ETL Processes.
• Reviewed Mapping Document and verified the Metadata for Source systems, Staging tables and Target tables.
• Executed test cases for source and target Database validation using Informatica Power Center and Informatica DVO.
• Performed database testing by writing and executing SQL queries.
• Reviewed various Mappings and Transformations to execute test scenarios for verifying Transformation requirements.
• Worked with Program Managers, Business Analysts, Developers, and other testers to resolve issues with requirements for mapping and transformations.
• Extensively involved in backend activities for testing several reports developed by SSRS.
• Tested different reports like Tablix, Matrix, Bar charts and Sub reports using SSRS Report Studio.
• Created and verified Drill through, Drill down, Matrix and Sub reports using MS SQL Reporting Services.
• Performed functional testing of SOAP and RESTful Web Services by using SOAP UI tool.
• Created Project, Test Suites, Test Cases and Test Steps in SOAP UI.
• Generated XML and JSON SOAP requests and validated the corresponding XML and JSON SOAP responses.
• Involved in automation testing of web applications using Selenium Web driver and Test NG.
• Assisted in Continuous Integration of automation framework with Jenkins and usedEclipse IDEto develop and debug the code.
• Performed Regression and functional testing in multiple browsers and platforms with Seleniumusingdata driven framework.
• Assisted the Test Lead in taking interviews for testing positions and training the junior testers.
• Assisted the junior QA team members in understanding the business requirements and identification of Test scenarios.
• Prepared Defect reports, and Test Summary reports.
• Participated in Triage meetings for triaging the Defects, Defect clarification and updates.

Environment: Informatica PowerCenter 9.5, Informatica Power Center DVO, SSRS, Oracle, SQL Server, Flat files, SQL, Toad, P/L SQL, XML, HTML, SOAP, JSON, Java, Eclipse, Selenium Web driver, Apache Maven, Jenkins, SOAPUI, RQM, JIRA, SharePoint, Agile, Windows.

Confidential, New York, NY

QA Analyst

Responsibilities:

• Involved in developingTest Plan,Test Strategies and Test scenarios based on Business and System requirements.
• Involved in testing applications under Agile methodology.
• Assisted in database testing by writing and executing SQL queries.
• Extracted data from databases, published reports using Cognos Reporting tool and gave access to users as per the business requirements.
• Created models defining the Metadata of the tables in database using Cognos Framework Manager to map the data of database to Cognos for creating reports.
• Involved in creating and publishing various reports using Cognos Report Studio, Query Studio and Analysis Studio.
• Created and tested various reports generated by Cognos including Dashboards, Summary Reports, Master Detailed and Drill down reports.
• Revieweddatabase test casesaccording to assigned Requirements to validate reports by retrieving data withcomplexSQL queriesfrom databases.
• Performed data accuracy, data validation and data integrity testing by querying thedatabase using SQL queries.
• Performed functional testing for Web based applications using SOAP UI tool by sending XML requests and reviewing responses.
• Inserted Assertions in SOAP messages to validate the data in the responses.
• Automated features of web applications using Selenium WebDriver with Java and TestNG.
• Executed browser compatibility and regression tests usingSelenium WebDriverfor testing UI for every new build release.
• Performed functional tests usingSelenium WebDriverwith data driven framework.
• Prepared Defect Status reports and Test Summary reports.
• Participated in weekly status meeting, triage meeting coordinating with the developers and business users assisting in defect clarification and updates.

Environment: Selenium WebDriver, TestNG, Eclipse, Cognos, Oracle, SQL, SQL Developer, JIRA, XML

Confidential -Bridgeport CT

QA Analyst

Responsibilities:

• Involved in interacting with Business users, development teams and Business Analyst to understand the business requirements, analysis and development of software testing documentation.
• Worked with development team to understand technical design and architecture for test planning.
• Analyzed User stories, reviewed Test Plans, prepared Test Cases and Test Scripts to ensure adequate coverage of all requirements.
• Worked under Waterfall methodology.
• Conducted Smoke Testing, Functional Testing, Regression Testing, Negative Testing, Integration Testing, System Testing and Database testing.
• Used Quality Center for overall Test Management, tracking, scheduling and executing tests cases and bug reporting.
• Exported requirements and test cases into the Quality Center, executed test cases from test lab and logged defects.
• Involved in reviewing the changes in business requirements and updated the Test Cases accordingly.
• Interacted with developers for all defect clarifications and updates during entire Defect lifecycle.
• Performed backend testing by writing SQL queries for data verification and validation.
• Prepared Defect reports and Test Summary reports.

Environment: Quality Center, Windows, SharePoint, MySQL.