SUMMARY:

• 6+ years of IT experience in Quality Assurance for ETL , Backend, Web based, Client/Server applications using Manual and Automated testing tools.
• Extensive experience with Test Plans, Test Cases, Test Scripts and Test Execution.
• Experience with defect management, test execution report and defect status report thru HP ALM/Quality Center.
• Proficient in gathering and analyzing the Business Requirements, documenting System Requirement specification, Functional Requirement specifications, Requirements Traceability Matrix.
• Experience in Insurance, Healthcare, Retail, Public Services, Web Apps.
• Experience using query tools for Oracle, Teradata and MS SQL Server to validate reports and troubleshoot data quality issues.
• Participate in all meetings planned for particular release and obtain necessary technical automation requirement. Such meetings design review, test execution timeline etc.
• Experience working in agile environment with bi - weekly sprint ad daily scrums.
• Significant experience with SQL queries involving DDL, DML, Joins, Set operators and Case statements.
• Expert in testing Client/Server, Mainframes, Middleware (EDI) and Internet/Intranet based business applications including development and implementation of test plans,test cases and test scripts.
• Experience in analyzing EDI requirements and mapping documents.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading.
• Good concept of ETL, Warehouse and BI applications integration
• Extensive experience with data warehouse concepts and technologies like OLTP, OLAP, Normalization, De-normalization, ETL, Data Models and Data marts.
• Good experience with Software Development Life Cycle methodologies waterfall and agile.
• Extensive experience with database utility tools TOAD for Oracle, SQL Server Management Studio, SQL Developer and SQL Assistant.
• Good Knowledge in various EDI X12, EDIFACT standards and Flat Files (Prop Format)
• Experienced with ETL tools - Informatica Power Center, SSIS and DataStage.
• Experience developing Requirements Traceability Matrix (RTM) and capturing and updating Change Requests.
• Experienced with System, Integration, Regression, Performance and User Acceptance Testing (UAT).
• Experience with Microsoft office applications such as Word, Excel, Access, Outlook, Powerpoint.
• Experienced with White box testing, and Black box testing.
• Experience with programming languages SQL, PL/SQL, C, HTML and Java.
• Good experience with large amount of data and large databases.
• Very good problem solving, interpersonal, and communication skills.

TECHNICAL SKILLS:

Testing tools: ETL,UFT(United Functional Testing), HP Quality Center/ALM, JIRA, QTP, Test Director, Manual Testing, Rational Test Tools Suite, Clear Quest

Defect Tracking Tools: Quality Center (9, 10, 11.0), Jira, Team Foundation Server (TFS 2008, 2010, 2012), Rational Clear quest, Bugzilla.

Languages: C, C++, Java, SQL, PL/SQL, HTML, Visual basics

Project Management: Microsoft Project, Microsoft Office (Word, Excel), Microsoft PowerPoint, MS Access, Agile & Waterfall

Methodologies: SDLC, Agile, Waterfall

Browsers: Internet Explorer, Firefox, Chrome & Safari

Operating Systems: Windows XP, 7, 8 & server 2003, UNIX and Linux

Databases: Oracle R12, MS Access, DB2, SQL Server 2008, TOAD/

PROFESSIONAL EXPERIENCE:

Confidential,Minnetonka,MN

ETL Tester

• Analyzed business requirements and developed test cases and test scripts.
• Conducted a complete assessment of teams, processes and environment.
• Defined issues and risks and oversaw the design and introduction of tools, processes and best practices across testing life cycle to improve throughput, communication and on-time delivery of projects in an Agile development environment.
• Involved in Capacity and resource planning and assigning tasks to team.
• Experience working in agile environment with bi- weekly sprint ad daily scrums.
• Written Test Script, Test Cases, Reported bugs and tracked defects using ALM.
• Experienced in data integration, metadata management, ETL, data modeling tool sets
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Experience in EDI transactions (837, 835, 270, 271, 276, 277, 278, 820, 834 & 997) Enhanced and maintained QTP scripts, Configured Shared Object Repositories and developed Reusable function Libraries using VBScript.
• Involved in creating the Object Repositories, QTP Test scripts and executes them during testing.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Performed system testing on all EDI transactions both inbound and outbound
• Created and managed issues thru JIRA tracking tool.
• Discussed QA Testing requirements in QA Team walk through meetings.
• Expertise in handling Health care EDI Claims 837I, 837P and 835P
• Involved in/EDL transactions Analysis, Design, Implementation and documentation.
• Developed shell script in UNIX and automated repeatable and regression test cases.
• Developed complex SQL queries for testing several ETL transformations.
• Executed ETL jobs and tested dimension and fact tables in semantic layer.
• Analyzed EDI translation errors that failed in the inbound and re-processed the EDI's without losing the information.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Tested several data mart tables in Oracle database using SQL and PL/SQL queries.
• Involved in extensive data validation using SQL queries and back-end testing
• Submitted weekly test execution and defect reports from ALM to project team.

Environment: Teradata 14, ALM/Quality Center 10, EDI, Power Center 9, JIRA, Oracle 9i, SQL Server 2008, SQL, TOAD, Hadoop, Hive, Big Data, SVN, Unix,TWS 9.3.

Confidential,Denver,CO

ETL QA Tester

• Analyzed business requirements and developed test cases.
• Written Test Script, Test Cases, Reported bugs and tracked defects using Quality Center.
• Used Informatica Power Center workflow manager for executing sessions and workflows.
• Used Informatica workflow monitor for monitoring workflows and reviewing session logs.
• Experienced in data integration, metadata management, ETL, data modeling tool sets
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Extensively test the reports for data accuracy and universe related errors.
• Used Toad to query and validate the data loaded into Oracle tables.
• Developed test cases and SQL queries for validating ODI mappings.
• Executed ODI jobs and tested target tables in Oracle database.
• Used Toad for data analysts and SQL server Management Studio to query SQL server.
• Report defects after reviewing test results and Track discovered defects and defect resolution in Quality Center.
• Worked with various EDI files, understanding of how to Drop, translate and Load them using various EDI editors and web tools
• Based on user requirements documented the test cases in Quality center.
• Developed test cases for SSIS packages and transformations using complex SQL queries.
• Executed SSIS packages and loaded target tables in SQL Server.
• Validated Stored Procedures using SQL queries involving joins and set operators.
• Executed SQL queries in SQL Server Management Studio for testing SSIS transformations.
• Validated SSRS reports like Drilldown and Crosstab reports using SQL queries.
• Tested SSRS report cosmetics like font, color and headers.
• Created and managed issues thru JIRA tracking tool.
• Discussed QA Testing requirements in QA Team walk through meetings.
• Developed shell script in UNIX and automated repeatable and regression test cases.
• Developed complex SQL queries for testing several ETL transformations.
• Executed ETL jobs and tested dimension and fact tables in semantic layer.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Tested several data mart tables in Oracle database using SQL and PL/SQL queries.
• Involved in extensive data validation using SQL queries and back-end testing
• Submitted weekly test execution and defect reports from ALM to project team.

Environment: Teradata 14, ALM/Quality Center 10, SSIS, T-SQL, SSRS, Informatica Power Center 9, JIRA, Oracle 9i, SQL Server 2008, SQL, TOAD, Unix.

Confidential

QA Tester

• Writing test plans and test scripts and complex SQL queries.
• Performed Requirement Traceability Matrix (RTM).
• Involved in functional, system, integration and performance testing.
• Recorded Testable and Non Testable requirements in spreadsheet.
• High Level Test Case Design and writing detailed test cases
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Involved in functional, system, integration and performance testing.
• Assigned defects to developers through Test Director.
• Updated defect status in Test Director.
• Involved in extensive data validation using SQL queries and back-end testing.
• Reported periodic project status and updates to the QA Lead and QA Manager.
• Involved in interacting with UNIX Shell scripts.
• Wrote the test scripts with respect to test cases to fix defects.
• Recorded Testable and Non Testable requirements in spreadsheet.
• Assisted in High Level Test Case design and writing detailed test cases.
• Used DDL, DML commands for testing backend database validations.
• Used Test Director for developing test cases.
• Used Toad for Oracle for querying Oracle database tables.
• Updated the defects status in Test Director.
• Reported periodic project status and updates to the QA Lead and QA Manager.

Environment: SQL, Oracle 8i, Test Director 8.0, MS Office, UNIX, Putty

Confidential

Manual tester

Responsibilities:

• egression testing upon the change control request feedback from clients.
• Reviewed and Analyzed the System Requirement Specs (SRS) and design documents.
• Analyzed the business requirements and wrote a Test Strategy and Test Plan.
• Was involved in the complete Software Development Life Cycle (SDLC)
• Created Test plans, Test Cases in Test Director as per the business requirements and executed them.
• Involved in writing and implementation of the various test cases and test scripts created for Functional testing using Win Runner.
• Involved in testing GUI applications in client/server system
• Test results and bugs are reported to the development team.
• Involved in System testing and Performance testing
• Interacted with developers, Business & Management Teams and End Users
• Interacted with programmers to identify and resolve technical issues
• Conducted integration, functional, Validation, Regression testing.
• Extensively worked on Test Director for bug reporting/tracking.
• Conducted R

Environment: JAVA, J2EE, Oracle, SQL, UNIX, Windows, Toad, Test Director, Manual Testing