SUMMARY

• 8+ years of professional work experience as Sr Business Analyst / Certified Scrum Master in financial market
• Strong experience working with different financial securities such as equities, fixed income, and derivatives with expertise in understanding of trade lifecycle from origination to settlement
• In - depth understanding of equities securities (common stock, preferred stock, rights, warrants), Confidential (corporate bonds, munis, T-Bills, T-Notes, T-Bonds, commercial paper, CDO, CMO, ABS, and MBS), and derivatives (options, futures, forwards, swaps, CDS, IRS)
• Well versed with different SDLC Environments - Waterfall, Agile SCRUM, and RAD
• Hands-on work experience in running meetings with SMEs, project stakeholders, and end users to gather, analyze, articulate, and document business requirements (BRD); transformed requirements to functional specifications and documented FRS
• Proficient in performing data mapping - capturing data requirements, identifying the source, business rules, target tables to setup the Extract, Transform and Load (ETL) process
• Extensive experience with building training documents and conducting hands-on user trainings to appropriate audience group
• Strong experience in application design using UML - Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Process Workflow Diagrams, Swim Lane Diagrams, Screen Mockups, Wireframes, Written Use Cases, and Sequence Diagrams, via Rational Rose, MS Visio
• Hands-on experience in writing SQL queries for data analysis & Report generation (Audit Trail Report, Accounts P&L, Holdings Report, Trading Data, Accounts Balance/ Cash Flow Report)
• Experience in assisting DBAs in performing data modeling - creating entity-relationship (ER) diagrams to build data models for underlying database
• Expertise in facilitating project management assignments - managing project plan, conducting review meetings, tracking project status, addressing project issues, and organizing product demos
• Proven expertise in conducting GAP analysis evaluating as-is application, defining Business Process Improvements, and incorporating those into to-be application scope
• Extensive experience in performing user interviews, JAD sessions, and documents walkthroughs with end users and stakeholders to ensure effective application development
• Strong experience in assisting QA team for documenting Test Plan, Test Scenarios, Test Cases/ Test Scripts for performing Functional Testing, Systems Testing, GUI Testing, User Acceptance Testing (UAT)
• Very good understanding and experience of the ALM and HP Quality Center software for defining, managing and tracking requirements, test cases and defects
• Well versed in managing defect lifecycle - logging defects, prioritizing, delegating to developers, and generating issues reports; and maintained Requirements Traceability Matrix (RTM)

TECHNICAL SKILLS

OS: Windows 2000/XP, Mac, UNIX, LINUX

Database: Oracle, MS SQL Server, MS Access, MySQL

Languages: SQL, Java, J2EE, .NET, C++, C, JSP, XML, JavaScript, HTML, PHP, Shell, VB Script

Testing: ALM, Quality Center, Win Runner, Load Runner, JIRA, Clear Quest, Bugzilla, QTP

Others: UML, MS Project, MS Visio, Tivoli, Autosys, OBIEE, PL/SQL, TOAD, Crystal Report, Business Objects, Cognos, Eclipse, Erwin, Rational Rose, RequisitePro

PROFESSIONAL EXPERIENCES

Confidential, DE

Scrum Master / Senior Business Analyst

Responsibilities:

• Followed Agile SCRUM methodology throughout the Software Development Lifecycle (SDLC)
• Gathered requirements from the users and product owners and created user stories to assist with the development of new features of the tool that provide support and enhancement in the business; collaborated with the stakeholders to refine functional requirements
• Supported the product owner in maintaining the product backlog and scheduling next release
• Participated in daily scrum stand ups, backlog grooming sessions, sprint planning meetings and sprint retrospective meetings
• During sprint planning session guided the development team to break down large and complex user stories into multiple simplified sub tasks foreasy development and execution
• Assisted in closing gaps for associated stories in each sprint
• Prepared the Use Case Diagrams, Screen Mock-ups, Business Workflow and Process flow Diagrams
• Prepared the test scripts and tested the user stories for accuracy and compliance to ensure acceptance and validation of stories
• Entered and updated issues in the form of epics, stories, tasks and sub tasks onto the JIRA application
• Maintained Requirements traceability matrix throughout the application development lifecycle
• Followed Agile SCRUM methodology throughout the Software Development Lifecycle (SDLC)
• Worked closely with users and product owners; understood their needs of improvement/ enhancement about the Petra tool and gathered requirements and wrote them as stories in Jira
• Worked in Agile environment, actively participated in sprint planning meeting and prioritization of product backlog with the product owners
• Participated in the planning sessions, backlog grooming sessions, the daily standup call and Sprint Retrospective meeting
• Prepared the Functional Specification document; Created UML diagrams, including use cases diagrams, activity diagrams, sequence diagrams, data flow diagrams, and webpage mock ups
• Prepared the test plan; wrote and executed Test cases/ scripts in ALM for each iteration during system testing, logged defects in ALM, assigned those defects to the responsible developer and retested them once they were fixed and closed them in ALM as well as in Jira
• Closely associated with UAT, executed test cases and logged the defects

Confidential, PA

Senior Business Analyst

Responsibilities:

• Followed Agile SCRUM methodology throughout the Software Development Lifecycle (SDLC)
• Interacted with product owners and conducted user interviews to identify the user stories for building Product Backlog (prioritized set of high-level requirements)
• Involved in documenting Business Requirements Document (BRD) capturing user requirements
• Assisted the scrum master in coordinating resources, organizing team meetings, and monitoring & tracking project deliverables
• Developed & maintained the project plan using MS Project and tracked the project progress
• Facilitated daily scrum meetings, sprint planning meetings, sprint review meetings, and sprint retrospective meetings
• Conducted data mapping to define the data source, target, transformation & validation rules to construct the ETL process and loading data into the data warehouse/datamart
• Conducted UML modeling to provide the development team with application’s graphical view - Use Case Diagrams, Activity Diagrams, Swim-lanes Diagrams, Screen Mock-ups, and Business Workflow Diagrams
• Wrote SQL queries for retrieving data from the database, generating business reports, and conducting data validation testing
• Conducted GAP analysis to analyze & document the existing process flow and proposed process flow identifying the system enhancements to meet end-state requirements
• Assisted Database team in data modeling creating ER diagrams, identifying dependencies, data attributes, and constraints to effectively meet the data requirements
• Involved with QA team for creation of Test Plan, Test Cases and conducted functional testing, integration testing, GUI testing, regression testing, and smoke testing and used Quality Center extensively for management of requirements, test cases and defects
• Facilitated the Defect Tracking Lifecycle by logging defects, prioritizing defects, developer follow-ups, and re-testing fixed defects
• Actively participated in User Acceptance Testing (UAT) to facilitate the final stage of testing process in which acceptance of the completed system is made by the end users in a simulated production environment
• Created Traceability Matrix between the Use Cases (Requirements) and Test Cases

ENVIRONMENT: MS Visio, Oracle, PL/SQL, MS Office, Erwin, Quality Center, Crystal Reports, QTP, UNIX, HTML, XML, .NET, VB Script

Confidential, NY

Senior Business Systems Analyst

Responsibilities:

• Followed RUP methodology in planning, defining problem, gathering requirements, business modeling, and communicating with technical team for application development
• Created detailed business requirements (BRD) and system requirements specifications (SRS)
• Worked closely with project manager for drafting project plan & strategies, managing release schedules, project status tracking, and coordinating resources, using MS Project
• Created UML diagrams such as Use case diagrams, Activity diagrams, Wireframes, Swim lane diagrams, Sequence diagrams, Class diagrams, and Business workflow diagrams
• Designed Screen Mock-ups to visualize the functionality of the system, break the complex system into discrete pieces to enhance transparency and capture bottlenecks in the system
• Prepared data mapping document to set-up ETL process to load data into target database tables
• Formulated & executed SQL queries for data analysis, preparing test data by interacting with database, and validating the data integrity
• Generated operational reports and statement reports through Cognos Reports and Analysis tool
• Facilitated JAD sessions by gathering major decision makers, stakeholders, and knowledge providers to conduct workflow process analysis
• Performed Functional Gap Analysis to derive requirements for existing systems enhancements where-in we identified core problem
• Assisted Database team on relational data modeling for creating conceptual, logical, and physical data model to describe entities, relationships, and integrity constraints
• Assisted QA team in developing test plan, test cases, test scripts, test summary report for functional testing, integration testing, static testing, system testing, regression testing, sanity testing, and database testing
• Documented and maintained Requirement Traceability Matrix (RTM)
• Conducted UAT by closely working with the end users and assisting them in following the execution of the user acceptance test cases

ENVIRONMENT: Java/J2EE, UNIX, UML, RequisitePro, Rational Rose, Cognos, JIRA, Management Studio, MS SQL Server

Confidential, NY

Sr. Business Analyst

Responsibilities:

• Adopted Waterfall framework for software development process
• Worked with SMEs to gather business requirements and define business rules to be incorporated in the new application
• Acted as a liaison between business users, developers, and QA team to gather & communicate requirements, investigate issues, resolve conflicts, and handle change management
• Gathered requirements by understanding & analyzing legacy system and interviewing business users
• Built Business Requirements Document (BRD) and Functional Specifications Document (FSD)
• Facilitated JAD sessions bringing together business users, IT team, and QA team in a highly focused workshop to set the road map, design development strategies, and resolve conflicts
• Performed GAP analysis to understand the existing system functionalities and required enhancements to meet the end-state system requirements
• Extensively created UML diagrams such as Use case diagrams, Activity diagrams, Sequence diagrams, Business workflow diagrams, and Mock-ups
• Wrote complex SQL queries for accessing database, retrieving data, data validation testing and generating operational and managed reports
• Extensively worked on building and maintaining source-to-target data mapping documents
• Collaborated with QA team in developing test plan, test scenarios, test cases, and test scripts; conducted black box testing, functional testing, system testing, performance testing, regression testing, smoke testing, and UAT
• Played a key role in defect tracking and management by following-up on open defects, monitoring turnaround time, prioritizing open defects, and generating daily status report
• Created and maintained Requirements Traceability Matrix throughout the development and testing process, corresponding each of the individual business requirement with the test cases
• Assisted with User Acceptance Testing (UAT) - provided the test data to the users, setup the environment, identify the test group, and managing the defect tracking lifecycle

ENVIRONMENT: Windows, Java, MS-Office, Sybase, MS Visio, Quality Center, Cognos, J2EE, MS Project, Unix, XML

Confidential, NY

Business Analyst

Responsibilities:

• Followed the Agile XP for the software development process
• Gathered requirements, interacted with the business users, developers, project manager, and SMEs to gain thorough understanding of the business process
• Modeled existing process (AS IS) and future (TO BE) process model and provided further recommendations to improve process
• Performed complex SQL queries to validate data tables, retrieve data from the database and generate profit & loss report, investment performance report, positions report using Cognos query and reporting facility
• Maintained accurate reference data and data mapping by actively communicating with data sources
• Performed data mapping activities such as capturing data requirements and source to target mappings
• Created Data Flow Diagrams in MS Visio to specify the Process Flows and Data Flows between the systems
• Conducted JAD sessions with various stakeholders to make sure that application meets the desired requirements, open issues & changes; prepared BRD and FRD
• Used the Unified Change Management (UCM) tool to maintain and track the stakeholder requested enhancements and changes
• Involved in developing test strategy and assisted in developing test plan, test case objectives, and test cases. Helped in conducting Functional, Integration, and System Testing
• Generated status reports, prioritizing & maintaining defects log using Quality center

ENVIRONMENT: .Net, MS Visio, UML, MS Office, Cognos, ERwin, UML, TOAD, MS Office, MS Project, Windows, SharePoint