Business Analyst/Quality Analyst

Anjana Jose

Business Analyst

*********@*****.***

Visa status: Green Card

Summary of Qualifications

Eight years of IT experience working as a Business Analyst and Quality Analyst

in Travel, Political Affairs and communications, Retail, Automobile domains.

>Public Affairs and communications domain expertise includes integration of

PAC websites for political funds disbursement and Mobilizations.

>Travel domain expertise includes Online booking of flights and hotels,

Finance components like Chargeback, Payments, Fraud Management tools and Back

office systems.

>Online stores domain knowledge includes online sales of HP products.

>Automobile domain experience covers handling of Material Procurement module

for Toyota Motors and Integration of various modules.

>School Administration domain knowledge covers management of student databases

in various counties across US.

>Emergency domain experience includes working on mission critical application

catering to the Emergency Service (911).

>Online Retail domain experience

Experience in writing Test Cases using Test Director and development of Test

Plans.

Strong experience in SDLC methodology and Defect Life Cycle.

Experience in SQL query for data analysis and reporting.

Extensive experience in testing software including Regression Testing,

Functional Testing, Smoke Testing, Integration Testing and User Acceptance

Testing.

Experience working in Agile and Waterfall software development environment

Experience in using TOAD for SQL

Experience in using MS Visio for creating UML diagrams

Experience performing User Acceptance testing and user training

Experience in using defect tracking tools like Test Director and Bugzilla

Experience using VersionOne Agile project management tool.

Skills/Technologies

Languages- SQL, XML

Databases- MS SQL server, Oracle

Tools- TOAD, HP Quality Center, Microsoft Office Suite, MS Visio, MS

Project,VersionOne, SharePoint, QTP, Crystal Report, Bugzilla, Squirrel,

Agile, Jira

EXPERIENCE:

DECEMBER 2012 TO JANUARY PETCARERX, NYC,

2014 NEW YORK

BUSINESS ANALYST

Project: LPPE (Leading Personalized Pet Experience)

Environment/Technology: JAVA J2EE, XML and SQL Server

Goal of this project was to build a new website introducing enhanced

experience for customers to purchase online pet products.

Role/Responsibilities:

. Performed Requirements gathering and Testing Activities of petcarerx

website and mobile sites

. Performed User Acceptance testing

. Co-ordinated extensively with business and development teams

. Maintained defects on SmartQ and Jira

. Maintained Requirement and test documents on Google drive

. Developed functional specifications

. Tested front end, Attribute management and content management tools

. Performed mobile testing on ios6

. Co-ordinated with external vendor for mobile testing activities

. Reviewed wireframes with design teams

NOVEMBER 2011 TO ABC CONSULTING -

FEBRUARY 2012 CONTRACT ROLE

BUSINESS ANALYST

Project: Pfizer, NYC

PAC (Political Action Committee) Pfizer Grassroots Integration Project

Client: Pfizer (Internal project)

Environment/Technology: HTML, XML, Content Management tools

Goal of this project is to integrate two existing websites (PAC and

Grassroots) residing on two disparate systems into one user friendly

integrated website to be accessed by Pfizer through Internet. PAC is a

voluntary organization where colleagues can contribute towards

Congress and Election campaigns. PG enables colleagues to contact

Legislators to encourage them to take action on political affairs

affecting Pfizer.

Role/Responsibilities:

. Coordinated with vendor to ensure timely sign off on Requirements and

Testing activities.

. Coordinated with Compliance teams and Testing teams for System testing

and User testing activities

. Performed Gap Analysis between existing and future sites.

. Developed Administrative test cases for Democracy Direct vendor tool

for Business teams to execute.

. Worked extensively with External Affairs and Political communications

teams on Business side to understand the legal implications of the

project and Content Development for the website.

. Worked extensively on Pfizer PAC contribution and Pfizer Grassroots

Mobilization Alerts functionalities and Logo branding for the project

. Coordinated with vendors and third party consultants for development

and testing activities

. Prepared Test Cases and Test Plan for Functional and User Testing

. Developed Traceability Matrix for the Project Release and Use Cases.

. Maintained project documentation on Share Point.

. Used Microsoft Visio to create Process flows

. Developed and maintained Business Requirements document(BRD) and Use

Cases

. Worked on website Content Management tools and prepared Test Cases

June 2007 to Sabre Holdings, Bangalore, India

July 2011

Sr. Business Systems Applications/

Quality Analyst

Project: Global Chargeback Project

Client: Travelocity (Internal project - Travelocity is a Sabre brand)

Environment/Technology: JAVA J2EE and SQL Server

Goal of this project was to develop a global Chargeback management

system in order to improve chargeback dispute process in Travelocity,

which also replaced the existing Chargeback processes in North

America, Europe and Asia.

Role/Responsibilities:

. Acted as primary liaison between functional business units and

technical teams throughout project life cycle

. Developed and maintained low level merchant mapping data for

Chargebacks coming from various credit card companies

. Documented existing Chargeback processes in North America, Asia and

Europe regions and developed Functional specific requirements(FRD) for

Global Chargeback tool which could be accessed by all regions alike

. Conducted extensive study on Travelocity merchant, accounts and

processor relationships for every locale

. Conducted extensive study on Chargeback data coming from various banks

into Travelocity systems which included customer sensitive data

. Executed SQL queries on TOAD/Squirrel and generated periodic reports

to Reporting teams

. Worked on bank interfaces(eg: First Data) for data export

. Gathered Business and Functional Requirements and converted them into

Use Cases, Flowcharts and other Requirements Documents (technical

specification docs).

. Prepared Test Cases, Test Plans and UAT Test scripts

. Worked on Chargeback data mapping between Merchant accounts and bank

accounts, issues and products, Chargeback reports from various banks

. Effectively used bug tracking tool Bugzilla for maintenance of bugs on

Release and product basis.

Project: Global Finance Fraud Prevention and Revenue Protection

Project

Client: Travelocity (Internal project - Travelocity is a Sabre holding

company)

Environment/Technology: JAVA J2EE, XML and SQL Server

Key goal was to implement a more stabilized fraud system to reduce

fraud losses and refine risk assessment methods and use this financial

service across various other teams within and outside the

organization.

Role/Responsibilities:

. Acted as primary liaison between functional business units and

technical teams throughout project life cycle and performed Testing

activities for the project

. Gathered Business and Functional Requirements and developed Flowcharts

and Functional Requirements Documents.

. Executed queries on TOAD/Squirrel and generated periodic reports to

Reporting teams

. Maintained project documentation on SharePoint.

. Conducted extensive study on Fraud data coming from various

Travelocity systems which included customer sensitive data

. Worked on Fraud risk assessment tools like Vincio which is an external

product used by Travelocity

. Worked on Credit Card banking system

. Developed detailed documentation of Travelocity Fraud tool

architecture and various third party systems and web services it

interacts with.

. Communicated with Fraud agents who are the real time users of the tool

at Travelocity call centre who understand the way the system is used

. Performed Manual Functional and Regression testing for various

Releases

Project: Lastminute Order Service Project

Client: Lastminute (Internal Finance project - Lastminute.com is a

Travelocity key brand)

Environment/Technology: JAVA J2EE, XML and SQL Server

This is a back office application that interfaced online booking

related information in the form of XML from User Interface into

Lastminute.com's financial tool SAP using ETL before reaching Data

warehouse.

Role/Responsibilities:

. Gathered Business Requirements and converted them into Mockups,

Flowcharts and Functional Requirements Documents.

. Conducted interviews with key business users to collect requirement

and business process information

. Worked with Lastminute MidOffice tool Winona which is a risk analysis

tool for the live bookings made on lastminute site

. Extensive usage of UPL and MCDB booking databases and data process in

the form of XML

. Responsible for data interface into financial system SAP for

Lastminute bookings

. Developed Manual Test Cases for Functional and Regression testing and

test data

. Developed End to End Test suites on Test Director using templates and

other effective features enabling reuse of cases for all future

Releases.

. Involved in testing the application using data in the form of XML

. Validated outgoing XML messages from Order Service

. Authored detailed Test Plan and Test Scenarios/Cases based on

technical specifications and business requirements for various phases

of testing.

. Effectively used bug tracking tool Bugzilla for maintenance of bugs

during Release Testing

. Performed extensive Database testing using SQL

Project: Travelocity Vpayment Service Project

Client: Travelocity (Internal Travelocity Finance project)

Environment/Technology: JAVA J2EE and SQL Server

This project dealt with developing a back end application which could

be used by Travelocity to pay suppliers.

Role/Responsibilities:

. Acted as primary liaison between functional business units and

technical teams throughout project life cycle and prepared Business

Requirements document.

. Utilized tools such as MS Visio for data flow diagrams, process models

and data models

. Created User stories for each Iteration of Project Development cycle

and reviewed the same on version tool on a daily basis.

. Validated XML files

. Worked extensively on Finance Reconciliation data from Amex to SAP

. Prepared Requirements Traceability Matrix

. Prepared Functional Test Cases for multiple Releases

. Maintained data mapping and Reconciliation of supplier data and

payments

. Performed Regression Testing and Live Production Testing

Project: Travelocity Total Trip Project

Client: Travelocity (Sabre brand - Travelocity.com)

Environment/Technology: JAVA J2EE and SQL Server

This project provided customer a complete travel experience online via

Travelocity site which is used to book online reservations for travel

which includes flight, hotel, car hire etc. It included various

enhancements for customer satisfaction.

Role/Responsibilities:

. Performed End to End testing activities

. Worked on Shopping path, Universal Checkout, Customer Care tools of

Travelocity.com(888) and various lines of businesses like flights,

hotels and other cross selling products on the site

. Prepared Manual test scripts and participated in Test Review sessions

. Involved in Regression testing during various Release cycles of pre

and post production phases

. Executed queries on TOAD and generated periodic reports to Reporting

teams

. Maintained project documentation on Twiki which is an internal Sabre

tool.

. Prepared use cases for various front end interfaces

. Obtained training on QTP and developed QTP scripts for few

enhancements

. Developed End to End Test suites on Test Director using templates and

other effective features enabling reuse of cases for all future

Releases.

. Authored detailed Test Plan and Test Scenarios/Cases based on

technical specifications and business requirements for various phases

of testing.

. Effectively used bug tracking tool Bugzilla for maintenance of bugs

. Designed and implemented basic SQL queries for testing and report /

data validation.

June 2004 to May 2007 Hewlett Packard, Bangalore, India

Software Testing Engineer

Project: MATS (Material Management System)

Client: TMT (Toyota Motor Thailand)

Environment/Technology: J2EE/Websphere 5.1/Solaris/MQ Series/Oracle

MATS was part of project suite designed and developed by HP for the

entire automation of material management, inventory, costing and

supplier management of Toyota, Thailand.

Role/Responsibilities:

1. Participated in project Integration and User Testing at onsite client

location for two major releases

2. Worked on Requirements documentation

3. Developed Test cases and Test Plans

4. Supported post production testing activities

5. Extensively used TOAD for sql

6. Logged and tracked bugs and generated reports on Test Director

7. Acted as SPOC(single point of contact) for Procurement data testing

8. Performed Regression and Functional testing activities

9. Worked with project managers to accomplish timely releases

10. Worked in conjunction with the development team to retrieve and

analyze data using SQL

11. Responsible for tracking and executing test scenarios

Project: Online Store - EMEA

Client: HP Internal client, HP USA

Environment/Technology: .NET

EMEA Smart Choice application was a solution to provide HP Partners an

online Store comprising Store Front, Admin Tool and Call Center

website applications.

Role/Responsibilities:

12. Performed Regression and Functional testing for all Releases

13. Designed and developed test cases in Test Director

14. Logged and tracked bugs in Test Director, generated reports on TD

15. Updated requirements and defect status as per the current status of

the project in Test Director

16. Maintained document versioning in MS VSS(visual source safe)

17. Participated in Go Live activities

18. Worked on Admin tools where administrator roles can make necessary

modifications to the website content and on front end interfaces

19. Assisted and coordinated with teams in making changes to different

website environments for timely production implementations.

June 2003 to May 2004 Lionbridge, Mumbai, India

Trainee

Project: SASI (School Administration and Student Information

System)

Client: Pearson Development Centre, USA

Environment/Technology: VC++ and SQL Server 2000

SASI is a revolutionary software system that manages extensive student

information at both the school and district levels in the US. It also

handles publication of elearning course materials.

Role/Responsibilities:

20. Preparation of test cases for System Testing, Smoke Testing,

Regression Testing and Acceptance Testing

21. Performed testing on Operating Systems Windows and Macintosh

22. Handled School Databases for more than 10 schools in the US

23. Executed Release Regression Testing and update Test Director with new

enhancements cases

24. Tracked defects in Test Director

25. Worked on defect management based on Defect life cycle

26. Worked as a technical writer for e-learning course materials for

SASI's publishing domain.

27. Generated and presented reports to the leads/managers on test status

using Test Director

28. Developed and maintained test data in MS EXCEL to validate output data

Education and Certifications

? Bachelor of Engineering (BE) in Electronics and Communications from

Bharathiar University, Tamil Nadu, India

? Certified Software Testing Engineer (CSTE) from QAI, USA

? Certified Software Tester from Travelocity, USA

Contact this candidate