Keerthi Rani

Sr. ETL Tester

Professional Summary:

8+ Years of IT experience in the Software Quality Assurance, working as ETL tester testing in different environments and platforms.

* ***** ** *xperience in Data Warehouse applications testing using Ab Initio on multiple platforms.

Experience in Functionality testing, System testing, Ad-hoc testing, Regression testing and E2E testing.

Estimating the QA timeline, resource allocation and tracking of efforts and issues.

Strong experience in Informatica TDM tool for Data Validation, Data Discovery (sensitive data)

Worked in Agile Methodology using Version-One for tracking User Story Task and Activity.

Designed Test Case & Executed in HP-ALM with Defect Tracking.

Used different methodologies like Agile (SCRUM), Water Fall model in different projects.

Experience in using TDM tool to mask and bring down production data to lower environments

Logged the Business Requirements in IBM Doors with the collaborative effort of Product Owners.

Experience in full software Development Life Cycle (SDLC) and Quality Assurance Life Cycle (QALC) analysis, design, development, testing, implementation and maintenance in data warehousing environment.

Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents with Business & Product Owners.

Prepare QA Documents including Requirements Tractability Metrics, Test Data, Test Result Metrics, and Defect Reports and Test Status Reports.

Good expertise in using TOAD and SQL*Plus.

Proficient in using SQL Queries using TOAD & SQL Plus to ensure data consistency of front-end and raw feed by developing and executed complex SQL queries for data base.

Good Knowledge on Dimensional modeling, Star schema, extraction, transformation and loading (ETL) process.

Excellent Knowledge in defect tracking and various reports and change request process.

Experience with various test management tools such as Clear Quest &JIRA.

Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.

Excellent experience with Data base testing and strong SQL skills–ORACLE

Excellent analytical & Testing skills with problem-solving approach

Technical Skills:

Testing

Black-Box, White-Box

Testing Tools

ETL Tools

Reporting Tools

HP-ALM, Jira, Bugzilla

Ab-initio GDE 3.1.7.3, 3.1.5.3

Business Object, Cognos, Ab Initio, SSIS, Power BI

Defect/Test Management Tools

Jira, HP- ALM, Bugzilla

Languages

SQL, Unix and Java

Databases

Oracle 10g, SQL

Web Server/App Server

Tomcat, Web logic,

Operating Systems

UNIX, Windows

Professional Experience:

Client: Kellogg’s, Battle Creek, Michigan Jun 2019 – Present

Role: Sr. ETL Tester

Responsibilities:

Developed Test Plan and Test Cases based on the ts and performed smoke test to decide credibility of the build in order to initiate

Create Test design estimations timeline based on reviewed scope.

Manual testing and regression.

Conducted Functional and Regression Tests and interacted with developers to fix defects and resolve

Secure transfer of watch list files using Java API’s

Used Informatica TDM tool for data masking. Tested complex masking rule, Plans in TDM to mask application

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

Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e., backward navigation from target to source.

Development of automation Test scripts using Selenium WebDriver framework.

Performed Functional, Integration, System, Regression, and UAT during the various phases of the application.

Established and documented ETL QA standards, procedures and QA methodologies.

Built Automation Framework using Selenium WebDriver

Developed complex SQL queries to test the database values for data integrity.

Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.

Involved in business requirements & users requests.

Closely worked with developers and System Engineers to nail down the technical problems.

Reported the bugs, emailed notifications to the developers using the HP-ALM.

Environment: Business Objects, Quality Center/HP-ALM, Oracle, Java, Agile, TOAD, UNIX, Version One, Rapid-SQL

Client: Coty, Sanford, NC Mar 2018- May 2019

Role: Sr. ETL Tester

Responsibilities:

Flexible, resourceful, and self-motivated and can work as a team and independently

Developed Test Plan and Test Cases based on the requirements and design documents.

Extensively used HP-ALM for designing Test case & Execution & defect Tracking.

Worked with Business team very closely for Business requirement changes in Agile Methodology

Analyzed user requirements, scenarios, and business rules and attended periodic meeting for changes in the application.

Logged defect in JIRA / Bugzilla for defect tracking.

Identifying the Test Cases to be automated and developed automation test scripts using Selenium Web

Used TDM to Mask and bring down the production data to lower environments, in order to load data in SIT and UAT environments

Performed manual testing and regression testing for user stories.

Involved in Functional testing, business requirement testing, data requirement testing, regression testing, system integration testing, data validation, and non-functional testing.

Responsible for Smoke testing, Regression testing, Integration testing and System testing.

Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.

Prepared Requirement traceability matrix (RTM) for the application.

Developed complex SQL queries to test the database values for data integrity.

Prepared agile test approach and test summary report for Release.

Closely worked with developers and System Engineers to nail down the technical problems.

Environment: Business Objects, Quality Center/ALM, Oracle, Agile, UNIX

Client: Service channel, Pleasanton, CA Dec 2016 – Feb 2018

Role: ETL Tester

Responsibilities:

Analyzed user requirements, scenarios, and business rules and attended periodic meeting for changes in the application.

Worked with cross-functional teams to manage defects, compile test results and communicate issues, risks and status on a timely basis to ensure solution meets the business requirements.

Involved in Functional testing, business requirement testing, data requirement testing, regression testing, system integration testing, data validation, and non-functional testing.

Responsible for Smoke testing, Regression testing, Integration testing and System testing.

Involved in Manual Testing to check the basic functionality of the modules under test.

Prepared test plans and test cases to test application functionality.

Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.

Prepared Requirement traceability matrix (RTM) for the application.

Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.

Involved in database testing by writing and executing SQL queries to ensure that data entered has been uploaded correctly into the database.

Environment: Business Objects, Quality Center/ALM, Oracle, Agile, UNIX

Client: ACE-TECH Products, Hyderabad, India Jan 2014 - Mar 2016

Role: Senior ETL Tester

Responsibilities:

Having experience of working at Client Location as Onsite Coordinator in Singapore.

Preparing ETL Specific Test Plan, Test Case and Test Data for GMBS process

Participation in Test Readiness Review meeting and Defect Review meeting

Point of contact for the client data testing, data accuracy and accuracy of functionality

Leading a team and monitoring End to End ETL execution through Ab-initio graphs.

SPOC for Testers-clarifying the design related queries of the test team members, bridging the gap between the Design and Testing Team, technical contributions in terms of forming conceptual level and high-level designs Test Cases

Worked with cross-functional teams to manage defects, compile test results and communicate issues, risks and status on a timely basis to ensure solution meets the business requirements.

Implementation of Innovation and Automation within the project which contributed in increasing efficiency and reducing manual efforts.

Prepared Requirement traceability matrix (RTM) for the application.

Prepared Knowledge Management Documents for the Team

Attended Walk through, Meeting with Project manager & QA team.

Estimating the QA timeline, resource allocation and tracking of efforts and issues.

Resource allocation – Deciding on resource allocation as per Work Order and complexity of various modules given for test.

Tracking of projects – tracking progress of deliverables; maintaining alignment with external Testing Teams; maintaining interaction with users

Environment: Abinitio, Unix, SQL

Client: Airtel, Kolkata, India Feb 2012 - Dec 2014

Role: ETL Tester

Responsibilities:

Usage data analysis from different network elements like

MSC, IN, SMSC, CGSN, GGSN, Mediated Sources and reconciliation among them

Non usage data analysis and reconciliation among them like

HLR, BILLING, Voucher Management Systems etc.

Writing and debugging PL/SQL blocks (Functions, Stored Procedures and Triggers etc.) and performance tuning of the code as well

Writing and implementing UNIX Shell Scripts for different modules of the One review product suite to make the jobs automated

Creating aggregate data from detail data source and generating KPI reports from the aggregate data source.

Involved in ETL process monitoring which includes new job creation and re-initiating failed jobs.

Involve in Walk through & Inspection.

Responsible for sending Daily & weekly status report.

Analyzing raw data and finding the correlation between raw data and transformed one.

Implementing new tariff systems in the re-rating server and developing multiple procedure and package creation to serve the purpose.

Responsible for other adhoc as assigned.

Flexible, resourceful, and self-motivated and can work as a team and independently.

Environment: Unix, SQL, Rating-Billing

Contact this candidate