Shilpanjali Guduru
Dallas
Summary
Over 12+ years of professional experience in IT industry with extensive hands-on experience as a Sr. Quality Assurance Tester and Business Analyst in diversified fields of Quality Assurance, Test Management, Test Leadership and Automation of Testing. Involved in several complete life Cycle Implementation experience spanning the entire scope of the SDLC: development, testing, quality assurance, documentation, implementation, troubleshooting and customer support.
Overview
14
14
years of professional experience
Work History
Sr. QA Lead
Federal Home Loan Bank of Dallas
08.2023 - Current
- Understand the fed funds confirmation process to rewrite from UiPath to Microsoft Power Automate
- The migration from UiPath to Power automate significantly reduces the costs to the client associated to UiPath tool
- Prepare functional requirement documents for fed funds process
- Write User Stories, Get sign off on user stories, write test cases associated to User Stories in Azure DevOps
- Conducted Functional, System, User Acceptance Testing (UAT) and Regression Testing during the various phases of the development
- Test the Power Automate fed funds flow to see the trade in and trade out of amounts accuracy, re with new automation flow
- Report defects, develop dashboard for traceability matrix using Azure DevOps
- Developed detailed test cases based on business requirements documents, ensuring accurate coverage of all functionalities under review.
- Environment: Azure ADO, Azure Test case management, Azure User Stories creation, Microsoft Power Automate, UiPath, Postman, Rest API.
Sr. QA Tester
Microsoft
10.2022 - 07.2024
- Analyzed the Business Requirements Document, created the test plan and prepared detailed test cases for new Functionality
- Conducted Functional, System, User Acceptance Testing (UAT) and Regression Testing during the various phases of the development
- Testing of Microsoft products like Outlook, Teams, SharePoint, OneNote for CAE functionality testing
- Tested for Multifactor authentication for users with administrative roles for users
- Updating the documents in Microsoft wiki in Azure
- Testing blocking or granting access from specific locations
- Rest API’s testing using Postman and SoapUI
- Fiddler network tracking for outgoing and incoming calls
- Identity protection testing in Azure AD by creating users under test tenants
- Performed User Acceptance Testing on behalf of End Users at client’s environment
- Generated Weekly Reports, Defect Reports and Customized Summary Reports
- Participated in Project Meetings & Conducting Knowledge Sharing Sessions
- Opened defects and Tracked defects to closure
- Worked with development teams, tested self-served tool for the First Party Application owner where the tool will recommend the least/minimal permissions for Microsoft apps based on their scenario
- Reviewed the Business/ Functional/ System Requirement Specs, High Level Design Documents, and Detailed Design Documents
- Prepared test plans for each release, Developed and executed test cases as part of functional testing
- Performed UAT testing with the help of Overprivileged First Party Application Owners
- Identified Overprivileged Application and worked with the Partners to remediate those applications
- Environment: Azure ADO, GIT, POSTMAN, One Note, Microsoft Wiki, .Net., Fiddler, Windows, Android testing, IOS testing of Microsoft apps
Sr. QA Tester
State Farm Banking
06.2020 - 09.2022
- Write test scenarios against code using Java, Maven, Cucumber framework
- Prepared test reports and deliverables and submitted for version releases
- Rest API testing using Postman and SoapUI
- Performed backend testing for retrieving the data using SQL queries
- Conducted Functional, System, User Acceptance Testing (UAT) and Regression Testing during the various phases of the development
- Reviewed the Business/ Functional/ System Requirement Specs, High Level Design Documents, and Detailed Design Documents
- Prepared test plans for each release, Developed and executed test cases as part of functional testing
- Create issues in GIT, track and monitor
- Reviewed test cases in the automation perspective to list of the test cases that can be automated as well as to identify the reusable actions, functions
- Interacted with Product Owners and programmers to identify and resolve technical issues
- Conducted External Walkthrough and Peer Review meetings for Test Plan and Test Cases
- Conducted root cause analysis on periodical basis
- Tracked defects to closure
- Environment: Java, Maven, Cucumber, Spring Tool Suite, SQL Developer, GIT
Lead QA Tester
New York State Department of Health
08.2016 - 02.2019
- Analyzing the user/business requirements and functional specifications documents
- Prepared Manual Test Strategy, Test Scenarios and Test cases for entire application
- Validate the data against the technical documents using SQL Developer
- Worked closely Project Managers, Developers and Program areas to ensure application development meets the user expectations
- Identified document management roles & also involved in all the workflows actives
- Set up test environment for manual test and automation test with HP Tools like UFT
- Installed and Configured Quality Center 11.0 with Quick Test Pro for functional testing environment
- Used Quality Center for Traceability Matrix, defect reporting and tracking
- Participated in QA meetings using Waterfall methodology
- Performed meetings to report the updates to the management
- Write test cases to test the application manually in Quality Center
- Executed Test cases for NYSE-CON application both Functional and Regression
- Responsible for creating test Scripts for Time-based Notifications and Event Based notifications and executing in QC and made data changes using Database
- Building the Requirements tree and Test Plan tree in Quality Center
- Created Release Test Plans for all releases including Emergency release working closely with QMC team to meet the QMC standards
- Developed test scripts and manual test cases for Regression testing based on the requirement documents using Quality Center
- Extensively used Quality Center for Functional and Regression testing
- Managed the team, maintained test results, and discussed the issues with developers
- Conducted the status meetings reviewed the issues with the team
- Discussed with Business Analysts, Developers and Project Managers for Production issues and any Requirement issues
- Set Created Project, Requirements, Test Plans and Tests in Quality Center
- Created data setup and provided scripts to Business Analyst for User Acceptance Testing (UAT)
- Provided regular status updates to Project Manager on high priority issues
- Used Redmine for defect tracking
- Involved in working with the Development team and Business users to clarify requirements as needed and to ascertain level of effort and feasibility
- As part of functional requirement testing, giving QA team deeper insight into the rationale behind stated requirements and the opportunity to ensure that NYSE-CON application meets the requirements in addition to what’s actually listed
- Environment: Quality Center 11, UFT 12, Oracle SQL, Java, SQL Developer, Java, Redmine, VbScript, Web Logic Server 12.2.1, XML
QA Tester/Analyst
Cablevision
10.2015 - 08.2016
- Attended Quality review meetings of the Requirements
- Micro strategy (ETL) lead and onsite coordinator
- Production migration for new deployment (Dev ops model) and monitoring the tidal jobs
- Involved in the requirements collection and functional specification preparation for Migration automation
- Conducting pre-release, release meeting
- Meeting with client to discussion production details for new changes
- Closely working with Business Analysts, Data Modeler, Developers and Delivery Leads
- Occasionally work with the Business (SME) directly to Analyze and understand the Business process
- If any production issue occurred working on agile methodology to help the developers fix the defect faster to meet the deadlines
- Validating the Target data against the Source data as per the Business logics and rules
- Extensively using JIRA for Defect Tracking purposes
- Writing Complex SQL queries to validate the data against the technical documents
- Working mainly on Oracle databases for validating data
- Highly involving in creating job long run analysis and handling failures
- Migrate for new requirement/changes into production
- Involved in working with the Development team and Business users to clarify requirements as needed and to ascertain level of effort and feasibility
- Actively involved in Daily stand-up meetings with Project Manager and team to discuss the updates/issues
- Reviewed and Analyzed Business Requirement Documents, Project Plans and Functional Specification
- Attended Use Case Review and Design Review Meetings
- Logged the Defects with appropriate Severity and Priority and Conducted Defect Meetings and Team Status Meetings providing testing updates
- Attended Change Control Meeting for approval of change requests and raised testing concerns
- Provided daily inputs to the Project Manager on the testing schedule and its time frame
- Inserted Check Points to check the broken Links, Text, and standard properties of an object using Prod fix
- Validated the Columns, Data completeness for Data Migration by using SQL Queries
- Created and Maintained Traceability Matrix to ensure test coverage of all requirements
- Ensured testing schedules are met during different iterations to ensure a timely release to production
- Develop the Test Scripts for Regression build based on the enhancements to the application
- Identified, Reported and Tracked Defects in JIRA
- Created and Updated Test Execution Matrix and Defect Matrix
- Provided regular status updates to Project Manager on high priority issues
- Coordinated with the Reporting team to make sure that required data is displayed in reports
- Cablevision Systems Corporation is a leading media company with a portfolio of operations that includes a full suite of advanced digital television, voice and high-speed Internet services and valuable local media and programming properties
- Environment & Tools: Micro strategy (ETL tool), Java, SQL, JIRA, Toad for Oracle, Putty & IBM Web sphere server
- For Automation: MS – Visual studio .Net (MVC), Oracle 10g, Selenium and Web driver for automation
Automation Tester
State Farm
01.2013 - 09.2015
- Assessed requirements, user specifications and other project documentation to comprehend the application and execute automation feasibility analysis
- Developed and supported Automation scripts using QTP
- Performed automation scripts, prepared execution reports and any log defects
- Co-ordinated with functional testing team and development team to drive automation testing related undertakings
- Evaluated new and developing trends in the automation test plans, estimation, test reports and dashboards
- Contributed to project meetings, peer reviews and strategic proposals
- Shared the best practices on the team and encouraged incorporation for delivery of excellence
- Analyzed the Business Requirements Document, created the test plan and prepared detailed test cases for new Functionality
- Involved in developing Test Strategy, Test Plan, Test Scripts and Test Execution requirements for the project
- Part of team to perform extensive Load/Stress and Regression testing using Load runner for all phases
- Developed Test Plan and Test Cases for Functional, Integration, Regression and System Testing of the assigned modules
- Establishing the base line, rerunning the test scripts, comparing them with the base line
- Experience in designing Test Cases/Test Scripts/Test Conditions for the Unit Testing, verifying and validating Web based e-commerce applications, like Boundary Value Analysis
- Attended walkthroughs with the users on Load and Stress tests conducted periodically
- Clearly communicated requirement related issues, risks, constraints, assumptions, dependencies and scope change
- Escalates to management
- Tracked issues, risk, dependencies, resolves conflict and keeps the meeting moving and on target
- Used SQL Queries extensively to manipulate database
- Communicated all defects found and recorded them using the QC defect tracking tool
- Performed different types of tests like Integration, system and regression tests
- Environment: QTP, LoadRunner, Windows XP, UNIX, Java, TOAD, XML, Oracle, SOAP UI, Redmine
QA Tester
Comerica Bank
03.2012 - 12.2012
- Analyzed the Business Requirements Document, created the test plan and prepared detailed test cases for new Functionality
- Used agile methodology to ensure the new features meet the customer requirements and acceptable quality assurance standards
- Developed Manual test scripts for different test scenarios covering all aspects of project functionality
- Executed the test cases, recorded the results, logged the defects and tracked it until closure
- In the regression phase, the project was automated using Selenium WebDriver and Java
- Responsible for developing a dynamic framework which could automate all the test cases
- Performed web services testing using SOAPUI when necessary
- Hybrid framework with Selenium was developed and generic keywords were implemented
- Participated in system walkthrough and inspection meetings to understand the business rules and system operation flows
- Wrote SQL Query to extract data from various database tables for testing purpose
- Validated tests by crosschecking data in backend on SQL server using SQL Queries
- Worked closely with users and program developers to ensure application development meets with the user expectations
- Comerica is a nationwide bank offering personal, small business and corporate banking products
- Wealth Management comprises of lending, mortgage and deposit services
- Environment - Core Java, Selenium WebDriver 2.0, TestNG, MySQL, SOAPUI
Software QA Tester
CIGNA Health Insurance
01.2011 - 03.2012
- Utilized agile methodology for different phases of testing
- Involved in writing and implementing the Test Plan, Test Cases, Test Procedures, Test Sets using design document and functional specs
- Involved in Manual Testing, Functional Testing, and Regression Testing, JUNIT
- Responsible for Smoke testing each build and a detailed testing in the Test environment and certifying the production deployment
- SQL server was used to retrieved, validate data for data verification and data integrity
- Utilized Quick Test Professional to execute and update QTP scripts
- Performed system and functional testing, executed test cases extensively and verified actual results against expected results
- Used TD for requirement management, planning, execution, defects tracking & reporting
- Logged, maintained & tracked defects, assigned type & severity levels, regressed scripts to assign status to defects, configure Test Director to auto-notify developers
- Support developer for troubleshooting issue and provide weekly status reports
- Utilized MS Office to store and maintain necessary files and reports
- Document test results in compliance with the established standards and guidelines
- Participated in weekly team meetings to track and monitor defect resolution
- CIGNA insurance subsidiaries are major providers of medical, dental, disability, life and accident insurance and related products and services
- Environment: Test Director (TD), Selenium, QTP, Windows and MS office
- Java, Oracle, Junit, Eclipse, DB2
Education
Master’s degree - Computer And Information Sciences
Jawaharlal Nehru Technical University
Hyderabad, India.07.2009
Skills
- Manual Testing
- Automation Testing
- QTP
- Java, Maven, Selenium
- Cucumber & Karate Frameworks
- Rest and SOAP service testing
- Traceability Matrix
- Test Cases
- Defect Tracking
- Regression Testing
- Performance Testing
- User Acceptance Testing
- Test case design
- Functional Testing
- Test Data Management
- Test environment setup
- RFT
- Azure ADO - User Stories - Test Cases
- Jira
- Git repositories
- Quality Center
- Eclipse & Spring Tool Suite
- JUnit
- SQL Queries
- Waterfall/Agile Methodology
- ETL (Data extraction and Validation)
- Functional Requirement Specification
- Technical Requirement Specification
- Web-based applications
- Client-server applications
- Automation Test Frameworks
- Communication skills
- Mentoring
- Analytical skills
- Problem-solving ability
- Leadership skills
Timeline
Sr. QA Lead
Federal Home Loan Bank of Dallas
08.2023 - Current
Sr. QA Tester
Microsoft
10.2022 - 07.2024
Sr. QA Tester
State Farm Banking
06.2020 - 09.2022
Lead QA Tester
New York State Department of Health
08.2016 - 02.2019
QA Tester/Analyst
Cablevision
10.2015 - 08.2016
Automation Tester
State Farm
01.2013 - 09.2015
QA Tester
Comerica Bank
03.2012 - 12.2012
Software QA Tester
CIGNA Health Insurance
01.2011 - 03.2012
Master’s degree - Computer And Information Sciences
Jawaharlal Nehru Technical University
Similar Profiles
Roxanna MarinRoxanna Marin
Senior Affordable Housing Analyst at Federal Home Loan Bank of DallasSenior Affordable Housing Analyst at Federal Home Loan Bank of Dallas
ANJANA IMMANENIANJANA IMMANENI
Technical Business Analyst at Federal Home Loan Bank of Dallas (FHLB)Technical Business Analyst at Federal Home Loan Bank of Dallas (FHLB)
Lindsey BreesLindsey Brees
Strategic Planning Manager at Federal Home Loan Bank TopekaStrategic Planning Manager at Federal Home Loan Bank Topeka