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 wif 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 teh various stages.
• Well acquainted wif 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,) wif 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 teh 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 wif and breaking-down of epics into User Stories (INVEST format) and handling teh 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 wif Architects and Developers to create Conceptual and Logical Models
• Development and Maintenance of documentation using teh 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 wif conducting usability studies for teh 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.
• Reviewed Business Rules written for middle tier and validated XML schema for system data documentation including teh requirement data document.
• Extensive knowledge of Data Warehousing architecture, implementation approaches, schemas, and dimensional modeling. Performed ETL using Informatica to load data into teh 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 teh 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 teh business needs.
• Excellent problem solving, team building, judgment and decision making skills coupled wif good verbal, communication and interpersonal skills.

TECHNICAL SKILLS

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

PROFESSIONAL EXPERIENCE

Confidential - San Jose, CA

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 wif small as well as large groups of stakeholders.
• Gatheird 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 teh Product Owner to prioritize teh Product backlog items (PBI’s) for developing Sprint tasks by taking suggestions from teh cross-functional development team.
• Facilitated teh 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 teh track of teh team’s progress and teh team’s velocity for better estimation of teh 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 wif 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 teh quality assurance testing and ensured dat business requirements were being addressed in teh test plans.
• Planned teh UAT testing, test plans, test cases and worked wif teh business users for UAT test execution.
• Performed Functionality, Integration, GUI, Regression, Usability and System testing.
• Coordinated wif teh 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

Business system analyst/ Scrum Master

Responsibilities:

• Analyzed teh requirement and functional specification document.
• Identified teh timelines, deliverables and resources available to create a detailed Work Breakdown Structure using MS Project and Responsibility Matrix (RACI).
• Supported teh 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 teh end users by managing requirement workshops and interview sessions wif key stakeholders and SMEs.
• Conducted JAD sessions and interviews wif key stakeholders and SME’s for requirements gathering.
• Monitored seamless data integration of extracted and transformed data in batches for further loading in teh 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 wif teh achieving teh 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 wif teh Software Quality Assurance (SQA) Team to develop Test plans.
• Executed Test Cases. And logged teh defects for failed test cases.
• Played a key role in teh planning User Accepted Testing and implementation of system enhancements and conversions.
• Oversaw data mapping and modelling to ensure fields get populated wif 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 teh design, development, unit testing, and implementation phases of teh 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

Responsibilities:

• Involved in all phases of software development life cycle SDLC.
• Analyzed and collected business requirements, identified system interfaces and created teh requirements specification document Using HPQC.
• Applied and acquired Risk Analysis strategies for teh 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 teh data also involved in Data Migration.
• Created Data Models wif 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 wif teh Business owners & stakeholders and document analysis.
• Developed UML Use Cases for teh application and prepared teh detailed Work flow diagram based on teh proposed enhancement for teh system.
• Functioned as teh primary liaison between teh business line, operations, and teh technical areas throughout teh 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 teh requirements by using Waterfall as System Development life cycle (SDLC).
• Facilitated JAD Sessions and One on One session wif SME, stakeholders to obtain their perspectives, resolve any issues and come to an agreement.
• Prepared Business Process models, defined present state flows dat cover “AS-IS” then defined teh future state dat covers “TO-BE” diagram based on teh 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 teh System.
• Involved in designing database schema and creating Entity Relationship (ER) Diagrams to teh proposed database.
• Analyzed and Designed teh Data model using Star Schema model wif Facts and Dimension Tables
• Used Web Services to connect teh services to teh 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 wif 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 wif teh QA team for designing Test Plan, Test Cases and Requirement Traceability Matrix for teh User Acceptance Testing (UAT) and regression testing.
• Used Microsoft Project to manage schedules, deadlines, resources and collaborate on teh 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 teh requirements elicitation.
• Defined metrics to be tracked for ingestion.
• Organized and Conducted reviews and Inspections wif SME’s on teh requirements
• Document project related artifacts like BRD and FSD
• Assign tasks to teh team keeping in mind teh complexity and priority of teh tasks.
• Provide tasks based reports to teh Manager andevaluate team SLA (Service Level Agreements) on weekly and monthly basis
• Teh 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 teh business process and framed teh operational risks and created workflows.
• Worked wif 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 teh 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 dat contains test scripts, test cases, test data and expected results for teh Integration, Functional, Performance, and User Acceptance Testing.
• Assign tasks to teh team members keeping in mind teh complexity and priority of teh 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 teh team and keeping teh 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 teh Daily SCRUM meeting.
• Involved in requirement scoping and identifying high priority requirements for implementation wif teh insights from teh self -organizing development team and teh product owner.
• Worked wif Project manager to estimate teh user stories using T-shirt sizing, poker planning, INVEST Techniques.
• Strongly served and supported teh 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 wifin teh 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 teh target data-mart in IBM Cognos, theirby 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 teh severity of teh service requests and halped in solving many complicated issues.
• Involved in writing teh use case templates.
• Involved in gathering teh requirements, analyzing and documenting teh 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 teh 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 teh HP Quality Center/HP ALM for logging, tracking and reporting bugs in teh application.
• Communicated extensively wif teh 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.