Prawesh Joshi

Company Overview: Wells Fargo is an American multinational financial services company headquartered in San Francisco, CA, with central offices throughout the United States. It is the world’s fourth largest bank by market capitalization and the third largest bank in the US by total assets.

• Experience of working in agile environment for SDLC (Software Development Life Cycle) methodology
• Actively participated in daily stand-up meeting on order to update the team about the given task and progress
• Review the Business requirements and ensure the testability of these requirements
• Developed test scripts based upon business requirements and processes
• Prepared Test Scenarios by creating Mock data based on the different test cases
• Reported defects and status of the defects in HP ALM
• Coordinated and participated in generating the test data required for various test activities
• Written and executed the functional and regression test script using Specflow in Visual studio
• Developed new functionalities based on ASP.Net framework for Client/Server, Object Oriented and web based multi-tier architecture applications
• Experience with systems integration testing applications developed for the .NET platform
• Experience in automating test cases using Selenium WebDriver in visual Studio (Using C#)
• Used GitHub to maintain and manage the build scripts, test data used and other documents related to the project
• Experience in using TFS GIT, GitHub to deploy developed codes to Dev and QA environment and store, merge, push, pull developed codes as well as make a pull request at the time of code freeze
• Experienced in Web Services testing using SOAP UI and POSTMAN tool to Validate request and response XML, SOAP and RESTFUL Web service calls
• Developed Test Scripts to implement test cases, test scenarios and features for BDD (Behavior Driven Development) using cucumber in Gherkin format
• Used SQL Server Management Studio, Query Design Center (DM SQL) tools to develop and performed backend validation for the developed scripts
• Initiated Work Request in PAC2000 and actively performed QA database refresh which included querying in Prod and request to move the loans from Prod to QA database for quality development and testing
• Written several complex insert, update and delete SQL queries to update the database table
• Communicated risks and escalated issues to supervising Manager as required
• Conduct walk through meetings with various teams in understanding the QA processes, bug life cycles, QA documentation
• Performed Smoke, Sanity, Functional, Regression, Data Integrity, System, Compatibility and User Acceptance Testing including GUI testing
• Escalate any issues that could potential create hindrance to testing progress
• Conducted prerelease meetings and documentation approvals
• Provided test data and assisted UAT team as per the request in each release level testing
• Attended various meetings with product owner, scrum master, developers, business analyst and stakeholders in order to understand the business requirement
• Provided status reports on test execution, and defects identified during testing
• Wells Fargo is an American multinational financial services company headquartered in San Francisco, CA, with central offices throughout the United States
• It is the world’s fourth largest bank by market capitalization and the third largest bank in the US by total assets
• Environment: SQL Server Management, QC/ALM, SpecFlow, Selenium, Nunit, Postman, Autosys, Visual Studio, Eclipse, Windows 10, Query Design Center, SQL, JIRA, NOTEPAD++, Confluence WikiD, SnagIt, MS Outlook, Microsoft Team, GitHub and PAC2000

Company Overview: Wells Fargo is an American multinational financial services company headquartered in San Francisco, CA, with central offices throughout the United States. It is the world’s fourth largest bank by market capitalization and the third largest bank in the US by total assets.

• Worked on Agile methodology for functional testing
• Actively participated in daily stand-up meeting on order to update the team about the given task and progress
• Performed task-assignment and coordinate with on site team members
• Responsible for collaboration with business analyst and Project management to review, perform complex analysis and understand business rules, requirement and system specifications
• Created and execution of Test Plans, Test Scripts and Test Cases using Manual Techniques
• Documented all phases of Systems QA process i.e
• Review requirements, Test Planning, System testing / validation, defects and sign-off
• Participated QA meetings to discuss tech specs review, functional specs review and defects tracking
• Performed UI/GUI, functional, regression, sanity and configuration testing on the application
• Used HP ALM for executing scripts, reporting and tracking defects and also create reports and update bug status
• Used Jira tickets and QA request form created by the developers to get the insight for QA validation and update details for QA testing progress and reported defects for any enhancements, CR’s and Trouble tickets (Production Tickets)
• Categorized bugs based on the severity and interacted with developers to resolve in timely manner
• Worked closely with the UAT team and provided all the necessary details for UAT testing that included details about testing scopes, QA validation screenshots, reported defects etc
• Wells Fargo is an American multinational financial services company headquartered in San Francisco, CA, with central offices throughout the United States
• It is the world’s fourth largest bank by market capitalization and the third largest bank in the US by total assets
• Environment: Agile Methodology, HP/ALM, Jira, SQL Query design Center, SnagIt, MS office, MS Outlook

Company Overview: Prime Therapeutics LLC provides pharmacy benefit management solutions. The company manages pharmacy benefits for health plans, employers, and government programs, including Medicare and Medicaid. It also processes claims and delivers medicine to members offering clinical services for people with complex medical conditions. The company facilitates members to get personalized support from a team of pharmacists and clinical experts; assists doctors and healthcare professionals in delivering evidence-based care; and allows employers to enhance employee health. Prime Therapeutics LLC has a strategic alliance with Walgreen Co

• Responsible for planning and directing Quality Assurance and Software change control policies
• Coordinated in setting up Test Environments and Test Plan needs with team members
• Developing various Test Scripts, Test Execution using ALM based on the Functional Specifications
• Developed SQL Queries for Back-end testing/Database testing and performed end to end testing
• Web Service testing using Postman and SoapUI
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Expertise with System Testing, Functional Testing, Regression Testing
• Prepared Traceability Matrix with requirements versus test cases
• Provided daily and weekly status reports
• Prime Therapeutics LLC provides pharmacy benefit management solutions
• The company manages pharmacy benefits for health plans, employers, and government programs, including Medicare and Medicaid
• It also processes claims and delivers medicine to members offering clinical services for people with complex medical conditions
• The company facilitates members to get personalized support from a team of pharmacists and clinical experts; assists doctors and healthcare professionals in delivering evidence-based care; and allows employers to enhance employee health
• Prime Therapeutics LLC has a strategic alliance with Walgreen Co
• Environment: DB2, HP ALM, SQL, POSTMAN, SOAP UI, NOTEPAD++, ADVANCED QUERY TOOL v9 (AQT), SAS, MS Office

Company Overview: Capital Group is an American financial services company. It ranks among the world's oldest and largest investment management organizations, with over $2.6 trillion in assets under management.

• Responsible for generating the files for various downstream application
• Testing requirement analysis, Defining test strategy and plan
• Identify the project and testing risks and dependencies and reporting to the project manager
• Issue tracking and solving from onsite
• Discussion with offshore team members about the work status and issues if any on daily basis
• Status call with client and all the project stakeholder
• Effectively communicate testing activities and findings in oral and written formats
• Provided status reports on test execution, and defects identified during testing
• Involved in backend testing with SQL, check the data integrity and referential integrity
• Extensively used SQL queries to check storage and accuracy of data in database table
• Maintained documentation on different types of testing performed in Microsoft Excel Sheets and Microsoft Word
• Conducted Discussions and meetings with designers to understand the application and the overall functionality of the system
• Interacted with the developers on resolving the reported bugs and various technical issues
• Environment: SQL Server, TOAD, UNIX, Informatica Power Center, SQL, HP ALM, JIRA, Notepad ++, MS Office, Autosys

Company Overview: Northern Natural Gas owns and operates the largest interstate natural gas pipeline system in the United States. Northern Natural Gas' pipeline system stretches across 11 states, from the Permian Basin in Texas to Michigan's Upper Peninsula, providing access to five of the major natural gas supply regions in North America

• Responsible for creating Test plan, development of test scripts, execution, validate Test results, and document test evidence
• Executed test cases, and test scenarios for User Acceptance (UAT), Functional and Regression test cases
• Reviewed unit test cases and test results and certified the code for Integration testing
• Created user acceptance testing documents and reviewed them with the customer
• Mapped test cases to requirements using Quality Center
• Involved in entering and tracking defects using Rational Clear Quest
• Involved in communicating with support, business and development teams to resolve issues during test execution
• Involved in testing the batch programs by using the Autosys tool
• Conducted reviews of test plans, test cases, and prepared test results
• Prepared Test Scenarios by creating Mock data based on the different test cases
• Effectively communicate testing activities and findings in oral and written formats
• Facilitated the sharing of structured data across different information systems using XML
• Extensively used SQL programming in backend and front-end functions, procedures, packages to test business rules and security
• Done data validations for Business Objects reports
• Performed Backend testing by writing SQL queries
• Created Test input requirements and prepared the test data for back end testing
• Provided status reports on test execution, and defects identified during testing
• Northern Natural Gas owns and operates the largest interstate natural gas pipeline system in the United States
• Northern Natural Gas' pipeline system stretches across 11 states, from the Permian Basin in Texas to Michigan's Upper Peninsula, providing access to five of the major natural gas supply regions in North America
• Environment: Oracle 9i, Toad, DB2, SQL, SQL Server 2003/2005 SSIS, SSRS, Smart Bear, JIRA, UNIX