SUMMARY

• Over 7+ years of IT industry experience with good understanding of Client - Server and Web based applications, Software Design and Development, Quality Assurance, Manual and Automated Software Testing, writing test plans, test strategy, test cases and generating test scripts using Automation Tools in various Data Warehouse, Business Intelligence, Packaging Applications, Datamarts and ETL for clients in major industry sectors like Retail Sales, Pharmacy, Insurance, and Finance.
• Over 7 years of extensive experience with Quality Assurance / Quality Testing on GUI based Client-Server, Web Based & Data Warehouse applications using Manual and Automated testing procedures.
• Involved in the full life cycle of the data warehouse building process including architecture design, dimensional modeling, ETL and reporting primarily using Informatica and Business Objects.
• Experience in writing, testing and implementation of the triggers, Procedures, functions Confidential Database level and form level using PL/SQL.
• Authoritatively documented GUI client-Server and web testing methodology for successful QA Testing, Planning, Implementation and Management.
• Developed, Documented and Executed Test cases manually and generated Automation Scripts using Quick Test Professional, Quality Center to ensure proper business compliance and worked closely with users and business analysts, Project Managers, Developers to understand requirements, business processes for testing and attended regular walkthroughs.
• Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirement.
• Strong Experience in Manual and Automation testing using automation tools.
• Highly proficient in Mercury Interactive Testing Tools (Quick Test Professional (QTP 9.0/9.1/9.2), Quality Center, Rational Functional Tester, Rational Test Suite (Clear Quest, Rational Test Manager) & Selenium).
• Expertise in tracking the Defects using the Test Defect Tracking Tool and reported the bugs in the Quality Center & Clear Quest.
• Used Mercury Quality Center to manage the test cases and for defect tracking.
• Experience in System tests, Integration Testing, Regression Testing and Performance/Load Testing.
• Involved in gathering requirements, developing Test Plans & Test Cases using specifications and design documents.
• Experienced in Database Testing using interfaces like TOAD and SQL Navigator.
• Experience in Integration, Functional, Performance, Regression, System, User Acceptance, and Load & Stress testing.
• Knowledge of complete software project development life cycle.
• Interacted with Business users regarding Business Requirements.
• Experience in testing Windows based applications, Client/Server (2-Tier), Multi-Tier, Web Based applications, Communication Industry applications, financial applications and Commercial Stand-Alone applications.
• Possess problem-solving skills, ability to follow industry standards and procedures.
• Working knowledge of RDBMS in ORACLE 8i/9i/10g and SQL SERVER 2000/2005.
• Expertise in Windows & UNIX Operating System platforms.
• Proficient in SQL and PL/SQL Programming for testing database integrity.
• Ability to work in a team environment. Strong communication and interpersonal skills.
• Ability to interact with customers with ease and professionalism.

TECHNICAL SKILLS

Testing Tools: QuickTestPro 6.5, Test Director 7.8/8.0, Silk 6.5, Rational functional Tester 8.0 LoadRunner 7.8/8.0

Operating Systems: UNIX, Windows NT/95/98/2000/ME/XP

ETL Tools: Informatica Power Mart 4.5.2, 4.7.3 and 5.1.1Power Center 1.7 and 5.1.2

Data Analysis and Reports: Business Objects v 5.1

Web Applications: HTML, DHTML, XML 1.0, XSL, IIS 4.0, JSP, ASP 2.0

DBMS: Oracle 8.x, MS SQL Server, MS Access. b Servers WebSphere 5.1, WebLogic 5.3

Languages: TSL, VB Script, Java Script, JDK 2.0, Java 1.2, SQL, PL/SQL, C, Shell, python

ERP Packages: Peoplesoft version 6.0. (People Tools, People Code & HRMS Module)

Packages: AutoCAD R -13, 14, MS Office 2000/XP.

Front Ends: Visual Basic 5.0/6.0, Developer 2000, Flash macromedia, Python QT.

Internet Tools: VB Script, Java Script, Active Server Pages 2.0, and HTML.

Job Scheduling: CONTROL-M & AnthillPro

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr.QA Analyst

Responsibilities:

• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
• Formulate methods to perform Positive and Negative testing against requirements.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, and User Acceptance Testing (UAT) and Data validation testing.
• Coordinated all QA activities and enhancements using Agile Methodology.
• Executed and managed test cases and reported bugs in Quality Center.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Conducted End-End testing manually.
• Extensively tested Graphical User Interface (GUI) Components.
• Developed and executed automated test case using VB Scripts in QTP for the Front-end-applications. Conducted Data Driven testing by passing parameter from excel files
• Analyzed the defects and categorized them based on severity using Quality Center 10.0.
• Wrote extensive SQL queries for data creation, data validation, and data mining migration during testing phase.
• Used Simple and Complex SQL Queries like Joins, Select, and Update for data validation and data manipulation.
• Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
• Responsible to send the Data Warehouse Quality report to the QA manger on weekly basis for Caliber data mart.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.
• Involved in defect tracking, reporting and coordination with various groups from initial finding of defects to final resolution.

Confidential, Lincolnshire - IL

QA Analyst

Responsibilities:

• Performing GUI, Functional, Integration and Regression testing manually.
• Involved in writing the test conditions, test data, test cases using Functional Specifications.
• Involved in developing functional libraries.
• Automated the manual test cases using the Quick Test Pro (QTP) and Shell scripts.
• Performed Ad-hoc testing and Regression testing.
• Execution of master test suites on various windows flavors
• Involved in writing shell scripts.
• Environment Readiness for UAT.
• Data conversion, gathering business requirements from End Users and Creating Logical Data Models.
• Tested repository using Informatica Repository Manager
• Tested source definitions using Informatica PowerMart Source Analyzer.
• Tested reusable transformations using Informatica PowerMart Transformation Developer.
• Tested manual target Creation using Informatica PowerMart Warehouse Designer.
• Tested and edited mapplets using Informatica PowerMart Mapplet Designer.
• Validated the Imported and Exported mappings and mapplets to and from the repository.
• Tested the source to target mappings that contain the business rules for the server during the extract, transform and load process using Informatica ETL Tool.
• Verified schedules and monitoring sessions using Informatica Server Manager
• Verified very often, the Source to Target Field Mapping Report, this contained transformations, expressions and descriptions in a mapping for documentation.
• Prepare the test plans for the comprehensive end-to-end testing of the application.
• Prepare the manual test cases for all types of tests, from sanity to regression level.
• Performed manual Regression testing on different versions of the application.
• Perform unit, functional, cross platform, integration and system testing manually.
• Perform Environment set up/Test Data
• Perform Environment Readiness-Create isolated Environment for system test.
• Coordinated with the developers to fix the problem and enhancing the application delivery process.

Environment: DB2, Java 2.0, J2EE, JSP, Java Script, Mainframe, UNIX, Change Control, Oracle, VB,VB Script, Struts and Windows XP Environment, SAS & QTP.

Confidential, Dubuque, IA

QA Engineer/Analyst

Responsibilities:

• Performing GUI, Functional, Integration and Regression testing manually.
• Involved in writing the test conditions, test data, test cases using Functional Specifications.
• Detecting bugs & classifying them based on the severity.
• Participated actively in the team meetings with the Developers for fixing the Bugs.
• Performed software compatibility tests manually on various platforms.
• Involved in Benchmarking Testing.
• Recording & Scripting and executing the scripts using Win Runner.
• Parameterized test scripts in Win Runner with necessary values.
• Performed Data Driven Testing and end-to-end testing.
• Performed functionality of the Web page objects such as HTML Links etc.
• Created and executed Functional, Security, and Navigation and Usability Test cases manually.
• Providing Screenshots to identify & reproduce the bugs.
• Prepared Traceability Matrix, Test Metrics.
• Analyzed performance results and verified with the development team.
• Performed performance manual tuning for the system applications.
• Update or produce documents to be used by end users.

Environment: MS Visual C++, ASP 3.0, MS SQL Server, MS Visual Source Safe 6.0, Macromedia Flash player, Python QT, Windows 95/98/NT/2000/ME/XP, Test Director 7.6, Silk 6.5,Quick test Pro 5.6, Win Runner 7.5 and Load Runner 7.5.

Confidential, Hoffman Estates, IL

Responsibilities:

• Involved in creating the requirement documents from the FDS and BFS documents.
• Develop the test plans Test specifications and test strategies for manual testing.
• Performed manual Regression testing on different versions of the application.
• Perform unit, functional, cross platform, integration and system testing manually.
• Performed Regression testing and Integration testing.
• Developed tests with 4TL and added functions and logic to recorded tests.
• Co-ordinate with developers and the testing team to resolve the discrepancies.
• Perform database and backend testing.

Environment: Silk suite for the stress testing, VB 6.0, Oracle 8i, Informix, Lotus notes for bug tracking and Email, mainframe, UNIX, Epiphany Suite and Windows NT.

Confidential, Richmond, VA

Programmer /Analyst

Responsibilities:

• Involved in modifying and developing the Test Plans, Test specifications and Test cases.
• Executing the Test Cases manually and anomaly reporting them through Test Director.
• Performed Unit/stress testing/Regression testing and then performed Integration testing manually.
• Suggested Enhancements in the application according to the Users view and Complaints with Quality standards.
• Co-ordinate with Developers to fix the problem and enhancing the delivery process
• Executed system testing manually.
• Up gradation of the mobile terminals and applying restriction on the users.

Environment: Test Director, Visual Basic 6.0, Oracle 8i, Tandem, Windows 95/NT/2000.

Confidential

Responsibilities:

• Involved in modifying and developing the Test specifications and Test cases.
• Executed the Test Scripts manually and anomaly reporting them through Test Director.
• Performed manual Unit/stress testing and then performed manual Integration testing.
• Generated Test Cases in Microsoft Excel Sheet to be data driven.
• Load Runner is being used to test the performance/load of the application.
• Suggested Enhancements in the application according to the Users view and Complaints with Quality standards.
• Co-ordinate with Developers to fix the problem and enhancing the delivery process.

Environment: Test Director, Win Runner Load Runner, Tandem, Oracle, HTML, Jscript, VB, ASP Windows 95 and Windows NT.