Test Cases Data

VAMSHI B

Sr Business Analyst

Over * years of experience as a Business Systems Analyst, Business Analyst, Business Research Analyst and Reporting Analyst in various domains (Finance, Investment Banking, Retail Banking and Retail).

END CLIENTS

Perr & Knight

Huntington Bank

Best Buy

MAI Capital Investments

FactSet Systems India Pvt. Ltd

Shore Infotech India Pvt. Ltd

TOOLS/METHODS:

AGILE – SCRUM, Agile, Hybrid Scrum

Waterfall, RUP, Spiral

JAD- Joint Application development

UML- Use case diagrams, Sequence diagrams, Class diagrams and Activity diagrams

BRD and FRD

SQL

Selenium

Excel

JIRA/ Confluence/ Rally

MS Office suite, MS Word, MS PowerPoint, MS Access, MS Visio, MS Project

Sharepoint

Power Designer

SOFT SKILLS:

Tracking of all project goals, tasks and resources.

Status reporting

Sprint planning and managing

Negotiations

Interactions

Research and analysis

STRENGTHS

Documentation

Working in teams and independently as required

Status reporting

Onshore-off shore models

SQL

BONDS

Risk Management

Change Management

Flexibility

Self-starter

Problem solving skills

Comprehending business needs and functional requirements

PROCESS KNOWLEDGE

Business Analysis skills

Expertise in dealing with Software Development Life Cycle using the Waterfall Model, Rational Unified Process (RUP) model and Agile/Agile Scrum methodologies.

Proficient in gathering requirements from stakeholders by conducting various elicitation techniques like Brainstorming, One on One Interviews, Surveys & Questionnaire, Focus Groups, Requirement Workshop, Prototyping, Document Analysis and Interface Analysis.

Facilitated and participated in Joint Application Development (JAD) sessions.

Reviewing existing documents and vision documents to assist in GAP analysis.

Immense knowledge about prioritizing techniques like MoSCoW and Kano. Used estimation techniques like Planning Poker, T-shirt sizing and conducted retrospectives using techniques like Star Fish, Mad Sad Glad, Satisfaction histograms.

Created tasks using SMART criteria, did User story mapping, logged impediment list, and resolved impediments, experienced in using development techniques like Test Driven Development (TDD), Behavioral Driven Development (BDD) and Acceptance TDD (ATDD) and capturing empirical data necessary for forecasting for sprints.

Created Sprint/Product Burn Down Chart, Sprint/Product Burn Up Chart, measured & recorded various types of Velocity for tracking team performance while making them perform at the highest level to achieve sprint goals.

Certified Scrum Master and have proficiency in Scrum framework and facilitated ceremonies like Sprint Planning, Daily Scrum, Sprint Review, Backlog Grooming & Sprint Retrospective while enforcing timeboxing and maintaining consistency in teams.

Coordination/ Interaction

Active co-ordination between business stakeholders, SME's and technical team-including PM, Data Analysts, DBA, Developers and QA.

Experience in working on an offshore-onshore development model, co-ordinate resources and establish schedules to ensure that plans are consistent with project management objectives.

Involved in various kinds of testing including User Acceptance Testing (UAT), Black Box testing, Regression testing, Smoke Test, Sanity Testing, White Box Testing, Stress Testing, System Integration testing (SIT).

Experience in working with the QA Testing team for creating Test Plans and Test Cases.

Documentation

Experience in formulating Business Requirement Documents (BRD) and Functional Requirement Documents (FRD).

Expertise in Use case writing.

Proficient in UML – Use case Diagrams, Activity Diagrams, Sequence Diagrams and Class Diagrams using Microsoft Visio.

Technical experience and skills

Proficient in using SQL joins, nested queries and good understanding of batch processes, stored procedures, indexes

Mock up test data creation using SQL.

Knowledge of DDL (data definition language), DML (data manipulation language), DCL (data control language) and TCL (Transaction control language) commands.

Actively used XML formats from source systems, Data Mapping, data items to target systems and building templates for Customized Dashboards.

Working Knowledge of Unix Commands.

Knowledge of ETL (Extract, transform, load) used mostly for data-ware housing.

FINANCE EXPERTICE

Strengths include working with technical and business teams and Change Management to create, interpret and implement financial software systems. Understanding of Capital Market Instruments. Equity, Fixed Income, OTC Derivatives and Swaps, Currency Forwards, FX Futures, REPOs and Money Market instruments.

Proficiency in Trade life cycle, Trade settlement process and Reconciliation.

Expertise in Risk Management using VaR- Historical, Variance-Covariance and Monte Carlo Simulation. Calculation of Risk factors such as Variance, Standard Deviation, Alpha and Beta.

PROFESSIONAL EXPERIENCE

Perr & Knight, Fort Worth, TX Oct 2016 - Current

Sr. Business Systems Analyst/Scrum Analyst

Description: Property and casualty insurance companies are required to file data with Statistical Agents who then compile the data for State Insurance Departments. The objective of the project was to develop a system which would help in automating the process of data reporting to improve accuracy and timeliness.

Responsibilities:

Efficiently worked in the Water Scrum Fall methodology which is a hybrid model of Scrum and Waterfall.

Conducted Gap analysis by knowing the AS-IS business models and TO-BE business models and created the Mapping documents so rectify the gaps.

Conducted requirement walk-throughs with key stakeholders using various methods like team demos, workshops during sprint planning and backlog refinement sessions.

Drafted Business Requirement Document (BRD) for the specific business requirements and Functional Specification Document (FSD) capture the functional requirements.

Helped the team overcome a technical barrier by creating and updating use case diagrams, Activity diagrams, Sequence diagrams, Data Flow Diagrams using MS Visio.

Worked with the Design team and created prototypes using mockupscreens and wireframes to give a clear picture of the system to the client.

Prioritizing the ad hoc releases by conducting business impact analysis and technical impact analysis of the release on the system and to know whether it has any dependencies.

Conducted Root cause analysis to know the reasons for the ad hoc release and document the causes.

Estimated tasks based on the task hours that has been defined by the developers.

Documented the pre-steps and the post-steps to be followed before and after the release.

Extensively used SQL scripts/queries for data verification at the backend.

Prepared Requirement Traceability Matrix (RTM) report to ensure that every Business requirement is adhered to achieve the expected performance.

Involved with the Software Quality Assurance (SQA) Team to develop Test plans, execution of Test Cases and logged the defects for failed test cases.

Facilitated Scrum ceremonies, workshops on SCRUM and decomposed Epics into User Stories using Vertical Slicing technique. Created user stories using INVEST criteria, tasks using SMART criteria, and defined Acceptance criteria. Used various Estimation, planning and Prioritization techniques such as MoSCoW and Planning Poker respectively. Responsible for identifying Impediments and conflict management.

Environment: Agile/Water-Scrum-fall Hybrid, Oracle, SQL, PL/SQL, Sharepoint, MS-Visio, MS Office suite, Process Improvement, MS-Access.

Huntington Bank, Columbus, OH Jun 2015 – Sep 2016

Sr. Business Analyst

Description: Huntington Bancshares, Inc. is an American bank holding company headquartered in Columbus, Ohio. The objective of the project is to build a system which provides alerts to the customers about the actions which were performed and alerts about the activities which needs actions to be performed. These alerts would be in the form of emails, messages and notifications.

Responsibilities:

Extensively worked in Agile/Scrum Methodology framework especially within a Mobile/Tablet/Mobile Web application ecosystem.

Worked in great collaboration with Product Owners to manage Product Backlog for agile software development teams.

Evaluate information from multiple sources within the business team and cross work-streams and help distinguish user requests from user needs.

Wrote concise and effective User stories while fostering agile principles and methods for requirement gathering.

Wrote Use cases for all the functionalities and developed Use case diagrams.

Defined precise and accurate User Story Acceptance Criteria that was used by developers, testing team and by Product Managers to ensure that Product Managers’ intent is effectively captured.

Used JIRA for User Story requirements management throughout the Agile Sprints and development life cycle.

Estimated tasks based on the task hours that has been defined by the developers.

Worked with a UI/UX design team on Screen Mockups, Wireframes and screenshots for the application and have experience in wireframe prototyping using Justinmind Prototyper & Snagit.

Worked directly with developers and Tech Lead to make sure the software meets the product requirements and business requirements.

Supported agile software development team with Scope considerations throughout the development cycle.

Driven process definition and improvement for the release projects and worked closely with Agile Coach on improving overall agile development.

Involved in identifying and managing the working dependencies of Onsite and Offshore teams.

Worked with the Testing team throughout the defect management life cycle in HP ALM and planning necessary test cases for resolving the defects within the given Sprint time box.

Conducted Client Acceptance Testing (CAT) along with the Product Managers to ensure all the business requirements have been fulfilled by the application.

Worked with the Production support team for issues reported by the user group in the production environment.

Environment: Agile Scrum, JIRA, Microsoft Office Suite, Justinmind Prototyper, MS Visio, Oracle, Process Improvement.

Best Buy, Richfield, MN Jun 2014 - May 2015

Business Systems Analyst

Description: Best Buy Co., Inc. is an American multinational consumer electronics corporation headquartered in Richfield, Minnesota. The project consisted of designing a new in-house order management system and in store billing application. Respective store managers and customer sales staff order the products they need from the stores system, and in 3 days they receive the products they had ordered, the project was to replace with the new order management system and in store billing application.

Responsibilities:

Responsible for documentation of business and functional requirements.

Conducted stakeholder interviews and planning sessions for gathering requirements.

Created Activity Diagrams, Sequence Diagrams using UML methodologies for easy understanding.

Created requirement documentation; reviews with user representatives, recommended priorities and obtained user signoff.

Analyzed present needs/recommendations and aided in preparing and presenting Return on Investments, business case proposals and Cost Benefit Analysis.

Worked in conjunction with the team in assigning tasks with understanding of the complexity and priority of the task.

Assisted the Product Owner in converting requirements from BRD into User Stories by conducting User Story sessions and prioritizing Product Backlog Items (PBI).

Responsible for implementing, coordinating and documenting all business processes for (web based) Internet billing customers.

Implemented and supported Order Management System by defining and validating requirements relating to OMS and developing process flows to define functionality across the systems.

Tracked team’s velocity and progress during a Sprint using Sprint burn down chart and Release burn down chart.

Helped the team in estimating the complexity of the user story by using Planning Poker.

Assisted Business Intelligence (BI) team in creating dashboards using Tableau as required by the end users.

The effort involved developing extensive SQL Queries and Procedures, utilized to perform database integrity testing, ensuring various data table entries, data validity, and data integrity.

Performed logical data modeling and created ER diagrams and used SQL queries for managing database.

Prepared Requirement Traceability Matrix (RTM) report to ensure that every Business requirement is adhered to achieve the expected performance.

Played a key role in the planning and performing User Accepted Testing (UAT) along with business users.

Environment: Scrum Methodology, HP ALM, Tableau, SQL Server, Mock-Up Screens, UML, MS Office Suite, MS Visio.

MAI Capital Management, Cleveland, OH Jun 2013 - Apr 2014

Business Analyst

Description: The objective of the project was to develop a system which provides unbiased financial advice based on the risk appetite and the profile of the users by leveraging big data and predictive analysis. The system also provides services like portfolio rebalancing and tax loss harvesting.

Responsibilities:

Elicited requirements on Web Application, Dashboards and types of Data and Reports from different Business Owners, Stakeholders and development teams by facilitating Interviews, Brainstorming, re-engineering and JAD session.

Assisted Project Manager in creating Project deliverables, KPI’s, milestones, resource estimation and work breakdown structure using MS Project.

Performed Document Analysis to know the As-Is system and created To-Be system by conducting GAP Analysis, broke down the BRD into user stories by conducting workshops with the team and defined the acceptance criteria for the user stories and created the product backlog on issue tracking tool JIRA.

Prepared Data flow diagram, Use case diagram, Sequence diagram, Activity diagram and mockup for a better visual understanding and involved in modelling business scenario predictions like segmenting users based on their behavior.

Worked proactively with Bloomberg and Reuters specialists in identifying data inconsistencies to provide curated data to the Machine Learning Algorithm.

Provide ad-hoc support to risk managers to help them better understand the behavior of the models.

Aided testing team in performing Unit testing, Integration, System and performance testing and creation of testing artefacts like test cases, test scripts and test scenarios.

Used Test Driven Development (TDD) development and Acceptance Test Driven Development (ATDD) technique for building the components.

Assisted in configuring dash boards and reports using Power BI.

Involved in creation of User Acceptance Test cases and plans, defect tracking using JIRA and validated reports and dashboards.

Attended Scrum ceremonies, and helped in converting High level requirements like Epics in to user stories by using Vertical Slicing technique. Used various Estimation, planning and prioritization techniques such as Moscow and Planning Poker.

Environment: Scrum-Waterfall Hybrid, MySQL database, Power BI, JIRA, MS Visio, MS Project, MS Office suite, Capital markets, Hadoop, Power BI.

FactSet Systems India Pvt. Ltd, India Oct 2011 – Mar 2013

Business Research Analyst

Description: The scope of the project is to build a Mutual Fund processing system to automate the method of processing the mutual funds, to reduce the lead time and increase the efficiency of the process. As a Business Research, I was responsible for gathering the functional requirements from the business users and create Functional Requirements Documents.

Responsibilities:

Gathering requirements from the business users using various elicitation techniques such as Interviewing, Brainstorming and Focus groups.

Created Business Requirement Documents(BRD) and Functional Requirements Documents(FRD) capturing all the functional and the non-functional requirements.

Created prototypes using mockup screens to explain the UI of the functionality.

Dealing with the portfolio of holdings which comprise of Equities & Fixed income securities.

Segregating Securities as per their Asset classes.

Primary workflow involves checking the accuracy of the portfolio of holdings with internally prescribed parameters & updating the processed Mutual funds to the database.

Correlating the Prices of securities of the processed portfolio with the database prices.

Corporate Actions such as Stock Split and Spin-off, need to be verified for huge price variances.

Checking the Fund name, Net assets & NAV of the fund including fund history.

Making necessary amendments to the existing Mutual Fund database.

Exploring data from BLOOMBERG, THOMSON REUTERS, Securities Exchange Commission and SEDAR.

Providing complete details of the fund such as Investment Objective, recent NAV, and rate of allocation of Total Assets to different asset classes.

Environment: Waterfall, MS Office Suite, MS Visio, RDBMS, SQL

Shore Infotech India Pvt. Ltd, India Aug 2010 – Sep 2011

Programmer/Reporting Analyst

Responsibilities:

Served as the primary point of contact with the client, performed requirements gathering and analysis to eliminate redundancy.

Headed a team of five members to develop reports and visualizations using SSRS that assisted in making key business decisions.

Collaborated with several business stakeholders to define data and reporting requirements for the technical implementation.

Utilized SQL to fulfill ad-hoc data procurement requests in a timely manner to accelerate seamless delivery of results to the client.

Automated the ETL of data from different data sources to a data warehouse which optimized the output efficiency manifold.

Employed SQL Profiler to analyze & capture the stored procedures under different GUIs reducing the defect rate.

Environment: SQL, MS Office Suite, DBVisualizer

EDUCATION

Bachelor’s in Technology from JNTU Hyderabad. 2006-2010

Contact this candidate