EXPERIENCE SUMMARY:

• Around 7 years of experience in IT, extended expertise Quality Assurance, testing and implementation of both Manual Testing, Automation Testing using with Business Intelligence, Data Warehouse, Data Mart, Database and client/server applications.
• Experience working as ETL Tester, SQL Tester, BI Tester, Data Tester and QA Analyst.
• Experience with Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies,
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Experience in testing Data Migration testing.
• Identify the Test Requirements based on User Requirement and Program Specifications.
• Expert in preparing Test Plans, Test Scripts, Test Cases and Test Data.
• Prepared Test Plans, Test Scenarios and Test Cases for both positive and negative scenarios for System Integration testing (SIT) and mapped same requirement in quality center.
• Tested applications in Waterfall and Agile development processes.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle and Teradata, MS Access, Flat files into a staging area.
• Experienced in distributed testing, multi - user testing, and database testing.
• Expertise in analysis of Problem severity, Defect tracking and Defects reporting system.
• Expertise in data manipulation using SQL scripts for data retrieval from relational databases.
• Strong skills in Batch and back-end testing using SQL queries on SQL Server and Oracle.
• Experience in HP ALM - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Strong skills in database programming using SQL.
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Specialized in testing Character-Based, Web, GUI (Graphic user Interface) networking and On-line client server GUI applications.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame
• Excellent communication, analytical and interpersonal skills Good analytical skills, presentation skills with strong communication skills

TECHNICAL SKILL SET:

Defect Tracking. Tools: HP Quality Center/ALM, Jira

ETL Tools: Informatica 10.2/10 / 9.5/9.0 , Data Stage 11.5/8, SSIS

BI/Reporting Tools: SAP BO, Tableau, Cognos

Methodologies: Waterfall, Iterative, Agile/Scrum

Programming Languages: SQL, XML, Java, C, C++

RDBMS/ Database: Oracle, SQL Server, IBM DB2, Teradata

GUI Tools: TOAD, Oracle SQL Developer, Teradata SQL Assistant

Testing tools: Manual Testing, WinRunner, Rational Robot, Test Director, QTP, QMS

Modeling Tools: Rational Rose, ER-Win

Web Development Tools: XML, HTML, Java Script, VB Script, JSP and Java Servlets

Data Access Languages: SQL and PL/SQL. AS/400

PROFESSIONAL EXPERIENCE:

Confidential, Omaha, NE

ETL/SQL/BI Test Analyst

Responsibilities:

• Developed Test Plan and Test Cases based on Functional Requirements/ Low Level Design documents.
• Involved in Data Warehouse testing while sourcing data from multiple sources.
• Involved in ETL & Report testing, executed SQL queries to validate data in target database.
• Involved in preparation of SQL queries based on business requirements and testing needs.
• Involved in Preparation of Test data using Data mining SQL Queries.
• Performed End User Data Validation on Cognos as a Reporting Tool.
• Detected Defects, communicated to developers using Bug Reporting Tool and Tracking Defects using Quality Center.
• Extensively used Quality Center for test planning, bug tracking and reporting.
• Used Quality Center for organizing Requirements, Test Cases and Defects
• Inserted Check Points to Check for the broken Links, Text, and standard properties of an object using QTP.
• Performed database testing
• Used Test Driven development (TDD) to write test cases for new modules.
• Uploaded test scenarios, test cases and defects to Quality Center and SharePoint.
• Extensively developed SQL scripts on Oracle for validating test cases.
• Experienced in writing of UNIX Shell Scripting to analyze log files and reports.
• Verified the files in the specific directory in UNIX.
• Executed test cases using Test Director (HPALM), Used Test Director to generate the test matrices.
• Reviewed the files in the specific landing directory in UNIX.
• Involved Web services testing, SOAP UI testing of the application
• Performed QA Testing in distributed UNIX/ Windows Environment, Oracle databases as back end and performed end-to-end testing. Involved in complete QA Life Cycle.
• Participated in Project Manager/ Tech Leads walkthroughs and defect report meetings periodically.

Environment: HP ALM, Oracle 11g, Informatica 10.2, MS Office, Unix, QTP, Tableau, Toad.

Confidential, Princeton, NJ

Sr. ETL QA Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Assisted in promotion of Informatica code and UNIX Shell scripts from UAT to Production.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Worked with shell scripts to extract data from different sources and set up jobs to load extracted data into TERADATA Databases in QA environment.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• 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 dev team.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• 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, SQL, PL/SQL, HP ALM, XML, Oracle 11g, TOAD for Oracle, Cognos

Confidential, Baltimore, MD

QA Analyst

Responsibilities:

• Validated that the design specifications meet the requirements and data flow.
• Written test cases developed the validation steps and reviewed them with test team lead.
• Developed test scripts using SQL and PL/SQL according to the mappings and rules specified in mapping document.
• Reviewed test cases, validation steps and test scripts with business users and team lead.
• Used Microsoft Excel to test small amount of data imported from different database management systems.
• Used Access database to import connections from different databases systems and validate the test cases.
• Attended Daily Status Call with Manager, Development Team and QA Team to discuss the project updates.
• Documented test cases, test scripts and test results in Microsoft Excel.
• Responsible for keeping up with the test schedule and interacting with software engineers to ensure clear communications on requirements and defect reports.
• Conducted performance testing of the application using Load Runner
• Worked on generating reports using SQL Plus and PL/SQL. Worked on tuning SQL statements.
• Worked intensively with indexes to tune the query, exploited the B-tree and Bitmap index functionality of oracle to get the better performance.
• Analyzed, reported, and kept track of defects using HP ALM
• Submission of test results, weekly status reports and test summaries to the QA lead and project manager
• Conducted Training Sessions and Knowledge Transfer Sessions to develop skill sets of team members

Environment: DataStage, SQL, DB2, SAP BO, Flat files

Confidential, Dallas, TX

QA Analyst

Responsibilities:

• Preparing Test plan and Test case.
• Preparing Test schedule and Estimation.
• Involved in reviews, Meeting and peer reviews.
• Involved in Functional, Integration and Regression testing.
• Defect tracking, Reporting and metrics collection.
• Defect Review, Evaluation and assigning
• Creating Bug Report, Test execution Report and defect metrics.
• Coordination with developers, onsite coordinator and clients.
• Preparing daily, weekly status report.
• Involved in internal audits and causal analysis.
• Mentoring and monitoring the team activities.

Environment: DataStage, SQL,SAP BO, Flat files,HP Quality Center,Unix,TOAD

Confidential

Intern/Jr. QA Tester

Responsibilities:

• Developed Manual and Automated test cases to test the functionality of the application.
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional
• Experience in creation of library functions, Checkpoints, Data Validation Descriptive Programming using QTP
• Written Test plans, Test cases, executed Test cases for SQL/backend test and tracked defects in Quality Centre based on the Business Requirements, Functional Requirements, and Business Workflows
• Performed back end testing by writing and executing SQL queries to validate that data is being populated in appropriate tables and manually verify the correctness of the data with front-end values
• Involved in testing Web services and XML with tool called SOAP UI and using this tool to locate WSDL file on internet, created Test cases
• Participated in writing Test Plan, Test strategy & Test Scenarios based on software documentation from business, technical and functional requirements.
• Performed end-to-end testing of application and verified compliance for software quality standards of the organization.
• Maintained Test Logs and Reports in Quality Center
• Defects were Tracked, Reviewed, Analyzed and Compared using Quality Center
• Provided test summary documentation and analyze test results, identifying trends and/or root causes of problems

Environment: HP QTP 9.5, HP Quality center 9.8, Windows, Linux, Java, SOUP UI, Manual Testing, XML, HTML, Oracle