SUMMARY:

• Experienced Quality Analyst with strong background in design, development, and support of databases and information products as well as data analysis / reporting / Testing.
• 3+ 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.
• Experienced in working with HP ALM/Quality Center and Rational Requisite Pro and Clear Quest for Test Management and defect tracking.
• 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 Informatica.
• 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, 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.

TECHNICAL SKILLS:

Programming: SQL, PL/SQL, Perl, VB.Script

ETL Tool: Informatica, Data stage 8.1, Ab Initio, SSIS

Reporting Tools: Business Objects XI R2/R3, IBM Cognos, SSRS, OBIEE, and Microstrategy

Database: Oracle 11i/10g/9i, SQL Server, IBM DB2, Sybase, Teradata and MS-Access

Utilities: Toad, Oracle SQL Developer, SQL Advantage, Putty, Claim Guide wire

Testing Tools: HP Quality Center/Test Director, Clear Quest, Rational Clear Case, ALM

WORK EXPERIENCE:

Confidential,San Francisco, CA

QA Analyst

Responsibilities:

• Prepared the test plan, test strategy and test case documents with the help of BRD, FRD, DSD and other supporting documents.
• Wrote Test cases and SQL queries to validate the data pulled in from the Data Marts and populated.
• Logged defects using HP ALM/Quality Center, linked defects with requirements and generated Defect Reports in QC.
• 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
• Attended walkthrough meetings with the Business Analysts and DEV team to get a clear understanding of the business and the applications being used in house.
• Identified the test requirements based on user requirements and design specifications using ALM/QC
• Validated the source data coming from various databases using complex SQL queries.
• Execute SQL queries to perform Backend testing to ensure data validation
• Customized HP QC ALM 11.0 for tracking and managing the requirements, test cases, defects dashboard, defects trend/test coverage assessment, reports by deriving quality/execution.
• Aggregated the data at source and compared with the Target to validate Transformations.
• Attended daily status call with Offshore to review assigned tasks and solve any impediments.
• 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.

QA Analyst

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.
• Logged defects using HP ALM/Quality Center, linked defects with requirements and generated Defect Reports in QC.
• 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
• Attended walkthrough meetings with the Business Analysts and DEV team to get a clear understanding of the business and the applications being used in house.
• Identified the test requirements based on user requirements and design specifications using ALM/QC
• 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
• Customized HP QC ALM 11.0 for tracking and managing the requirements, test cases, defects dashboard, defects trend/test coverage assessment, reports by deriving quality/execution.
• Aggregated the data at source and compared with the Target to validate Transformations.
• 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.