We provide IT Staff Augmentation Services!

Qa/ba Analyst Resume

3.00/5 (Submit Your Rating)

Mc Lean, VA

SUMMARY

  • Over 7 years of experience in IT as Quality Assurance Analyst. Proficient in Manual/Automation Testing of Client/Server and Web based applications using Mercury Interactive Test Suite - Test Director, Win Runner, Quick Test Pro and Load Runner.
  • Domain competency includes finance, Mortgage and Insurance sectors.
  • Expertise in writing Test Plans, Test Strategies, Test Cases, Test Scripts, Test Scenarios, Test Reports and Defect Metrics.
  • Involved in various stages of Software Development Life Cycle (SDLC) implementing Waterfall, V-Model and Agile methodologies.
  • Strong understanding of QA Principles, QA Process, Use Cases, and Software Development Life Cycle.
  • Used Test Director for test documentation management and defect tracking.
  • Extensive experience in developing Test Procedures and Test Strategy for Web and Client/Server applications.
  • Sound knowledge of Black Box, White Box, System, Regression, Integration, Functionality and User Acceptance Testing.
  • Experience in testing on enterprise wide applications with multiple databases.
  • Proven experience with the development, and implementation of large-scale, enterprise data warehouse and reporting solutions.
  • Extensive experience in Test Director 7.2, Clear Quest, Clearcase and Remedy.
  • Good Knowledge of Workflow Manager and Workflow Monitor in Informatica 8.6.1/7.1.2.
  • Experience in Business Intelligence in generating various reports using business Intelligence tool Business Objects XI R2/XI/6.5.
  • Interacted with the developers on various technical issues and resolved the reported bugs.
  • Excellent understanding of the Software Development Life Cycle and role of QA.
  • Extensive experience performing ETL/Data warehouse and database testing.
  • Worked with all stages of testing namely Integration Testing, System Testing and User Acceptance testing manually as well as using automated test tools.
  • Back-end testing using SQL, PL-SQL, Unix.
  • Well versed in testing Methodologies, Web testing, and software Deployment/Release processes.
  • Very Strong skills, including the use of nested table expressions, unions, Multi-table joins and outer joins.
  • Supported the defect resolution process by prioritizing the severity level of defects.
  • Self Motivated, Team Oriented with ability to handle multiple tasks and efficient in meeting deadlines.
  • Participation in design reviews with the Development team.
  • Possess excellent communication skills along with verbal and written skills.

TECHNICAL SKILLS

Operating Systems: Windows 2003/2000/XP, UX-HP, Solaris, MS DOS

Internet: ASP, HTML DHTML, XML, Web Services

Business Modeling Tools: Rational Rose, MS Visio

Languages: C#, C++, C, VB.Net, VBScript, JavaScript, VB 5/VB 6, SQL, PL SQL

Testing Tools: QTP8.x/9.2/9.5/10,Quality center, WinRunner 7.5/7.0/6.0, LoadRunner9.0/8.x, Test Director

Office Tools: MS Office, MS Project

Databases: MS SQL Server 2000, Oracle 8i/9i, TeradataV2R6/R5, DB2

ETL/ Reporting tools: Informatica, Datastage, Ab Initio, Crystal Reports

Configuration Management: MS Visual Source Safe, SOS, Clear Case, Share Point Portal, PVCS, Doors, Rational Test Manager

PROFESSIONAL EXPERIENCE

Confidential, Mc Lean, VA

Senior Data warehouse / ETL Tester

Responsibilities:

  • Worked as a System Analyst and a Data warehouse/ ETL Tester.
  • Worked with the business team to gather requirements.
  • Created and executed test cases based on test plans.
  • Developed SQL scripts and used Rapidsql query tool to run the SQL scripts from Sybase and SQL Server databases.
  • Tested load scripts that are developed and executed using Teradata client utilities MULTILOAD, FASTLOAD and BTEQ.
  • Validated JCL scripts and debugged stored procedures in TERADATA SQL Assistant.
  • Validated customized Mload scripts on UNIX platform for Teradata loads
  • Validated several Teradata BTEQ scripts that implement the business logic.
  • Used Quality Center to execute the test cases, track execution against the plan during testing and manage defects from inception to resolution.
  • Created Test cases scripts from the functional specifications and maintained traceability with the requirements.
  • Created SQL queries to fetch data and validate application against the database
  • Performed functional, performance, regression and black-box testing on the payment and billing application.
  • Creating the test batch data file by FTP thru Unix.
  • Created Test execution, Defect Metrics for daily status meetings
  • Validated XML files for the web services triggered by the Java based application (OUS).
  • Performed web service testing using SOAPUI, QTP as part of OUS functionality
  • Tested reports developed using Business Objects and Crystal Reports
  • Validated data between different web applications and documented the test results.
  • Communicate testing activities and findings in oral and written formats.
  • Ran Sql queries to check if the data is loaded correctly into the database for the backend testing.
  • Responsible for maintaining RTM in DOORS.
  • Trained end users on the new application and conducted knowledge transfer sessions on the project.
  • Attended daily status meetings for Data quality issues and technical review meetings.

Environment: Sybase, SQL Server, Teradata V2R6, Java, .Net, Informatica 8.6.1, BO XI 3.0,Embarcadero's Rapid SQL, XML, Lotus Notes 7.1.1, Clear case, Clear quest, UNIX, MS Excel 2007, MS word 2007, Windows XP, Unix, Quality Center 9.2, QTP 10/9.5, SOAPUI, IBM DOORS.

Confidential, New York

Senior Data warehouse / ETL Tester

Responsibilities:

  • Working with the business team to gather requirements.
  • Creating and executing test cases based on test plans.
  • Performed report validation of the securities system, which are generated, on Cognos8.0.
  • Developing SQL scripts and used TOAD to run the SQL scripts from Oracle and SQL server databases.
  • Experience in testing using Teradata utilities like BTEQ and exposure to FastLoad, MultiLoad, FastExport, Tpump, SQL Assistant, SQL Administrator.
  • Extensively tested data from flat files, Oracle, Teradata database.
  • Worked extensively with the Teradata Queryman to interface with the Teradata.
  • Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
  • Monitored the Informatica workflows using Power Center monitor. Checked session logs in case of aborted/failed sessions
  • Perform Functional, Data Validation, Integration, regression and User Acceptance testing.
  • Used TOAD, DB Artisan tools to connect to Oracle Database to validate data that was populated by ETL applications.
  • Involved in backend testing for different environments like System Testing and User Acceptance Testing.
  • Perform Functional testing, System testing, Smoke testing and Regression testing.
  • Developed automation scripts and executed them as a part of the regression testing using QTP.
  • Followed the keyword driven methodology for the automation
  • Documenting the test results.
  • Creating and modifying UNIX shell scripts.
  • Created T-SQL queries to retrieve the data the SQL Server database.
  • Tested internal and high-level business reports.
  • Running Sql queries to check if the data is loaded correctly into the database and into the reports subsequently.
  • Checking the job flows in Informatica.
  • Used Quality Center for executing the test cases and defects tracking.
  • Scheduling Autosys jobs and running the job flows.
  • Attended weekly status meetings for reporting the testing updates.
  • Participating in review meetings on a periodic basis.

Environment: Quality Center 9.2, QTP 9.5, Oracle, SQL Server, Teradata V2R5, Toad, Informatica 8.1, XML, Java, Cognos8.0, MS Outlook, Autosys, MS Excel, MS word, Windows XP, Unix and DOORS.

Confidential, Mc Lean, VA

Senior Data warehouse / ETL Tester

Responsibilities:

  • Worked as a Data warehouse / ETL Tester
  • Worked with the business team to gather requirements.
  • Used TOAD SQL browser to write SQL queries for validating constraints, indexes.
  • Used TOAD schema browser to check the characteristics of the schema objects(tables, synonyms etc)
  • Performed Positive testing, Negative testing, Functional testing, Navigational testing, System Testing and Regression Testing in different phases
  • Extensively used Informatica Debugger for testing the mapping logic during Unit Testing. Performed unit testing, integrated testing and validated results with Business Analyst and/or customer.
  • Extensively worked on understanding the business requirements and designing Cognos applications
  • Involved in FTP process to transfer the files from one server to other.
  • Performed quality control analysis and validates results of conversion programs. Used extensive SQL query. Evaluated actual data load results. Involved with high volume testing.
  • Developed SQL scripts and used Rapidsql query tool to run the SQL scripts from Sybase and DB2 databases.
  • Performed Functional testing, System testing, Smoke testing, Regression testing and UAT.
  • Documented the test results.
  • Created and modified UNIX shell scripts
  • Communicate testing activities and findings in oral and written formats.
  • Ran Sql queries to check if the data is loaded correctly into the database.
  • Responsible for maintaining RTM in DOORS.
  • Used Quality Center for executing the test cases and defects tracking.
  • Enhanced the existing automation scripts in QTP and maintained the object repository to ensure the sync with the application version
  • Created the Naming conventions document and documented management plan.
  • Attended daily status meetings for Data quality issues and technical review meetings.

Environment: Quality Center 9.2, QTP 9.2, Sybase, DB2, Rapid SQL, Data stage, BO XI R2, XML, Lotus Notes 7.1.1, Clear case, Clear quest, UNIX, MS Excel, MS word, Windows XP, Unix and DOORS.

Confidential, IL

Data warehouse / ETL Tester

Responsibilities:

  • Wrote Test Plans and Test Cases pertaining to data validation and integrity testing for data loading, data validation and integrity check testing.
  • Wrote test cases and executed them on the Billing System.
  • Developed a detailed Test Plan for the testing effort of the User Interface
  • Involved in requirement analysis
  • Performed security testing manually and writing sql queries against the database
  • Maintained requirement traceability matrix.
  • Extensively used Mercury Quality Center (TEST DIRECTOR) and Created Test Cases in the TEST PLAN according to the specifications.
  • Used TEST LAB to run the Test cases.
  • Reported Defects and prioritized outstanding defects using Test Director/Quality Center.
  • Ran the Informatica ETL Sessions for Claims in different stages Source to Stage & Staging to Data mart and Data mart to Business Objects and BO to Dashboard using Informatica Server Manager
  • Maintain Object repository
  • Created TSL Scripts files as per the test plan requirements.
  • Tracked the defects in Test Director.
  • Validated data feed into the data warehouse for DWH implementation and also tested front end application where massaged data was presented in report formats.
  • Involved in Integration testing, UI, User Acceptance Test (UAT), Functionality testing & Performance testing.
  • Performed database testing to verify the rates as per the large accounts
  • Executed SQL Queries to verify the dataflow from the backend
  • Involved in validating the reports, both Data and their layouts
  • Bug reporting, tracking and documentation on the Bug tracking System using Test Director
  • Weekly Status meeting with Development and Management teams to discuss bugs and other issues.

Environment: Test Director 7.2, QTP 8.2, Flat files, Ab Initio, SQL Loader, Oracle 8i/9i, TOAD, UNIX, Windows

Confidential, VA

QA/BA Analyst

Responsibilities:

  • Identifying business requirements, process improvements and new processes in a timely manner.
  • Designed, debugging & testing Informatica mappings for loading data to data warehouse.
  • Involved in writing the test cases and Test plans based on Informatica mappings and Data Analyst mappings, BA Visio diagrams
  • Ran the Informatica ETL Sessions for Claims in different stages Source to Stage & Staging to Data mart and Data mart to Business Objects and BO to Dashboard using Informatica Server Manager
  • Checked the existing functionality of the application manually.
  • Logged defects in TD and worked with the development team towards bug resolution.
  • Developed Test Matrices for consolidating the data required for Positive and Negative testing.
  • Tested the application manually (Black box testing) during the development phase.
  • Performed Integration and Regression testing to check compatibility of new functionality with the existing
  • Tested performance web applications using Client /Server architecture.
  • Managed defect tracking, defect reporting for assigned projects using Test Director.
  • Worked with development teams to investigate, prioritize and resolve software bugs / defects based on the testing results.
  • Participated in review meetings and took the initiative to meet the QA testing targets.
  • Participated in daily status meetings to report any bugs, issues and risks.
  • Run the SQL queries to fetch test data and backend (database) testing to validate the database.
  • Worked with the QA / Development team for improving the testing methodology.
  • Communicating with team members and managers by participating in bug review meetings

Environment: Informatica 7.1.2, .Net, XML, QTP, VBScript, UNIX, Test Director 7.2, IIS 5.0, SQL Server 2000 and Crystal Reports 8.0, Ms Visio.

We'd love your feedback!