Professional Summary

• Over 8 years of experience as a Senior Business Analyst with Banking Financial Services domain.
• Experience with Money Markets, Interest Rate Derivatives, and Mortgage-backed securities, Equity, Total Return Swaps, Equity Derivatives and Fixed Income
• Comprehensive knowledge of both manual and automatic underwriting guidelines and restrictions for conventional and government-insured loan programs for both conforming and nonconforming mortgages.
• Experienced in identifying at risk loans for modifications, Record and maintain the full history of each loan change and repayment structure at loans.
• Proficient in using the mortgage documentation for validation Uniform Residential Loan Application 1003 , Property Inspection Report, Residential Appraisal Report 1004 , Income documentation Paystubs, w2, 1099 , Bank Statements, Investment Statements, Tax forms, TIL, Amortization Schedule, Title work, Good Faith Estimate GFE .
• Excellent knowledge of Fund Accounting Portfolio NAV Accounting , Anti-Money Laundering, OFAC and Customer Identification Program KYC/CIP , Basel II compliance using industry standards and regulatory guidance.
• Proficient in Data Analysis, Requirement Analysis, Business Modeling, and use case development using UML methodology, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams, Wireframe prototypes and documenting them using Microsoft Visio.
• Experienced in various Software Development Life Cycle SDLC Methodologies including Agile, Waterfall and RUP.
• Experienced in writing documents like Business Requirements, Functional Requirements.
• Proficient in creating mapping spreadsheets, Source to Target mapping documents including the transformation rules.
• Proficient in facilitating management, developers, QAs, stakeholders, business users and off-site teams in JADs, Brainstorm sessions and WebEx.
• Experience in database modeling and development of Entity Relationship Diagrams ERD , SQL, Data migration, Data mapping, ETL, and reporting process.
• Experience in Test development testing methodologies for User Acceptance Testing UAT , System Integration testing SIT and documenting test results.
• Assisted QA team in different phases of testing such as System testing, Functional testing, Regression testing and Integration testing for Quality Analysis.
• Strong team builder and leader with excellent systematic and communication skills with ability to handle new technologies and situations, committed to meet deadlines and provide necessary deliverable and solve issues creatively by out of the box thinking.
• Experience in writing SQL queries for the data validation exercises using Oracle SQL Plus and TOAD.
• Great interpersonal skills and the ability to deal with all levels of business users and management.

Business/Technical Skill

MS Office Excel, Word, PowerPoint, Project, Visio, Access, Publisher, FrontPage, Outlook , MS SharePoint 2007, Lotus Notes. Industry Standards: ISO, Six Sigma, CMM, HIPAA, Windows NT/2000/XP, Linux. Testing Tools: Quality Center, Load Runner, Quick Test Pro QTP , JIRA, TOAD, Quality Center, Rational Requisite Pro, Rational Rose, Rational ClearQuest, SQL, RUP, Agile, Waterfall

Confidential

Role: Senior Business Analyst/Scrum Master

The goal of the project was to make improvements to management dashboard to assist managers and staffs to centralize workflow, document storage retrieval and also by giving access to clients to manage funds, reports and maintain fund information. Management Dashboard is a web-based application that provides a range of tools to assist managers and staffs to centralize workflow, division information, and document storage retrieval. AIS Dashboard provides various functionalities for different departments like Client Services, Portfolio NAV Accounting, and Investor Services in the form of applications. Portfolio Accounting NAV Accounting Checklists, NAV Tracker help accounting team to track Accounting processes. Trade Tracking are used by Investor Services team. Client Services team uses AIS Dashboard to maintain Client Fund information.

Responsibilities

• Worked closely with Business team to define requirement gathering requirement analysis.
• Created mock up screens for various modules including Portfolio/NAV Accounting Checklists, for Management Dashboard Project and enhancements in existing AIS Dashboard using MS Visio and MS Paint.
• Facilitated JAD Session involving stakeholders from business side and IT side to gather business functional requirements.
• Understood the AML compliance requirements by interacting with compliance department
• Maintained SDLC standard by documenting various documents like Project Request Document, Scope Document, Project Planning Document, BRD, FRD and Planning Phase end matrices.
• Analyzed change requests and enhancements, bugs prod issues and worked closely with development team for implementation.
• Created High Level Design Document, Test Plan Test Case Document, Release Plan, standard by Followed SDLC standards.
• Evaluated change requests and enhancements, bugs prod issues and worked closely with development team for implementation.
• As Scrum Master involved in Scrum Sprint Planning Sessions, Backlog refinement, Sizing, Sprint Retrospectives Reviews, Daily Stand ups, User Stories and Acceptance Criteria.
• Used JIRA to maintain and update status of each change request, enhancement, prod issue and bugs for AIS Dashboard project.
• Worked very closely with various business team like Client Services team, Investor Services team, accounting team etc. during UAT phase Production Release of the project. Also identified and documented disaster recovery plan.
• Lead onsite offshore development team during the project and worked closely to achieve product delivery timelines.

Tool Technologies

Agile, Microsoft Windows XP, Microsoft Office Suite, Visio, SQL, Microsoft Outlook, JIRA, Rally, UML

Confidential

Role: Senior Business Analyst

The project was to upgrade of the existing selling system and upgrade of the loan underwriting and servicing application.

Responsibilities

• Facilitated JAD sessions with both business side and IT side to produce high level requirements. Assisted with design walkthroughs with stakeholders.
• Managed project risks by effective communication to stakeholders with appropriate mitigation strategies.
• Create Data Flow diagrams and process flow diagrams to facilitate better system understanding
• Lead 3 analysts in the system integration analysis, data analysis and requirements gathering for the implementation of various consumer system s to publish data in/from enterprise data services hub in the form of canonical data format.
• Created functional requirements using UML models including user case diagram, activity diagram, and assisted developers in creating sequence diagrams and collaboration diagrams.
• Was responsible for understanding the business logic and assisted other business analysts in generating Functional Requirement specifications FRS and User Requirements Specifications URS .
• Created mock up screens for various modules including Underwriting, selling system, and servicing.
• Performed impact analysis, GAP analysis for new to improve on the current methods, apply analytical skills, and produce thoughtful and strategic recommendations for review with the business partner.
• Performed data analysis with high difficulty in support of ad-hoc customer requests. Developed SQL queries and reports for analyzing and presenting the data.
• Coordinated work plans between project manager and client using MS Project.
• Assisted Project Manager in supporting and checking project progress using MS Project
• Supported project teams to manage requirements, traceability and implement Change Requests.
• Helped development teams to Export design document and generate RTM using Rational Requisite Pro
• Created High Level Design Document, Test Plan Test Case Document, Release Plan, standard by preparing Followed SDLC standards to main documentations including
• Managed all phases of testing including development of test plans, scenarios, data, and test scripts for facilitation of System Integration Testing SIT , User Acceptance Testing UAT . And user training for the new system.
• Helped in reviewing and editing of the test scripts.
• Created and tested scripts for the premium calculations and claim limits and deductible.
• Used Rational Clear Quest for handling change requests.
• Analyzed the test environment for usability and user interface design including Defect tracking, recording, and management to ensure defect correction completion.
• Worked closely with underwriter to understand the underwriting process, assisted reviewing the documents for loan underwriting Uniform Residential Loan Application 1003 , Property Inspection Report, Residential Appraisal Report 1004 , Income documentation Paystubs, w2, 1099 , Bank Statements, Investment Statements, Tax forms.
• Perform detailed income analysis including review of tax returns to determine qualifying income for the borrower.
• Perform credit analysis to determine obligations
• Analyze Bank/Financial statements to determine availability of liquid assets needed for closing and reserves according to different product guidelines.
• Analyze appraisal report and reviews to ensure compliance with guidelines.
• Assisted Underwriter maintain audit trail for loan modification approvals and loan changes.
• Worked closely with Business team and project manager to define project scope, risks and requirement gathering requirement analysis.

Tool Technologies

RUP, UML, Rational Requisite Pro, Rational Rose, Rational ClearQuest, Windows 7, SQL, HTML, MS Office Suite, Visio

Confidential

Role: Senior Business Analyst

The project was to manage the funds data for Calamos. This required loading the data into Global Info Warehouse GIW data-mart from the source system, Multifonds the upstream system and extracting the data to the downstream system, Fund Services Reporting. This would allow the downstream system to publish reports to the client. This reports included the account details, entitlement reports and corporate action reports.

Responsibilities

• Outlined program and project goals, objectives, products, services, restrictions, assumptions, risks and facilitated processes by working with the GIW team to baseline the scope of the work.
• Executed gap analysis for existing Data model for various referential and transactional entities and created Data model change requests for the enhancement.
• Defined logic for the load process of securities Funds in which defined rules for ISIN international security identification number , CUSIP and SEDOL.
• Identified the data load processing order for each entity based on dependency check.
• Worked with Subject Matter Experts SMEs to identify, understand and document business needs of data.
• Gathered Requirements and interacted with Subject Matter Experts to identify, understand and document business needs for data.
• Evaluated business requirements and functional requirements from clients and writing of the Data Dictionary, initial and final function.
• Developed the data mapping documents for all units, investor-distributor, accounts, transactions, funds, dividend balance, and foreign exchange rate.
• Prepared test data for various test Cases and performed unit testing exercise using SQL server to examine data quality for the data analysis activity.
• Performed data validation for all the load processes, maintained log of data validation issues.
• Analyzed input feed layout for all the entities. Prepared the data dictionary for learning purpose for development team.
• Also prepared the documented SQL queries for the Production Website.
• Responsible for troubleshooting the issues reported by the development team.
• Facilitated User Acceptance Testing UAT using HP Quality center with the stakeholders and the business users, and the errors discovered were fixed and then verified via regression testing.
• Acted as a liaison between the development team and the business and worked on resolving the issues reported.
• Accountable for maintaining the latest versions of the data mapping documents, documenting all the proposed changes and explain the changes to the development team.

Tool Technologies

Agile Methodology, Microsoft Office, Visio, SQL, Rally Enterprise edition, Toad v11, HTML, UML

Confidential

Role: Business Analyst

Project was to enable management team to propose loan modifications that will enable borrowers to make timely payments and avoid loans from going in to inactive status. It also had the ability to change the terms of a loan at any point in the loan, restructure a loan with different interest rate or as per the monthly payment including HELOC and High risk loans. Used Waterfall Methodology.

Responsibilities

• Conducted user interviews at both in-house and client locations gathering and analyzing requirements and implemented those ideas in to developing GUI wire frames models, technical and functional specifications.
• Designed and developed BRD, Use Cases, Activity diagram, identified, analyzed, defined and documented business processes and use case scenarios.
• Conducted JAD sessions with management, SME's, Business users, and other stakeholders for open and pending issues to develop specifications.
• Ensured timely completion of project tasks, and deliverables with high degree of quality and prioritizing task appropriately and resolve issues along with project manager.
• Performed manual Testing along with testers. Conducted UAT with the business users.
• Worked with Quality Assurance Analyst in HP Quality Center to track defects.
• Collaborated with the Project Manager to organize training material and user manuals.
• Worked with SQL queries such as select, insert, update and delete for data manipulations.
• Worked on profiling the data for understanding the data and mapping document

Tool Technologies

MS Office, UML, Visio, UAT, HP Quality Center, SQL, ERD, Mock Up.

Confidential

Role: Business Analyst

This project involved the automation of Mortgage loan origination process beginning from origination/opening a mortgage application through funding/closing. The system performed all the business functions of the loan process such as set-up Account information, New Loan set-up, the Appraisal, credit, and income. The project involved modules for Pre Approval, Application, Underwriting, Pricing, Processing, and Closing.

Responsibilities

• Involved in the SDLC phase of requirement analysis, design, and development of the intranet based application.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop. Documented User Stories to analyze the level of effort on project specifications
• Generated a streamline process to understand the various steps in the loan lifecycle and desired functionality of the new system by interacting with users, management, SME Subject Matter Expert , stakeholders, lenders, underwriters.
• Conducted walkthroughs with the different department heads to have a deeper understanding of the requirements.
• Analyzed and documented the business requirements and generated reports for the Manager
• Developed flow diagrams for Business process of the company, UI Wireframes and Mockups using Microsoft Visio
• Created and maintained data mapping documents.
• functioned as the primary liaison between the business, operations, and technical groups throughout the project cycle
• Follow up with the end users and developers for user satisfaction and change management if necessary
• performed extensive Gap analysis to determine the risks and assisted the PM in budget and resource planning
• Assisted and adhered to project work flow process.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives, resolve issues, and reach agreements.
• Organized and managed all phases of the software testing process, including planning tests, writing test cases, executing tests and tracking defects using Quality Center.
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance testing UAT and validation.
• Involved in weekly meetings with the development team to resolve technical issue
• Participated in creating User manuals.

Tool Technologies

Microsoft Office Suites, MS Outlook, MS Project, MS Visio, SQL, Oracles, and UML.

Confidential

Role: Jr. Business Analyst

Confidential is an online brokerage firm that offers a full line of investment products, online trading platforms and market research tools to help investors Individuals, corporate, Trusts, custodians take control of their financial future. It provides a real-time stock trading data from exchanges around the Confidential. To enhance its Real suite of applications for analyzing, tracking, and trading stocks, futures, options, foreign exchange, and fixed income instruments for the Confidential market, TD Ameritrade recently upgraded its website that allows the customers Individuals, corporate, Trusts, custodians to have in depth research of the ETFs that they are interested in like analyzing the historical data, charts, latest news and financials. The project was about enhancing the existing trading site for incorporating it with the trading platforms and integrating it with the trading platforms. Interfaced the ETF trading systems to types of customers. Now any customer Individual, trust can open an account to trade ETFs.

Responsibilities

• Extracted the business requirements for the end users keeping in mind their need for the application.
• Conducted Gap Analysis to show the current and proposed functionalities of the system.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams in MS Visio.
• Assisted with JAD sessions with management, SME Subject Matter Expertise , vendors, users and other stakeholders for open and pending issues to develop specifications.
• Assisted in testing the application for Usability testing to verify whether all the user requirements.

Tool Technologies

Microsoft Office Suites, MS Outlook, MS Office, Visio, SQL, UML