PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in Software Testing of web based and Client - Server applications with full understanding of Software Development Life Cycle (SDLC).
• Solid experience of AGILE Methodologies, AGILE Manifesto and Scrum processes.
• Well versed in manual and automation testing.
• Contributed to all phases of SDLC methodology from requirements gathering through analysis, design, development, testing and maintenance.
• Expertise in Understanding and Analyzing Test Requirements, Tracking changes and maintenance of Test Requirements.
• Experience in developing Test Plans, Use Case, Test Scenario, Test Cases and Execution Summary Reports based upon the business requirements.
• Experience on Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing, Security testing, Smoke testing, System Integration Testing (SIT), Software Validation testing, Configuration testing, Interface testing, Stress and Performance Testing.
• Proficient in overall Defect Management/Problem solving including tracking bugs and reporting using Quality Center and JIRA.
• Extensive experience in testing reconciles (initial) and delta (daily) loads.
• Proficient in using Quality Center/ALM.
• Good understanding with Business Requirement Documentation (BRD), Functional Documentation and System Requirement Specification (SRS).
• Prepared Traceability Matrix for Test Coverage using QC.
• Proficient in System Testing, Integration Testing, Functional, Regression, GUI, Stress, Smoke Testing, End-to-End Testing.
• Performed Data validation testing and verification.
• Experience in Database testing by using Oracle & SQL databases, SQL, Joins, and SQL Queries.
• Worked on projects with SOA Architecture.
• Worked on web service testing using SOAP UI Tool.
• Good Exposure in testing SOAP Web services by using SOAP UI.
• Excellent Analytical, Problem solving, decision making and presentation skills. Can adapt to any newer technology or software at a greater pace. Able to define and fulfill the project’s goals.

TECHNICAL SKILLS:

Test Management/Automation Tools: HP ALM, Rally, SOAP UI, SharePoint, Subversion (SVN),JIRA, Cucumber

ETL Tools: Informatica Power Center 9.6.1, Ab initio 3.0

Web services: SOAP UI, RESTFUL

Version Control tool: Subversion (SVN)

XML Technologies: XML, XSD,WSDL,XPATH,DTD

Database: Oracle, SQl Server2005/2008,MSAccess,DB2,TOAD

Operating Systems: Windows Variants, UNIX, LINUX

Other: MS Office (Word, Excel, PowerPoint)

Job Scheduling Tools: Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Chicago

ETL Tester

Responsibilities:

• Reviewed project artifacts, analysed Requirements, designed the test plan and provided weekly status report that includes testing metrics, test logs and test summary reports.
• Performed Database Validation and Integration Testing using SQL.
• Validated reports for specific and aggregation accumulation data.
• Extensively involved in System testing / Functional, Regression testing and Integration testing.
• Prepared Test Cases for system testing and uploaded them into ALM; linked the test cases to the business requirements.
• Ran the manual test cases from Quality Center Test Lab.
• Wrote Complex SQL queries to support the test case results.
• Performed Negative testing using Informatica to find how the workflow performs when it encounters invalid and unexpected values.
• Performed Database (metadata) validation before loading the data in to the target tables.
• Performed Data Validation by testing the delta/daily and reconcile/data loads.
• Created SQL compare statements to validate Actual results with the Expected Results.
• Tracked and executed the User Acceptance Test Cases (UAT) with respect to the requirements to determine the feature coverage.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Verified ETL logs and reject/discard files for errors and reported them to development team.
• Worked on Informatica Workflow Manager to run the workflows and Monitored the status and logs in Workflow Monitor
• Provided support for Technical Integration and Prod Control teams for execution of ETL mappings.
• Written several complex SQL queries for validating Business Objects Reports.
• Extensively tested Business Objects reports for static/cosmetic errors like header, footers, logos, fonts etc which may appear in all pages of the reports.
• Smoke testing the new builds for QA-acceptance
• Responsible for defects management and driving to resolution and retesting the same.
• Estimated level of effort (LOE) for testing effort and reported to Test Leads.
• Performed Quality Assurance activities for data validation, data scrubbing, data profiling.
• Created shell scripts and used Unix commands to manipulate input files for test execution
• Created test data for all ETL mapping rules to test the functionality according to requirements.
• Used Rational Clear Quest for defect management.
• Ensured quality products delivered and installed as specified in the statement of work (SOW).

Environment: Informatica 9.6.1, SQL, PL/SQL, Oracle 11g, TOAD, Rational Clear Quest, Doors, Putty, VB Script, ALM, Autosys, UNIX,JIRA

Confidential, VA

ETL/Quality Analyst

Responsibilities:

• Prepared Test Strategy Document and Test Case Document, Requirements Traceability Matrix to map the requirements with their respective test cases.
• Designed and developed detailed Test Plans and Test cases which specify testing overview and testing approach depending on the Business and Technical Requirements.
• Executed the jobs through Autosys.
• Created the Autosys reports using JAWS tool.
• Performed Functional Testing, System Testing, Integration Testing, Regression Testing. Tracked and managed defects using Mercury Quality center.
• Worked on end to end executions using Autosys scheduling tool.
• Created data quality rules and tested the rules using informatica data quality analyst tool.
• Validated the messages using Confidential posted on the queue and topic.
• Monitored the job executions using informatica workflow monitor and verified the logs.
• Validated the data loaded into the target database.
• Developed and modified Unix Shell scripts to automate QA execution process in Test environment.
• Developed required SQL scripts for database testing and Performed Backend Testing, by executing the SQL queries. Wrote SQL Queries to extract data from the Tables.
• Analyzed tables and indexes for performance tuning, optimizing database objects and streamlining applications.
• Executed the Test Scripts on different releases and validated the actual results against the expected results.
• Developed automation scripts using Confidential and integrated the scripts with master script.
• Involved in the automation of the Regression suite execution using Confidential .
• Involved in User Acceptance Testing by providing test data for users and by testing UAT defects in test environment before, the new code gets moved to UAT environment.
• Created test Execution Report, Test Completion Report for Test Sign Off, documented the testing process and Test evaluation summary.
• Involved in Code Review, Design Review, Test Case Review meetings with business analysts and developers.

Environment: Informatica9.5.1, ALM, Autosys, JAWS, Sybase, Oracle 11g, Toad, IDQ Analyst, Confidential, UNIX, Rational Clear Quest, Doors.

Confidential, NY

Junior Test Analyst

Responsibilities:

• Worked on Developing, executing and maintaining Test Plans, Test Scenarios, and Test Cases Documents in ALM (Application Lifecycle Management) based on business requirements.
• Involved in designing the Confidential scripts using Manual Test Cases
• Developed the share repository using Confidential Object Repository Manager
• Testing process involved daily test activities through Agile Scrum 'stand-up' meetings.
• Created and executed the test cases for various scenarios, and participated actively in system, integration, performance and regression testing for every new build released.
• Used ALM to develop test cases, and executed them in test lab.
• Created the UAT Test Plan by entering high-level requirements from the Statement of Need and Functional documents, as well as identified test scenarios, into the UAT Test document.
• Ensuring the execution of UAT Test Cases and documentation of test results.
• Entered the defects into ALM and manages the resolution and documentation of these defects.
• Performed Development Integration, System Integration, End to End and User Acceptance Testing for the data services.
• Good in database testing by using SQL queries retrieved the data from database for data validation.
• Performed happy path and unhappy path testing scenarios.
• Creating test case and test sets, tracing them to requirements and executing them in ALM.
• Analyze all Report Bugs for continuous process improvement and keep tracking on the SDLC critical path.
• Used SOAP UI to validate the response of web services with the data in Host.

Environment: Oracle11i, Manual Testing, Quality Center, TOAD, CLEARQUEST, Windows 9x/N2000/XP, MS Office Suite, HTML, CSS, XML, Web Services.

Confidential, St Louis, MO

Junior Test Analyst

Responsibilities:

• Responsible for analysing business requirements and business rules.
• Written Test Scenarios and the Test Cases as per the Requirement documents and High level design documents.
• Created, maintained and executed the test scripts.
• Identified the testing scenarios as per business needs of the application.
• Involved in the Back-end testing by writing and executing the SQL queries using Oracle DB.
• Identified the bugs in the application and reproduced them.
• Participated and involved in weekly project status meetings, team/management meetings, performed Internal Review, Tech Reviews.
• Responsible for Black box testing, GUI, System, Regression and User Acceptance Testing.
• Participated in meetings with Developers on Change requests, Critical issues, and modifications.
• Documented the bugs and worked with developers to eliminate the issues in the application, and track and report the issues in a timely manner within the deadlines.