Project Data
Resume:
Venkata Manoja Pothula
* : *****************@*****.***
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