Venkata Manoja Pothula

* : ac89vo@r.postjobfree.com

Ph : +815-***-****

To obtain a challenging position with career growth opportunities in the area of software testing in different functional testing and to continue to advance my career in software quality assurance and quality control environment. I would like to work in a creative and competitive environment on challenging assignments of the organization.

7.1 years of experience in ETL Testing and Reports Validation.

2+ years of experience in leading the testing team.

2 years of experience in Product/Web Application testing.

Experienced in creating complex SQL test scripts. Expertise to work on Teradata, Oracle & Mysql databases.

Experience in debugging the complex issues and providing RCA to the client.

Experience to work on Linux platform.

Experience in Agile Methodology.

Experience in writing Test strategy, Test Plan design, Test case Execution and preparing Test Summary Reports.

Experience in preparing estimates and metrics.

Experience in Interacting with clients for addressing their issues and Change requests.

Experience in providing KT sessions to product support team with required documentation.

Involved in Recruitment and training activities.

Received many outstanding performance awards as token of appreciation. Also received Team awards, incentive & Long service awards.

Got client appreciations for most of the projects on successful completion under tough time lines.

January 2014 to November 2018

Worked as Senior Analyst in BA Continum India Pvt Ltd(Bank Of America)

July 2013 to January 2014

Worked as Senior Software Analyst in Intergraph Consulting Pvt Ltd

October 2009 to June 2013

Worked as Test Engineer in Infosys. Ltd, Hyderabad

·Bachelor of Technology in Electrical and Electronics Engineering from Koneru lakshmaiah College of Engineering, Affiliated to Acharya Nagarjuna University, 2009, Percentage: 75%

·Intermediate Public Education from Nalanda Junior College, 2005, Percentage: 93.4%

·Secondary School Education from Nirmala High School, 2003, Percentage : 85%

Testing Skills

ETL Testing, Data base Testing, Manual/functional Testing.

Tools

HP Quality center, Rally, JIRA

RDBMS

Toad for Oracle, MySQL

Operating Systems

Unix, Linux, Windows.

Domain knowledge

Banking & Financial Services.

Platform: TRADS (Treasury Authorized data store)

Summary: Global wholesale banking treasury payments technology has been identified to become an Authorized Data Source (ADS) to address the risk data aggregation requirements. The objective of TRADS is to consolidate wholesale banking treasury data and be a single point of provisioning. 18 upstream systems data will use TRADS platform as central provisioning point to provide information to corporate risk and compliance.

Project #1:

Project title : RTP (Real time payments) - AML

Role : Team Lead

Team Size : 8

Environment : Toad for Oracle, HP ALM, Autosys and HADOOP.

Description : The RTP is a real-time payments platform that all federally insured U.S. depository institutions are using for payments innovation. With mobile technology and digital commerce driving the need for safer and faster payments in the U.S., financial institutions of all sizes are taking advantage of the RTP network’s capabilities to create or enhance digital services for their corporate and retail customers.

The Clearing House is working with providers of core processing and payment services, bankers’ banks, and corporate credit unions to ensure that every financial institution in the U.S. has an easy way to access the RTP network by 2020. TRADS acted as a central provisioning point and all the upstream systems of RTP are brought into TRADS as part of this project. AML (Anti Money Laundering) report was generated for the RTP data and sent to the AML team.

Responsibilities:

Participated in planning sessions, grooming sessions and retrospectives.

Extensive onsite interaction to understand requirement analysis, formulating solutions.

Understood the highly complex requirements for transformation of data in a format suitable for downstream platform and validated the business rules to ensure data is successfully submitted to AML.

Involved in providing the estimates for the project.

Designing and executing reusable global backend Test Scripts (SQL Scripts) to validate the data.

Lead the team of 8 members and was involved in code review, test preparation, test planning, test execution.

Was single point of contact for the offshore testing team and effectively passed on the information to the team by attending the late-night defect triage calls and other status meetings.

This was an ongoing project with many phases and with target release date of 2020 and I was involved only in the phase 1 of this project.

Efficiently allocating work and monitoring effectively of all the work performed by the team.

Setting up the environment and running the Autosys jobs in testing environment.

Preparing set of User acceptance scripts and validating data loaded to target tables.

Participating in product demos.

Project #2:

Project title : GRRP - GBS

Role : Team Lead

Team Size : 8

Environment : Toad for Oracle, HP ALM, Autosys.

Description : Global Regulatory recovery Platform (GRRP) is a compliance team that monitors all the financial institutions for any deviations with respect to policies and regulations. TRADS acted as a central provisioning point to provide the regulatory reports to this team. As part of this project GBS (Global Banking System) payments data has been brought into TRADS and compliance reports were generated from TRADS and shared with the GRRP team.

Responsibilities:

Participated in planning sessions, grooming sessions and retrospectives.

Extensive onsite interaction to understand requirement analysis, formulating solutions.

Understood the highly complex requirements for transformation of data in a format suitable for downstream platform and validated the business rules to ensure data is successfully submitted to GRRP.

Involved in providing the estimates for the project.

Designing and executing reusable global backend Test Scripts (SQL Scripts) to validate the data.

Lead the team and was involved in code review, test preparation, test planning, test execution.

Was single point of contact for the offshore testing team

Received gold award and became SME (Subject matter expertise) for TRADS testing team.

Efficiently allocating work and monitoring effectively of all the work performed by the team.

Setting up the environment and running the Autosys jobs in testing environment.

Preparing set of User acceptance scripts and validating data loaded to target tables.

Participating in product demos.

Project #3:

Project title : GRRP - ACH

Role : Team Lead

Team Size : 8

Environment : Toad for Oracle, HP ALM, Autosys.

Description : Global Regulatory recovery Platform (GRRP) is a compliance team that monitors all the financial institutions for any deviations with respect to policies and regulations. TRADS acted as a central provisioning point to provide the regulatory reports to this team. As part of this project ACH (Automated Clearing House) payments data has been brought into TRADS and compliance reports were generated from TRADS and shared with the GRRP team.

Responsibilities:

Participated in planning sessions, grooming sessions and retrospectives.

Extensive onsite interaction to understand requirement analysis, formulating solutions.

Involved in providing the estimates for the project.

Designing and executing reusable global backend Test Scripts (SQL Scripts) to validate the data.

Lead the team and was involved in code review, test preparation, test planning, test execution.

Was single point of contact for the offshore testing team

Received Silver award for sticking to the schedules in spite of numerous challenges like huge number of defects and very large defect turn around time.

Efficiently allocating work and monitoring effectively of all the work performed by the team.

Setting up the environment and running the Autosys jobs in testing environment.

Preparing set of User acceptance scripts and validating data loaded to target tables.

Participating in product demos.

Project #4:

Project title : GRRP - HPP

Role : Team Lead

Team Size : 8

Environment : Toad for Oracle, HP ALM, Autosys and HADOOP.

Description : Global Regulatory recovery Platform (GRRP) is a compliance team that monitors all the financial institutions for any deviations with respect to policies and regulations. TRADS acted as a central provisioning point to provide the regulatory reports to this team. As part of this project GPP (Global Payments platform) payments data has been brought into TRADS and compliance reports were generated from TRADS and shared with the GRRP team.

Responsibilities:

Participated in planning sessions, grooming sessions and retrospectives.

Extensive onsite interaction to understand requirement analysis, formulating solutions.

Understood the highly complex requirements for transformation of data in a format suitable for downstream platform and validated the business rules to ensure data is successfully submitted to GRRP.

Involved in providing the estimates for the project.

Designing and executing reusable global backend Test Scripts (SQL Scripts) to validate the data.

Lead the team of 8 members and was involved in code review, test preparation, test planning, test execution.

Was single point of contact for the offshore testing team and effectively passed on the information to the team by attending the late-night defect triage calls and other status meetings.

As this was the first project om HADOOP for TRADS a huge number of defects - 345 defects were logged by the team as part of this project out of which 112 defects were logged by me.

Received Gold award for sticking to the schedules in spite of numerous challenges like huge number of defects and very large defect turnaround time.

Efficiently allocating work and monitoring effectively of all the work performed by the team.

Setting up the environment and running the Autosys jobs in testing environment.

Preparing set of User acceptance scripts and validating data loaded to target tables.

Participating in product demos.

Project #5:

Project title : FPS - AML

Role : Individual Contributor

Environment : Toad for Oracle, HP ALM, Autosys and HADOOP.

Description : TRADS acted as a central provisioning point to provide the reports to AML team. As part of this project FPS(Faster Payments Service) payments data has been brought into TRADS and reports were generated from TRADS and shared with the AML team.

Responsibilities:

Participated in planning sessions, grooming sessions and retrospectives.

Extensive onsite interaction to understand requirement analysis, formulating solutions.

Understood the highly complex requirements for transformation of data in a format suitable for downstream platform and validated the business rules to ensure data is successfully submitted to AML.

Designing and executing reusable global backend Test Scripts (SQL Scripts) to validate the data.

Setting up the environment and running the Autosys jobs in testing environment.

Was involved in all the stages of test window.

Preparing set of User acceptance scripts and validating data loaded to target tables.

Participating in product demos.

Project #6:

Project title : BNTOL

Role : Individual Contributor

Environment : Toad for Oracle, HP ALM, Autosys and HADOOP.

Description : TRADS acted as a central provisioning point and as part of this project BNTOL(Canada Bank Notes) payments data has been brought into TRADS.

Responsibilities:

Participated in planning sessions, grooming sessions and retrospectives.

Extensive onsite interaction to understand requirement analysis, formulating solutions.

Understood the highly complex requirements for transformation of data in a format suitable for downstream platform and validated the business rules to ensure data is successfully transformed.

Designing and executing reusable global backend Test Scripts (SQL Scripts) to validate the data.

Setting up the environment and running the Autosys jobs in testing environment.

Was involved in all the stages of test window.

Preparing set of User acceptance scripts and validating data loaded to target tables.

Participating in product demos.

Product Summary:

SmartPlant Foundation is the world’s most proven, industry-standard engineering information management solution in the process, power, and offshore industries. It is the backbone for the common architecture that extends across our premier industry solutions. SmartPlant Foundation ensures an open, independent data storage system to protect plant information for the life of the plant. It addresses all of the design, build, and operation requirements of a facility throughout the entire plant life cycle. SmartPlant Foundation encompasses a plant's design, modifications, upgrades, and refurbishment, effectively managing the evolving plant configuration from front-end engineering design to plant decommissioning.

Responsibilities:

Attended extensive training on the SmartPlant foundation product for a period of 4 months.

Project #1

Title

MEM – Marketing Events Measurment

Client

Bank Of America

Tools Used

Quality Center 9, Toad, Putty, WSFTP

Project Summary :

MEM (Marketing Events Measurement) is a self-servicing tool for Bank of America to calculate the Return of Investment (ROI) for the events that are sponsored by BOFA. ROI is calculated by taking different parameters like GNA,NNA,PC and LIFT and it also depends on the type of the attendee.ROI is calculated only for Clients and Converted Clients. MEM consists of Front End Processes and ETL(Batch Processes).

Front End Processes

Front End Processes include 3 functionalities namely Attendee Management, User management and View Reports. Attendee Management functionality mainly includes management of the attendees for an event such as Add Attendee, Upload Attendee and Attendee List. User management includes 3 functionalities namely Manage Users, Modify Users and Delete Users. In View reports functionality, a report for an individual event can be generated and in this page one can find information for the event such as the amount invested by the bank and ROI.

ETL Batch Processes

ETL processes include MIDAS, GEKKO, Marketscape and Donnelly Matching processes. MIDAS is a third party application which provides all the client related information in the form of a FTP source file and a batch process is run to load this information into MEM DB. GEKKO process provides all the parameters that are needed for calculating ROI in the form of a FTP source file and a batch process is run to load this data into MEM DB. Marketscape provides the event related information in the form of a FTP source file and a batch process is run to load this data into MEM DB. Donnelly matching process is a third party application which will determine if a prospect is converted into a client after the event is conducted. After the event, if prospect gets converted into a client then Donnelly process will update a conversion flag for that prospect with a 'Y' value and send it back to MEM DB

Contribution:

Preparation of test data for Test Cases for negative scenarios in ETL processes.

Preparation of test scenarios as per the requirements

Analysis and design of the test cases as per the test scenarios and requirements

Review of the test cases and updating test cases as per the comments from the client

Test case execution in HP quality center

Has detected a large number of defects and no defects are rejected

Preparation of Test Report.

Preparation of status reports regarding Execution

Involved in Weekly Status Reporting and Meetings.

Project #2

Title

Web sphere – Tomcat Migration

Client

Fidelity

Tools Used

HP Quality Center 10, Test Harness Tool

Project Summary:

The main aim of this project is to migrate the existing NetBenefits application which is in Websphere platform to Tomcat platform. Wepsphere – Tomcat Migration project does not make any functional changes but instead it makes a platform change. NetBenefits is an application that is used by participants to check various account information such as retirement accounts, pension accounts, health insurance accounts, payroll accounts and brokerage accounts.

Contribution:

Review of the test cases and updating test cases as per the comments from the client

Test case execution in HP quality center

Has detected a large number of defects and no defects are rejected

Preparation of Test Report.

Preparation of status reports regarding Execution

Involved in Weekly Status Reporting and Meetings.

Project #3

Title

CRRP – Commercial Risk Rating Platform

Client

Capital One

Tools Used

HP Quality Center 10, SQL Server

Project Summary:

CRRP is a commercial banking application which is developed for credit risk calculation. CRRP mainly focuses on credit worthiness of the obligor and also it calculates the credit risk and to make decisions for loan approvals.

Credit Risk is calculated using DRR (Dual Risk Rating Method) which implements 2 risks

Probability of Default and Loss Given Default

Contribution:

Review of the test cases and updating test cases as per the comments from the client

Test case execution in HP quality center

Has detected a large number of defects and no defects are rejected

Preparation of Test Report.

Preparation of status reports regarding Execution

Involved in Weekly Status Reporting and Meetings.

Date of Birth : 27th March, 1988

Gender : Female

Nationality : Indian

Visa Type : H4 EAD

Career Objective

Professional Summary

Professional Experience

Academic profile

Skill set

Company Name: BA Continum India Pvt Ltd (Bank Of America) January 2014 – November 2018

Company Name: Intergraph Consulting Pvt Ltd(July 2013 – January2014)

Company Name: Infosys Ltd (Oct 2009 – June 2013)

Personal Profile

Contact this candidate