SUMMARY:

• Around 9 years of diversified experience as a QA Analyst in Web - based Applications, Client-Server and Database Applications using Manual and Automated Testing Tools.
• Good Experience in Datawarehouse concepts and technologies like OLTP, ETL, OLAP, Normalization/Denormalization, Data Models (Star/ Snow Flake Schemas), Datamarts (Dimensions and Facts) and Reporting.
• Good experience in Waterfall and Agile testing methodologies, and worked on domain like Banking, Healthcare, Ecommerce.
• Well versed in Software Development Life Cycle and Test Methodologies from project definition to post-deployment.
• Extensive Experience with development of Test Plans, Test Scenarios, Test Cases, Test Scripts, Test Execution, Change Requests and Defect management.
• Experience in RDBMS technologies like Oracle 10g/11g, DB2 9.7/8.0, SQL Server 2008/2005, Teradata.
• Did Data Quality testing and Data Profiling validation processes in Enterprise level Data Warehouse and also in small systems.
• Make sure that data movement from Source to Target is accurate as per business logic (Source and Target may be a database, flat files or xml files).
• Expertise in Testing Data Marts, ETL (Informatica, Data stage and Abinito) and OLAP (Cognos, OBIEE), Reporting and Documentation.
• Hands on experience in Designing and developing Keyword driven, Data Driven and Hybrid automation frameworks.
• Experienced on Agile methodology to understand Scrum, Sprint work.
• Experience in developing automated test scripts using VBScript in QTP.
• Performed Data driven test for testing the application with multiple set of data using QTP.
• Maintaining and executing Selenium Automation scripts developed in Java.
• Extensive experience in Automation Framework Designing, Development, Executing and maintaining automated test scripts.
• Implemented Page Objects, Data Driven, Keyword Driven, Hybrid automation frameworks using Selenium WebDriver, JAVA, JUnit.
• Have tested the applications on Oracle ADF for Order receipt management System, Retail inventory also different Sales channels like GOC, My HL, HMS.
• Experience on testing SAS Datawarehouse.
• Implement new updates to Confidential FED Edit Checks.
• Extensive Experience with Utility Tools like TOAD for Oracle, SQL Server Management Studio, SQL Developer, SQL Assistant.
• Performed test execution by writing and executing complex SQL queries in TOAD, sql developer and done analysis on data.
• Well familiar with managing defects and creating requests through documenting tools like HP ALM/Quality Center/Test Director. knowledge of systems concepts and terminology.
• Expertise in Excel vlookups and Pivot data.
• Good experience with Reporting Tools like Crystal Reports, Oracle BI, Business Objects.
• Strong written and verbal communication skills.
• Strong ability to follow the requirement documents and test plans to complete the projects with in the timeframe.
• Hands on Experience on QTP/Selenium.
• Interact with all the stakeholders and business teams, managers to for clarifications and resolve the issues.
• Can able to support with any environment and be an effective team member.
• Able to handle and do the projects alone without supervision.
• Validate the DW/ETL daily jobs using the Informatica Power Center tool to monitor the job execution process raise the defects accordingly if any failures after analyze the root cause.
• Good experience with UNIX commands, Putty, VI Editor and knowledge in PERL Scripting.
• Well familiar with Excel for developing Requirements Traceability Matrix (RTM) and Capturing and Updating Change Requests.
• Worked with transformations like Filter, Joiner, Router, Look up, Aggregator, Expression and functions like CASE, IFNULL, SUBSTR(), MAX(), SUM(), JOIN, PARTITION BY, ROUND(), DATEDIFF(), etc.
• Extensive experience working with FACT and DIMENSION tables.
• Experience with Microsoft Desktop applications such as Word, Excel, Access, Outlook, PowerPoint, Visio, Office Communicator, IE and with Office Web applications.
• Actively participated in daily scrums and sending out weekly status updates.
• Actively participated in team meetings on a regular basis involving discussions about Overview, Architecture, Development plan, Test Plan and overall Project plan.
• Experienced in testing Type 1 and Type 2 Dimensions

TECHNICAL SKILLS:

QA Testing Tools: HP ALM, Quality Center, Test Director, TFS,Rally

Quality Methods: Agile/Sprint/Scrum Methodology, ISO, CMM/I

ETL-DW, BI-BO Tools: Informatica Power center, Informatica IDQ, Data Stage, SAS

Functional Test Tools: WinRunner, QTP, Selenium Webdriver

DBMS/RDBMS: Oracle, SQL Server, TOAD, DB2

ERP/CRM: Siebel, Oracle ADF

Scheduling Tools: Autosys

Configuration Tools: MS Visual Source Safe, Rational Clear Case

Scripting Languages: VB Script, Java Script, UNIX Shell Scripting

Languages: C, C++, SQL/PLSQL, Java

Operating Systems: Windows, Unix, Linux

GUI Tools: Visual Basic 5.0/6.0

Web Technologies: HTML, ASP, JSP, DHTML, and XML

Web/App Servers: IIS, Web Logic, and Web Sphere

Web Browsers: IE Explorer, Chrome, Netscape Browser, Fire fox and AOL

MS-Suite: MS Word, Excel (Macros), PowerPoint, Outlook

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. QA Analyst

Responsibilities:

• Understanding of Business Requirement Specifications and System Requirement Specifications.
• Working in DW - ETL Testing project, responsible for understanding the Business Requirements/Project Specifications.
• Used Database links in SQL for Querying the Oracle database.
• Validated the GE data from oracle to Teradata as part of GE Capital CDF Data Migration.
• Experienced in Validating Bteq scripts, Informatica mappings, Session logs.
• Writing test plans and test scripts and complex SQL queries.
• Expertise in validating Type 1 and Type 2 Dimensions.
• Extensively used Lookup tables, validated various types of Bridge tables or Relation tables.
• Validated various types of mapping requirements analysis.
• Validate the ETL load process to make sure the target tables are populated according the data mapping from Source (ODS) to target validation Field to Field verification.
• Extensively used Unix commands for file validations.

Environment: Oracle 11g, Win 2K/XP, UNIX, ETL, Informatica power center, OBIEE Reports, HP ALM, Teradata, Sql Server, Sql developer, Winscp, Manual Testing.

Confidential,Winston Salem, NC

Sr. Applications Analyst - QA

Responsibilities:

• Understanding of Business Requirement Specifications and System Requirement Specifications.
• Writing test plans and test scripts and complex SQL queries.
• Worked on multiple projects RMS, Lemonade simultaneously.
• Tested the web application of different sales channels like GOC, My HL, HMS in Oracle EBS.
• Tested the order receipt management for customers, retail inventory.
• Worked as admin for HTM ( Confidential Test Management tool), uploading test cases, managing defects, performing all types admin activities.
• Proven ability in designing and creating automation frameworks using Java, Selenium WebDriver, TestNG.
• Experience with in using assertions and annotations.
• Expertise in writing Selenium WebDriver automation scripts in JAVA for highly transactional E-commerce websites Executed automation scripts on different browsers/environments & reported defects/results to the team
• Experience in working on Page Object model framework using selenium web driver Involved in knowledge transfer to the newly recruited persons.
• Experience in offshore and onsite model, co-ordinate with offshore and onsite teams.
• Lead the team of 5 members in RMS.
• Good experience in creating, modifying and enhancing both manual Test Scripts and Test Scripts created in selenium.
• Worked with complex SQL queries involving JOINS, Sub Queries, CASE statements, Filters and Set Operators.
• Prepared Test Scripts and Test Data based on Functional Requirement Specification Document.
• Performed functional and regression testing using Selenium Webdriver.
• Maintenance and execu

Environment: Oracle 11g, Oracle EBS, Oracle ADF, Win 2K/XP, UNIX, HTM, HP ALM, Manual Testing, Selenium

Confidential, San Ramon, CA

Sr. ETL QA Analyst

Responsibilities:

• Understanding of Business Requirement Specifications and System Requirement Specifications.
• Working in DW - ETL Testing project, responsible for understanding the Business Requirements/Project Specifications.
• Used Database links in SQL for Querying the Oracle database.
• Writing test plans and test scripts and complex SQL queries.
• Executed SQL queries using Advanced Query Tool to validate ETL jobs.
• Consolidating data into schedule tables and implementing Fed Edit checks to ensure quality Fed submissions.
• Expertise in validating Type 1 and Type 2 Dimensions.
• Extensively used Lookup tables, validated various types of Bridge tables or Relation tables.
• Validated Product Hierarchy and Collateral Hierarchy at REAL ESTATE and VEHICLE level.
• Validated different sources data from Mortgages, consumer, auto loans,
• Validated various types of mapping requirements analysis.
• Implemented Page Objects, Data Driven, Keyword Driven, Hybrid automation frameworks using Selenium WebDriver, JAVA, JUnit.
• Validate the ETL load process to make sure the target tables are populated according the data mapping from Source (ODS) to target validation Field to Field verification.
• Written complex SQL queries to test FACT and DIM tables.
• Worked with complex SQL queries involving JOINS, Sub Queries, CASE statements, Filters and Set Operators.
• Wrote SQL Queries for different types of slowly changing dimension transformations.
• Prepared Test Scripts and Test Data based on Functional Requirement Specification Document.
• Source to target data validation Field to Field verification.
• Involved in BA walkthroughs and ETL Specification Document.
• Worked and tested on Informatica Designer tools - Source Analyzer, Data warehousing designer, Mapping Designer, and Transformations, Repository manager, Workflow manager and Workflow monitor.
• Execution of Test Cases and Test Scripts. Perform end to end ETL testing using Informatica ETL tool.

Environment: Oracle 10g, Win 2K/XP, UNIX, ETL, Informatica Power center, OBIEE Reports, HP-ALM, Agile Methodology.

Confidential, San Ramon, CA

Sr. ETL QA Analyst

Responsibilities:

• Understanding of Business Requirement Specifications and System Requirement Specifications.
• Working in DW - ETL Testing project, responsible for understanding the Business Requirements/Project Specifications.
• Used Database links in SQL for Querying the Oracle database.
• Writing test plans and test scripts and complex SQL queries.
• Executed SQL queries using Advanced Query Tool to validate ETL jobs.
• Consolidating data into schedule tables and implementing Fed Edit checks to ensure quality Fed submissions.
• Defect fixes for incorrectly coded or interpreted fed Edit check.
• Implementation of prioritized Confidential FED Edit Check modification and updates to the FED instructions for previously coded 14Q and 14M schedules.
• Support WS5 development of External edit check dashboards.
• Worked on IDQ Informatica Analyst to validate Edit checks in mapping level.
• Validate the ETL load process to make sure the target tables are populated according the data mapping from Source (ODS) to target validation Field to Field verification.
• Written complex SQL queries to test FACT and DIM tables.
• Worked with complex SQL queries involving JOINS, Sub Queries, CASE statements, Filters and Set Operators.
• Wrote SQL Queries for different types of slowly changing dimension transformations.
• Prepared Test Scripts and Test Data based on Functional Requirement Specification Document.
• Source to target data validation Field to Field verification.
• Performed end to end ETL testing using Informatica ETL tool.
• Involved in BA walkthroughs and ETL Specification Document.
• Worked and tested on Informatica Designer tools - Source Analyzer, Data warehousing designer, Mapping Designer, and Transformations, Repository manager, Workflow manager and Workflow monitor.
• Execution of Test Cases and Test Scripts. Perform end to end ETL testing using Informatica ETL tool.

Environment: Oracle 10g, Win 2K/XP, UNIX, ETL, Informatica Power center, Informatica Data Quality, OBIEE Reports, HP-ALM, Agile Methodology.

Confidential, Austin, TX

QA Analyst

Responsibilities:

• Understanding of Business Requirement Specifications and System Requirement Specifications.
• Working in DW - ETL Testing project, responsible for understanding the Business Requirements/Project Specifications.
• Used Database links in SQL for Querying the Oracle database.
• Writing test plans and test scripts and complex SQL queries.
• Executed SQL queries using Advanced Query Tool to validate ETL jobs.
• Validate the ETL load process to make sure the target tables are populated according the data mapping from Source(ODS) to target validation Field to Field verification.
• Written complex SQL queries to test FACT and DIM tables.
• Worked with complex SQL queries involving JOINS, Sub Queries, CASE statements, Filters and Set Operators.
• Wrote SQL Queries for different types of slowly changing dimension transformations.
• Prepared Test Scripts and Test Data based on Functional Requirement Specification Document.
• Source to target data validation Field to Field verification.
• Performed end to end ETL testing using Informatica ETL tool.
• Involved in BA walkthroughs and ETL Specification Document.
• Conducted on the ODS data testing and Knowledge on XML.
• Worked and tested on Informatica Designer tools - Source Analyzer, Data warehousing designer, Mapping Designer, and Transformations, Repository manager, Workflow manager and Workflow monitor.
• Involved in Build deployment activities and ran UNIX scripts.
• Execution of Test Cases and Test Scripts. Perform end to end ETL testing using Informatica ETL tool.
• Provided daily status to Test Lead

Environment: Microstrategy, Oracle 10g, Win 2K/XP, UNIX, ETL, Informatica, OBIEE Reports, Quality Center 9.2, Agile Methodology, Manual Testing.

Confidential, Richfield, MN

QA Analyst

Responsibilities:

• Execution of Test Cases and Test Scripts. Perform end to end ETL testing using Informatica ETL tool.
• Developed validation steps and SQL using business requirements and rules.
• Performed database validation using SQL according to the business rules and specifications.
• Responsible for documenting the test cases and test execution in HP ALM.
• Worked in an ERP platform with Oracle Integration.
• Hands on experience with TERADATA.
• Worked on 4 different fast paced projects involving huge data.
• Experienced in writing SQL queries like joins, sub queries which used to validate transformations.
• Worked in an AGILE environment attending daily scrums and weekly meetings.
• Used MS Visio to develop test approach and view Dataflow designs.
• Worked on projects with source and target data in different databases and environments.
• Worked with little to extensive documentation for QA requirements specs.
• Worked with BA/TA to make changes to documentation as per DA specs and data.
• Tested the batch processes and stored procedures.
• Used Toad for Oracle to prepare test scripts and execute them.
• Attended and represented the QA team in test review sessions.
• Tested and assisted in closing Service Requests during post-production and pre-production.

Environment: Micro strategy, Oracle RDBMS 10g/11g, TOAD 10.5/11.0, HP Quality Center 10.0/HP ALM 11.0, IE 8, Windows 7, SQL, Informatica 8.6, Excel, Outlook.

Confidential, Sioux Falls, SD

ETL/BI Tester

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for ETL Data Validation and Report testing.
• Written complex SQL queries and queried the Oracle database to test Informatica ETL code.
• Involved in Regression, Functional, Integration and User Acceptance Testing.
• Tested several complex reports generated by OBIEE including Dashboard, Drill Down and Pivot.
• Created test data to test the functionality of the Informatica jobs.
• Written complex SQL queries to query DB2 database.
• Used VI Editor to access and manipulate files in UNIX.
• Used UNIX Diff command to compare two text files.
• Experienced with UNIX commands like GREP, PS, LS and CHMOD etc.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Validated business reports like Drilldown and Cross Tab reports developed by OBIEE.
• Maintained the test logs, test reports, test issues, defect tracking using Clear Quest.
• Performed integration and performance testing on Informatica ETL jobs.
• Used Database links in SQL for Querying the Oracle database.
• Attended daily project status meetings and weekly QA status meetings.

Environment: Oracle 10g, Teradata V2R6, SQL, Toad for Data Analysts, Informatica, Microstrategy 8.0, MS Office, SQL Server, Oracle, SQL, Datastage, Unix, Quality Center 8.0.

Confidential,

QA Analyst

Responsibilities:

• Prepared Test Cases by analyzing Business requirements and Functional Specification Document.
• Design Specification Document to determine the functionality of the ETL Processes.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Created test plan and test cases from the business requirements to match the project’s initiatives in Quality Center.
• Executed SQL queries using SQL Server Management Studio to find useful test data to verify various functionalities of the application and also done the back-end verification.
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Performed database validation according to the business logic by comparing the source to the target in Spreadsheet.
• Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
• Worked with Users to develop Test cases for user acceptance testing.
• Verified the data in DW tables after extracting the data from source tables by writing SQL queries using TOAD.
• Involved in preparation of Requirement Traceability Metrics (RTM), Defect Report, and Weekly Status Reports using Quality Center.
• Writing test plans and test scripts and complex SQL queries
• High Level Test Case Design and writing detailed test cases
• Involved in functional, system, integration and performance testing.
• Used QTP for automating scripts and running them.
• Assigned defects to developers through Test Director.
• Updated the defects status in Test Director.
• Reported periodic project status and updates to the QA Lead and QA Manager
• Involved in interacting with UNIX Shell scripts.

Environment: Oracle 8i, Load Runner, QTP, PL/SQL, UNIX, Test Director 8.0, QC, SQL Server .