Bharat S Anjna

+1-401-***-**** acwxhp@r.postjobfree.com

Experience Summary

A competent professional offering 8.0 years of experience in the IT industry with wide range of experience in Business System Analyst and Software Testing Life cycle processes.

Extensive QA experience in different phases of lifecycle, including Test Planning, Test Case Design, Test Execution, Defect Tracking, Management and Reporting.

Extensive experience in analyzing, reviewing and understanding of Business/Functional & Testing requirements

Experience in working with QTP descriptive programming, Keyword driven and Data driven and Hybrid Frameworks.

Domain expertise includesFinancial Market Data (Six Financial Information Provider, Credit-Suisse), Investment Banking, Capital Market (Strate), Manufacturing (Cisco) & Healthcare.

Holds the distinction of working onsite (Johannesburg, South Africa), wherein involved in project implementation from scope management, to activity sequencing, risk analysis to quality management in line with standard guidelines & norms.

Well versed with Agile Methodology and experience in using JIRA as tool for Agile.

Proactively worked in FDD (Feature-Driven Development) & TDD (Test-Driven Development) environment.

Adept in end-to-end software testing from requirement analysis to system study, designing, coding, testing & de-bugging of applications

Sound knowledge of Software Integration, Regression, Usability, Back End, Front-end, Functional, System, Browser and Compatibility Testing.

Excellent analytical & logical abilities coupled with team management skills

Experience in Data Mining, PowerMart, PowerCenter, Server Manager, Session Manager, Designer, Workflow Manager, Workflow Monitor, MetaData Reporter.

Expertise in data warehousing, database design, and business intelligence.

Excellent knowledge in extraction, cleansing and modification of data from/to various data sources like flat files and databases

Good understanding and hands on experience with web technologies like HTML, XPATH, XML.

Experience in Web services testing using SoupUI 3.6

Proficient in writing and executing complex SQL queries.

Efficient and versatile team player with a positive approach to all tasks. Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports.

Worked with various test management/Defect Management with tools like ALM (Quality Centre) and JIRA.

Significant Features of the careers include:

Profound experience in:

oSoftware Test Life Cycle (STLC)

oTesting techniques and methodologies

oDefect Tracking Life Cycle (DTLC)

oDetail study of the BRD, Scenario identification, FRS and Bug Reporting using Quality Center 9.2/11.0 and Jira

Well versed with:

oAutomation (QTP 10.0/11.0 & Quality Center 11.0) and Manual Testing, SoupUI

oDB2, ERP, Jaws, Windows XP, Windows 7 &SQL Server

Technical Skills:

Testing Tools

QTP, SoupUI 3.6, Quality Center, Informatica 8.1 (ETL), Jaws and Tectia

Database

Oracle 10g, SQL Server 2000/2005, DB2, TOAD

Version control

SVN(Subversion)

Languages

VB Script, XML, SQL, UNIX, Shell Scripting

SDLC/STLC

Agile, Scrum, Waterfall, V model.

Education:

Master of Science (M.Sc.), Information Technology from Devi Ahilya Vishwavidyalaya, INDIA Year 2008

Project Experience

Sirius XM Holdings Inc., New York Jan 2016- Till now

Sr. Quality analyst

Sirius XM Holdings Inc. is the largest radio company measured by revenue and has more than 30 million subscribers.SiriusXM creates and offers commercial-free music; premier sports and live events; news and comedy; exclusive talk and entertainment; and a wide variety of Latin commercial-free music, sports, and talk programming. SiriusXM is available in vehicles from every major car company in the U.S. and smartphones and other connected devices, as well as online at siriusxm.com. SiriusXM listeners can personalize SiriusXM’s expertly curated commercial-free music channels using MySXM and listen to thousands of hours of programming on demand using SiriusXM on Demand.

Responsibilities:

Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.

Involved in testing like - Functional, Integration, Regression and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.

Managing new requirements from the project.

Determining tasks to all testing team members and conducting meetings with them.

Participating in daily and weekly call to discuss status and progress with the client.

Involved in Test case testing, Execution & Defect Tracking.

Determining tasks to all testing team members and conducting meetings with them.

Coordinated with team members, developers located in various time zones.

Identifying and debugging all the defects related to the project.

Participated in Daily Scrum/Stand-up/status meeting, Sprint planning and demo meetings, weekly assessment meetings with business analysts, developers, DBA and others.

Technologies Used:Manual(Functional) Testing, SQL Developer, Quality Center 11.0& Jira

Methodology: Agile Methodology

Royal Bank of Canada (Volcker Matrix – CFTR), NJ, USA Jan 2015 – Dec 2015

Associate / Test Lead –Automation

Purpose of this project is to make Client Compliant towards Volcker Rule portion of Dodd-Frank Wall Street Reforms and Consumer Protection Act of United States by fiscal 2016, which when fully operational will enable regulators to monitor daily trading activities and identify potential breach of Volcker Rule prohibition on Proprietary Trading.

Team has been tasked to Design and Develop Customer Facing Trade Ratio (CFTR) Engine, when this CFTR Engine is fully designed and developed, it will generate the Quantitative Matrix of Trade Ratio and Value Ratio that will be shared with Financial Regulators.

Responsibilities:

Carrying out detailed study of the change request and requirement specification document.

Handling scenario identification and writing test cases for critical enhancements.

Designed, Developed and Executed Test Plans, Test Cases and Test Procedures based on the

Functional specifications.

Developed traceability matrix to ensure all the requirements are covered for testing.

Involved in Creation of Automated Scripts, executed the same and analyzed the results in QTP.

Worked on Data Table (Data Driven), Object Repository, Expert and Keyword View Framework.

Involved in Framework designing (Hybrids Framework).

Responsible for Recovery Scenario Management/Exception Handling through QTP.

Reviewed test cases and executed the test cases with QTP (Automation Tool) & manually.

Validated the data at back-end and Database Integrity by using different SQL Queries.

Created the test environment for Staging area, loading the Staging area with data from multiple sources.

Involved in Test case testing, Execution & Defect Tracking.

Determining tasks to all testing team members and conducting meetings with them.

Coordinated with team members, developers located in various time zones.

Identifying and debugging all the defects related to the project.

Participated in Daily Scrum/Stand-up/status meeting, Sprint planning and demo meetings, weekly assessment meetings with business analysts, developers, DBA and others.

Technologies Used: QTP, SQL Developer, Quality Center 11.0& Jira

Methodology: Agile Methodology (FDD & TDD)

First Gulf Bank (Balance Transfer & Quick Cash), Pune, India Mar’2014 - Dec’2014

Associate / Test Lead –Automation

FGB stands for ‘First Gulf Bank’ and Established in 1979 and headquartered in the UAE capital, Abu Dhabi, the bank offers a full range of financial services to business and consumer sectors throughout an extensive network of branches across the UAE. Internationally FGB has branches in Singapore and Qatar, representative offices in India and Hong Kong and a subsidiary in Libya.

Responsibilities:

Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.

Involved in testing like - Functional, Integration, Regression and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.

Managing new requirements from the project.

Determining tasks to all testing team members and conducting meetings with them.

Participating in daily and weekly call to discuss status and progress with the client.

Involved in designing the Hybrid Frame work (Keyword & Data Driven Framework).

Worked on Data Table (Data Driven), Object Repository, Expert and Keyword View Framework.

Responsible for Recovery Scenario Management/Exception Handling through QTP.

Reviewed test cases and executed the test cases with QTP (Automation Tool) & manually.

Extensively performed Mobile testing on different types of operating systems such as IOS and Android

Performed testing on the app using Emulators & Simulator.

Experience in Mobile Application testing includes UI, Functional/Non-functional, Regression tests, Device compatibility tests, Performance tests, Security interoperability testing, Usability testing.

Worked on different types of projects on different platform such as Mobile and tablets.

Mobile testing in agile environment using actual devices.

Logged & tracked all the defects related to the project.

Technologies Used: QTP, Sql Developer& Quality Center 11.0

Methodology: Waterfall Model

Credit Suisse (FIS (Financial Info Server), Pune, India Nov‘2012 - Feb’2014

Associate / Test Analyst (Automation) Cum Business Analyst

FIS stands for ‘Financial Info Server’. It is an intermediary system to collect market data information from different providers and offers market data in a consistent form for display in the intranet and internet to frontend web based applications. FIS receives markets information and fundamental data about financial instruments from various sources via various interfaces. Certain import and processing rules built in FIS to improve the data consistency. The data covers Quotes of different actuality (real time, delayed, historical, internal enriched) and shows the data also in graphical way. Additional information offered is news, key figures and research data. The search function allows a fast selection of financial instruments with combined criteria. User defined quote limits are watched and if exceeded an alert is triggered. FIS provides data for a number of instruments in the trading markets.

Responsibilities:

Involved in (As Business Analyst):

Define, plan, coordinate and obtain information requirements to support and module releases.

Coordinate with multiple resources efficiently and effectively throughout the development lifecycle so as to ensure that the projects are completed on time, meet requirements, are implemented accurately and the full impact is understood by the business owner

Interface with internal business users as well as various IT development groups so the needs can be clearly understood, expectations managed and change initiated.

Act as the point of contact between the business units and IT.

Perform analysis for business applications.

Use systematic techniques for specifying requirements - like use-case scenarios, process modeling and data-flow diagramming.

Involved in Designing documents like-Project Version Document, Use Case, Business Requirement Document, Requirement traceability matrix (RTM), Functional requirement specification (FRS)/ Functional Specification Document (FSD).

Involved in (As Test analyst):

Responsible for scenario identification & test case writing for critical enhancements.

Involved in Test case Design, Execution & Defect Tracking.

Reviewing designed test case by team members

Execute the test cases.

Conducting Smoke Testing before demo to client and executing regression suite

Created the test environment for Staging area, loading the Staging area with data from multiple sources.

Extraction of test data from tables and loading of data into oracle tables using SQL

Prepared PTA (Prod Testing Acceptance) and sign-off.

Discussed doubts / queries with Development Team / Client.

Logged the defects in defect tracking tool / bug report.

Technologies Used: Toad, Tectia, Quality Center 11.0, SVN& Jira

Methodology: Agile Methodology (FDD & TDD)

Credit Suisse (MIDI-MKURS), Pune, India Mar’2012 - Oct’2012

Associate / Test Analyst (Automation) Cum Business Analyst

MIDI stands for ‘Market Information & Distribution Infrastructure’. MIDI consumes the MDF stream (at the moment real-time only) from SIX Financial Information (SFI) provider. MIDI is made up of three components: MQA, ITFH (Feed Handler) & ITOD (Object Distributor) and it functions as an interface between Market Information and Application Host.

The WFO (Web Sphere Front Office) component processes the feed and puts the data into internal cache of MIDI. The object distributor components are responsible for passing the data to the MQ Adaptors (MQA). The MQAs are CS specific components for accessing data from the MIDI cache. There is one MQA for streaming requests and one MQA for snapshot requests. Access to the MQAs happens over Request-and Reply-Queues. Over the Streaming MQA a conflated stream is sent out.

The snapshot interface will be used by the YYMAKU program in order to retrieve price data from MIDI on request and streaming interface use by the VK71...88 price processing programs in order to update the P6C database accordingly.

Responsibilities:

Carrying out detailed study of the change request and requirement specification document

Handling scenario identification and writing test cases for critical enhancements.

Managing new requirements from the project

Involved in preparation of effort estimation and sharing the same with client.

Determining tasks to all testing team members and conducting meetings with them.

Participating in daily stand-up and weekly call to discuss status and progress with the client

Review various reports prepared (Audit Purpose) by test engineers.

Performing smoke testing before demo to client and executing regression suite

Identifying and debugging all the defects related to the project

Developing PTA (Prod Testing acceptance) test summary repost and providing sign-off on all testing deliverables

Logged & tracked all the defects related to the project

Technologies Used:Toad, Tectia, Quality Center 11.0& Jira

Methodology: V-V Model

Strate (Electronic Clearance & Settlement) Jo'burg, South Africa Jun’2010 – Nov’2011

Test Analyst (Automation)

Strate is the authorized Central Securities Depository (CSD) for the electronic settlement of all financial instruments in South Africa. Currently Strate handles the settlement of equities, warrants and bonds for the South African stock Exchange (JSE Ltd). Strate project deal with capital market (Swift messages-Remat, Demat, On-market, Off-market). Involve with Functional Testing, UAT (User Acceptance Testing), SIT (system Integration testing), Usability Testing and Compatibly Testing.

Responsibilities:

Involved in (As Business Analyst):

Define, plan, coordinate and obtain information requirements to support and module releases.

Coordinate with multiple resources efficiently and effectively throughout the development lifecycle so as to ensure that the projects are completed on time, meet requirements, are implemented accurately and the full impact is understood by the business owner

Interface with internal business users as well as various IT development groups so the needs can be clearly understood, expectations managed and change initiated.

Act as the point of contact between the business units and IT.

Perform analysis for business applications.

Use systematic techniques for specifying requirements - like use-case scenarios, process modeling and data-flow diagramming.

Involved in Designing documents like-Project Version Document, Use Case, Business Requirement Document, Requirement traceability matrix (RTM), Functional requirement specification (FRS)/ Functional Specification Document (FSD).

Involved in (As Test analyst):

Executed detail study of the BRD (Build Requirement Document).

Created test plan which involve creating test cases using Quality Center for different testing like Sanity, System, Integration Testing and Regression Testing.

Worked on Data Table (Data Driven), Object Repository, Expert and Keyword View Framework

Enhanced scripts by adding various checkpoints such as text area, standard, bitmap, table, and database checkpoints using QTP.

Involved in Creation of Automated Scripts, executed the same and analyzed the results in QTP

Responsible for Recovery Scenario Management through QTP

Involved in preparing effective documentation which is the driving force for the forth coming releases and is used by the Business team

Involved in programming with VB script to write reusable functions, and setting up the startup files for loading the libraries and configuration in QTP.

Reviewed designed test cases and executed the test cases with QTP (Automation Tool) & manually

Defects are tracked until it goes to a closed state.

Technologies Used: QTP, Toad, Quality Center 11.0, WinScp

Methodology: Waterfall Model

Cisco (CCW-Cisco Commerce Workspace), Pune, India Jun’2010 – Sep’2010

Test Engineer (Automation)

Cisco is completely involved with different Products & services like Hardware configuration, Network and system configuration, Online Ordering products and testing suite of services include Functional Testing, UAT (User Acceptance Testing), SIT (system Integration testing), Usability Testing and Compatibly Testing.

Responsibilities:

Involved in creating test cases using Quality Center for different testing like Sanity, System, Regression testing.

Test Case Execution using Quality Center.

Developed traceability matrix to ensure all the requirements are covered for testing.

Involved in Cross Browser Testing on IE, Firefox and Safari

Involved in Testing Web Services using SOAP UI.

End to End Testing

Involved in executing SQL queries to verify database was updated.

Detected defects and track defects using bug tracking tool Quality Center

Technologies Used: SoupUI (Web Service testing), Toad, Quality Center 10.0

Methodology: Waterfall Model

HSBC Bank (ADA-American Disability Act), Pune, India Feb’2010 - Jun’2010

Test Engineer

HSBC Credit Card Services Internet Website has been developed for the card services business Unit of a leading North American bank to cater the customer requirements for online access of their credit card accounts. SIT (system Integration testing) & UAT (User Acceptance testing) Phase of all projects involve end to end functional testing & validation of all enhancements Including marketing content validation, compliance validation & regression testing. This project mainly deals with reading out all the content and services that are provided by the site to the End users. We are using a third party tool JAWS to read the content.

Responsibilities:

Details study of the BRD (Build Requirement Document) document.

Involvement in scenario identification & test case writing for critical enhancements.

Cross Browser Testing on IE, Firefox and safari.

Review Test cases, executing the test cases.

Logging & tracking of all the defects related to the project.

Technologies Used: Integration Testing, Web testing, Quality Center

Methodology: Waterfall Model

Best Health Care, New Jersey, USA

Test Engineer July’08 – Dec’09

A service provider can be an individual or an agency. Service provider is a person who is interested to provide his services to a service seeker. A service provider may provide details related to the services he may offer. He can also fill in his availability details .The hourly rates he may charge. If this is an agency or franchisor, we want the company to be able to have their company appear in multiple zip code queries for a fee.

A service seeker can be a patient or a person (seeker) Service seeker is a person who is interested to hire a service provider for seeking his services. A service seeker may describe his requirements and thereby start searching for suitable service provider. A service seeker can also be an agency/organization that posts jobs and helps or even select providers for patients and their families.

An investor admin is a user who will be able to access all the reports related to no. of users registered on site, all the payment transaction reports, etc. He can also activate and deactivate user’s accounts.

Advertisers have to register on site in order to post their advertisements. They will be able to upload banners of specific sizes; they can associate the banners to different categories. Also they can provide links on those banners which will redirect users to the specific URLs

Technologies: Window XP, Quality Center 8.0

Methodology: Waterfall

Contact this candidate