venkata ramana g - WIZBII venkata ramana g has published his/her professional profile on WIZBII. v g

venkata ramana g

QA with 7.1 years of experience

37years • Bengaluru

Summary

• Presently working as QA lead leading a team of 8 people. • I love taking responsibilities and strive to deliver them. • Having handled multiple projects as a team lead and also working from the starting of the project till the End of the project. • Like to learn a lot and work as a team player and work in a challenging environment. • Experience in working in agile Environment. • Experience in writing Test cases and SQL queries to validate the data that has been loaded into Staging

Skills

Manual TestingEtl TestingDWH Testing

Experiences

Senior SQA engineer

01-2015 - NowIT development• Lead a team of 8 resources and work on multiple projects. • Ensured the team implement and follow the best practices to prevent defects. • Was the point of contact for the QA for escalation and other work related issues. • Assign task to all Testing Team members and ensure that all of them have sufficient work in the project. • Define the scope of testing for a particular release based on the meeting with the dev team and BA’s. • Monitor the test progress by constantly assessing the work assignment to each of the resources and re-balance or re-allocate them as required. • Actively involved in release cycles by contributing to scope planning, test effort estimation and release sign-off. • Managing and mentoring a small group of capable test engineers. • Provide formal sign-off on all testing deliverables and events. • Provide training and assistance to testers to ensure they are following testing and defect reporting processes. • Perform Cross browser compatibility testing for one project and participate in UAT for the project. • Testing multiple projects in parallel that includes feature upgrade in existing products and ground up new product initiatives. • Developing end-to-end functional and integration test-case scenarios to validate business function and system requirements. • Collaborate with product management, developers, and system administrators to ensure timely and robust execution of testing as part of a regular quality release schedule

SSE

11-2013 - 01-2016 IT development• Lead a team of 4 resources from offshore. • Performed Upgrade testing from Informatica 8.6.0 to 9.5.1. • Participated in the Design and test cases review meetings. • Create clear and concise bug reports with actionable steps to reproduce • Submit daily status updates and Metrics to onshore manager. • Identify the Training requirements and forward it to the QA manager (Technical and soft skills). • Conduct smoke tests and verify test servers before releasing to remote team. • Developing end-to-end functional and integration test-case scenarios to validate business function and system requirements. • Involved in the test data preparation for proper test coverage. • Ensure the resolved defects are re-tested. • Plan and organize training for the Software Test Engineers. • Clarify and escalate issues, risks and concerns on testing coverage for the project. • Involved in test Estimation by going through the design document. • Prepared test scripts as part of post/pre-production testing.

Senior tester

11-2011 - 11-2013 IT development• Prepared test scripts as part of post/pre-production testing. • Designing test cases by going through the mapping document. • Performing different types of testing like constraint testing, Data validation testing and regression ETL testing. • Involved in peer reviews. • Update the Test Result document, test sql and test cases on time when any change has been made in the Mapping document or requirement documents. • Involved in Test data preparation for proper test coverage. • Excellent knowledge in performing data integrity testing of the incremental data that is getting loaded in to the database. • Validated source and target tables based on the mapping document and transformation logic implemented. • Checking in the Informatica Scheduler whether the jobs are running properly or not. • Report test execution status daily and weekly to the team lead. • Involved in Test result analysis and bug reporting using Quality Center (11.0). • Involved in testing ODS, Dimension and Fact tables. • Supported the testing process of extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica. • Worked with Source Analyzer, Warehouse Designer, Transformation designer, Mapping designer and Workflow Manager in Informatica power center 9.1.0 • Preparation of Test case document and modified according to comments from Team lead. • Perform backend testing of the Database by writing SQL queries to test the Database integrity. • Check whether the data is getting loaded from multiple sources to the desired target table or not. • Used SQL queries for database testing and Data migration/Data loading activities. • Testing the data in the tables of the database for data quality

Tester

10-2009 - 11-2011 IT development• Prepared test scripts as part of testing. • Perform data integrity testing of the incremental data that is getting loaded in to the database. • Executed the SQL queries to verify the data from the database tables. • Validated source and target tables based on the mapping document and transformation logic implemented. • Check whether the data is getting loaded from multiple sources to the desired target table or not. • Report test execution status daily and weekly to the team lead. • Involved in Test result analysis and bug reporting using Quality Center (10.0). • Involved in testing ODS, Dimension and Fact tables. • Verify the table details according to the mapping document/spec. • Checking in the Control-M whether the jobs are running properly or not. • Perform different types of testing like constraint testing, Data validation testing and regression ETL testing. • Used SQL queries for database testing and Data migration/Data loading activities. • Testing the data in the tables of the database for data quality. • Execute Test case document and modified according to comments from Team lead. • Perform backend testing of the DB by writing SQL queries to test the integrity of the application and SQL Server databases.

Education & training

Gudlavalleru Engineering College

2004 - 2008 Gudlavalleru, Andhra Pradesh 521356, India, GudlavalleruIT development

My soft skills

Independent
Team player
Responsive

Languages spoken

  • English

    Native language

Make every future a success.
  • Job directory
  • Business directory