Post Job Free

Resume

Sign in

Manager Data

Location:
Charlotte, NC
Posted:
January 10, 2021

Contact this candidate

Resume:

VENKATA K SAVITA GUMIDYALA

704-***-****

adjbiy@r.postjobfree.com

SUMMARY

•About 14 years of total IT Experience as, Business Test Analyst, Test Coordinator and QA Lead.

•Excellent understanding of the Software Development Life Cycle (SDLC) and Software Test Life Cycle (STLC).

•Experience in Banking (Financial), ATM, Insurance and Retail domains.

•Expertise in project management skills by handling meetings, data analysis, documentation and business reports.

•Extensive experience in building requirements & test management of large client server applications, web based applications, E-commerce applications and Middleware applications on various Window & UNIX environments.

•Experience in gathering requirements, preparing BRD’s (Business requirement documents) and FSD/FRD’s (Functional specification/requirements document).

•Documented Requirement Traceability Matrix (RTM) for requirement elicitation and linkup to deliverables.

•Expertise in document preparation for software development using Microsoft Word, Excel, PowerPoint, Access and Sharepoint and MS Dynamics 365.

•Experience of AWS

•Full understanding of Rational Unified Process (RUP) using Rational Rose Modeler, Rational Requisitepro, Unified Modeling Language (UML) in the context of Waterfall methodology and Agile Methodology - SCRUM.

•Coordinated the test updates to senior management on a regular basis to avoid delayed risk in project progress.

•Preparing for AWS certification, practicing and good knowledge of cloud services like AWS..

•Experience working on web-based applications and has managed multiple projects simultaneously.

•Experience in Business Process Testing BPT .

•Excellent understanding of Data services, Data ETL using SQL query tools and applications.

•Effective in Facilitating Joint Application Development (JAD) sessions to gather, synthesize and prioritize requirements using interviews, document analysis, requirements workshops, site visits, and surveys.

•Experience in conducting GAP and Risk analysis and Cost/Benefit analysis.

•Working expertise in Workflows and UML diagrams such as Use case diagrams, Activity diagrams, Sequence diagrams and Class diagrams.

•Conducting User Acceptance Testing (UAT) and verifying performance, reliability and fault tolerance issues.

•Possess specific experience performing testing including Backend, Frontend, Regression, Functional, System, Interface, Usability, and Black box, Integration Verification, ETL testing and Validation End-to-end, User Acceptance Testing and performance testing.

•Possess specific experience performing Regression and Functional Testing.

•Expertise in Mercury`s Test Director and Quality Center (HP ALM) for Test Designing, Requirement Mapping, Reports, Test Execution and Defect Tracking.

•Flexcube, Loan IQ, ITFT, FX (Foreign Exchange), Payment processing, Tradeworks, SWIFT).

•Vast experience as a ‘Test Coordinator’ for large scale projects, responsible for Managing the Defect process for the project and ensuring traceability to Requirements and Test Cases, via the respective Requirements and Defect Management tools.

•Familiar with the current industry improvement standards like Six Sigma (6σ), Capability Maturity Model (CMM).

•Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts, Test Scenarios and Test Summary Reports for both Manual and Automated Testing.

•Possess excellent interpersonal skills, effective written & oral communication, and presentation skills. Used questionnaire, surveys, JAD sessions and Brainstorming sessions as requirement elicitation techniques.

•Expertise in testing GUI applications, SQL query scripts and SQL commands for testing.

•Exceptional ability to quickly master new concepts, very co-operative team player, fluent communication skills, and interpersonal skills, innovative and self-motivated.

TECHNICAL SKILLS:

Front-End Tools : MS Office, MS Visio, MS Project 2000, 2010, 2013, MS Project Server 2010, 2013, SharePoint 2007,2010,2013

Programming Languages : SQL, UML, C, C++, Java

Databases : MS-SQL Server, DBVisualizer and Oracle, PL/SQL. DB2, Oracle 7.x/8.0

ETL /BI TOOLS : Informatica, AUTOSYS

Tools : Caliber RM, CA Agile Rally, Win Runner, Load Runner, Quick Test Pro,Microsoft Test Manager(MTM), Rational rose, ClearQuest, Clearcase, JIRA, Selenium, HP ALM Quality center, Test Director, MS Dynamics 365, TeamTrack, TopTeam, Selenium, Cucumber.

Web Technologies : XML, HTML, VB, ASP, Client-Server Programming, Oracle SOA

Methodologies : SDLC, RUP, AGILE, Waterfall, V Model.

LinkedIn Link : www.linkedin.com/in/venkata-s-gumidyala-9b606612

PROFESSIONAL EXPERIENCE:

Vanguard Inc, Charlotte NC June 2018 – Present

Senior Business system consultant

●Providing a senior level of expertise. Experience in building effective relationships with the project’s business lead ensuring a collaborative environment is established. Support lead facilitation of the team collaboration sessions leveraging BDD (Behavior Driven Design).

●Handling 4 different applications( 401k, 529, SBS, Annuities & 403b) in product support with assisting the technical & business team in delivering high priority issues solutions within the turnaround time.

●Responsible for all business requirements enhancements or production related issues validations for 529, 401k, SImple IRA, SEP IRA, Annuities and 403b related plans.

●Applying elicitation techniques, utilizes various modeling techniques such as process modeling, data modeling, system modeling, example mapping to gather information at the right level of detail and understanding of the business.

●Communicating with the offshore team around the clock and handling priority issues in a timely manner and communicating to higher business management.

●Worked along with the software team in planning, implementation and executing a continuous integration and deployment methodology of the AWS hosted cloud applications.

● Design & manage JIRA / Confluence queries, dashboards for metrics reporting for various teams.

●Working with the technical team in installing and configuring Integration tools like Jenkins for nightly test suite execution and testing AWS.

●Setup Testing environments, establishing testing criteria, created end-to-end test plans.

●Performed UAT testing & regression testing.

●Leading Regression test cycles and all through applications testing and defect tracking using HP ALM & Team tracker.

●Prepared Feature files from scratch in GWT format for automating manual test scripts.

●Acting as a liaison between the business users and development team in getting the production issues fixed in a timely manner. Analyzed and prepared BRDs/CRs, FSD’s and having regular sessions with Dev, QA and business teams for discussion on requirements. Defining testing specifications.

●Creating and managing the business requirements using TopTeam tool and defect tracking using Team Tracker tool.

●Worked with a vendor management organization for alternative analysis of 529 Vanguard plans & interacted actively with Senior executive presentations to receive approvals & resource allocations for projects.

●Worked closely with the PMO team in defining project delivery methodology and templates.

●Expertise in Analysis,, design and preparation of application/system specifications for information system solutions which address business needs and methods for testing and installing them. Organized, optimized and sustaining ATTD and project artifacts that define product baseline.

●Collaborated with stakeholder groups across the organization to ensure business and technology alignment. Proposed solutions meeting defined specifications and needs.

●Plays a significant role in the development of Product Backlog, story prioritization.

●Supports Developers & Automation Engineers scripting the automated tests at ALL levels of the “test pyramid” (i.e. Unit, Integration and End-to-End system tests); may participate in the automated test code reviews.

Wells Fargo, Charlotte NC

Business Systems Consultant September 2017 – March 2018

Wells Fargo's SWIFT technology group, a part of Wholesale International, is an experienced and established financial domain which leads credit Risk model validation.

Responsibilities:

●Responsible for providing strategic business solutions to enterprise wise technology initiatives.

●Acted as a liaison between client and technical team by planning, conducting and directing the analysis of business flow.

●Provided technical expertise in identifying, evaluating and developing systems and procedures that are cost effective.

●Worked with user groups to provide training, resolve questions, assess user needs and recommend changes.

●Transformed strategic enterprise architecture and design principles into specific system requirements and specifications.

●Created business documents as in FSD, BRD & TDD for the projects that were being implemented as part of SWIFT technology development.

●Offered training of ALM & Production maintenance procedures to the team members.

●Closely worked with technology, business & Operations users, product managers, testing team to capture project related assumptions, constraints.

●Facilitated discussions and team ceremonies, including the daily Scrum, product backlog refinement, sprint review, sprint retrospective, and sprint planning.

●Supported cross-team coordination.

●Work with business user to get the requirements on production issues, Worked on the root cause analysis and share with the business users.

●Preparing Technical Design Doc as per root cause and resolution

●Participated in technical design walkthrough meetings, Implementing Code in Production using version control tools.

●Providing Fix in case of abends or defects.

●Maintained the defects for every month and proposed new measures to prevent them in future.

●Ability to support multiple projects and production maintenance items.

●Excellent time management skills to be able to support and coordinate multiple stakeholders from technology, business at one time.

AIG, Charlotte NC April 2016 – September 2017

Business Systems Analyst

Risk Control Services (RCS) developed a process for Vendor management, wherein TPM & CBRA are the ASP.net web applications used to facilitate Vendor/Contract Inventory management system. Handling these application developments which are used for vendor management replace the existing manual SORT with an automated application called CREP which engages a new third party relationship and calculates the Risk associated with the third parties.

Responsibilities:

●Managed the creation of all project level test plans and phase level plans such as component, system integration and User acceptance test plans using MS office and CA Agile Rally tools.

●Documented High Level Design (HLD) and Low Level Design (LLD) Documents to define the system rules by creating Use cases, interface designs etc.

●Created Use Case diagram, activity diagrams, sequence diagram in MS Visio

●Elicited requirements for development of the GUI, interfacing with various systems.

●Led test reviews (e.g. test case review) and sign off on test cases.

●Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2010 environment.

●Identify the new BCRs (Business change requests) that will affect the automated test cases, coordinate with the manual and automate QA team and update and maintain the test cases according to the new changes.

●Drove execution and status reporting for the test phase. Managed and monitored defect reports and worked with developers & other project team members to verify resolution.

●Understanding and documenting the requirements by creating user stories which details the requirement specifications.

●Created and edited dashboards, project forms and workflows using MS Dynamics 365.

●Analyzed requirements from business and technical groups and provided written testing coverage needs.

●Used CA Agile Rally tool to create the User stories for the business model.

●Working closely with the development team and business users.

●Coordinated resources from lines of business, offshore team, and interns to provide multiple project testing coverage.

●Coordinated with the regional leads from worldwide regions for the post production issues and updates.

●Involved in detailing project mission, Data Process Flow Diagrams and timelines.

●Acting as a liaison between the business users and development team in getting the production issues fixed in a timely manner. Analyzed and prepared BRDs/CRs, FSD’s and having regular sessions with Dev, QA and business teams for discussion on requirements. Defining testing specifications.

●Performed QA testing responsibilities to handle the testing of the Vendor application. Performed Regression Testing and created test scenarios for User Acceptance Testing (UAT).

●Prepared the business roadmap progress calendar and communicated with the team of the weekly status updates.

●Handled the risk exposure calculations testing that TPM & CREP are functioning as per the requirements.

●Updating the application release calendar for each sprint cycle and making sure we accomplish the scheduled tasks.

●Testing the application development enhancements in DEV and QA environments.

●Tracking and documenting the defects during the testing process, communicating them to the developers and getting them fixed.

●Interact with the end business users and make sure they are being provided the support for any high priority issues.

●Prepared Business Workflow models that cover "How" business processes are accomplished. Prepared Workflow diagrams analyzed AS IS and TO BE scenarios, designed new process flows, training videos and documented the business process and various business scenarios.

●Involved in Design Walkthroughs with stakeholders for baselining the architecture.

Wells Fargo, Charlotte NC

QA Analyst August 2014 - Feb 2016

Principal purpose of the Global Bank Expansion initiative is to establish Wells Fargo as the choice provider of International banking services for commercial customers in the middle market segment. By targeting strategic global markets- both developed and emerging. Project concerning Foreign exchange (FX) trading and handling the International funds transfer applications.

Responsibilities:

•Analyzed and prepared BRDs/CRs, FSD’s and having regular sessions with Dev, QA and business teams for discussion on requirements. Defining testing specifications.

• Prepared Test Strategy Document and Test Case Document, Requirements Traceability Matrix to map the requirements with their respective test cases.

•Created slide presentations for quarterly business reviews for corporate-level management

•documenting business status, performance, and pending business initiatives

•Involved in detailing project mission, Data Process Flow Diagrams and timelines.

•Participated in sprint planning, daily scrums, testing, retrospectives and sprint reviews.

•Experience on International banking systems and transactions with SWIFT codes and messaging systems.

•Formed a bridge between the Project Manager and different teams with effective presentations.

•Responsible for translating BRD into functional specifications and UAT test plans. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.

•Updating the Requirement Traceability Matrix RTM upon completion of Functional Verification and User Acceptance Test execution and mapping the RTM to the Functional Specification, Design Specification and User Requirement Specification.

•Worked with SharePoint 2013 user base to understand business needs and build solutions to address them.

•Conducted brainstorming sessions to define the project and to reduce the time frame required to complete deliverables.

•Involved in testing the SWIFT messages

•Flexcube Application testing which involved all the base modules; Customer payments, Single and multiple currency International funds transfer, Money Market, Foreign Exchange, Fixed assets, etc.

•Developed a quick and thorough understanding of MS SharePoint 2010. Performed quality assurance testing on developed SharePoint sites and web parts.

•Managed and approved the Funding tools per quarterly releases and supported for post release validations.

•Writing queries for data validations for multiple applications like OPICS, BOX, CURE, and CAS in test and prod environments to analyze production issues and suggest solutions to the Dev team.

•Testing different types of FX deals like FX, MM in OPICS as SOR and testing E2E interface with other upstream systems like Reuters, WXC, and FXOL,

•Tested the Trade flow process (Trade settlements), ITFT (International funds Transfer) etc.

•Executing test cases/scripts and reviewing test cases for SIT/QA teams.

•Using SOAP UI for calling different web services to create trades for E2E testing interfacing different systems.

•Worked on Team Foundation Server (TFS) and Microsoft Test Manager (MTM) to effectively manage the product life cycle.

•Maintained Requirement Traceability Matrix (RTM).

•Performed Regression Testing and created test scenarios for User Acceptance Testing (UAT).

•Prepared various test reports from Quality Center such as Test Execution Status, Test Execution Summary, Defect Summary/Details report.

•Analyzing test results and recommending modifications to the applications and data warehouses as required by project.

•Analyzing, identifying and tracking bugs and issues arising during the testing lifecycle using HP Quality Center/ALM

•Prepared Business Workflow models that cover "How" business processes are accomplished. Prepared Workflow diagrams analyzed AS IS and TO BE scenarios, designed new process flows and documented the business process and various business scenarios.

•Involved in Design Walkthroughs with stakeholders for baselining the architecture.

•Thorough documentation of the entire process along with all its activities.

BBVA Compass Bank, Birmingham AL March 2014 – August 2014

Test Lead Coordinator (QA)

BBVA Compass bank is a recognized financial company with its corporate in Spain now spreading in the USA.

•Coordinated testing for large applications including Unit, System, Smoke, Integration and Regression.

•Led team meetings on a regular weekly basis for business, technical and testing groups for status updates.

•Identified test resources: test data regions, servers, personnel, software and tools. Defined Exit /entrance test criteria.

•Created Master Test Plan and Testing Project Plan using MS-Project.

•Responsible for translating BRD into functional specifications and test plans. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.

•Developed and maintained all operational and technical flows using Visio and PowerPoint.

•Used MS Office Suite for creating Use cases, workflows and sequence diagrams according to UML methodology thus defining the Data Process Models

•Defined Use cases from requirements and helped convert them into software specifications

•Aided in workflow analysis and process design.

•Developed Test Plans, Test Cases, and Test Scripts for SIT and support for UAT tests.

•Involved in Master Test plan preparation and Efforts Estimation.

•Testing the Lynx application with web based testing and manual testing from different POS.

•Testing on ATM hardware and software in communication to the Lynx Fraud application.

•Worked on SQL for the data verification process.

•Created and edited dashboards, project forms and workflows using MS Dynamics.

•Designed and executed Test Cases using MTM (Microsoft Test Manager) for Functional Testing and Regression testing covering all specified features/requirements.

•Identify the new BCRs (Business change requests) that will affect the automated test cases, coordinate with the manual and automate QA team and update and maintain the test cases according to the new changes.

•Assisted in entering and updating Issues (Epics, Stories, and Tasks) onto JIRA Agile application.

•Experience in conducting GAP Analysis between the "As-Is" and the "To-Be" system. Performing SWOT Analysis and Cost-Benefit Analysis during project inception phase.

•Participated in modified agile, scrum methodology phases for the project.

•Followed Scrum (Sprints) for the project releases and managed the requirements and testing within the sprint time frames.

•End to end Assessment for all the test applications.

•Maintained requirements in Jira for tracking and testing purposes.

•Prepared Defect tracking report for the applications using Excel.

•Experience in preparing project reports using Excel (Macros, Formatting, Pivot tables, and dynamic graphs).

•Responsible for daily monitoring of Defects in QC and coordinated with the off-shore team in fixing the defects and responsible for cross communicating to Business Users.

•Communicating with the higher management and software development team on a daily basis for defect management and various testing purposes.

•Conducted & Participated in Joint Application Development (JAD) sessions with stakeholders and System Users.

•Global Intranet Migration for 20,000 Users, incorporating site content and news using Microsoft SharePoint 2010 (online) dedicated version

•Coordinating with the development teams in organizing defect triage meetings and escalating the issues to be resolved to meet the deadlines.

•Handling multiple projects testing planning, estimations and test management activities.

Wells Fargo Nov 2012 -- Jan 2014.

Charlotte, NC

Senior QA Analyst

Wells Fargo's Corporate Model Risk Management group, a part of Corporate Risk, is an experienced and established financial domain which leads credit Risk model validation.

•Implementation of Credit risk limits on new products for various wholesale and capital market groups.

•Working with various trading technology groups for source data generation to assess risk credit limits for trading different products such as Flexcube, equities, etc.

•Running UNIX jobs to load, normalize, map source data into respective database tables.

•Performed ETL testing and ran the AUTOSYS jobs for credit risk application testing. Extensively used the AUTOSYS jobs for the entire project.

•Extract simulation matrices, generate profiles and load them into downstream systems.

•Test Issues assigned for monthly releases, support UAT efforts for new product implementations.

•Deploying new release builds, database builds and grid server builds for QA, UAT environments using UNIX for grid.

•Managed the Change management tool JIRA by updating Issues (Epics, Stories, and Tasks).

•Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.

•Connected remotely to UNIX servers using PUTTY.

•Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

•Involved in monitoring the data flow from using SQL queries and stored procedures to extract the data from the database.

•Execute batch processing and verify the jobs status and data in database tables

•Adapted Agile implementation for release and attend daily standup meetings for updates.

•Conduct cross training and functional presentation for business users as needed.

•Performed Black Box Testing, User Acceptance Test (UAT), functional and Regression testing.

• Used QC for bug tracking and reporting, also followed up with the development team to verify bug fixes, and update bug status. Involved in the User Acceptance Testing.

•Created, maintained and updated test strategy, test conditions, test cases and regression testing based on business requirements.

•Conducted defect triage meetings with the software team and project managers.

•Generated Reports in Front end and validated Reports in Backend to ensure data integrity and validate Business rules.

•Involved in Cross Browser testing and cross platform testing.

•Expertise in JIRA for tracking the story cards.

•Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage in the Mercury Quality Center.

Tiaa-Cref, Charlotte NC Apr 2012 - Aug 2012

QA Application & Coordinator Lead

Tiaa-Cref is a Fortune 100 financial services organization that is the leading retirement provider for people who work in the academic, research, medical and cultural fields. TIAA–CREF serves millions of active and retired employees participating at more than 15,000 institutions.

•Responsible for analysis of defects in Quality Center (QC) and coordinated with business users in retesting the applications after defects are resolved.

•Coordinated testing for large teams and held meetings for business, technical and testing groups.

•Coordinated resources from lines of business, offshore, and interns to provide multiple project testing coverage.

•Responsible for daily monitoring of Defects in QC and coordinated with the off-shore team in fixing the defects and responsible for cross communicating to Business Users.

•Responsible for coordinating testing efforts in Cross Functional applications and ensure that user testing is done with proper validation of data.

•Performed in-depth analysis of the defects functionally and technically to support the testing and development teams.

•Responsible for preparing project reports using Excel (Macros, Formatting, Pivot tables, dynamic graphs).

•Used DATASTAGE as an ETL Tool for Developing the Data Warehouse.

•Created Master Test Plan, Test cases and scenarios.

•Created and maintained the Requirement Traceability Matrix RTM for the application.

•Extensive Coordination with the offshore teams in resolving testing issues and defect tracking.

•Generated testing metrics and reports via Excel, and QC.

•Update defects "real-time" in Defect Action board meetings.

•Work with Testing team, Development team and Business Team on resolving defects in HP Quality Center.

•Provided first-level Test Tool support for QC, and may perform additional duties processing Change Requests, and other tasks as required.

•Involved in monitoring the data flow from using SQL queries and stored procedures to extract the data from the database.

•Updated QC job aids and training materials.

•Performed testing on the user interface to validate the application.

•Ensured that the testing efforts are carried as per the business and functional requirements.

•Contributed in Test Planning & Test Strategy.

Diebold Inc. North Canton, Ohio Jun 07 – Mar 2012

QA lead / Test Coordinator

Diebold is a globally recognized company in the Retail ATM domain. It offers an integrated line of self-service banking solutions of ATMs to its customers who include financial institutions, government agencies, commercial enterprises and various retail outlets.

Project Description:

Diebold's Deposit Automation solution provides multi-item deposit aggregation to both the Authorization Host (XApCheck) and an item processing server (XApImage). Accepts individual checks without an envelope. Front and back image capture of a check. Autos extract the courtesy amount without user interaction. Detects and reads the MICR line. Displays check image and courtesy amount on ATM screen for customer verification. Check is held in a secure area and is returned if the customer rejects the transaction. Print on either side of a check. Deposits check in a secure area, separate from ATM currency.

Role and Responsibilities:

•Test case design, review and maintenance as per requirement Design, review and updating the test cases as per requirement

•Identified system integration requirements, coordinated the collection and verification of business needs.

•Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes

•Managed all the requirements in Requisite Pro, making requirements available to all

Team members. Followed the UML based methods using Rational Rose for Business Modeling.

•Conducted JAD sessions to gain consensus on various issues related to the project.

•Analyze business requirements and segregate them into high level and low level Use Cases, activity diagrams / State Chart Diagrams and Robustness Diagram using Rational Rose according to UML methodology thus defining the Data Process Models.

•Responsible for analysis of defects in Quality Center and coordinated with business users in retesting the applications after defects are resolved.

•Developed Test Plans, Test Cases, and Test Scripts for UAT tests.

•Tracked the defects using ClearQuest and Quality Center and generated defect summary reports

•Involved in writing test plans and test cases to approach documents using Rational Functional tester (RFT) for automation testing.

•Prepared Defect tracking report for the applications using Excel.

•Experience in preparing project reports using Excel (Macros, Formatting, Pivot tables, and dynamic graphs).

•Conducted All Hands Meeting before the production roll-out and ensured that all the change control documents are completed as per Change Control Board policies.

•Providing training to team members of the ATM devices and Agilis software.

•Involved in preparing Risk Management Plan, SCR checklist and Review Log.

Project #2

Title : NDX XV 2.1 and Hotfixes

Client : Diebold Inc., North Canton, USA

Project Description:

The Agilis NDx product enables the installation of an ATM terminal in an NCR (National Cash Register) Direct Connect or NCR Direct Connect+ (NDC or NDC+) network. The Agilis NDx application allows the terminal to work in the NDC or NDC+ network with no modifications to the host terminal driver application.

Role and Responsibilities:



Contact this candidate