SUMMARY:

• Around 7+ years of experience in Finance, Investment Banking, Wealth Mangement,Insurance, Healthcare and Capital Market, Mortgage Domain as a Sr QA Analyst/QA Analyst.
• Experience using ClearQuest, QuickTest Pro10.0, Jira, Quality Center 10.0, ALM.
• Experience includes testing of Client/Server and Web based applications using automated testing tools.
• Expertise in Manual and Automated Testing in different testing methodologies like Water Fall Model, Agile, Scrum Methodologies
• Experienced in various types of testing like Black box, Functional test, Integration test, System test, User Acceptance test and Regression test, Grey box End - End testing, Cross browser testing, Security Risk Testing, Mobile Testing.
• Experienced in testing Web Applications in different OS Environment (Windows, iOS, Android, Mac) and in a different browsers (IE7, IE8, IE9, FF17, FF18, FF19 and Safari in Mac)
• Experience in using Quality Center for storing test plans, test cases and test procedures and used as Bug Tracker.
• Extensive experience in building and executing Test plans, Test cases and RTM (Requirement Traceability Matrix). According to business, functional and user requirement specifications.
• Developed and Executed Automation test scripting QTP.
• Good experience in QTP - VB Script programming standards, developed reusable functional libraries which are used in different scripts.
• Exp with FACETS & Pega Claims.
• Good working experience on testing ETL. Tested the Data Completeness, Data Transformation, Data Quality, UAT, And Integration & Regression Testing for ETL.
• Knowledge in Automation frame works using Selenium WebDriver, Selenium IDE functional testing
• Proficient in SQL query and testing RDBMS such as Oracle, MySQL, SQL Server for data validation.
• Proficient in using SQL Queries using TOAD & SQL Plus to ensure data consistency of front-end and raw feed by developing and executed complex SQL queries for data base.
• Strong experience in testing ETL applications, BI Reports.
• Performed SOAP based web services using SoapUI tool to validate both request and response messages.
• Good knowledge of Java development and Involved on Selenium.
• Good Knowledge on Cucumber for writing functional test cases.
• Knowledge of networking protocols: VOIP, TCP/IP, FTP and HTTP.
• Involved in reviewing whole documentation of testing cycle.
• Possess strong Problem solving and Analytical skills with the ability to follow project standards. Ability to learn quickly and take up new tasks and responsibilities.
• Excellent team worker, good communication skills, and ability to work on multiple projects.

TECHNICAL SKILLS:

Operating Systems: Windows and UNIX

Testing Tools: QTP, Test Director, Quality Center, Jira, Clear Quest, DVO, Informatica(ETL),Visio,ALM,JIRA

Database: MS SQL Server, Oracle, Toad

Languages: C, C++, Java,PHP, C#, SQL, HTML, XML, Java Scrip and VB Script

App/Web services: HTML,XML, SoapUI, WebServices, REST API

PROFESSIONAL EXPERIENCE

Confidential

Sr ETL Test Analyst/UAT Project Support Data Analyst

Responsibilities:

• Analyzed the Requirements Definition Document (RDD) and Technical Design Documents (TDD) for designing Test Cases and Test Script.
• Communicated with Business Analysts and Developers for requirement analysis, design reviews, testing and documentation for the applications.
• Developed and Designed Test Cases based on the Business Rules and Mapping Documents.
• Validated the source data coming from various databases using complex SQL queries.
• Performed Enterprise Wide Operational Data Store (EWODS) to Online Transaction Processing (OLTP) database testing.
• Validated the load process of ETL to make sure the target tables are populated according to the data mapping provided that satisfies the transformation rules.
• Worked on ETL Data conversion and ETL Delta Load testing for domains POOL, FINANCE, ADMIN, PARTY and DOCUMENT.
• Created Test Bed data for Insert and Update testing in Source and Target Tables for Delta Load. For creating test bed data need to analyze data type, primary key, foreign key, default value, transformations for fields.
• Verified ETL extracted data for Transformation between Source and Target schema by developing SQL scripts.
• Tested End to End ETL run to performed data is flowing through all source systems like Mainframe, RFS Source systems.
• Extensively written complex SQL queries/Scripts (Joins, Union, Union all, Minus, Group By, Order By, Aliases etc.) using Oracle database to validate ETL Delta Load.
• Performed Smoke, Functional, System, Integration, End-to-End, and Regression testing for various applications.
• Verified Business Verification Reports, Operational Reports, and BOBJ Reports as Business support Analyst.
• Supported Production Parallel after Go-Live. Worked on User Manual Documents for Ops.
• Used ALM for Defect/Bug tracking and reporting, also followed up with the development team to verify bug and update bug status (retest failed, resolved etc.).
• Performed cross browser testing in I.E 10, 11, Firefox 43.0.1, Google Chrome, Safari for the application GMEP 2.0 and Platinum Pool Processing, Party UI.
• Involved on BDD framework on Cucumber and Integration with Selenium
• After completion of particular testing, reported to QA /UAT Manager/Project Manager and signoff.
• Participated everyday work status checking and defect review meeting.

Environment: Oracle SQL Developer, Java GUI, JavaScript, HP ALM 11.5, Mainframe, Informatica, JIRA v6.3, Linux 6.4, Citrix, XML, Windows 7, SOAP UI, Rest API

Confidential, Jersey City, NJ

Sr . QA Analyst/ETL Tester

Responsibilities:

• Analyzing system requirements and developed detailed Test Plan, Test Scenarios for application
• Developed test cases for different testing phases viz. - System testing, Integration testing, Backend testing, Grey box, Negative testing and Regression testing - based on the specifications mentioned in the Design document, and derived the test scenarios from the Use Cases, Use Case diagrams, flowcharts, etc.
• Created requirement traceability matrix, to ensure all the requirements are covered with test scenarios/cases.
• Involved in defect triage process by involving, Business, QA, Development teams
• Tracked, reported and assigned defects that were identified during each stage of the testing exercise. Used 'HP ALM' to assign responsibility to developers for the various defects, and did follow-up for defect resolution and updated ALM with defects status, Delivery Dates, and R&D comment as needed
• Performed the tests in both the SIT, QA and contingency/backup environments
• Involving in Functional testing, End to End testing and Regression Testing.
• Timely providing support to UAT team before going 'Go-Live'.
• Developed SQL Script (Developed complicated SQL Script in Toad) to validate data, automated UNIX based process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Involved in key learning process after each release to implement process in future as a part of QA Process Management.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Tested test scenarios that were used to validate the ETL movement
• Written complex SQL queries for validating the transformation rules for ETL mappings.
• Experience in data analysis and data testing and validate the data returned after nightly ETL (Extract, Transform and Load) runs.
• Tested the Data Completeness, Data Transformation, Data Quality, UAT, And Integration & Regression Testing for ETL.
• Worked on Informatica DVO tool for Regression Testing.
• Performed field-to-field testing between source and target data.
• Worked on multiple assignments simultaneously and lead offshore resources.

Environment: ALM, Java, Oracle 11.0, Toad, SharePoint, MS OFFICE 2010, Windows 7, Flat files, ETL Informatica, UNIX,SOAP UI, Rest API .

Confidential, New York, NY

Sr. QA Analyst/ETL Tester

Responsibilities:

• Involved in all stages of testing process - Development of Test procedures and Test cases based upon requirements for functional test, regression test, integration test, Middleware testing and user acceptance test.
• Created Project, Requirements, Test Plans and Tests in Quality Center.
• Validated the ETL Informatica scripts for data conditioning, transformation, validation and loading.
• Tested a number of complex ETL Informatica packages for initial and daily data loads
• Validation the XMLs to verify the integrity of data received from DWH system.
• Performed sanity testing using post installation check using release notes and identified installation or code initial problems.
• Communicated with Project Management to establish LOE of each phase of SDLC and prioritized QA task.
• Developed SQL Script to validate Data Transaction in Front End Testing. Developed complicated and execute via Toad and saved Test Result.
• Worked with peers in development and other organizations to troubleshoot and resolve project issues both technical and non-technical in nature.
• Performed functional testing by deployment request, sanity testing, prioritized QA Test Cases within project plan.
• Performed Defect Root Cause Analysis, interacted with related Team, and tracked defects in a Test Director.
• Performed impact analysis and executed test scenario with Regression Testing.
• Extensively involved with backend testing by writing complex SQL queries.
• Tested API using SoapUI, Restful.
• Participate in Daily Scrums to provide daily testing updates
• Created the templates for daily status reports, weekly status reports and test Metrics.
• Maintained the team spirit in off shore and onsite

Environment: HP Quality Center, Oracle 9i, SQL, TOAD, Teradata 12.0, Teradata SQL Assistant 12.0, Agile, ETL Informatica, XML, XNL Spy 2008, PuTTy, Sharepoint, WinSCP, UNIX.

Confidential, New York, NY

BA/UAT Tester

Responsibilities:

• Involved in all stages of testing process - Development of Test procedures and Test cases based upon requirements for functional test, regression test, integration test, and user acceptance test.
• Involved in testing all NYU Applications in different OS Environment and Virtual Environments (Windows, Mac,iPhone,Samsung) and in a different browsers (IE7, IE8, IE9, FF17, FF18, FF19 and Safari in Mac)
• Tested the Business Logic of the application by testing the application, also analyzed the behavior of the application login in different browsers and Networks.
• Tested Security Risk Testing on the application with different Operating Systems.
• Tested Firewall testing while implementing the VPN from Juniper to F5 on Virtual machines.
• Tested the application in different VPN like Juniper and F5.
• Created, assigned, and tracked the defects using Quality Center.
• Used SQL Queries for checking data transactions in the data base.
• Developed and Executed Automation test scripting QTP for Regression Testing.
• Prepared Test Cases for GUI application. Developed test scripts for Data driven testing using parameterization in QTP by using Excel sheet for test data and Database Queries based on the functionality.
• Automated test scripts for Regression testing. Maintained, Enhanced, and executed the scripts as needed.
• Interacted with different Development teams, Business Analysts and Project Manager.

Environment: Quality Center 9.0/10.0,Fire bug, Virtual Environments, Quick Test Professional 10.0, ASP.Net, SQL Server 2005.

Confidential, NYC, NY

QA Analyst

Responsibilities:

• Developed Test Cases from Functional Requirements Document.
• Involved in all stages of testing process - Development of Test procedures and Test cases based upon requirements for functional test, regression test, integration test, and user acceptance test.
• Validated different EDI formats and transactions. Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
• Responsible for writing programs for testing data as well as develop business enterprise data warehouse application
• Tested the entire compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
• Identifies metrics to measure quality in products and processes, PEGA logic, Facets claims test creation.
• Run claims SQL queries and generated reports for defect modifications.
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using ETL Informatica Power center.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Tested the ETL with XML as source and tables in the data warehouse as target.
• Tracked defects to closure by coordinating with the dev team.
• Analyzed EDI translation errors that failed in the inbound and re-processed the EDI's without losing the information.
• Tested source data for data completeness, data correctness and data integrity.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Enterprise Data Warehousing and Data Mart Staging Tables.
• Coordinated the end to end testing efforts of the HIPAA compliance and EDI transactions.
• Good experience in writing SQL in order to data validation in migration as part of backend testing worked with ETL group for understating mappings for dimensions and facts.
• Prepared UNIX scripts to run the Informatica ETL jobs from command line.

Environment: Data warehouse ETL Informatica 8.6, Business Objects, SQL, PL/SQL, EDI, HP Quality Center 9.2, XML, Oracle 10g, QTP, ALM, SOAP UI, JavaScript and TOAD for Oracle

Confidential, Jersey City, NJ

Manual Tester/UAT

Responsibilities:

• Developed Test Cases from Functional Requirements Document.
• Involved in writing detailed Test Plan and Test scenarios.
• Involved in all stages of testing process - Development of Test procedures and Test cases based upon requirements for Functional test, Regression test, user acceptance testing and Cross browser Testing, UI Testing.
• Logging the defects in defect tracking tool and generated defect reports on a day to-day basis using Quality Center.
• Written SQL Queries to test database.
• Interacted with different Development teams, Business Analysts and Project Manager.

Environment: Windows NT/2000/XP, Office 2003, Oracle E-Business Suite expertise, Quality Center 9.0, ASP.NET, C#, Java Script, HTML, CSS, SQL Server 2000.

Confidential, PortLand, O

QA Analyst

Responsibilities:

• Developed Test Cases from Functional Requirements Document.
• Involved in all stages of testing process - Development of Test procedures and Test cases based upon requirements for functional test, regression test, integration test, and user acceptance test.
• Logging the defects in defect tracking tool and generated defect reports using TFS.
• Involved in of testing end-to-end testing for payment system.
• Extensive experience in building and executing Test plans, Test cases and RTM (Requirement Traceability Matrix). According to business, functional and user requirement specifications.
• Performed Regression testing with QTP by executing the automation test scripts.

Environment: QTP 8.2, Jira, Oracle 9i, HTML, Java, JavaScript, JSP, DB2, XML, TFS, UNIX

Confidential, Kansas City, KS

Web Application Tester

Responsibilities:

• Written Test cases and Test Scripts from the decomposed requirements and Use cases.
• Open Defect's with help of Test Director wherever discrepancies found in the code and assigning them to development Team.
• Involved in testing all Back End processes using SQL on different servers.
• Interacted with various development Teams, QA teams, Business Analysts and Project Leaders.

Environment: SQL, HTML, Java, J2EE, Windows XP, QTP 8.2 and ClearQuest.