SUMMARY

• Business System Analyst with over 8+ years industry experience in data modeling, process modeling, requirements gathering and analysis, process flow, process analysis and quality assurance
• Experience working with customer / business and project team (Cross Functional), Vendor Management and Operation Management.
• Excellent writing skills in documenting Business Requirements Document (BRD), Use Case Specifications and Functional Specifications, Systems Requirements Specification (SRS), Workflows and Unified Modeling Language (UML) diagrams (Use Cases, Activity and Sequence), Requirement Management Tools and Change & Version Control Tools
• Experienced in all areas of project life cycle in a highly structured change management environment using traditional waterfall, and Agile Techniques and RUP
• Involved in all phases of SDLC with comprehensive knowledge of business requirements, analysis, use case modeling, use case specification, defined and documented the Current state process flow and Future state process flow diagrams.
• Excellent knowledge of asset management, securities, brokerage, equity, derivatives, retail and commercial banking.
• Highly experienced in various areas of Investment Banking: Portfolio Management, Fixed Income, Annuities, Trading Life Cycle, Mortgage, Loan Orientation, Stocks, Bonds, Futures, Options, Hedging, Equity Research, Mutual Funds, Securities lending and Commodities.
• Worked extensively with the team to meet business requirement, create prototypes and analyze workflow and conducted JAD sessions.
• Using data transformation services to move data between different sources and transform data according to needs .
• Configuring and monitoring replication and log shipping and Debugging deadlocks and other database inefficiencies using SQL Profiler. Performance Tuning - Tune, analyze and optimize costly queries
• Involved in creating and reviewing test plan and test cases, manual testing, and conducting User Acceptance Testing (UAT).
• Experienced in creating Business Requirement Documents, User Requirement Specification, and Functional Requirement Specifications, and Requirements Traceability Matrix.
• Exposure to OBIEE and Oracle Hyperion Financial analytical tools
• Worked as Analyst and Test Lead for implementation and upgrade, Application maintenance and product development support of Unisys Treasury Product - URBIS.
• Good working experience in sprints of the project in SCRUM methodology.
• Skilled in performing Gap analysis, Impact Analysis and Risk Analysis, Cost benefit analysis.
• Exposure to Change Request Management tools like Clear Quest.
• Assisted QA team in developing Test Scripts, Test Cases and Test Plan for User Acceptance testing.
• Effective in executing multiple tasks and assignments ahead of schedule. Reputation for dedicated teamwork, high energy, work ethics and commitment with capability to handle new technologies and situations.
• Team player and self-starter with excellent communication, coordination, documentation, project planning and interpersonal skills.

TECHNICAL SKILLS

Business modeling: Microsoft Visio, IBM Rational Rose, Enterprise Architecture

Documentation: Rational Requisite Pro, On Time, Dream viewer, Microsoft Word, Excel

Tools: Microsoft Project, Java, MS Visio, Cognos, Snagit, Google Analytics

Version Tools: Clear Case/ Clear Quest, Clarity

Defect Tracking: Mercury Quality Center, Application Lifecycle Management

Testing: Mercury Quick Test Pro, Win Runner, Load Runner, Quality Center

Reporting tools: Micro strategy, Crystal Reports

Languages: SQL Access, PL / SQL, VB Script, JavaScript, C, C++, HTML, XML, VHDL

Databases: Oracle 8.x/ 9i/10g, MS Access, MS SQL Server, DB2

Operating Systems: Windows NT/95/98/2000/XP/7, UNIX, Linux (SSL, VPN)

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr Business Analyst

Responsibilities:

• Worked closely with ALM and Finance users to capture business requirements for Tri Party Repos and Collateral products.
• Planned and conducted the requirements gathering sessions/JAD sessions with the business user.
• Familiar with most current mortgage software and automations technologies
• Conducting design review meeting with onshore and offshore teams.
• Showed mortgage bankers the risk of the loan based on credit, collateral, and underwriting.
• Worked closely with users from Corporate Finance, Product Control, Compliance, and Regulatory Reporting group and gathered their requirements.
• Perform information technology audits of trading and operations systems
• Perform treasury cash allocation procedures including daily funding business units and departments
• Managed all mortgage operations for residential lending broker.
• Evaluated the entire credit package and collateral for residential mortgage loans and ultimately ensure an 'investor' quality loan product
• Consult on accounting, treasury, operations, and management information systems for merger with Manufacturers Hanover Trust, and report
• Implement derivatives accounting procedures in accordance with FASB 133
• Supported URBIS modules like Foreign Exchange, Money Market, Foreign Exchange Swaps, Interest Bearing Securities, Discounted Securities and Options for Treasury department.
• Designed software using UML language and Enterprise Architect tool
• Gathered Basel II & III requirements for Market Risk, Credit Risk and Liquidity Risk from the users.
• Baseline the business requirements, data requirement, and user interface requirements through BRD/FSD and Use Cases.
• Worked with dba’s and development team for database design, GUI designs, Web Portals and Reporting Dashboards.
• Generated and analyzed purchasing reports of existing suppliers to negotiate pricing structures with new suppliers.
• Monitored and maintained profit levels and pricing via File Pro database programs
• Responsible for weekly project dashboards, issue escalations and resolutions, Change Request Management and Defect Management.
• Developing User Stories and worked on Testing Driven Agile development projects utilizing UML deliverables.
• Conducted gap analysis of current processes and developed new process flow, data flow and work flow models.
• Prepared project charters / plans and identified the major milestones of the project.
• Worked with external audit teams (PWC) to comply with IT audits.
• Utilizing use cases with an emphasis on test case development and planning thru Mercury Quality Center
• Conduct work stream meetings to eliminate redundancies and duplication of efforts.
• Managed and delegated tasks for building the interface with Broker Dealer Services & Collateral Management System (Repo Edge, Intrader), Static Data, Client Master and Security Master.
• Owned several project artifacts including Project Plan, Requirement Traceability Matrix, UAT Test Plan and Schedules.
• Effectively used SQL joins, union and functions like group by, order by, count, having, sum, etc. for data analysis, data validation, generating mockup reports, and ensuring referential data integrity.
• Sales and Marketing business functions to provide customers with an analysis of Rate Plan options.
• Reviewed SQL store procedures with developers to trouble shot bugs, fixes and enhancements.
• Effectively conducted Defect Management and Reporting using Quality Center.
• Managed UAT testing effort with business users and offshore technology teams and delegated issues through Confidential Quality Center.
• Co-ordinated project go-live and post production support.

Environment: Ms Office, .Net, Java, Problem Book, Project Book, Same Time in Lotus 8.5,JIRA, Share Point, Oracle, Windows XP, Windows 2003, UML, HTML, Web Services, Internet Explorer, Mozilla Firefox, Safari, Chrome

Confidential, NY

Sr. Business Analyst

Responsibilities:

• Conducted requirements gathering sessions with the business user to collect business requirements (BRDs), data requirement, and user interface requirements.
• Excellent experience in the residential mortgage loans.
• Reviewed mortgage compliance. As a senior auditor serve as advisors in the areas of mortgage quality control, agency audits, collateral and appraisal management's compliance.
• Interacted with treasury and operations personnel on performing daily settlement procedures with securities clearing houses (DTC and SCC)
• Automated, streamlined and standardized, regulatory reporting and treasury accounting activities
• Determined ability to repay and debt ratios on mortgage applications and maximize loan quality while
• Managed a Cognos reporting team to develop reporting functionality of the portal.
• Designed software using UML language and Enterprise Architect tool the software team on UML, RUP, J2EE and respective tools.
• Responsible for developing management reporting using Cognos reporting tool.
• Conducted User Interview and documented reconciliation work flows.
• Conducted detailed analysis of current processes and developed new process flow, data flow, and work flow models, Use Cases using Rational Rose & MS Visio
• Worked on multiple systems such as In trader /MOMS for investment portfolio Fixed Income trades, QRM, ACBS for Corporate Lending/Loans, IBS for client
• DDA & Clearing Accounts, Wall street for Repos/Reverse Repos, Bloomberg, QRM for Forecasting and Funds Transfer Pricing.
• Originated personal loan business, both commercial and residential. Reviewed and evaluated mortgage loan documentation to determine if borrower and/or property meet loan standards and company, investor, or government guidelines
• Prepared Use Cases, Business Process Models and Data flow diagrams, User Interface models.
• Gathered & analyzed requirements for Asset & Liability Management group (ALM), Corporate Finance group, designed process flow diagrams.
• Defined business processes related to the project and provided technical direction to development workgroup.
• Analyzed the legacy & Oracle Chart of Accounts (COA) and the Financial Data Warehouse.
• Participated in Data base design sessions, Database normalization meetings.
• Managed Change Request Management and Defect Management.
• Managed UAT testing and developed test strategies, test plans, reviewed QA test plans for appropriate test coverage.

Environment: Windows XP/2000, MS Office Suite, MS Visio, Rational Rose, Mercury Quality Centre, Load runner.

Confidential, PA

Sr. Business Analyst

Responsibilities:

• Gathered business requirements and formalized them through requirements walk through sessions.
• Interviewed business users and documented current work flow, reconciliation process.
• Worked on integrating feeds from Broadridge, Calypso, Flexcube, LoanIQ, OPICS, Client Master and Security Master in to Granite data warehouse.
• Manage stress test activities and helping the team to come up with test strategies.
• Acted as a Subject Mater Expert (SME), owner of several systems and point of contact for business users and global offshore technology/QA teams.
• Perform UAT and QAT procedures for Euroclear settlement system implementation
• Performed detailed compliance and substantive tests on clients' money market, securities, and foreign exchange trading activities
• Responsible for project management functions including preparing project charters / plans, project timelines.
• Conducted project kick-off meetings and delegated task to different workstreams.
• Extensively used SQL( Joins, Distinct, Functions- count, sum, max, having, group by) and MS Excel hlookup, vlookup, Macros, Pivot Tables etc for data validation and creating mock-up reports.
• Designed software using UML language and Enterprise Architect tool
• Prepared trading position reports for options, government securities, and mutual funds
• Worked with developers on SQL store procedures to trouble shoot issues and document legacy programs.
• Developed Process Flow Diagrams, Work Flow Diagrams, and Use Cases using MS Visio.
• Developed Traceability Matrix, Data mapping and Data flow diagrams.
• Effectively conducted Change Request Management and assigned priority on each change.
• Prepared UAT test strategy, test plans, reviewed QA test plans for appropriate test coverage.Managed project go-live and support

Environment: RUP SDLC, UML,MS Visio, MS Project, MS Office Suite Word, Excel, Access, Power Point, Outlook.

Confidential, CA

Business Analyst

Responsibilities:

• Worked with the Enterprise architect for the overall architecture/solution for the project and ensured that it aligns with the long-term strategy.
• Created sprint plans and transformed the scope into work packages. Worked with the product owner to groom the product backlog throughout the lifecycle of the project
• Defined clear roles and responsibilities among team members and established a process for work management.
• Responsible for enhancing existing Logical and Physical data models to accommodate the new data requirements.
• Tracked the progress of sprints. Monitored sprint burn down and velocity of the scrum teams. Created dashboards for the management to view the sprint progress of all the scrum teams.
• Proactively managed scope changes, risks, issues and action items throughout the projectAt the program level, interfaced with the owner of the interfacing applications and vendors to establish dependencies (Give Vs. Get) and milestones.
• Conducted sessions on Agile methodology and work management process
• Generated Reports for Traffic Analysis using Analytics tools like Web Trends Tool, Google Analytics, and prepared reports by importing external data in Excel format with the help of ODBC Web Trends driver and MS Query.
• Experience in writing XML scripts
• Excellent skills in analysis web data and providing analysis.

Environment: Agile, MS Office (Word, MS Excel, MS PowerPoint, MS Visio), SharePoint, Oracle, XML, SQL Server