SUMMARY

• Business Analyst with 7 years of experience in business process analysis/modeling, business requirements gathering, database design and development of Web Based, and Client/Server applications.
• Deep understanding of Investment Management, Asset Management, Prime Brokerage Services, Money and Capital Market Instruments.
• Comprehensive noledge of and solid experience in Derivatives including Credit Derivatives, Interest Rate Derivatives, FX Derivatives, Equity Derivatives and Commodity Derivatives.
• Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose & MS Visio.
• Expertise in using Rational tools for creating use cases, version control, and defect tracking and monitoring and used teh Rational Unified Process (RUP) methodology in all areas of teh software development life cycle (SDLC).
• Experience in broad range of financial practices and principals ranging from financial analysis, corporate valuation, equity/capital market research, financial modeling, forecasting, and budgeting to trend analysis, investment banking, asset allocation, portfolio management, risk analysis and derivatives.
• Experienced in conducting Requirement Analysis, Use Case Design, Designing Test Plans and developed database schemas based on teh logical models.
• Understanding of money market and capital market instruments.
• Ability to gather business and Technical Requirements from both formal and informal sessions utilizing a variety of software methodologies including, Use Cases and teh Rational Unified Process.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, Primavera, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts and web design and development.
• Expertise in data driven testing and setting parameters with teh Performance Session Scripts.

TECHNICAL SKILLS:

• OOAD (OOA/OOD)
• RUP
• UML
• UAT
• SDLC
• Waterfall
• QA
• MS Access
• SQL Server
• MySQL
• PL/SQL
• Oracle DBA
• DB2. Windows 98/2000/XP basic UNIX
• HTML
• DHTML
• XML
• MS Office Suite - Excel Macros
• Project
• Visio
• Siebel
• Adobe Photoshop
• Flash
• Rational- Rational Rose
• Rational XDE
• DOORS
• Cobol
• RequisitePro
• CaliberRM
• Crystal Reports various NIKU products teradata
• Sharepoint
• Docushare
• Visual Basic.

PROFESSIONAL EXPERIENCE:

Confidential, IL

Sr Business Analyst

Responsibilities:

• Financial products involved: Fixed Income, Equities, Bonds, Mutual Funds, Fund of Funds, Insurance, ment Planning, Generation Planning and complete Financial Planning. Leverage strong business noledge of teh investment banking sector to halp design viable solutions.
• Worked with SMEs to understand various assets and security classes, exchange traded derivatives (such as futures, options on futures, equity options and index options), OTC derivatives (such as interest rate swaps, swaptions, credit default swaps and total return swaps) and portfolio allocation and management. Responsible for interacting with business heads for designing integrated accounting and business processes.
• Conduct Brainstorming and JAD Session to gather businessrequirements from market risk Group, risk Reporting Team and other stakeholders (PMEs, Compliance, etc)
• Build VDW (Virtual DataWarehouse) and RDW (Regional DataWarehouse) for research data analysis after normalizing data for outliers.
• Worked onCounterparty Credit Risk, Equity and General Ledger reconciliation work streams based on Basel III Final rule with regards to capital calculation, asset classification and RWA calculation.
• Performed detailed profitability analysis on client products and business segments including retirement systems (401K, Keogh) and brokerage subsidiaries.
• Gather requirements for teh listed options risk management system, specifically for index options risk management spreadsheet. Defining requirements for product control and risk management.
• Involved in identifying and documenting detailed business requirements pertaining to Fixed Income Securities and Repo/Reverse Trading Cycle, Equities and Equity Trading Cycle, Derivatives, Portfolio Management, Corporate Action, and Wealth Management, etc.,
• Assist in teh coordination of teh particular businesses (ICG, GCB) specific needs for teh Global AML KYC project supported by fully documented plans, vetted with global business owners (ICG, GCB), regional and country AMLCO representatives.
• Worked with SMEs to understand various assets and security classes (LOC, IEFs, Government Securities), capital markets and fixed income securities (such as Treasury securities, Repo, Bonds), and Cash Securities.
• Responsible for various functions within treasury management commercial operations which include but not limited to; project management, quality and cost reporting with data analysis.
• Conducted User Interviews and Work Shops to gather accurate Business Requirements.
• Developed a business intelligence life cycle to address teh business intelligence project team.
• Reviewed data model and reporting requirements for Cognos Reports with teh Data warehouse/ETL and Reporting team.
• Experience of working with Treasury securities (T-Bills, T-Notes, T-Bonds & Tips) and Cash transactions to re- engineer teh C-21 system.
• Understand and assist with translating teh impact of consumer AML commitments for data privacy, data quality issues or any other issues arising during teh planning and implementation phases.
• Documented Requirements for Activity management, Fixed Income, Asset Management Services, Client portfolio management, Order management system, Performance, Equities, Reconciliation, Transaction capture/Execution and reporting requirements for teh user interface.
• Managed teh development, maintenance and, operation of finacial data warehouse used for Quality Reporting. Reported teh bugs, Email notifications to teh developers using Test Director.
• Set up market data including zero curves, correlation matrices, dividend curves, etc., and underlying financial instruments and tan set up derivatives pricing parameters and trade capture options that drive teh valuation of trade migration based on teh market data to configure and test teh system
• Worked at different stages of teh Software Development Life Cycle (SDLC) with business users, developers, and stakeholders.
• Written smoke test cases in Quality Center and modified them when they are automated.
• Automation of test scripts was done using QTP for test re-usability of different online transaction modules. Conducted Functional Analysis and Gap Analysis for designing robust solutions.
• Involved in creating Data Flow Diagrams for Database of teh Investment Portfolios.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data. Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements using UML.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Extensively experience in Fixed income trading such as Bond, Note, and Bill with estimation of Coupon Rate, Current Yield, YTC, and YTM.
• Understood Fixed Income, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing.
• Understood Fixed Income Repos, Treasury, Mutual Funds, Bonds and Bond Trading Cycle, Equities and Equity Trade Cycle, Derivatives (Interest, Options and Futures), Portfolio Management, Wealth Management, and Sales and Marketing.
• Worked on teh Functional and non - functional documentation for teh equity, GL reconciliation and Counterparty Credit Riskwork stream based on theBusinessrequirement document.
• Collaborated with Basel II team on credit risk analysis and issue resolution. Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using teh UML methodologies.
• Involved in mentoring specific projects in application of teh new SDLC based on teh Agile Unified Process, especially from teh project management, requirements and architecture perspectives.
• Assisted PM in Developing Project plan and tracking project Process, Scheduling and organizing group meeting, as well as developed Risk Management Plan.
• Participated in automation of manual reconciliations/balancing (Treasury management portal) thus streamlined operations (time and cost savings).
• Maintained monthly benchmark index weights and industry classifications for performance analysis. Downloading benchmark index weights from Reuters & Bloombergon a daily basis for uploading to various databases.
• Conducted analysis and review of client documentation/information obtained by client contacts within teh business units is consistent with BSA/AML Policy and Procedures and satisfies regulatory requirements.
• Performed extensive analysis and documentation of Basel II Capital Engine (Internal-model capital engine to determine credit risk) Balance Sheet trade data to Source System trade data from various data streams for financial products such as Money Markets, OTC and Exchange traded derivatives, Commercial Loans, Secured Financing, Loss Mitigation, Escrow Analysis, Portfolio Analysis, Home Retention and Loan Servicing.
• Work with Global AML business partners on teh local application and requirements to ensure that regulator' requirements are met in addition to teh needs of Client's customers.
• Document requirements to extract Sales Credits and Profit & Loss for fixed income securities from Bloomberg, 12B-1 fees and Clearance Charges from Pershing, Remarking fees for Auction Rates and Variable Rate Demanding Bonds from START and Dalcomp.
• Involved in identifying teh common elements between teh trading tickets of various products traded by private banking clients (Listed equities, listed options, OTC derivatives, FX and FX options, Commodities and related options etc.) and in corporate teh same in teh FSD.
• Involved in loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Also gatheird requirements and updates RRT’s for technical team, which builds RDW reporting tools for merchants; handles teh testing and validation of upgrades and/or new reports.
• Co-authored many business requirements document with project teams for Fixed Income and Brokerage documents. Extract, discuss, and refine business requirements from business users and team members.
• Run advance SQL queries to document teh output details for each test condition (pass or fail) and create a SIR for all failed conditions or issues.
• Gatheird and Documented Business requirements to contribute to teh Risk/Return Analysis, and Portfolio Optimization and Diversification.
• Developed Business Requirement Documentation, Functional Specification Documentation, High Level Testing Plan, etc. Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Worked with teh components of Data Warehousing like components model, ETL tools.
• Maintained and kept track of stakeholder’s request for enhancements and changes using Unified Change Management Tool (UCM) such as Rational ClearQuest.
• Used Rational ClearCase, Configuration Management Tool to maintain different builds of teh application with description about all changes and versions.

Confidential, NH

Business Analyst

Responsibilities:

• Reviewed and analyzed teh business environment and identified process improvements.
• Analysis of business requirements and system requirements of teh client and also for Property and casualty modules
• Helped with data modeling and defining teh conceptual and logical model of teh data warehouse.
• Assisted in mapping teh requirements to teh source systems, teh DW and applicable data marts.
• Conducted user interviews, gatheird requirements, analyzed teh requirements by using Rational Rose, Visio and Requisite pro - RUP
• Coordinated activities with project manager and various other teams using MS Project.
• Teh project heads towards enhancing teh existing online banking application by improving its GUI, making it user-friendlier.
• Worked with a Derivative Management Systems IT group, Treasury Accounting, Regulatory, Murex Market Data & Trading Systems in a Business System Migration (Reval to Murex) and integrations.
• Performed custom data conversions and developed custom software for risk management applications including general claims, vehicle accident and administrative tracking. Performed all data field mappings.
• Define teh contracting terms based on various plans. Analyzed system requirements, developed detailed Test plan, Test cases, Test scripts for testing teh functionality, GUI and security testing.
• Worked in creating and integrating Microstrategy Reports and objects with teh data warehouse.
• Maintained a close and strong working relationship with teammates, developers, testers and management staff by conducted regular one-to-one sessions and group meetings.
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans. Designed and developed project document templates based on SDLC methodology.
• Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed teh test cases and finalized.
• Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
• Assisted teh Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Developed Test Plans and Test Cases according to Business Requirements.

Environment: Microsoft Office Suite, MS Visio, Windows NT/2000/XP, XML, JavaScript, GUI, UNIX, HTML, Oracle, SQL, UML, RUP, Mercury TestDirector, Mercury LoadRunner, MS Project, requisite Pro

Confidential, Stamford, CT

Business Analyst

Responsibilities:

• Analyzed data and created class diagrams and ER diagrams for designing. Gatheird teh information from teh competitor’s websites.
• Performed teh requirement analysis and documented teh requirements.
• Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about Business users sentiments.
• Interact with business stakeholders from multiple departments including: Card Finance, Accounting, Third Party Investor Reporting and Capital Market and led meetings and interviews.
• Teh system provides enhanced Business Process Management (BPM), new Portfolio Reporting System for High Net worth Clients and Credit Risk Management.
• Analyzed teh business requirements pertaining to Fixed Income Securities and Repo/Reverse Trading Cycle, Equities and Equity Trading Cycle, Derivatives.
• Gatheird requirements around teh Credit Card processing System.
• Teh system collects data from various departments, both finance and operational, merges it into a staging area, after cleansing it and tan loads teh data into teh EDW in accord with various data warehousing and business guidelines.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Worked on data modeling and produced data mapping and data definition documentation.
• Worked throughout teh SDLC, which included requirements, specifications, design, analysis and testing utilizing AGILE methodology.
• Perform daily processing for Single Stock and Listed Options instrument for Equity updates sent via PME. Involved in designing and developing Data Models and Data Marts that support teh Business Intelligence Data Warehouse.
• Evaluated Competitors offerings and products including fixed income and derivatives.
• Produced teh visual models for teh application using Rational Rose to create use cases, state charts, sequence diagrams, deployment diagrams and activity diagrams.
• Collected teh information about different entities and attributes.
• Developed data conversion strategy for data migration from MS Excel to MS Access.
• Used power point presentations for conduction walkthroughs with teh stakeholders.
• Conducted walkthroughs with teh end users and stakeholders to gather teh modification requests from teh user to upgrade or change teh business specifications for teh product.
• Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and insured that critical requirements are not missed. Monitored and analyzed teh development of cascading style sheets in HTML at front end.

Confidential, Milwaukee, WI

Business Analyst

Responsibilities:

• Extracted teh business requirements from teh end users keeping in mind their business needs and documenting it for teh developers.
• Gatheird business requirements through interviews, surveys, and observing from account managers and UI (User Interface) of teh existing Brokerage Portal system.
• Was responsible for creating teh various end to end Straw man flows for teh work streams and teh Clearing Broker/Dealer using MS Visio.
• Used MS Visio to designed and develop Use Cases Scenarios, Use Cases Models, Activity Diagrams, Sequence Diagrams, State chart diagrams using UML.
• Wrote businessrequirements which involved market riskanalysis and riskmanagement like continuous time finance & asset pricing, derivatives, structured products, Documentation, value at risk, risk& return optimization
• Worked with SQL queries using MS Access for data manipulations and involved in writing scripts for patient online registrations using teh VB Script.
• Implemented teh Rational Unified Process (RUP) Methodology during application development.
• Extensively used Rational RequisitePro to gather and manage requirements.
• Analyzed business requirements and segregated them into Use Cases and Activity Diagrams using Rational Rose according to UML Methodology thus defining teh Data Process Models.
• Performed Project Requirements Gathering, Requirements Analysis, Design, Development, Testing for teh ETL, Data warehousing and Reporting modules of teh project.
• Managed and organized requirement coverage, Test Case Management and Defect Management using Mercury Quality Center.
• Monitored Performance measurement, Risk Management and Asset management.
• Performed GAP Analysis of business rules, business and system process flows, user administration, and requirements.
• Extensively involved in RAD session to achieve early a design acceptable to teh customer and feasible for teh developers.
• Maintained and managed various versions of teh documents generated during teh project using Rational ClearCase. Identify teh source tables from which teh Data Warehouse extracts data.