SUMMARY

• 8 Years of focused experience in IT Industry with a strong back ground in testing of Client Server and Web based applications.
• Expertise in all phases of testing life cycle including Requirements gathering, Providing Estimates, Scheduling, Testing, Defect tracking, Management and Reporting from Inception to Implementation phases using Agile, waterfall methodology.
• Having good knowledge in Software Development Life Cycle (SDLC) & Software Testing Life Cycle (STLC) which includes Requirement Gathering, Data Analysis, Application Design, Implementation and Testing of various applications and Software development methodologies (RUP, Waterfall and Agile).
• Experienced in Unit, Functional, Integration, Regression, System, black box, GUI, usability, back - end, browser compatibility, Component, API and User Acceptance Testing (UAT) across varied domains and operating systems.
• Possess strong domain experience in Insurance, Health Care, Banking, Tele Communications, Production, Consumer Goods
• Worked in Agile SCRUM methodology of project development
• Extensive knowledge in gathering and understanding BRDs (Business Requirements Document), FRDs (Functional Requirements Document), SRS (System Requirement Specifications) and Used cases.
• Adept in using tools like Quality Center, Test Director, Quick Test Pro, SOAP UI, Rally, Itko LISA and Jira.
• Experience in all stages of testing namely GUI testing, Functional testing, Integration testing, AIT testing, System (SIT) testing, End to End testing and User Acceptance testing.
• Experience in Data Driven Testing using parameterization.
• Excellent knowledge in setting up Test environment and Test data.
• Superior analytical, presentation and documentation skills with both Technical and Non-Technical professionals.
• Experienced in creating/maintaining Test Logs, Summary Reports.
• Involved in writing UNIX shell scripts and used them to batch automated testing process.
• Good exposure to SDLC, Software testing life cycle and Bug Life cycle.
• Strong knowledge in life cycle of Data Warehouse using Data Extraction, Data Transformation and Data Loading processes (ETL) and having profound knowledge in Dimensional modelling techniques (Kimball and Inmon), Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).
• Expertise in RDBMS backend testing for data validation of the business rules to ensure data integrity using SQL Assistant.
• Experience in writing simple and complex SQL queries using TOAD, and Oracle SQL Developer/Navigator.
• Executed negative and positive test cases to test application functionality against user requirements.
• An excellent team member with an ability to perform individually with strong verbal, interpersonal and written communication skills.

TECHNICAL SKILLS

Test management tools: Mercury Quality Center 9.0/10.0,Rational clear quest,, Jira, Bugzilla

Automation Tools: iTKO LISA 5.0.28/7,SoapUI and QTP 9.2

ETL Tools: Informatica Power Center 9.1/8.6, Informatica Power Mart 5.x

Internet Tools: Java Script, VB Script, XML, .NET Framework, HTML, and DHTML

Requirement Management Tools: TFS, Microsoft SharePoint 2010

Databases: MSSQL Server, Oracle11g,10g,9i/8i, Access,DB2,COBOL

Database Tools: WinSql, Toad, SQL Developer

Packages: MS Office

Languages: TSQL, PL/SQL

Operating Systems: Windows NT/2000/XP/7/8 and UNIX, Shell Scripts

Data Modeling and Design: MS Visio

Reporting Tools: SQL Server Reporting Services (SSRS), Business Objects and Crystal Reports.

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

Sr. QA Analyst

Responsibilities:

• Reviewed and understand the User Stories/business requirement documents of various functionalities.
• Design and execute the Test Plans and Test cases using User Stories/Business requirements. Performed Sprint level testing, Functional, Systems Integration Testing and Regression Testing.
• Identified & organized the overall plan for test data, strategy and also identify the Scope of testing within the context of each Sprint.
• Good Experience in Agile methodology with SCRUM Process for the product development.
• Performed testing on multiple Sprints. Participate in Daily standup SCRUM meetings, Sprint Planning Sessions, Sprint
• Review and Sprint Retrospective Sessions.
• Created Test Cases and developed Tractability Matrix and Test Coverage reports.
• Prepared and provided status summary reports to the management on system status, system changes, problems and potential impacts.
• Interacted with developers, Business & Management Teams and End Users.
• Responsibilities included Test Planning, Test Case development and test script execution for Unit, Integration and System Testing.
• Participated in developing high-level System Test Scenarios and Full Cycle Test Scenarios
• Worked closely with Business Analysts to find out the gaps in functional requirements.
• Crated and maintained requirement traceability matrix to find out the gaps in requirement and test case coverage.
• Reported defects using Clear Quest and actively involved in presentation for discussing the defects.
• Run Smoke tests on QA environment for every build from development Team helped data migration team in testing the migrated data through back end.
• Involved in Custom Implementation projects Business Requirements Functional Requirements, Solution Proposal and design documentation reviews
• Worked closely with development team to discuss and priorities the defect fix.
• Experienced in testing the web services, SOAP, REST Frame Work, and SOA (Service Oriented Architecture) both manually and using iTKO LISA and SOAP UI tools.
• Created New scripts and Maintained in iTKO LISA work station
• Worked on Enhancement of scripts by adding datasets, filters and assertions for parameterization.
• Used Interactive Test Run Mode to playback the recorded/created test scripts.
• Created the test suites and staged them successfully.
• Experienced in preparing staging Documents in iTKO LISA.
• Experienced in Running test cases and test suites using iTKO LISA.
• Involving in QA / UAT / Production deployments by doing Shakedown testing
• Experience in Data Analysis, Data Validation, Data Verification and identifying data mismatch.
• Extensively executed Extraction Transformation and loading using SQL Queries on Oracle tables to verify the data for Back end.
• Performed database testing by writing PL/SQL queries.
• Interacted with development team for defect prioritization and resolution using Defect Tracking Tool JIRA.
• Participated in QA status meetings on a daily basis.
• Communicated defects encountered during regression test and follow up with developers until all issues were resolved.

Environment: Guidewire Policy Center,Java,J2EE, iTKO LISA 5.0.28/7, JIRA, Informatica Power Center,XML, SOAP UI, Oracle, DB2, SQL, TOAD, Mainframes, COBOL,CICS, JCL, Flat Files, XML, QMF for windows and MS Office.

Confidential, Bloomington, IL

Sr.QA Analyst

Responsibilities:

• Analyzed the Business Rules Documentation and specifications to gain a better understanding of the application.
• Involved in writing Test Scripts for Functional Testing, System Testing and Integration Testing
• Extensively involved in Manual/Functional Testing of the Web Based Applications.
• Involved in Executing System Testing
• Involved in Script clean up in system testing.
• Used QC for Bug Tracking and for functional Specifications and Test scripts.
• Involved in Test Data Creation
• Validated the Data in Back End by Writing SQL Queries in Oracle and DB2
• Created and executed test cases using Quality Center.
• Worked with development team to discuss the design and testing aspects of the application
• Reported the bugs, Email notifications to the developers using the Quality Center.
• Interacted with the Clients to perform Integration testing
• Performed data integrity and data validation by writing SQL queries in TOAD for RDBMS Oracle.
• Defect detection, reporting and tracking was done using rational clear quest.
• Participated actively in team meetings with Functional/Development Team for fixing the bugs

Environment: Quality Center 10.0,Java, J2EE, PL/SQL Developer 8.0.4, QTP 10.0,Oracle, DB2, Mainframes, MS Excel, Windows XP and MS Office.

Confidential

ETL Tester

Responsibilities:

• Conducted source-system data analysis to understand current state, quality and availability of existing data.
• Executed and scheduled tasks; batch processing, metadata management and data mapping.
• Responsible for setting timelines and reaching deliverables.
• Facilitated meetings with business users, Project Managers, and IT personnel.
• Responsible for data analysis, business/systems analysis; ETL process documentation; user requirements/ functional specs; technical specifications.
• Created ETL documents detailing the ETL (database navigation and data transformation) logic used by developers as coding specifications.
• Involved in development and implementation of test cases test plans test data and test scripts for customers.
• Created customized and adhoc reports for various campaign execution based on certain criteria.
• Scrubbed data to accurately generate customer pull. Provide output files in various file format based on customer request.
• Reviewed specifications for feasibility of customer list pull criteria and commit date.
• Executed Campaign based on customer request and reviewed execution log to keep track of the number of records going into and coming out of every job step.
• Created waterfall reports to show total lead pull, number of records dropped as result of each suppression or set of suppressions.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Followed company code standardization rule.
• Involved in various kinds of testing like functional testing, system testing and integration testing.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Extensively involved in performance tuning at source, target, mapping, session and system levels.
• Worked on generating reports using SQL Plus and PL/SQL. Worked on tuning SQL statements.
• Worked with T-SQL for validating the SQL Server 2000 data.
• Involved in preparing detailed Business Analysis documents, ETL design documents, unit test plans for the mappings.
• Involved in complete life cycle activities like pre-testing phase and testing phase.

Environment: Quality Center, Informatica Power Mart 5.1, Erwin, Visual Safe Source, SQL Server 2000, MS Excel, T-SQL, SQL, PL/SQL, TOAD, Test Director, Oracle 8i, Windows 2000, UNIX, Shell Scripting (Korn)

Confidential

Software Engineer

Responsibilities:

• Testing (System, Regression, Report, Performance).
• Ensure end to end Data Consistency and Integrity across different layers of Datawarehouse (DRA-Data Reception Area, DSA- Data Staging Area, and ODW- Orbit Data warehouse & ALD-Aggregate Layer Datamart) making use of ETL tool OWB.
• Perform duplicate, count, incremental data checks on source and target.
• Run ETL jobs on OWB (Oracle Warehouse Builder).
• Write complex SQLs to validate the transformation and data cleansing rules in Datawarehouse.
• Train project team members on technologies implemented & business functionalities in the project.
• In charge of testing developed software against specified requirements.
• Accurately monitoring and recording results in test documentation.
• Preparing detailed test plans, acceptance criteria and test scenarios for each project.
• Liaising with developers and programmers to swiftly resolve faults.
• Analysing, writing reports & communicating results to colleagues & managers.
• Monitoring the testing process and identifying and logging test failures.
• Performing peer reviews and estimates.
• Involved in Performance Testing, Scalability / Stress and Load Testing.
• Testing full product suite's, identifying problems & resolving them with the development team.

Environment: Java, Oracle, Toad, SQL/PLSQL, HP Quality Center, UNIX