Background Summary

. Extensive IT experience in Software Analysis, Business (System)

Analysis (BA/BSA), Quality Assurance (QA) Testing using Manual &

Automation of multi-tiered and integrated systems of large scale

enterprises.

. Excellent understanding & Experience in all phases of Software

Development Life Cycle (SDLC), Software Testing Life Cycle (STLC),

Data Warehouse Life Cycle (DWLC), Software Quality Assurance

Techniques (SQAT), QA Testing Strategies / Methodologies and

Defect/BUG Life Cycle.

. Good at understanding & preparing the Business Requirement Document

(BRD), Functional Specifications Document/System Requirement

Specifications (FSD/SRS), Technical Specifications Document (TSD),

Test Plan Document (TPD) and Test Case Document (TCD).

. Extensive experience in various SDLC Methodologies such as Rational

Unified Process (RUP), AGILE, SCRUM, V, Spiral, Iterative Increment,

Extreme Programming, and Waterfall.

. Experience in creating artifacts on various stages of SDLC using

Unified Modeling Language (UML) writing Use Cases, creating data flows

and activity diagrams.

. Good Experience in Test Cases Management tool for Defect/Bug tracking,

reporting, reviewing & analyzing test results using HP Quality Center

(QC) formerly Test Director (TD), Prepared and Reviewed business

requirements, executed Test Plans, Test Cases and Test Results.

. Strong exposure in DBMS & RDBMS Concepts, Data Mapping, and SQL

queries. Familiarity with Data Warehouse (DW) concepts and schemas &

Business Intelligence (BI) concepts & reports.

. Experience in mapping business processes using MS Visio for performing

AS-IS and generating TO-BE processes utilizing GAP Analysis.

. Extensive experience in using IBM Rational Clear Quest (CQ), Mozilla

Bugzilla & tested several products through complete lifecycles and

multiple releases.

. Proficient in Black Box Testing (Functional Testing), White Box

Testing (Unit Testing, Integration Testing), Smoke Testing, Grey

Box/System & Regression Testing, & User Acceptance Testing (UAT).

. Experience in QA Manual testing process and Familiarity in QA

Automation environment using HP Quick Test Professional (QTP), Load

runner, Win runner, ALM, TFS.

. Strong Experience in QA Process Management, Test

Strategies/Methodologies (Verification & Validation), Test Plans, Test

Cases, Bug/Defect Reports, Test Scripts, Traceability Matrices & Test

Scenario/Environments.

. Experience in Reviewing/Reporting, Tracking, & Maintaining Defects

with high level of detail, accuracy and informative recreation steps.

. Professional experience & Good domain knowledge of Healthcare,

Insurance, Financial, Banking, Telecom, Retail, Mortgage, Pharmacy

industries.

. Experience in Health Insurance Portability and Accountability Act

(HIPAA) Regulations, Electronic Data Interchange rule (EDI)

Transaction Codes as Benefit Enrollment 834, Health Care Claim 837,

International Classification of Diseases (ICD 9/10), Health Level 7

(HL7) standards & understanding of Healthcare Professional Maintenance

Organization (HMO) & Preferred Provider Organization (PPO) insurance

policies.

. Excellent Analytical, Problem Solving & Learning skills and Strong

Communication, Documentation and Interpersonal skills in diverse team

environments.

Tools and Technologies:

Methodologies & SDLC RUP, Waterfall, AGILE+SCRUM, Spiral, RAD, V, Iterative,

Standards Prototype, Extreme Programming, ISO 9001/9000, SEI-CMM, Six

Sigma, Data Modeling

Operating System Windows XP, 2000, 8, 7, Vista., HP Unix, Apple Mac

QA Automation HP Quick Test Professional (QTP) 12.0/11.0/10.0/9.5, HP

Testing Tools Quality Center (QC) 11.0/10.0/9.5/9.2, IBM Clear Quest (CQ)

8.2/8.0/7.1, Mozilla Bugzilla, MS Team Foundation Server

(TFS) 2013/2012/2010

Requirement IBM Rational Rose 7.0, IBM Rational Requisite Pro 7.0,

Management Tools Rational DOORS, UML 2.0

Database (RDBMS) MS SQL Server 2012/2008R2/2008/2005, Oracle 11g/10g/9i, MS

Access

Database MS SQL, TSQL, Oracle SQL, PL/SQL, mySQL

Languages

DW Methodologies Ralph Kimball's Dimensional Modeling, STAR, Galaxy, &

SNOWFLAKE Schema's, OLTP, OLAP

Workflow/Web, MS Office 2013/2010/2007 (Word, Excel, PowerPoint, VISIO),

Tracking tools MS Visual Source Safe 6.0 (VSS)

Programming, Java, VBScript, ASP.Net, C#.Net, HTML, DHTML, XML

Scripting &

Markup Languages

Professional Experience

PRONTOH.COM - Online Health Care Provider Appointment Portal

Apr'14-Till Date

Business Analyst & QA Analyst, Vensoft, Phoenix, AZ

PRONTOH.COM is a medical care scheduling service, designed to be

efficiently used by primary & specialty care clinics, patients to manage

access to service providers, hospitals to schedule elective surgeries. It

is also aimed at improving access to healthcare. Subscribers can gain

access to the scheduling system & find doctors, as both online service and

via deployed office calendar or integrated with their websites. Patients

can access the website at no cost and can see the schedule of subscribers -

doctors.

Responsibilities:

. Actively Engaged in Requirement gathering with the Business Users

to understand & collect the Business Requirements, & documented

them for review.

. Performed doing Thorough Analysis and gathered & verified

requirements and prepared Business Requirement Document (BRD),

Functional Specification Document (FSD)/System Requirement

Specifications (SRS) and Use Case Document (UCD).

. Performed multiple Joint Application Development/Design (JAD)

sessions, conducted interviews and Q&A sessions with business users

to solicit business requirements relative to proposed functionality

and partnered with the business stakeholders, process owners, and

users to identify their requirements, produced detailed

specifications, planned the project deliverables with the Software

development team, defined QA plan, & conducted User Acceptance

Testing.

. Wrote moderately Complex SQL queries to perform Data analysis and

validation & Backend testing of the application.

. Drafted Test Scripts, Test Cases, User Acceptance Testing (UAT) and

System Integration Testing (SIT), recorded and tracked the Bugs with

Quality Center.

. Prepared Process flow diagrams using MS Visio and conducted meetings

with all the division supervisors to ensure that all the requirements

are met and implemented the approved suggestions and modified the

current process flows.

. Supported for the developers to perform various Data Modeling, Data

Validation, and Data Mapping and reviewed proposed changes to

documents to ensure complete traceability, timeliness and accuracy.

. Participated with QA team to write and validate various Test Plans,

Test Cases based on the Test Scenario, ensuring that the project

met the desired requirement.

. Utilized Quality Center (QC) for uploading discovered defects and

conducted User Acceptance Testing (UAT) with business users and

Scrum Master.

Environment: MS Office 2013, MS Word, MS Excel, MS Power Point, MS Visio,

AGILE, Scrum, UML, IBM Rational Requisite Pro 7.0, IBM Rational Rose 7.0,

MS Visual Source Safe 6.0 (VSS), MS SQL Server 2012, SQL, TSQL, SSMS, HTML,

MS Team Foundation Server 2012, HP Quality Center 11.0 (QC), MS Windows

Project Resource Management Toolset (PRMT)

May'13 - Feb'14

Business Analyst, Equity Bank, Atlanta, GA

Equity Bank is a full-service community bank that offers a full range of

Financial Solutions, including Commercial loans, Consumer banking, Mortgage

loans, & Treasury management services. The purpose of this project is to

capture portfolio information which can be manipulated & viewed by Upper

Level Management. The System will pull information from the other elements

of Project Resource Management Toolset (PRMT).

Responsibilities:

. Utilized Software Development Life Cycle (SDLC) Waterfall

methodology for project resource management toolset.

. Created and Reviewed the Business Requirements Document (BRD)

including Use Cases.

. Conducted Joint Application Development (JAD) sessions to define

technology applications for business requirements and assisted in

development of training materials for new technology and process

improvements.

. Determined operational objectives by studying business functions;

gathered information; evaluated output requirements and formats.

. Assisted in development of Test Plans and QA team in System testing

to ensure the new system satisfies all User requirements.

. Involved closely with various businesses, Stakeholders for the

specification and verification of multiple levels of requirements

and supported the ongoing management of the requirements.

. Involved in Analyzing requirements during the requirements analysis

phase of projects and tracked the new requirements and defects

using Quality Center.

. Attended conference calls with onsite coordinators to understand

the team activities with the delivery dates & client requirement

and ensured the client confidence.

Environment: MS Office 2010, MS Visio, MS Windows, SDLC Waterfall, UML 2.0,

IBM Rational Requisite Pro 7.0, HP Quality Center 11.0 (QC), MS SQL Server

2012, SQL

Insurance Benefits System (IBS)

Jul'12 - Mar'13

Business Analyst & QA Engineer, GLI, Bethlehem, PA

Guardian Life Insurance provides a variety of insurance products as Life

insurance, Retirement services, Disability income insurance, Investments, &

Employee benefits. This application provides easy access to get quotes

online for the desired type of insurance for the customers intended to

apply for insurance.

Responsibilities:

. Participated in requirement gathering sessions with Stakeholders &

Business Owners to understand and incorporate the potential

requirements in Business Requirement Document (BRD) & Functional

Specification Document (FSD).

. Conducted multiple JAD sessions & other group discussions with the

business users, attended project meetings & QA status meetings &

updated status to the QA Manager when needed.

. Involved in preparing Test Plan, Test Case, Test Scenario and

Generated reports to show the test status of the Test Scripts.

. Participated in the daily meetings to walk through the defect

reports periodically.

. Performed initial Smoke Testing to determine if the product was

stable enough to withstand a major testing effort; performed

Functional testing manually and the defects have been raised &

resolved for the application using Quality Center.

. Generated various Database Objects as Table, View, Sequence,

Indexes, Synonyms, Constraints and various types of Integrity such

as Domain, Entity, Referential and Validity.

. Performed Black Box Manual Functionality Testing, Integration

Testing, System Testing, of specific Non-Functional and Functional

test cases, as needed.

. Interacted with developers & stakeholders to follow up on

defects/issues, documented testing results and engaged with project

team members to clearly define & document the policies, procedures

for projects.

. Accessed logs generated by the server & attached the error logs in

the defects in order to help developers in their analysis.

Scheduled, interacted, invoked & tracked the Test Cases & Defects

in Quality Center (QC).

. Conducted software & application training to the users & new

members in the team by preparing and assisting them with any

technical or non technical issues & test data for various modules.

Environment: MS Office 2010, MS Windows, SDLC Waterfall/RUP, HP Quality

Center 9.2, MS Visio 2010, IBM Rational Requisite Pro 7.0, UML 2.0

Mobile Billing Management System (MBMS) Apr'11-May'12

Business Analyst, Sprint PCS, Hutchinson, KSA

Sprint's web application helps their customers to view bills, pay bills,

check payments, electronic bill enrollment, and generating consolidated

bills, sort bills and print the bills in PDF format. The Online Customer

Mobile Billing Quality Assurance Team provides operational support ensuring

the accuracy of selected bills for mobile customers.

Responsibilities:

. Involved with the SDLC AGILE software project during all the stages to

establish plans, standards, and procedures.

. Involved within the SCRUM team to define the scope of testing for each

SPRINT and attended all SCRUM observances including daily SCRUM stand-

ups, and planning meetings.

. Involved in gathering information and preparing various documents as

Business Requirements Documents & Functional Specification Documents.

. Conducted multiple Joint Application Design/Document (JAD) sessions

with business users to meet business requirement.

. Documented all problems and worked to resolve them. Reported progress

on problem resolution to project management and conducted Verification

& Validation of software defects.

. Involved & communicated with Business Owners to prepare Project

Charter, Project Scope Document, High level work plan activities,

Development, Tracking of Project Management processes and deliverables

(e.g., detailed task lists, project schedule, status reporting,

ongoing monitoring and reporting).

. Provided ongoing status updates to the Project Manager and Sponsor;

endorsed issue resolutions as appropriate, and ongoing support

throughout the life cycle of the project.

. Produced and Tested SQL Queries as Aggregate Functions (MAX, MIN, AVG,

SUM, COUNT), Operators and Conditions as LIKE, IN/NOT IN, BETWEEN,

EXISTS, NOT, AND, OR and Comparison.

. Assisted the Testing team in creating Test Plans, Test Scenarios, Test

Cases and collected Test Data for successful completion of Integration

Testing and Functional Testing.

. Conducted User Acceptance Testing (UAT) with business users and

Project Manager.

. Implemented pre-determined improvements to current procedures and

reports on success of changes.

. Guided team that created Test documentation and supported the QA

Testing efforts by escalating defects, and ensured bug fixes and

smooth implementation of the solution.

Environment: MS Office 2010, MS Windows, JAD, SDLC AGILE+SCRUM, UML 2.0, HP

Quality Center 11.0 (QC), MS SQL Server 2008R2, SSMS, SQL

Global Mobile Communication System (GMCS)

Jan'10-Feb'11

QA Tester, Ncell PL, Kathmandu, Nepal

Ncell is a privately owned Global System for Mobile Communication mobile

operator in Nepal. It is the first private company to operate GSM services

in telecommunications sector. The network for Ncell is structured as base

station subsystem, network and switching subsystem, GPRS core network,

Operation Software System (OSS). It is gradually expanding its network

coverage in various urban, semi-urban & rural areas of the country. In many

places, Ncell has been providing services to the subscribers by installing

& using satellite equipments & network. Ncell has always planned & adopted

new technologies & services available in the international market &

provided them among its subscribers.

Responsibilities:

. Involved in creating Test Plan with the support of QA Test Lead,

and prepared Test Case Documents (TCD) for Project Modules Cases

based on the system & business requirements and transitioned

software development efforts to a Test-Driven Development (TDD)

process.

. Converted the user requirements in to functional requirements for

Integration, System, User Acceptance testing and prepared in Manual

Test Scripts.

. Prepared Test Status Report on weekly demand during planning and

execution to summarize progress and results and Prepared Test

Summary Report at the end of testing phase with results of

readiness of system deployment of production.

. Conducted formal & informal product design reviews throughout the

Software Development Life Cycle (SDLC) to provide input on

Functional Requirements, product designs, schedules & potential

issues.

. Documented Software defects and reported them with program

functionality, output, online screen and content to software

developers.

Environment: MS Office 2007, MS Windows

Banking & Financial Service System (BFSS)

Aug'09-Dec'09

QA Test Engineer, SCBNL, Kathmandu, Nepal

Standard Chartered Bank is a banking and financial services company in

Nepal and a wholly owned subsidiary of Standard Chartered. It is a

universal bank with operations in consumer, corporate and institutional

banking, and treasury services.

Responsibilities:

. Engaged in understanding the SCBNL Application study and physical

environment setup and QA Manual Testing processes & responsibilities.

. Participated in attending multiple information sessions with SMEs to

understand Business Requirements.

. Created QA documentation & reports using a variety of diagnostic tools

& participated with development teams to investigate & correct

software bugs & deficiencies based on testing results.

. Performed Backend Database testing manually & managed all the phases

of testing for assigned components ensuring Test Plans & Test Cases

are completed to meet the business requirements.

. Conducted project reviews, presentations in time to time basis &

reported to the project coordinator & interacted with the development

teams to understand system requirements.

. Coordinated with product development teams to recommend solutions to

maximize performance & efficiency. Analyzed software failures,

reported issues to Bugzilla & performed Bug Verification testing to

ensure that every phase and features of the software solutions are

tested and that any potential issues are identified and fixed before

the product goes live.

. Engaged in regular project team meetings to discuss about testing

process, business requirements, and assignments & communicated with QA

team members & Developers to resolve testing issues.

. Tested software applications for Reliability & Stability to improve

the product performance.

Environment: MS Office 2007, MS Word, MS Excel, MS PowerPoint, MS Visio,

Oracle 9i SQL, Bugzilla

Professional Certifications & Training:

. IIBA Business & AGILE System Analyst

. Dimension Modeling (STAR & Snowflake) & RDBMS, QA & ETL DW Testing by

VENSOFT Inc

. Implementing Essentials of ETL Data Warehouse, OLTP, OLAP Concepts by

NETG

Education

Bachelors of Business Management

Contact this candidate