Hardik Patel CONTACT NO: 240-***-****

Email: acw103@r.postjobfree.com

PROFESSIONAL SUMMARY

Over 5+ years of cumulative Software Quality Assurance and testing experience in the area of Manual Testing, Automated Testing, Web and Client/Server based applications.

Good experience in ETL Testing and Backend Testing.

Experienced in performing different types of testing: Module, Integration, Regression, and Data Driven, Performance, Screen Navigation, Installation Testing, and E2E Testing.

Proficient in SQL and PL/SQL Programming for testing database integrity, Data Validation.

Involved in Test, debug, review & modify testing programs to ensure technical accuracy & reliability of programs.

Familiar with developing & executing software test plans and maintaining documentation of test results to assist in debugging and modification of software.

Good Exposure in Using of QTP Integrated Environment (Step Generator, Synchronization, Actions, Recovery Scenarios and Methods etc.).

Experience in writing test plans, test cases and maintaining test scripts, use cases.

Well versed with Various Testing Stages/Levels/Phases, Testing Types, Testing Techniques and Quality Work Products.

Expertise in GUI Testing, Functional Testing, Integration testing, and Automation of GUI testing.

Excellent knowledge of the quality assurance process, methodologies and Software development life cycle.

Expertise in Manual and Automated Testing.

Good Expertise in VB Script and Automation Infrastructure Development.

Involved in ETL testing using Informatica power center 8.1.1/7.1.1, Pervasive SAAS.

Strong working experience in the Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL) Informatica and Pervasive.

Advanced extensible reporting skills using SQL Server Reporting Services (SSRS)

Good experience in using testing products such as Quality Center, Rational Manager, Rational Clear Quest and Test Director.

Strong experience in XML, XSLT, XPath and XML Spy.

Experience in Waterfall and Agile Methodology process.

Good Exposure on Bug Life Cycle.

Working knowledge on Java, .Net, Oracle and SQL Server Technologies based Projects.

Good experience in writing queries in Oracle, DB2, SQL Server, Sybase.

Knowledge in BPT ( Business Process Testing)

Knowledge in UNIX Commands.

Excellent analytical skills, communication skills and work ethics.

Good Business and System analysis skills to understand the requirements and customize client applications.

Strong inclination for finishing job before project deadline.

Ability to learn new technologies quickly and effectively.

SOFTWARE EXPOSURE

Operating Systems:

MS-DOS, Windows 98, 2000, XP, Unix

Testing Tools:

Titanium, Quality Center, QTP, Win Runner, Load Runner, Test Director, Rational Test Manager, Rational Clear Quest

Software:

VB, HTML, ASP, VBScript, JAVA, JSP, Servlets, EJB, J2EE, WebServices, XML, UNIX Shell Scripting

Databases:

SQL Server, Oracle 9i, Sybase, IBM DB2, MS SQL Server 2000/2005

Data warehousing tools:

INFORMATICA POWER CENTER 8.1, Pervasive,SAAS.

Other Tools:

TOAD, RAPIDSQL, SQL Navigator, Aqua Studio.

PROFESSIONAL EXPERIENCE

NSF (National science Foundation ) July 2013 –Present

Arlington (VA)

The Grants Information Mart (GIM) Development Project will assist the National Science Foundation (NSF) by bringing data from the legacy data sources that pertain to the Grants Lifecycle – thereby providing robust reporting and analytical capabilities. The Grant Information Model (GIM) captures the various key components of the Grants lifecycle end-to-end. This effort will broaden and mature the existing data warehouse and allow stakeholders to perform data analysis/ reporting utilizing the Oracle Business Intelligence Enterprise Edition (OBIEE) tool.

Responsibilities:

Worked as a Team of 10 persons for system testing of the Research.gov.

Participated daily Scrum meetings and weekly project planning and status sessions.

Tested the OBIEE applications under the Scrum (Agile) Methodology.

Involved in creating test cases after carefully reviewing the Functional and Business specification documents

Used Rational Manager and Rational Clear Quest for writing test cases and for defect logging the defects.

Performed Functional Testing, Regression Testing, System Testing, Integration Testing, End To End and SAT Testing.

Created SQL queries for validation of data present on the tables after load, based on the business requirements.

Extensively used SQL (Inner joins, Outer Joins, sub queries) for Data validations after loading into the Tables.

Performed file level validation, detail level validation and also tested the data flown from source to target.

Involved in testing mappings using SAS.

Used SAS ETL tool to load and Extract the data.

Tested Standard, ad-hoc, Pie, Bar and graph reports and compared the results against the database by writing SQL Queries.

Tested Research.Gov and performed Positive and Negative Testing.

Performed 508 compliance testing.

Involved in reviewing the Test Plan, Test Scenario and Test Cases.

Actively participated in all phases of testing life cycle including document reviews and project status meetings.

Communicated with business Analysts to understand business requirements.

Used waterfall and Agile Methodology process.

Participated in weekly Status meetings, Coordinated with the developers to resolve the defects and close them.

Participated in Team meetings for weekly QA Testing Reviews.

Preparation of daily, weekly and monthly status reports.

Environment: SQL Server 2005/2008, Rational Manager, Clear Quest, Pervasive, SSRS reports, Java, MS –Excel, MS –Word, Windows XP, XML, IE 6, 7.

Xerox, Maryland March 2011 –July 2013

ETL/Web tester

Project Title: DMCS (Debt Management Collection System)

Project Description:

The purpose of the Debt Management Collection System (DMCS) is to support the U.S. Department of Education (the Department) in its implementation and oversight of defaulted student loans. It supports Federal Student Aid (FSA), Borrowers, and Schools in its tracking of student aid debt collections.

Responsibilities:

Worked as a Team of 14 persons for system testing of the DMCS 2 Application.

Participated daily Scrum meetings and weekly project planning and status sessions.

Tested the applications under the Scrum (Agile) Methodology.

Involved in creating test cases after carefully reviewing the Functional and Business specification documents

Used Rational Manager and Rational Clear Quest for writing test cases and for defect logging the defects.

Performed Functional Testing, Regression Testing, System Testing, Integration Testing, End To End and SAT Testing.

Created SQL queries for validation of data present on the tables after load, based on the business requirements.

Extensively used SQL (Inner joins, Outer Joins, sub queries) for Data validations after loading into the Tables.

Performed file level validation, detail level validation and also tested the data flown from source to target.

Involved in testing of Pervasive mappings using Pervasive Designer.

Used Pervasive ETL tool to load and Extract the data.

Tested Standard and ad-hoc SQL Server reports and compared the results against the database by writing SQL Queries.

Tested 3 web sites (borrower website, Partner website, FSA website) and performed Positive and Negative Testing.

Performed 508 compliance testing.

Involved in reviewing the Test Plan, Test Scenario and Test Cases.

Actively participated in all phases of testing life cycle including document reviews and project status meetings.

Communicated with business Analysts to understand business requirements.

Used waterfall and Agile Methodology process.

Participated in weekly Status meetings, Coordinated with the developers to resolve the defects and close them.

Participated in Team meetings for weekly QA Testing Reviews.

Preparation of daily, weekly and monthly status reports.

Environment: SQL Server 2005/2008, Rational Manager, Clear Quest, Pervasive, SSRS reports, Java, MS –Excel, MS –Word, Windows XP, XML, IE 6, 7.

JP Morgan chase Houston, TX Jan 2010 – Feb 2011

ETL / Web tester

Project Title: Order Tracking System

Description: : Capital Funding System, JPMCHASE Retail Services, Student Mortgage, JPMC Risk Management Repository (JRMR), Delta Loads, Customer Life Cycle Mgmt and Splits & Joins etc. Tested on-boarding data from various lines of Business of JPMCHASE like Credit Cards

Responsibilities:

Used Quality Center (QC) for writing test cases and for logging the defects.

Involved in creating test cases after carefully reviewing the Functional and Business specification documents

Designed and developed Functional test cases, User Interface test cases.

Created and executed manual test cases using Quality Center and also reviewed test cases developed by other testers.

Participated in weekly status meeting, coordinated with the developers and business analysts to resolve the defects and close them.

Performed Functional Testing, Black Box Testing, Regression Testing and End2 End testing of the application.

Involved in Regression Testing using Quick Test Pro.

Involved in testing of Informatica mappings using Informatica Designer.

Extensively used internal tool for XML validation.

Involved in Backend testing to verify data integrity using SQL.

Functional, Regression test scripts executed using QTP scripts.

Involved in execution on UNIX batch jobs

Responsible for Database testing using SQL.

Fine Tuning of SQL Statements to improve the database performance.

Tested the data and data integrity among various sources and targets.

Performed End-to-End testing and backend testing using SQL queries

Extensively used Informatica Designer, Workflow manager to check the mapping and session, work flow validations.

Performed the web service testing using the development tool and verified the correct data sending and receiving through SOAP envelop messages in the XML format.

Responsible for writing test cases, test plans planning and organized the testing process, and build test cycle, test execution, and track defects.

Participated in weekly Status meetings, Coordinated with the developers to resolve the defects and close them.

Involved in all the phases in a QA life cycle.

Participated in Team meetings for weekly QA Testing Reviews.

Environment: Mercury Quality Center, IE, QTP, Citrix, QTP 9.0, Informatica Power Center 7.11, MS-Office, Excel, TCP/IP, Oracle, Sql Server and Windows XP

Bank of Marin Jan-2009– Dec 2010

Web tester

Project Description - Bank of marine offers a broad range of deposit products, commercial and personal loans, cash management solutions, and wealth management services. The project was to incorporate customer resources into the web portal including online banking, financial education and tools, calculator, privacy policy, service forms, faq, funding account, service forms With the help of this tools customer can find out the information about the financial service such as wealth management, investment management.

Responsibilities:

Tested the applications under the Scrum (Agile) Methodology.

Involved in creating test cases after carefully reviewing the Functional and Business specification documents

Used Rational Manager and Rational Clear Quest for writing test cases and for defect logging the defects.

Performed Functional Testing, Regression Testing, System Testing, Integration Testing, End To End and SAT Testing.

Created SQL queries for validation of data present on the tables after load, based on the business requirements.

Involved in Backend testing to verify data integrity using SQL.

Functional, Regression test scripts executed using QTP scripts.

Involved in execution on UNIX batch jobs

Responsible for Database testing using SQL.

Fine Tuning of SQL Statements to improve the database performance.

Tested the data and data integrity among various sources and targets.

Performed End-to-End testing and backend testing using SQL queries.

Performed the web service testing using the development tool and verified the correct data sending and receiving through SOAP envelop messages in the XML format.

Responsible for writing test cases, test plans planning and organized the testing process, and build test cycle, test execution, and track defects.

Participated in weekly Status meetings, Coordinated with the developers to resolve the defects and close them.

Involved in all the phases in a QA life cycle.

Participated in Team meetings for weekly QA Testing Reviews.

Education - MBA-Finance Dowling College (New York)

US Citizen

Currently working on getting my certification in oracle

Public trust clearance.

-

Contact this candidate