SUMMARY:

• Over 9 years of professional experience as a Business Analyst with expertise in understanding, analyzing, and documenting Business Requirements, Functional Specifications, Business Process flow, Business Process Mapping, and Modeling.
• Worked in all phases of Software Development Life Cycle (SDLC), such as Waterfall, Rapid Prototyping, RUP (Rational Unified Process) and Agile Programming Methodology (such as Scrum).
• Acquired extensive knowledge on end to end flow of loan origination system used in Mortgage Industry.
• Worked on industry standard systems in Mortgages like LPS, MSP, LOS, Foreclosure management etc.
• Supported the Front Office and Middle Office teams in Equities, Fixed Income and Derivatives trading.
• Interacting with business users and executives to identify information needs, gather Functional Requirements, Technical Requirements and Non - functional requirements.
• Preparing Business Requirement Documents (BRD), Use Case Diagrams, Use case scenarios, Activity Diagrams, and Sequence Diagrams using UML modeling.
• Conducting Joint Application Design (JAD) sessions, interviews, workshops and requirement elicitation sessions with end-users, clients, stakeholders and development team.
• Creating Business Context Diagrams, Work Flow Diagrams and Implementation Checklists
• Using MS Project to manage schedules, deadlines, and resources
• Created Requirements Traceability Matrix
• Work with Remedy tool to monitor the closure of any bugs raised by end user
• Organized weekly Project Status and Task Review meetings
• Created PowerPoint presentations and project updates using MS Project for management review
• Developing Test Cases from Use Cases, reviewing Test Plans to ensure Use Cases accurately reflect Functional and User Interface testing. Used QC, QTP and TD
• Willingness to learn new concepts and ability to articulate alternative solutions and reasoning behind the alternatives
• Demonstrated skills in managing relationships with key clients, understanding their marketing plans and budgets and developing customized pitches/ proposal.
• Worked closely with the QA team, knowledge about the testing principles.
• Excellent oral and written communication skills, interpersonal skills, and analytical skills and experience of working in high pressure environments
• Very detail-oriented team player with an ability to work in time-sensitive environments.

TECHNICAL SKILLS:

Databases & Tools: MS SQL Server 2000, MS Access, Toad and Oracle 9i

Project Management: Microsoft Project, Microsoft Office, MS PowerPoint, MS Visio

Quality Management: Quick Test Professional, Test Director, Load Runner, Quality Center

Methodologies/ Frame work: Rational Unified Process (Rational Rose, Requisite Pro, Clear Case, and Clear Quest), Data Modeling, Business Modeling, Business Intelligence solutions, UML, Use Case Diagrams, State Machine Diagrams, Sequence Diagrams, Activity Diagrams and Class Diagrams

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

Responsibilities:

• Worked with in third party COTS application CompassPoint and Aladdin which were used in Capitals Markets for managing collateral, hedging, creating pools/securities and trading.
• Developed the current pricing process (Best Execution) and determined the system and process changes required to make it aligned with the industry standards.
• Verified the mapping of loan/disclosures attributes that are needed for determining the eligibility of the loans using Oracle rule engine, pooling and disclosure in SQL.
• Implementation of Aladdin trading system to replace STAMPS trading system which enabled real-time trade reconciliation.
• Created data mapping documents to capture the mapping between legacy and target state data bases.
• Wrote SQL queries to verify that the credit and MBS trades are reflected correctly in the data base.
• Worked with underwriting and servicing reporting teams to review the loan attributes for eligibility and disclosures and investigated the anomalies using SQL and Excel.
• Supported the market risk reporting team by providing the PnL and making sure that high quality data is being sent to the risk management systems.
• Worked with the traders to evaluate and monitor market risk for daily risk production and analyze impact of market changes and alternate courses of action, and evaluate market moves affecting the portfolio position, using SQL.
• Provided issue resolution for any complications/problems that may arise, trade error and correction, reporting and monitoring the trade allocations by reviewing the data from Aladdin.
• Supported traders with the Mortgage securitization and trading process in Aladdin.
• Compared the trade data from Aladdin with multiple tables and legacy systems.
• Worked with front, middle and back office to verify the trade processing and allocation of pools/collateral.
• Worked with stakeholders to create business requirements through to system level Functional, Data and Technical Specifications
• Facilitated business and IT stakeholder discussions and consensus regarding business process workflow designs.
• Create data flow diagrams, data analysis, and Process flow diagrams required for clearing of MBS and listing of these derivatives instruments.
• Facilitated JAD sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business personnel and technical personnel.
• Participating in the manual UAT testing and preparation of testing reports using HP Quality Centre
• Reviewed Test Cases, Test Scripts, Test procedure, Test data and expected results for the system testing of the application.
• Prepared Use Case Scenarios, mockups, prototypes, swim lane diagrams, Data Models using MS Visio.

Environment: MS PowerPoint, MS Word, MS-Visio, MS Excel, SQL, MS SharePoint, HP Quality Center, Rally, TOAD, CompassPoint, Aladdin

Business Analyst

Responsibilities:

• Interviewed product owners and managers to gather information, understand the users need, define requirements, Business Requirements Document, Functional and Non-Functional Requirements and develop specifications.
• Met with stakeholders to gather and analyze reporting requirements and formulate Business Rules for Securities Transaction, position and sales Reporting of various trades TDA Institutional group as part of the Eagle PACE Data Warehouse Initiative with BI Tool Oracle Business Intelligence Suite (OBIEE) as the front end reporting tool
• Performed Mutual Fund Structure analysis to identify gaps in Eagle PACE for establishing
• Mapped the data from multiple custodians to the dashboard.
• Assisted senior managers, developers and other internal groups in transferring from an outdated securities platform to the new proprietary model.
• Frequent use of SQL to pull/query varied security data, provide onboarding groups requested information, and ad-hoc managerial requests
• Coordinated with developers/programmers to implement new additions to the Security Master, fix bugs and identify miscellaneous issues with the system.
• Created wireframes for customizable user interface of the Salesforce dashboard.
• Verified the data required for generating reports to advisors and their clients on the performance of their portfolio.
• Mapped end to end process of trading on equities / Equity Derivatives, back-office processing, and especially Prime Brokerage, Margin, Collateral and Financing
• Facilitated JAD sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business personnel and technical personnel.
• Provided daily changes in the PnL and portfolio analytics using QlikView
• Conducted GAP analysis for training purposes between existing application and after integration of the new one.
• Documented BPM (Business Process Modeling) following industry standard UML using tools such as IBM Rational.
• Developed reports using Power BI and created dashboards for sales/commission data.
• Extensively worked with the On-site Quality Assurance Groups by assisting the QA team.
• Identified the defects during the testing phase and logged defects in Quality Center.

Environment: MS PowerPoint, MS Word, MS-Visio, MS Excel, SQL, MS SharePoint, HP Quality Center, JIRA, Clarity PPM

Business Analyst

Responsibilities:

• Strategized project scoping and specifications documents, to clearly communicate the project roadmap.
• Interviewed client employees to gather information, understand the users need, define requirements, Business Requirements Document, Functional and Non Functional Requirements and develop specifications.
• Facilitated JAD sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business personnel and technical personnel.
• Conducted GAP analysis for training purposes between existing application and after integration of the new one.
• Conducted functional walkthroughs, User Acceptance Testing (UAT) session, ensured project was in compliance with the policies and regulations, and assisted the development of User Guides and SOP Manuals for customers. Prepared Use Case Scenarios, mockups, prototypes, swim lane diagrams, Data Models using MS Visio.
• Organizing weekly Project status meetings with business users and updating project plan and status reports
• Set-up and Coordinate Onsite teams, Conduct Knowledge Transfer sessions to the team.
• Extensively worked with the On-site Quality Assurance Groups by assisting the QA team.
• Project tracking and Status Reporting to business users/management.

Environment: MS PowerPoint, MS Word, MS-Visio, MS Excel, SQL, MS SharePoint, HP Quality Center

Business Analyst

Responsibilities:

• Designed the business requirement collection approach based on the project scope and Rational Unified Process (RUP) Methodology.
• Created and reviewed Business Requirements Documentation (BRD), Functional Requirement Specifications (FRS), and Use Cases that supported the overall business objective.
• Extensive knowledge of Mortgage processing, and closing procedures.
• Gathered Business Requirements after conducting Joint Application Development (JAD) sessions and Interviews with business users and other stakeholders.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Designed and developed Use Cases, Process Flow, and Activity Diagrams using UML.
• Documented and delivered Functional Specification Document to the project team.
• Using detailed knowledge of application features and functions assess scope and impact of business needs throughout analysis and completion of all enhancement specifications.
• Worked with QA team to defining Defects during the process.
• Develop the Test Plan, Test Scenario and Test Cases to be used in testing based on business requirements and performed the User Acceptance Testing (UAT).
• Communicate with the PM and business stakeholders to assure the business needs are met.
• Maintained Traceability Matrix among requirements, test cases and change requests.

Environment: Microsoft .NET platform, SQL Server, Test director, UML, RUP, Excel.

Business Analyst

Responsibilities:

• Analyzed the existing system and business process flow by understanding preset business rules and conditions
• Worked with data flow diagrams, data analysis, and Process flow diagrams
• Facilitate and managed the meeting, interviews with SMEs from various areas
• Conduct interviews with key business users and used other fact finding techniques to collect requirements and business process information
• Conducted surveys and brainstorming sessions with SMEs for requirement gathering
• Performed extensive requirement analysis including data analysis and gap analysis
• Designed and developed different project development documents based on SDLC methodology
• Assisted in creating the project templates for Use case specification, Change request form, functional specification documents and Business Requirement documents and Defect status form
• Worked actively in the preparation of Business Requirement Documents, Functional Specification Documents and Change Request Documents
• Designed and developed Use Cases and many other UML models using Microsoft Visio
• Worked closely with QA teams to define test cases and execute test plans
• Involved with the technical teams during implementation such that right business requirements are being translated into the system
• Assisted the project managers in feasibility analysis-schedule, technical, economical and operational feasibility.
• Assisted the technical team in defining the candidate system matrix and feasibility matrix
• Worked closely with project manager to assist him with project plans, budgeting, scope creep and feature creep

Environment: MS Visio, MS Office Suite, Test Director, UML, Windows XP, Test Director, MS Project

Business Analyst

Responsibilities:

• Established the business analysis methodology using Agile (Scrum) Methodology.
• Analyzed requirements and documented as Business Requirement document (BRD) and detailed the Functional Requirement Document (FRD)
• Worked with the business unit to define Business Requirements and analyze the possible technical solutions.
• Responsibilities included requirement gathering, Business Process Flow, and business analysis.
• Facilitated Joint Application Development (JAD) and Interviews sessions with SME’s and stakeholders’ for gathering the requirement of Mortgage Application.
• Performed Feasibility and adaptability study to identify the business critical areas from User perspective.
• Designed and developed Process Flow and Activity Diagrams based on UML standard.
• Worked with the design team to create the Mock-ups screen for the system.
• Involved in performing GAP Analysis by identifying existing technologies and documenting enhancements to meet end state requirements.
• Assisted QA team in designing Test Plans, Test Scenarios and Test Case for Integration, Regression and User Acceptance Testing (UAT) to improve overall quality of the application.
• Organized cross training of team members and users to become more responsive.

Environment: Rational Rose, Agile, UML, SQL, MS-Office, MS Project, MS Visio