Profile Summary:

• Rich Experience in Writing Test Strategies, Test Plan, Test Cases, Defect Reports.
• Experience in Agile Waterfall Methodologies
• Expert in working with automated tools like Selenium Webdriver 2.0, UFT 11.5 formerly QTP .
• 9 years of Professional Experience in Software testing ISTQB certified .
• Worked on Finance and Ware-House / Supply Chain Technology System Domains.
• Proficiency in designing and implementing innovative Automation Frameworks
• Extensive experience in designing Automation Scripts using VB Script C .
• In-depth experience in Web Services Testing using WCF Windows Communication Foundation Test Client.
• Performed Database Testing on Oracle and DB2 database.
• Mastered in developing SQL queries to Access, Manipulate and validate the data.
• Used the TOAD, SQL developer tools to perform Database Testing.
• Good understanding of all stages of SDLC, STLC, Defect Life Cycle.
• Experienced in handling E2E testing phases from QA planning to delivery phase of applications.
• Extensive experience with Web-based, Client/Server and batch applications.
• Proven ability in White Box Testing and Black Box Testing Functional Testing, Regression Testing, Exploratory and UI testing.
• Solid Experience working with test management tools like HP ALM 11.0 Quality Center , JIRA.
• Ability to work under minimal supervision, adhere to deadlines, excellent verbal and communication skills.

Technical Skills:

Projects

Confidential

Technology:

• Front End : Web-Based Dot.Net Application
• Database : Oracle
• Languages : C , ASP.Net
• Tools : TOAD, SQL Developer, ALM, WCF

Responsibilities:

• Thorough review analysis of Requirements in every sprint.
• Followed Agile Methodology includes sprint Meetings product deliverables
• Test Estimation and creating Test Strategy, Project Test plan detailed Test plan.
• Setting up test Environment prepare test data in the production size environment
• Involved in preparing Requirement Verification Traceability Matrix
• Worked on automation Test framework and used the Test framework to automate Functional and Regression testing of project components.
• Designed automation scripts using C in selenium webdriver 2.0 in the Visual Studio 2010 IDE
• Interacted with development and support groups to understand the application architecture and recommend testing strategy.
• Interact with Business Analysts and Developers during defect review meetings during the project.
• Participate in design walkthrough and review meetings while interacting with customers.
• Web services testing using WCF Test Client
• Database testing using the TOAD and SQL developer
• Good understanding of core warehouse functionalities like Receiving, Replenishment, Picking, Packing Shipping
• Creation and execution of test cases
• Preparation of test summary report and providing Sign off to the project
• Train and mentor team members for continuous improvement of team deliverables.
• Daily review of defects assigned in HP QC and defect retesting accordingly.
• Coordinate the activities in Pre Post release

Confidential

• SMS-Shareholder Management System is the Canadian Transfer Agency's primary database for dealer and investor account information. SMS is a database that contains all clients and dealer information on all accounts for Franklin Templeton Investments. The Application is developed on AS-400 to support the Franklin Templeton Database of 8 Million Users with more than 15,000 Funds and acts as Database for the web applications of Franklin Templeton.
• Letter Automation Process Oct'2012 to Sep'2013
• The goal of this project is to eliminate the existing manual process of creating and sending confirmation letters to clients when certain non-financial and financial changes are made on their accounts in the SMS. The purpose of sending a letter is to ensure that the client is aware of the change and has, in fact, requested it. Therefore, whenever a non-financial or financial change is triggered in an account an automated process is designed which generates a letter to client. DST refers to DST Canada, print vendor for Franklin Templeton Investment Corporation will print the Letters for Franklin Templeton account holders.

Technology:

• Front End : Web-Based Dot.Net Application
• Back End : DB2
• Tools : SQL/400, SEQUEL, ABSTRACT and ALDON

Responsibilities:

• Receive Requirements from client, analyze with team, conduct internal and client KT sessions with BA, Provide estimates to client, design test suites, perform reviews, execute along with the team, prepare daily and weekly status reports.
• Followed Agile Methodology includes sprint Meetings product deliverables
• Test Estimation and creating Test Strategy, Project Test plan detailed Test plan.
• Setting up test Environment prepare test data in the production size environment
• Creation and execution of test cases Code promotion to Test Environment.
• Run the series of daily batch cycle jobs to generate the letter extract feeds
• Validate the Letter extract feeds generated in the DB2 transmit the Letter extract feeds to DST location through FTP and then Coordinate with the print vendor DST to obtain the Letter PDF's and paper copies
• Test Control and Test Monitoring Providing Sign off to the project
• Regularly update process documents, Project metrics, delivery reports and quality assessment reports
• Present reports to various stake holders across different forums weekly, fortnight, monthly and quarterly meetings
• Train and mentor team members for continuous improvement of team deliverables.
• Daily and weekly calls with client
• Prepare Exit summary reports, milestone analysis reports, Case study reports, monthly newsletters and lessons learnt reports
• Responsible for deliverable of module allotted as an individual contributor in the team
• Upload all the documents into SharePoint for client review
• Automated the Regression Suite using the UFT
• Designed comprehensive automation scripts using VB Script in UFT
• Daily review of defects assigned in HP QC and defect retesting accordingly.

Confidential

Technology:

• Hardware System : AS/400
• O/S : OS/400
• Database : DB2/400
• Languages : CL/400, ILE COBOL, COBOL/400, ILE RPG
• Tools : SQL/400, SEQUEL, ABSTRACT and ALDON

Responsibilities:

• Active Participation in the Daily Project Meetings with all the project stakeholders and update the testing progress/deliverables status.
• Requirement workshops with DEV/ BPA team to resolve queries and conflicts.
• Test Estimation and creating Project Test plan detailed Test plan.
• Documentation to reflect reviews, Daily status report, and Test exit summary report.
• Compare results with the existing process by capturing the maximum elapsed time between each thread
• Through performance testing done to evaluate the results of thread rebalancing
• Coordinating guiding the on-site offshore teams
• Independent handling of QC cycles for application releases with a team of members which includes handling the following phases of testing efforts
• o Daily work allocation for team members based on their skill level.
• o Training new team members for project requirements.
• o HPQC folder structure creation, uploading of documents, test cases, mapping of requirements.
• o Distribution of initial defect status so as to avoid duplicate defects.
• o Motivating team members to reach the targeted numbers of test cases by the end of the day.
• o Test execution.
• o Result analysis.
• Assess the last minute Change Requests, estimate and plan.
• Identification of targeted regressions for a short and urgent QC cycles.
• Metrics collection.
• UAT log analysis.
• Additional Contribution for the projects with lot of hands on testing.

Confidential

Technology:

• Hardware System : AS/400
• O/S : OS/400
• Database : DB2/400
• Languages : CL/400, ILE COBOL, COBOL/400, ILE RPG
• Tools : SQL/400, SEQUEL, ABSTRACT and ALDON

Responsibilities:

• Generate the Shareholder, Account, Fund, Transaction, Dealer and Rep information and transaction counts for the Canadian funds in a flat file MPAR Extract
• FTP the MPAR extract through SACSUN server to the PeopleSoft Enterprise Perform Management which stores and calculate the profitability results.
• Responsible for planning/tuning activities for a client environment
• Project meetings, Defect reviews, KT sessions for other teams at client side.
• SRS and CR reading, RTM preparation. Discuss with BPA/Dev team if requried.
• Prepare Test conditions based on the requirements and get reviewed.
• Create test setup which includes creating release and cycle under appropriate folder in HPQC, create requirements and map to the corresponding release cycle, upload test cases from Excel sheet in HPQC test plan, create mapping of test cases with requirements, load test cases in Test lab.
• Create test environment set up requests like DB changes, H/W changes and configuration changes if required with Admin team.
• Execute test cases, report defects.
• Finalize the automation candidate test cases from regression suite to automate.
• Defect retesting and regression testing in case of cycle 2.
• Exit summary report preparation in case application meets exit criteria.
• Test Control and Test Monitoring Providing Sign off to the project.

Confidential

Technology:

• Front End : Web-Based Dot.Net and JAVA Application
• Back End : DB2
• Tools : SQL/400, SEQUEL, ABSTRACT and ALDON

Responsibilities:

• Trained the resources in Toronto and Hyderabad on statement generation and validation process
• Prepared the Training manual for statements validation
• Test Estimation, creating Project Test plan detailed Test plan.
• Coordinate with the Marketing department to obtain the Marketing messages and events to be endorsed on Quarterly statements
• Quality check the statements generated directly from production and ensure correctness.
• Work with integrity as client data is being directly accessed while testing the statements
• Run a daily, month-end, Quarterly and year-end batch cycle jobs to generate the quarterly statement extract feeds.
• Thorough validation of statement extract feeds in database files
• FTP the statement extract feeds to DST Coordinate with DST to obtain the statement PDF's and paper copies
• Setting up test Environment Prepare test data in test environment
• Creation and execution of test cases Code promotion to Test Environment.
• Reporting Weekly Status of the projects, Weekly project status meeting.
• Mentoring the team, Test Control and Test Monitoring.
• Providing Sign off to the project.

Confidential

Technology:

• Front End : Web-Based Dot.Net Application
• Back End : DB2
• Tools : SQL/400, SEQUEL, ABSTRACT and ALDON
• Tested the critical functionalities of the project like Prices performance of funds
• Test Estimation, Creating Project Test plan detailed Test plan.
• Setting up test Environment Code promotion to Test Environment.
• Creation and execution of test cases.
• Reporting Weekly Status of the projects.
• Weekly project status meeting.
• Mentoring the team.
• Actively involved in performing comprehensive Functionality testing and Regression testing.
• Tracking and reporting the bugs.
• Preparing test reports
• Test Control and Test Monitoring
• Providing Sign off to the project.

Confidential

• Worklogs constitute of a monthly maintenance release where a group of worklog tickets are tagged together to form a release. Worklog tickets are raised by various departments in Franklin Templeton who use SMS to perform daily business tasks. Whenever an issue is found on the production system a ticket is raised and a BRD is created to resolve the issue. Worklog tickets are also raised when a dealer/customer reports of an issue.
• Leading the Worklog Maintenance projects.
• Extensively performed manual testing to ensure the quality of the software.

Test Estimation

• Creating Project Test plan detailed Test plan.
• Setting up test Environment Code promotion to Test Environment.
• Creation and execution of test cases.
• Actively involved in performing Functionality and Regression testing.
• Reporting Weekly Status of the projects.
• Weekly project status meeting.
• Involved in Tracking and reporting the bugs.

Confidential

• A new fund is launched into the market to encourage dealers and investors to invest with Franklin Templeton. Bisset Bond Fund was launched in July 2009 which provided investors to relinquish the front load charges and promised better returns. Whenever a fund is launched the details related to Fund has to be updated in the database.
• The investors are allowed to invest on the Fund using SMS, Fundserv, GI. Also, the information related to the funds has to be captured in the Adhoc and Quarterly statements, Investors are allowed to view the details through GWS and through IVR.
• Creating Project Test plan and detailed test plan.
• Code promotion to Test Environment.
• Updating the Fund related files on the test environment using DFU utility in AS400.
• Validating the files after updating the fund details.
• Validating the trades by placing them through FundServ.
• Validating the Adhoc and Quarterly statements.
• Running the daily batch job on test environment and ensuring the price file is updated on IVR.
• Validating the information through IVR.
• Reporting Weekly Status of the projects.