PROFESSIONAL SUMMARY:

• Over 10 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, Rancho Cordova, CA

Sr. QA Analyst

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
• Ran workflows created in Informatics by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• 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.
• 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, QTP 10.0, XMLSPY, TOAD 10.6, ORACLE 11 g

Confidential, Folsom, CA

Sr. QA Analyst

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.
• 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.
• Good working knowledge of Service Oriented Architecture.
• Did extensive backend testing using SQL queries in the Oracle DB.
• 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.
• Participated as a key member with the Testing Team for Regression testing where day-to-day bugs were monitored.
• Created automating Scripts with QTP using VB scripts.
• Interacted with developers to review the defects throughout the defect lifecycle from defect report to defect closures.
• Daily and Weekly Status reports were updates to the Team Lead, Test Groups and Test Managers to co-ordinate test cycles.

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

Confidential, CA

QA Analyst/ ETL Datawarehouse 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
• 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 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
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• 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.
• Extensively written test scripts for backend and frontend validations, testing.
• Extraction of test data from tables and loading of data into SQL tables.
• Logged the defects in the Quality center
• Written several complex SQL queries for validating Reports.
• Writing Sub Queries to retrieve data from multiple tables and used indexes efficiently.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Used Mercury Quality Center to document issues found during the test automation process, suggested

Environment: Oracle 10.2, PL/SQL MySQL 5.0, 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

Datawarehouse 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.
• Extensively tested several Business Objects Reports to validate the reports, the data and cosmetics of the report.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Managed and executed the test process, using Agile Methodology
• Created and executed Test scripts for system validation and user acceptance testing (UAT)
• Written several UNIX scripts for invoking data reconciliation
• Used Mercury Quality Center to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team
• Performed the data validation once the Batch Job execution is completed
• Involved in rigorous meetings with offshore testing team and DWH Lead to plan and implement the testing efforts.
• 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

Confidential, New Jersey

Quality Assurance Analyst/ ETL Datawarehouse Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation.
• Managed and executed the test process, using Agile Methodology
• Did database backup and recovery mechanism using PERL
• Reviewed Informatica mappings and test cases before delivering to Client..
• Loaded the data into the Teradata database using Load utilities like (Fast Export, FastLoad, MultiLoad).
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Experienced in writing Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• Extensively worked with defect tracking software as bugzilla, JIRA
• Extensively used Informatica power center for extraction, transformation and loading process.
• Data Integration testing for products, Reference Data and Customer master data management (MDM)
• Executed sessions and batches in Informatica and tracked the log file for failed sessions.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Validated XML file against related XSD schema files using XMLSPY.
• Extensively involved with backend testing by writing complex SQL queries.

Environment: Informatica 8, Teradata 12, Teradata SQL Assistant, Oracle 10g, XML, XSD, XML Spy TOAD, UNIX, Schell Scripting