Name: Srinivasarao Ravipati Mobile: +* - 980-***-****

Summary

Overall 9+ years of experience in Information technology.

* ***** ** ********** ** Datawarehouse,Datamart and Business Intelligence (ETL & BI) testing, functional and database testing in Insurance domain.

2 years of experience in Service NOW CMDB on Data Quality, Reporting, Dashboards, Qualys integrations in investment banking domain.

Experience in end-to-end DWBI testing including creation of test plan & test strategy, preparation of test estimates, test approach, defect tracking, test cases review and Metrics collation.

Proficient in analyzing Business Requirements, System Requirements, Functional Requirement Specification (FRS), Design Documents, Use Case Specifications, and User Stories.

Well acquainted with all phases of Software Development Life Cycle & Software Testing Life Cycle Concepts.

Excellent Analytical, Problem Solving and Documentation skills including Team leadership coupled with aptitude to motivate team members towards goals, and strong interpersonal, written & oral communication skills and capable to work on multiple project/product assignments.

Strong at testing ETL process & BI Reports and ensuring data correctness & data quality as per the Business requirements.

Experience in using Service NOW CMDB platform to create reports, Dashboards, Identify data quality issues.

Experience in writing Unix commands.

Experience in using Autosys tool.

Experience in setting up QA best practices and making sure that team is following the set process.

Strong experience in DWBI Testing, Data Migration Testing, Database Testing, Regression, System Integration and UAT.

Has experience in Agile Development Methodology.

Sound knowledge and experience in Test Design, Test Execution and Test Results Analysis.

Hands on experience in designing and executing test scripts.

Extensive experience in test data setup based on business requirement.

Extensively performed ETL, Datamart (IBM DataStage) testing and Report (OBIEE) testing.

Experience in testing jobs developed by IBM Datastage and Informatica tool.

Good knowledge and working experience in using UNIX commands

Validated reports developed in OBIEE.

Experience in trading tools like Long View trading system (LVTS), iRouter, iCross, QAT, IPO applications.

Having experience on IBM OPTIM tool.

Experience in TDM (test data management) Re- Engineering data end to end process to analyze relationships between all tables from each DB to subset data using IBM OPTIM tool.

Experience in identifying PII elements to mask data for any DB.

Possess Excellent problem solving skills and Flexible to the work environment

Good understanding and experience of every phase of QA Life cycle, beginning with planning to the release of the product.

Experience in creating Requirement Traceability Matrix to ensure comprehensive test coverage of requirements.

Good experience in writing Queries for the following databases (Teradata, MS-Access, Oracle 10g/11g, SQL Server)

Good experience in using tools like SQL Developer, TOAD, SQL server management studio.

Possessing Strong SQL skills.

Closely worked with business to understand the features and design the test approach.

Experience in GUI Testing, System & Functional Testing, Ad-hoc testing, Black Box Testing, And White Box Testing.

Experience in Defect management, defect analysis and defect reporting using various Defect Tracking Tools like HPALM, JIRA.

Experience in writing Unix commands using tools like Putty.

Experience in using WinScp, FileZilla tools.

Lead team of testers of team size up to 6, Managed small to medium size projects, and have experience in interacting with offshore teams, onsite teams, clients counterparts.

Technical Summary

Database

MS-Access, Oracle 10g/11g, Teradata

ETL Tools

Datastage, Informatica, IBM OPTIM and Autosys tool.

Platforms

Service NOW CMDB

Reporting Tools

OBIEE

Test Management Tools

HP Quality Centre, ALM, JIRA

Operating System

Windows,UNIX

Defect Tracking Tools

Rational ClearQuest,JIRA, ALM

Languages

SQL, VB, Java

Other tools

Toad, MS Visio, SQL Developer, MS SQL Server, WinSCP, FIleZilla

PROFESSIONAL EXPERIENCE:

Service NOW CMDB – State Street Corporation, Quincy, MA Oct 2017 – Till Date

Test Lead

Project Abstract:

SSBT-ITAM is a State Street IT Asset and Configuration Management project to manage enterprise level IT infrastructure Assets which include Desktops/ Laptops, Servers, Network, Storage and Business Applications. This project helps State Street Client to comply with FED Regulatory and Corporate IT Infrastructure Audits requirements. It maintains IT Asset information used by Change, Incident, Problem, Release and all other ITSM Processes. It involves automation of different processes (like Server Build, Logistics, Asset Lifecycle management and decommission processes etc.) to manage huge and growing infrastructure need while controlling cost and quality.

Responsibilities:

To analyze existing CMDB application and gather requirement for enhancement of an existing process

To develop data quality reports and work with platform teams to resolve the issues.

Develop reports, Dashboards based on user requirements.

Develop CMDB health dashboards to measure measure data accuracy, data completeness.

Involved in Qualys vulnerability integration with CMDB testing.

Identify activities/ tasks, task level estimates, schedule, dependencies and risks. Participate in knowledge gathering sessions conducted by customer/ other business teams and Provide feedback on requirements understanding and design from application SME perspective.

Analyze functional/nonfunctional requirements and seek clarifications for finalizing requirements.

Define the data process governance for application mapping requirements to complete loading process into CMDB Cycle.

Validate and verify the status of application mapping process in CMDB and certify with app owners.

To collect Asset analysis and utilization of Report for monthly, quarterly, yearly and adhoc process based to Management.

To validate the Data quality with business owner and application owners for required data that loaded in CMDB.

To collect application codes from Application inventory team and sync up with CMDB Business configuration items

Remove/Archive/Verify the duplicate CI components in CMDB Repository and verify with Business and Application owners.

Data Quality Validation process with Reporting and KPI generating team and supporting for carry out in quality data from reports to Management

Creating key performance Indicators for IT Asset Inventory Data Health

Identify and resolve process gaps for IT Assets purchase Orders, Vendor Feeds & ISM weekly Feeds

Technolgies:

Service NOW CMDB, Service NOW discovery, Service NOW Reproting, Oracle, MS Access, MS Excel, S Powerpoint, MS word

LIFE Insurance, TIAA– CREF, Charlotte, NC Jan 2017 –Sep 2017

Test Lead

Project Abstract:

The objective of this project to update PIN’s from 7 to 12 digits because TIAA company customers are growing day by day and will assign PIN for each person. So TIAA planned to increase PIN from 7 to 12 digits so that no impact in future.

Responsibilities:

Worked as Test Lead.

Handled team of up to 4 members and responsible for overall QA deliverable of the team

On boarding and off boarding resources to the projects

Involved in functional, ETL, Datamart, reporting, regression and system integration testing.

Prepared the test cases and uploaded the test case into QC using QC add-in tool in Excel.

Involving in discussion on the requirements with functional leads based on the implementation and testing of data- warehousing and reporting concepts. Also suggesting best practices and value ads.

Based on the requirement determining the scope of work in the effort estimations.

Involving in automating the scripts for test execution, writing medium to complex SQL Queries to test the functionality.

Involving in test case, test script preparation, test data preparation process for files in Unix using putty and also in Test Execution using ETL and reporting tools

Using HP QC as test management tool to track whole STLC phases from Requirement to Defect tracking.

Responsible for designing and executing complex SQL scripts for data validation

Created Dashboard to generate reports from QC.

Preparing test closure documents

Mentored new resources.

Responsible for writing test strategy and test plans

Entirely responsible for Planning, prioritization and allocation of testing tasks to team members

Conducting test case reviews

Timely escalations on critical issues

Responsible for QA completion report & QA Sign off

Test metrics collection & project postmortem & implementation of lesson learned

Prepared the Daily status & weekly status Report

Project progress tracking and resource management

Providing guidance to team members on project scope & day today testing activities

Responsible for test approach and test scenarios walk through to Development team and Business Analysts

Responsible for assigning task and tracking the progress of team members

Used the test management tool ALM for test design and test execution andJirafor defect logging and tracking

Track and prepare the report of testing activities like Testing progress, Test case coverage and Defects discovered

Responsible for defining test automation approach by using Platinum

Participating in daily status calls

Responsible for collecting and publishing monthly test metrics

Technology & Tools –

Windows 7, UNIX, Data stage, Sql Developer, Putty, WinScp, HP QC/ALM, Autosys

AM Trading Tools, TIAA – CREF, Charlotte, NC Aug 2016 – Dec 2016

Test Analyst

Project Abstract:This project related to trading tools, TIAA use third party LVTS tool for trading purposes. TIAA internally developed few tools like iCross, iRouter, IPO to provide flexibility, response time and customer satisfaction with regards to price for traders who will place orders without any delay.

Responsibilities:

Worked as Test Analyst.

Involved in functional, regression and system integration testing.

Prepared the test cases and uploaded the test case into QC using QC add-in tool in xls.

Based on the requirement determining the scope of work in the effort estimations.

Involving in test case, test script preparation, test data preparation

Raising defects in defect tracking tools, ALM. Track and follow-up the defects with Dev team till closure

Preparing test closure documents

Placed orders on LVTS and receive response from ICross engine once orders are executed.

Involved in end to end testing from the time when order is placed until order was executed and send response back.

Validated different scenarios as per requirement with traders in test environment.

Technology & Tools –

Windows 7, UNIX, Putty, WinScp, LVTS trading tool, iCross, IPO, iRouter, Oracle 11G, Quality Center,

AM Confluence, TIAA – CREF, Charlotte, NC Jan 2016 – July 2016

Test Analyst

Project Abstract: Confluence, the global investment management industry’s leading provider of automated data management solutions, today announced Unity™, the first integrated platform that automates and integrates critical fund administration processes, including the collection, creation, confirmation, and delivery of investment product data. Unity supports a range of managed investment products worldwide, including mutual funds, funds of funds, collective funds, variable products, separate accounts, hedge funds, and other alternative investments.

Responsibilities:

Worked as Test Analyst.

Involved in functional, regression and system testing.

Prepared the test cases and uploaded the test case into QC using QC add-in tool in xls.

Updating and tracking the work order in client project management system

To run the jobs and check whether output files were created in expected location with correct format.

Prepared Test Plan and the Test Strategy based on requirement documents.

Experience in working with Confluence Unity Usage tool.

Developed SQL queries based on ETL mapping and TDD documents.

Executed Autosys and DS jobs and validated ETL mapping logic using SQL queries.

Validated ETL, Datamart, OBIEE reports by preparing SQL queries based on FRD and TDD.

Created traceability matrix to map Test cases against Requirements using Quality Center.

Prepared & reviewed Test scenarios, Test cases and Test Data, Test case Design, Execution

Involved in reviewing and modifying test cases & scripts after initial iterations of testing phases to account for changes in project scope

Verified whether the reports and extracts created are correct as per database by querying in sequel view point.

To send the daily status mail to client.

Technology & Tools –

Windows 7, Confluence Unity Usage tool, Datastage, Sql Developer, Quality Center, OBIEE, Unix, Autosys

TDM – Re Engineering Data E2E, TIAA – CREF, Charlotte, NC Dec 2014 – Dec 2015

Test Analyst

Project Abstract: This initiative came up because all Production environment DB sizes are increasing day by day. If QA need latest data from production then need to copy full data from production to ST environments. But ST DB sizes will not be more so as part of Re Engineering team we suggested that sub setting and masking for all DB’s across TIAA and they agreed to proceed on that. So those now no need to copy entire data from production to ST.

Responsibilities:

Analyzed all tables in Prod copy DB and prepared doc like which tables need to copy fully, need to subset, need to ignore to ST4.

Prepared data load strategy document to subset, mask and load data to ST4 from Prod back up.

Created extract services in IBM OPTIM tool for the tables which need to do sub setting using Driver file (Pin/SSN/Plan/Contract).

Executed extract services in IBM OPTIM for the tables which need to do sub setting using Driver file (Pin/SSN/Plan/Contract).

Created load services in IBM OPTIM for the tables which need to do sub setting using Driver file (Pin/SSN/Plan/Contract).

Executed load services in IBM OPTIM for the tables which need to do sub setting using Driver file (Pin/SSN/Plan/Contract).

Validated data before and after sub setting by using SQL queries.

Analyzed few DB’s and identified PII elements from all tables for masking purpose.

Validated data before and after masking for few DB’s by using SQL queries

Involved in ETL, regression and system testing.

Prepared the test cases and uploaded the test case into QC using QC add-in tool in Excel sheet document (.xls).

Technology & Tools –

Windows 7, Sql Developer, IBM OPTIM

Yardi Real Estate, TIAA – CREF, Chennai, India Dec 2010 – Nov 2014

Test Analyst

Project Abstract:TIAA used third party Yardi as source to develop new operational and financial dashboards to report statistical and performance data to higher level management and to take decision based on this data.

Responsibilities:

Worked as QA Tester

Requirement analysis, Test Planning, Test Execution, Reporting defect, Coordination with Onsite

Batch Preparation, Batch processing

Data Warehouse Testing, End to End Testing, Sanity Check, Functional and Regression Testing

Creating Master Test Plan, Creating test scenarios and Test cases, Reviewing test cases prepared by team members.

Daily call with onsite/Offshore team members and clients, Executing Test cases, Task identification and Tracking, Preparing Metrics, “ETL” solutions to extract data into database (data warehouse).

Tested the Data Validations in application using the SQL Queries in TOAD.

Effective execution of test cases, Responsible for system testing.

Peer reviewing of test design documents of my team members and guides the team in successful delivery of the projects.

Initial load has been tested in ETL tool and incremental testing has been performed through Autosys.

Managed the defect tracking process using QC.

Prepared the Daily Status Report (DSR) and Weekly Status Report (WSR) and Monthly Status Report (MSR) for internal audit.

Involved in test design review of the entire ETL tables.

Involved in creating the Complex Queries to test the data Warehouse

Performed Datamart testing as part of ETL testing.

Performed OBIEE reports validation as part of data load from Datamarts to OBIEE reports.

Responsible for creating the BI Report test plan, test estimation, test strategy, test design, test execution, metrics creation and overall test management.

Continuously involved in executing the BI Reports for regression and smoke testing in various test environments.

Prepared test phase summary report

Technology & Tools –

Windows 6, Informatica, Sql Developer, Sql Server DB, Autosys.

Education:

Bachelor Of technology in Information technology (IT).

Contact this candidate