SUMMARY

• Business Analyst wif 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 the Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).
• Experience in broad range of financial practices and principles 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 the 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 the 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 wif the 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 the investment banking sector to help design viable solutions.
• Worked wif 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 wif 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 wif 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 the 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 the coordination of the particular businesses (ICG, GCB) specific needs for the Global AML KYC project supported by fully documented plans, vetted wif global business owners (ICG, GCB), regional and country AMLCO representatives.
• Worked wif 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 wifin treasury management commercial operations which include but not limited to; project management, quality and cost reporting wif data analysis.
• Conducted User Interviews and Work Shops to gather accurate Business Requirements.
• Developed a business intelligence life cycle to address the business intelligence project team.
• Reviewed data model and reporting requirements for Cognos Reports wif the Data warehouse/ETL and Reporting team.
• Experience of working wif Treasury securities (T-Bills, T-Notes, T-Bonds & Tips) and Cash transactions to re- engineer the C-21 system.
• Understand and assist wif translating the impact of consumer AML commitments for data privacy, data quality issues or any other issues arising during the 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 the user interface.
• Managed the development, maintenance and, operation of finacial data warehouse used for Quality Reporting. Reported the bugs, Email notifications to the developers using Test Director.
• Set up market data including zero curves, correlation matrices, dividend curves, etc., and underlying financial instruments and then set up derivatives pricing parameters and trade capture options that drive the valuation of trade migration based on the market data to configure and test the system
• Worked at different stages of the Software Development Life Cycle (SDLC) wif 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 the 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 wif 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 the Functional and non - functional documentation for the equity, GL reconciliation and Counterparty Credit Riskwork stream based on theBusinessrequirement document.
• Collaborated wif 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 the UML methodologies.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the 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 wifin the business units is consistent wif 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 wif Global AML business partners on the local application and requirements to ensure that regulator' requirements are met in addition to the 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 the common elements between the 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 the same in the FSD.
• Involved in loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Also gathered requirements and updates RRT’s for technical team, which builds RDW reporting tools for merchants; handles the testing and validation of upgrades and/or new reports.
• Co-authored many business requirements document wif 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 the output details for each test condition (pass or fail) and create a SIR for all failed conditions or issues.
• Gathered and Documented Business requirements to contribute to the 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 wif the 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 the application wif description about all changes and versions.

Confidential, NH

Business Analyst

Responsibilities:

• Reviewed and analyzed the business environment and identified process improvements.
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules
• Helped wif data modeling and defining the conceptual and logical model of the data warehouse.
• Assisted in mapping the requirements to the source systems, the DW and applicable data marts.
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
• Coordinated activities wif project manager and various other teams using MS Project.
• The project heads towards enhancing the existing online banking application by improving its GUI, making it user-friendlier.
• Worked wif 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 the contracting terms based on various plans. Analyzed system requirements, developed detailed Test plan, Test cases, Test scripts for testing the functionality, GUI and security testing.
• Worked in creating and integrating Microstrategy Reports and objects wif the data warehouse.
• Maintained a close and strong working relationship wif teammates, developers, testers and management staff by conducted regular one-to-one sessions and group meetings.
• Interacted wif 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 the test cases and finalized.
• Developed UML Use Cases using Rational Rose and developed a detailed project plan wif emphasis on deliverables.
• Assisted the 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. Gathered the information from the competitor’s websites.
• Performed the requirement analysis and documented the requirements.
• Closely interacted wif designers and software developers to understand application functionality and navigational flow and keep them updated about Business users sentiments.
• Interact wif business stakeholders from multiple departments including: Card Finance, Accounting, Third Party Investor Reporting and Capital Market and led meetings and interviews.
• The system provides enhanced Business Process Management (BPM), new Portfolio Reporting System for High Net worth Clients and Credit Risk Management.
• Analyzed the business requirements pertaining to Fixed Income Securities and Repo/Reverse Trading Cycle, Equities and Equity Trading Cycle, Derivatives.
• Gathered requirements around the Credit Card processing System.
• The system collects data from various departments, both finance and operational, merges it into a staging area, after cleansing it and then loads the data into the EDW in accord wif 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 the 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 the Business Intelligence Data Warehouse.
• Evaluated Competitors offerings and products including fixed income and derivatives.
• Produced the visual models for the application using Rational Rose to create use cases, state charts, sequence diagrams, deployment diagrams and activity diagrams.
• Collected the 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 wif the stakeholders.
• Conducted walkthroughs wif the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the 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 the development of cascading style sheets in HTML at front end.

Confidential, Milwaukee, WI

Business Analyst

Responsibilities:

• Extracted the business requirements from the end users keeping in mind their business needs and documenting it for the developers.
• Gathered business requirements through interviews, surveys, and observing from account managers and UI (User Interface) of the existing Brokerage Portal system.
• Was responsible for creating the various end to end Straw man flows for the work streams and the 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 wif SQL queries using MS Access for data manipulations and involved in writing scripts for patient online registrations using the VB Script.
• Implemented the 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 the Data Process Models.
• Performed Project Requirements Gathering, Requirements Analysis, Design, Development, Testing for the ETL, Data warehousing and Reporting modules of the 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 the customer and feasible for the developers.
• Maintained and managed various versions of the documents generated during the project using Rational ClearCase. Identify the source tables from which the Data Warehouse extracts data.