Test Cases Microsoft Office

S SHARMA **************@*****.***

Business Analyst

●Five (5+) years of experience in Business Analysis, Data Analysis & Functional/Automation testing in Finance and Retail Industry software applications.

●In depth knowledge of the Software Development Life Cycle with complete understanding of business process, defining vision documents, interacting with stakeholders, understanding user requirements to articulate into User Requirement Specifications.

●Experienced with all phases of software development including requirements gathering and documentation, writing SRS, Gap analysis, UML diagrams, user acceptance testing

●Proficient in conducting JAD sessions, writing use stories, capturing use cases and deriving requirements.

●Proficiency in analyzing and Creating Use cases, Use Case Diagrams, Activity diagrams, Class diagrams, Data Flow Diagrams, Business Flow Diagrams and Navigational flow diagram and Sequence diagrams using MS Visio

●Expertise in MS Office Suite, MS Project for Project Plan, MS Visio, JIRA, and HP Quality Center.

●Fully involved in Requirement Analysis, Test Scenarios from Requirements and Use Cases, Test Planning, Test data Preparation, Test Case Execution, Defect Reporting and Documentation

●Extensively interacted with the QA Team in creation of the Test Plans, Providing Test Data, Creating Test Cases, and Issuing SRS upon detection of bugs and collecting the Test Metrics.

●Good knowledge of various RDBMS like Oracle/PL-SQL and MS SQL Server.

●Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income, Foreign Exchange, Derivative & Back-Office operations.

●Thorough knowledge in Requirement analysis, Planning, Scheduling & Tracking projects.

●Completed QA training to get better understanding about automation tools like QTP, Selenium, Quality Center and SOAP UI

●Experience in testing of Web based and Client based applications.

●Extensive experience in conducting different kinds of tests such as Integration, Regression, Functional, System Testing and UAT.

●Working knowledge of designing & implementation of all QA test strategy plans manually and automated test solutions for client/server, API and Web applications.

●Used process models like Linear Sequential Model (Waterfall), and AGILE methodologies.

●Experienced in logging defects using the bug tracking database, providing verifications on fixes in multiple environments, and communicating fix success, failures, status updates as appropriate using Bug tracking Tool like Quality Center, JIRA

●Experienced in writing SQL verification scripts to test the result of deployment for correct business logic for Backend testing.

●Proven ability to support multiple projects, under tight deadlines, often with competing priorities and complexities.

●Strong analytical skills with ability to quickly understand client’s business needs.

●Excellent Documentation and communication skills, willingness to learn the latest cutting edge technologies.

●Ability to work independently in time sensitive environment and be fully responsible for work results.

Technical Skills

Operating Systems : Windows Server 2000, Windows Server 2012, Windows XP, Win 7, Win 8

Database : Oracle 11g, MS SQL Server 2012/2014

Testing Tool : QTP, SQL Developer

Languages : VB Script, SQL

Defect tracking tools : JIRA, HP QC

Web Application Platform : .Net with C#, Visual Basic, Classic ASP

Other Tools : MS Office, Visio

Methodology : Waterfall, Agile (Scrum)

Web Technologies : XML HTML

Education:

Bachelor of Business Administration in Finance, Post-Graduation Diploma in Management

Professional Experience

Objects On Net, (USA, GA)

Project : Delivery System

Duration : Oct 2016 – till date

Role : Business Analyst

Responsibilities:

●Liased between Business Partners/Stakeholders and IT teams

●Research and Analyze business needs and objectives to improve processes

●Actively seek and respond quickly to business partners inquiries

●Document and maintain requirements traceability matrix to ensure all requirements are traceable from top to bottom.

●Write and maintain Business Requirements Documents (BRD) and Functional Requirements Documents (FRD) defining new systems operations for the project.

●Create Use cases, Use Case Diagram, Business flow diagram, Work and Navigation flow diagram using Unified modeling language (UML).

●Conduct many informal sessions to develop solutions that the application meets the business requirements, resolve open issues, and change requests.

●Document all data mapping and transformation processes in the Functional Design documents based on the business requirements

●Work on requirement gathering, documentation, Requirement validation and verification and processes conducting JAD sessions

●Define user stories success criteria to ensure the testability of backlog

●Maintaining the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.

●Responsible for designing and execution of Test cases.

●Plan & Execute end to end QA Testing includes Functional testing, System Integration Testing, Regression Testing, Bug Validation and UAT.

●Tracked bugs using JIRA and generated the defect reports for review by the client and the management teams.

●Work as a member of the agile team that extensively used Scrum methodology

●Create, update, prioritize and modify production and development issues in JIRA.

●Create and execute PL/SQL queries in ORACLE.

Environment: Windows 7, Windows Server 2012, .Net with C#, Visual Basic 6.0, Classic ASP, PL/SQL, SQL Developer, JIRA

MLRS Business Process Solutions LLP (India)

Project : Inventory Management System

Duration : April 2015 – Mar 2016

Role : Business Analyst & QA Analyst

Responsibilities:

●Involved in requirement gathering by conducting personal interviews, developing questionnaire, brainstorming, or role playing to get a better understanding of client business processes and creating requirements traceability matrix for tracking the requirements

●Responsible for Project Planning, Feasibility Study, Requirements Analysis (through JAD sessions and Storyboards), Wireframes, and Prototype Development.

●Used power point presentations for conduction walkthroughs with the stakeholders.

●Developed Use Case diagrams, User stories, Business flow diagrams, Activity/State diagrams and Sequence diagrams so that developers and other stakeholders can understand the business process

● Responsible for creating wireframes and prototypes for the system.

●Documented both functional and non-functional requirements, Use Cases, and Systems Requirements Specification (SRS), Conducting GAP analysis, documenting the enhancements to meet the end-state requirements

●Tracked the business requirements/changes and made sure that all the stakeholders have the same perspective and are at the same page

●Identification of End-to-End scenarios for automation.

●Clarifying requirements, understanding design requirements and creating Test Scenarios / Test Cases /scripts etc.

●Perform System Testing, Functionality Testing, Regression testing and Smoke testing

●Negative and Positive testing of various Modules.

●Created Traceability matrix to match the requirements with test cases.

●Participated in the team meetings to discuss the issues that came up during the various stages of testing.

Environment: .Net framework 3.5, Visual Basic, VB Script, JIRA, HTML, Microsoft Office, Oracle, SQL Developer, QTP

ROPL (India)

Project : Point of Sale (POS)

Duration : May 2012 – March 2015

Role : Business Analyst

Responsibilities:

●Interacted with the users for requirement gathering and understanding the business structure of the projects

●Understanding of Requirement Traceability Matrix

●Setup meetings with the development team while reviewing the requirement documents and preparation of the test cases.

●Designed a compact regression test suite for new business application processing

●Quality review of Test Plans, Test Cases and Test Data

●Developed user manuals for final project deliveries

●Prepared test data required to execute the test cases

●Performed testing for using barcode scanner and printer.

●Performed testing for POS printer for receipts

●Prepared QA Strategy and review it with developer/lead

●Used SQL Server Management Studio to write and execute SQL queries to verify the data and generate the MIS reports.

●Negative and Positive testing of various Modules.

●Provided product trainings/demos to various stakeholders

Environment: Visual Basic 6.0, Classic ASP, Microsoft Office, JIRA, SQL Server, HTML

Contact this candidate