Sr QA Tester

Email: ***************@*****.*** Deepthi Chunduru

Phone: 805-***-****

Over 7+ years of experience in manual testing & ETL testing on web based, Client/Server and data warehousing applications.

Proficient in Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) including test strategy preparation, test plan development, test case creation, test execution and bug tracking.

Tested web applications in Waterfall and Agile development processes.

Extensive Experience in SQL scripting.

Professional experience in SQL, Integration, Functional, Regression, System Testing, Load Testing, UAT Testing, Black Box and GUI testing.

Extensive ETL testing experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) and other ETL Processes (Data Warehouse Testing)

Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.

Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.

Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.

Experience in using JIRA, Bugzilla, Test Director and HP Quality Center for Bug Tracking and Defect Reporting.

Experience in working with Software Development team in resolving Defects, presenting Defect Status reports, understanding requirements and observing design inconsistencies.

Created detailed QA documentation including QA reports, actively participated in SQA and project status meetings.

Strong working experience in Windows 7/XP and UNIX environments

Clear understanding of business procedures and ability to work as an individual and as part of a team.

Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

Certified as an "Oracle PL/SQL Developer"

Bachelor of Technology (Electronics and Communication Engineering), from Nagarjuna University, India

Operating Systems : Windows 7/XP, UNIX

Languages : SQL, PL/SQL, UNIX

Bug Reporting : JIRA, Mercury Test Director 8.0, HP Quality Center 11.0, Bugzilla

Databases : Oracle 11g/10g/9i, SQL Server 2005/2008

Database Tools : TOAD, SQL Developer

ETL Tools : Informatica Power Center 8/9

Reporting Tools : COGNOS, OBIEE

Client: Guthy Renker, Santa Monica, CA Dec 14 - Present

Role: Senior ETL Analyst

Guthy-Renker is one of the world’s largest and most respected direct marketing companies, with distribution in more than 68 countries. G R is creating its next generation multi-channel commerce solution for its customers. It has selected Order Motion, a Net Suite company and its OMX SaaS platform, as a best of breed software to support GR’s order management needs for the solution. The program is mainly aimed to reduce IT costs by eliminating dependence on HP and providing system with flexible product configuration rules. The project I work on is where we deal with Data Conversion from HP to OMX after applying various business logics and help load the data to OMX from where further fulfillment of orders take place.

Responsibilities:

Work in the Agile development environment with frequently changing requirements and features set.

Interacted with Business Analysts and Software Developers for bug reviews and participated in QA meetings.

Review product requirement documents, functional specifications, and involved in developing test strategy, test plan and test case documents.

Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.

Extract data files from HP, convert EBCDIC files to ASCII format and place the ASCII files in Informatica Server

Loading the files onto STAGE tables in a staging database, validate the files and their counts against the Files from HP.

Validate the date loaded in the views created on top of STAGE tables against the data provided by HP.

Write complex SQL queries including Join Conditions, SQL Functions, Sub Queries to check the data from Source and Target.

Involved in writing complex SQL queries to verify data from Source to Target

Performed backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.

Validate the data being loaded into OMX is matched with data sent from HP.

Reviewed the ETL mappings (Informatica) to ensure the transformation rules are applied correctly.

Developed parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.

Write SQL validation scripts and executed SQL stored procedures to validate the output data.

Create Validation Views for various scenarios on top of LOAD tables and validate the data in these Views.

Used JIRA for documenting Test Plans and Test Cases to log the expected results and to create Defects.

Defect tracking based on the priority and severity of the defects logged and follow up with developers until they are closed.

Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

Prepare test suits that has test cases from various sprints and prepare a regression suit for future sprints.

Responsible for Validating Business Intelligence Reports created using Cognos, to meet the Daily operational and analytical reporting demands of the business.

Successfully implemented the project without delays and within budget.

Environment: Informatica 8.6.1, JIRA, Oracle 11g, SQL, PL/SQL, TOAD, UNIX, Windows 7/ Windows XP

Client: Move Inc, Westlake Village, CA Dec 12 – Nov 14

Role: Senior QA Engineer

MOVE is a realtor company operating real estate web sites for consumers and real estate professionals. Scope of the project is to test lead managing websites for agent sales and broker sales. MOVE collects offices data from different source systems to maintain and store their data in a centralized database where the end users can use it for different business applications. This project maintains and enhances the agencies data warehouse, thus enabling them to perform trend analysis. The data was being extracted from various databases such as Oracle, SQL server, and Flat Files and loaded into an Oracle database using the ETL tool Informatica. The reporting was done using the OBIEE.

Responsibilities:

Worked with Business Analysts to define testing requirements to satisfy the business objectives.

Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.

Analyzed requirements, created and executed test cases.

Test Case Execution and Adhoc testing.

Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

Compared SQL results with application results by writing SQL queries.

Backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases using TOAD.

Used Test Director for tracking the defects. Performed Black Box, Integration, and Regression Testing. Investigated and reported bugs to the developers.

Prepare Monthly and Weekly Dashboard’s for tracking and reporting.

Responsible to deliver the Test Result and Test Closure Report to the Client.

Responsible to get the UAT signed off from users.

Performed Integration, End-to-End, system testing, involved in Functional Testing & Regression Testing.

Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.

Used HP Quality Center for storing, maintaining the test repository, bug tracking and reporting

Experienced in retesting the existing test cases with the different kind of source systems for different periods of data.

Prepared documentation for some of the recurring defects and resolutions and business comments for those defects.

Ensured seamless implementation of the project.

Environment: Informatica 8.6.1, TOAD, SQL plus, Oracle 11g, XML, PL/SQL, Oracle Business Intelligence 10.1.3x, Unix/Shell Scripting.

Client: Equinix, Sunnyvale, CA Oct 11 – Dec 12 Role: QA Tester

Equinix, Inc. is an public corporation that provides carrier-neutral data centers and internet exchanges. Equinix provides network-neutral data centers (IBX or "International Business Exchange") and interconnection services. This project maintains orders from various third parties; the data was being extracted from various databases such as Oracle, SQL server, and Flat Files and loaded into an Oracle database using the ETL tool Informatica.

Responsibilities:

Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.

Performed manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.

Modified and created SQL Queries and stored procedures for quality assurance and analysis.

Worked with data analysts to implement Informatica mappings and workflows to meet business requirements.

Performed backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.

Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.

Wrote complex queries to compare the counts and data from source to target.

Formulated the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.

Performed database testing to verify backend database transactions.

Coordinated user acceptance testing activities for business groups and IT.

Involved in communication between UAT team members, business leaders, and IT.

Participated in application release planning and status sessions.

Used Agile testing methodology for achieving deadlines in UAT testing.

Created, maintained and updated regression suites upon receiving new build.

Modified and executed test scripts for web based environment-using Quality Center.

Created traceability relationship between requirements in the same module and also between different modules.

Analyzed requirements and creating and executing test cases

Extensively used Quality Center for documenting, organizing and tracking requirements.

Involved in formulating the test plan, procedures and Wrote test cases.

Handled the implementation of the project within an Agile environment

Environment: HP Quality Center, Oracle10g, SQL, PL/SQL, UNIX, Windows NT/2000

Client: HealthNet, India Oct 07 – Apr 09

Role: QA Tester

Health Net Insurance offers health insurance plans for individuals and families, groups/companies, and Medicare beneficiaries in Arizona, California, Oregon, and Washington. Scope of the project is to perform quality assurance on member services.

Responsibilities:

Involved in the meeting with business analysts and Marketing team for requirement gathering in Definition Stage.

Gathered and Analyzed Functional requirements.

Involved in project planning, coordination and implemented QA methodology.

Designed, Created and executed manual Test Cases.

Peer Review of the scripts and made recommendations for updates if any.

Used Test Director for storing, maintaining the test repository, bug tracking and reporting

Prepared documentation for some of the recurring defects and resolutions and business comments for those defects

Assist QA Team with defining and implementing a defect resolution process including defect priority, severity, next steps, and assigned owner

Created detailed periodic Status Reports for senior management to keep them posted on the progress of implementation

Wrote SQL queries to test the data in database using TOAD and validated the data

Developed Test Matrix to give a better view of testing effort.

Responsible to deliver the Test Result and Test Closure Report to the Client.

Environment: Java, Web logic Application Server, Oracle9i, SQL, PL/SQL, Test Director

Client: AT&T, India Aug 06 – Sep 07

Role: QA Tester

Worked as a QA Engineer for testing E-Learning products. Involved in Functional Testing, User Interface Testing, Multiplatform Testing, Browser Compatibility Testing.

Responsibilities:

Involved in designing the Test Cases using Functional Specifications

Conducted extensive manual Black Box testing to better understand the functionality of the Application.

Peer reviewed the Test Cases and made recommendations.

Designed, Created and executed manual Test Cases.

Test Environment Setup and Performed the Functional and Regression Testing

Detecting bugs, classifying them based on the severity, and documenting them.

Open Defect's with help of Bugzilla wherever discrepancies found in the code and assigning them to development Team.

Involved in Testing Change Requests (CR) that is testing base enhancements to the existing code before implementing in the Production.

Created detailed periodic Status Reports for senior management to keep them posted on the progress of implementation.

Attended periodic meetings, teleconferences and led discussions on problem resolution.

Coordinated with Developers for Defect analysis and performed Regression Testing.

Environment: Java, Web logic Application Server, Oracle9i, SQL, PL/SQL, Bugzilla

Contact this candidate