PROFESSIONAL SUMMARY:

• Over 15+ years of IT experience as QA Analyst/Backend/ETL Tester/QA Tester/BI Tester
• Expert in Designing & Developing of Test Plans, Test Scenarios & Test Cases and Execution of Test cases
• Strong knowledge and experience in SQL with ability to write complex SQL queries which can combine data from multiple tables.
• Expert in Waterfall Lifecycle, AGILE, Scrum project SDLC methodologies
• Worked as a Lead QA to guide QA team (Onsite/Offshore) & coordinate with project team (Developers, BAs, PMs)
• Worked as a Project Coordinator for multiple projects to communicate data flows, impact of requirement changes, scope of the testing, End to End Testing
• Worked on e - Commerce end to end testing.
• Worked Closely with Users for UAT
• Excellent experience in RDBMS technologies like Oracle, DB2 MS SQL Server, Teradata, dbase, Excel and MYSQL. SQL Developer, TOAD, DB2.
• Extensively used SQL, PL/SQL to create complex queries, SQL Stored Procedures, Triggers.
• Expert in setting up Test environments which includes Configuration, data, builds and batch job installation & execution.
• Expert in Unit testing, Integration testing, System Testing, Regression Testing, GUI Testing, Performance Testing, Load Testing, Stress Testing, Smoke Testing, Functional Testing, End to End Testing, Backend Testing, Complex Calculation Testing.
• Collected data via Query/400 SQL, and OS/400 commands for destructive testing of new and updated programs for data integrity.
• Created Excel reports from DB2 files from AS/400's and Mainframes.
• Proficient in using test automation tool Selenium suite to develop automation testing scripts for web and client server applications
• Sound knowledge on TestNG Framework, Maven build tool, Git hub for code checking, Jenkins for Continuous Integration
• Experience in Data driven, Keyword driven, Hybrid Automation, Behavior Driven frameworks in Selenium
• Expertise in automating Rest protocols using HTTP Client, good working experience on POSTMAN for testing and validating various web services used in the application.
• Expertise in using open source bug tracking tool JIRA, Quality Center, BugZilla & IBM Rational Team Concert
• Used Excel extensively to test Complex Calculations.
• Expertise in presenting and conducting UAT’s with Business team
• Extensive working knowledge on QTP, Selenium for automation requirements.
• Participation of Defect Review Meeting with business & IT team
• Strong knowledge of programming language C/C++, OOP’s concepts Encapsulation, Polymorphism, Inheritance, Virtual Functions.
• Ability to debug the code written in C/C++ languages.
• Strong trouble shooting, learning and problem-solving skills with ability to work independently and as a team member, team lead.

TECHNICAL SKILLS:

Operating Systems: Windows 12, UNIX (Sun, AIX, HP), and MS DOS

Languages: C, C++, Visual C++, SQL and PL/SQL JAVA, HTML, XML, Json, PL/SQL

Web Technologies: HTML, XML, CSS, DHTML, Angular JS, Node.JS

Database: IBM DB2, Oracle12, SQL Server 2000, and MS- access

Testing Tools: Selenium IDE/RC/WebDriver/GRID, Cucumber, QTP

Utilities: Toad, Citrix server, Oracle SQL Developer, DB Visualizer, PuttyVPN and Ipswich WS FTP 12, AWS UltraEdit, Confidential Compare 3

QA: DataStage 8, Informatica 8.6.1, 9.0, Ab Initio, DMExpress

Reporting Tools: Business Objects Xi R2, Cognos 8

Scheduling: TWS

PROJECT EXPERIENCE:

Confidential, NJ

Sr.QA Analyst

Responsibilities:

• Worked as a Lead QA to guide QA team onsite/Offshore for multiple projects parallelly
• Worked as a Project Coordinator for multiple projects to communicate data flows, Impact of requirement changes, scope of the testing
• Reviewed the business requirements for QA process and worked with team for gaps found during the review.
• Designed & Created Test Cases based on the Business requirements.
• Worked on Agile, attended Standups/Sprint planning meetings.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Created Requirement Traceability Matrix for various projects.
• Worked on e-Commerce end to end testing
• Worked with Android, iPhone mobile testing
• Worked with Automation team to design automation test Scripts.
• Validated complex Calculations using Excel & SQL Queries.
• Responsible to verify data completeness, data transformation, data quality, unit testing, integration testing, Interface testing, regression testing.
• Created test data required for multiple projects like Allocation, eCom Replenishment .
• Validated the design meets requirements and function according to technical and functional specifications.
• Worked Closely with Users for UAT
• Performed monitoring of the QA jobs (Extraction, Transformation and Loading) in AS400, JDA Robot Jobs, Checked DATA QUEUE in JDA , Promoted Mods to Dev to QA & QA to UAT environments.
• Worked with planning applications that used .NET applications and JDA programs.
• Explained the problems and challenging issues in each phase in detail .
• Tested data via Query/400 SQL, and OS/400 commands against DB2 files for destructive testing of new and updated programs for data integrity.
• Performed functional, regression, and some stress testing on Java/J2EE Web Applications, .Net application and SQL Database.
• Written several complex SQL queries for data verification and data quality checks.
• Used Rational Team Concert (RTC) (CCM/RQM/QM),Jira to state requirements, business components, test cases, and test runs for every iterations, defects.
• Performed data warehouse validation of source to target transformations using SQL queries.
• Performed functional, regression, integration, performance and system tests on new Java/J2EE , .NET Desktop , web applications, Web Services and enhancements to existing applications.
• Developed a detailed Test Plan, Test strategy, Test Summary Report based on Business requirements specifications.
• Developed Strategies for Data Analysis and Data Validation.
• Validated data flow from different system/Applications using complex queries (left outer Joins, sub queries etc).

Environment: AS/400, OS/400, JDA, Web/Desktop .Net Applications, TOAD for Oracle 12.1, TOAD for DB2 10.5, SQL Developer, DB Visualizer, Rational Tools, Jira, MS Teams, ATG (Oracle Commerce)

Confidential, PA

Sr. ETL Tester

Responsibilities:

• Reviewed the business requirements for Data Warehouse QA process and working with business and requirements team for gaps found during the review.
• Designed & Created Test Cases based on the Business requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Created Requirement Traceability Matrix for various projects.
• Performed complex data validation using SQL queries.
• Responsible to verify data completeness, data transformation, data quality, unit testing, integration testing, Interface testing, UAT & regression testing.
• Created test data required for new project excommunication (eRegistry, eInquiry).
• Validated the design meets requirements and function according to technical and functional specifications.
• Performed monitoring of the QA jobs (Extraction, Transformation and Loading) with the help of DMExpress.
• Reported by eCommerce platform, you can easily move product information from Retail STAR to that platform to populate your web site .
• Experienced in DWH, BI and Analytics in eCommerce, with Marketing Life Cycl e.
• Explained the problems and challenging issues in each phase in detail and provide a general approach and guideline to web usage mining and business intelligence reporting for ecommerce.
• Performed functional, regression, and some stress testing on Java/J2EE Web Applications, Web Services, Middleware, Single Sing-On, Messaging, and SQL Database.
• Performed functional, regression, integration, performance and system tests on new Java/J2EE and .NET web applications, Web Services and enhancements to existing applications.
• Written several complex SQL queries for data verification and data quality checks.
• Used HP Quality Center 9.2 to state requirements, business components, test cases, and test runs for every iterations, defects.
• Used TOAD & SQL Developer GUI tools for Querying Database.
• Developed a detailed Test Plan, Test strategy, Test Data Management Plan, Test Summary Report based on Business requirements specifications.
• Executed DMExpress jobs to test the QA processes.
• Developed Strategies for Data Analysis and Data Validation.
• Involved in preparing Test plan for the needs of the business segment for the ICD-10
• Enterprise testing efforts implantation in Insurance Solutions Data Warehouse(ISDW)

Environment: DMExpress 6.7, AS/400, OS/400, JDA, Web Application, Oracle 10g, TOAD for DB2 4.7, SQL Developer, IBM DB2 8.1, UNIX, HP Quality Center 10.0, TWS, Confidential Compare, Ipswitch WS FTP 12, UltraEdit 17.1

Confidential, Atlanta, GA

Sr.QA/ QA Analyst

Responsibilities:

• Reviewed the business requirements for Data Warehouse QA process and working with business and requirements team for gaps found during the review.
• Designed & Created Test Cases based on the Business requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Created Requirement Traceability Matrix for various projects.
• Performed complex data validation using SQL queries.
• Responsible for testing packages using SSIS (QA) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Validated the design meets requirements and function according to technical and functional specifications.
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files and Oracle to load into the Teradata data warehouse.
• Performed monitoring of the QA jobs (Extraction, Transformation and Loading) with the help of Informatica.
• Used SQL and Query/400 commands, to run ad hoc reports and inquiries on demand for multiple purposes including assisting QA testing of RPG ILE programs.
• Written several complex SQL queries for data verification and data quality checks.
• Used HP Quality Center 9.2 to state requirements, business components, test cases, and test runs for every iterations, defects.
• Performed data warehouse validation of source to target transformations using SQL queries.
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Automating the manual test cases using QTP scripts for regression testing.
• Developed a detailed Test Plan, Test strategy, Test Data Management Plan, Test Summary Report based on Business requirements specifications.
• Wrote extensive SQL and PL/SQL scripts to test the QA flow.
• Executed Informatica workflows to test the QA processes.
• And besides, this is the same as the transaction ID stored in the ecommerce data.
• Making well-designed data warehouse would feed business with the right information at the right time in order to make the right decisions in ecommerce environments.
• Developed Strategies for Data Analysis and Data Validation.
• Used the Informatica Designer to develop various workflows for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Involved in DATA validation using SQL queries and back-end testing.
• Validated data flow from Source through to FACT tables and Dimension tables using complex queries (left outer Joins, sub queries etc).
• Validated FK failures and data integrity checks for all the tables.

Environment: Informatica 8.6.1, Oracle 10g, Query/400, SQL/400, TOAD for oracle, SQL Developer, IBM DB2 8.1, Sybase 12.5, UNIX, HP Quality Center 10.0, AutoSys Jobs, Micro Strategy

Confidential, New York, NY

QA/Analyst

Responsibilities:

• Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse as part of EDW Project.
• Well exposed to SDLC (Software Development Life Cycle) and Test methodologies.
• Configured the QA Environment for Manual Testing as well as Automation through AutoSys.
• Designed and created the Microsoft Visio diagram which represents the workflow and execution process of all the process in the reinsurance world.
• Integration of mainframe and Unix environments in Data warehousing
• As a Test Lead involved in gathering System and Business requirements, studying and coordinated with the Development and Business teams to prepare Test Plans and Execution Plans.
• Involved in Database testing by writing & executing SQL & PLSQL queries using TOAD to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.
• Worked as QA Tester responsible for the requirements / QA Analysis, QA Testing and designing of the flow and the logic for the Data warehouse project.
• Extensively worked on handling the application response for Positive and Negative sets of data using data driven testing.
• Also, manually tested the application for each system build, for both negative and positive testing.
• Tested complex objects to the universe to enhance the report functionality.
• Tested ad hoc and canned reports for Business objects.
• Coordinate Test Data Preparation with business users covering all necessary features for securities.
• Tested Business Objects reports and Web Intelligence reports.
• Tested the QA process for both before data validation and after data validation process. Tested the messages published by QA tool and data loaded into various databases.
• Generated tractability Matrices to ensure that all the requirements are covered by the test cases.
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing. Performed unit testing, integrated testing and validated results with Business Analyst and/or customer.
• Involved in FTP process to transfer the files from one server to other.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Utilized HP Quality Center for Tracking and Reporting Defects, which are assigned to developers. Designed, developed and executed Test Plans, Test Scripts and Test Cases in HP Quality Center.
• Providing testing inputs to the Project team (Project manager, Planner and the Development lead) during the Planning sessions to finalize the Work Breakdown structure (WBS).
• Participated in Daily and weekly status meeting with team members and coordinated with teams for the progress of the work done in application.

Environment: Informatica 8.6.1, Web Application, Business Objects XIR3, SQL, PL/SQL, SQL Server 2008, Unix Shell Scripting, TOAD 9.2, Teradata, Oracle 10g, HP Quality Center, Autosys, Microsoft Visio

Confidential, Williamsville, NY

QA Engineer

Responsibilities:

• Analyze business requirements (e.g., business logic, Process specs, process flows). Developed test plans and test cases based on the business requirements.
• Writing the test scenarios based on business requirements and Business use cases
• Developed a detailed Test Plan & Test strategy based on Business requirements specifications
• Responsible for Backend testing with TOAD by comparing the Changes in the frontend FACETS 4.5.
• Validated QA Workflows for Parameter.
• Experienced with automated software testing tools Quick Test Professional (QTP), WinRunner.
• Involved in using complex SQL/Joins to query the FACETS Database.
• Used various SQL queries to validate the test case results for back-end test cases. Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Tested various jobs and performed data loads and transformations using different stages of DataStage and pre-built routines, functions and macros.
• Tested DataStage jobs to allow portability and flexibility during runtime.
• Tested Datastage Hashed files for extracting and write data to an intermediate file in a job.
• Extensively worked on Facets database tables such as NCA APPS PROCESS INFO table, CMC GRGR GROUP,CMC CSPI CS PLAN,CMC SBSB SUBSC,CMC MEME MEMBER,CMC SBAD ADDR,CMC MEPE PRCS ELIG,NCA SBSE SUB ELIGIBILITY,NCA GREL GROUP ELIGIBILITY and NCA APPS PROCESS INFO.
• Extensively validated different QA workflows such wkflw UT07 PARAMETER CREATE, wkflw UT07D ARG MEMBERS, s m ARGD MBR 02A MOVE CURR TO PREV.
• Analysis, Project planning, Status reporting, document review and defect entry verification.
• Written & execution of Test Cases for each functionality based on interfaces that interacting with workflow application.

Environment: DataStage, Windows XP, Oracle10G, Sybase, TOAD for oracle, UNIX, Reflections, Mercury Quality Center, PVCS (Dimensions), MS Project, FACETS 4.3, FACETS 4.5, NCA Main Frame for CA7 Job Scheduler.

Confidential, Hartford, CT

QA Engineer

Responsibilities:

• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data and Traceability Matrix.
• Conducted Functional, GUI, Regression and User-Acceptance (UAT) testing
• Developed XML test files based on XML schema.
• Generated XML data files using XML Spy.
• Validated the Web Services (SOAP), both Request and Response messages.
• Tested the Source and Target databases and QA process.
• Developed Test Cases and Test Design using Quality Center.
• Automated the scripts using QTP by developing VB scripts.
• Developed functions in QTP.
• Build up SQL queries to get data from both source and destination and to compare them in the test bed.
• Performance testing full charge for backend/supporting infrastructure (network clouds) for in-vehicle navigational systems. i.e. web services, message queue, batch services, customer facing web application and web site.
• Worked with SQL, PL/SQL and functions to test the database integrity (Oracle).
• Created Traceability between Requirements and Test Cases.
• Conducted Data Driven testing to test various sets of data.
• Worked with UNIX Shell Scripts.
• Tracked the defects using Test Director and generated defect summary reports.
• Maintained Test Logs, Test Summary reports and participated in defect review / Status / GO-NOGO Meetings.
• Configuration management / Version control was done using Rational Clear Case.

Environment: Mercury Tools, QTP 8.0, VB.NET, ASP.NET, IIS, XML, SOAP, Windows XP, SQL Server, Mainframes (DB2, JCL, CICS), MS-Office.