Sandhya Rani Gurivelli

 Professional Summary 14 years of experience in QA working in Test Management, Test Plan creation, Test Estimations,Project Management, Test Strategy, Leadership of teams, training of individuals in QA Practices on Platforms Manual and Automated testing that included Legacy Mainframe, Client Server, Financial Services,Capital markets, Home Loan Services that follow the SDLC, Used Water fall, Iterative and Agile methodologies ,worked for clients Capital one, Charles Schwab, Wachovia/Wells Fargo, Fresh Fields, CFS and PangeR and worked on different plat forms like .net, Java, Mainframes. Experience Summary Responsible for the testing project deliverables like test estimations, test strategies, test plans, test cases, test results, test summary reports and ensuring all the deliverables on time Managed 10-15 members team at offshore and onshore in testing and implementation projects Have experience in Banking and Capital markets domains and both product based and service oriented projects Experience on Finacle Retail Banking and corporate internet banking product (Infosys Internal Product/tool) Experience in Product Pricing Engine (PPE) Home Loan products of Lender Price. Status and metrics reporting to senior management and client on daily, weekly and monthly basis Experienced on working for Black-Box and Mobile Testing. Have experience in different testing Regression, functional Testing, Smoke/Sanity Testing, Integration testing and API (SOAP UI) testing for different testing scenarios. Have experience on SQL queries for database testing activity in Oracle and PL/SQL. Have experience on automated testing of Web-based applications using QTP, Win runner, and have basic knowledge on Selenium Webdriver. Have experience on Test director,HP QC and ALM. Managed multiple projects with highly aggressive deadlines under minimum supervision. Have experience in bringing the projects to CMMi Level 5 within 45 days of the project start date. Though worked as Manager have hands on experience on testing for complex modules Managed Scrum meetings with the teams Have followed different testing methodologies risk based testing and stringent review process to eliminate the defects at the early stages of SDLC life cycle Experience in Risk based approach for testing projects Planned Knowledge sharing sessions on testing best practices followed in different projects as well as with in the project. Technical Skills Testing Tools : Quick Test Professional, Selenium RC, IDE, Selenium, Eclipse, Win runner, SOAP UI, Certify, and Junit. Management Tools : MPP, Quality Centre, Test Director, Bugzilla, VSS. Operating Systems : Windows 2000/XP/7, UNIX/LINUX, Mainframes. Databases : Oracle, SQL, DB2. Office Software : MS Office (Word, Excel, Outlook, and PowerPoint), Visio. Technologies : ASP .Net, Java, J2EE, JRE, JDK, COBOL, REXX, CICS, C++. Browsers Used : IE, Chrome, Firefox. Work Experience: Employer : Lender Price Project : Product Pricing Engine (Mortgage Home Loans) Domain: Banking Duration: Jan 2018 till date Location: Pasadena, LA Role:- Lead QA Engineer SDLC Methodologies :- Agile(2weeks sprint) Project: Lender Price has the most accurate and dynamic mortgage product pricing & eligibility engine (PPE) with advanced business intelligence & analytics. LP allows all lenders, banks and credit unions to manage product pricing for all mortgage types (Conforming, Non-Conforming and specialty loans). Worked on different mortgage type of mortgage loans and the pricing of the loans, second loans, home equities, ERNST services, custom fees/closing cost based on different services provided to the end user, rate sheets manual import and auto import using scheduler (using Java script), lender/broker relation between lenders, APR calculations(fixed and variable), compare tool which is developed for the rate sheets comparison for Union Bank, Quicken Loans Integration between DLP-LP products of lender price. Environment: Web application, Java, Mongo DB, Jira, Cloud, API testing using Jason(manual) Roles & Responsibilities Work closely with development teams to understand features and create robust comprehensive test plans to verify functionality. JIRA tool to manage test cases, requirements and defects. Developing and executing test plans and test cases, and providing well documented feedback with clear steps. Conduct exploratory testing and acceptance of new features as part of a story-driven Agile development process. Identify bugs through systematic testing, help developers reproduce errors using devops tools, and ensure that defects are fixed. Jira used for bug tracking tool Employer: Kforce Project: Muni Maritcs Domain: Capital Markets Duration: June2017 to Dec 2017 Client: Wells Fargo Bank, San Francisco, CA SDLC Methodologies: - Agile (2weeks sprint) Environment: Web application, .Net, SQL Server 2016, Jira, ALM Description Muni Matrics is the project to buy and sell the municipal bonds (tax exempted) to the end customer based on CUSIP, book and lot. The bond price based on the interest rates. Interest rates and bond prices inversely proportional and the bonds can help add stability to the investor portfolio. Validated the below functionality as a part of “Muni Matrics” testing. Investor portfolio based on lot book value Different reports validation based on backend data MML Pricer engine validation GXL server for the bond calculation based on bond type, term, coupon values and other specified conditions SQL Server migration from 2012 to2016 on all 6 test environments ETM(Escrow to Maturity) bonds validations – Credit, Hedging, trading validations and email notifications to the respective teams based on the flag set in database for a bond 60% backend validation testing on SQL Server. Used SQL Query manager extensively to test the application backend functionality, reports, calculations. Roles & Responsibilities Sprint planning, estimations(Points) and stories discussion with business teams Test plans preparation for the user stories planned for the sprint Work closely with development teams to understand features and create robust comprehensive test plans to verify functionality. JIRA for requirements tracking ALM test management tool used for developing and executing test plans, test cases, RTM and defects tracking Backend database testing in using SQL Query analyzer- validated stored procedures joins. Conduct exploratory testing and acceptance of new features as part of a story-driven agile development process. Identify bugs through systematic testing, help developers reproduce errors, and ensure that defects are fixed. Preparation of test summary reports for every sprint Followed the SDLC process which was set at WellsFargo organization for each sprint and set a benchmark for all other projects in the LOB. Employer: MindTree Project: UKACIDuration: June2017 Client: Silicon Valley Bank(SVB), Santa Clara, CA Role : UAT Test Lead Environment: Web application, Java, SQL, FlexCube, Sterling, ACI Description SVB provides a facility to their UK clients for different operations through the ACI application. The corporate/client can create different outgoing payments like BACS, MultiBACS, CHAPS, FPS, Cross border payments and different types of transfers. As the part of the project, have ensure the quarterly maintenance UAT release successful and all the evidences captured along with the regression. Getting sign off on the test scenarios, test evidences, test summary from different business teams(US and UK). UAT Testing is 3 weeks cycle. Will have to plan, estimate, execute and get sign off with in the 3 weeks span. Roles & Responsibilities This project was handed over to Mindtree from other vendor. UAT Test execution for the maintenance release tickets and regression testing Capturing test evidence during the UAT test execution for all the scenarios Raising defects to ACI team and having defect triage calls to resolve the issues as early as possible UAT test evidence walk thru to the business team and got the sign off Employer :MindTree Project: Remote Deposit ChecksDuration: April 2017 – May 2017 Client: Silicon Valley Bank(SVB),Santa Clara ,CA Role : UAT Test Lead Environment: Web application, Java, SQL, iphone, MAC Book, Windows, Water Fall Methodologies Description SVB provides a facility to their client thru their SVB account to opt for “Remote Deposit Checks” and “Remote Lock Box” thru a third party vendor RDM corp (Research, development and manufacturing). Client can deposit checks using windows, MAC Books and mobile devices. Panini scanner used to scan the checks thru windows and MAC Book where as there is an inbuilt scanner for the mobile devices to scan the checks and deposit. Client can deposit a single check using “Remote Deposit check” or batch of checks using “Remote Lock Box” option. Once the deposit done from the front end an “Image Cash Letter(ICL)” will be send to Fiserv and Fiserv will convert the ICL to Proof of Deposit(POD) and sends the files back to econnect system thru a nightly run. Roles & Responsibilities This project was handed over to Mindtree from other vendor. Had provided reverse KTs on this application to SVB IT and business teams and got sign off UAT Test execution with the existing regression test cases using windows, MAC Book and Mobile devices Capturing test evidence during the UAT test execution for all the scenarios Raising defects to business team to get it resolved with RDM vendor team UAT test evidence walk thru to the business team and got the sign off Employer: MindTree Project: StripesDuration: April 2017 – May 2017 Client: Silicon Valley Bank(SVB), Santa Clara, CA Role : UAT Test Lead Environment: Python, SOAP UI, CRM, Java, SQL, Windows, Water Fall Methodologies Description SVB provides a facility that can accommodate a group of customer onboarding at a time using a third-party vendor API which is developed in Python scripts. By executing the python scripts, if the clients are low risk clients based on the business rules an account and CIF will be generated in CRM for those clients. If the clients are high risk based on the business rule then the request will be sent for HRBO and GDOs approval. Once the verify and approve then account and CIF will be generated. As there is no front end available for this application, SOAP UI used to check the request and response statuses. Once the account, CIF got generated in CRM the same can be checked in the econnect(online banking) application. Roles & Responsibilities Review of UAT test scenarios shared by Offshore team Review of the Test plan for the UAT part UAT Test execution with the business team Capturing test evidence during the UAT test execution for all the scenarios Raising defects to the development teams UAT test evidence walk thru to the business team and got the sign off Test Manager: Oct 2011 till April 2016 (Infosys Ltd): - Worked for ICICI Bank (Indian Bank) Role:- Test Manager Client :- ICICI Bank Projects:- Worked on ICICI Mobile banking application, Retail internet banking migration from finacle 6.x to 10.x and Corporate internet banking project with in 5 years. Key Accomplishments:- Project planning, tracking and control Developed MPP for project scheduling and tracking the status of project using the same Ensured all the testing deliverables on time and meeting the deadlines Developed Proposals, RFI/RFP, test estimations, test strategies, test plans, test summary reports and reviewing the testing deliverables. Developed monthly, weekly and daily status and metrics reports and sharing with management as well as client. Managed 10-15 members of team Handled teams performance appraisal and escalations Conducting quality audits and having regular calls with senior management and updating status. Interacting with different teams (dev, UI, business and project management) and external stakeholders (client teams) on the project weekly status. Supported to production support team as a project manager for the mobile banking application. As the project was in critical stage and had taken a responsibility in testing project on different devices like iPhone, android …etc. Technical Test Lead: Oct 2008 till Sep 2011(Infosys Technologies) Worked for Wachovia(Capital Markets – Brokerage Accounts creation – NAO & AM ) and CFS Developing test plans, test estimations, test scenarios and test cases. Assigning the work and tracking the progress on daily basis and updating manager on daily basis. Updating internal and external stakeholders, if there are any environmental related issues . Key Accomplishments:- Developing test plans, test scenarios and test cases. Reviews of the test scenarios and test cases developed by the team. Implemented risk based testing approach for the projects to ensure the high priority modules mentioned by business delivered first Mentoring ,guiding the teams on test practices and conducting internal trainings on testing Updating weekly status to Manager to senior management and assigning the work to the team and tracking on daily basis. Preparing estimations, defect reports. Designed and Developed automation script using Selenium and web driver. Having interactions with business, dev, UI and project management teams. Execution of back end (DB validations) using SQL. Received 3 best performer awards from Wachovia client Test Analyst : - April 2006 till Sep 2007: Infosys Technologies Worked for Charles Schwab(capital Markets- Mutual Funds), Capital One clients Analyzing the requirements and preparing test scenarios and test cases. Executing different types of tests and raising defect in defect management tool. Preparing test scripts using automation tools and compiling and executing on different test environments. POC done to prove QTP is the suitable tool when compared to certify to test mutual funds application on Mainframes. Key Accomplishment:- Developed test scenarios, test cases and RTM. Reviewed and verified test cases for functional and system testing. Executed, Functional, System, regression, sanity/smoke, usability and installation testing. Providing and managing test Data for test execution. Automation Framework using Quick Test Professional (QTP) to develop and maintain automation projects in a structured and logical manner. Verified requirements coverage by conducting walkthrough meetings of Test plan and scenarios with business analysts, project manager. Performed necessary Test environment / data setup, testing and reporting during various phases of the Testing life cycle. Executed SQL queries to performed database validation according to the business logic. Tracked and reported defects into Quality Center and notified management with details. Partnered with the Software Development and Program Management teams to investigate and resolve product defects. Participated in weekly project status meeting and updated the testing Progress. Received Star award from Infosys and client excellence award from Charles Schwab client Test engineer: Sept 2002 March 2006 : Infosys, Interwoven and Nunet technologies Worked for Fresh fields and PangeR clients Key Accomplishments:- Developed test scenarios, test cases and RTM. Reviewed and verified test cases for functional and system testing. Executed, Functional, System, regression, sanity/smoke, usability and installation testing. Providing and managing test Data for test execution. Automation Framework using Win Runner to develop and maintain automation projects in a structured and logical manner. Verified requirements coverage by conducting walkthrough meetings of Test plan and scenarios with business analysts, project manager. Partnered with the Software Development and Program Management teams to investigate and resolve product defects. Participated in weekly project status meeting and updated the testing Progress. Academic Qualification: B.Tech (Computer Science Engineering) from Nagarjuna University, A.P, India. Exceptional Performances Project star award from Infosys 3 best performer awards for Wachovia/Wells Fargo client Client excellence award from Charles Schwab Hot shot team award from Interwoven in 2003 Certified ISTQB tester.