Gowtham Mandl Senior Business Analyst

Email:ac903h@r.postjobfree.com

Phone: 972-***-****

Senior Business Analyst with 8 years of experience in domains such as E-commerce, Education, Investment Management and Property & Casualty. Proficient in Software Development Life Cycle methodologies such as Waterfall, Agile and expertise in developing and implementing innovative business processes and providing system solutions using new approaches.

Professional Summary:

In depth knowledge and solid experience about Software Development Life Cycle (SDLC) using Agile (SCRUM) and Waterfall methodologies.

Performed AS IS and TO BE analysis for documenting User Stories and Business Requirements Document (BRD) which in turn helps in transforming to Functional Requirements Document (FRD).

Experience in requirements gathering by conducting Joint Application Development (JAD) sessions and Fit/Gap sessions.

Expertise in Requirement Elicitation techniques. Highly proficient in coordinating with the team and in working with users, stakeholders to elicit the requirements using Focus groups, Interviews and Brainstorming sessions.

Proven experience in end-to-end business process mapping, business and technical requirements analysis, business planning, modeling, verification and product development.

Developed and maintained Agile artifacts; sprint backlog, burn-down chart and Involved in Scrum events such as Backlog Grooming and Story-Point Estimation.

Facilitated Agile Scrum Ceremonies: Sprint Planning, Daily Scrum Call, Sprint Review and Sprint Retrospective Meetings.

Proficient in using UML in behavioral, structural modeling – in creating Use Case, State chart diagrams, Activity diagrams, Class diagrams, Sequence diagrams, Process flow diagrams and Data Flow diagrams (DFD) using MS Visio.

Created workflow scenarios, designed new process flows and documented the business Process and activities of the business from the conceptual to procedural level.

Skilled in leading the project, Analysis, design and implementation of the solutions.

Experience in working on web applications and interactive software products using HTML, CSS and JavaScript.

Created Wireframes for better visualization by using Balsamiq and Pencil.

Proficient in creating and managing Requirement Traceability Matrix (RTM) for tracking and managing changes based on project’s evolving needs.

Used TFS, JIRA for defect tracking and reviewed them in subsequent iterations of the application development process and facilitated Triage meetings.

Effectively and accurately communicated relevant project information to the client and offshore project team.

Trained users on the changes being released and conducted post production activities like getting feedback from users, prioritizing tasks with business users.

Possess excellent written and verbal communication skills. Self-motivated and organized.

Performed Sanity Testing for all the enhancements related to Screens, Reports and Inbound / Outbound interfaces in the project.

Experience in creating test cases and participated in QA and User Acceptance Testing (UAT).

Technical Skills:

Domain

E-commerce, Education, Investment Management and Property & Casualty.

SDLC Methodologies

Waterfall, Agile (SCRUM)

Business

Process Modelling Tools

MS Visio

Wire Framing Tools

Balsamiq, Pencil

Defect Tracking Tools

JIRA, HP QC, TFS

Document

Management Tools

MS Office - Word, Excel, PowerPoint, Outlook

Content Management Tools

MS SharePoint

Database

Management Systems

Oracle, SQL Server

Requirement Management Tools

Team Foundation Server (TFS) and JIRA

Programming Languages

C/C++, JavaScript, C#

Markup Languages

HTML, CSS, XML

Operating System

Windows, Linux

Professional Experience:

Client: Baker & Taylor, Charlotte, NC Apr 2018 – Till Date

Role: Senior Business Analyst

Project Description:

Baker & Taylor is a distributor of books to public libraries and schools, has been in business for over 180 years. Worked as a Senior Business Analyst in the following projects.

TS 360: Title Source 360 is an innovative and dynamic ordering system that allows B&T customers - both librarians and retailers to purchase Books and Entertainment (Movies/Music) titles.

CDMS: The Collection Development Management System application is developed to assist the Collection Development staff of Baker & Taylor in their day-to-day CD tasks - preparation of Collection Development lists.

AXIS 360: This application allows users to read and listen to digital content.

Responsibilities:

Documented user stories and modeled Use Case diagrams by utilizing MS Visio.

Performed Gap Analysis to check the compatibility of the existing system with the new business requirements.

Participated and facilitated meetings with business and Subject Matter Experts (SMEs) to capture the high level function points and business practices.

Created a product roadmap for the various stages and releases throughout the project lifecycle.

Provided analytical support in the Design, Development and Implementation of Project.

Created Use Case diagrams, Activity diagrams, and Sequence diagrams by using MS Visio.

Documented Requirement Traceability Matrix (RTM) to check the completion of current project requirements.

Created wireframes for the user interface and provided the same to GUI design team.

Verified the Business Scenarios on new builds to allow testing by the QA team.

Reviewed and approved Test Scenarios and Test Cases based on user stories.

Actively conducted and participated in weekly meetings to analyze the progress and to maintain status reports.

Performed Back End Testing using SQL queries, generating reports to ensure data integrity and to validate the inserted and updated data.

Prepared UAT Test Plan for various Test Scenarios and assisted in User Acceptance Testing.

Organized JAD sessions to understand the client’s existing business process.

Prioritized deliverables, identified gaps, tracked defects, defined software requirements, created artifacts for development and testing.

Effectively communicated Business Requirements with Offshore BA’s / UI/UX designer and responsible for Onsite – Offshore coordination.

Environment: MS Visio, MS Office, Team Foundation Server, ASP.NET, SQL Server, Pencil, Microsoft Teams

Client: Los Angeles Unified School District (LAUSD), Los Angeles, CA Aug 2016 – Mar 2018

Role: Senior Business Analyst

Project Description:

My Integrated Student Information System (MiSiS) is a modernized all-in-one student information system that provides teachers, counselors, administrators, and others with access to student information (K-12) all in one place. It is the largest and most complex student data system in the United States.

Responsibilities:

Worked as Primary BA for MiSiS components such as Scheduling, Student Support and System Administration.

Expertise in gathering requirements from SMEs and Business Owners by using different Elicitation techniques.

Performed AS IS and TO BE analysis to check the compatibility of new Business requirements with the existing system.

Created Technical Specification documents as per Business requirements and provided the same to the developers.

Conducted Spec Walkthrough meetings with Business Owners, SMEs, Developers and QA team.

Expertise in doing Specs Peer Review for all the enhancements done by the others BA’s in the project.

Performed Sanity Testing for all the enhancements related to screens, reports and Inbound / Outbound Interfaces in the project.

Effectively communicated Business Requirements with Offshore BA’s and responsible for Onsite – Offshore coordination.

Provided support to the developers and QA team in resolving the bugs that raised during the testing process and updated the specification documents if required.

Expertise in doing Specs Revamp based on the Business Priority and efficient in writing Business rules as per the Business requirements.

Actively analyzed current business process and worked with management to improve the process.

Analyzed, maintained and updated FAQ knowledge base in SharePoint for better timely data availability.

Environment: SQL Server, ASP.NET, SSIS, SSRS, Team Foundation Server, MS Visio, MS Office, Balsamiq, SharePoint

Client: HIMCO, Hartford, CT Jan 2014 – Jul 2016

Role: Business Analyst

Project Description:

The Hartford Financial Services Group, Inc., usually known as The Hartford, is a United States-based investment and insurance company that is part of the Fortune 500 list located in Hartford, Connecticut. HIMCO is a wholly-owned subsidiary which manages the investment of the Hartford Financial Services Group, Inc. HIMCO project was aimed at developing ETL processes to load the target databases.

Responsibilities:

Interacted with Product Owner & Agile Development Team on documenting Scrum artifacts like Product, Release & Sprint Backlog.

Assisted in facilitating Scrum Ceremonies like Sprint Planning, Daily Scrum/Stand Up meeting, Sprint Review and Retrospective meeting.

Involved in performing competitive research and analysis, and conducting user interviews to identify specific areas for improvement and to generate ideas for future functionality upgrade.

Assisted in communicating business process and requirements to technical personnel.

Facilitated Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes and conducted meetings with the Product Owner.

Prepared Business process diagrams, State diagrams, Activity diagrams, and Sequence diagrams using Visio.

Documented the Requirement Traceability Matrix for tracing the Test Cases and requirements related to them.

Critically evaluated the information gathered from multiple sources during requirements gathering.

Interacted with the developers for resolving the bugs reported in JIRA and various technical issues related to the requirements.

Prepared UAT Test Plan for various Test Scenarios.

Conducted functional walkthroughs and User Acceptance Testing (UAT) sessions.

Assisted in creating User Manuals for customers.

Performed Back End Testing using SQL queries, generating reports to ensure data integrity and to validate the inserted and updated data.

Worked with Quality Manager to ensure Quality for all the deliverables in the project.

Environment: SQL Server, Oracle, SSIS, SSRS, Markit Enterprise Data Management (EDM), MS Visio, JIRA, MS Office, Balsamiq, SharePoint

Client: The Commerce Insurance Company, Webster, MA Aug 2011 - Dec 2013

Role: Business Analyst

Project Description:

Commerce Insurance Group is an American company that provides personal insurance, commercial property insurance, and casualty insurance in Massachusetts and New Hampshire. Their core product lines include personal automobile, homeowners, and commercial automobile insurance.

The project was aimed at developing the UI for insurance claims and also ETL processes to load the target databases to populate the insurance claim's transactions like automobile coverage and personal losses. Further, Business Intelligence reports were also generated.

Responsibilities:

Conducted SWOT Analysis for better market understanding and project implementation.

Documented user stories and modeled Use Case diagrams by utilizing MS Visio.

Performed Gap Analysis to check the compatibility of the existing system with the new business requirements.

Participated and facilitated meetings with business and Subject Matter Experts (SMEs) to capture the high level function points and business practices.

Interacted with Claims team for analysis and documentation.

Created a product roadmap for the various stages and releases throughout the project lifecycle.

Provided analytical support in the Design, Development and Implementation of Project.

Created Use Case diagrams, Activity diagrams, and Sequence diagrams by using MS Visio.

Documented Requirement Traceability Matrix (RTM) to check the completion of current project requirements.

Created wireframes for the user interface and provided the same to GUI design team.

Verified the Business Scenarios on new builds to allow testing by the QA team.

Reviewed and approved Test Scenarios and Test Cases based on user stories.

Actively conducted and participated in weekly meetings to analyze the progress and to maintain status reports.

Performed Back End Testing using SQL queries, generating reports to ensure data integrity and to validate the inserted and updated data.

Prepared UAT Test Plan for various Test Scenarios and assisted in User Acceptance Testing.

Environment: SQL Server, HTML, Java, Balsamiq, JIRA, MS Visio, MS Office, SSRS, SSIS, Sharepoint

Contact this candidate