SUMMARY

• 8 years of experience with Quality Assurance Methodologies & Testing of Web based and Client - Server applications.
• Experience in Auto, Finance, Tax & Audit, Telecom industry domains.
• Well versed with Waterfall, Agile iterative and onsite offshore development methodologies.
• Lead and execute test cases for functional, system integration, Regression, End to End, Smoke Testing and create defects, manage defects, shell, and writing UNIX, SQL scripts to aid testing.
• Extensive experience in developing Test Plans, Test Cases, Test Scenarios, Test Scripts, Test Reports.
• Reviewing approaches, participating in test Plan walkthroughs, prepare test plans for functional testing, and system integration testing.
• Extensively used defect-tracking Tools like Test Director, QC ALM, TFS, RallyDev.
• Strong analytical and product management skills including a thorough understanding of how to interpret business needs and translate them into application and operational requirements.
• Very good experience in BVA & Equivalence Partitioning testing for various calculations like Tax, Interest, Benifits.
• Solid knowledge and experience with data flow process and procedures.
• Experience in conducting Data Warehouse/ETL/BI testing with working knowledge of IBM Datastage 8x including understanding of dimensional data models and source/target mapping.
• Experience in relational databases like Oracle 10g, SQL Server and DB2. Extensive experience in testing applications and products developed using Java, J2EE, .Net, CSS and Java Script.
• Worked closely with end users and Business Analysts, SMEs Project Managers, Product owners, Developers to understand requirements, and business processes.
• Extensive testing experience in several web based, Client server and Data warehouse applications.
• Experienced on UNIX and Windows environments
• Worked independently and in teh team environments with high self-motivation.
• Excellent written and verbal communication skills including teh ability to discuss issues and concepts with technical and business personnel.

TECHNICAL SKILLS

Operating Systems: Windows, Linux, Unix, OS/400

Testing Tools: Mercury Win Runner, QTP, Test Director, Quality Center 9.1, TOAD, Putty.

Programming Languages: C++, Java, .Net, SQL, PL/SQL, RPG/400, COBOL/400, CL/400, XML.

Tools: .NET Framework, XML, Microsoft Visual Studio, VSS, CVS, HTML, DHTML, AbIntio, Datastage 8x

Relational Databases: Oracle 10g, MS SQL Server, DB2 UDB, DB2/400, MS Access.

Application Servers: Web Sphere 6.x, Web Logic, Tomcat 5.x

PROFESSIONAL EXPERIENCE

Confidential, ATLANTA, GA

Sr.QA Analyst

Responsibilities:

• Experienced in Agile software development approach of web based applications, analyzing and testing data flow process/RDBMS systems.
• Worked as onsite off shore coordinator.
• Involved in CRM application End to End testing.
• Preparation of test plan and test cases from teh User stories.
• Design and execute test cases based on written requirements, documented designs, data relationships, and business or data scenarios.
• Interacting with Product Owner, Scrum Master and Team Members (BA, DEV, QA, DBA, and Infrastructure) to develop teh complete understanding of teh business needs.
• Reviewing approaches, involved test Plan walkthroughs, prepare test plans for End to End testing
• Check and review teh test case documents and place them in Rally Dev
• Escalate issues in teh application to teh Dev/Defect manager / Product Owners.
• Reporting testing activities test results and test case coverage and update them in Rally Dev.
• Writing SQL queries for testing data Confidential back end and executed teh SQL scripts for end to end testing.
• Created test cases to test database interactions and verify data accuracy and validations.
• Interacted with business team to resolve business issues and investigated software faults for every iteration and release
• Involved in Sprint scoping calls, Scrum and retrospective meetings.

ENVIRONMENT: Agile, Onsite off shore model,.Net, Java,, MS SQL server 2008 R2, MS SQL Server Management Studio, SQL Developer, SOAP, XML, Oracle 10g, ALM QC, Rally Dev.

Confidential, ATLANTA, GA

QA Testing Engineer

Responsibilities:

• Experienced in Agile software development approach of web based & client server applications.
• Analyzing and testing data flow process/RDBMS systems.
• Developed requirements specifications according to standard templates, using natural language.
• Ability to complete testing to deliver high-quality, complex projects on time, on budget, and to specification.
• Preparation of test plan and test cases from teh business requirements.
• Design and execute test cases based on written requirements, documented designs, data relationships, reasonability and business or data scenarios.
• Analyzing and review requirements to write test cases
• Interacting with Product Owner, Scrum Master and Team Members (BA, DEV, QA, DBA, and Infrastructure) to develop teh complete understanding of teh business needs.
• Reviewing approaches, involved test Plan walkthroughs, prepare test plans for functional testing, and system integration testing
• Check and review teh test case documents and place them in Share Point server
• Escalate issues in teh application to teh Dev/Test manager / Product Owner or posting in TTP Work space (Project Issues).
• Reporting testing activities test results and test case coverage and update teh TFS system.
• Conducting BVA (Boundary value analysis) and Equivalence Partitioning testing for tax calculations of various regions.
• Document and execute Functional, System, Integration, Regression, Performance and UAT testing processes create defects, manage defects.
• Worked on citrix environment.
• Writing SQL queries for testing data Confidential back end and executed teh SQL scripts for end to end testing.
• Created test cases to test database interactions and verify data accuracy and validations.
• Identifying Test Cases to be run for Regression Testing and conducting Regression Testing as and when new builds or functionalities were made.
• Interacted with business team to resolve business issues and investigated software faults for every iteration and release
• Involved in Sprint scoping calls, Scrum and retrospective meetings.
• Track milestone and come up with mitigation alternatives for issues and design gaps.
• Maintained healthy interaction and collaboration with team members and business partners

ENVIRONMENT: Agile, .Net, Java, QTP 10.5, MS SQL server 2008 R2, MS SQL Server Management Studio, XML, Oracle 10g,Toad, TFS (Team Web Access 2010).

Confidential, CHICAGO, IL

QA Tester (Data warehouse)

Responsibilities:

• Analysis of data flow process/procedures/systems.
• Strong ETL knowledge with IBM Datastage tool experience.
• Involved in data warehouse/reporting/ETL/ELT, including understanding of dimensional data models and source/target mapping.
• Worked in data warehouse development cycle methodology.
• Testing data transformations (Reformats)
• Performed testing to validate dat data is being migrated correctly through teh various phases from source, to cleanse, staging and ultimately target.
• Converting specifications from User Stories into testable requirements
• Created teh detailed test plan and test cases from teh business requirements document and interfacing with Business Users.
• Interacted with business analysts, project leads, and developed complete understanding of teh business needs.
• Escalate issues in teh application to teh test manager / client
• Reporting testing activities test results and test case coverage
• Involved in Designing and Developing validations and test plan documentation
• Created test cases to test database interactions and verify data accuracy.
• Involved in System Testing. Created teh System Test Plan and multiple test scripts
• Conduct Peer Reviews and Walkthrough sessions with testing and technical team members and maintained a positive relationship.

ENVIRONMENT: Agile, Java, .Net, IBM Infosphere DataStage 8.5 (ETL Parallel Extender), Business Objects, AIX, UNIX, Oracle 10g, DB2, Autosys, Clearcase, Quality Centre.

Confidential, MI

Quality Analyst

Responsibilities:

• Involved in data warehouse and business intelligence environment
• Analyzing Physical Data Models and Logical Data Models
• Highly proficient in building complex SQL statements involving all join variants to enable them to make robust comparisons of source versus target data loaded by teh ETL
• Analysis of data quality, data profiling, and dimensional modeling designs.
• Worked on relational database design. Ability to interpret and understand database schemas to ensure database integrity.
• Involved in manual testing of teh UAT Confidential various phases of software.
• Worked on development life cycle such as Unit Testing, Functionality Testing, Integration Testing and Regression Testing
• Experience in testing applications in various components like Database, Datasets, FTP, Sort and Validate.
• Documented teh Problem Reports (PR) for all teh bugs detected and tracked teh bug fixing process until they were closed
• Scripts to check teh data consistency, ETL (Extract Transform and Load) process, data integrity in teh application and database as data was fetched from different databases.
• Worked closely with developers, Business Analysts and SMEs to resolve technical and functional issues.

Environment: Java, .Net, Tomcat, Datastage 7x, Oracle9i, Mercury Quality Center 9.1, JUnit, Windows, UNIX

Confidential, Salt Lake City, Utah

QA Engineer

Responsibilities:

• Created detailed test plan and test cases from teh business requirements document and interfacing with Business Users.
• Analyzed and reviewed business requirements to prepare test cases
• Interacted with business analysts, project leads, and developed complete understanding of teh business needs.
• Escalate issues in teh application to teh test manager / client
• Reporting testing activities test results and test case coverage
• Involved in Designing and Developing validations and test plan documentation
• Wrote SQL queries to compare data with teh source databases (using TOAD) during teh testing process
• Worked on citrix environment to connect server remotely
• Tested teh application with Junit frame work on methods and packages
• Conducted functionality testing and GUI testing using QTP
• Identifying Test Cases to be run for Regression Testing and conducting Regression Testing as and when new builds were made.
• Involved in reviewing Test Plans and Test Cases
• Manually implemented several test scripts and documented teh results
• Used Quality center to report bugs in teh Application.
• Performed system testing, integration testing, GUI testing on each build

Environment: Agile, Java, .Net, Tomcat, Tandon database, Oracle9i, QTP 9.1, Mercury Quality Center 9.1, JUnit, Citrix, Windows, UNIX