Visali Boddakayala

Email: aca8wp@r.postjobfree.com; Phone: 416-***-****.

* *******:

> Having 10+ years of professional experience out of which 8+ years of

experience in testing as Sr.QA/Lead analyst and 2+ Years of

Sr.Software Developer in the domains of Retail (POS), Finance,

Insurance, Banking, Brokerage, Health Care industries and

Provincial/Federal government services.

> Performed both manual and automated testing for n-tire applications,

ERP, GUI and Web-based applications using tools of Mercury / HP

Interactive Tools (Win Runner, Test Director, Quality Center, Load

Runner).

> Extensive experience in performing Functional testing, Integration

testing, Regression testing, UAT testing, White Box, Black Box

testing, Load/ Stress/Performance testing, GUI testing,

Infrastructure Testing, Browser compatibility testing, Data Migration

and Conversion testing.

> My expertise lies in creating comprehensive Test Plans, Executing Test

Cases, Developing and Maintaining Test Procedures & Traceability

Matrix from Business requirements (BRD), Functional requirements (FRD)

documents.

> Successfully worked on complex testing using Best QA processes like

Waterfall & Agile. Very well acquainted with all phases of Software

Development Life Cycle (SDLC).

> Experience in integrating four Quality Management modules -

Requirements Management, Test Plan, Test Lab, and Defects Management

using TestDirector / Quality Center.

> In-depth understanding of Defect Management in the Test Director,

Quality Center, this supports the entire defect life cycle from

initiation of defect detection to resolution.

> Experience in Data Warehouse testing and ETL testing using

Informatics 8.1/7.1 (Power Center/ Power Mart, Designer) and Report

testing using Cognos tools.

> Experience in testing and configuration of the COTS using C ram

applications.

> Establishing highly effective relations with the Release Manager,

Delivery Manager, and the Business / IT stake holders to coordinate

test requirements, scenarios and project schedules.

2 CAREER HISTORY:

Ministry of Transportation (MTO)

Aug'13 - Current

D+H Ltd

Mar '12 -Dec' 12

Capital C

Aug'11 - Mar'12

L&T InfoTech Ltd

Jan'11 - Jun' 11

CITI Group

Jul'08 - Dec'11

BD (Becton, Dickinson and Company)

Apr'06 - Apr'08

Foresters Insurance Company

Sep'05- Mar'06 WELLS FARGO

Dec'04- Aug'05

3 TECHNICAL SKILLS:

TESTING TOOLS: HPQC, QTP, Winrunner, LoadRunner, Silk Test,

Selenium

BUG TRACKING TOOLS: Quality Center, Test Director, Track Record,

JIRA, Orasi Bridging

TICKETING TOOLS: Remedy, Heat and clarify, Bugzila,

Compuware

operating SYSTEMS: Windows7/XP, NT, 2000 & 2003, UNIX (Solaris),

OS/400

Programing languages: C, Java, C#, ASP, VB.NET

Middleware: MQ Series, BizTalk, Web Methods, Websphere,

Weblogic

Scripting: Shell Script, VB script, Java

Script, CGI, PHP, HTML, XML, SOAP

communication tools: Microsoft Outlook, Lotus Notes Same time,

Jabber

DOCUMENTATION TOOLS: Documentum, Live link, Share point portals

DatAWearHouse: Informatica 8.1/7.1(ETL), CognosV8.4, Crystal

Reports,

MS-SQL Server V2000/7.0, T-Sql, PL/SQ and Toad

4 PROFESSIONAL EXPERIENCE:

Road Safety Modernization Project

Aug '13 - Current

Ministry of Transportation(MTO),North York

Sr.QA Analyst

Project Brief:

MTO is chartered to implement an integrated solution to support the

management of Ontario's International Registration Plan (IRP) and

Oversize/Overweight (O/O) Permitting programs. OO Application is SOA

designed application. O/O permits are issued for vehicles that exceed the

weight or dimension limits prescribed in the Highway Traffic Act. Different

types of permits are available like Annual permits, single trip permit,

project permit and SVC (Special vehicle configuration) permit. OO

application allows transaction on permits like amendments, renewal, hold,

cancellation reinstate, suspend and replace permit. This project involves

the replacement of the existing MTO legacy OO application with a Commercial-

Off-The Shelf (COTS) solution that will be integrated to the rest of the

MTO systems and process. The current OO reside in an ORACLE (RDBMS)

database and the Celtic COTS solution is a SQL server database. Celtic will

be responsible for the data conversion from source to target.

Job Accomplishments:

> Performed testing on (Oversize/Overweight) OO application which is

designed on SOA architecture which is COTS application.

> Analyzed Business and functional documents and prepared test plans and

test cases for OO application from requirement traceable matrix to

cover 100% coverage.

> Prepared documents and tested data migration process and records and

logic to transfer data from source to target.

> Prepared documents and data for Performance testing and assisted

performance team to ensure that performance testing and test results

meet performance metrics.

> Performed different types of testing like Sanity testing, integration

testing, functional, regression and performance testing.

> Performed testing on manual and automated routing for bridge

clearances for trucks with overweight/oversized loads using analytical

data provided from PHM server (Provides Map data and Restriction data)

and OSCLIS(Ontario structure& Load information system). PRIO

application uses PHM server analytical data and creates way points for

truck clearance on the path, tested to check path and way points are

correctly populated for clients.

> Performed manual testing of COTS application from Celtic.

> Performed testing on functionality of permits, transactions on permits

like renewals, replacements, hold, cancellation, refunds and reinstate

and verified credentials.

> Online payment process using cash, credit cards, store cards and

certificates.

> Prepared excel documents using excel functions for reports and

analyzing test efforts and defect results.

> Performed audit testing, printing permits on secure paper and invoice

generation.

> Evaluate defects found during reviews to determine root cause and

report to Celtic and prepare report for defect management.

> Participate in testing activities to ensure that the test results meet

defined acceptance criteria.

Environment: SOA, HPQC, QTP, Load runner, Oracle, DB2, JSF, HTML,XML,

Internet Explorer, Team System, Windows7/XP, True Compare, MS Excel, SQL

Server, PRISM, PRIO,

StreamLoan Data migration

Mar '12 - Dec '12

D+H LTD, Mississauga

Sr.QA Analyst

Client: Ministry of Consumer and Business services.

Project Brief:

D+H acquire CSRS/Win PPSA Government Database system(Ministry of Consumer

and Business Services) and started process of migrating data from CSRS

(Canadian Securities Registration Systems) database to StreamLoan web

application, because of high maintenance on legacy system of CSRS.CIBC

intended to match data from multiple, non-integrated systems, e.g., eDiary,

iCAP, RDPRM, etc with CIBC registration in CSRS database and Migrate to In-

house application StreamLoan to support small business loans by reducing

the turnaround time on PPSA activities and decreasing error rates. It is

large project.

Job Accomplishments:

> Reviewed technical document and prepared test cases, test plans for

Streamloan migration utility, Streamloan, Match and kill process and

registry testing.

> Performed testing on Shared securities, credit packages, tasks,

insurances, migration options, migration rules and match rate for auto

match, assisted match and manual match of registrations, registry

testing and submitted to collateral guard.

> Performed manual functional, Positive, Negative, Integration, UAT/BAT,

smoke, grey box and regression testing on Streamloan migration utility

and Streamloan applications.

> Creation of Informatica Workflows, sessions and Run that Sessions to

load into Target and Debugging, Unit Testing of Mappings.

> Validated the load process of ETL to make sure the target tables are

populated according the data mapping provided that satisfies the

transformation rules.

> Involved in coordinating the Black box testing for the Data warehouse

by checking ETL procedures/mappings.

> Build and executed complex SQL Queries to validate source data to

migrate from source to staging database.

> Performed validation check on data on staging database for final

migration to stream loan application.

> Logged the valid defects and interacted with the application

development teams to resolve the issues through Defect Calls. Provided

in-depth detailed information to developer to resolve defects.

Environment: HPQC, QTP, JAVA, Oracle, Toad, DB2, JSF, HTML, CSS, XML,

Internet Explorer, Compuware, Team System, Windows7/XP, Informatica Power

Center 7.1, MS Excel.

Facebook Applications

Aug'11 - Mar'12

Capital C, Toronto

Sr.QA Analyst/Lead

Project Brief:

Facebook application's project is to develop new applications in

Facebook for their various clients like Toshiba, Nissan, Food Network

and Bissell. Capital C develops applications for a variety of online

businesses, online game and marketing initiatives in a multi-platform

environment. E-Commerce sites for Nissan and Toshiba.

Job Accomplishments:

> Led team of 5 testers in the development and execution QA strategy and

test plans of all Capital C digital projects.

> Review project business and technical documentation and create detail

test plans, test cases, traceability matrix and test scripts to ensure

the application performs as defined in the business and functional

requirements.

> Performed manual functional, integration, smoke and regression testing

on Facebook and mobile applications on IOS, android, smartphone and

tablets and iPad applications.

> Generated reports and graphs from HP Quality Center to project and

report Test Effort in the Test Case Creation phase and Test Execution

phase.

> Created complex SQL queries to validate backend database.

> Performed web content, user maintenance testing using Adobe CQ on

client websites (Nissan, Toyota and Toshiba).

> Tested applications on different web browsers (IE, Firefox, Safari and

Chrome) in windows and Mac.

> Tested applications of HTML, Flash based web applications and mobile

applications.

> Involved in walk through test cases to QA team before execution of

test plans and defect investigation and procedure to escalate defects

to proper channel. Report results to Project managers.

Environment: HPQC 10, QTP 9.0, Load Runner 9.1,JAVA,JSF, .Net, MS SQL

Server, HTML, CSS, XML, Java, Internet Explorer, Adobe CQ5, Safari,

Firefox, Mac, Windows 7/XP.

Project Phoenix

Jan'11 -

Jun'11

L&T InfoTech Ltd, Mississauga.

Sr.QA Analyst/Lead

Project Brief:

Project Phoenix is to develop new Unitrax functional screens for GUI,

which is not developed in SRP Project in Unitrax system (Mainframe).

Developed n-tire web based application using in 3GL language and JAVA.

SharePoint application to accommodate new requirements of SRP project

and Transaction screens. Project is developed on agile methodology.

Job Accomplishments:

> Mentored and Led team of 8 tester from off-shore and On-site.

> Involved in Business requirement (BRD), Functional requirement (FRD),

Over All Design, and Use-Case analysis, Initial Summary, Risk Analysis

and Documentation in SIT environment.

> Involved in intensive testing of Unitrax SRP project like adhoc jobs

for reports, workdoc functionality, Investment banking, Fixed Income,

Capital Market, Pricing system, Cash management, Wealth management,

MEM screens, Bonds, payment calculations and derivatives.

> Validated the data extraction and transformation logic, including

testing of a dimensional model.

> Validated the testing a number of data loading every week. Created

test conditions for data models.

> Tested end to end data flow from source to data mart to reports,

including calculation logics and business rules.

> Performed both automated and manual Positive, Negative testing,

Integration, Functional, gray box, Smoke, BAT/UAT (Business/User

Acceptance Testing) and performance Testing.

> Created central data storage in Share point for Test plans, Documents

and deployment track records and reports.

> Create and maintained Excel sheets for team meetings and testing

status using excel functions.

> Executed and written complex SQL Scripts using JOINS and UNION to

analysis and test the database.

> Logged the valid defects and interacted with the offshore development

teams to resolve the issues through Quality Center, Follow-up Calls

and Daily Defect meetings.

> Supported the Project manager and Delivery manager with developing

crystal reports and presentations for management review.

Environment: HPQC 10, QTP 9.0, Load Runner 9.1,EGL, Oracle, JSF, Web

Services, PCML, HTML,DB2, IBM Websphere, .NET, Crystal Reports, Share

Point,, IBM Mainframe,Windows XP .

Screen Replacement Project (SRP)

Jul'08 - Dec'10

CITI Group (Mutual funds and Investment Banking), Mississauga.

Sr.QA Analyst

Project Brief:

Screen Replacement Project is a web application which is used for

banking operations for clients. SRP is basically replacing existing

transfer agency Unitrax (Mainframe) Green screens which are developed.

GUI based SRP is more user friendly and also clients can access

online. Screens are developed in EGL language. This is a data

intensive, large and complex project.

Project is developed on agile methodology.

Job Accomplishments:

> Prepared the Business (BRD) and Functional (FRD) requirement

documents, translated into Test cases according to the established

standards for all releases (1, 2, 3 and 4).

> Provided subject matter expertise on full QA life cycle, performed

both manual and automation testing from the beginning of the project

to end of the project.

> Prepared documents, test plans and test cases to execute by off shore

and on-site team.

> Involved in intensive testing of new Developments of Unitrax SRP

project like Pension administration, interest calculations, Credit

cards, OLTP, back office operations, Trading system, Capital market,

Pricing system, Investment banking, Bonds, Trading and Mutual Funds

Screens.

> Performed automated and manual Positive, Negative testing,

Integration, Functional and performance Testing in SIT and BAT/UAT for

different clients.

> Performed testing of mobile applications on android, blackberry,

smartphones and tablets and iPads.

> Created and executed scripts in QTP using VB script for regression

testing and Sanity testing.

> Executed and created complex SQL Scripts for data mining and business

conditions and for data analysis.

> Tested SQL Triggers for business rules.

> Tested data quality check for accuracy, completeness like missing

data, invalid data and inconsistencies.

Environment: HPQC 10, QTP 9.0, Load Runner 9.1,EGL, Oracle(RDBMS), JSF,

Web Services, PCML, Summit(Trading system), HTML, IBM Websphere, .NET,

Internet Explorer, Biz Talk, Crystal Reports, Share Point,, Windows XP

Professional.

WirlessWatchDog (Manhattan Warehouse Management for Open System)

Nov'07 - April'08

BD (Becton, Dickinson and Company), Oakville.

Sr.QA Analyst

Project Brief:

WirlessWatchDog is an implementation of Manhattan Warehouse Management

for Open Systems (WMOS) which is n-tire application allows for real-

time control over everything happening in Distribution Center. It is a

merchandise and supply chain project.

Job Accomplishments:

> Engaged with business stakeholders, subject matter experts, and

application systems analysts & developers for process blueprints on

all aspects of warehousing design for all Inbound and Outbound

functional of Manhattan WMOS.

> Involved in testing various inbound process functionalities as

interfaces, receiving, putaway, cycle counting and vendor performance

and the outbound process functionalities as waves and wave management,

replenishment, allocation, picking and packing, and transportation of

WMOS. Tested RF devices functionality.

> Test management with HP QC (Quality Center): Managed Test planning and

designing, developing and executing manual tests and suites, prepared

for automated testing, Determined and report test results.

> Responsible for coordinating script execution between numerous

functional areas and executing tasks pertaining to the Manhattan WMOS

warehouse management system.

> Created data driven scripts to be used with various data / test cases

for positive and negative testing of the application. Developed

performance test strategies and scripts in Load runner.

> Performed Regression testing to prove that the new code has no adverse

effect upon the current system particularly in the area of corrupting

data used by different applications or system performance.

Environment: HP QC, VB.Net, MSSQL Server7, Windows 2000, Visual Source

Safe, Visio, MSWord, Informatics, Manhattan (WMOS), LoadRunner.

BD Attendance Management (Web Portal)

April'06 - Nov'07

BD (Becton, Dickinson and Company), Oakville.

Sr.QA Analyst

Project Brief:

The BD Attendance management is a web application n-tire application

for HR department which is used for request, approve and manage the

vacation time for all the employees and calculates vacation accrued by

each employee, it takes the factor of length of service, position,

location policies, specials rules, etc. and generates reports for each

employee and updates their vacation related data of Employee Master

File in the SAP. Project is developed on agile methodology.

Job Accomplishments:

> Tested the various functionalities of Associate, Approver and HR Admin

in the BD Attendance management.

> Involved in Business and System requirement documents, provided

expertise to translate into Test cases.

> Performed Positive, Negative, Integration, Functional, Regression,

Stress and performance testing.

> Tested data from the data warehouse data mart is mapped and designed

correctly in the OLAP cube or reports.

> Validated derived measures, aggregations, all dimensions, including

slowly changing dimensions and attribute hierarchy.

> Validated the data extraction and transformation logic, including

testing of number of data loading every day.

> Tested layout of format per design mock-up, style sheets, prompts,

filters, attributes and metrics on the reports.

> Executed and created complex SQL Scripts to test the backend Data Base

and analyze data.

> Remedy is used to track tickets raised from production support team.

Environment: HP QC,, SAP, MS SQL Server, T-SQL, ASP.NET, C#, Web

services, XML, HTML, CSS, MS Exchange server, QTP 9.0, Cognos, Data

Warehouse environment.

Customer Insurance Tracking System

Sept'05 -Mar'06

Foresters Insurance Company, Toronto.

QA Analyst

Project Brief:

Customer Insurance tracking system is a web application which helps

the field agents of the company to enter prospective customers' data.

The application also calculates the amount of premium required, cash

value and benefit amount for the years in consideration.

Job Accomplishments:

> Responsible for creation of the QTP scripts and enhancing the

automated test scripts created.

> Performed parameterization and performed check point analysis of the

scripts and enhanced them according to the test case. Created complex

Oracle SQL queries to check business conditions on database. Performed

Shell scripting on UNIX platform.

> Executed and developed automated test scripts and reported any

problems.

> Updated, maintained, and promoted Test Plans and Scripts to

configuration management for version control.

Environment: QTP, ASP, Java Script, VB Script, Oracle 8i (RDBMS), SQL,

PL/SQL, Visual Source Safe, Compuware Track record.

NAO Service System

Dec'04 - Aug'05

WELLS FARGO, Toronto.

QA Analyst

Project Brief:

WELLS FARGO is a diversified financial services company in Canada and

U.S. This project is for integration of general banking and brokerage

application. I was involved in Brokerage application, NAO (New Account

Opening) and service requests. Project is developed on agile

methodology.

Job Accomplishments:

> Created and executed manual Test cases, Test plans and Test Matrices

using Test Director in SIT environment.

> Initiate, coordinate and implement the system testing Process.

> Performed manual Testing of the trading application using Test

Director.

> Created follow-up report using MS-Excel functions.

> Performed regression, database backend testing using SQL queries for

the application.

> Performed web services testing on web application.

> Production Support for Trading Application.

Environment: HP Non-Stop (Tandem), Windows 2000, Java, HTTP Server, IBM

WebSphere Application Server, JSP, HTML, Test Director, Winrunner, MS -

Money, Intuit Quicken, JIRA QuickBooks, MS - Excel, Oracle.

Wendy's Point of Sale System (Quick Service Restaurant System)

Aug '03 - Sept'04

Wendy's Inc. (Consulting Assignment of TATA Consultancy Services)

QA Analyst

Project Brief:

Wendy's Point of Sale (POS) system currently used all Wendy's

corporate store. The Quick Service Restaurant System consisting of a

touch screen point of sale (POS) system which consists of three module

Order process, Billing and Employee payroll system which connected to

the back-office applications.

Job Accomplishments:

> Performed functional, regression, white-box and black-box testing on

the various functionalities of User Login, Order Process, Billing and

Employee Payroll. Performing online transactions OLTP.

> Used Test Director to create and execute the test cases and manage

defects from inception to resolution. Performed system, integration,

automation and regression testing.

> Used Oracle SQL queries to perform backend testing on the database.

Environment: Windows 2000, ISUAL C++, COM, XML, XSLT, ATL, MFC and WINSOCK,

Oracle, Test Director, Winrunner.

EDUCATION:

> Master Degree in Computer Application (MCA), University of Madras

Apr' 2001.

> Bachelor Degree of Science (B.Sc.), Andhra University

May' 1998.

> MCSE Certified

2004

> CCNA Certified

2004

Contact this candidate