Test Lead & BA

Madhavi Gundavelli

Cell # 262-***-**** E-mail: ***********@*****.***

~ BUSINESS PROCESS IMPROVEMENT ~ APPLICATION ARCHITECTURE DESIGN ~

PROJECT LEADERSHIP ~

Highly accomplished Business Systems Analyst & Software Quality Assurance Analyst with a verifiable track record of managing complex IT projects and exceeding expectations. Practiced in clarifying business requirements, performing gap analysis between goals and existing procedures/ skill sets, and performing testing activities for system improvement and to increase productivity and reduce costs. Extensive experience in the implementation of Financial Accounting, CRM, Employee Relationship Management, and Partner Management systems for financial services firms. Strong interpersonal skills, highly adept at diplomatically facilitating discussions and negotiations with stakeholders. Recognized project management skills, consistently deliver complex, large-scale projects on time and within budget.

Process Analysis & Redesign

Management of Cross-Functional Teams

Project & Delivery Methodologies

Project Management & Tracking

System Solution Architectures

Change Control Management

Budgeting & Planning

Cost & Resource Estimates

Project Risk & Scope

TECHNICAL PROFICIENCIES

Operating systems

Windows 95/98/NT/2000/XP, Unix and Linux

Languages

XML, VB, Java Script, VB Script, COBOL, VBA, SAS, SQL, HTML, DHTML and CSS.

Web Technology & ERP

ASP.Net, VB.net, JAVA and J2EE, SAP Modules

Middleware Technologies

COM/DCOM, COM+/MTS, CICS

Source Code Control

Rational Clear Case, Microsoft Visual SourceSafe 6.0 and CVS

Testing Tools

HP Application Life Cycle Management (ALM), QTP, Win Runner, Load Runner, Quality Center (QC), Rational Test Manager Test Partner, and IBM Rational Clear Quest. Requisite Pro

Requirements Tools

IBM Rational DOORS, Version One, Atlassian - Confluence, wiki, JIRA, Bit Bucket, Rational Requisite pro, ALM, Quality Center

Databases

Oracle, MS SQL, DB2 and Sybase, Mainframes

Data warehouse

Informatica, Ab initio, MicroStrategy

Web servers/Client

WinSCP, Web Logics, Web Sphere and IIS

EDUCATION AND CREDENTIALS

1 Bachelor of Technology in Computer Science & IT, JNTU, Hyderabad

2 PGDCA (Java, VB.Net, ASP.Net, Client Server technologies, Web Technologies and Database design technologies) from NIIT, India

3 Oracle SQL, PL/SQL, Wilshire Software Technologies, Hyderabad

4 Oracle Database Administration (DBA), Wilshire Software Technologies, Hyderabad

5 Oracle Apps 11i, Genesis Software Systems, Hyderabad

Professional Experience

Client: Freddie Mac, Virginia.

Role: UAT Test Lead Period: Jun 2018 to Dec 2018

Project: Scoring Engine Redesign (SER)

The objective of the project is to successfully design and implement a New Loan Scoring System for loans received by Freddie Mac. The New scoring Engine will perform Credit Risk assessment and perform calculations based on the scorecard model to calculate credit scores and credit information.

Job Responsibilities

Worked with the business client to understand business needs and requirements and visualize the solution being proposed.

Facilitated and navigated discussions with stakeholders to ensure clarity, prioritization, and consensus using Business analysis best practices.

Documented business processes and created workflows.

Created Business process models using BPMN to detail business process and requirements for IT development.

Leveraged rapid prototyping approaches to present as-is/to-be processes/workflows and rough designs of the proposed solution

Created and maintained dashboards, reports and project documentation in JIRA and SharePoint.

Gathered and transformed business requirements into function and system requirements

Extensively used Doors, ALM and Version One for requirements management.

Created, maintained and updated the Master tracker for mapping of CDM data elements for integration of the new scoring system with the Loan Application system.

Developed business cases, requirements, use cases, test plans, test strategies, test cases, and operational procedures and plans.

Documented and managed issues and actions identified during the mapping and conversion of data elements.

Prepared presentations using MS PowerPoint and Visio to project stakeholders and management.

Provided support to ensure the successful design, testing, and implementation of applications that support the business unit, developed training materials and conducting training.

Worked in agile software development and release management project for delivering enterprise applications through multiple release cycles.

Client: The College Board, Reston, Virginia.

Role: Business Systems Analyst Period: Jul 2017 to Mar 2018

Project Digital LPT & MST for SAT

The SAT is a standardized test widely used for college admissions in the United States. The objective of the project is to successfully implement an Item Authoring module that provides comprehensive authoring and item banking capabilities, enabling assessment, learning, education and HR professionals to: author and import items; manage items within a collaborative yet secure environment; organize items into tests, exams, and publish assessments for delivery.

Job Responsibilities

Worked with Stake holders and Product owners in gathering the functional and non-functional requirements and document inline of Agile Methodology. It includes identification of high-level business needs, preparation of Detail requirements documents (DRS), Screen Design docs, preparation of Application workflow, Wireframes

Conducted meticulous GAP Analysis while successfully reengineering key business processes to increase operational efficiency and alignment of business unit objectives.

Created Product Backlog, sprint Backlog and managed user stories in Jira and Wiki.

Used Enterprise Architect and Visual Paradigm's various tools for requirements management and current/future state modeling,

Extensively used Microsoft Visio and Microsoft Office tools for Requirement management.

Document technical and functional requirements, source to target documents, use case activity diagrams and Use Case specifications or user stories.

Supported System testing, User Acceptance Testing (UAT), and Business Acceptance Testing to support Client business needs

Subject Matter Expert and Advisor on regulatory compliance IT solutions.

Worked directly with product owners and stake holders to elicit business requirements, and their feedback on customer satisfaction items

Analyzing existing customer satisfaction functionality requests for business value-based recommendations to product owners

Analyze & acquire data from primary and secondary data sources – creating mapping specifications for use by ETL development resources

Facilitate Requirement JADs, requirement analysis and other requirement workshops

Partnering with development leads to identify opportunities for better collaboration and process improvements

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

Facilitated "three amigos" work sessions between developers, product owners and business analysts.

Client: Navy Federal Credit Union, Vienna, Virginia.

Role: Software Quality Assurance Analyst (SWAT TEAM) Period: Feb 2012 to Sept 2016

Navy Federal is the world’s largest credit union serving a Department of Defense field of membership to meet the financial needs of the members investments, life insurance, financial and retirement planning, trust services and legacy planning, in addition to auto/homeowners/renter’s insurance and discount programs

Job Responsibilities

SWAT TEAM : One of a select group of individuals assigned to large complex engagements designing application architectures and improving business processes for integration of New systems with existing client systems. Specialized in financial services clients leveraging extensive experience in banking industry. Assigned to special "Red" accounts indicating troubled or highly sensitive projects.

Demonstrated skills in interviewing business and technical leaders to gather and clarify business requirements. Developed CRM Strategy and Roadmap vision, and oversaw Business Process and Technical mapping. Authored detailed project/ deployment plans and schedules. Took lead role in numerous projects and consistently exceeded customer expectations.

Strong Understanding of software development life cycles (SDLC's) and Expert in Business Analysis, Quality Assurance and Quality Control Methodologies

Validate, prioritize, phase, enter, document and maintain all requirements for the client database in a Requirements Management System (RMS) to be approved by the client

Ensure that the requirements documented in the RMS are accurate, traceable, unambiguous, and concise. Functioned as the bridge between functional business units and IT.

Wrote test scenarios and performed system & UAT testing & performed defect tracking using Customer Relation Management (CRM) tools such as Quality Center and ALM.

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

Hands-on Mainframe testing experience in JCL, CICS, Batch environment

Experience using IBM Rational Requisite Pro and IBM Rational Clear Quest, Wiki, Jira, ETL informatica

Document technical and functional requirements, source to target documents, use case activity diagrams and Use Case specifications or user stories.

Supported System testing, User Acceptance Testing (UAT), and Business Acceptance Testing to support Client business needs

Experience in Client / Server based application testing.

Experience in backend/black box testing.

Experience in Internet/Web related applications testing

Participated and lead in project/sprint planning, status and review meetings and clearly communicated the system requirements to both the business and technical team members.

Experience in Internet/Web related applications testing.

Expertise in Defect Tracking, Defect resolution

Expert in mitigating risks and providing workaround and solutions using Technical, analytical and problem-solving skills.

Supported design decisions by backing them with business needs using IBM Rational tools.

Communicated and provides daily status reports on UAT execution metrics and defects to Project Team.

Extensively used IBM rational tools for gathering requirements and execution of workflow automation and as bug tracking system

Prepared and conducted end user training by developing key documentation, meeting facilitation and notes documentation, user guides and other necessary training materials.

Environment: Windows, Mainframes, IBM Rational tools-Requisite PRO, ClearCase, ClearQuest, Application Lifecycle Management (ALM), DBMS MS SQL, Oracle TOAD, Microsoft Office, MS Access, MS Outlook and MS Word, Quality Center 10.0, ETL informatica, COGNOS 8, SQL Server 2005, VB.Net, Active X Components, Test Manager, Version One .

Client: Capital One, Richmond, Virginia.

Role: Software Business & Quality Analyst Period: June 2010 to Feb 2012

Project: Commercial & Credit Infrastructure Program (C&CIP) Implementation

The Commercial and Credit Infrastructure Program (C&CIP): To establish integrated and robust platforms for Commercial and Small Business Banking, instill more consistent and robust processes, procedures and risk management across the entire banking portfolio, and provide sustainability for the future growth and profitability of the Bank.

Project 1: Strategic Dual Risk Rating Platform: The new 'Strategic' DRR tool is called the Commercial Risk Rating Platform (CRRP). CRRP, which is a web-based application, will help to mitigate a number of the issues associated with the Excel-based calculator. CRRP provides a stable, robust platform for the Underwriting and Model Development processes.

.

Project 2: Credit Path: To standardize Small Business and Commercial application processing, underwriting, credit approval, documentation and portfolio management in a workflow system. Data Conversion: Conversion to a loan accounting system for consolidation of multiple systems onto a single platform. to migrate loans from both NORTH and SOUTH onto the new platform

Job Responsibilities:

Agile Projects:

Gather requirements from Product Owner, Quality managers and Business users.

Created Product Backlog, Sprint Backlog and managed User stories.

Participated in Sprint Planning, Daily Scrum Stand Up, and Sprint Retrospective meetings.

Participated in the development and grooming of Project Backlog Stories (Requirements) with business and technology partners.

Assisted in closing gaps and TARs for associated Stories in each individual Sprint.

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

Assisted in the development of Project Impact and Process Control Plan documents.

Assisted in testing associated Sprint Stories for Acceptance Signoff (Configuration Management System).

Enterprise Fraud Management EFMS (Using FICO Falcon Fraud Manager)

Fed wire Automation using ETL Informatica and COGNOS

Cash Handling Automation

Corporate Automated Reconciliation

Patriot Officer Data Load File Modification

Experience in Quality Assurance and Quality Control Methodologies

Experience in designing and executing system and UAT test plans by attending technical/functional requirements reviews for complex software applications

Hands-on Mainframe testing experience in JCL, CICS, Batch environment.

Conducted daily Defect Review Board meeting with testing team and Vendors for Defect Remediation.

Expertise in Client / Server based application testing

Identify and remove obstacles that will keep the team from achieving their goals

Experience in backend/black box testing

Performed functional and UAT testing based on requirements and generated reports of execution metrics and defects.

Collaborated with on-site and off-shore developers and other analysts during UAT testing until achieving stakeholders' desired end results

Prepared instruction manuals and developed and maintained operational and technical flow diagrams using Visio and PowerPoint

Wrote test scenarios and performed system testing & Effectively used defect tracking Customer Relation Management (CRM) tools such as Quality Center

Performed UAT, User Acceptance Testing to ensure Application is designed and functioning as per the requirements.

Environment: Requisite PRO, Quality Center, SQL Server 2005, VB.Net, Active X Components, ETL Informatica, ASP.net, Abinitio, MicroStrategy, Microsoft Office Excel 2003

Client: ING Direct, Wilmington, DE.

Role: Software Business Analyst Period: Jan 2010 to Jun 2010

Project: Easy Orange and Orange Mortgage: Orange Home Loans is a revolutionary Mortgage application for managing mortgages online, over the phone and by e-mail.

EZO & OMA are web applications that deals with customer information for Mortgage loan for Purchase and refinance. The EZO & OMA Solution calculator provides refinance quotes and Good Faith Estimates to the customers; this application is integrated with Transact, which is Mortgage Loan decisioning application. All applications are done on ingdirect.com and all payments are done electronically.

Job Responsibilities:

Worked in agile software development and release management project for delivering enterprise applications through multiple release cycles.

Established a lightweight Scrum project management process and helped team meet sprint goals.

Coach team members on agile software development techniques.

Actively participated in Sprint planning, Grooming and retrospective to plan the sprint releases in efficient and timely manner.

Used Version One tool for tracking the Requirements and backlogs

Identified the Gaps Between Requirements and Use cases.

Worked closely with the development team in making the detailed Test Plan, Test Cases regarding the scope and focus of the testing.

Based on requirements designed and developed test plan and test cases in co-ordination with business analyst and developers.

Create test deliverables: test methodology, test strategy, test plan and preliminary test cases

Plan and execute user acceptance testing (UAT) to support multiple production

Support data mapping between old and new system for Coordination of Benefits (COB) & claims data conversion.

Identify test scenarios for claims adjudication, COB and Finance user stories.

Work closely with QA to coordinate testing efforts.

Actively participated in Defect meetings to resolve the defects in efficient and timely manner

Created Regression Suite by including the test cases that covers major functionality of the application and handed over to the Regression Team.

Baselined the Automation Scripts for future releases

Analyzed the Graphs and Reports obtained by the Scrum Master after the stress testing is done on the Client-Server Application.

Environment: Quality Center, IBM Rational tools: Requisite PRO, ClearCase, ClearQuest, Application Lifecycle Management (ALM), Version One, VB.Net, Active X Components, ASP.net, MTS, COM, ADO, VBScript, JavaScript, IIS, DHTML, SQL Server 7.0, Oracle 7.0, Rapid-SQL.

Client: ACCENTURE, India

Position: Oracle PL/SQL Developer Dec 2003 to May 2005

Project 1:

Production, Planning and Control System: This project was developed in Oracle 8.0 with Developer 6 as the front-end for Production Planning and Control Division, Delivery system, Accounting, Material Control, Billing and Recovery System

Job Responsibilities:

Supported Technical projects for Information Analysis, and to create data solutions and logical data model for incoming data.

Involved in coding and unit testing of the program units using Forms 6.0 and Reports 6.0.

Participated in the review of requirements.

Added functionalities and enhancements according to specified requirements.

Used PL/SQL for the procedures and for writing the application specific triggers.

Used SQL *PLUS for doing database related manipulations.

Used stored procedures in the template, which was created to ensure a certain standard for the general system.

Used database triggers for table related manipulations

Extensively used TOAD for database queries.

Assisted the DBA in creating Tablespaces, hot and cold backups and performance tuning with respect to SQL queries

Project 2:

Contact Management and Quotation System: This package enables the client to maintain Customer Details, Call History i.e., to maintain calls made by Customers for Appointments, Service and for other enquiries.

Job Responsibilities:

Involved in Application Development on oracle Platform.

Was involved in coding generating reports using Developer/2000, Reports 6i

Data Base designing

Coding PL/SQL functions, procedure, triggers and alerts to be used in the project

Developed Reports

Coding review, Testing and debugging of the codes.

Environment: Oracle7.3, Oracle 8i, Dev 2000, Dev 6, Forms 6, Reports 6, MySQL, Pl/Sql, Oracle Toad, Html, FrontPage, MICROSOFT Word, Excel, outlook and Access, Windows 95/98, Win NT.

Contact this candidate