We provide IT Staff Augmentation Services!

Quality Analyst Resume

Denver, CO

SUMMARY:

  • Over 5+ Years of Professional Experience in Software Quality Assurance (QA) and Testing in different environments and platforms including Data Warehousing, Business Intelligence, Client/Server and Web based applications.
  • Experience in Data Warehouse applications testing using Informatica, Ab Initio, Data Stage and SSIS on multiple platforms.
  • Involved in all phases of the QA Life Cycle and SDLC, with timely Delivery against aggressive deadlines, with QA methodologies such as Waterfall, Agile, etc.
  • Experience in DBMS Utilities such as SQL, PL/SQL, TOAD, SQL Server, SQL*Loader, Teradata SQL Assistant.
  • Extensive experience in writing SQL and PL/SQL scripts to validate the databases systems and for backend database testing.
  • Expertise in using Quality Center & HP ALM for designing, writing, implementing and maintaining the Test Plans, Test Cases, Test Execution, Defect management, Bug Reporting and familiarity with other features of Quality Center and Administration.
  • Expert in writing complex SQL queries for data validation between source and target.
  • Extensive working knowledge in UNIX/Linux operating systems.
  • Experience in User Acceptance Testing, Performance Testing, GUI Testing, System & Functional Testing, Integration Testing, Regression Testing, Data Driven, Keyword driven Testing and both Manual as well as using automated testing tools including Win Runner, Load Runner.
  • Involved in front - end and back-end testing. Strong knowledge of RDBMS concepts.
  • Proficient on designing implementing basic SQL queries for QA testing and report/data validation and Solid Back End Testing experience by writing and executing SQL Queries.
  • Well versed with Unix Shell Scripting.
  • Experienced in writing complex formulas in Crystal reports, SQL queries using Crystal Designer, conversion of Crystal reports in different versions.
  • Strong knowledge of working with Data Marts (Star Schema and Snowflake Schema)

PROFESSIONAL EXPERIENCE:

Quality Analyst

Confidential

Confidential - Denver, CO

Responsibilities:

  • Responsible for Business analysis and requirements gathering.
  • Performed complex defect reports in various environments like UAT, SIT, and QA to ensure the proper delivery of the application into the production environment.
  • Developing and designing data quality test plans and manually executed ETL and BI test cases.
  • Test the data from various sources and load in the target table.
  • Using SSIS and HP ALM keep the track of defects and reopen them.
  • Used ALM for writing effective test cases and test case scenarios
  • Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
  • Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
  • Used Quality Center for defect tracking.
  • Developing and validating complex SQL queries advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
  • Testing the reports and maintenance of daily, monthly and yearly.
  • Coordinate and helped in testing the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
  • Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects
  • Involved in Confidential by checking ETL procedures/mappings.
Quality Analyst

Confidential - Atlanta, GA

Responsibilities:

  • Created Test Plan for System Testing.
  • Responsible for performing various types of process evaluations during each phase of the Software Development Life Cycle, including Review, Walk Through and hands on system testing.
  • Tested the entire 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.
  • Identify & record defects with required information for issue to be reproduced by development team.
  • Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
  • Worked on QA testing and associated methodologies and Test case management tool. Used Defect tracking software JIRA.
  • Tracking and managing defects using HP ALM 11.0.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
  • Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
  • Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
  • Tested the ETL Informatica mappings and other ETL Processes ( Confidential )
  • Written several complex SQL queries for validating Cognos Reports.
  • Used SQL for Querying the SQL server database for data validation and data conditioning.
  • Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
  • Written several shell scripts using UNIX Korn shell for file transfers and cleanup process
  • Conducted data validation testing.
  • Responsible for leading team and co-coordinating with offshore team. Developed data quality test plans and manually executed ETL and BI test cases.
  • Data verification and validation using complex SQL queries.
  • Tested the Business Objects Universe.
  • Tested the entire 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.
  • Used SQL for Querying the DB2 database in UNIX environment.
  • Worked with Data Extraction, Transformation and Loading (ETL)
  • Worked with business team to test the reports developed in Cognos.
  • Performed Unit Testing by comparing the data in OBIEE and Business Objects.
  • Tested whether the reports developed in Cognos are as per company standards.
  • Used HP Quality Center for writing the test cases and logging the defects.
  • Involved in testing the XML files and checked whether data is parsed and loaded to stag in tables.

Environment: Informatica 9.1, ALM/HP Quality Center 11.0, Teradata V2R6, BI Reports, DB2, IDQ 8.6.1, TOAD, Oracle 11g, JIRA, SQL, PL/SQL, SQL Server 2008, XML, XSLT, Autosys

ETL/BI/ QA Tester

Confidential - Alpharetta, GA

Responsibilities:

  • Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
  • 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.
  • Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
  • Used HP Quality Center 11 for managing the business requirements, test plans, test labs and test defects in System Testing.
  • Built and performed test cases for END to END testing using JIRA and SQL.
  • Tested the entire 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.
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning
  • Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
  • Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata.
  • Created defects in HP ALM and mapped them to HP ALM test cases.
  • Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
  • Executed Complex SQL queries within UNIX shell scripts in the UNIX environment.
  • 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 devlopment team.
  • Developed Test Plan and Test Cases using HP Quality Center to test the application for the new code.
  • Used HP QC- ALM as a repository for all the test case scenarios, test scripts, Defects and Test results.
  • Written several complex SQL queries for validating Cognos Reports.
  • 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.
  • Prepared test data to cover all the test scenarios.
  • Prepared UNIX scripts to run the Informatica ETL jobs from command line.
  • Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.
  • Tested the migration of reports from Business objects XIR2 to XIR3.

Environment: Informatica 8.6, SQL, PL/SQL, Teradata V2R5, HP Quality Center 10.0, IDQ, HP ALM, XML, Oracle 10g, Tibco, Business Objects XIR3, JIRA, TOAD for Oracle

ETL/QA Analyst/ DWH Tester

Confidential - Baltimore, MD

Responsibilities:

  • Responsible for Business analysis and requirements gathering.
  • Performed complex defect reports in various environments like UAT, SIT, and QA etc. to ensure the proper delivery of the application into the production environment.
  • Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
  • Expertise in SQL queries for cross verification of data.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Used SQL for Querying the DB2 database in UNIX environment.
  • Involved in extensive DATA validation using SQL queries and back-end testing.
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning.
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate.
  • Used Ab Initio to extract, transform and load data from multiple input sources like flat files, Oracle 10g database to the Teradata database.
  • Use SQL queries for Database testing and Validation.
  • Developed/Modified test graphs based on business requirements using various Ab Initio Components like Filter by Expression, Partition by Expression, reformat, join, gather, merge rollup, normalize, denormalize, replicate etc.
  • Involved in testing data mapping and conversion in a server based data warehouse.
  • Involved in testing the UI applications.
  • Created SQL Queries using SQL*Plus for dropping indexes prior to the load graph execution to be able to perform direct loads on the database tables.
  • Tested the Oracle PL/SQL testing programs.
  • Involved in prepare the documentation and manuals for User Acceptance testing.
  • Validated the Autosys jil scripts for dependencies, owner, description and other attributes.
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Ab Initio GDE 1.15, Co-Op 2.15, EME, UNIX, HP ALM, Shell Scripting, XML Files, XSD, XML Spy 2010, Oracle 10g, Quality Center 10, BEA Web Logic 8.1, Autosys, Toad, Tivoli, QTP.

ETL QA - Customer Data Mart - EDWH

Confidential - Round Rock, TX

Responsibilities:

  • Translate business-reporting requirements into data warehouse architectural designs and analyzing source and target data models and makes necessary changes.
  • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
  • Identify the primary key (logical / physical) and put update or insert logic.
  • Deleting the target data before processing based on logical or physical primary key.
  • Design and execute the test cases on the application as per company standards.
  • Preventing occurrences of multiple runs by flagging processed dates.
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Testing of records with logical delete using flags.
  • Interacting with senior peers or subject matter experts to learn more about the data.
  • Identifying duplicate records in the staging area before data gets processed.
  • Extensively written test scripts for back-end validations.
  • Ensured that the mappings are correct.
  • Extensively used Toad to verify records that has been populated by ETL process.
  • Responsible for de-duping and consolidating customer records from various sources to create master customer list.
  • Prepared and implemented data verification and testing methods for the Data Warehouse as well as to design and implement data staging methods and stress testing of ETL routines to make sure that they don't break on heavy loads.
  • Involved in performing Functionality testing, Validation testing and System testing, testing manually on the first release of the application.
  • Used Test Director as a defect-tracking tool to keep track of defects during the testing process.
  • Performed End-to-End testing after bug fixes and modifications.
  • Used Tivoli as a scheduling software to schedule the Informatica jobs.

Environment: Test Director, Informatica 7.1, SQL, XML Files, XSD, DTD, XSLT, PL/SQL, SQLPlus, UNIX Scripts, TOAD, Clear Quest, Clear Case

Quality Analyst

Confidential

Responsibilities:

  • Involved in Data Analysis and Database Designing.
  • Involved in identifying data from BRD to Develop LDM, PDM by studying Data Flow diagrams and State Transition Diagrams.
  • Used MS Visio to develop the database design.
  • Extensively involved in developing Data Dictionary.
  • Created tables and various database objects.
  • Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
  • Involved in performing validation of datasets, tables and triggers by performing White Box Testing and code walk-through.
  • Performed Data Profiling to improve search abilities by using tags and aliases.
  • Dynamically adjusted price breaks in accordance with client pricing groups and allowed editing/addition of customer information to rapidly assemble on-screen, printed and database-recorded quotes.
  • Developed test reports and participated in testing prioritization and archived test results and user signoff
  • Involve with Design and Development team to implement the requirements.
  • Performed execution of test cases manually to verify the expected results.
  • Involved in creation of tables, writing stored procedures and Triggers.
  • Developed user interface screens using VB, ADO to connect to backend and stored procedures to manipulate data.
  • Handling user defined exceptions.
  • Involved in testing, implementation & maintenance.

Environment: MS Visio, Crystal Reports 9.0, Metadata Repository, Visual Basic 6.0, SQL Server 2000, SQL, T-SQL, UNIX and Windows NT

Hire Now