PROFESSIONAL SUMMARY

• 7 years of IT experience with emphasis onQuality Assurance in Manual testing on web based applications, Data Validation, Data Analysis, Data Quality and Data Warehousing testing experience. .
• Good understanding of Software Development Life Cycle, Testing Methodologies and Testing Life Cycle
• Proficient in analyzing and translating business requirements to testing requirements and creation of Test Specifications, Test Scenarios and Test Cases.
• Experience in Black-box testing and White-box testing
• Strong in writing SQL queries for data verification and backend testing
• Expertise in identifying defects and Bug tracking
• Good working experience with Business Intelligence tools Cognos & Micro Strategy
• Excellent debugging and problem solving skills
• Extensive experience working with Cross Functional Teams
• Excellent communication and interpersonal skills, self starter, quick learner, team player

TECHNICAL SKILLS

Testing Tools : Mercury QTP, Quality Center,Load Runner
ETL : Informatica Power Center
Reporting Tools : Cognos, Micro strategy, OBIEE
Scripting Languages : HTML, JavaScript, VBScript, SQL, XML, CSS
Web Servers : Web Sphere, IIS, Apache, Web Logic, VMWare
Defect Reporting Tools: Quality Center, Rational Clear Quest, Jira
Database : Oracle 9i/10g/11i, Sybase, DB2, SQL Server2005, Teradata
Operating Systems : Windows 9x/NT/XP, Vista, UNIX
Office Applications : MS Office (MS Word, MS Excel, MS Paint, MS Project, MS Outlook), Eudora, MS Visual Source Safe, Visio

PROFESSIONAL EXPERIENCE

ETL Tester Confidential, West Chester, PA
Sep 2010 to Present

• Reviewed the Business requirement documents and developed test plan, test scenarios and detailed test cases.
• Participated in business requirement walk through, design walk through and analyzed Business requirements
• Worked with Development team and Business Analysts to analyze test scenarios and ensure that test cases are correct and complete.
• Involved in Code review meetings.
• Monitored the Informatica workflows using Power Center monitor, Checked session logs in case of aborted/failed sessions
• Performed Verification, Validation, and Transformations on the Input data before loading into target database
• Performed Full Load and Incremental Load Data Validations
• Used SQL Assistant tool to connect to Teradata Database to validate data that was populated by ETL applications
• Data validated between Source and Target by using DCB studio tool
• Load target Teradata tables and validate using SQL statements
• Worked on Quality Center to execute test cases, log defects and track resolution till the closing of defect after retesting
• Participated in review, Scrum, Defect and status meetings

Environment: Informatica Power Center 8.6, DCB Studio, AMDOCS, CSG, Oracle 11g, Toad, Teradata, SQL Assistant, UNIX, Golden Gate

ETL & Report Tester Confidential, Chicago, IL
May 2010 to August 2010

• Reviewed the Business requirement documents and developed test plan, test scenarios and detailed test cases.
• Test Cases were incorporated both positive and negative test conditions.
• Performed System, Integration, Regression and Performance Testing
• Used Bugzilla for Defect Reporting and Defect Tracking
• Tested Source and Target validations.
• Written and executed SQL queries on database using TOAD to verify the report values
• Participated in review, Scrum and status meetings
• Tested different types of Reports
• Performed Functional and Load Testing on Reports

Environment: Informatica Power Center 8.1, Micro Strategy 9, DART, Bugzilla, Load Runner 9, Oracle 11g, Toad, Windows XP

ETL & Report Tester Confidential, Glendale, CA
Sep 2009 to Apr 2010

• Reviewed the Business and functional requirement documents and prepared test scenarios.
• Created detail Test cases for each Subject Area.
• Test Cases were incorporated both positive and negative test conditions.
• Worked with Development team to create a suite of test data to exercise data validation and actual ETL functionality.
• Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage in the Mercury Quality Center.
• Executed Test cases and Submitted Defects in Quality Center.
• Good experience in testing Source and Target validations.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful
• Performed System, Workflow Integration, Regression and Performance Testing
• Good experience in coordinating with offshore team
• Written SQL Queries and executed them using Squirrel
• Participated in review, Scrum and status meetings
• Tested different types of Reports

Environment: Informatica Power Center 8.1, Micro Strategy 9, HP Quality Center 9.2, Sybase, DB2, UNIX, Windows XP

QA Engineer Confidential, Round Rock, TX
Sep 2008 to Jun 2009

• Reviewed and analyzed the requirements to understand the functionality of the application and prepared Test Plan and Test Cases.
• Interacted with developers and users to understand the functional specifications, Business rules and work flow of the project
• Performed Smoke, Functional, Integration, Regression, Browser Compatibility(IE, Firefox, Netscape) on the application
• Created and executed SQL Queries for Back-end testing
• Responsible for identifying, reporting and tracking defects using Quality Center.
• Actively participated in Defect Review Meetings and Weekly Status meetings.
• Maintained IT standards regarding documentation and testing
• Created Periodic Status Reports and Test Metrics and reported to the manager
  

Environment: C#, .Net, Java, Oracle 11i, TOAD, IBM Main Frame Tandem, HP Quality Center 9.2, XML, HTML, HTTP, HTTPS, Windows

QA Engineer Confidential, San Diego, CA
Oct 2007 to Aug 2008

• Reviewed the Business Requirements document, System Design document and prepared the Test Plan.
• Identified and preparedtest cases in HP/Mercury Quality Center
• Participated in Design review meetings and Weekly Status Meetings
• Performed Functional, Integration, Regression and End-To-End testing
• Performed Positive, Negative and Adhoc testing
• Performed database testing for verification of data integrity
• Implemented the automate test suite for regression testing using Descriptive Programming in Quick Test Pro
• Identified and submitted defects in defect tracking tool JIRA
• Reported Test Execution status to the manager on daily basis

Environment:Java, Adobe Flex, Jira, Quality Center 9.0, QTP 9.2, SQL Server 2005, MS Excel, MS Word, HTTP, HTTPS, Unix, Windows XP

Software Tester Confidential, India
Mar 2005 to Jun 2007

• Involved inFunctional Testing, Regression and Integration Testing
• Performed back-end testing using SQL queries for data validations
• Logged & Tracked Defects using Test Director.
• Carried out Integration tests to check the interfacing between sub modules
• Ensured that all Change Requests and defects are tested and approved before the release.
• Worked with customers to develop user acceptance tests

Environment: Test Director, UNIX, Java, J2EE, Java Script, HTML, XML, PL/SQL and Oracle8i

EDUCATION

• Bachelors.