Project Test Cases

Arun Kumar

Scrum Master/Sr. Business System Analyst

Email ID :****.******@*****.*** Ph.NO:201-***-****

SUMMARY:

Proactive, self-directed, result oriented Senior Business Analyst with over 9 years of experience in business requirements gathering and analysis, object-oriented design, data modeling, systems development, implementation & administration.

Extensive knowledge and experienced in different software development life cycle methodologies like Waterfall, Rational Unified Process (RUP) and Agile (Scrum).

Experienced with facilitating Scrum Ceremonies as a Scrum Master and expertise in stimulating the adoption of Scrum Rules, Managing Impediments, Conflict Resolution and fostering Self-Management.

Proficient in writing User Stories and handling the Requirements Churn in the Scrum.

Strong knowledge of requirement Elicitation Techniques like Interviewing, Questionnaires, Brainstorming, and Surveys for enhancing features of the Application.

Good knowledge into financial domain like banking, credit management, capital market, and risk management.

Experienced in conducting Rapid Application Development (RAD) and Joint Application Development (JAD) sessions for requirements gathering and translating to Business Requirements Document (BRD), Functional Specification Document (FSD), System Requirements Document (SRD) and other High Level artifact/Low Level artifacts.

Experienced in conducting Gap Analysis, Impact analysis, ROI analysis, SWOT analysis and Cost benefit analysis

Experienced in risk management, task escalation and prioritization to resolve risk.

Expertise in conducting “AS IS”- “TO BE” GAP Analysis, and eliciting high-level business requirements

Strong experience with Requirement Management tools such as Rational Requisite Pro and DOORS

Proficient in analyzing and creating Use Case Scenarios, Use case Diagrams, Activity Diagrams, and Business Flow Diagrams using MS Visio and Rational Rose.

Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes using the Rational Clear Quest.

Assisted working in Data ware house, supporting data extraction, transformations and loading process through ETL tools.

Extensive experience with Data Analysis on Data warehouse system for various reporting systems within an organization.

Possess very good Understanding on Data Warehouse, Client-Server, and Object-Oriented design experience with Data Analysis, Business intelligence(BI).

Assisted UI design Throughout development and keep in touch with client and updated about UI design.

Familiarity with different types of testing including User Acceptance Testing (UAT), Black Box testing, Load Testing and Performance Testing and writing Test Cases, Test Plans and developing RTM (Requirements Traceability Matrix).

Knowledge of web services related concepts - XML, WSDL, SOA, HTML/CSS and JavaScript.

Well versed with various protocols related to web-services and SOA (Service Oriented Architecture) like SOAP, REST and the Internet Protocol Suite like HTTP, TCP, FTP, etc.

Directed teams and participated in Data Visualization, Business Intelligence, Business Analytics, Statistical Analysis and Data Mining. Also worked on extracting data through writing complex SQL queries.

Well versed in project management including creation of WBS, Capacity Planning, Estimating, Scheduling, Risk Planning, team leadership, interfacing with executive management and issue resolution.

Excellent Problem Solving skills, Critical Thinking skills and comfortable in working with onshore/offshore model.

TECHNICAL SKILLS

Modeling Tools

Rational Requisite Pro, HPALM, UML, MS Visio, Rational Doors, Mockup Screens.

SDLC Methodologies

Agile Scrum, Waterfall, Waterfall-Scrum

Database

MS SQL Server 2012/2008/2005, MS Access.

BI Reporting Tools

Tableau, IBM Cognos, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

ETL Tools

Informatica, Teradata, HADOOP

QA Testing Tools

HP ALM, HP Quality Center, JIRA, Load Runner, Mercury QC.

Documentation Tools

MS Office Suite, SharePoint 2010/2013.

Data Warehousing

Data Marts, OLTP, OLAP, Query/Reporting, Multidimensional Analysis, Data Mining, Slicing/dicing, Drill Down/Roll Up

Project Management Tools

MS Project professional, MS Project Server.

Agile Management Tools

Agile JIRA, VersionOne, Rally, HP Agile Manager.

Web Technologies

Ajax, HTML, JavaScript, CSS, Angular, Java Script, JQuery, SOAP, Restful, XML, and WSDL

Working Tools

Teradata SQL Assistant, Oracle SQL Developer, MPUTTY, WIN SCP, Power Designer 16.5, Accurev, GitHub, Denodo

PROFESSIONAL EXPERIENCES

COMPANY NAME: T-Mobile, Seattle, WA. Oct 2015- Present.

Sr.Business Analyst/Scrum Master

PROJECT DESCRIPTION:

The scope of IDW (Integrated data warehouse) is to provide Efficient data to top level of management to make strategic decision. The current process of delivering BI is not ideal because the business community spends too much time and effort on managing data rather than analyzing it. The IDW will gather, manage and provide access to data, so the business community can be more focused on leveraging it for insights and decision-making.

Responsibilities:

Implemented the project using Agile Scrum methodology and analyzed the detailed business case to understand the client needs.

Experienced in interviewing business users in detail, record the requirements, and converted into user stories.

Collaborated with product owner to build requirements log (product backlog) with cost estimates and priority.

Worked in a Scrum team and negotiated with product owner by participating in techniques like MoSCoW to prioritize user stories.

Worked as Scrum Master in estimating the complexity of user story by using techniques like planning poker and T-shirt sizing with scrum team. Used RALLY to plan the user story, add Tasks, Test Cases, Dependencies, and Acceptance Criteria to track the sprint and scrum team’s work and to generate reports.

Experienced in managing the team’s optimal velocity and work on completing planned sprint tasks with consistent schedule.

Good understanding and hands on experience requirement gathering & analysis of BI projects.

Worked as a Scrum Master in facilitating Sprint ceremonies like sprint planning meeting, daily scrum meeting, sprint review meeting, and sprint retrospective meeting for each sprint.

Provided daily communications including scrum notes, sprint review reports and project retrospective to product owner.

Expertise in handling sensitive customer data and provide use full information by using BI tools.

Experienced in participating backlog refinement meeting at any point of time in the process.

Developed and presented SCRUM reports and artifacts to include; Velocity Charts, Burn-down Charts, and Demonstration presentations.

Experienced in creating SSA mapping Document using MS EXCEL by collecting information from Functional Analyst and feed Data Modeler according to his requirements.

Professional in creating Source to Target Mapping Document using MS EXCEL by taking input from SSA document and feed Hadoop Developers.

Incorporated new processes like User Story Driven Development to improve quality of the report.

Understood the compliance norms, regulations and legal obligations that will help build an effective module using CIS Review and managing the document.

Experienced in Querying on ORACLE SQL DEVELOPER using SQL to access databases.

Experienced in creating SSA mapping Document using MS EXCEL by collecting information from Functional Analyst and feed Data Modeler according to his requirements.

Professional in creating Source to Target Mapping Document using MS EXCEL by taking input from SSA document and feed Hadoop Developers.

Experienced in writing BTEQ Scripts using Note Plus, and creating Teradata DDL’s and tables in Teradata

Database using Teradata SQL Assistant.

Had keen contact with end-user how the intent system behave by keeping in mind BDD(behavior driven development) .

Worked with Hadoop developers in validating data using SQL and UNIX Shell Scripting in PUTTY and HUE

Prepared Test Cases and Test Exit Report that is given to App Supporter to deploy the code to production.

Experienced in performing UNIT TESTING at pre-preparation, Preparation, Staging and at Dispatch of the code.

Involved in creating SIS document, Control-M document, Run-Book for each sprint.

Worked on GITHUB, ACCUREV, POWER DESIGNER, DENODO, WYNSCP, MS SHAREPOINT

Environment: AGILE Scrum Methodology, RALLY, MY SQL, Teradata SQL, MS Excel, MS SharePoint, MS Word, Note Plus, Hadoop, GITHUB, PUTTY, WYNSCP, Teradata, Denodo, Power Designer, Accurev.

Company Name: JP Morgan Chase Bank, Columbus, OH. Mar 2015 - Oct 2015.

Sr. Business Analyst

PROJECT DESCRIPTION:

The project is to implement a consistent, comprehensive, systematic and preventative compliance risk management platform. The Global Compliance and Risk Management Program will establish standards and a common solution that drives consistence, efficiency and transparency across LOB's and regions. Functional areas within GCRM are Regulatory Change Management, Policy Management, Risk Assessment, Monitoring & Testing, Training & Awareness, Issues Management, and Governance & oversights. Exam Management is also integrated within the framework.

Responsibilities:

Involved in preparing the project scope and objectives and Gathered business requirements by conducting client group interviews, focused groups, workshops and online surveys.

Conducted Joint Application Development (JAD) sessions with SMEs and stakeholders.

Good understanding and hands on experience requirement gathering & analysis of BI projects.

Strong understanding of financial concepts and various capital market instruments and process including Equities, Fixed Incomes, Derivatives, Foreign exchanges and back-office operations.

Coordinated with project stakeholders to track the progress of the project, updated status and lead review meeting to ensure that schedules and deliverables are met.

Performed data analysis on various financial reports that were generated in excels spreadsheets and was managed by MS Access database.

Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes using the Rational Clear Quest.

Expertise in eliciting business Requirements and documenting then in SRS (software requirement specification) and FRD (Functional requirement document).

Authored use cases, test cases and took ownership of traceability matrix by tracing the requirements in HPALM

Hosted Daily scrum calls by shadowing the project manager when necessary to update sponsor on status updates and project progress.

Created sprint burn-down charts, Facilitated daily stand-ups and review meetings.

Conducted Backlog refinement meetings for requirement detailing via use cases and to undertake management of churns.

Facilitated the process by resolving the conflicts in the team and avoiding the impediments.

Performed the analysis and visualization of the data through Qlikview.

Used SharePoint for content management, and to share the information with the groups involved during the project.

Assisted in working on the SQL to check the accuracy and consistency of the data.

Assisted in the client side data validations for the data and generated many reports for the data mapping in data warehouse by Informatica.

Coordinated and controlled change request for the clients by conducting impact and cost analysis, prioritizing and mitigating changes.

Assisted in the preparation of the Test Plan, Test cases with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application.

Interacted with developers to report data related bugs thorough JIRA and re-tested the fixed issues.

Environment: scrum (agile), MS-Visio, QlikView, Version one, .net, MY SQL, MS Word, MS PowerPoint, SharePoint, Excel, JAD, HP ALM, Web Services, HTML, XML, MySQL, Informatica 9.5, Agile, JIRA, Rational clear quest.

COMPANY NAME: American Commerce Insurance– NH. Jan 2014 - Mar 2015.

Business Analyst

PROJECT DESCRIPTION:

American Commerce Insurance Company provides a whole range of insurance products to its diverse group of customers in the US. The primary goal of the project was to develop a web-enabled application that would enable actions like registering new policyholders on Internet directly and incorporating complete details of the customer and their vehicles. It also helps validate all these service operations at the end.

Responsibilities

Involved in Business Process Management, Documentation, External and Internal Communications, Governance Processes, Program Issues and Risk, Risk Mitigation, Audit and Change Requests.

Elicited requirements by conducting JAD sessions, interviewing business users and stakeholders, conducting one to one sessions and consulting existing systems documents.

Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the product owner & stakeholders.

Mapped process flows; assessed as-is processes through user interviews, data collection, analysis, design and evaluation of to-be process solutions.

Expertise in eliciting business Requirements and documenting then in SRS (software requirement specification) and FRD (Functional requirement document).

Designed and developed Use Case diagrams. Also involved with design team in creation of Activity Diagrams and Sequence Diagrams to depict process flows.

Developed conceptual and logical ER diagrams for the database and created Data Dictionary for the data models.

Strong knowledge of Client-Server validations and developed client validations using JavaScript.

Performed Data Mappings based on the specified business requirements.

Handling sensitive data and good hands on experience in customer data and generating BI reports.

Developed project schedules, timelines, status, system schematics and process work flows.

Managed changes and worked on the change requests during all phases of the project.

Presented meeting agendas and progress of the project to the senior management.

Assisted and guided software architects and developers during the design and development phase.

Strong knowledge of SOAP and WSDL to understand the requirements.

Good knowledge on SOA that is predominant for the e-commerce, which is a 3-tier architecture.

Assisted in design review meetings to make sure all the requirements are covered in the development project scope.

Worked with the project manager to organize project activities and to communicate with other business center managers and stakeholders of the project.

Involved in writing Test Plans, Test Cases and Test Scripts using HPQC.

Discussed limitations, risk, dependencies and assumptions pertaining to the scope of the application. Extensive documentation using Word, Excel and Visio and worked on MS SharePoint for document management.

Prepared change request form to provide details of the changes requests, and obtained approvals from the appropriate stakeholders.

Involved in User Acceptance Testing (UAT) for successful implementation of requirements and generation of reports.

Environment: Waterfall, MS Visio, MS Word, MS Excel, SQL, MS Access, MS Project, MS SharePoint, HPQC.

COMPANY: Fidelity Investments, Durham, North Carolina. Jan 2012 – Dec 2013.

Business Analyst

PROJECT DESCRIPTION:

This project was to develop a Stock valuation system for IPO’s based on latest amount raised, cumulative amount raised and number of investors, using an algorithm which calculated the IPO rating so as to compare stock valuation to different organizations. The algorithm was based on several modules like Growth components, Profitability components, Funding components, Market Components and Activity components.

Responsibilities:

Involved in preparing the project scope and objectives and Gathered business requirements by conducting client group interviews, focused groups, workshops and online surveys.

Conducted Joint Application Development (JAD) sessions with SMEs and stakeholders.

Prepared business requirement document (BRD) and System Requirement Specification (SRS), System Design document (SDS), Functional Requirement Document (FRD) to provide details of each business and functional requirement, development and implementation plan of these requirements, timelines.

Created UML Diagrams including Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams, Data Flow Diagrams (DFDs), ER Diagrams and Graphical user Interface (GUI) -Web Page Mock-Ups using MS Visio & Axure thus defining the Business Process Model and Data Process Model.

Created Use-Case Models to depict Actors and Use-Cases in various Business Processes.

Coordinated with project stakeholders to track the progress of the project, updated status and lead review meeting to ensure that schedules and deliverables are met.

Performed data analysis on various financial reports that were generated in excels spreadsheets and was managed by MS Access database.

Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes using the Rational Clear Quest, expert in handling various BI tools.

Authored use cases, test cases and took ownership of traceability matrix by tracing the requirements

Facilitated the process by resolving the conflicts in the team and avoiding the impediments.

Assisted in working on the SQL to check the accuracy and consistency of the data.

Coordinated and controlled change request for the clients by conducting impact and cost analysis, prioritizing and mitigating changes.

Assisted in the preparation of the Test Plan, Test cases with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application.

COMPANY: Mangal Keshav Securities Ltd. Mumbai. June 2011 – Dec 2011.

Business Analyst

PROJECT DESCRIPTION:

This customer information system developed to help in back end operations at head office, branch and franchisee levels. It includes multi-login administrator built to perform operations. It facilitates for the management of client requests. More than 30 different types of change requests of a client can be processed using this system. Their status can be tracked online with request flow option. Every doc or courier sent by the branches to head office can be tracked online.

RESPONSIBILITIES:

Involved in preparing the project scope and objectives and Gathered business requirements by conducting client group interviews, focused groups, workshops and online surveys.

Conducted Joint Application Development (JAD) sessions with SMEs and stakeholders.

Prepared business requirement document (BRD) and System Requirement Specification (SRS), System Design document (SDS), Functional Requirement Document (FRD) to provide details of each business and functional requirement, development and implementation plan of these requirements, timelines.

Created UML Diagrams including Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Collaboration Diagrams, Data Flow Diagrams (DFDs), ER Diagrams and Graphical user Interface (GUI) -Web Page Mock-Ups using MS Visio & Axure thus defining the Business Process Model and Data Process Model.

Created Use-Case Models to depict Actors and Use-Cases in various Business Processes.

Coordinated with project stakeholders to track the progress of the project, updated status and lead review meeting to ensure that schedules and deliverables are met.

Performed data analysis on various financial reports that were generated in excels spreadsheets and was managed by MS Access database.

Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes using the Rational Clear Quest

Authored use cases, test cases and took ownership of traceability matrix by tracing the requirements

Facilitated the process by resolving the conflicts in the team and avoiding the impediments.

Assisted in working on the SQL to check the accuracy and consistency of the data.

Coordinated and controlled change request for the clients by conducting impact and cost analysis, prioritizing and mitigating changes.

Assisted in the preparation of the Test Plan, Test cases with the testing team as well as ensuring testability, reliability, usability, maintainability and performance of the application.

COMPANY: Goldmine Stocks Pvt Ltd. Ahmedabad. May 2009 – June 2011.

Business Analyst

PROJECT DESCRIPTION:

The scope of the project was to read live trades from the exchange trade file and to calculate the risk of clients based the trades done. Developed modules consisted of reading intraday trades for different segments and store it into database. Calculating risk based on these trades, profit and loss and generating square off reports. Risk Analyzer was designed to generate only the end of day (EOD) risk reports. Whereas new & updated Risk Analyzer facilitates to generate live and online risk report of the clients when the market is live along with many other reports like EOD, compliance and summarized reports.

Responsibilities:

Analyzed the prior documentation and business processes for full understanding of the project. Interviewed area experts, asking detailed questions and carefully recording the requirements hereby building a bridge between the business people and technical people.

After being on boarded, conducted GAP Analysis by understanding the AS IS business process and the TO-BE business process. Prepared SRS document

Conducted JAD sessions, document analysis and one-on-one interviews with the stakeholders for the requirements elicitation.

Assisted project manager in creating proposals and project budget allocations and worked on Project Charter and Work-Breakdown Structures using MS Project.

Prioritized requirements using Moscow technique.

Conducting Business requirements, Functional and technical meetings with business groups.

Prepared Software Requirements Specifications, Business requirement document using Rational Unified Process (RUP).

Prepared prototype using Axure wire frames tool.

Identified high level system actors, depicted complex business requirements as use case diagrams and documented them into clear and concise use case specifications.

Prepared Use case using Rational Rose. Also created an actor based activity diagram.

Prepared Requirements Traceability Matrix (RTM) and updated it time to time.

Handled change requirements and approvals for the client manager.

Initiated the preparation of user manual and PPT presentations.

Assisted test manager to prepare test cases from use cases.

Actively involved in verifying high level test cases and UAT testing.

COMPANY: HFH Delhi. Aug 2007 - May 2009.

Associate Business Analyst

PROJECT DESCRIPTION:

Hospital Management system is an online application includes registration of patients storing their information into the database to provide patients record. Computerizing pharmacy and labs reports to records in database. Manage employee’s profiles, access, and leave management. Scheduling doctor appointments and managing. Operation theater scheduling and room allocation. Helps in daily operations by integration functional operation to align with customer record and make in reporting to top level management.

Responsibilities

Worked with the business users to define business requirements and analyze the possible technical solutions.

Acted as a liaison between the technology team and business users.

Created UML diagrams such as use case diagrams, activity diagrams and sequence diagrams using MS Visio.

Prepared Vision Document Glossary, Stakeholder Request Document, Business requirement document (BRD).

Prepared Use Case Diagram, description document and Supplementary specifications.

Assisted the Lead BA with development of project schedules. Prepared preliminary design for client applications.

Handled change requirements and approvals for the client manager.

Prepared high level test cases to check the accuracy of the project

Assisted in development of training materials for new technology and process improvements in the project.

Actively involved in verifying high level test cases and UAT testing.

EDUCATION

Bachelor of Technology in (Electronics and Communication Engineering). Hyderabad, India.

PG diploma in Finance & Information Technology. Hyderabad, India.

CERTIFICATIONS

International Scrum Institute- SMAC (Scrum Master Accredited Certification)

Contact this candidate