Soumil Parekh

**** ***** *******, ***********, *******, L5M0M9 416-***-**** ac4i7g@r.postjobfree.com

PROFESSIONAL SUMMARY

Over 7+ Years, strong experience in Software Quality Assurance of Web based Client/Server, Mainframe applications and all phases of Software Development Life Cycle testing.

Expertise in designing Test Strategy, Test Scenarios, Test Scripts and Test Reports and Bug Reporting of manual and automated tests.

Work experience of 3 years in ETL Testing within the environment of Oracle & SQL Servers.

Used Mercury Interactive Tools (QTP, HP Quality Center, LoadRunner, and WinRunner) for testing the functional behavior of the Web based applications, GUI applications.

Proficiency as QA Tester, which includes mainly Manual, but also worked on Automated test case execution using Automated Testing Tools on WINDOWS 95/98/ME/2000/NT/XP/Vista environments, following the manuals.

Identify bugs/issues and work with developers to resolve them.

Experience in working with Telecommunications, Retail and Banking.

Involved in Test Planning, coordinating and implementing various QA Methodologies such as Rationale’s RUP, SEI-CMMI and ISO-9001.

Experienced in both manual and automated testing of the Client/Server and Distributed n-tier applications.

Executed SQL queries to validate data in Oracle, SQL Server, MS Access, and DB2 backend.

Competence in writing and executing test plans, test cases, and test scripts based on the Baseline Requirements, Functional Specifications and Design documents.

Sound knowledge of SCCM.

Hands-on experience with desktop data management tools such as: MS Project, SQL query, MS Access, MS Excel, and/or text editors.

Able to work independently, a good team player, and able to interact with all levels of management.

Possess good communication skills, self-motivated, task oriented and quick learner at new technologies

TECHNICAL SKILLS

Operating systems

MS-DOS, Windows 3.x/95, 98, 2000, Windows NT 4.0, Linux

Programming Languages

Java 2, C, C++

Testing Tools

HP Quality Center, QTP, Test Director, WINRUNNER, Rational Robot, Rational Test Manager, Rational Rose

Web Technologies and Application servers

HTML, ASP.Net, Java Script, Macromedia Dreamweaver Flash and Apache Tomcat 4.1

Database Programming

SQL, PL/SQL, SQL* PLUS 3.1

RDBMS

Oracle 9i/8.1, MS Access, SQL Server 6.5, DB2

Software Tools

MS Office, MS Visio, MS project, Adobe PhotoShop 7.0, Crystal Reports

Networking Protocols

Routing Protocols (RIP, OSPF, EIGRP,IGRP,IS-IS,BGP)

Routed Protocol (TCP/IP)

VOIP Protocols (SIP, MGCP, H.323)

Implementation of HSRP, DHCP, FTP, and TFTP

Software Engineering

Requirement Analysis, Use-case Modeling, Workflow modeling, Testing Strategies, Unified Modeling Language (UML), Rational Unified Process (RUP)

Mobile Devices and Application

Blackberry device on various platforms 4,5,6,7

Iphone devices on various platforms up to Version 5.0

Various devices on Android based OS. (Samsung, Motorola, HTC) – up to the newest Gingerbread version.

Tested application on various devices and various platforms.

WORK EXPERIENCE

RBC – Capital Markets – Toronto, ON, September 2014 – Present

QA Analyst, Capital Markets (E-Trading) - Fixed Income

Environment: Applications for E-Trading: Bloomberg, ION, Unix, SQL, TOMS, JIRA, Trading Applications, Sales Application, Various ECN’s (Electronic Channels)

Project Description: Performed Manual Testing on applications for Trading on various ECN’s and tested End to End flow for RFQ’s on Trading application to being booked in TOMS. Verified trades on ION Gateway. Offerings published on various markets, Pricing verified across end to end flow.

Conduct Analysis and Manual testing to verify End to End flow for all ECN’s.

Develop Regression Suites and documentation in Confluence.

Log tasks & defects in JIRA, for every release

Verifying logs to identify issues on Unix

Performing & Evaluating gap analysis to ensure business requirements are met

Conduct Functional Testing, Backend Testing, SIT, Regression Testing

Communicate with Stakeholders to gather data and fully understand requirements

Focus on Vendors to verify RBC Dealer requirements on particular ECN’s

Providing Demo to Stakeholders before releases

Create documentation and analyze requirements for changing processes

Using JIRA to log and monitor defects and create UserStories

Fidelity Investment Services (FIS) for BMO Nesbitt Burns – Toronto, On. April 2014 – September 2014

Sr QA Analyst, Wealth Management Application (GIC)

Environment: Wealth Management Application for GIC: UNIX, SQL(Sybase), Window XP, WINSCP, ClearCase, Windows 7, Scrum Environment

Project Description: Performed Manual Testing on applications for GIC related Loaders for BMO Nesbitt Burns.

Created & Executed Test Scripts in Microsoft Excel.

Developing test data for test case execution & regression testing.

Testing loaders for Wealth (GIC) application like Interest, Maturity and various others.

Functional testing of various loaders (front end) & mapping data to the Sybase (back end).

Bank of Nova Scotia – Toronto, On August 2013 – January 2014

QA Analyst, Wealth Management application

Environment: Wealth Management Application Environment: Wealth Management Applications, RPM, JAVA, XML., SharePoint, Windows 7

Project Description: Performed Manual Testing on applications for Pre-Authorized Contributions (PAC), TFSA – Year End, GIC’s, Personal Portfolio Statement (PPS), Taxation Slips and NR4 slips, NR4 Summary slips, RRSP, RESP

Worked on HP QC to create, executed test cases and log defects

Developed and analyzed data for test case execution, regression testing and production.

Developed Data tables with varying data for automation team to create accounts.

Worked on RPM application for creating and verifying accounts & information. Also extracting batch reports for data verification and reporting the bugs.

Conducted UAT, SIT, Sanity, Regression testing.

Developed strong understanding of the Business and System side of the applications.

PNC – Health Care, Toronto, On April 2012 to August 2013

QA Analyst, Health Care application

Environment: JAVA, Microsoft 2010, SQL, Windows 7 & XP, XML, HP QC,

An integrated comprehensive and complete healthcare revenue cycle solution from pre-registration through collection that utilizes decision support tools throughout the cycle is required. The focus is to enable cognitive learning for constant and improvements to the decision support tools and processes to drive economies of scale and to manual process for both PNC and the client, by converting it to a web based application.

Reviewed the functional specifications and the design document to determine the testing requirements

The Test Plan & Test Cases was created using Quality Center. The Test Case Matrix, along with other documentation for the test plan, contained clear and concise information on testing specifics

Generated Execution, Status and Defect Reports and presented to the Management, all the defects were tracked using HP Quality center.

SQL queries to extract and populate data to the table.

Conducted UAT & Regression Testing.

Performed Cross Browser testing & End-to-End testing.

SUNGARD INVESTOR ACCOUNTING SYSTEMS, San Mateo, CA October 2010 to April 2011 (7 months)

Sr. QA Analyst, Mutual Funds Investor accounting applications

Environment: Mutual Fund Application, Portfolio Application, Oracle 9i, Rational RequisitePro

Project Description: Tested the Enterprise Product Image Management (EDAM) program to establish and manage a centralized (universal) digital asset management system that captures, approves, stores and delivers all digital assets for the entire enterprise for the purpose of providing the strategy, processes and technology to support the activities associated with ingesting, transforming, managing and deploying the digital assets required to support Marketing, Product Content Management, Catalog Management.

Gathered Business Requirement Specifications using Rational RequisitePro

Tested application for paperless item, check numbers and e-bill feature, which is converted and executed to an XML file and sent to a Third Party Vendor for further action.

In money market accounts like mortgage accounts, bond accounts implemented Unified Modeling Language (UML) methodologies to design Context Diagram, Use Case Diagrams, Data Flow Diagrams, Activity Diagrams, Sequence Diagram and ER using CASE tools like Visible Analyst

Conducted user acceptance testing(UAT) and system integration testing (SIT) for new application.

Tested the look-n-feel or non-functional requirements of the application of Mock-up forms used for better illustration of the application to construction managers and field representatives who were based remotely

Created status reports which were submitted to project lead and stakeholders on a regular basis

Performed Cross Browser testing across various Operating Systems. On various Desktop - Mac, Windows (XP, Vista, Windows 7), Linux for the web based application

Facilitated user acceptance testing and test strategies with Information Technology Group

Performed manual front-end testing to check all functionalities of different module

Suggested measures and recommendations to improve the current application performance

Logged Defects and re-tested the fixes

NATIONAL BANK OF CANADA, Montreal, November 2008 to August 2010 (22 months)

Sr. Quality Assurance Analyst, Mail Access Customer Satisfaction

Environment: Oracle business suite, Capstone, Mainframe (ISPF, Spufi, TSO, File AID), TSYS, Mercury Quality Center, CMMI

Project Description: MasterCard application, Mail Access Customer Satisfaction (MAC), is the part of Credit Adjudication process. This application is used to create Deals for the customers by gathering information of customers Assets, Liabilities etc.

Gathered all Business Requirements, Functional Requirements and Use Cases for LPS application

Responsible for Test Planning, Execution and Analysis of LPS application

Responsible for creating reusable Test Plans, Test Scenario, Test Case, Test Script and Status Report Templates

Created Data Transactions for Performance Testing to be used to identify the response time of the application

Performed system integration testing (SIT) and user acceptance testing(UAT) test execution and verification of output logs during SIT and UAT cycles.

Designed and created custom automated testing solutions as required

Generated Execution, Status and Defect Reports and presented to the Management, all the defects were tracked using HP Quality center.

Responsible for testing the Data Mapping and testing text file, performing ETL back to the database.

Responsible for making sure that the interdependent files have arrived and loaded correctly so that the actual deal file has been loaded successfully.

Performed Cross Browser testing across various Operating Systems. On various Desktop -, Windows 7, Vista, XP, & MAC for the web based application

Provided Status Reports and Defect Reports in a Graphical Representation to the management after each Test Cycle

Responsible for testing the upload process of the file, which uses .net framework

TRADER CORPORATION (BuySell.com), BC, Canada February 2008 to September 2008

Senior QA Analyst, OMT Model Configuration

Environment: HP Quality Center, QuickTest Pro, TestDirector, UNIX, HTML, JavaScript, ASP.Net, SQL Server, Office2003, Outlook 2003

Project Description: Buysell.com is an auction site. As a QA Analyst, I was involved in testing of different modules of the web site and client server applications. Client/Server applications were used by medium and large merchants to load the data for the auction items. OMT methodology was used for the design of the various business processes.

Reviewed the functional specifications and the design document to determine the testing requirements

Extracted data from the existing database for regression testing as well as new functionality testing

Analyzed the Test data requirements, examined the test bed database using FileAid

Participated in walkthroughs of the Requirements, Detailed Design, and Construction phases

Developed test objectives, test cases, test scripts for the assigned work products to ensure compliance with the functional requirements using HP Quality Center

Involved in Functional Testing, Integration Testing of the build

Executed test cases as per the Test execution plans and logged defects and tracked defects through resolution, retested fixes

Automated System Test Scripts and conducted Regression Testing using QTP.

Created Transactions for Performance Testing using Mercury LoadRunner and identified the response time of the application

Conducted system testing by executing online and batch test scripts

Responsible for testing, implementation and performance monitoring of modules such as Gift Shoppe Bulk data loaders, financial modules and CRM

Tested and created results for “Bulk Loader”, an application in Visual Basic and Access. Large merchants use the application to upload and manage the auction items. Interacted with various merchants to develop the business specifications

Responsible for testing the process flow for the credit card payment by auction users and the accounting interface. Interacted with the Bill payment service providers

Used standard and prescribed Quality Assurance testing methodologies for the system test life cycle

ACG’S INSURANCE APPLICATIONS, ON, Canada September 2006 to December 2007

Sr. Quality Assurance Analyst, ACG Re-hosting

Environment: Rational Robot, and Rational Clear Quest Power Builder 7.0, Windows NT, Mainframes, Meter, Informatics, Ingenium

Project Description: This ACG project was converting the Legacy based Auto insurance into a web based system, developed on Java, XML and MQ series for Ontario. The system had integrated a wide range of systems that was developed and maintained by IBM, CGI, Solcorp such as INGENIUM FOR HEALTH INSURANCE, Database for auto insurance, MVR, satellite integration, and claims. This ACG application can provide an application, Quote, or a full policy based on business needs. This Application will also be integrate with Property insurance.

Involved in all phases of the software development life cycle (SDLC) to ensure that the customer gets the highest level of quality in the base product

Created detailed test cases based on thorough examination of the requirements and performed functional, regression and End-to-End testing

Validate and verified data integrity through multi-tier client/server application, documented the result of test cases and investigated log-files

Intensively used the SQL to extract/populate data (ETL) and loading the changes to the server

Interacted with developers and business analysts to clarify design specifications and to address defect resolutions

Conducted user acceptance testing and SIT for production issues within a simulated environment

Performed business acceptance testing

Provided sign-off for all phases of testing life cycles

Performed testing for many regions

Used Clear Quest for defect Tracking and defect reporting

Interacted with Development Teams and Project Management in explaining the Business and Functional requirements

Performed

Testing to verify the Compatibility of the application to support different Web Browsers

Tested all the Web pages for data input validations on all Edit fields and Alphanumeric Fields where customers were required to log in their Name and SIN Number as well as Postal Code to view further details of their accounts

INSURANCE HOLDINGS OF AMERICA, Oriskany, NY February 2006 to July 2006

QA Analyst, GL integration

Environment: Claims Package, Accounts Receivables, WinRunner, CICS, Java, XML, Mercury Quality Center.

Project Description: Assignment involved the testing of new modules and service programs to update AR, export to GL systems using a combination of COBOL400, embedded SQL, CLLE, and COBOL/ILE procedures. Tested archive rule for production and new reporting to catch out-of-balance conditions within the cycle processing during month-end closing.

Gathered requirements document from the systems team, along with developer updates. Held brainstorming sessions with other QA testers for pre-testing random test scenarios and initiating sanity tests on the application.

Involved in creating the Performance Master Plan Blue Print for the use by all the modules. The plan includes the entire road map of performing Performance Test.

The Test Plan was created using Quality Center. Test Case generation task was also distributed out to the other QA Analysts. The Test Case Matrix, along with other documentation for the test plan was thus generated in a short amount of time, and contained clear and concise information on testing specifics

Created Data Tables with varying data to automatically supply test data to virtual testers under different load conditions

Inserted Verification Checkpoints for the validation of the functionality under stress conditions

Performed Statistical Analysis of the response time data, collected under peak load conditions. Generating reports of the performance tests for the developers for load balancing and re-testing the system

Analyzed the Percentile Response, Hits/Second, Throughput and transaction performance graphs

Provided the Development Manager with testing results and weekly status report to the QA Manager

Involved in entering and tracking defects using Quality Center. Responsible for reviewing and updating test cases to follow an effective overall testing strategy

CINGULAR/AT&T WIRELESS, BOTHELL, WA February 2005 to December 2005

SR.QA Software Engineer, DMDR

Environment: Mercury - Test Director, DbVisualizer, JIRA defect tracking tool (issues database), IE6 and an assortment of internal support tools.

Project Description: The project is about bringing new functionality to an existing call in Sales Rep tool that is written in Java for Call Center billing purpose. This application is primarily used to take new orders for Cellular accounts. The application of the project is called "X" which use to be known as TeliVision. The application is designed to create new accounts, modify existing Cingular accounts (limited in scope), and be a direct portal for order and customer problems for the first 30 days of activation.

Conducted manual testing using the Standards, guidelines and structured methodology in testing the application

Documenting and executing Test plans, Test cases and Test scripts based on baseline requirements

Conducted system and integration testing, debugged the software errors and interacted with developers to resolve technical issues

Employing data-driven testing based on Excel tables by parameterize test scripts to check application behavior

Performed SIT, System testing, and Functional testing

Analyzed the user requirements by interacting with system architect, developers and business users

Actively involved in Functionality, unit and integration tests for modules developed in Java

Performed End-to-End testing manually and was associated with User Acceptance Testing

Win Runner was used to automate the Regression Testing after every version change of the application

Automated test scripts for Functional, GUI validation, Data Driven testing text data file using Win Runner

TATA CONSULTANCY SERVICES, Mumbai, India June 2003 to December 2004

Software Tester, Order entry Application

Environment: Java, Oracle 8, CICS, MVS, VSAM Datasets, TSO/ISPF, IBM S390, File Aid, JCL

Project Description: Worked as a Software Tester in validating Customer Order Entry Application System for office Supply Company. The application was developed to maintain customer information, product inventory, and order information for the business. The front end of the application was designed using Java and the database with Oracle on Windows NT platform.

Analyzed the requirements and developed Test Cases for functionality and negative testing

Extensively used SQL to query the database and display the results in different reports

Designed and developed forms in Html and their connectivity to the database

Performed unit testing on all the modules to check the code

Involved in the preparation of the design, coding and test plans and test case documents and data modeling as expected from the client for every version and updated to the corresponding team of people working towards achieving it as a whole team

Involved in version control of the project and documenting the updates

Conducted regression testing and interacted with developers to resolve the issues

Involved in the making of the qualification testing report covering the Environmental tests procedures that the unit is required to be subjected to

Involved in the making of the limited qualification testing report covering the limited qualification test procedures that the unit is required to be subjected to

EDUCATION

Bachelors of Commerce

C-DAC – Centre for Development of Advance Computing.

Red Hat Certified Engineer (RHCE) Under Red Hat Enterprise Linux 3

Completion of SAP Bi (BW) with Netweaver 7.0 -Application Associate Course. – Toronto, Canada – ERPTEK 2012

Business Analysis – University of Toronto - 2017

Contact this candidate