V Ramadevi

To pursue a challenging career in leading and progressive research organization offering opportunities for utilizing my skills towards the growth of the organization.

PROFESSIONAL SUMMARY

• Total 5 years of experience in IT industry and performed ETL testing, Manual testing and database testing with skills of Oracle SQL, UNIX, SSIS and ETL concepts.
• Have working knowledge on various ETL schema architecture like Fact table, dimension tables and Star schema and snowflake schemas.
• Experience on using waterfall and Agile methodologies.
• Have working knowledge with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Knowledge and experience with Business Intelligence (BI) data warehousing environment
• Analyzed requirements and provided work effort estimates. Identified & implemented corrective measures based on gathered metrics.
• Created Test Cases based on the requirements. Conducting system integration and functional testing throughout the project in various iterations/Sprints. Proficient in SQL Queries, SSIS validations.
• Proven experience in utilizing databases such as Oracle and SQL Excellent Analysis and problem solving and communication skills.
• Experience in UNIX commands and SQL Joins, Group functions, Analytical functions and Sub queries.
• Experience in Fact table and Dimension table analysis. Worked in the UNIX commands like grep, awk and Find etc.. To process the files in the Unix environment.

Project - 1

Client: Sun Trust Bank, USA                                           Domain: Investment Banking

Technologies: Oracle 10g/11g, SISS, UNIX                  Tools: SQL Developer, JIRA

ROLES AND RESPONSIBILITIES

• To create Test scripts and Execute the test scripts.
• Tested SQL queries to validate the data and performance of the database.
• Involved in data quality validation includes row counts check, sample data validations and entire data reconciliation.
• Verified Column mapping between Source and Target environments.
• Strong Understanding in Software Testing Life Cycle processes.
• Create documents for Bug logging, Prioritizing, Tracking and Reporting
• Participated in sprint planning and giving estimates for the testing tasks assigned.
• Working with business analyst and team lead to go over the user stories assigned as part of the sprint.
• Giving demo/walk through to the product owner after every sprint.
• Participating in peer review of the team member's test cases.
• Impact analysis on the existing automation scripts due to the new changes in the sprint.
• Working with dev team to go over the developed package to make sure that the requirement is covered by the dev as per the mapping sheet.

Project  - 2

Client : Deutsche Bank in Finland                                       Domain : Investment Banking

Technologies: Oracle 11G, SISS, UNIX.                             Tools: SQL Developer, JIRA

ROLES AND RESPONSIBILITIES

• Analyzed the Project and tested the source data, staging data and target data.

• Written SQL queries to execute the test cases using Sub-queries, Joins, Group and

Analytical function.

• Testing the Record counts between Source and Target environments..

• Wide experience in creating test cases for manual test execution using SQL in a database

testing environment.

• Documentation & preparation of test reports, defect list, test results.

• Analyzed application data using the SQL to identify the ETL processes modifying and

• creating SQL Queries and stored procedures for quality assurance and analysis.

• Defects Identified in testing environment are communicated to the

developers.

• Creating trace ability relationship between requirements in the same module and also

between different modules.

• Attended the Scrum Meeting and Update the Status for Day-to day activities

DOB - 26/06/1993

Gender - Female

Marital Status - Married

Father's Name - G.Vasudevan

Husband's Name - S.Vijayakumar

Nationality - Indian

Languages Known - English, Tamil. Telugu

    I V.Ramadevi hereby declare that the information furnished above is true to the best of my knowledge and subject to verification.