Sheela Surapaneni
Email:***********@*****.***
Phone No: 571-***-****
TOOLS/METHODS:
Soap UI, Ready API, Xml Spy, Coded UI, Gitlab, Jenkins, Postman, JIRA, Zephyr, Microsoft test manager, Azure, Selenium, DevOps Visual Studio, .Net, Team Foundation server, Actional Diagnastic, Quality Center, ALM, Sql server, Oracle.
RELEVANT CLIENTS:
US Bank
Wells Fargo
Thomson Reuters
Medtronics
NOVOLOGIXS
Fidelity Investment Services
Global Tel Link
EDUCATION:
Master of Science (Information Systems) from Andhra University, India.
Bachelor of Computer Application from Andhra University, India
ADDITIONAL TRAINING:
MCP (Microsoft certified Programming)
Relevant Experience
16+ years of IT experience with 13 years of Software Quality Test Engineer/QA Analyst and 3 years of .net developer experience.12 years of US Home Mortgage experience. 8+ years experience with Microsoft Visual Studio. Proficient in performing both Manual and Automated testing of applications. Participated in requirements analysis, reviews and working sessions to understand the requirements and system design.
Skills Inventory
Quality Assurance:
Excellent understanding of the Software Development Life Cycle (SDLC), Software Quality Life Cycle (SQLC) and various testing methodologies like Waterfall Methodology, Agile Methodology.
Proficient in performing both Manual/ Automated testing applications.
Expertise in writing System Test Plans, Test Design Specifications, defining Test Case Specifications and Test Procedures, developing and maintaining Test Scripts.
Experience on IntelliJ and Selenium.
Involved with Functional Testing, Integration Testing, GUI Automation Testing, Security testing, Negative testing, Black Box Testing, White Box Testing, System Testing, Usability Testing, Performance Testing, Regression Testing on Client/Server, Mainframe and Web based applications.
Good experience in Web service testing using Soap UI, Groovy script, Test harness, XML spy and Postman.
Additional Tools:
Application Server: IIS.
Languages: C, C++, vb,.Net2.0/3.0/3.5/4.0.
Operating System: Windows 98, 2000 professional, vista, XP, Windows Server 2003.
Database: Oracle 10i, MS-Access, Sql Server 2010, DB2, Main frames.
Development Tools: Visual Studio.Net 2005/2008/2010,Curam, Soap UI, POSTMAN, Intelli J
Dot Net Language’s: C#.Net, VB.Net, ADO.NET and APS.NET, Selenium
Frame Work: ASP.Net 2.0, 3.5, 4.0, TFS, Microsoft test manager, Coded UI, DOORs.
Bug Tracking Tools: Track Plus, TFS, ALM, JIRA.
Version Control: VSS (Visual Source Safe), TFS, Sub version, gitlab, Jenkins.
Other Tools: Active Reports for 2.0, Adobe Photoshop 7, Macromedia, Dream Weaver MX 2004 for PDF, WPF.
Web Technologies: Web Services, XML, XSLT, ASP, AJAX, CSS, SOAP.
Middleware Technologies: Web Services (SOAP, WSDL, UDDI), SOA, COM, DCOM, COM+, Remoting.
Software Tools: FxCop, Nunit, MS-Visio.
WCF, WWF, LINQ, SSIS, SSRS, Active Directory.
CHRONOLOGICAL SUMMARY OF EXPERIENCE
Sr Automation Test Lead/ Sr QA Analyst / BSA
Client: US Bank, Sep 2015 – Till Date
Raleigh NC(Remote)
ER (Early Resolution) is a Decisioning Application in US Bank home mortgage which is used for default user. Default users are the borrowers who are not able to make payments to their home loan due to various default reasons. This application is useful for collectors to reach out to borrowers and be in touch with them about their loan status and coordinating with their borrower employment status and financial status documents. Based on the received documents work over his loan, income, reason for default and other aspects of being default and find out a different and better plan which we be beneficial to the borrower and make them comfortable in loan payment and bring him on to the normal track. There are step by step processes involved in to make the default user to normal like Trail decision, Appeals, midstream, Final. This application is supporting government, GSE, Asset investors currently.
Involved in analyzing and the business requirements and converting them to scenarios and detailed test cases.
Working on test data and Involved in test Execution.
Create / Maintain XML’s to test various test scenarios and debug issues in SOAP UI.
Working in an Agile environment with 3 weeks sprint.
Involved in Planning meeting, grooming calls and Retrospective meetings.
Worked on regression Suite preparation.
Worked with business stack holders to gather business requirements.
Creating business requirements documents and review with business and internal Team.
Involved in regression execution.
Understanding of web services, restful services and ability to test them using tools such as Soap UI, postman, xml spy.
Validating request and response file using. Writing Assertion in Soap UI.
Working in Automation team to automate the Test Cases.
Creating Test cases and in Excel and in Soap UI. Using Excel as data source, Data Transformation, properties and using Groovy script creating Soap UI Automation Projects.
Created Assertion to validate the check points.
Walk through with business on how we are covering the requirements.
Involved in working both manual and automation testing.
Manual testing – Writing Scenarios, test cases in MTM (Microsoft Test Manager).
Automation – Excel, Soap UI, Groovy Script. Write Groovy Script in such a way that test results will write back to excel sheet.
Used Gitlab as version controller to check in and check out code.
Advanced ability to think through negative scenarios and alternative scenarios for best coverage of requirements.
Ability to formulate test strategy, test planning, test data creation and management.
Report the identified bugs in TFS and JIRA. Work with developers and demo them the issue if needed. Once bug is fixed retest and close the bug.
Attending scrum calls, updating TFS (team Foundation Server) and JIRA boards with estimates, Actual burned down hours.
Good technical skills to understand development environments, servers, version controls, Scripting and automation.
Worked on MSP/black night main frames for Loss mitigation loan conditioning.
Used Zephyr for creating scenarios, test cases and execution.
Used Azure DevOps for creating scenarios, creating test suites based on requirements, test cases and execution.
Worked on API testing automation using Ready API/Soap UI and postman.
Modernization of the Groovy scripting application to Selenium, InjetlliJ and Java application
Ability to work on multiple project, flexible and able to understand things fast.
Used sql server to save test results and validate the results.
Maintain and execute regression for every release.
Presenting demos to business and management.
Working with off shore/on shore coordination.
Senior QA Analyst
Client: Wells Fargo, Feb 2014 – July 2014
SLoad is a Decisioning Application in Wells Fargo home mortgage which is used for default user. Default users are the borrowers who are not able to pay home loan due to some issue. Using this application banker will work over his loan, income, reason for default and other aspects of being default and find out a different and better plan which we be beneficial to the borrower and make them comfortable in loan payment and bring him on to the normal track. There are step by step processes involved in to make the default user to normal like Trail decision, Appeals, midstream, Final. This application is supporting the FHA, FNMA investors currently. Future investors will get support is FREDI MAC, Wells owned.
Involved in Analysis, design the business requirements for the project, and translating these into Requirements Analysis Documents.
Involved in analyzing and the business requirements and converting them to scenarios and detailed test cases.
Involved in test case execution to make sure the requirements are properly implemented.
Analyzing, Testing and Certifying application – specific software and performing ambiguity reviews of business requirements and functional specification documents.
Create / Maintain XML’s to test various test scenarios and debug issues in SOAP UI.
Involve in the creation, preparation and conduct of quality assurance reviews.
Whenever any issues comes creating the defects for tracking the issues.
Involved in defect creation, Defect life cycle management.
Involved in End to End testing by verifying front end UI to web services that are been consumed
by the application and database to main frames MSP write backs.
Understanding the complex calculation logic and testing the functionally.
Closely working with BA regarding the requirement related questions, gaps by doing analysis on the requirements.
Involved in Smoke testing.
Working with Data team on requesting test data and make the loan ready for testing.
Working with developers for any technical issues, gaps. Like any design issues. Design not matching the given frame work.
Coordinating with offshore team and working with them on work assignments and coordinating with team over here for their questions.
Involved in web service testing using transaction viewer, data base testing for SQL server, Oracle and main frames.
Understanding the application flow from mainframes to data base, internal rules engine, external rules engine and there from Data base write backs.
Understanding the data base mapping structure and writing complex queries to validate the data.
Involved in internal rules testing by testing request and response been generated by the web services.
* Worked on RTC ( Rational Team Concert ) Project area preparation to defining timelines, Iterations, creating team areas, Roles, Categories and work types.
* Used Iteration planning of RTC for integrated iteration planning and execution task estimation linked to key milestones, out of box agile process templates.
* Generated real time metrics, reports, Project milestone tracking and staus of project using Rational Team Concert.
* RTC – Clear Quest is configured as a bug tracking system to open, tracking, report defects.
* Created sprints, user stories for the backlog items to final delivery, features, prioritize product backlog using Rational Team Concert.
* We used Rational Team Concert for integrated, including iteration planning, Process definition, Source control, defect tracking, build management and reports.
* RTC to use burn down charts, project status, visual of work completed, indication of team velocity report to scrum master while do participate in the standup meetings.
Testing the complex rules. How the rules are firing.
Participating on daily status calls for tracking status, risks, and Road blocks.
Working closely with lead for any kind of coordination towards follow up on surf status, reposts or any kind of coordination with BA, developer.
Involved in boundary testing.
Flexible on working on different projects based on the project priority and scope.
Handling different challenges and jump on to the issue working towards fixing issues by coordinating with the team to go project smoothly for ultimate success of the project.
Involved in knowledge transfer by conducting training sections to the new team members.
Balance multiple tasks and coordinating onshore – offshore team work assignments.
Senior QA Analyst
Client: Thomson Reuters, June 2013 – Feb 2014
Small Law form, large law form these are different applications that are providing services to the different law form clients to manage their documentation. Deadline calculator new main feature that is been implemented to intimate ahead of time to submit the required documents to the law department on time. Based on case details entered in to the system it will calculate the deadlines on submitting the required documents on time automatically. Fully supporting documents management based on the case level to the lawyers towards their client cases.
Involved in Agile process. Actively participating in the sprint planning meeting for 2 weeks planning meeting. Understanding in the requirements, planning the test approach and providing the testing planning to test lead.
Based on the story
Creating the test tasks and linking test tasks to actual story been created by BA.
Participating the daily status call to track the status of the story development and testing.
Creating the Automation framework using visual studio, Selenium, C#.net, web driver.
Implementing the new classes, methods for new functionality testing.
Developing the scripts based on the standards.
Participating in Peer reviews for the developed automation script.
Code check in daily
Using fire bug to identify the object. Code checkin in to Team foundation server.
Defect tracking through TFS(Team Foundation Server). Linking the defect to the corresponding story.
Generating reports on TFS. Coordinating with offshore team.
Checking the daily regression reports and updating the regression test cases as per the UI changes or opening the defect based on the issue.
Involved on smoke testing after 2 weeks of production deploy.
Working with test data teams for test data request.
Data base testing writing queries to check the data base.
WCF service testing using Actional diagnostics tool.
Senior QA Analyst
Client: Medtronic, August 2012 – May 2013
Medtronics manufacturing the different medical devices like pacemakers. Medtronic is a web application which tracks the wireless devices functionality. It will generate echo reports of the heart for the face makers. Generates reports for the pace maker functionality. Supports different types and versions of devices based on the patient need.
Involved in Analysis, design the business requirements for the project, and translating these into Requirements Analysis Documents.
Responsible for Manual and Automation Testing.
Experience in Scrum, participating in daily stand up meetings and coordinating with Remote Team.
Creating WORK ITEMS, related bugs in TFS for the SCRUM.
Updating TFS Task items and makes it available for review, Maintaining TFS Tasks for the SCRUM planning.
Writing the Test plane based on the Story (functional document).
Working closely with the Business Analysts and participating in to the standup calls for 3 weeks iteration plane for the scrum.
Developed and execute manual and automated tests in different platforms using C#.
Using HP Quality Center 11.0 to prepare test plan, test cases and test data.
Actively participated in Iteration Planning, Stand-ups, and Team Retrospectives.
Developed software-testing artifacts within an agile process.
Test case walkthrough with other team members and QA manager / Lead.
Involved in Functional, Integration, Regression, UAT, E2E and Implementation Testing
Involved in The Requirements Analysis and creating Test Plan.
Developed and actively participated in build test automation using C#.
Created and managed software quality assessments; including anticipating project needs and implication of project decisions on quality.
Writing the Test Planes for the feature which are assigned.
Develop High-Level and Detailed Test Cases from business requirements and technical specifications.
Developed test scripts/testing solutions through analysis of product specifications, software requirements specifications, and software prototypes.
Developed the Test strategies for the areas assigned by analyzing requirements, design and overall project goals. Involved in Grey testing.
Involved in testing the newly implemented features like EHR and Export option functionality in IPhones and Ipads.
Health care, Medical devices supporting application testing.
Analyzed and document all issues discovered during testing. Verify and close issues resolved during the release cycle.
Partner and build the relationships with others throughout the testing, software development and in the Agile test development environment.
Actively participated in planning, estimation, and prioritization processes to ensure successful execution of testing activities
Updated test cases when appropriate to reflect changes in product functionality or requirements
Executed test cases/suites for assigned software releases.
Involving in the developing Test Procedure based on USE Cases or Scenarios.
Identifying the Test Variables. Defining and Setup the test data in different environments once they are available.
Created user stories, creating tasks as per the story, writing defects in JIRA,
sprint testing status tracking through JIRA reports.
Develop the Test Strategy and process for testing based upon NMDP’s standard test process.
Experience on Python Script for creating CLINICS and USERS.
Involved in testing of the web application features for CLINICS and PATIENTS.
Based on the Users Permission need to verify the Features availability for the users.
Developed and executed the Testes using Coded UI.
Experience on ALLPAIRS for identifying the Test Scenarios based on Test Variables.
Creating the Test Procedures in Excel Spread Sheet Mapping in QC.
Involved in Test Execution.
Involved in Regression Testing. Mainly responsible to identify the Regression tests and creating a Regression plane and execution report.
Involved in data base testing. Responsible for writing queries to retrieve data and do verification.
Test Development experience in Test Manager for creating Automation scripts and Check-in the code in TFS.
Sr. QA Analyst
Client: NOVOLOGIXS, July 2012 –June 2012
Involved in Analysis, design the business requirements for the project, and translating these into functional specifications.
Writing the Test plane based on the Story (functional document).
Working closely with the Business Analysts and participating in to the standup calls for 3 weeks iteration plane for the scrum.
Involved in testing the Windows Service and the functionality to connect to the Data base and generate letters for Authorization systems and claims processing.
Involved in testing of the web application which actually generating the Auth letters and inserting in to the data base including the data base.
Health care Experience on generating letters for Authorization systems and claims processing.
Involved in Testing the WCf services which are consumed by the Web Application.
Writing the VB script and execution of the scripts.
Actively participated in System testing, integration testing and coordinated for UAT.
Involved in providing the Testing Effort estimates and provided the timely feedback on progress of the testing activity.
Worked on 837, 835, 276 and 277 Institutional and Professional, EDI Gateway.
Worked Extensively with Inbound 837 I and 837 P, 835s(Out bounds) claims processing systems.
Involved in testing maps and translated data.
Performed Black Box, Integration testing, Negative, and positive and testing.
Generated the execution results and sent it across to the team, by way of gathering and analyzing the Test Metrics for the purpose of reporting.
Created the Regression Test cases and automated them for the purpose of regression testing.
Working with QA manager/ Lead / Project Manager for necessary planning schedules to test deliverables.
Using HP Quality Center 10.0 to prepare test plan, test cases and test data.
Used Quality Center for managing the defect flow.
Sr. QA Analyst- International Trading
Client: Wells Fargo, April 2012 –June 2012
Involved in Analysis, design the business requirements for the project, and translating these into functional specifications.
Involved in the Analysis and design of the USE CASES.
Involved in the Testing based on the Tibco Use cases and system Rules.
Working closely with the Business Analysts and participating in to the standup calls for 2 weeks iteration plane for the scrum.
Manage day-to-day project task assignments such as task prioritization, estimates, and time reporting. Proactively work to identify, clarify, and resolve issues, and remove barriers within a timely manner.
Work with project managers and management to set priorities and to address escalated items.
Understand the technical aspects of the project i.e. environments, configurations, data validation, databases, and security in order to fully assess and substantiate testing needs.
Proficiency with the Microsoft Suite tools.
Work with QA Manager/QA Lead as necessary from planning, scheduling to execution.
Validating the XML file, .CSV files through Quick Test Pro Scripts.
Writing the VB script and execution of the scripts.
Participation PRD reviews business impacts, feedback and final approvals.
Using HP Quality Center 10.0 to prepare test plan, test cases and test data.
Test case walkthrough with other team members and QA manager / Lead.
Involved in testing the Windows Service and the functionality to connect to the various MQ servers and read the messages and process them in the windows services.
Sr. QA Analyst- Global Remittance
Client: Wells Fargo, August 2011 –March 2012
Involved in Analysis, design the business requirements for the project, and translating these into functional specifications.
Involved in Life Cycle Development (SDLC), provided value added services with Test Team, development teams and clients throughout the life span of a project, strategic consulting; code writing; and managing complex testing schedules and tasks.
Involved in testing web services using Actional Diagnostics. Involved in creating the function requirement specification and technical specification documents.
Contacting and coordinating with the Business users for the business requirements and translating them in to Function specification documentation in the design phase.
Testing the web n-tier middleware applications using .Net Framework (VS.Net, C#, ASP.Net and ADO.Net code with Oracle, sql server as the database.
Involved in Testing the Application layer, Business Logic layer and User Interface
Testing the web services with XML web service (SOAP) using .Net, Involved in ntier application development DAL, Business logic and UI.
Involved in creating the new web services and publishing which are consumed by the other teams in wells.
Testing complex queries, views and procedures in ORACLE data base.
Involved in creating the Data mapping and messaging with MQ Series.
Writing the VB script and execution of the scripts.
Testing the Core Reusable components utilizing C#. Net, ASP.Net and SQL Server.
Sr. QA Analyst
Client: Fidelity Investment services, January 2011 – August 2011
Involved in understanding and transmitting the business requirements for the project, and translating these into functional specifications.
Involved in documenting Technical specification document or design document based on function Specification document and using UML for documentation.
Testing the web n-tier middleware applications using .Net Framework (VS.Net, C#, ASP.Net and ADO.Net code with Sql Server, oracle as the databases, DB2 and main frames.
Testing Client, server communication using Asynchronous socket programming.
Involved in testing the Application layer, Business Logic layer and User Interface
Testing web services with XML web service (SOAP), WCF services using .Net, which provides facility rules information to the Facility module.
Testing the reports for CallDeatilReport which are sending across the clients, developed using crystal reports.
Writing the VB script and execution of the scripts.
Testing the ASP.NET MVC Web Application project for building unit tests that can be used for Test-Driven Development.
Testing Web Forms Custom controls, User Controls and Code behind pages using .Net Framework.
Sr QA Analyst-TeleCom web Application
Client: Global Tel Link Jan’10 –Nov’10
Global Tel Link is a telecommunication system providing exceptional telecommunications service to correctional facilities. GTLLazerweb is a web Appliation which provides telecommunication to DOC (Department Of Correction) of US Jails. Lazer web application includes Call Monitoring, Accounts, Phone Numbers, Stations, User Permissions, Groups, Facility Rules and Reports. Call Monitoring will keep track of all the calls which are made by the prisoners and in this module Officers can listen, cut call, enable and disable the calls. In Account Module they can create and view the Account. In Phone Numbers module Create, View and Manage the Phone Numbers. In Station Module based on the facility they can check the available Stations, Enabled and Disabled Station Groups module is to create new groups for each facility basis and to manage the existing groups. Facility Rules deals with Schedule, Call duration, Global Free, Call Restriction Specification, Velocity based on the Facility. User Permissions module is to create view and modify the new users, permissions and for existing user based on their level.
Involved in understanding and transmitting the business requirements for the project, and translating these into functional specifications.
Involved in Life Cycle Development (SDLC), provided value added services with development teams and clients throughout the life span of a project, strategic consulting; code writing; and managing complex Testing schedules and tasks.
Testing web n-tier middleware applications for sales using .Net Framework (VS.Net, C#, ASP.Net and ADO.Net code with Sql Server as the database.
Involved in testing and Integration in all Module.
Testing web n-tier middleware applications using .Net Framework (VS.Net, C#, ASP.Net), ADO.Net code with Sql Server as the database.
Testing web services with XML web service (SOAP) using .Net, which provides facility rules information to the Facility module.
Testing Web Forms Custom controls, User Controls and Code behind pages using .Net Framework.
Testing the web services and XML standards, including SOAP and testing the prototype using XML web service (SOAP) for data transfer over HTTP network.
Testing Ajax controls which are in Ajax control tool kit like hover menu, collapsible, update pane.
Testing the Activex Reports for usage and revenue, investigation, prepaid, Administration, Diagnastics and calling card for GTL Lazer Web Application.
Testing Stored Procedures using Sql Server.
Provided post production support for newly implemented features.