SUMMARY

• Over 7+ years of IT experience in QA testing with extensive ETL, BI, and Web based, Client/server, Middleware and Applications.
• Experience in defining Testing Methodologies, creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development.
• Experience in all phases of Software Development life cycle such as Agile, Scrum, Waterfall
• Tested integrated software (SOAP Web Services using SOAP UI)
• In depth technical knowledge and understanding of Data Validations, SQL Server, Oracle
• Experience in database testing with SQL queries to verify data integrity using QTP.
• Good experience in test planning, writing test cases/scripts, test case Automation and test execution.
• Extensive knowledge in regression testing and design documentation.
• Extensive experience in writing SQL to validate the database systems and for backend database testing.
• Good experience in data sources, data profiling, data validation, developing low - level design patterns based on the business and functional requirements.
• Good experience in API Web Services testing using Parasoft SOATest tool.
• Experience in the XML validation against XSD using XMLSPY
• Developed Test Cases for Deployment Verification, ETL Data Validation and Report testing
• Extensively used Informatica power center for extraction, transformation and loading process.
• Well Versed with System testing, Integration testing, Performance testing, Functional testing, Regression testing and User Acceptance Testing.
• Responsible for execution of Batch jobs and population test data for other teams
• Worked with defect tracking software as bugzilla, JIRA.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• Worked with Functional /Testing tools as QTP, Quality Center, Rational ClearQuest
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Excellent Communication, Analytical and Interpersonal skills.

TECHNICAL SKILLS

Database: Oracle 11g/10g, SQL Server 2005/2008, My SQL 5.6

Change Mgt Tools: Quality Center 11/10/9.2/8.2 , Rational Clear Quest

Functional Test Tools: UFT 12.02, Quick Test Pro 8.2/8.0, Load Runner 8.0

Languages: Java 1.6, PL/SQL, SQL, Shell Scripting, VB5.0/6.0, SQL*Plus

Data Warehouse Tools: Informatica 8.6/8.1, Data Stage 8.1

Reporting Tools: Cognos, Business Objects, Crystal Reports

Office Tools: MS Office Suite, Microsoft Share Point

Operating System: UNIX, LINUX, Windows

Tools: TOAD 9.2, 11.6, SOAP UI, XMLSPY, Bugzilla, JIRA, SOA Test 9.8, Visio

Web Technologies: XML, HTML, SOAP 1.1, Web Services, WSDL, XSD

PROFESSIONAL EXPERIENCE

Confidential, WI

Sr. ETL QA Tester

Responsibilities:

• Functional test case planning and test case creation using ALM.
• Participating in business discussions with business, product owner, BA and Tech lead to define test requirements and to provide test estimations to satisfy the business objectives.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica
• Involved in writing Test scenarios, positive and negative test cases for ETL also Preparing ETL and SQL routines/code for performing ETL testing (system and integration testing) and documenting the test results
• Automated manual test cases using Apex and Selenium.
• Coordinate, analyze and resolution of technical issues with scrum master, developer and reporting manager in a timely manner.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Wrote SQL queries to validate that actual test results match with expected results
• Writing complex SQL queries using Case Logic, Joins, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Expert in System, Regression, Integration and UAT Testing using UFT.
• Extensively worked on Toad, in order to write SQL queries, stored procedures, file comparisons, etc.
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.
• Ran workflows created in Informatics by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Extensively written test scripts for backend and frontend validations, testing.
• Extraction of test data from tables and loading of data into SQL tables.
• Developed and executed formal test plans to ensure the delivery of quality software applications.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Created automating Scripts with QTP using VB scripts.
• Created and executed Test scripts for system validation and user acceptance testing (UAT)
• Created SOAP UI Projects using the WSDL files and created Test cases, run them, do load testing, security testing.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Logged the defects in the JIRA
• Written several complex SQL queries for validating Reports.
• Created the functional requirements and Use Cases as per the SRS in the ALM Quality Center and mapped test cases to the associated requirement specifications and/or Use Case to fulfill traceability matrix for the successful coverage of the requirements.
• Manually performed Functional testing, System testing, Regression testing, and Smoke testing.
• Interacted with developers to review the defects throughout the defect lifecycle from defect report to defect closures.
• Did extensive backend testing using SQL queries in the Oracle DB.

Environment: Jira, ETL Informatica, SQL, PL/SQL, XML, XSD, XSLT, Shell Scripting, HP ALM 11.0, ParaSoft SOATest, SOAP UI, Teradata SQL Assistant, Teradata V2R6, QTP, UFT, XMLSPY, TOAD 10.6, ORACLE 11 g

Confidential, Irvine

Sr. ETL QA Tester

Responsibilities:

• Functional test case planning and test case creation using HP ALM Quality Center.
• Created the functional requirements and Use Cases as per the SRS in the HP ALM Quality Center and mapped test cases to the associated requirement specifications and/or Use Case to fulfill traceability matrix for the successful coverage of the requirements.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Performed smoke, regression, integration and functional testing using UFT.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Tested all the 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.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Tested the XMLs feeds received from another source, which is a third party for data consistency.
• 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.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Conducted and coordinated integration testing and regression testing.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Tested the ETL Informatica mappings and other ETL Processes (DW Testing).
• Performed the API Web Services testing using Parasoft SOATest tool.
• Performed the XML validation against XSD using XMLSPY.
• Performed the Integration Testing to verify the payload is sent and received correctly between the downstream and upstream applications.
• Performed Security testing. Validated various security certificates by installing the certificates in the different browsers.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Verified the certificate authentication in the LDAP (Lightweight Directory Access Protocol) server configuration for each certificate to meet the privileges during the client login.
• Good working knowledge of Service Oriented Architecture.
• Performed cross-system consistency checks while doing the integration testing where data pay load received or send to the Upstream and/or downstream applications and validated the data integrity by writing effective SQL statements.
• Prepared Test Data and performed Positive and Negative testing.
• Manually performed Functional testing, System testing, Regression testing, and Smoke testing.
• Identified the defects and logged in the in HP Quality Center Defect Module and for tracking.
• Performed Regression testing when changes such as enhancements, patches have been made.

Environment: Informatica 8.6, SQL, PL/SQL, XML, XSD, XSLT, Shell Scripting, HP ALM 11.0, Black Box testing, JMETER, ParaSoft SOATest, Teradata SQL Assistant, Teradata V2R6, SOAP UI, QTP, UFT, XMLSPY, TOAD 10.6, ORACLE 11 g

Confidential, CA

ETL QA Tester

Responsibilities:

• Worked in an agile technology through the software development life cycle
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Created Test plan, Test Design, Test scripts and responsible for implementation of Test cases as Manual test scripts in Team Foundation server HP Quality Center
• Performed Functionality, Stress, Security, and UI & Regression testing of web-based applications.
• Tested SQL queries, PL/SQL scripts to validate the data and performance of the database
• Performed SOA / Web Service testing using SOAP UI
• Experience in loading from various data sources like Teradata, Oracle,Fixed Width and Delimited Flat Files.
• Validated XML file against related XSD schema files using XMLSPY.
• Prepared the guides for UAT and written test cases for UAT
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Worked on the Functional and Integration testing
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
• Reviewed Informatica mappings and test cases before delivering to Client..
• Executed sessions and batches in Informatica and tracked the log file for failed sessions
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Extensively involved with backend testing by writing complex SQL queries.
• To verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Involved in testing the UI applications.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Created test data for both positive and negative scenarios.
• Developed and executed formal test plans to ensure the delivery of quality software applications.
• Debugging the SQL-Statements and stored procedures for various business scenarios.

Environment: Oracle 10.2, PL/SQL MySQL 5.0, Teradata SQL Assistant, Teradata V2R6,Quality Center 10, SQL, Perl, TOAD, Flat Files, UNIX, SOAP UI, SOAP1.1, WSDL, XSD, XML, XMLSPY, TOAD 10.6,HTML, Informatica

Confidential, Irvine, CA

Data warehouse Test Analyst

Responsibilities:

• Analyzed business requirements, system requirements, and data mapping requirement specifications interacting with client, developers and QA team.
• Executed the Batch job in Autosys and validated the data.
• Tested SQL queries, PL/SQL scripts to validate the data and performance of the database.
• Created SOAP UI Projects using the WSDL files and created Test cases, run them, do load testing, security testing.
• Validated XML file against related XSD schema files using XMLSPY.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing.
• Used Quality Center to track and report system defects
• To verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Experience with Autosys job scheduler including jil scripting, virtual machines and custom calendars.
• Developed JIL’s for autosys for job settings and job scheduling.
• Extensively used AUTOSYS to schedule the jobs and run the scheduled jobs at specific time.
• Involved in testing the UI applications.
• Extensively involved with backend testing by writing complex SQL queries.
• Testing of records with logical delete using flags.

Environment: XSD, XML, XMLSPY, Oracle 10.2, MS SQL SERVER 2005/2008, Cognos 8 BI Cognos Connection, Query Studio, Oracle 10g, MySQL 5.0, Windows 2007, SQL Server 2008, SOAP1.1, Quality Center 10/9.2, Agile, SQL, Perl, TOAD, Flat Files, UNIX Shell Scripting, Informatica