PROFESSIONAL SUMMARY:

• Experienced Quality Analyst with strong background in design, development, and support of databases and information products as well as data analysis / reporting / Testing.
• 8+ years of IT experience in the Analysis, Design, development, testing and Implementation of Quality Analyst solutions using Databases, Backend, SQL, Web and Client/Server applications.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back - end testing.
• Strong Functional Testing tool Quick Test Professional (QTP) and the various frameworks in QTP.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load of data from Legacy systems using Informatica.
• Well versed using UNIX commands for shell scripting.
• Testing on various methodologies for data warehouse projects and Star and Snowflake Schema
• Planned, developed and conducted unit, function, integration, data quality and UAT tests
• Expertise in Testing complex Business rules by creating mapping and various transformations using Informatics.
• Hands on experience in testing soap UI and xml web service interfaces and running basic UNIX shell scripts
• Extensive backend testing executed SQL queries on Teradata, Oracle, DB2, and Hadoop, SQL server tables in order to view successful transactions of data and for validating data.
• Experienced in working with HP ALM/Quality Center and Rational Requisite Pro and Clear Quest for Test Management and defect tracking.

PROFESSIONAL EXPERIENCE:

Confidential, Stamford, CT

Sr. Functional Tester

Responsibilities:

• Prepared the test plan, test strategy and test case documents with the help of BRD, FRS, HLD, LLD and other supporting documents.
• Wrote Test cases and SQL queries to validate the data pulled in from the Data Marts and populated.
• Generated test scripts for functional and regression tests using QTP.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Good experience in writing SQL in order to data validation in migration as part of backend testing
• Involved in preparing the Data-driven and keyword-driven frameworks in QTP for system and UAT environments and performed data comparison and functional comparison.
• Attended walkthrough meetings with the Business Analysts and DEV team to get a clear understanding of thea business and the applications being used in house.
• Validated the source data coming from various databases using complex SQL queries.
• Performed various data analysis at the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for successful creation of Data Warehouse and Data Marts.
• Execute SQL queries to perform Backend testing to ensure data validation
• Aggregated the data at source and compared with the Target to validate Transformations.
• Logged defects using HP ALM/Quality Center, linked defects with requirements and generated Defect Reports in QC.
• Performed Integration testing using QTP tool on the modules that have been tested.
• Analyzing Facts, Dimension models for data warehousing FDW in Star join schema.
• Attended daily status call with Offshore to review assigned tasks and solve any impediments.
• Extensively used SQL queries/Unix commands for data verification and backend testing.
• Used Oracle SQL developer tools for Querying source Database.
• Used Quality Center/ALM for execution, tracking and reporting for Internal High Level access and also to create reports and update bug status
• Documented and reported various bugs during the Testing process.
• Written SQL Queries to define identify and validate the code written for the data movement into the database tables, fine-tuned the queries for better performance.
• Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: HP ALM/Quality Center, MVS, SQL, PL/SQL, SQL Server, Teradata, SOAP UI, XML, QTP/UFT, Web services, Oracle, Data Quality Analyst, PL/SQL, TOAD 8.0, SQL, UNIX.

Confidential, Hartford, CT

Functional Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC)
• Extensive backend testing for the front end of the application using SQL Queries in Teradata data base.
• Written and executed the functional and regression test script using Test Script QTP.
• Reported periodic project status and updates to the QA Lead and QA Manager
• Performed Integration Testing of different modules.Logging in UNIX server for checking logs in UNIX in Production & Development environment.
• Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases
• Performed various data analysis at the source level and determined the key attributes for designing of Fact and Dimension tables using star schema for successful creation of Data Warehouse and Data Marts.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Load new or modified data into back-end SQL server database. Used Quality Center to run the test scripts and to log and track defects.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Used Quality Center for Test Management, Defect Management and save/manage the automation scripts created using QTP
• Extensively involved in Web service testing using SOAP UI. Performed backend testing by validating data between source and target by developing SQL scripts, and verifying stored procedures.
• Tested User Interface inconsistency and application functionality.Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Expertise in bug-reporting and bug-tracking using the test management tool like Clear Quest, ALM and Quality Center.
• Preparation of test data for various levels of testing. Verified the Data completeness, Data Migrations, Data transformations and Data Quality
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created Customized report using Soap UI tool for all the services.Created various stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.Validated cube and query data from the reporting system back to the source system.

Environment: SQL, PL/SQL, SOAP UI, XML, Teradata, ALM/Quality Center, DB2, SQL Server Import Export Wizard, Oracle10g, C#, SQL Server, Erwin, Windows XP, TOAD for Oracle.

Confidential, West Haven, CT

Functional Tester

Responsibilities:

• Involved in Business analysis and Requirements gathering.Data migration - Includes migration of data from legacy environment to Oracle System.
• Involved in Data Validation using SQL queries. Written complex SQL to validate the backend values with frontend
• Implemented manual testing of web services using XML Spy.Utilized Access database to collect data from multiple database sources using ODBC methods. Developed procedures for exporting information in Excel format in development server.
• Consolidated numerous scripts and revised validation logic to conform to data jobs and client data integrity requirements. Created user defined functions to dynamically validate data specific to clients.
• Processed transactions from system entry to exit. Tested functionality across applications and workflows.
• Involved in writing Test scripts for various test scenarios using QTP tool and in creation of Automation frame work.
• Validated Response with the XML Schema during web service testing.Worked with UNIX shell scripts for scheduling and running the required jobs.
• Worked with appropriate business and technology leads to determine the acceptable range for test results and performance
• Coordinated component, system testing with the appropriate technical groups and Release Management and documented test procedures and findings.
• Reconciled test results from different tests and different groups. Assessed readiness and deviation of product/project performance based upon test results and product specifications.
• Reported bugs and tracked defects using Rational Clear Quest. Involved in extensive DATA validation using SQL queries and back-end testing
• Used TOAD Software for Querying ORACLE and Used Win SQL for Querying DB2.Created critical scenarios for each change request and defect request.

Environment: QTP, SOAP UI, XML, SQL, Quality Center, Oracle 9i/10g, SQL, PL/SQL, Stored Procedures, DB2, Toad, Erwin, Congo’s, Test Plans Test Scripts, Test Cases, VSS, MS Office Suite, Informatica Power Center 8.5, Tivoli, Flat Files, XML Files

Confidential, Hartford, CT

QA tester

Responsibilities:

• Worked with Business analyst and QA manager in gathering technical and functional specification documents for reviews to understand the functionality.
• Prepared test plan and determined testing approach and time slots for task completion.
• Coordinate with other test team, define the functionalities to be tested and assigned the tasks to other team members.
• Wrote Test Cases and design test steps according to the requirements specifications in Excel.
• Maintained Requirement Traceability Matrix (RTM) to make sure that test plans were written for all the requirements.
• Exported test cases into Mercury Quality Center.Inserted Check Points to check for the broken links, Text and standard properties of an object using Quick Test Pro.
• Performed Synchronization and Tested Applications using Quick Test Pro with different sets of data.
• Created page checkpoints to test the properties and contents of the web page using Quick Test Pro.
• Checked the data flow through the front end to backend and used SQL queries, to extract the data from the database.
• Get sign off after completion all the test scenarios have been tested successfully.
• Worked with Business Analyst in UAT testing and involved in testing in Production region.
• Extensively involved in Database testing by writing SQL queries.

Environment: Oracle 9i, Toad, DB2, SQL, MS Visio, SQL Server 2003/2005, HP Quality Center, UNIX.

Confidential, Stamford, CT

QA Engineer

Responsibilities:

• Develop test plans based on BRDs and Technical Specifications.Written complex SQL queries for querying data against different data bases for data verification process.
• Preparation of technical specifications and Source to Target mappings.
• Verified the Data completeness, Data Migrations, Data transformations and Data Quality
• Written Test Plans and Test Cases on Mercury Test Director Tool.
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• Wrote SQL scripts and PL/SQL queries using TOAD and Oracle SQL Developer to query DBs and analyzed the results.
• Tested the different sources such as Flat files, Mainframes Legacy Flat Files, DB2 and Oracle to load into the Oracle data warehouse.
• Extracted data from various sources like Oracle, flat files and SQL Server.

Environment: UNIX, SQL, PL/SQL, Perl Scripting, Mercury Test Director 6.5, SQL *Loader, Oracle 9i, SQL Server 2003, Java.