SUMMARY:

• 7+ years of Information Technology experience in Quality Assurance for ETL, Backend, Web based, Client/server applications using Manual wide variety of testing tools.
• Good Experience in Writing System Test Plans, Test Cases, Test Scripts, Documentation and Setting up Test Lab Environment.
• Extensive experience in varied aspects of the (SDLC) Software Development Life Cycle.
• Experienced in working with the QA methodologies and processes.
• Solid Experience in Data warehouse, Reports and Back end databases.
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data Warehouse using Data Stage, Informatica.
• Created Test Scripts and Test Conditions to perform the Functional, Integration, System, and End - to-End testing of the application to ensure Requirements Traceability using ALM/QC
• Extensive work experience and expertise in Black Box testing, system testing, backend testing, regression testing, user/business acceptance testing.
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Expertise in the entire QA Life Cycle Process, which includes design and development of Testing Methodology, Test Strategy, Test Scenarios, Test Plans and Test Cases.
• Experience in Backend testing of SQL Queries using Oracle, SQL Server, and DB2
• Expertise in Oracle, SQL database queries and manipulation using SQL.
• Expertise in testing web services using SOAP UI tool.
• Expertise in handling the entire QA process documentation using ALM/Quality Center.
• Well organized, creative and a Team Player with proven ability to complete given tasks on time.
• Worked on Agile methodologies
• Experience in Bug Tracking System and involved in Defect Triage Meetings.
• Strong analytical and communication skills with capable of working efficiently under stress and tight deadlines.

TECHNICAL SKILLS:

Testing Methodologies: Water Fall, Agile

Defect Tracking Tool: ALM/QC, Jira, Clear Quest, Teamtrack

Datawarehouse: Data Stage, Informatica, SSIS

Reporting: SAS, Business Objects, Cognos, SSRS

Operating System: Windows 95/98/NT/2000/XP, UNIX.

Mainframes: IBM, Anchor, Rumba, TSO/ISPF, IBM utilities, QMF

Database: Oracle, SQL Server, MS Access, DB2

Database Tools: SQL *Plus, SQL Query Analyzer, AQT and TOAD

Scripting Languages: VB Script, HTMLWeb Services SOAP UI, XML, SOA

PROFESSIONAL EXPERIENCE:

Confidential, MN

QA Analyst

Responsibilities:

• Study of detailed requirements of end users of system & their expectations from Applications.
• Interacted with Business users and Technical team in providing clear solutions to requirements.
• Verified correctness of data after the transformation rules were applied on source data.
• Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Wrote Test Cases for EDW - Data ware house (Source to Target).
• Validated Source - Target mappings applying various transformation rules and Business Rules.
• Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications.
• Worked with data feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Executed the SQL Test Scripts in TOAD and documented the results.
• Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings.
• Written SQL queries to validate that actual test results match with expected results.
• Check the naming standards, data integrity and referential integrity.
• Verified data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Tested the database to check field size validation, check constraints, and cross verifying the field size defined within the application with metadata.
• Tested Web Services using SOAP UI tool by creating test XML’s with expected data and verified the responses in SOAP UI as per the business requirements.
• Defects tracking, review, analyze and compare results using ALM.

ENVIRONMENT: Water-Fall, ALM, XML, HTML, DHTML, J2EE, Java, Java Script, Oracle, DB2, MS Word, MS Excel, UNIX, SOAP UI, Data Stage (ETL), SQL, BO, Windows NT/2003.

Confidential, MA

QA Analyst

Responsibilities:

• Involved in preparation of Test plans, created test cases and responsible for executing the Test Scripts.
• Coordinate all Testing for Back End and Front End.
• Working with the end users to create user acceptance test strategies and test scenarios to verify that the system performs the business functions as required.
• Owned the creation and ongoing maintenance of test process documentation and test plans.
• Worked with the development team to create a suite of test data (both input files and expected results) that fully exercises data validation (detecting and rejecting bad data) and actual ETL (Informatica) functionality (properly processing good data, i.e., transformations, calculations, and derivations)
• Managed the ETL build validation process on an ongoing basis.
• Created reports for Validation activities.
• Responsible for the validation of any additions/modifications to the Business Objects reports before release to production. Validating fields present in the reports are as agreed in the specifications.
• Created Test Strategy that included Estimation, requirement Analysis, Resource Planning, Test Planning, Execution, and Results.
• Wrote SQL queries for backend testing.
• Identified and logged defects using Quality center.
• Owned the overall defect tracking process, by which defects are prioritized and scheduled for resolution, including preparation of reports that summarize overall project status for review by the team.

ENVIRONMENT: Agile, ALM, XML, HTML, DHTML, J2EE, Java, Java Script, IBM Web sphere Server, Oracle, DB2, MS Word, MS Excel, UNIX, Informatica (ETL), SQL, Cognos, Windows NT/2003.

Confidential, MA

Quality Assurance Engineer

• Participated in meetings with business customers to gather the requirements and business naming conventions.
• Involved in test planning, coordination and implementation of QA methodology based on the Business requirement and Design documents.
• Involved in Source database, target database, data extraction, data transformation and data loading validations.
• Used the most comprehensive approach of data warehouse testing. i.e., validating the data at each transformation; first the Source tables, staging tables, then the loading tables and finally the destination tables.
• Interacted with System Analysts and the Development team on system to investigate requirements and in resolving issues.
• Incremental development/testing of Enterprise Data Warehouse.
• Wrote complex SQL queries to validate target data based on the business requirements.
• Implemented data verification procedures for ETL processes in load testing.
• Used SQL scripts to perform backend database testing.
• Used Quality Center for bug tracking and reporting, followed up with development team to verify bug fixes and update bug status.
• Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings.
• Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
• Effectively distributed responsibilities, arranged meetings and communicated with team members in all phases of the project.
• Involved in Integration testing, Functional testing and Regression testing.
• Checked for any inconsistent joins and resolved loops in the catalog.
• Involved in the System Testing of the OLAP Report Functionality and data displayed in the reports.
• Validating fields present in the reports are as agreed in the specifications.

ENVIRONMENT: Agile, TFS - MTM, SSIS, SSRS, Oracle, SQL Server, TOAD, UNIX, XML, Windows

Confidential, IN

QA Analyst

Responsibilities:

• Performed Smoke, Integration, functional, Regression, and system testing.
• Created test cases and responsible for executing the Test Scripts.
• Designed the Data for interpreting the Positive/Negative results.
• Participated in Sprint Planning and Sprint Review meetings.
• Participated in daily SCRUM/stand up meetings to report any issues and risks.
• Used JIRA for preparing the test plans and manual test scripts.
• Conducted the Functional, System, Integration, Adhoc testing, End to End, Regression, User Acceptance on the web application.
• Submitted Status and Test Evaluation Reports to Project Lead on daily basis and constantly updated the test deliverables.
• Involved in Black box and White Box Testing.
• Attended Code Review meetings.
• Managed requirements and creating traceability matrix.

ENVIRONMENT:  Agile, Clear Quest, JIRA, J2EE, XML, Oracle, Windows.