Business Analyst Resume
Stamford, CT
Summary of Qualifications:
- Analytical and result oriented professional, with over 10 years of extensive experience, working with cross-cultural teams. Worked in Financial Services Industry with tier-1 clients as Business Analyst in diverse domains in Capital Markets in areas such as Fixed Income, Equities, Risk, Over The Counter (OTC) Derivatives, Electronic Trading floor applications, Financial reporting using Business Objects, SAP BW and Spreadsheets, leading and managing Business Process Re-engineering. Strong understanding of P/L operations from middle-office side.
- Strong understanding of Equities and Fixed Income products with respect to Brokerage Operations, Margin trading and Securities Lending. Worked on trade capture (OMS), Middle office operations and Back office settlements with DTCC.
- Solid understanding of Reference Data (pricing feeds and client data) and Data Analysis for real time market valuations with respect to Brodridge BPS Advantage
- Competent working with Business Intelligence, preparing and developing requirements for business objects reports.
- Successfully led design and deployment of overnight automated batch system for various products.
- Proficient in authoring Business Requirement Documents (BRD) using Requisite Pro and documenting business process specifications.
- Competent in analyzing and creating Use Cases, Use Case Diagrams, Activity diagrams, Class diagrams, Data/Flow/Navigational flow diagram using UML Tools like MS Visio and Rational Rose. Experienced in doing Data mapping within upstream and downstream applications for financial products.
- Very strong using MS Excel. Used advanced functions like V-lookup, Pivot tables and analysis.
- Experience in working in all phases of SDLC through out the project life cycle.
- Extensive experience in conducting Gap Analysis, Business Process Re-engineering, Designing Work flows and communicating the trade-off decisions on product features based on technology, budget constraints and customer requirements.
- Organized numerous Joint Application Development (JAD), Joint Requirement Planning sessions (JRP), Interviews, workshops.
- Worked on different software development methodologies like RUP and Agile.
- Adept in reviewing Test Procedures, creating Test plans, Test Scenario, defining System & Integrating Test Cases, executing Test Cases, Test Data reviewing and maintaining and executing detailed Test scripts for User Acceptance Testing (UAT), analyzing bugs, interacting with team members in fixing errors and UAT and also assisted in Post–Production support.
- Excellent communication skills and can effectively work in cross-cultural environment in diverse teams. Strong abilities to work in pressure-environments and effective problem solving and trouble-shooting skills.
Technical Knowledge:
Operating Systems: MS Windows NT 4.0/95/98/2000/XP, UNIX
Databases: MS SQL Server, Oracle, DB2, Sybase, MS-Access
Business Case Tools: Rational Suite, MS Visio, MS Project, MS Office Suite, Requisite Pro.
Testing Tools: Test Director, QTP, Rational Tools, MQC
ERP: SAP ( FICO & MM)
- Workflow Tools: MS Office Suite, MS-Visio, MS-Project, MEGA
Languages: Visual Basic (6.0), SQL, HTML, C++, Java, PL/SQL
Querying Tools: DB Artisan, Toad
Education: MBA - Finance
Cost and Works Accountant
Bachelors in Accounting
Professional Experience:
Client: Confidential,Stamford-CT May 2009 - Present
Role: Sr. Business Analyst (Consultant)
Project Scope: As a part of integration efforts of North America operations with London operations in the Equity Derivatives space, the initiative was aimed to effectively manage risk across different legal entities.
Role & Responsibilities:
- Interviewed different functional groups for preparing current state and future state Target Operating Model (TOM) using MS Visio.
- Extensively interviewed traders and front office support to understand the trade booking of equity derivative in Fidessa and TOMS (Bloomberg). Documented and analyzed Converts, Structured products and Listed options trade booking model with front office.
- Worked on restructuring the Listed Options front-to-back office trading model. Listed options mainly involved equities as the underliers. Underlying assets (equity) is captured in fidessa and settled in ADP.
- Analyzed and discussed the impact of using listed options as a strategy for macro hedging in broker dealer in US. Listed Options were also used for macro hedging the market exposure in the London Branch (RBS NV), which resulted in split hedge.
- Validated the TOM (Target Operating Model) with compliance, regulatory, operations, legal and tax perspectives to study the impact on broker dealer and London operations.
- Conducted interviews with traders, Front office support and front office technology to understand the trading of equity derivative products and capturing the impacts on the future state.
- Captured high-level requirements from different functional groups like Market Risk, Credit Risk, Operations, Financial Reporting and Trade Accounting and Product Control.
- Proposed and analyzed back-to-back models to transfer market risk to London Branch.
- Involved in the preparation of test plans and test scripts in MQC. Coordinated the UAT testing with the business users.
Client: Confidential,NYC-NY Sep 2008 – May 2009
Role: Sr. Business Analyst (Consultant)
Project Scope: Morgan Stanley is transforming itself into Morgan Stanley Holding Company. As a part of compliance initiative, the project is based on developing a centralized repository for compliance perspective (mainly for the purpose of Fed Audit) in ISG (Institutional Securities Group) Operations. The repository proposed to be built should contain the central and global policies and procedure documents. These documents need to be collected from various regions across the globe, which are currently stored on local share point sites and share drives. The main purpose of the project is to analyze these documents in their current state and simultaneously remediate them. The documents being analyzed are spread across various domains like Equity, Fixed Income, Commodities, Derivatives and Prime Brokerage operations.
Role & Responsibilities:
- Interacted with the various divisions among the operations group across the globe to gather their documents and understand their business requirements with respect to the repository being developed.
- Analyzed the document provided by the different operations group and prepared the Inventory Matrix.
- Developed the project plan using MS Project and tracked the progress.
- Involved in preparing the BRD for the proposed central repository (KEY Application) to be developed.
- Conducted several JAD sessions with the technical group handling the development of key application.
- Performed UAT for the application developed.
- Involved in remediation of Policies and Procedure documents.
Environment: MS Office Suite, DB Artisan, Requisite Pro, Unix, Sharepoint.
Client: Confidential,Jersey City-NJ Sept 2007 – Aug 2008
Role: Sr. Business Analyst (Consultant)
Project Scope: The project is based on re-engineering of the Market Risk application called LehmanRisk and CAMEO application (Collateralized Asset Management and Exposure) as a part of enhancing the feature in Electronic Trading. The application is meant for calculating margins and Risk Based Margin (RBM) using VaR, for various Fixed Income and OTC Derivatives products with margin centers like Derivatives, Futures and Repos as per the client contracts and determine the Collateral requirements on day-to-day basis due to change in Mark-to-Market valuations. Institutional clients in the prime brokerage areas may use this application to track their margin requirements.
Role & Responsibilities:
- Interacted with the SMEs along with Operations Group, production support groups, various teams on business side to gather client specific business requirements and translate them in a various business artifacts for the flow documentation.
- Worked on BPS Advantage and used SQLs to access data from RDMS, which is loaded on nightly batch runs for positions, balances and other reference data.
- Performed Data Analysis for pricing feeds coming from Reuters, Bloomberg and Enterprise Security Master (ESM).
- Involved in developing a web based environment for margins.
- Prepared financial reports for reporting Margins to the clients on day-to-day basis.
- Analyzed the existing business process flows for Equities and Derivatives to gain understanding of the existing system and documented the business process flows for the proposed system. Business flows documented contained information flowing from upstream applications to the downstream applications and any impact made using GUI by the users.
- Analyzed the Market Data and the bottlenecks of various upstream applications in getting the ‘Positions’, ‘Journals’, and ‘Prices’. Used SQL queries for extracting the data from the DB using DB Artisan.
- Worked with ETL (Informatica) developers for creating real-time data interfaces and DB extracts (ETL Design).
- Analyzed the bottlenecks between the feed arrival time of the upstream applications and the formal SLAs and analyzed its impact on the downstream applications.
- Developed Data Models and done Data Mapping across downstream applications of Cameo.
- Actively involved in developing 130 plus system flows from front-to-back office operations.
- Worked on Business Intelligence for generating margin reports for clients. Interacted with Business Objects developers and prepared various matrix and graphical reports in business objects.
- Developed the project plan using MS Project and tracked the progress.
- Tested Business Objects reports in UAT using Pivot Tables in MS Excel.
- Organized several meetings with SMEs situated across the globe (London, New York, Tokyo, and Mumbai), using WebEx and conference calls.
Environment: Windows XP, Windows 2000, Microsoft SharePoint, MS-Access, MS Visio, MEGA,SDLC, SQL, PL/S, DB Artisan, Unix, ERWIN, JIRA.
Client: Confidential,Stamford CT April 2007– Aug 2007
Role: Business Analyst
Project Scope: Worked on Client Aligned Reporting initiative using Business Objects . Thin client reports were developed for DTC (Depository Trust Company) fails and trade breaks that may occur, when the particular trade executed by the client, does not get settled till the settlement date. This involves identifying the DTC confirms and the details of executing broker on behalf of the client. Fails and Breaks capturing is done by identifying the interfaces from front-to-back office operations with DTC. UBS being a prime broker, the project involved reporting details to its client’s viz. fixed income and equity clients. For reporting purpose the reports were later on developed in business objects for client aligned reporting.
Business Area: TAS PBIT (Trade and Asset Services-Prime Brokerage operations)
Role & Responsibilities:
Role & Responsibilities:
- Interacted with the Business Owners and SMEs, to gather client specific business requirements and translate them in a various business artifacts for the technical team.
- Conducted user interviews, facilitated JRP and JAD sessions to better understand the business domain, requirements and project scope.
- Conducted walk through sessions with the business users and the stake holders of the project to facilitate the BRD sign off process.
- Performed risk analysis of the requirements to identify the key business risks areas for the project and prioritized the application development and testing.
- Used RequisitePro to organize and analyze the business requirements. Gathered the Business requirements & documented them into Business Requirement Documents (BRD).
- Developed strategic partnerships with the Business Users to develop solid knowledge base of the business line, including the business plan, products and process.
- Facilitated weekly meetings with the review teams to continuously improve the Quality Assurance (QA) process for the application development.
- Worked on logical data modeling to represent graphically about what the information is about, how to relate it with business concepts and how to apply business rules to the system.
- Collaborated with the QA Group to ensure adequate testing of application both before and after completion, maintained quality procedures, conducted UAT Testing, and ensured that the documentation is in place.
Environment: MS Office Suite, Oracle, ERWIN, Business Objects, Broadridge BPSA
Client: Confidential,Dallas, TX June 2005 – March 2007
Role: Sr. Business Financial Analyst
Project Scope: This was a web based application project and the asset classes included the capital market products such as equities and OTC derivatives. The application uses market data to value the trade. With the risk methodology, it can generate paths and stress scenarios so that trade can be valued against various paths and scenarios. It also allows traders to perform what-if analysis, stress test and Computed the VaR under different confidence levels. The product also allows for adding different asset classes at different stages. Finally, this would be integrated with Pricing and P/L calculations. Collateral required for their clients was also calculated in the enhanced application.
Role & Responsibilities:
- Responsible for Fixed Income and OTC Options part of the project. Involved in the Monte Carlo simulations using market data and to value the trades. Simulated yield curves with different spreads under various scenarios and used these curves to simulate the P/L path.
- Worked extensively on risk calculation and model development, path/scenarios generation and valuation model.
- View holdings in the portfolio in terms of market risks – equity, fixed income, currency, and commodities etc., in which drives VaR (Value at Risk), Equities.
- Facilitated and coordinated Joint Requirement Planning (JRP) sessions for communicating and managing expectations with business users and to understand thoroughly the business process and the interface requirements which need to be incorporated in the application.
- Worked with the technical team and Conducted Joint Application Development (JAD) sessions to discuss the business requirements, workflow, data availability and environment details and planned phases in development to facilitate SRS design.
- Provided assistance to Technical Lead in Analysis & Design of architecture using UML & Visio.
- Created SQL statements to validate the data tables.
- Involved in developing the test strategy and assisted in developing test plans, test case objectives and test cases. Helped in developing QA Test plans for Functional, Integration and System Testing. Performed Black Box Testing. Performed GUI testing and user acceptance testing (UAT).
- Provided training to the business users and involved in preparing user manuals.
Environment: Oracle, Windows XP/2000, MS Visio, MS Office, SQL, HTML, Java, J2EE, Java Servlets, Rational Suite, Requisite Pro, Rational Rose, LINUX, Test Manager, UML
Client: Confidential,Baltimore, MD June 2004 – May 2005
Role: Sr. Business Analyst
Project Description: The system was required to process the increased volumes with a much more predictable latency and minimizes the latency between trade capture and risk updating. The firm needed to ensure queries made to its trading system did not delay business critical information reaching its traders. This enhanced the capacity to process more trades per second and Market Risk. Improvements were made to queuing in the existing system and introduction of business focused interfaces based on Web services between client and middle tier.
Role & Responsibilities:
- Facilitated meetings with clients, brokers and a group of business partners to identify the needs and requirements of the new system, prioritized and organized these requirements in a systematic fashion, evaluated and compared potential solutions.
- Participated in the identification, understanding and documentation of business requirements including the applications capable of supporting those requirements. Collected and documented business processes as well as business rules.
- Comprehensively worked with Requirement Gathering for Fixed Income Trading System and produced initial requirement data to produce User Interface and Business Process Requirements. Designed the business requirement collection approach based on the project scope and System Lifecycle (SLC) Methodology, documented the same in Business Requirement Document (BRD).
- Gathered business requirements through one on one interviews of brokers and traders, surveys, controlled brainstorming sessions, prototyping and conducting JRP session.
- Reviewed the business-critical elements with the help of traders, system developers and the portfolio managers.
- Conducted Gap Analysis of existing architecture and prepared workflow scenarios, designed new process flows of the proposed trading floor system.
- Extensively used wire framing to design several UI Screens for the traders and brokers.
- Used UML to draw system requirements with Use Case Diagrams, Use Case Scenarios, Activity Diagrams and Sequence Diagrams, identified system functionality and wrote Use Case for the same.
- Collaborated with Technical Architect to develop both High Level and detailed application architecture to meet the business needs. Involved in establishing relational database management systems with system developers.
- Planned, tested, and implemented system enhancements and conversions. Extensively wrote SQL queries for QA testing, reporting/data validation.
- Involved in imparting training to the business users and preparing user manuals.
Environment: Java, Java Swing, Servlets, JavaScript, JSP, Oracle, UML, Windows XP, Sun Solaris, Linux, WinRunner, TestDirector, J2EE, Rational Suite, Rational Rose, MS Office, MS Visio, Clear Quest
Client: Confidential,New Delhi, India May 2002 – April 2004
Position: Business Analyst/Quality Analyst
Project Scope: The Company offers products across the full spectrum of investment classes, ranging from equities, fixed income and multiple-asset class products. The application was developed as a product to capture, analyze, calculate and report risks for all asset classes traded by the client bank. The asset classes included equities, bonds, commodities/metals, ABS, MBS, derivatives. The application uses market data to value the trade. With the risk methodology, it can generate paths, exposures and stress scenarios so that trade can be valued against various scenarios and benchmarks. It also allows traders to perform what-if analysis, stress test and computed the VAR under different confidence levels. The product also allows for adding different asset classes at different stages.The system also allowed timely report generation based on the format and the key fields specified by the SMEs.
Role & Achievements:
- Interacted with the Business Owners and SMEs along with Risk Managers and Project Architects, to gather client specific business requirements and translate them in a various business artifacts for the technical team.
- Conducted user interviews, facilitated JRP and JAD sessions to better understand the business domain, requirements and project scope.
- Created UML diagrams such as Use Cases, Activity Diagrams, and State Chart Diagrams using MS Visio.
- Implemented RUP and followed iterative Use Case driven process for requirement documentation and deployment.
- Conducted walk through sessions with the business users and the stake holders of the project to facilitate the BRD sign off process.
- Performed risk analysis of the requirements to identify the key business risks areas for the project and prioritized the application development and testing.
- Gathered the Business requirements & converted them various Business Requirement Documents (BRD).
- Developed strategic partnerships with the Business Users to develop solid knowledge base of the business line, including the business plan, products and process.
- Facilitated weekly meetings with the review teams to continuously improve the Quality Assurance (QA) process for the application development.
- Worked on logical data modeling to represent graphically about what the information is about, how to relate it with business concepts and how to apply business rules to the system.
- Created Traceability Matrix between the Use Cases (Requirements) and Test Cases, developed detailed Test plan, Test Cases, Test scripts for testing the functionality, GUI and security testing.
- Collaborated with the QA Group to ensure adequate testing of application both before and after completion, maintained quality procedures, conducted UAT Testing, and ensured that the documentation is in place.
Environment: Windows 98/NT/2000 Server, MS Office Suite, Oracle, JAVA, J2EE, JavaScript, WebSphere, WinRunner, LoadRunner, HP UX
Client: Confidential,India Jan 1999 – April 2002
Role: Manager Finance
Project Scope: Confidential,is India\'s largest private sector enterprise, with businesses in the energy and materials value chain. Group revenues add up to USD 20 billion. The flagship company, Reliance Industries Limited, is a Fortune Global 500 company. The Group\'s activities span exploration and production of oil and gas, petroleum refining and marketing, petrochemicals (polyester, fiber intermediates, plastics and chemicals) and textiles. The project was to implement SAP/R3 in the textiles division, to integrate all the functions. Implement FICO & MM modules initially and then transition from legacy to SAP by fully implementing other modules, SD and PP.
Role & Responsibilities:
- Studied and analyzed the business process information from the business users in all the functional areas and prepare the Business process Document. Also gathered the information for the areas of improvements to be incorporated into SAP. Worked actively in SAP FICO module.
- Collected information from the SME’s in all functional areas to study the impact of other modules like SD, MM and PP.
- Involved in gathering requirements from SMEs regarding smart forms and getting them designed by developers.
- Involved in creating BDCs by analyzing company’s legacy data and then conceptualizing its implementation in the ERP.
- Prepared Use Cases to explain the functional requirement of SMEs to the Basis person in SAP.
- Studied the impact of integrating the functions with key persons in all the functional areas.
- Involved in the configuration phase.
- Tested the system using real-time transactions and studied the impact. Analyzed and compared the results of SAP with legacy system, and implemented the changes when required.
- Trained the functional people in respective areas.