Prawesh Joshi
Durham,NC
Summary
A result-oriented individual with over 6+ years of diversified experience as QA/Data Analyst.
Good knowledge and experience working with Retail/ Ecommerce, Banking and Healthcare Clients.
Experienced and comfortable working on various databases like SQL Server, Oracle, and DB2.
Proficient in Data Governance, Data Lifecycle, Data Quality Improvement, Master Data Management (MDM), and Metadata Management.
Excellent skills in writing Test Plans and Test Cases.
Extensive experience in testing Client/Server and Web-based Applications.
Expertise in Bug reporting tools such as JIRA, Version One, Test Director and Quality Center/ALM.
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.
Excellent understanding of STLC process and experience in working with Agile/SCRUM development methods.
Very good experience in Back-End Testing using SQL and Windows platform to validate the consistency of data.
Proficient knowledge in various types of Software Testing such as Unit testing, Integrated testing, System Testing, Black box testing, Positive Testing, Negative testing, Back-end Testing and Regression Testing.
Supported UAT team in their release level testing from end-to-end basis.
Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
Experience in creating and implementing interactive charts, graphs, and other user interface elements.
Experience in writing complex SQL scripts/ queries to perform End-to-End ETL validations and support Ad-hoc business requests.
Deep experience with the design and development of Tableau visualization solutions.
Good working knowledge of major Operating Systems such as Windows 98, 2000,2010, XP, Vista, 7.
Extensive knowledge of SDLC and STLC methodologies.
Excellent communication and writing skills with the ability to adapt to new and dynamic environments.
Good team leader, Player and can work alone with minimal supervision.
Ability to multi-task, prioritize and work with time constraints while paying attention to details.
Excellent communication, interpersonal & analytical skills.
Creative and Aggressive person capable of forming and maintaining positive and productive team environments with integrative thinking skills.
Strong business analysis skills and thorough understanding of full SDLC.
Overview
8
8
years of professional experience
Work History
QA/Data Analyst
Wells Fargo
Raleigh, NC
10.2021 - Current
- 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
- Gathering and documenting business requirements for testing and data analysis projects
- 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
- Using data management skills to define policies and procedures to ensure that data is collected, stored and analyzed securely and efficiently
- Developed optimized SQL queries to retrieve and manipulate data from various databases, ensuring efficient performance and data integrity
- Used Tableau and Excel for extracted data and data analysis, gathering reports, graphics and statistical analysis
- 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
Business / Data Analyst
Amazon
Minneapolis, MN
02.2020 - 10.2021
- Company Overview: The project is more of Process Improvement in maintaining and optimizing the existing databases
- Observing database performance and growth, performance, to create reports and requirement gathering according to the business requirement
- Analyzed customer transaction data to identify trends and patterns, informing strategic decisions for improving the online payment process and increasing conversion rates
- Used Java and Selenium to create reusable test scripts for common web application tasks, such as login, product search, and checkout
- Developed test plans, executed test cases, and ensured traceability to capture both functional and non-functional requirements, including JavaScript requirements
- Utilized SQL queries to extract and manipulate data from the database, providing insights into customer behavior and preferences
- Validated web services directly in browsers, ensuring accuracy in data retrieval and delivery
- Assisted in the selection of third-party software packages tailored to Amazon's business needs
- Developed predictive models to forecast future sales and optimize inventory management, reducing stockouts and improving customer satisfaction
- Extracted data from databases using SQL for analysis of online payment processes and e-commerce functionalities
- Collaborated with development teams on localizing the website, ensuring correct translation and representation for diverse user groups
- Collaborated with developers to troubleshoot and resolve Selenium-related issues
- Collaborated with the marketing team to segment customers based on their purchasing habits, enabling targeted promotional campaigns and personalized shopping experiences
- Developed functional specifications for store-side order entry systems interfacing with electronic catalogs and POS systems
- Developed SQL scripts for data validation and integrity checks during testing phases of web application enhancements
- Designed KPIs to monitor business performance and drive growth
- Utilized Selenium for automated testing, ensuring that new e-commerce functionalities were robust and met user requirements
- Generated reports and dashboards using Tableau to visualize key metrics, such as revenue, customer acquisition cost, and average order value, facilitating data-driven decision-making across the organization
- Conducted in-depth Gap Analysis, evaluating the existing and proposed system architectures
- Coordinated with cross-functional teams, suppliers, and vendors in weekly project meetings
- Provided feedback to the development team on defects and application behaviour, ensuring software met end-user expectations
- Conducted comprehensive UAT for online payment systems, including PayPal, Credit & Debit Card, Authorize.net, and shopping cart functionalities
- Focused on responsive design testing, ensuring compatibility across various devices, and understanding how different breakpoints influenced page layouts
- Tested integrations that were primarily data-driven, ensuring seamless interoperability between systems
- The project is more of Process Improvement in maintaining and optimizing the existing databases
- Observing database performance and growth, performance, to create reports and requirement gathering according to the business requirement
QA / Data Analyst
Prime Therapeutics
Eagan, MN
10.2019 - 12.2020
- 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
Data Analyst
Citi Bank
Washington, D.C.
06.2018 - 08.2019
- Company Overview: This was an enhancement project targeted towards improving the online banking application in order to allow for smooth banking operations both for internal and external customers
- Part of the development and technical team which ensure that the enhancements would meet the defined business requirements
- Gathered functional business requirements through various business intelligence tools
- Executed data cleanliness and enhancement in the project
- Wrote multiple complex SQL queries to enhance the project SDLC and meet business requirements
- Identify, analyze, and interpret trends or patterns in the process of data enhancement sets
- Actively work with business users to gather requirements for the design and development teams
- Utilized SQL for data extraction, transformation, and loading (ETL) to support data enhancement initiatives
- Interpret and analyzed business requirements to produce system requirements for the technical team
- Writing multiple complex SQL queries which enhance the project SDLC
- Actively involved in Compiling and Generating Reports in a Presentable Format to the Project Team
- Worked with the management to prioritize business and information needs of confidential data and information according to guidelines
- This was an enhancement project targeted towards improving the online banking application in order to allow for smooth banking operations both for internal and external customers
Quality Analyst
Northern Natural Gas
Omaha, NE
02.2017 - 04.2018
- 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
Education
Master of Science - Finance
Texas A&M University
Commerce, TX12-2011
MBA - Business Administration
Texas A$M University
Commerce, TX12-2011
Skills
UNIX
Windows 98
Windows 2000
Windows XP
Windows Vista
Windows 7
Windows 10
SQL
VB Script
C#
Oracle
Teradata
DB2
MS SQL Server
SQL Developer
SQL Server Management Studio
TOAD
Informatica Power center
Query Design Center
QC/ALM
JIRA
Smart Bear
Spec Flow
Selenium
Post Man
Chrome
Mozilla Firefox
MS Internet Explorer
Safari
Visual Studio
Eclipse
Autosys
Pac2000
MS Office
MS Outlook
Microsoft Teams
Skype for Business
Tableau
Timeline
QA/Data Analyst
Wells Fargo
10.2021 - Current
Business / Data Analyst
Amazon
02.2020 - 10.2021
QA / Data Analyst
Prime Therapeutics
10.2019 - 12.2020
Data Analyst
Citi Bank
06.2018 - 08.2019
Quality Analyst
Northern Natural Gas
02.2017 - 04.2018
Master of Science - Finance
Texas A&M University
MBA - Business Administration
Texas A$M University
Similar Profiles
Laxmikanth ChittampallyLaxmikanth Chittampally
Senior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells FargoSenior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells Fargo
Mayank OberoiMayank Oberoi
Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)
Kavya S PrabhuKavya S Prabhu
Senior Institutional Investment Analyst at Wells FargoSenior Institutional Investment Analyst at Wells Fargo