* ** *

Payal Navadiya

Sr. Test Engineer/ QA Test Analyst/ Back-End Manual Tester

734-***-**** / adhebt@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 5 years of experience in Quality Assurance and Software Testing of various business applications in Client/Server environments and Data Warehousing solutions.

Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases.

Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle.

Have solid experience on database query tools such as TOAD, SQL Navigator, SQL Assistant and SQL Plus.

Excellent working knowledge to test BaNCS Consumer, Constructions, and Commercial products.

Excellent working knowledge to test BaNCS, and ODS Reports.

Excellent working knowledge to test Statements, Notices and Forms.

Excellent working knowledge to transmit Final Flat Files from BaNCS to third party vendor, to prints Statement and Notices.

Experience on FileNet, and Xnet setup.

Excellent working knowledge to get offshore status, communication, and training.

Experience on Product Support Testing.

Excellent working knowledge to write JRS Rational queries to generate reports.

Experience on UNIX commands and Shell Scripting.

Experience in authoring UNIX shell scripts for automating metadata testing.

Experienced in Functional testing, Performance testing, Load testing, Integration testing, System Testing, Regression testing, Black Box testing, Stress Testing, Smoke Testing, Recovery Testing, DWH Testing, BI Reports Testing and GUI Testing.

Strong experience in preparing documentation, preparing test environments, executing and analyzing the results.

Have experience in testing reconcile (initial) and delta (daily) loads.

Have tested several complex reports generated by Cognos, including dashboards, summary reports, master detailed, drill down and score cards.

Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports.

Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center, Clear Quest, Rational CLM, and JIRA.

Expertise in writing complex SQL queries for back-end testing.

Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.

Experience in Testing ETL, PL/SQL, UNIX batch jobs using Autosys scheduling tool.

Manually conducted Functionality and GUI testing during the various phases of the development of the application manually.

Experienced in writing and executing SQL queries to verifying Source-to-Target Mapping.

Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.

Experience in working Agile methodology environment.

Experience in On-Shore, Offshore coordination.

Experience in Banks, Healthcare, and Financial Domains.

Excellent interpersonal, communication, documentation and presentation skills. 2 of 3

TECHNICAL SKILLS:

ETL Tools Informatica Power Center 9.1/8.6/8.5/8.1/7.x, SSIS 2012 Data Stage 8.0/9.0, Ab Initio 2.13/2.15

QA Tools HP – Quality Center, Test Director, Quick Test Pro (QTP) DBMS/Query Tools TOAD, Rapid SQL, SQL Developer, SQL Navigator Languages SQL, PL/SQL, C, Java

Databases Oracle11/g/10g, SQL Server 2012/2008/2005/2000, DB2 Version Control Tools Rational Clear Case, WIN CVS Requirements Tools Doors, Rational Requisite Pro

BI / Reporting Tools IBM Cognos 8.0, Business Objects BOXI, SSRS, MicroStrategy Operating Systems Microsoft Windows – Vista, XP, 98, 2000, NT 4.0 UNIX – Sun Solaris, HP-UX

Scheduling Tools Autosys, Control M, Flux

Other Tools TextPad, CompareIT, PuTTY, WinScp, SnagIT PROFESSIONAL EXPERIENCE:

Client: Zionsban Corp., Salt Lake City, UT Jan ’17 – Mar ’20 Role: Sr. Test Engineer

Responsibilities:

Reviewed Technical design documents, FSD, BRD and setup documents discussed with BA.

Written Test plans and Test strategy documents according to the requirements.

Responsible for developing and executing test cases and test scripts based on the requirements and also responsible for creating and updating user-defined functions to meet the current business requirements.

Tested the Front-end functionality of the entire application.

Performed navigational testing, tested broken links.

Performed Black Box Testing based on the functional requirements and product specifications of the application including smoke, regression and functional testing using Quality Center.

Involved in running the Informatica workflows from Workflow Manager and verified the session logs from workflow monitor.

Involved in validating the batch processes such as PL/SQL, Informatica, UNIX Scripts scheduled using Autosys.

Performed User Acceptance Testing, GUI testing, Smoke testing, System Testing and Integration Testing.

Written several complex SQL queries for validating Reports and testing ETL jobs.

Reported defects on Quality Center and followed bug life cycle.

Involved in validating SSIS and SSRS packages according to data mapping specifications.

Validated data moving from source to target using Informatica Data Validation Option (DVO).

Involved in validating the initial loads and incremental loads according to functional specifications.

Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.

Validated Cubes, Adhoc Reports and Standard Reports built from Cognos.

Developed test cases in Excel and uploaded to Quality Center.

Used Quality Center as test management tool.

Involved in testing reports and closely worked with operations, and Release teams to resolve the production issues.

Designed test data using MS Excel sheet to test the application with positive and negative inputs.

Used Toad to run SQL queries to check data is populating as expected from tables. Environment: Informatica 9.5/9.1, DVO, IDQ, SQL, PL/SQL, Quality Center ALM, Oracle 11g, Cognos 10, SQL Server 2010, SSIS, SSRS, SSAS, Java, XML, Flat Files, UNIX, TOAD, Share point, Autosys 3 of 3

Client: Coventry Healthcare, Detroit, MI Jan ’15 – Nov’16 Role: Test Analyst / Backend Manual Tester

Responsibilities:

Developed and executed test cases based on the requirements and also responsible for creating and updating user-defined functions to meet the current business requirements.

Reviewed Technical design documents, FSD, BRD and setup documents discussed with BA and Developers to gain knowledge on the application.

Participated in Walk-through with BA’s, Developers, and Users to agree on Back logs to update status of on-going work.

Reported defects on Test Director and followed bug life cycle.

Performed Black Box Testing based on the functional requirements and product specifications of the application including smoke, regression and functional testing using Test Director.

Developed test cases in Excel and uploaded to Test Director.

Created Analysis document based on technical and setup documents send for review to BA and Team Lead.

Designed test data using MS Excel sheet to test the application with positive and negative inputs.

Performed backend testing and reviewing Database tables for updates.

Document and publish test results.

Preparation of various test documents for testing process in Test Director.

Responsible to understand and train others on the enhancements or new features developed. Environment: Windows XP, Test Director, Java, TOAD, XML, Forms and Reports, Oracle 8i, SQL, Web Application, GUI Testing, MS Office.

Contact this candidate