PEREINCE SUMMARY
Over *+ Years of experience as Software Quality Assurance, GUI, System and Integration Testing, Functional/Regression Testing, Data Migration, Interface, Data Upload, Data Integrity/End to End testing of Web and Client/Server based applications
Prepared test data and helped load test data into the test database environment.
Experienced in the creation of use cases and the development and maintenance of test specifications, test cases, test scripts and test data
Experienced in use of Automation tool QTP
Worked closely with developers on defect tracking and fixes, and assignments to QA for retesting. Defect/Agile Waterfall project methodologies Stories were tracked in JIRA.
Proficient in both Manual and Automated Testing Tools such as QTP, Win Runner.
Extensive knowledge of SDLC (Software Development Life Cycle) methodologies.
Experience in working with Agile methodologies and active participant of SCRUM meetings.
Good Experience with Agile/Scrum and Waterfall development processes.
Strong knowledge Microsoft Test Manger & Coded UI tools (include writing and executing Automation scripts)
Expertise in automating functional test cases, test data in XML standards and writing Test scripts using automation tools
Participated in design Walkthroughs and Inspection meetings to review Test scripts and results.
Extensive working experience in Oracle on UNIX Environment.
TECHNICAL SKILLS
Project Methodologies: RUP, Waterfall, Agile, SCRUM, V
Languages: C#, C, C++, VB Script, SQL, ASP.Net, PL/SQL
Web Technologies: HTML, XML, JavaScript, VBScript
Defect Tracking Tools: ALM/Quality Center, Team Track, Clear Quest, Bugzilla
Operating Systems: UNIX, Windows,
RDBMS: MS SQL Server, Oracle, DB2
Query Tools: TOAD, MS SQL Server Mgmt Studio, My SQL,
Business Applications: Microsoft Office Suite – MS Word, Excel, PowerPoint, Outlook, MS Visio,
Testing Tools: Quick Test Professional (QTP), SOAPUI
PROFESSIONAL EXPERIENCE
PNC Bank, Pittsburg, PA
Sr. QA Analyst/ Tester/ Test lead
May 17 – Present
PNC is a highly diversified and growing financial services organization spanning the retail, business and corporate markets. PNC offers a wide range of services for all our customers, from individuals and small businesses, to corporations and government entities, their business are categorized in to Retail Banking, corporate and Institutional Banking, Asset Management and other services like the Borrowing, Investment, Insurance, Online Banking, Activities, e-statements, Home Loans, Equities, Mortgages, Loan center. The project was to create a Test automation system to deal with Mortgage based on Home Value, Loan Amount, Interest Rate, Loan term, Start Date, Property Tax, and Private Mortgage Insurance. Based on Customer requirement specifications, System enables mortgage Repayment Summary along with Re-payment chart, Balance graph
Responsibilities
Interacted with the developers to report and using HP ALM/Quality Center.
Attended Change Request Meetings to ensure products and changes are fully documented for further Test changes.
Executed test cases through HP ALM/Quality Center and reported defects in QC.
Automated for different transactions in an Insurance Policy. Designed Functions Library, Functions, Subroutine's, Common functions, Utilities functions, Regular Expressions and Environmental variables using Visual
Performed various types of testing such as Functional, Regression, SIT, UAT, Backend etc.
Detected, reported and tracked defects using HP ALM/Quality Center.
Created Test Plans and Scenario which describes the features and functions to be tested.
Identified test scenarios and wrote test cases based on mapping document, functional document and transformation rules.
Manage software testing program for the ePolicy, eClaims and eFinancial systems (Insurance Policy and Claims system)
Testing includes Functional testing on CICS Mainframe system and web based functional testing which includes transaction for the generation of Insurance policy numbers, claim details, Rating calculation and verification.
Conducted the defect report in HP ALM/Quality Center.
Worked on payments with FFP,FFS, PRT and SMS
Worked on salesforce application with all interface team involve in testing.
Managed posting payment, verifying errors and performing resolutions.
Managed pay cycle process including Reviewing, Verifying and also processing credit and debit memos
Verifying every single logs of payment on DB as well as OCCP.
Validated Counts, Referential Integrity Checks, table structures, and transformation rules in Source and Target tables
SQL Queries for backend testing
Work in Agile, scrum, and sprint environment in order to change the requirements and features set.
Wrote and executed complex joins and sub queries to incorporate and test Mapping rules
Wrote test cases in HP ALM/Quality Center
Extensively used SQL queries/Unix commands for data verification and backend testing.
Establish test processes for Agile development life cycle of P&C Insurance policy administration system interfacing with Underwriting, Rating, Policy Forms, Policy Issuance,
Executed test cases and logged in defects for failed test cases in HP ALM/Quality Center
Developed and executed test cases test Scenarios and followed-up defects using HP ALM/Quality Center
Responsible for communicating Defect Status Reports to business in project meetings.
Actively participated Agile and Scrum meetings, review and developed test scenarios
Performed Backend Testing by using SQL Queries for the purpose of database integrity
Developed the reports using HP ALM/Quality Center.
Followed Agile Methodology to emphasize on real time communication over written documentation
Worked with developers to resolve Issues and Production Incidents using HP ALM/Quality Center
Checked the data flow through the front end to backend and used SQL queries, to extract the data from the database.
Environment: Windows, SQL, Server, HP ALM/Quality Center, SOAP UI, SOA, XML, SQL, QTP, Web logic, UNIX, Oracle, Agile, UAT
Thrivent Financial, Minneapolis, MN
Quality Assurance Manual Tester Oct 2016 – April 2017
Salesforce Tester
Review, analyze & evaluate complex business systems, processes and user needs
Define scope, objectives and requirements on multiple projects.
Assist in defining and designing system requirements and recommends solutions to a business needs
Perform execution of test cases manually using Quality Center.
Experience in testing with various Salesforce.com standard objects like Reports and Dashboards, Leads, Accounts, Contacts, and Opportunities along with Campaigns.
Extensive experience over creating and testing Salesforce CRM Workflows, Approval Processes, Validation Rules and Sharing & Security rules.
Develop custom Objects and Fields as specified in the scope document
Create data flow diagrams and process flow diagrams to facilitate better system understanding.
Track and maintain the requirements to functionality traceability and use case traceability.
Analyze Business requirements and solution specification documents to design Test Plans, Test cases.
Define requirements in Quality Center and map with the respective test cases for traceability.
Regularly participate in Technical and Used Case review meetings for various functionalities in the application.
Involve in defect triage meetings, reviews for functional requirements, Test case scenario and User Acceptance Testing.
Prepare Test Strategy and Test Plan for all the applications.
Analyze Business requirements and solution specification documents to design Test Plans, Test cases.
Perform Test Plan/Test case review meetings during testing phase.
Implement execution of test cases manually using Application Life Cycle Management.
Use MS Excel sheet for comparing the millions of records and its fields.
Maintain multiple versions of test sets and work on regression testing.
Perform data validation testing, wrote test cases based on business scenarios.
EDUCATION
Bachelors in Management.