Sanhita Banda ac13n3@r.postjobfree.com Cell: 614-***-****

Business Analyst with 10 years of IT experience

IT experience in various domains like Banking, Insurance, Retirement Plans, & Retail.

Expertise in Software Development Life Cycle Methodologies such as Waterfall, RUP, Spiral, Pair programming, &Agile-Scrumincluding variousHybrid Organizational Methodologies.

Workedwithmulti-departmental infrastructure projects in various roles such as Business Analyst, Test Analyst, Requirement Analyst, Quality Analyst, and Lead Business Analyst.

Analyzed existing Requirement Documents, Technical Documents, Process Maps, and ASIS System and created Document of Understanding and Business Requirement Document capturing Scope, Dependencies, Features, Epics, and User Story List.

MappedStakeholder Requirement to Epics, User Stories and Test Cases.

Created Product Backlog and prioritized user stories.

Conducted Entry/Exit Gate Meetings & multiple Requirement Sessions briefing Scope, Assumptions & Dependencies.

Analyzed and Estimated Business Analyst effort.

Conducted Brainstorming Sessions, One on one, Joint Application Requirement (JAR) Sessions, Joint Application Development (JAD) Sessions, Show & Tell, and PeriodicStatus Meetings.

Facilitated numerous large meetings involving onsite, offsite, & offshore teams.

Created Business Requirement Document, System Requirement Specifications, Functional Requirement Documents, Non-Functional Requirement Documents, Use Cases, User Stories, Business Rules, Information Requirements, Report Requirements, Source to Target-Data Mapping Sheets, Test Plans, Test Scenarios & Cases and Requirement Traceability Matrix (RTM).

Gathered & Documented Requirements for new applications as well as re-engineering of an existing application.

Hands on experience using various documentations repositories/tracking tools such as MEGA, SharePoint, Lotus Notes, MS Visio, Trac, and IBM Rational Software integrated tools like Rational Clear Case, Rational Clear Quest, Rational Requisite Pro,Rational Rose, Rational Team Concert, Rational Requirements Composer.

Highly proficient in Object-Oriented modeling using various UML diagrams such as Use case diagrams, Sequence diagram, and Activity diagrams.

Conducted Gap analysis, SWOT analysis, Impact analysis, and cost/benefit analysis to increase productivity and reduce cost.

Created multiple complex reports such as Project Schedules, Weekly/Monthly Status Reports, Burn-Rate Report, Defect Queue Management, KPI & CPI Reports, SLA Reports, Root Cause Analysis& Resolution Documents.

Highly motivated team player with excellent communication, presentation, and interpersonal skills.

Created Test Plan, Test Strategy, Test Cases and Test Summary Reports

Conducted ADA (Americans Disability Act) Testing of Websites and Mobile Applications.

Written and executed SQL query in order to validate database, dataflow&UI parameters.

Written and executed SQL’s query to validate ETL load processes and Business intelligence reports

Created and Loadtest data into databases.

Written and executed system test plans for web-based software including functional, usability, browser compatibility, performance, installation, load and stress tests using QTP and QC

Verified test results to ensure system is behaving perbusiness requirements (User Stories) and HLD/LLD.

Created Test scripts, Call Scripts and Requirement traceability matrix in Quality Center

Categorized, Prioritized, and Trackeddefects based on the severity and Priority; And coordinated with multiple development teams until all defects are fixed and retested.

Used HP Quality Center and Rational clear quest test management tools to create and execute Test Plan, Test Cases, and Test Scripts and also Map the same to Requirements for traceability.

Developed test strategy, test requirements matrix, and test work plan for ETL (Informatica) and MicroStrategy business applications.

Developed test strategy, Requirements Traceability Matrix (RTM), and test work plan for Acquisitions, Loan, Web based Projects and Business Reports.

Owned Test Environments such as Alpha, Beta and UAT. Coordinated with various Dev, QA and Business groups to efficiently manage various Release Activity.

Managed various change requests, including defects, enhancements, issues and documented the same using Quality center

Technical Competencies:

Operating System

Windows, Linux, Unix, IBM Mainframe, IBM WEBLOGIC and TOMCAT.

Database

Microsoft Access, MS SQL Server, Oracle

Languages

HTML, JAVA, C++, APS.Net, VB

Methodologies

UML, Data Modeling [Conceptual, Logical], Object Modeling, ERD, Data Flow Diagrams, BPMN, Context Diagrams

Requirement Repositories &Tools

SharePoint, MEGA, Lotus Notes, Trac, Rational Suite [RequisitePro, Rose, Clear Case, Clear Quest], Test Director, Borland Star Team, MS Office, Visio, Excel, Access, & Lync.

Domain Standards

HIPAA, IEEE Standards, & NACHA.

Software testing

Manual Testing, Automated Testing, Test Plan, Test Case, Test Script Creation, White Box Testing, Black Box Testing, System Testing, User Acceptance Testing, Browser Compatibility Testing, Performance/Stress Testing, GUI Testing, Security Testing, Regression Testing, Functional/Integration Testing.

Software testing tools

Visual Studio Team Edition for Testers (TFS), Test Director, Quality Center, Mantis, Microsoft Office, Microsoft Project

Training & Certifications:

Business Analyst Training

2010

Accessibility Testing Training

2012

Agile Methodology

2011

Automation Testing (ruby)

2013

Professional Experience

Nationwide Mutual Insurance Company September 2014 – Present

Role: Requirement Analyst (Business Analyst)

Location: Columbus, OH

Nationwide Mutual Insurance Company is a group of large US insurance and financial services companies based in Columbus, OH. Nationwide has been awarded the exclusive contract for general retirement plan administration for transition of data and administrative processes to the Nationwide recordkeeping system from external providers of large-scale public sector retirement plans with approximately $1 billion in assets under management (City of Seattle Deferred Compensation Plan, City of Philadelphia, City of Sacramento, etc Acquisition project was responsible for moving all plans (transfer ins/rollover ins) from the previous Plan provider’s system to Nationwide Plan administration system which involved both automation and manual testing efforts for backend and front end. The transition involves retirement plan data and under lying account level data to Nationwide database and validated for accuracy using Nationwide user interface. Assets will be mapped to a unit/share accounting fund line-up where daily trades and fund prices are performed.

Responsibilities:

Analyzed the Business Requirements Document and system specifications and identified the test requirements.

Worked in a Scrum team environment and participated in backlog review and Sprint planning sessions, following Agile methodology.

Interacted with Requirement Analysts and Developers in requirement analysis, design reviews, testing and documentation for application developed in Agile environment.

Analyzed App enhancement documents (BRD) from business troika and broke down Features Epics &Epics user stories.

Created Master Story List (MSL) and prioritized product backlog.

Conducted JAR Sessions to elaborate stakeholder requirement to detailed requirements (user stories).

Prioritized and Re-prioritized user stories to meet changing project priorities and dependencies.

Coordinate with various downstream systems to ensure that the scope is defined clearly across teams.

Facilitated JADsessions for Feasibility of the requirements and address any technical constraints.

Captured minutes of meetings, actions items, due dates, owners for action items and tracked the same until closure.

Created use cases, user stories, information requirements, business rules, report requirements in RRC and mapped the same to story cards in Rational Team Concert(RTC)

Performed various reviews such as peer review,out-side-the-line RA review, business review and approvals.

Created mockups based on requirements.

Prepared a standard questionnaire template for the team that can be re-used for reports, letters, and statements.

Created Test plansand Test Strategy based on business requirement documents and use cases.

Prepared and reviewed Test scripts in Quality Center.

Prioritized bugs based on the severity and interfaced with developers to resolve them.

Used HP ALM Quality Center to create test cases intest plan, run the test cases in test lab, and login & track defects.

Attended daily stand-up meeting with Project team to report status on committed tasks and any potential roadblocks.

Developed test strategy, Requirements Traceability Matrix (RTM), and test work plan for Acquisitions, Loan, Web based Projects and Business Reports.

Loaded test data into databases in support of requirements and testing needs.

Executed SQL Queries to verify the dataflow from the backend and validate screens

Report formatting, testing against requirement.

Verified all test results to ensure system behavior is per business requirements and design documents.

Extensively used Microsoft Office Suite of products for documentation and data interpretation

Worked on Virtual machines that worked independently from each other on a single physical computer, created a virtual testing lab on one computer.

Environment: HP Application Life Cycle Management, Quality Center (QC), Informatica, Teradata, Microsoft SQL server 2008, Essbase, MicroStrategy, TOAD, CVS, JavaScript, Agile, Subversion, Beyond compare, Visio 2010, Windows 2003.

Kroger September 2012 – September 2014

Role: Business Analyst

Location: Cincinnati, OH

Kroger is a corporate classified system which provides the sales reporting information by store, district and division level for all product categories (produce, dairy, frozen, accessories, furniture, etc It also gives weekly classified information for store managers and district level managers. It gives sales information by product for current year vs prior year and also gives information about weekly sales. Reports based on store counts like new store opening or closing of stores are also given.

Responsibilities:

Analyzed the Business Requirements Document and System Specifications.

Interacted with Developers, design reviews, testing and documentation for application developed in Agile environment.

Conducted JAD interviews and facilitated meetings with project teams as needed

Contributed in project planning and work allocation in accordance with project management framework standards and procedures.

Identified ongoing issues and gaps within current process and made recommendations.

Actively participated/arranged with number of iterations between team and business on domain related tasks.

Translated business user concepts and ideas into Features, Epics and User Stories (System Requirement Specification).

Created user stories and followed the Story review process (Peer Review, Business Approval, 3 Amigo) until moved to the scrum board.

Conducted Iteration planning&Retrospective meetings.

Facilitated and contributed Story Estimation meetings.

Supported Testing team with Exploratory testing of the application.

Created and Monitored Requirement Traceability Matrix until all the requirements are captured, tested and closed.

Used HP Quality Center and Rational clear quest as test management tools in defining releases, documenting requirements and test cases and mapping requirements with test cases, defect reporting and analyzing test results

Attended daily kick-off meeting with scrum team to discuss issues and daily tasks.

Executed SQL Queries to verify the dataflow from the backend and validate screens.

Verify all test results to ensure system is performing functions as described in business requirements and design documents.

Extensively used as-of products for documentation and data interpretation.

Environment: Share Point, Lotus Notes, RegPro, HP Application Life Cycle Management Quality Center (QC), Microsoft SQL server 2008, TOAD, JavaScript, Agile, Subversion, Beyond compare, Visio 2010, Windows 2008.

Chiquita Brands International inc. October 2011 –September2012

Role: Business Analyst

Location: Cincinnati, Ohio

Chiquita Brands International Inc. is an American producer and distributor of bananas and other produce. The company operates under a number of subsidiary brand names, including the flagship Chiquita brand and Fresh Express salads. Chiquita is the leading distributor of bananas in the United States.

Responsibilities:

Analyzed System Requirements Specification and created Master Story List (Stakeholder Requirement Epics & Epics User Stories &Test Cases).

Prioritized product backlog (User Stories) and created Iteration Backlogs.

Configured iterations in jira, created stories and tracked the same, organized Sprint Planning, Daily Stand Ups, Iteration Planning Meetings, and Retrospectives.

Coordinated with various downstream systems to ensure that the scope is defined clearly across dependent teams.

Facilitated JAR sessions to elicit detailed requirements and documented the same.

Captured Minutes Of Meetings, Actions Items, Due Dates, Owners for Action Items and tracked the same until closure.

Created Use Cases, User Stories, Information Requirements, Business Rules, Report Requirements in JIRA

Performed various review process such as Peer Review, Out Side The Line Ra Peer Review, Business Review and Approvals.

Coordinated with Ux Team to create wireframes,

Coordinated with Content Management and Legal Teams.

Facilitated JAD sessions to discuss technical dependencies and layout high-level designs.

Prepared a standard questionnaire template for the team that can be re-used common functionalities.

Conducted 3 amigo meetings involving DEV, QA and BA.

Conducted exploratory testing and logged defects appropriately.

Performed as a Subject Matter Expertise (SME) for UI designs

Conducted various requirement walk through sessions to help end to end testers.

Identified data elements required for new functionalities and coordinated with the run team for successfully migrating data to the new data warehouse.

Identified pain points with the current requirement process and recommended various improvements in requirement gathering and signoff process.

Created Business Requirement document (BRD) and Functional Requirement document and maintained the RequirementTraceability Matrix (RTM) related document.

Conducted UAT, developing and maintaining quality procedures and ensured that appropriate documentation is captured.

Environment: HP Quick test professional (QTP), Quality Center (QC), Microsoft SQL server 2008, SQL Navigator, Data Stage, XML, Business Objects, Windows 2003 server and UNIX.

AAA Insurance Services. august 2010 – September 2011

Role: Business System Analyst

Location: Minneapolis, MN

AAA Insurance is a company with five Lines of Business with various Insurance products. Integrated Customer Platform/Customer Driven Evolution (CDE) was an effort to consolidate the segregated databases into a single database with an aim to increase customer satisfaction. Disbursements is an individual project among the many ICP/CDE projects which focuses on disbursing Auto, Home, Life, Travel, Vehicle extended services

Responsibilities:

Reviewed High-Level Requirements documents and created product backlog.

Prioritized Use Cases and conducted recurring meetings with Business Analyst Team to ensure consistency in use cases.

Worked with the Wireframe Team in designing the Administrative User Interface desings.

Conducted JAD sessions involving Business partners, Wireframe designers and product owners to baseline Admin UI design.

Created a Review & Feedback process for Use cases created by the Business Analysts.

Identified and documented detailed Business Requirements and Business Rules.

Created Dependency documents illustrating internal dependencies as well as dependency on other ICP/CDE projects and communicated with the overall dependency coordinator.

Created Process Maps using MS Visio.

Experienced in PeopleSoft HCM and the dependencies with between modules within HCM and PeopleSoft Finance.

Experienced with PeopleSoft Time and Labor modules.

Conducted Risk Analysis Sessions and created Risk trackingdocuments.

Contributed in developing Test cases, Test plans&performed accessibility testing.

Collaborated with the testing team to develop user acceptance test cases and test criteria.

Served as a liaison between the offshore and onsite teams in the development phase.

Environment: Scrum, Business Process Design/ Workflow Analysis, PeopleSoft, Reverse Engineering, MS Project, Office, MEGA, SharePoint, Lotus Notes, Mainframe, Java.

wells Fargo October 2009– July 2010

Project: Finance (Banking)

Role: Business Analyst

Location: Minneapolis, Minnesota

Wells Fargo offers asset based loans for small growing businesses. Merchant looks at the opportunities available, management and future prospects of the small business it is going to finance. The client needs are constantly reviewed and credit lines can be adjusted accordingly. A client server application called RIP (Risk Information Profile) was created whose goal was to provide a tool to conduct the risks involved with a current customer. This tool involves authenticating the customer, checks, current credit limit and previous credit lines, payment history, fraud history, business history, frequency of credit card usage, etc.

Responsibilities:

Interacted with the business and other IT partners to gather requirements from an Information technology standpoint, answered any project related questions for customer assist and conducted Gap analysis.

Conducted JAD sessions to understand requirement related issues and work towards coming to a common and most apt solution.

Worked with UX (user experience) team for UI designs related to projects and made sure that the UX designs were in tandem with the project business requirements.

Worked with the UX team during screen mockups and prototype creations.

Worked with the development team to understand if a certain requirement can be implemented in the release cycle, and understood the impacts the enhancements may have on the existing flows and codes in CA.

Worked as a liaison between the CA IT team and Business and other groups and managed all communication between teams and groups related to the project.

Prepared Functional Document capturing system behavior per business requirements.

Created Test Cases for multiple testing scenarios

Executed test cases and worked with the QA team to resolve their queries.

Worked with the offshore and onsite development resources during development phase to answer all queries regarding the project for accurate code build.

Updated Evergreen documents with new enhancements and functionality descriptions.

Maintained and managed project related documents in SharePoint.

Worked with business through the UAT phase and provided any support needed from the IT project standpoint.

Created defect tickets and monitored until closure.

Prepared validation plans for implementation of the projects assigned and provided support for Enterprise Release

Environment: Mega, UML, MS-Visio2000, UNIX (Solaris), Oracle 9i, SQL, Informatica, Toad, RUP.

HCL Systems March 2007 – august 2008

Role: Business Analyst

Location: India

Hospital Information System (HIS): The project was to develop a Health Information System to streamline all hospital operations by automating the entire work flow and ensuring effortless retrieval & management of patient records. The main goal was to develop a system aimed at tackling services like Booking, pre-admission and pre-certification; Admission, registration and visit notification; Bed assignment, transfer, leave of absence, discharge and census management; Multi-parameter charging; Claim preparation and submission; Receivables management and follow-up; Remittance posting and denial management; & Customer service.

Responsibilities:

Worked on comprehensive Business Process Model which included all the process steps ranging from Scheduling appointments to Claims preparation processes. This was done to facilitate effectual scope analysis followed by cost estimation. This was the key component in highlighting issues around business impact analysis.

Facilitated meetings with Key Business users to discuss complex process and risk analysis including researching alternative processes.

Project cost estimation was done on a feature by feature basis which helped the business in prioritizing the features to be included in the current scope.

Created Functions Specification document.

Performed requirements management activities, including change control, facilitating stakeholder meetings, and business process modeling.

Assisted Project manager in project planning.

Created screen mockups to help IT and Business in arriving at preliminary consensus.

Contributed effectively to the Process management meetings with business users.

Created test cases and worked with QA Lead to facilitate DDTs [Data Driven Tests]

Environment: RUP, Business Process Design/ Workflow Analysis, Reverse Engineering, System Integration, Rational Requisite Pro, Rose, Clear Case, Clear Quest, Data Warehousing, MS Project, Office, Access, Enterprise Architect.

Education

BACHELOR’S IN computer science

Contact this candidate