SUMMARY:

• 7+ years of professional experience as a Business Analyst in Finance/Banking Domain.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
• Extensive risk management experience conducting fraud and risk investigations for financial institutions and payment processing organizations
• Strong experience in RUP Business modeling process.
• Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using IBM’s Rational Rose.
• Well versed with client server environment and tools like SQL Loader, UNIX shell scripts and TOAD
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Proven success as a business analyst through the years, providing a well - balanced understanding of business relationships, business requirements, and technical solutions.
• Professional experience in business analysis, operations management and development, design, documentation and testing.
• Excellent Analytical, methodical, and resourceful approach to problem solving, identifying and documenting root causes and corrective actions to meet short and long term business and system requirements.

TECHNICAL SKILLS:

• OOAD (OOA/OOD), RUP, UML, SDLC, Waterfall, QA, WAP, CVS, TEAMMATE
• MS Access, SQL Server, MySQL, PL/SQL, Oracle DBA, DB2. Windows, basic UNIX
• HTML, basic DHTML, basic XML, MS Office Suite-Excel Macros, Project, Visio, Adobe Photoshop
• Flash, Rational- Rational Rose, Rational XDE, DOORS, Cobol, RequisitePro, Websphere
• CaliberRM, VB.Net Crystal Reports, various NIKU products, C, C++, J2EE, Sharepoint, Docushare, BASIC, Intermediate level-Visual Basic.

PROFESSIONAL EXPERIENCE:

Confidential, San Franscisco, CA

Business Analyst

Responsibilities:

• Gathered Business Requirements. Interacted with the Users, Designers and Developers, Project Manager and SME’s to get a better understanding of the Business Processes, and Analyzed and optimized the process.
• Utilized Commercial Lending banking application and was responsible for the design and process flow of the system.
• Worked with front office and back office teams in the LOS side, alos was invloved working with credit analyst in determining the requiremnts for LOS.
• Analyzed requirements for loan request, loan process, member services, processing and portfolio management.
• Worked on sharepoint implemetation for the loan system.
• Worked with different modules for Pre Approval, Application, Pricing, Processing, and Closing of the Loan.
• Generated Use Case diagrams, Sequence diagrams, Business Objects, Domain Object Model, and Visio to depict process flows and PowerPoint presentations
• Worked extensively with Risk Management, Mortgage Loan Servicing, and Commercial and Residential mortgage, CMBS, MBS
• Mortgage Pre-payment risk, Risk Analytics for MBS, Loan Servicing, Loan Origination, MBS, CMBS, and Secondary Mortgage Market
• Held and attended presentations and meetings to coordinate efforts among all the groups, leading the inception phase.
• Performed GUI Test, System Test, web design implementation, User Acceptance Test (UAT), Compatibility Test and Performance Test.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification and Technical Specification using Rational RequisitePro.
• Identified Use Cases from the requirements. Created UML Diagrams including Use Cases Diagrams, Activity Diagrams/State Chart Diagrams, Sequence Diagrams, Collaboration Diagrams and Deployment Diagrams, Data Flow Diagrams (DFDs), ER Diagrams and Web Page Mock-Ups using Rational Rose and MS Visio and thus defining the Business Process Model and Data Process Model.
• Performed manual testing on Admin, Authorization, Closing and Funding modules of the Loan Origination System. Formulated a Test Plan and Test Cases that comprehensively tested these critical aspects of the loan life-cycle.
• Creating and maintaining the Traceability Matrix of scripts that needed remediation as part of the data conversion effort.
• Validated XML schema and inserted check points for various tags in XML.
• Involved in assisting the development of functional requirements, static testing the applications by preparing and developing the Test Plans and Test Rules, editing and writing Test Cases, Test Scenarios and Test Scripts.
• Executed the test cases manually for various job submissions in batch processing by using the Quality Center.
• Did the regression testing using pre-existing test cases besides integration testing of various modules of the application.
• Prepared Functional and Behavioral document that describe the detail design of the application.
• Used the Unified Change Management (UCM) tool, Rational ClearQuest to maintain and track the stakeholders requested enhancements and changes.

Environment: RUP, Rational Requisite Pro, IBM Rational, J2EE, Clear case, Sharepoint Clear Quest, Data warehouse, UML, Oracle, SQL Server, Unix, XML, MS Project.

Confidential, Chicago,IL

Business Systems Analyst

Responsibilities:

• Interview business area experts asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people
• Interact with SME's to elicit business goals and define goal-level requirements
• Collaborate with financial analysts, investment analysts and accountants to collect and understand business requirements
• Analyze Risks, documented Risk Logs and created Requirement Traceability Matrix (RTM) as a roadmap for the 'TO BE' system
• Facilitated and managed meeting sessions with committee of SME from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Conducting JAD Sessions to resolve open issues, change requests so that the application meets the business requirements and dead lines
• Worked on data modeling and produced data mapping and data definition documentation
• Worked in mainframe environment and used SQL to query various reporting databases.
• Interact and negotiate with Vendors to complete the tasks related to data conversion
• Was involved in the Test Plan document preparation.
• Developed and designed the test cases for different modules of finance referring to the test plan document and analyzing the test rules
• Provide AGILE project management controls, project plans, timeline schedules, facilitate RAD sessions, and review software defects.
• Conducted Functional Testing, Joint Functional Testing and UAT, documented and reported user feedbacks to management team.
• Reviewing the Requirements specifications, creating Master test plan, creating Test schedules according to the project deadlines.
• Identified test procedures that needed to be automated by isolating the repetitive actions.
• Created Test sets for the manual and automated test cases in Mercury Test Director.
• Created and executed Manual test cases in Qualtiy Center, and worked on automated test cases in WinRunner and viewing and analyzing the test results in the Quality Center.
• Used GUI Map Editor for capturing objects information for the current application under test.
• Identified, prioritized and designed various test scenarios.
• Used Quality Center for requirement management, test planning, scheduling, executing test cases, managing and tracking defects.
• Developed XML schema to validate business rules in the generated XML files
• Reported the bugs, Email notifications to the developers using Test Director.
• Customized the test scripts using check points, synchronization and parameterization of data.
• Automation of test scripts was done using QTP for test re-usability of different online transaction modules.
• Involved in converting User requirements into business requirements, functional and technical requirements using Rational Requisite Pro and also created business process models from the requirement specs

Environment: Windows, Oracle, SQL, Websphere, Sharepoint, Microsoft Office suite, Microsoft Visio, Clear Quest, Rational Unified Process (RUP), RequisitePro, Clear Case, UML, SAS

Confidential

Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Collects requirements from department managers and users for enhancements. Acts as liason between clients and development. Facilitates sessions to bring business requirements and functionality into SAP system development and enhancement.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Collaborated with Basel II team on credit risk and market risk analysis and issue resolution.
• Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II
• Prepared for GAP Analysis; identified and documented improved areas to meet capital requirement regulations for Basel II Compliance.
• Gathered requirements for credit risk, operational risk and market risk management
• Worked closely with. Standardised Approach and Foundation IRB (Internal Ratings Based) Approach for Credit Risk
• Involved in putting together QRM (Quantitative Risk Management) models for risk-weighted calculations
• Worked with Disclosure requirements as per Pillar 3
• Gathered architecture specifications for second pillar dealing with the regulatory response
• Worked with Oracle Reveleus Basel II to help generate various statistical models
• Enhancing supporting documentation (policies, frameworks, standards, methodologies, and modeling documents) to demonstrate compliance with the Basel II Accord.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Was responsible for indexing of the tables in that data warehouse.
• Reverse Engineered the existing ODS in to Erwin.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Worked on data modeling and produced data mapping and data definition documentation
• Configured the Data mapping between Oracle and SQL Server 2005.
• Tested Performance & Accuracy related queries under SQL Server
• Designed and implemented basic SQL queries for testing and report/data validation
• Manage Scope and change throughout the SDLC process of the product.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagr ams and creation of technical design (UI screen) using Microsoft Visio.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Sharepoint, Oracle, SQL, SQL Server, Sybase, IBM Websphere Business Process Modeller, MIS-IP, ACORD, XML, Business Objects, TestDirector

Confidential, Stanford, CT

Business Analyst

Responsibilities:

• Develop trading solutions to re-hypothecate the positions; perform high-level feasibility analysis, industry & market analysis, risk analysis, trading workflow reconfiguration
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration in to the CI System Knowledge Data Base in Microsoft Share Point
• Conducted JAD sessions for communicating with Stakeholders and Project directors
• Conduct extensive analysis on security trading cycles; provide consulting on financial disclosure, regulatory and compliance issues
• Streamlining the onboarding process is easier than ever these days. Begin by sending new clients a no-hassle, personalized switch kit.
• Created use case scenarios and documented work flow and business process using Rational Rose
• After the SRS is complete, to Baseline it, a Peer review meeting was held. Once the issues and questions raised in the Peer review meeting are logged and solved, then the SRS was sent for approval to Stakeholders.
• Created a procedural manual, by documenting the processes of the RSF Collateral/Custody Management System. Was the liaison person with regards to back-offices issues including: accounting, clearing, custody and regulatory.
• Design, develop, and validate testing methodologies for trading activities; perform trading-related testing via the new trading system, coordinate with various F2B components, document results, and generate reports
• Determined and Drawn the preferred flows for OMS (Charles River), TMS figuration, BOSS and MEO for financial instruments (Stocks, bonds, Options, Mutual Funds, Preferreds, etc) with the consideration of Web discounts, daily trading account value, margin requirements, IRA accounts, trading limits, Lead-Ins and Lead-Outs, GLAS (Gain Loss Analysis Systems), Confirms, Settles, Trade multiplier, etc. on MS Visio.
• Extracted the business requirements from the stakeholders keeping in mind their need for the application and documenting them using Rational ReqPro.
• Strong knowledge activities involving corporate actions data integration, Entitlement calculation, notification and reconciliations with custodian through SWIFT, management of Tax/ Market claims to be paid or redeemed.
• Wrote detailed specifications for various reports generated using Cognos
• Conducted business process modeling and analysis; identified, assessed and articulated gaps/operational risks associated; presented risk-mitigation and operational enhancement solutions to project management team
• Createdviewsto facilitate easy user interface implementation, andtriggerson them to facilitate consistent data entry into the database.
• Wrote user requirements specification (URS) and Functional requirements specification (FRS) Documents as per the System requirements and process flow.
• Assisted in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).

Environment: Windows, Oracle, MS Access, Rational Rose, Requisite Pro, Clear Quest, RUP, UML, MS Visio, Test Director