SUMMARY:

• 8+ years of experience working in Banking, E - commerce projects 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 (JRP, 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), Black box, Unit testing and integration testing.
• Worked extensively throughout the development process and 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).
• Met the Acceptance criteria’s and achieved the Definition of Done (DOD) to satisfy business owners.
• 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 user interface and layout improvements.
• Sound knowledge of test management tool HP Quality Center, HP Application Lifecycle Management.
• Used SQL for Querying data from Databases.
• Reviewed Business Rules written for middle tier and validated XML schema for system data documentation including the requirement data document.
• Extensive 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.
• Experience in Data Analysis, Data Mapping, Data Modeling, Entity Relationship Diagram, Normalization, understanding of Legacy DBMS, Relational DBMS, Object-Oriented DBMS, Multidimensional DBMS.
• 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.
• Use SAS/SPSS to access and modify databases to acquire information.
• Understanding of current Risk management tools and techniques.
• 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.

AREAS OF EXPERTISE:

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

Languages: SQL, HTML, XML

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

Requirement management tools: JIRA, Version one, MS Office, HP ALM 11.5, 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 9i and 10g(PL/SQL)

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

Testing Tools: HPQC, HP ALM, Rational Clear Quest, Load Runner

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

Other tools: Tableau, Informatica, IBM Cognos, Data Stage, SSIS, SSRS, SSAS, Business Objects, Web Methods, MS Office Suite, MS SQL Server

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.
• Followed the SCRUM methodology for 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.
• Helped Team by providing the development environments necessary before every sprint.
• Experience with various ETL, data warehousing tools and concepts
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• 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 production issues 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.

Confidential, San Jose, CA

Business system 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.
• Gathered and documented requirements using (JIRA) resulting in detailed business rules, functional requirements and process design.
• Used (SDLC) experience including Analysis, design and testing implemented agile methodologies
• 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: Hybrid Scrum, Wireframes, MS Office, MS Visio, Share Point, UML, JIRA 6.3, HP QC v 11.0, Tableau, Informatica, Oracle SQL 2008, Web Services, SOA, HTML, XML, Java, Apache Tomcat, JScript/JQuery, Eclipse.

Confidential, New York, Buffalo

Sr. Business 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.
• Facilitated the Sprint Planning Meeting, Daily SCRUM, Sprint Review Meeting, Sprint Retrospective Meeting, and Product Backlog Refinement Meeting.
• 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.
• Executed Test Cases. And logged the defects for failed test cases.
• 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, PC/E (Pro Classic Enterprise), Clear2Pay bridge tool & Ascert Versa.

Confidential, Baltimore, Maryland

Business system analyst / Scrum Master

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.

Confidential, Las Vegas, NV

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 Microsoft 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.

Confidential

Business Systems Analyst

Responsibilities:

• Analyzedprovider 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 andevaluate 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 Requisite Pro, MS Office 2007, MS Visio, HTML/CSS, JavaScript, My SQL Server, HP QC, Waterfall-Scrum Hybrid.

Confidential

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.
• Participated in sprint estimation process. And Communicated 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.

Confidential

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 (Microsoft Visio).

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