SUMMARY:

• Over 8+ Years of professional experience in Information technology with progressive experience covering Quality Assurance/Testing, and Software Development in various Client Server environments and Web Based applications.
• Strong testing background that included reviewing system requirements, writing and executing Test cases.
• Experience in the field of information Technology as a QA Analyst and a QA Tester.
• Experience in Manual and knowledge in Automated testing using tools like Quick Test Pro (QTP), Winrunner, Load Runner, and Quality Center.
• Strong Knowledge of the Software Development Life Cycle (SDLC) and methodologies (Agile, Waterfall, V - model), and ensure Quality Assurance Control.
• Experience analyzing the requirements and Proficient in establishing QA Procedures, Standard Methods, and Business Requirement Document (BRD).
• Experience in developing Test Plans and Test Cases using the requirements and design documents while specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities.
• Exposure in testing GUI, Web based applications, and Client Server applications.
• Experience working on POS systems.
• Strong work experience Black box Testing.
• Experience in Functionality Testing, Regression Testing, System Testing, Integration Testing, Unit Testing and User Acceptance Testing.
• Working experience of Relational Databases like Oracle, Sybase,SQL Server,DB2, and MS-Access. Experience in Back-end testing using SQL queries on the above databases.
• Expertise in using bug tracking tools such as Bugzilla, TFS, Test Director/Quality Center and its features.
• Strong experience in Defect Tracking and Reporting.
• Documenting Test Documents using MS Office Tools- Word, Excel, and Power Point.
• Excellent Trouble shooting, Problem solving and Technical skills.
• Good Analytical skills, Presentation skills with strong communication skills, Effective Time Management and ability to work in a team or independently.
• Experience in Diversified business domains.
• Expertise in all the phases of quality project life cycle from requirements gathering and analysis, requirements, high level and detail level test planning and execution.
• Excellent Communication and strong Interpersonal skills with ability to work successfully as a part of team.

TECHNICAL SKILLS:

QA Methodologies: Iterative, Agile, Waterfall and Spiral Methodology

QA Tools: HewlettPackard(HP) - QualityCenter,TestDirectorIBM/Rational - Clear Quest 

ETL Tools: Informatica Power Center 8.x/7.x, Data stage 8.x/7.x, Ab Initio 2.x, SSIS

BI/Reporting Tools: Cognos, Micro Strategy, Business Objects, SSRS

DBMS Tools: TOAD, Embarcadero Rapid SQL, SQL Developer

Operating Systems: Microsoft Windows - Vista, XP, 2000, NT 4.0, OS/2 UNIX - Sun Solaris, HP-UX 

Databases: Oracle 10g,9i,8i Microsoft MSAccess,SQLServer2005/2008

IBM: DB2, DB2/UDB, Teradata V2R6, V2R5

Languages: SQL, PL/SQL, UNIX Shell Scripts, VB Script, Java, C

Version Control Tools: Clear Case, DOORS, Requisite Pro

PROFESSIONAL EXPERIENCE:

Confidential, Kansas city, MO

ETL Tester

• Analyzed the Requirements from the client and developed Test cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Performed Smoke Testing, GUI Testing, Functional Testing, Backend Testing, System Integration Testing, Sanity Testing, and User Acceptance Testing (UAT).
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Used Unix to run the graphs related to Abinitio
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Performed complex data validation using SQL queries.
• Written several complex SQL queries for data verification and data quality checks.
• Developed test plan with testing scenarios from the end user perspective for User Acceptance Testing (UAT).
• Used Data Stage Director to run/monitor the ETL jobs and tested the functionality according to data mapping requirements
• Worked on data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Preparation of System Test Results after Test case execution.
• Used Data Stage Director to validate, run and monitor the Data Stage jobs.
• Tested the ETL Informatica mappings and other ETL Processes (DW Testing). 
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Have tested reconcile and incremental ETL loads for the project.
• Tested data migration to ensure that integrity of data was not compromised.
• Wrote complex SQL queries for extracting data from multiple tables and multiple database.
• Used Rational Clear Quest as defect tracking tool.
• Before the Load is accepted to test, have performed smoke or shake-out test.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Done data validation for the Cognos reports.
• Tested reports in Cognos using Analysis studio, Report studio and query studio.
• Provided the management with weekly QA documents like test metrics, reports, and schedules. 

Environment: Oracle 10g, Data Stage 8.1, Informatica Power Center 8.4, Clear Case, IBM Cognos 8.0, Micro Strategy, Clear Quest, SQL, UNIX, Putty, TFS Defect tracking tool, Teradata V2R6, Session log files, Flat files, XML, XSD, XSLT, HP Quality Center, Web Services, SQL Server 2008,

Confidential, Seattle, WA

Sr. QA Analyst

• Developed and documented Standard Testing Procedures for both manual and Automated testing.
• Played a key role in developing overall quality processes, metrics collection and change management.
• Created manual Test Cases and Test Suite based of functionality in Quality Center.
• Constructed and performed Web-Testing Demos for Quick Test Pro to assist billing Dept.
• Developed and executed test cases and test suites for Functionality and Regression testing.
• Developed automated Test Scripts for QTP Scripts for Regressing Testing and User Acceptance Testing.
• Created End to End test Scenarios in the check out process such as Creating the account, Check out as guest.
• Created walk the site scripts in QTP which are scheduled to run on production everyday.
• Wrote PL/SQL scripts to verify the database updates, inserts and deletes of the records
• Used Load runner testing tool to execute the test programs.
• Executed test procedures and documented test results.
• Reported software anomalies in accordance with the internal procedures.
• Provided testing the GUI consistency against different browsers (running on windows) against various screen resolutions.
• Tested broken links, navigation, forms, printing and usability.
• Worked on data validation by accessing SQL tables by executing complex Queries.
• Analyzed complains and suggestions coming from customers and reproduced them for developers.
• Tracked defects using Quality Center Attended Bug-Review meetings

Environment: Quick Test Professional, Load Runner, Quality Center, PL/SQL, Test Director,TOAD, JAVA, XML, Oracle 8.0, Windows XP, Windows XP, SQL Server, MS Access, MS-Word, Ms-Excel, NT, Mainframes, Mercury QTP, CICS,TSO,UNIX

Confidential, Jessup, PA

QA Analyst

• Interacted with Business team to understand Business logic and User Requirements.
• Analyzed business requirements document and developed test plans, test objectives, test strategies, test priorities, test cases etc.
• Attended meetings to better understand the applications.
• Actively participated in System testing, Integration testing and coordinated UAT.
• Written and executed SQL queries to access database.
• Created traceability matrices.
• Performed API testing with different sub-systems.
• Extensive test data analysis between API web tools vs. database.
• Worked with parameterization and object repository in QTP.
• Responsible for Planning, Coordination and Implementation of QA methodology 
• Uploaded and executed Functional Test cases.
• During execution phase smoke, functional, black box, End to End, navigational and regression tests are performed.
• Organize the Test Data with the Business Analyst assistance for the Regression Testing.
• Coordinated the Defect Management Process during Test execution using Quality Center
• Coordinated with Business Analysts, System Analysts & Developers for defect analysis
• Used Rational Clear Quest to track and close Defects as and when Defects were Fixed

Environment: QTP 10.0, Java, SQL Server 2008, Oracle, Quality Center, Clear Quest, API tool, MS Excel, VB script.

Confidential, Atlanta, GA

Sr. QA Analyst

• Developed detailed Test Plan and Test Cases for the application manually through Quality Center.
• Gathered and analyzed data in support of business cases, proposed projects, and systems requirements.
• For every module followed the process of doing Analysis, Design, Produce, Unit testing and Integration testing.
• Involved in day to day SCRUM in an Agile environment meetings both on site and off shore teams providing the day to day updates on the testing schedules.
• Defects were tracked, reviewed, analyzed and compared using bug tracking tool Quality Center.
• Responsible in coordinating with the off shore QA team in developing the test cases, test plan and day to day test status for all the builds and releases.
• Executed automated scripts for smoke test on every build release using Quick Test Professional.
• Wrote SQL queries and validated data in the datawarehouse.
• Tested webMethods transactions with the outside vendor integration.
• Tested data flow to information factory via webMethods.
• Responsible in escalating the issues in the business templates, testing cycle to the business and development team on individual state for all the taxation functionality.
• Used to arrange meetings to discuss issues with developers and project managers.
• Worked very closely with developers to recreate defects found and also to verify fixes.
• Initiated and participated in Conference Calls, Walkthroughs and Reviews
• Meetings and involved in supporting Production Releases.
• Involved in Testing SSIS Packages, and also involved in Data Migration.

Environment: Quick Test Pro (QTP) 9.5, web Methods, Quality Center 9.5, Oracle, DB2, SQL, Microsoft Visual Studio Team Explorer, MS Office, Siebel, SOA, Java. J2ee.

Confidential, KS

ETL Tester

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Responsible to translate business requirements into quality assurance test cases 
• Review of test scenarios, test cases and Data warehouse Test Results. 
• Involved in testing Ab Initio graphs based on data mapping requirements.
• Developed test scripts using SQL queries to validate data.
• Prepared Regression Test Plans, Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Responsible in testing Initial and daily loads of ETL Ab Initio graphs.
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Planned ahead of time to test the mapping parameters and variables by discussing with BA’s.
• Have tested SSIS packages according to business requirements and data mapping requirement documents.
• Extensively used Quality Center to track defects and managed them.
• Tested several reports detailing price/volume trends and expense variance over previous periods by using financial reporting and through the Interactive Reporting.
• Extensively tested several Business Objects Reports for data quality, fonts, headers, footers, and cosmetics.
• Extensively involved in testing the ETL process of data sources Teradata, SQL Server, Oracle, flat files into the target Teradata, Oracle database as per the data models.
• Executed automated test scripts using QTP for Regression testing.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups. 
• Responsible for documenting the process for future references. 
• Responsible for in-depth knowledge of data, processes or applications in their specific area of responsibilities 
• Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment: AB Initio 2.13, HP Quality Center, Business Objects, Rational Clear Case, Rational Clear Quest, Web Logic, Quick Test Professional (QTP), SQL Server 2005, SSIS, SSRS, Linux, Win X

Confidential, MD

 QA Analyst

• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Responsible for testing the reports according to client’s requirement using Business Objects 6.5.1.
• Created Short-cut joins, aliases and contexts to make the universe loops free.
• A test reporting environment was established to combine Distribution Work Management and PeopleSoft information into a consolidated place to allow combined reports to be generated.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Tested and worked on creating open document reports for business.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select for testing Business Intelligence Reports with various boundary conditions.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Written complex joins to validate query performance on large database volumes and worked with business users for acceptable performance criteria for each query.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Validated format of the reports and feeds.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked with ETL group for understanding Ab Initio graphs for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designing and creation of complex mappings using SCD type II involving transformations such as Expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: Ab Initio (GDE 1.14, Co>Op 2.14), EME, SQL *Loader, Business Objects XIR2, PL/SQL, SQL, Stored Procedures, Test Cases, Test Scripts, Test Plan, XML, XSLT, XML Spy 2008, Oracle 10g/9i, SQL Server 2005, Erwin 3.5/4.1, Windows 2000, TOAD 7