Surya Paruchuri
Phone: 647-***-**** Email: ac4l8e@r.postjobfree.com
Over 10 years of experience in Business Analysis and Quality Assurance. Strong skills in Business Analysis, Testing, and Reporting of banking and finance applications. Recognized by Senior Management and Business Partners, for consistently delivering exceptional work that has been instrumental in delivering business results.
Summary:
10 years of experience in Business Analysis and Quality Assurance.
6 years experience in planning, scheduling and release management in different environments.
Expertise with Selenium automation scripts for web and mobile applications test automation.
4+ years of experience as a Business Analyst.
5+ years of experience creating current and future state process maps using Visio
Scrum Master Certified and Certified Agilist with expertise in Agile (Scrum and Kanban) Methods.
Hands on experience with Manual and Automated testing tools
Knowledge of Quality assurance methodologies and strategies with better understanding of Software Development Life Cycle (SDLC) and Project Life Cycle (PDLC).
Experience in localization testing including French Applications.
Expertise in gathering requirements from multiple stakeholders across several departments, and creating Requirements documentation.
Expertise in analysis and testing of Wealth Management, Investment and Financial applications.
Have a strong technical background and familiar with a variety of system architectures.
Strong hold in Database/Backend Testing and hands on with writing SQL queries.
Experienced in writing Use Cases, Traceability-matrix, Bug reports and Test summary reports.
Familiarity with multiple software systems, tools and the ability to learn quickly innovative technologies and adapt to new environments.
Experience in using Jira, Agile Rally, TFS, ALM (HP QC) and Gemini for agile projects
Technical Skills:
Languages: C, C++, Visual Basic, SQL, MySQL
Testing Tools: WinRunner7.0/7.5/8.2, LoadRunner6.0/6.5/7.6/8.0, Quick Test Professional 6.5/8.0/8.2, Compuware, UFT
Test Management and Bug Reporting: TestDirector7.0/7.6/8.0, Quality Center, ALM, Rational Clear Quest, JIRA and Rally.
OS: Windows95/98/NT/XP, Linux, Sun Solaris 10
Web Language: HTML, DHTML, XML
Scripting Languages: TSL, VBScript, Java Script
Business Analysis Methodologies: Agile Development Process, Rational Unified Process, Unified Modeling Language
Database APIs: JDBC, ODBC, DAO, RDO, and Active X Data Objects
Web Servers: WebLogic, WebSphere, IIS, MTS, PWS
Network: TELNET, FTP, HTTP, TCP/IP
Other Tools: Toad, Visual SourceSafe, MS Word, MS Excel, MS PowerPoint, MS FrontPage, MS Outlook, Microsoft Project, C#, MS Visio, Lotus Notes and Amdocs Ensemble
Education & Certifications
Scrum Master Certified
Certified Disciplined Agilest
Diploma in Computer Applications
Honors Diploma in Computer Science
French Level N102 at Alliance Franchise.
Work Experience:
BDO Canada
Senior BA/Scrum Master March 2017 – Present Day
BOSSs Portal
Creating a web portal (CSP and CA) for the Government of the British Virgin Islands (BVI) in respect to the sharing of beneficial ownership information with the Government of the Virgin Islands and to establish and maintain an electronic platform that will allow immediate access to BVI Entities and Business owners. Portal to be used by 4 BVI Authorities: Financial Investigations Authority (FIA), International Tax Authority (ITA), Financial Services Commission (FSC), and Attorney General Chambers (AGC).
Responsibilities:
Complete E2E testing of the Portal
Requirement gathering.
UAT testing for CA portal testing for govt authorities
Preparing Training and User manuals for CA’s and CSP’s
Prepare estimates for projects, change requests and tasks.
Validating Functional, Nonfunctional, Integration and Security requirements.
Provide risk and impact analysis.
Preparing requirements for payments, funds transfer and account to account payments.
Prepare Use cases and user stories for CSP fund transfer, credit risk and wirepayments.
Provide daily, weekly and monthly project status reports.
Initiate brain storming sessions and Agile training sessions.
Responsible for creating credit risk requirements for entities using BVI FSC guidelines.
The Royal Conservatory of Music
"My RCM" portal enabling students to find teachers, get trained and certified along with exam booking and bookstore portals.
Barrick Gold Corporation-
Investment Analysis Portal enabling shareholders to make better investment decisions on selecting mining sites.
Responsibilities:
Responsible for gathering information for different legislations passed by British government in regard to BVI BOSSs Portal.
Creating and managing project and test milestones using MS Project and Gantt Charts.
Schedule meeting with steak holders and clients for gathering requirements and planning.
Creating Requirement Documentation (BRD, SRS and Wireframes)
Meetings with development team for gathering technical requirements.
Creating process maps, BUC’s and Traceability matrix.
Communicating and Training CSP’s on the new portal.
Managing data and training sites.
Creating Training documents, Videos and Demos for CSP training.
Creating CR’s and providing impact analysis and estimates.
Monitoring and testing the portal before deployed to CSP’s and BVI.
Preparing deployment release notes.
TD FPMO Sep 2016- March 2017
Senior Business Analyst (Agile/Rapid)
Consolidations
TD Bank Group ("TDBG" or the "Bank") is currently using Hyperion Enterprise 6.3 ("Hyperion") as a
Consolidation tool for Financial and Regulatory Reporting purposes. Hyperion and its supporting
Infrastructures (Windows 2003 and AIX 5.3) are at end of life, which means it is no longer supported
by the respective vendors. As a result, this project is being classified as a 'currency upgrade' as
opposed to 'changing the Bank' project.
Responsibilities:
Accountable for the drafting and collecting all the artifacts related to the RP
Responsible for preparing HLR(High Level Requirements) & DLR (Detailed Level Requirements)
Responsible for preparing the current and future state process maps using Visio
Identifying and drafting the use cases and reviewing with Business and Technology.
Validating Business scope
Creating and managing BA/QA tasks and mile stones using MS Project (Gantt Charts).
Monitoring Testing activities, including generating automation reports and defect reports.
Conducting impact analysis and Scope review meetings.
Conducting regular risk and impact assessments.
Conducting Defect Triage Meetings.
TD Securities April 2016- Sep 2016
Business Test Analyst (Agile/Rapid)
Risk Information Strategy for the Enterprise (RISE)
Responsibilities:
Used Rapid testing methodology ( TD trained )
Preparing HLR(High Level Requirements) & DLR (Detailed Level Requirements)
Preparing the current and future state process maps using Visio.
Responsible for Creating BUC's, HLR's and DLR's.
Responsible in the creation of requirements and BUC’s for CRDM(Credit Risk Data Mart ) and DDM
Responsible for database migration testing for Capital markets (TD Canada and TD US) from GDS to Universe.
Perform Business validation by running test cases in ALM and raising defects when required.
Run ETL process using SQL server 2008.
Verify traceability between RT requirements and RT test templates
Assist in creation and uploading of requirements from Excel to HP ALM
Design high level business test scripts for business test team.
Execute test cases for CRDM/DDM, if necessary
Create and log defects for failed test cases in HP ALM. Conducting defect triage calls
Responsible for creating Test Strategy & Test plan(s), including testing schedule for the applicable base test phase(s) BAT, PAT and deployment.
Creating reports using SAP Business Intelligence (BI).
Prepare test closure reports when necessary.
BMO Bank &BMO Harris bank May 2014- April 2016
BA/Scrum Master
Leading and managing Agile QA test team for BMO Credit Cards and F14 Redesign.
Responsibilities:
Responsible for testing BMO capital markets all applications and tools including Advisory Capital Raising, Institutional Investing, Global Trade & Banking and Investment Products.
Responsible for Understanding Business requirements from LOB's and Preparing requirements, BRB, L4 process maps and Wire Frames.
Conducting regular meetings with Team and LOB's to generate accurate status reports.
Responsible to lead and assemble a high preforming Quality Assurance team
Involved in building Test strategy, Test plan for various projects and providing timelines based on risk analysis and analytic report generated from Adobe Site Catalyst.
Focusing on all digital solutions developed from Digital & Channels Marketing
Managing vendor QA team to deliver quality web application within tight timelines. Overseeing vendor developed test cases/scenario to ensure full test coverage
Managing defects using Jira for F14 CMS redesign project
Planning and Execution of Regression test activities for F14 CMS redesign project
Providing QA Estimates, Strategy & Plan and tractability matrix of functional test cases for UAT to Business users using Gemini.
Performed User Acceptance Testing for applications on the pages and also the Page layout including Side Navs, Header, and Footer, White spaces, content, Banner, External and Internal links and redirects.
Providing Status report to Senior Management to help guide the project status on daily basis
Managing Vendor Accessibility testing team and ensuring the application meets WCAG AA standards
Executing test scenarios for Test and Target implemented applications
Performing Functional and UAT testing of web application Using Manual, Selenium automation scripts and Perfecto mobile for Device testing. Used Jenkins for continuous integration and build management.
Testing Mortgage, Insurance and Rewards calculators and documenting test results
Raising gaps in Functional requirements, Designs and Development
Documenting test cases/scenarios, decision tables for various short-term projects. Logging defects using defect tracker in SharePoint, Jira
Tracking and updating project status and reports in Kanban Board (Agile Rally)
TD Bank Jan 2013- May 2014
RIB and SBIB
Bill Pay, Alscom 41 &42, Account to Account, Online enrollment
SBIB Release Lead
Responsibilities:
Manage Online Software Testing project activities for multiple projects across all project
Performed UAT testing for online payments application, ACH payments and Transfers.
Performed testing for Cheque processing through Symcor
Performed E2E testing for Interac e-Transfer application.
AML testing for ACH payments and Transfers (Internal and External)
Collected data and modified user accounts for testing. Created user accounts for BAT testing and managing prod user names and passwords for deployment in SOC and CPO servers.
Performed English and French testing.
Phases, including initiation, planning, execution, monitoring and closure.
Work collaboratively with development team, BA and the product owner to determine
the approach for testing and deployment activities for Projects, STB’s and PCR’s
Create and manage Test estimates, Strategy, Plans and Status reports using HP QC (Now ALM)
Manage the day-to-day activities of testing and resource scheduling necessary to ensure test deliverables are on schedule and within cost parameters.
Communicate, collaborate and manage external testing venders (Polaris) to ensure deliverables are received on time and follow TD standards
Coach and train team members on the use of Integrated External Financial tools (Quicken and Quick books)
Track and monitor project status for SBIB with internal tools (OLC Dashboard and Clarity).
Work closely with external development teams Fiserv and Cash edge.
Involve in deployment activities and test closure activities.
Managing and Conditioning Test data for internal use and external vendors.
BMO Harris Financial Advisors June 2012 – Dec 2012
R71 project (HFA, ITS, P&C) & MasterCard World & Pricing Project
Sr QA /BA
R71 is the largest merger project for BMO Harris for the year 2012.This is an US Project, with the development of the new BMO Harris public/ internet site comes the opportunity to develop a consistent look and feel for all US products and services to communicate a robust brand experience to all users. This project streamlines and focuses user experience on the site, promote interactivity and user interaction.
MasterCard Worldwide (MCW), is introducing new requirements that move toward a strong product approach:
Explicit branding on card to denote cards earning premium interchange rates (World and World Elite).
Work collaboratively with development team and the product owner to determine the approach for Preparing Requirements &Test documentation and deployment activities for Projects and CR’s
Explicit customer consent to accepting a card with premium interchange.
Minimum income requirements for premium cards for new customers to ensure they are targeted to individuals who are mass affluent / affluent (for existing customers upgrading, income or annual spend can be used for eligibility).
Minimum level of product benefits for premium cards.
Responsibilities:
Setting up Agile working environment.
Reviewed and understood high level LRD (Lite requirement document)
Analyzed Business and System Requirements to build test cases
Used TFS to create test cases, report defects and generate reports.
Develop Test Plan, Test strategy and Traceability matrix.
Attended status review meetings.
Bilingual testing (Spanish)
Cross browser testing
Communicate with development team (US & Toronto) and arrange meetings for defect consolidation.
Ensuring no defects of critical, high, and medium severity is outstanding.
All open defects have been resolved and their final disposition determined.
All open issues/defects are communicated, and mitigation or workaround strategies are in place.
Updating Production support documents and shared document folders.
Verifying code for accessibility standards.
Environment: Visual Studio 2010 (TFS Team Foundation Server), CSS JavaScript, HTML, VB Script, HTML, SQL, DB2, and Oracle
ScotiaMocatta (Online Dealer System)
SSO (Single Sign On), T5008, SIN Enhancements Nov 2011 – May 2012
Sr Quality Analyst
This is an Enhancement project. The ScotiaMocatta Online Dealer system (SMOD) has been successfully deployed to 59 branches .SMOD is a web based third-party (Beanstream) hosted application that facilitates Precious Metals (PM) transactions for branches. SMOD also maintains an inventory of available PM products based on a starting initial inventory. Through proven interfaces with various Bank systems, tax reporting as well as enhanced inventory management will result
.
Responsibilities:
Reviewed and understood high level EDD
Analyzed Business and System Requirements to build test cases
Used SQL to verify and analyze the database.
Used Quality Center for reporting and tracking the bugs.
Worked closely with the development team to quickly resolve defects
Generated Online Metrics for different phases of testing using HP quality center web tool
Create accurate and timely issuance of a T5008 tax receipts
Calculation and display of applicable tax on commissions
Used QTP to run Regression packages
Calculated Taxes to be levied as per local Jurisdiction.
Generated reports and attended status review meetings every week
Performed Back-End Testing by creating/executing SQL Queries using SQL Query Analyzer
Bilingual testing (French)
Environment: Quick Test Professional, Quality Center, Java, Java Script, J2EE, EJB, HTML, DHTML, VB Script, XML, SQL, JDBC, UML, UNIX, DB2, and Oracle
Manulife Insurance
Legacy to Online Conversion Sep 2011- Nov 2011
QA Analyst
This project is developed for the conversion of the Classic system to the Web online system. It involved in the conversion of the legacy insurance data into Web online system with oracle database. New online web application will be used by the policy administration department to access the policy details of the customers.
Manual Testing Automated Testing
70% 30%
Responsibilities:
Used Scrum methodology for testing.
Reviewed and understood the Conversion strategy of this Conversion project
Created detailed Test Scenarios and Test Cases using standard templates and provided it to the management for review
Created detailed Test Execution reports and Defect Tracking reports and provided it to the management
Performed Functional, Integration and User Acceptance testing and monitored the applications behavior during different phases of testing using Manual testing concepts
Performed Data Mapping, Data Validation, Data Integrity and Backend testing by using SQL Queries on DB2 and Oracle
Logged all the defects to the development team using proper screen shots and steps to reproduce the defect using Quality Center and retested the defects after they were fixed by performing Regression testing
Used Jenkins for continuous integration.
Environment: Web Sphere, Java, Java Script, J2EE, EJB, JUnit, HTML, DHTML, FTP, CSS, Servlets, VB Script, XML, SQL, JDBC, UML, UNIX, DB2, and Oracle
Tools: Quick Test Professional, Quality Center, Load Runner
Manulife Financial, Toronto Feb 2010 – Sep 2011
Project: Manulife Financial
Position: QA Analyst
Description:
The project work mainly consists upgrading the Front End User Interface and making enhancements as required. This GUI was developed for the users to process their day to day transactions, performing queries regarding customers and their contact numbers, memberships/policies and insurance claims. The database is a customer data information repository integrated with Life Insurance (MLI and term life insurance).
Responsibilities:
Identified test requirements from functional specifications.
Analyzed Business and System Requirements to build test cases.
Prepared test plan documentation, including functional lists and test cases.
Developed library functions for functional and regression testing of Business Flow using Win Runner TSL scripts.
Developed test plans for features, stress, performance, and load testing.
Executed general regression tests upon fixed releases of the application.
Used SQL to verify and analyze the database.
Agile working environment.
Used Quality Center for reporting and tracking the bugs.
Worked closely with the development team to quickly resolve defects.
Participated in business requirements and system design breakthroughs. Analyzed specific changes and approaches to testing methods.
Performed all types of manual testing including Smoke, functional, system, and regression testing.
Managed test teams composed of staff drawn from various IT and business functional units to prepare for and successfully execute assigned tests.
Analyzed project documents to identify test requirements and develop the Master Test Plan & Functional Test Plan, Test strategy, Test coverage, Traceability matrix, Operational Acceptance Plan, Release Test Plan, QA Acceptance Plan, Project Wrap-up reports and delivery of maintenance reports based on the size of the Project.
Created data test plans, comprehensive test scenarios and guided team to create test cases with expected results using Mercury Quality Center (Test Case Management System).
Conducted walkthrough of QA Test Cases and the QA test plan with the QA team prior to execution.
Prepared re-usable test data specific to each test.
Provided backup to other QA testing projects as required.
Provided the QA automation team with application functionality work flow to generate scripts.
Participated in Post Implementation Verification and Reviews.
Worked under tight deadlines and handled multiple ongoing projects.
Environment: SQL Server 2000, Quality Center, Manual testing, MS-Excel Java, J2EE
HSBC, Toronto Dec 08- Jan 10
Project: Online Banking
Position: QA Analyst
Description:
HSBC is one of the largest integrated financial services organizations in the world. HSBC makes products and services available through its member companies to help customers meet any financial services need. Online Banking is a web application which performs online banking functionalities of a customer through payment account processor. This application integrates with the bill payment service, wealth management gateway and transaction processes of the payment account. Customer can view his account balance online. This service is integrated with other array of financial products and services, including life insurance, fixed and variable annuities, defined contribution retirement plans, mutual funds, stocks and share purchases, capital market applications, online trading and web brokerage.
Responsibilities:
Involved in Analysis of Business Requirements and documenting the requirements.
Analyzed Test Requirements and created Test Plan, Test Strategies and other Test plan documentation.
Designed, Planned and Created Test Cases using Quality Center.
Checked the user profiles and their login scripts.
Involved in Module Testing, Functional Testing, System Integration Testing (SIT) of Online Transactions (OLTP Processes), Billing payments, Report and Statement testing.
Performed Regression Testing as and when the Bugs got fixed.
Involved in migration testing of databases from mainframes environment (DB2) to oracle.
Writing test cases for the data extracts to make sure the vendors are sending the correct data files.
Performed Regression testing in RDBMS and functionality testing of database application.
Performed Regression Testing in Stock and share, capital market, POS and online trading.
Performed POS testing for frontend generated GUI files and feed files.
Performed the Black box testing for Functional flow of the applications.
Involved in automation of test cases using QTP.
Writing SQL queries for testing the data in the data warehouse against the data in the source systems.
Create queries and other SQL scripts for test execution and execute them against SQL Server databases
Performed Back-End Testing by creating/executing SQL Queries using SQL Query Analyzer
Monitoring daily load test results to ensure that they are within the tolerance level.
Created Test Reports.
Tracking and analyzing the defects and recording the variation between the expected and actual results.
Environment: Quality Center 8.2, Manual test process, MS Excel, QTP 8.2, Oracle 9i, Sun Solaris, TOAD 7.3, SQL * loader, SQL Query Analyzer, J2EE,Apache,Mainframes Environment (IMS, TSO, SPUFI, FILE-AID, CICS, JCL, COBOL), DB2, .NET
Toyota Finance
Project: Concur Sep 07 - Nov. 08
Position: QA Analyst
Description:
Concur is the world's leading provider of business services that automate travel expense report processes.
Concur Expense Service makes it easy to quickly automate entire expense reimbursement process. It's Web-based, so employees can generate and submit reports anytime, from anywhere using concurs intuitive interface. Managers approve reports with just a click, cutting the processing time in half. Concur Expense Service also produces audit reports, ensures compliance and most importantly delivers valuable Web-based business intelligence to help your company reduce its overall T&E spend.
Responsibilities:
Interaction with client and Keep the Client updated for the progress of the tasks
Preparation of EOPS (End of Release Summery report.).
Preparation of Feature Test Plan.
Review of Test Scenarios, Test Cases, Bugs, Bug regressions.
Manage Daily Status Report.
Handling testing activities.
Handle and execute Security testing of the application using SQL injection.
Developed and executed test plans, test schedules, high level scenarios, resource plans and test completion reports in a timely and efficient manner for all areas of the projects.
Supervised the execution of test cases for smoke, functional, regression, GUI, accessibility, usability, interface, compatibility, data base, back out and end to end testing of on-going projects in different environments.
Provided knowledge transfer to other team members related to the work performed during the time of the contract in order to ensure continuity.
Supported the testing efforts of various project team members (UAT) and end-users, as required.
Generated Online Metrics for different phases of testing using HP quality center web tool.
Prepared Test Data Matrix for all test Cases in Home and Auto
Involved in Regression and System Integration testing for personal lines program
Reported the defects, Email notifications to the developers using the Quality Center.
Environment: Manual Testing, MS Excel, Tomcat application server, J2EE, JSP, Microsoft SQL Server
PC Mobile, Montreal May 06 – Aug 07 Project: Billing Network System
Position: QA Analyst
Description:
PC MOBILE Billing Network System is a web application that manages and maintains the billing accounts of all the existing customers. Each customer has a unique Billing Account Number (BAN) which identifies the billing details, payment frequencies, call duration and call distances. This application is integrated with the customer service application and AMDOCS (a third party billing tool). The application also handles other functionalities like work orders that are sent to the technicians in order to create new line or change a line and with the trouble ticketing system on these lines. The Project is an Enhancements and Maintenance Project.
Responsibilities:
Analyzed User/Business requirements and developed a System Test Plan.
Participated in design and team review meetings.
Responsible for verification of database.
Created test scripts for various testing stages and test case execution.
Automation of Test Scripts for Functional and Regression testing
Performed the Black box testing for Functional flow of the applications.
Prepared Test Data and verified the results against expected results.
Involved in Back End testing, SOA functional testing, performance testing and interoperability testing.
Wrote SQL Statements to extract Data from Tables to verify the output Data of the reports.
Involved in User Acceptance Testing with users along with providing training to end-users.
Involved in Security Testing and Regression Testing.
Created test status report for weekly status meeting.
Environment: Rational clear quest, rational robot, rational test manager, rational rose, SOA, TOAD, Dot Net, Oracle 8i.
MCAP, Toronto Sep 05 – Apr 06 Project: MCAP Mortgage Pal
Position: QA Tester
Description:
MCAP Mortgage Pal application is used by GMAC Mortgage Insurance. The system receives the loan requests from their vendors through manual or automatic process using MQ Queues. The system validates it and makes a decision on the loan request. The project involves SIT Testing, Functional testing, UAT and Production support of the existing system, continuous enhancements and maintenance of the existing application.
Responsibilities:
Mainly responsible for creating design document for pre-qualification implementation.
Working with business user to understand business rules and requirements.
Designing a standard system which can be used by multiple clients for mortgage pre-qualification process.
Working with development team to create XML based interface between multiple systems to create common communication channel with various client applications.
Responsible for analyzing the test results.
Extensive use of SQL for data and other system analysis.
Developed custom views and packages for generating reports for business users.
Conducted extensive Functional and Regression testing using Win Runner.
Created GUI map file, GUI/Database checkpoints, customized objects and Synchronized objects
Developed Win Runner scripts using TSL for data driven and Database testing.
Performed Compatibility Testing of the application on various system configurations.
Performed bug tracking using Test director’s defect management system.
Environment: Win Runner, MS-Excel Load Runner, Test Director, UNIX, VB, Sybase, T-SQL