Quality Assurance Testing

Deepa Selvaraj

469-***-**** **************@*****.***

Professional Summary

Software Quality Assurance Analyst with over 7+ years of diverse Information technology experience in various domains like Transporation, Education, HR and Finance with emphasis on GUI Automation Testing, Manual Testing, Black Box Testing, Backend Testing,Web services testing of Client/Server and Web based applications,ETL Testing.

• 7+ years of consummate IT experience in complete SDLC and STLC

• Strong analytical, problem- solving and communication skills with particular emphasis on clear, detailed Functional Specifications, as well as reports for management.

• Excellent understanding of the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

• Experience in developing and writing test scenarios, test cases and process flows.

• Expertise in performing Manual testing and Database Testing .

• Involved extensively in Functional, Integration, Regression, WhiteBox, BlackBox, Re-testing, UAT, Smoke testing , Unit Testing.

• Experience in participating and reviewing Business Requirement , Functional Specification and Technical Specification documentation calls.

• Tested Web services for the portal application to ensure all of the components are

• working as per the requirements.

• Prepared Test Strategies , Test plans for small, medium and large applications and running thru the project towards a successful closure.

• Experience in High level Documentation,and test data preparation and Testing Methodologies and implementing in SDLC Life cycle process.

• Good understanding of Data Warehousing concepts and ETL (Extraction, Transformation and Loading) tools like Informatica and Data Stage.

• Experience in Datawarehouse Testing (ETL Testing, Cognos Report Testing).

• Extensive experience in executing Unix Shell Scripts for automation of ETL Process.

• Thorough understanding of Normalization, Demoralization, Data Object Modeling - Entity Relationship Diagrams.

• Strong working experience on Testing Data Warehousing applications, directly responsible for Testing Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse.

• Experience in IBM Tivoli Maestro Schedule Tool.

• Strong understanding of database concepts including RDBMS, data warehousing and data marts.

• Experience in Test Management tools like Quality Center 9.2, Jira, Bugzilla,Test Director.

• Experience in Web servers, Databases (MS-SQL Server,Oracle,Firebird Database)

• Experience in Unix Commands and scripting.

• Exposure to Automation tools like QTP and Load Runner.

• Experience in testing various database applications involving Oracle 8i/9i, SQL Server, and MS- Excel.

• Performed Lead Position for attending daily status meeting with client and sending status report.

• Wide knowledge in SOAP, XML, WSDL, XML Schema.

Education

• B.E (Computer Science) Engineering from Adhiyamaan Engineering College, India.

• Certified ANIIT – NIIT Ltd, India.

Technical Skills

Testing Tools : Quick Test Pro 9.5,Load Runner 9.5

Languages : Oops Basics (C++), PHP

OS : Windows XP, LINUX and UNIX

Databases : Oracle, MS Excel, MS SQL Server and Firebird Database

Scripting : UNIX Shell Scripting, HTML, XML

Management Tools : HP Quality Center 9.2/9.0, Excel, Word, Power Point,JIRA, Bugzilla.

Datawarehosue Tool : Cognos , Informatica Power Center,Toad

Scheduler : IBM Tivoli Maestro Scheduler

Professional Experience

Ericsson Inc – Plano, TX June 2009 – Present

Role: Senior Quality Assurance Analyst

Corporate Data Warehouse provides the Finance, Marketing and Sales related data to business for daily reporting needs. Business data from various source systems are Extracted, Transformed and loaded into oracle data mart using Informatica power center as ETL tool. Business creates Cognos reports from the Data Warehouse and which drives the Business critical decisions.

Responsibility:

• Studied the User requirement prepared by the technical User to evolve the technology architecture for the project.

• As QA involved in gathering business requirement, Studying the application and collecting the information from developer and writing the system and user acceptance test plan, designed the requirement using MS-Excel.

• Performed Web Application Testing and Database Testing.

• Performed the different type of tests such as Integration tests, Regression tests, User Acceptance tests.

• Scheduled the job and monitored the job failures to diagnose the problem during System Test Loads.

• Involved in System Test Environment Setup and ETL Code Migration process

• Worked in scheduling ETL jobs to perform System Test Loads.

• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.

• Worked with Data Warehousing developers who extensively used Informatica, ETL tool to design mapping to move data from source to target database using Stages to understand the functionality.

• Involved in performing the data inspection for the files loaded from Source to Target by running Informatica work flows to populate Source and Target tables.

• Tested target and Source table by writing SQL Queries

• Tested different ETL jobs for migration of data from various units of Target into Dataware house (Oracle).

• Involved in functional, Smoke, Integration, Regression testing of Dataware house application.

• Experience in Web Application Testing, Cognos Report Testing, Data Quality testing.

• Interfere directly with developers on the daily basis to determine testing requirements, communicate testing results and resolve defects.

• Performed lead position and sending daily status report to Client and developers.

• Experienced in HP Quality Center defect tracking tool.

Environment: Power Center Informatica, HP-UX, Windows XP, Oracle 9i, SQL, Toad 7.0, IBM Tivoli Maestro, Quality Center, Test Director.

Honeywell Technology Solution Apr 2007 – May2009

Location: Colorado Springs - Colorado

Role: Quality Assurance Analyst

Organization Efficiency Reports are a current need by the business to understand the cost of labor. There is no automated way to currently obtain or analyze this data. This data is being provided manually to the CEO and is unable to be sliced and diced to provide further analysis to the businesses. There is also a need by the business to begin doing in-depth workforce analytics. To provide advanced analytics including labor cost to the business, it is necessary to integrate compensation data into the Global HR Reporting Tool.

Responsibilities:

• Gathering business requirement, Studying the application Scenario and collecting the information from developer and writing the system and user acceptance test plan, designed the requirement using MS-Excel.

• Used Test Complete to store all testing results, metrics, implemented Test plan Document, created Test Cases.

• Created and executed the test cases for various scenarios, and participated actively in system, integration, performance and regression testing for every new build released.

• Involved in User Acceptance Testing (UAT).

• Performed Development, Integration, System Integration, End to End and User Acceptance Testing for the data services.

• Performed Positive & Negative Testing for system validations.

• Performed System testing, Smoke testing, and Regression testing.

• Performed Front end and Back end testing.

• Performed various environment testing.

• Performed Report Testing (Cognos Report), Cube Testing.

• Involved in Database testing by writing & executing SQL queries to validate that data is being populated in an appropriate tables & manually comparing the results with front-end values.

• Preparing status reports and defect reports.

• Managing the defects in the defect tracking tool HP Quality Center.

• Assigned those bugs to Programmer by using "Quality Center" a bug tracking tool (Verifying that all the reported bugs fix thru software developers)

Environment: Windows, Cognos Tool, HP Quality Center, Test Director, MS- SQL.

NIIT Technologies Inc, Atlanta, GA Jan 2006 – March 2007

Role: Software Test Engineer

Edumate

The most creative organizations providing software solutions to the K-12 education market today have formed a partnership to deliver unique value to schools by integrating full auto-timetable generation with a completely web-based student administration and learning management system.

Responsibilities:

• Analyzed business requirements, and Functional requirements.

• Involved in writing detailed test cases for the Integration testing and system testing.

• Performed Functional, System, Integration and Regression testing of the application.

• Performed debugging code in VC++ Environment.

• Involved in defect review and discussions.

• Performed Unit Testing and Database Testing

• Extensively involved in designing, reviewing and executing test cases and maintaining the defect tracking logs for open issues.

• Conducted various types of testing like Functionality, Integration and Regression.

• Maintaining defects using Defect Management Tool JIRA.

• Performed Black Box testing to see the entire functionality

• Extensively performed manual testing process to ensure the quality of the software.

• Performed system testing, integration and regression testing manually.

• Responsible for making Defect status report and Project status report every week.

Environment: PHP, Java Script, HTML, MS-SQL, Firebird Database, JIRA, Windows.

NIIT Technology Ltd, India Feb 2004 – Dec 2005

Role: Software Test Engineer

EBuLa (Electronic Book Timetable with Speed Restriction)

This application provides information to the train drivers about the different routes available and speed at particular kilometer point. This application is targeted to work on 32MB memory machine called Gercom, at drivers place in the train. There are three mediums to provide train information. Data is stored on the hard disk and shown to the driver based on the Train Number selection and alternative route selection.

Responsibilities:

• Analyzed business requirements, and Functional requirements.

• Involved in writing detailed test cases for the Integration testing and system testing.

• Performed Functional, System, Integration and Regression testing of the application.

• Extensively involved in designing, reviewing and executing test cases and maintaining the defect tracking logs for open issues.

• Performed debugging code in VC++ Environment.

• Maintaining defects using Defect Management Tool Bugzilla.

• Performed Black Box testing to see the entire functionality

• Extensively performed manual testing process to ensure the quality of the software.

• Performed system testing, integration and regression testing manually.

Environment: VC++, QT Tool, Visual Studio Windows, Linux, Bugzilla.

Contact this candidate