Prasad
Email: *******@*****.*** - Phone: 506-***-****
A seasoned QA with 10 years of experience in Software Testing [Manual testing and exposure to Automation testing using QTP 10.0]
Extensive customer facing & consulting experience for User Acceptance Tests [UAT], Business UAT and Interface Testing [IAT].
Experienced in managing multiple projects in parallel.
Experienced in Wealth Management/Capital Markets (FX, Funds, Equities, Bonds).
Working experience in organizations complying with CMMI Level 4.
Well versed with Software development life cycle (SDLC) and Software Testing life cycle (STLC) methodologies.
Handled Testing tasks from planning, execution, release and delivery.
Experience in Leading Onshore and offshore QA Leads and Team.
Expertise in Testing Business Objects (Desktop Intelligence, Web Intelligence, Universe Designer, Crystal Reports, Dashboards, Central Management Console and Business Objects Administration).
Analyzed and run database reports via Crystal and SQL.
Expertise in MS Office (Excel), SQL and Crystal Reports.
Experience in full life cycle gathering requirements, documentation and testing BI Solutions.
Involved in review meetings with Project Managers, Developers and Business Associates during Project Planning, Coordination and implementing various QA methodologies.
Tested complex WebI reports with multiple data providers
Tested Dashboards using SAP Business Objects Xcelsius Dashboard
Experience in ETL testing
Proficient in Risk identification, assessment, mitigation and management from Testing perspective.
Experience in managing & testing Data migration projects.
Worked on SharePoint applications like Extranet and Intranet portals, Enterprise Content and Document Management, Business Intelligence and Websites.
Experience in Handling change requests and preparing impact analysis.
Proficient in use of HP Quality Center for Test design, Execution, Defect tracking & Reporting.
Good problem solving skills with a strong technical background and good interpersonal skills. Strong verbal and written communication skills.
Proficient in SQL for testing database integrity.
Knowledge of Web Services testing using SOAP UI.
Types of testing: Functional – Black box, System Integration testing, Interface testing, Regression. testing, Exploratory, Ad-hoc, Smoke testing, User Acceptance Testing, web based testing, Client server application testing, Batch applications testing, Data Conversion Testing.
Documentation: Test strategy, Test plan, Test cases, Test reports, Requirement traceability matrix, Test entry criteria and Test exit criteria.
Education:
Bachelor of Engineering in computer Science.
Certifications:
. Salesforce.com Certified Force.com Developer (WI14)
. SAP Certified Application Associate – SAP BusinessObjects Web Intelligence 4.0
Security Clearance:
.Enhanced Reliability Security Clearance till 04/2025.
Technical Skills:
Operating Systems: MS-DOS, UNIX, Windows XP/7/8and Mainframes (TSO, SPUFI, CICS, File-Aid, IMS, JCL)
Languages: C, C++, XML, PERL, JAVA, SQL, UNIX Shell scripting and TSL
RDBMS: Oracle 11i, MS SQL Server, Informix and DB2
Web Technologies: HTML, ASP, Java Script, Java Servlets, JSP, Sharepoint, FrontPage and IIS
Microsoft Packages: MS-Office, MS-Access, and MS-Excel
Testing Tools: Quick Test Professional 10.0, Quality Center 10.0, SoapUI, LoadUI and PVCS
Jan 2016 – Till Date
CIBC, ON
Wealth Management Technology – Test Co-Ordinator
CIBC is a leading Canadian-based global financial institution. Through our three major businesses – Retail and Business Banking, Wealth Management and Capital Markets – we provide a full range of financial products and services to 11 million individual, small business, commercial, corporate and institutional clients in Canada and around the world. We invest in our businesses, our clients, our people and our communities to deliver consistent and sustainable earnings to our shareholders.
Experience in testing (Wealth Management/Capital Markets products): Segregated Funds, Mutual Funds, Stocks, and Non Registered/Registered Investments
Leading a team (Offshore and Onshore) of 2 QA Leads (onshore) and 3 QA Leads (offshore).
Creation and execution of test cases created from business requirement, user requirements, and functional requirements.
Testing and Execution of certain Initiatives (e.g. Mutual Funds, Stocks, Bonds, FX, wealthware, standing order etc
Developed understanding for product under test and associate requirements to develop Test strategy, Test Plan and Test cases.
Recommended and implemented process improvements by preparing macros.
Created and revised procedures, checklist and job aids that resulted in process consistency and reduced error disputes
Engage with the project team to report QA status and issues, and provide quality deliverables on time.
Co-ordinate and facilitate UAT.
Collaborate effectively with the Development team to work on/assess defects.
Streamlined the procedure to make sure that the Quality and Compliance standards have been met as per the industrial standards.
Identify Opportunities for efficiencies using automation and other techniques. Responsible for the complete Manual testing by performing Functional, Performance, and System and Integration tests during different developmental phases and also Performed Regression testing upon receiving new builds and updated the Quick Test Professional Scripts accordingly.
Co-coordinating with multiple external companies (production team, funds companies, etc…)
Used Quality Center/ALM for Planning, Execution, Generated various reports and Bug Tracking
Extensively used Quality Center for test management and defect management.
Interacted with developers and QA Manager to Identify and resolve technical issues by Participating in walkthroughs and Defect report meetings periodically.
Scheduled Defect Review Meeting with the team and determined the defects’ priorities.
Involved in QA reviews like Peer Review and Functional Review, walkthroughs and audits during Software Development Life cycle.
Environment: ALM, Java, C#, HTML, CSS, JavaScript, XML, SQL, Microsoft Excel, PowerPoint, SharePoint, JIRA, Java, Servlets, Applets and UNIX.
Apr 2012 – Jan 2016
GTECH, NB
Online Gaming Solution – Sr. Quality Assurance Tester
The GTECH INTELLIGEN Central Monitoring System is a comprehensive centralized software system for administrating video lotteries. It provides security, redundancy, event logging and database logging of all gaming activities in a jurisdiction. The INTELLIGEN system is used to control the operation of gaming machines, accumulate accounting information, and provide game data. It also stores marketing information, provides price validation and facilitates cash management. This is accompanied by placing the central system in control of all transactions, security and operational events. The central system is an online transaction-processing engine, which interfaces with a SQL-based Relational Database Management system.
Responsible for the complete Manual testing by performing Functional, Performance, and System and Integration tests during different developmental phases and also Performed Regression testing upon receiving new builds and updated the Quick Test Professional Scripts accordingly.
Used Quality Center/ALM for Planning, Execution, Generated various reports and Bug Tracking
Extensively used Quality Center for test management and defect management.
Interacted with developers and QA Manager to Identify and resolve technical issues by Participating in walkthroughs and Defect report meetings periodically.
Leading a team (Offshore and Onshore) of 8 Jr testers and 4 Sr testers. (Jr testers are located offshore).
Writing SQL Queries to perform Database Testing.
Expertise in Testing Business Objects (Desktop Intelligence, Web Intelligence, Universe Designer, Crystal Reports, Dashboards, Central Management Console and Business Objects Administration).
Created automated test scripts to enable regression testing.
Tested Dashboards using SAP Business Objects Xcelsius Dashboard
Verifying the financial data (fact data) to make sure that number of records and quality of records is good by comparing with sources(ETL)
Verifying the aggregates and calculated measures to make sure that they are matched with the source(ETL)
Verifying ETL flow to make sure that the tables are populating as per the design and data model design(ETL)
Scheduled Defect Review Meeting with the team and determined the defects’ priorities.
Involved in QA reviews like Peer Review and Functional Review, walkthroughs and audits during Software Development Life cycle.
Assist in coordinating, preparing, and presenting software products to customer.
Scheduled review meetings with the customer to analyze the defect priorities.
Worked at customer location to install build and perform the functional testing whenever required.
Participated in project meetings and meetings with the customer.
Applied principles and techniques to evaluate systems during development.
Recording, reporting, and tracking defects to accurately depict the status of the system.
Environment: Quality Center 9.0, ALM, IBM DB2, SQL, PUTTY, Crystal Reports, SAP BI/BO, DataStage, ETL, JIRA, Java, JavaScript, Servlets, Applets and UNIX.
April 2010 – Feb 2012
Insurance Brokers of New Brunswick, NB
Online Quote Application – Sr. Quality Assurance Analyst
Broker Online is a web-based application, which provides automated quote’s based on the customer data. Broker online application is also integrated with DMV office and insurance rating engine to provide accurate quotes.
Performed as a QA Analyst in testing Broker Online application
Created Test plans and Executed Tests, Developed detailed Test Cases, Established Test matrices as per QA process and methodology
Responsible for summarizing Test results for Management, responsibilities will include Tracking testing results, Categorizing issues and Creating/distributing trouble reports, managing the defect lists as well as analyzing data to ensure data integrity
Created Test Scenarios for Functionality by creating both positive and negative test cases according to the Business and Functional Requirements
Hands on experience in performing Functional based upon the Use Case work flow
Identified the test data by organizing multiple test data review meeting and also created test data for specific Test Scenarios and Test Cases using SQL
Performed end testing with multiple interfaces like DMV motor vehicle department, Equifax and Experian
Used Quick Test Professional for Test Automation by creating automated scripts based on the Test Cases.
Performed Functional, System-Integration, End to End, Regression testing and User Acceptance Testing
Verified the "fixes" for the reported bugs and provided status reports to the management
Regular interaction with developers and business analyst in resolving technical related issues
Participated in Enhancements meeting to distinguish between bugs and enhancements
Environment: Quick Test Professional 9.0, Quality Center 9.0, Webservices, SOAP, MS Content Management, Team Foundation Server, Visual Studio, Java, HTML, DHTML, SQL Server, Visual Source Safe, Microsoft Project.
Dec 2008 – Jan 2010
Capital One Financials
Credit Management System - Quality Assurance Analyst
Credit Management System is a web application used by Capital One financials underwriters to process all the credit deal applications received from agents and brokers of CapitalOne financials. Underwriters execute credit business rules to validate if the customer credit applications can be approved or rejected.
Involved in the project as QA Analyst in testing the Credit Deal Management System
Interacted with the Business Analyst and End Users to understand the
Analyzing the user/business requirements and functional specs documents
Created Project, Requirements, Test Plans and Tests in Quality Center
Wrote test cases to test the application manually in Quality Center
Performed Sanity, Functional, Integration, End to End, Smoke and User Acceptance Testing
Used Quality Center for Test Management, defect reporting and tracking
Performed Backend testing using SQL Queries
Provided Test Execution and Defect Status Report.
Technologies: Quality Center 8.0, QTP 8.0, Quick Test Professional, Oracle, PL SQL, IBM Mainframes, DB2, PVCS, C#, Java, J2EE,VBScript, WebLogic Server 8.1, and Unix
May 2006 – Oct 2008
UBS
Web Based Application - Quality Assurance Analyst
UBS is one of the world`s leading financial firms comprising of wealth management, global investment banking and global asset management tools. It is used for creating journals for both cash and security transactions. Service Works is a web-based application developed for managing bank services for clients. It provides investment banking and global asset management tools. It is used for creating Journals for both cash and security transactions.
Analyzed Business Requirements and Identified documents required for system and functional testing efforts for all test scenarios
Developed all the necessary documents for QA Testing like Test Strategies, Test Plan which includes all test items & Test Cases, and User Documents etc.
Validated the daily and monthly reports in against the data in Oracle databases
Worked in brokerage operations processing new accounts and general securities transaction process
Reviewed manual testing methods and created and implemented an automated test strategy and generated automation scripts
Participated in the development of data from the existing systems to the Oracle Financial Applications
Worked closely with users and Application developers to ensure that application development meets to user`s expectations
Comparing and Analyzing the Expected with Actual results in DB.
Used SQL Queries to verify the data from the Oracle database
Developed TSL scripts and GUI maps for all the test cases to be tested manually and automation using WinRunner /HP QC for functionality, integration and regression testing
Created WinRunner scripts that were used by other testers for regression testing
Created automated scripts using WinRunner for checking functionality and rules defined in CORBA server using test driver programs
Enhanced test scripts by inserting synchronization and checkpoints.
Gained familiarity with the use of Actions and Transactions. Parameterized the test script to run with different sets of data.