SUMMARY:

• 8+ years of experience working as a Business Systems Analyst/ Sr. Business Analyst and Scrum master, from conceptualization to implementation with experience in requirements gathering, documentation,
• Proven skills in gathering, analyzing and creating Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• In - depth knowledge of SDLC (Software Development Life Cycle) and development practices (ranging from traditional to Agile). Thorough understanding of RUP, SCRUM and the various stages.
• Well acquainted with Workflows and (UML) (Unified Modeling Language) diagrams such as, Use case diagrams, activity diagrams and Sequence diagrams.
• Organized and felicitated requirement gathering sessions (JAD, Brainstorming, Prototyping, Interviews, Requirement Workshops, Survey/Questionnaire,) with End users, Project managers, subject matter experts (SME’s), Stake holders.
• Experience in end-to-end testing, UAT (User Acceptance Test), Smoke Testing, Unit testing and integration testing.
• Worked extensively throughout the development process and also verifying their adherence to Requirement Traceability Matrix (RTM). Highly involved in Eliciting Requirements, Impact Analysis, Cause and Effect, GAP Analysis, As-Is and To-Be Analysis, Cost Benefit Analysis, Risk Assessment, ROI Analysis and SWOT Analysis.
• Proficient with and breaking-down of epics into User Stories (INVEST format) and handling the Requirements Churn. Efficiently performed prioritization & estimation techniques such as Planning Poker, T-Shirt Sizing, Moscow and KANO Analysis.
• Well versed in facilitating Sprint ceremonies (Sprint Planning, Daily Scrum, Sprint Review, Sprint Retrospective and Backlog Grooming)
• Performed Data Modeling with Architects and Developers to create Conceptual and Logical Models
• Development and Maintenance of documentation using the organizational templates according to established company guidelines using MS Office Tools including MS Visio and MS Project.
• Expertise in User Interface Design through wireframes and mock-ups. Familiar with conducting usability studies for the purpose of user interface and layout improvements.
• Sound knowledge of test management tool HP Quality Center, HP Application Lifecycle Management.
• Used SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases (SQL Server) for timely reporting and Validation. knowledge of Data Warehousing architecture, implementation approaches, schemas, and dimensional modeling. Performed ETL using Informatica to load data into the data warehouse from various disparate sources.
• Very good understanding of Database concepts like Data Warehousing, Data Structures, Schemas, Data Marts, Data-Entity relationships.
• Performed ETL using Informatica to load data into the data warehouse from various disparate sources. Knowledge of OLAP cubes and performing operations such as Roll-up, Drill-down, Slice, Dice and Pivot and designing and deploying reports via Tableau and IBM Cognos.
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
• Experienced in coordinating activities between business unit and technical staff, developing new methods, policies, and procedures to meet the business needs.
• Excellent problem solving, team building, judgment and decision making skills coupled with good verbal, communication and interpersonal skills.

TECHNICAL SKILLS:

Operating Systems: Windows XP, Vista, 7,8,10, Mac OS, Linux, UNIX

Languages: SQL, HTML, XML, C++, .NET, JAVA

Business modelling tools: M.S Visio, rational rose, Mockup Screens

Requirement management tools: JIRA, Version one, MS Office, HP ALM. Rational Clear Quest, Rally.

Data modelling tools: M.S project, Visio, Rational rose.

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, Slicing/Dicing, Drilldown/ Roll Up.

Database: MYSQL, Oracle

SDLC Methodologies: Waterfall, Agile-Scrum, Rational Unified Process (RUP), Waterfall-Scrum Hybrid.

Testing Tools: HPQC, HP ALM, Rational Clear Quest, Load runner.

Business Intelligence Tools: Tableau, SAS, Business Objects, IBM Cognos.

Project management tools: M.S project, M.S excel, MS SharePoint

Others: Informatica, SSIS, SSRS, SSAS, Business Objects.

WORK EXPERIENCE:

Confidential, Boise, ID

Business Process Analyst/ Scrum Master

Responsibilities: -

• Worked as a liaison between business team and development team for transforming requirements into user stories and converting them into features.
• Gathered and documented requirements in the form of backlogs using JIRA
• Prepared wireframes and prototypes of the features using Visio to help the Technical team to understand the requirements.
• Worked as an Agile coach and trained Project team over Agile methodologies and how to implement them in software development.
• Involved in Prioritizing and estimating the backlogs using T-shirt sizing and Planning Poker techniques.
• Conducted Sprint Planning, Daily Sprint, Sprint review, Sprint grooming and Sprint retrospective meeting during every sprint.
• Maintained Sprint burndown charts to monitor the sprints progress.
• Created Backlogs into Sub-Tasks for monitoring step by step progress of team’s work.
• Implemented new strategies in development to improve code quality standards.
• Worked closely with business team to ensure the audit requirements are met.
• Performed Integration, functional and Smoke testing.
• Prepared Test plan, Test cases and Test Scenarios for performing UAT testing.
• Worked Closely with Business Team for Changes in Requirements. Also Handled Release Fixes and Hot fixes occurred during UAT Testing.
• Used SQL for analyzing the data.
• Monitored and considered Issues occurred with the team during the sprints during retrospectives for continues development.

Environment: - MS Office, MS Visio, Share Point, JIRA, OneNote, Jenkins, HTML, XML, Java, Apache Tomcat, JScript/JQuery, Eclipse, Sonar Cube, Oxygen.

Sr. Business Analyst/Scrum master

Responsibilities: -

• Proficiently defined scope of projects based on ­­gathering Business Requirements including Documentation through interviews, requirement gathering sessions and meeting with small as well as large groups of stakeholders.
• Helped the Product Owner to prioritize the Product backlog items (PBI’s) for developing Sprint tasks by taking suggestions from the cross-functional development team.
• Facilitated the Sprint Planning Meeting, Daily SCRUM, Sprint Review Meeting, Sprint Retrospective Meeting, and Product Backlog Refinement Meeting.
• Created and maintained Sprint Burn-down Chart, Sprint Burn-up Chart and Product Burn-Down Chart to keep the track of the team’s progress and the team’s velocity for better estimation of the sprint life cycle.
• Estimated user stories by breaking down Epics into themes using Relative mass validation, T-shirt sizing, INVEST.
• Performed business process analysis like data analysis and GAP analysis.
• Conducted JAD sessions with management, SME, vendors and other stakeholders.
• Prepared graphical depictions of sequence diagrams, use case diagrams and wire frames using (UML) and (Mockup screens).
• Concisely and effectively communicated business requirements to developers also created sample web pages using Mockup screens.
• Developed Business Process Work Flows and Functional Diagrams using (MS Visio).
• Supported the quality assurance testing and ensured that business requirements were being addressed in the test plans.
• Planned the UAT testing, test plans, test cases and worked with the business users for UAT test execution.
• Performed Functionality, Integration, GUI, Regression, Usability and System testing .
• Coordinated with the project team and testing team to revise project artifacts (use-cases, website specifications, test scripts) to reflect requirement changes.

Environment: - Wireframes, MS Office, MS Visio, Share Point, UML, JIRA, HP QC v 11.0, Tableau, Oracle SQL 2008, Web Services, SOA, HTML, XML, Java, Apache Tomcat, JScript/JQuery, Eclipse.

Business system analyst/ Scrum Master

Responsibilities:

• Analyzed the requirement and functional specification document.
• Identified the timelines, deliverables and resources available to create a detailed Work Breakdown Structure using MS Project and Responsibility Matrix (RACI).
• Supported the Business Analysts to elicit business requirements in terms of data stream - upstream data type and sources, business rules and logics and downstream executive reports for the end users by managing requirement workshops and interview sessions with key stakeholders and SMEs.
• Conducted JAD sessions and interviews with key stakeholders and SME’s for requirements gathering.
• Monitored seamless data integration of extracted and transformed data in batches for further loading in the MS SQL Server database.
• Performed Impact Analysis, Feasibility Study, Cost-Benefit Analysis and Return on Investment (ROI)in order to mitigate and document risks associated with the achieving the project objectives.
• Prepared scenarios, use cases.
• Created user stories, and prioritized them using Moscow, KANO etc., process flow diagrams, sequence diagrams, and collaboration diagrams. Generated use-case diagrams using UML.
• Involved with the Software Quality Assurance (SQA) Team to develop Test plans.
• Played a key role in the planning User Accepted Testing and implementation of system enhancements and conversions.
• Oversaw data mapping and modelling to ensure fields get populated with accurate entries during enhancements.
• Formulated SQL Queries to generate relevant report from Data Warehouse
• Created test plans, test cases using HP QC.
• Identified and clearly defined functional issues and support IT development staff throughout the design, development, unit testing, and implementation phases of the software development life cycle.

Environment: Agile-Scrum, MS Visio, MS Office Suite, UML, Windows XP, Test Director, MS Project. JIRA, Java, Java Script, HTML, XML, Content management Angular JS, Informatica, Oracle DB, Hibernate, Tableau, Web Services, PL/SQL,

Business system analyst

Responsibilities:

• Involved in all phases of software development life cycle SDLC.
• Analyzed and collected business requirements, identified system interfaces and created the requirements specification document Using HPQC.
• Applied and acquired Risk Analysis strategies for the assigned projects.
• Tested data warehouse ETL process using SSIS (Integration Service).
• Held responsibility for creating business flow diagrams and charts using MS Visio.
• Used Unified Modeling Language (UML) to design Communication Diagram, Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
• Provided documentation such as functional requirements, test plans and test cases.
• Handled several SQL queries for manipulating the data also involved in Data Migration.
• Created Data Models with fact and dimension tables using snow-flake schema.
• Designed and analyzed Business Process Model, Use Case model and test procedures based on Agile-waterfall methodology using Rational Rose.
• Performed requirement analysis by gathering both functional and non-functional. requirements based on interactions with the Business owners & stakeholders and document analysis.
• Developed UML Use Cases for the application and prepared the detailed Work flow diagram based on the proposed enhancement for the system.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project life cycle.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Created test cases and test scripts Conducted User Acceptance Testing (UAT), Unit testing and System testing.

Environment: Waterfall-Agile Hybrid, MS Project, Visio, HPQC, ASP framework, MYSQL, SharePoint.

Business analyst

Responsibilities:

• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, UML and Business Process Modeling
• Conducting user interviews, gathering requirements, analyzing the requirements by using Waterfall as System Development life cycle (SDLC).
• Facilitated JAD Sessions and One on One session with SME, stakeholders to obtain their perspectives, resolve any issues and come to an agreement.
• Prepared Business Process models, defined present state flows that cover “AS-IS” then defined the future state that covers “TO-BE” diagram based on the requirements. Defined GAPs between AS-IS and To-BE models.
• Created Use-Case Models using (Visio) to depict Actors and Use-Cases in various Business Processes and identification of Basic/Alternative flows and definition of preconditions and post conditions of the System.
• Involved in designing database schema and creating Entity Relationship (ER) Diagrams to the proposed database.
• Analyzed and Designed the Data model using Star Schema model with Facts and Dimension Tables
• Used Web Services to connect the services to the existing system.
• Appreciative knowledge of ETL processing and in handling data manipulation, mapping, and database tasks.
• Implemented basic SQL queries for QA testing and report / data validation.
• Handled SQL server Administration and Data Migration.
• Extensive experience working with SQL Tables and Data, Indexes, Views, Functions and Triggers.
• Converted columns definitions - data types, default values, NOT NULL constraints and identity properties.
• Assisted Project Teams in preparing Software Requirement Specifications (SRS), User Interface Design, designing of Application Architecture & Database Modeling.
• Worked with the QA team for designing Test Plan, Test Cases and Requirement Traceability Matrix for the User Acceptance Testing (UAT) and regression testing.
• Used Confidential Project to manage schedules, deadlines, resources and collaborate on the project.

Environment: MS Visio, MS Project, Share Point, IBM Cognos, Mock-Up Screens, Waterfall-Scrum Hybrid, MS Office, GAP analysis, Oracle BI Publisher, UML, UAT Testing.

Business Systems Analyst

Responsibilities:

• Analyzed provider data and prepare Analysis documents
• Conducted user interviews and JAD Sessions as a part of the requirements elicitation.
• Defined metrics to be tracked for ingestion.
• Organized and Conducted reviews and Inspections with SME’s on the requirements
• Document project related artifacts like BRD and FSD
• Assign tasks to the team keeping in mind the complexity and priority of the tasks.
• Provide tasks based reports to the Manager and evaluate team SLA (Service Level Agreements) on weekly and monthly basis
• 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.
• Analyzed the business process and framed the operational risks and created workflows.
• Worked with database schemas.
• Worked in Three-tier architecture, Web Services (SOAP, WSDL), Client Side Validation and Server Side Validations for enhanced understanding of business functionality.
• Provide project leadership to the development team, schedule control, status reporting, client/project team coordination and quality assurance.
• Providing service specific expertise for Data, Foundation specifications.
• Used HP Quality Center for creating and executing test cases, for defect tracking and for generating reports.
• Documented Test Plans that contains test scripts, test cases, test data and expected results for the Integration, Functional, Performance, and User Acceptance Testing.
• Assign tasks to the team members keeping in mind the complexity and priority of the tasks.

Environment: JAVA, Clarity Work Bench, Rational RequisitePro, MS Office 2007, MS Visio, HTML/CSS, JavaScript, My SQL Server, HP QC, Waterfall-Scrum Hybrid.

Business Analyst

Responsibilities:

• Managing the team and keeping the team motivation and environment high so as to achieve maximum efficiency and productivity.
• Performed Impact Analysis of Requirement Churns for checking feasibility and discussed them during the Daily SCRUM meeting.
• Involved in requirement scoping and identifying high priority requirements for implementation with the insights from the self -organizing development team and the product owner.
• Worked with Project manager to estimate the user stories using T-shirt sizing, poker planning, INVEST Techniques.
• Strongly served and supported the Product Owner and Engineering Team in their quest to do everything possible to delight customers.
• Conducted detailed risk assessments by analyzing documents, statistics, reports and market trends.
• Created ad-hoc reports to users in Tableau by connecting various data sources.
• Takes responsibility for managing dependencies within the sprint team as well as those dependencies from other development or operations teams.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Used ETL Process using Informatica to map data from different sources to the target data-mart in IBM Cognos, thereby reporting and analyzing events and metrics.
• Participates in sprint estimation process.
• Communicates sprint status to stakeholders
• Maintained product backlog items, sprint backlog items and Burndown charts

Environment: Agile SCRUM, Mock-up screens, SQL Server, MS Office (MS Word, MS Excel, MS PowerPoint, and MS Visio), GAP Analysis, Data Warehouse, JIRA, Tableau, UML, and UAT Testing.

Business Analyst

Responsibilities:

• Provided 24 hours’ technical support by analyzing the severity of the service requests and helped in solving many complicated issues.
• Involved in writing the use case templates.
• Involved in gathering the requirements, analyzing and documenting the requirements
• Followed “just in time” SDLC methodology for solving service requests
• Responsible for status check at regular timeframe.
• Controlled and track defects by timely assigning to the maintenance team
• Performed SQL queries for managing database.
• Helped Testers for executing System/ Integration testing. And documented those test cases using HPQC.
• Designed screen mockups for changes in system functionality using (mockup screens).
• Executed test cases and test scripts for manual and automation testing. Defects are raised in the HP Quality Center/HP ALM for logging, tracking and reporting bugs in the application.
• Communicated extensively with the clients and front office to identify requirements and Documented functional specifications, created Use-Cases and Business Process Modeling.
• Created Activity diagrams and use case diagrams using ( Confidential Visio).

Environment: Waterfall, Oracle, PL/SQL, java script, Java, HTML/CSS, MS. Office, HPQC, Visio, UAT Testing.