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