SUMMARY:

• Senior Business Analyst with 10+ years of experience in system analysis, development, and enhancement of trading applications in the financial services industry
• Hands - on experience on project implementation using various SDLC methodologies such as Waterfall, Rational Unified Process (RUP), Agile XP, Agile Scrum, RAD, Iterative, V-model, and Incremental
• Proven expertise in gathering, analyzing, documenting business requirements, communicating effectively with end-users and IT community throughout requirements, solution design, testing, implementation stages
• Comprehensive knowledge of various financial products - equities, fixed income (Bonds, ABS, CDO, MBS, TBA-MBS, CMO), Interest-only (IO), Principle-only (PO), money-market instruments, FX, treasury bills, derivatives (Options, Futures, Swaps), equity derivatives, interest-rate derivatives, and credit derivatives
• Proficient with Fixed Income Securities: Treasury (Bills, Notes, Bonds), Municipal Bonds, Corporate Bonds, Floating and Variable Rate Notes, and Commercial Paper
• Strong experience in developing business requirement document (BRD), functional specification document (FSD), U se Cases, Data Flow Diagrams, and Business Workflow Diagrams
• Expertise in designing UML - Use Case Diagrams, Written Use Cases, Activity Diagrams, Sequence, Data-Flows, Swim-Lane Diagrams, Business Workflows, and Class Diagrams, using MS Visio / RationalRose
• Strong experience in Project Management tasks - Project Plan, Project Initiation Document, Communication Plan, Work Breakdown, Change Management, Status Meetings, Project Log, Status Reports
• Proven expertise in acting as primary liaison between business users and technical teams to identify, analyze, and translate user needs into system specifications and addressing enhancements requests
• Hands-on experience with several Derivative Trading Systems, Fixed Income & Equities Trading Systems
• In-depth understanding of financial risks like Credit Risk, Market Risk, Operational Risk, Volatility Risk and experience in financial risk management
• Understanding of Basel and Dodd-Frank regulations regarding OTC Derivatives across multi-asset classes
• Knowledge of financial networks and protocols such as FpML, SWIFT, and FIX
• Proficient in performing GAP Analysis to determine and document the variance between current capabilities of an application to actual business requirements
• Strong experience in ROI, Risk Analysis, Cost-benefit Analysis, Financial Analysis, and Financial Reporting
• Conducted weekly JAD sessions with business users to gather various business requirements and converted them to user stories
• Valuable knowledge of Accounting Principles - Opening / Closing Balance, Cash Inflow/Outflow, Profit & Loss, Balance Sheet, and Reporting
• Solid experience working with Quality Assurance (QA) team to create Test Plan, Test Cases, Test Scripts
• Proficient in building requirements traceability matrix (RTM) to ensure that all the project requirements are being met in all phases of development and testing
• Proficient in conducting various types of testing - Functional testing, Integration testing, System testing, Performance testing, Load testing, Stress testing, GUI, Smoke testing, Regression testing, End-to-end testing, User Acceptance testing (UAT), using several tools (WinRunner, LoadRunner, QualityCenter, QTP)
• Expertise in Fund Accounting - managing fund administrators (custodians) data feeds, data quality check, data load, generating client statements, balance / fee / profit & loss reconciliation, and client reporting
• Valuable experience in Defect Tracking Lifecycle Management by logging, analyzing, prioritizing, and reporting the defects, using Quality Center
• Solid experience with generating SQL queries to construct reports and conduct data analysis - retrieving, inserting, updating and deleting the respective data based on user’s criteria
• Proficient in Data Modeling, Data Mapping, and Cross-Data Integration of feeds from various reference data systems (Bloomberg, Reuters, Interactive Data)

TECHNICAL SKILLS:

Operating Systems: Windows 98/XP/Vista, UNIX, Linux

Databases: Oracle, Sybase, MS SQL Server, SQL, MYSQL, MS Access, RapidSQL

Programming languages: C, JAVA, JavaScript, JQuery, XML, HTML, PHP, VB, .NET, C++, Python, JSP, ASP, Servlets, Weblogic, VSS, Documentum

Testing Tools: TestDirector, QualityCenter, WinRunner, LoadRunner, ClearQuest, QTP

Business Intelligence Tools: Micro Strategy, Business Objects, Cognos, Crystal Reports, OBIEE, SSRS

Tools: MS Project, MS SharePoint, MS Office, MS Visio, Rational Rose, TOAD, SAP FICO, Erwin, Requisite Pro, MS Office, JIRA, DOORS, ALM

PROFESSIONAL EXPERIENCE:

Confidential, DC

Lead Business Analyst

• Market Data Team at Confidential provides Capital Markets Team (Treasury Desk, MBS Desk, Risk Team) with variety of data. The team has a foray of sophisticated applications to act as a gateway for vendor data, to perform modeling or integrate with internal modeling applications to further engineer data, to provide reports for users via GUI, drilled down reports, graphs or other applications via databases and ESB. The application offered web-based visual basic GUI that runs modeling and analytics on MBS portfolios while communicating with an internal modeling engine. It provides several reports ranging from MBS to Debt and derivatives; retrieves data via FTP from Bloomberg as per clients needs, and publishes data to external vendors. The application brings in real time data via circuit feeds to capital markets market room. It receives data files in several dealer emails, which are sifted and delivered to multiple clients in the format required.
• Acted as Lead Business Analyst on implementing new Microstrategy GUI, including database and ETL setup
• Applied Waterfall methodology, using structured techniques to understand the client specifications and requirements, documented the business process in Business Requirements Document (BRD) and translated business requirements into Functional Specifications Document (FSD)
• Analyzed current business functionalities and performed GAP analysis to design transition plan to shift from legacy system to future business process
• Interacted with traders to gather requirements and specifications for the development of new application and worked extensively with treasury desk to satisfy modeling and reporting needs, was involved in preparing business requirement documents including use cases
• Daily activities included performing activities of product owner, vendor manager, business analysts, operations analyst, and financial engineer
• Effectively worked on multiple methodologies including Waterfall, Agile SCRUM, Agile KANBAN
• Acted as Product Owner for multiple applications to effectively carry out application releases in SCRUM
• Constructed complex SQL queries to generate reports from application databases
• Lead the transition of the database to convert from Sybase to Oracle and retire the visual basic GUI to be replaced with Micro Strategy GUI
• Provided strategic support to the project manager in developing project plan, statement of work, scope statement, work-load management, sprint scheduling, project timelines, and communication plan
• Conducted weekly meetings with the clients to review functional specifications and resolve open issues
• Acted as Liaison between business users and IT dev team, QA team and other business stakeholders
• Acted as liaison between vendors like Bloomberg/Reuters/Tradeweb and Market Data Team at Confidential, managing the relationship and hosting weekly calls to track issues and maintain a line of communication
• Involved in designing various screens such as portfolio selection based on date, types of securities, ratings, performance and performing sensitivity analysis with changes in the parameters
• Worked closely with traders/stakeholders to determine and finalize requirements
• Understood requirements of users and recommended & implemented functionalities and reports, which helped reduced the daily activities and spreadsheet reliance for traders
• Further enhanced application to add new functionalities, analytics, and reports
• Understood client requirements, the changes required in the application, and to the pricing model
• Understood the user, application, data, and latency requirements. Worked closely with vendors and clients to enhance and ensure smooth operation of application
• Lead the changes required to implement large clients and allocated costs for clients every month
• Worked closely with Bloomberg and client to maintain smooth operations
• Understood IT limitations and requirements, performed UAT and integration testing with internal applications and external vendors
• Performed UAT and assisted with external UAT with several applications
• Lead UAT, daily operation and enhancements through the years

Environment: s: Micro Strategy, Oracle, Windows/Unix, Java, JSP, ASP, Servlets, Sybase, Documentum, Weblogic, VSS, Requisite Pro, Rational Rose, MS Project, MS Office, JIRA, DOORS, ALM, TOAD, RapidSQL

Confidential, NY

Sr. Business Analyst

• Equities / Equities Derivatives Trading Platform is a comprehensive front and middle office application suite, for all security types, including portfolio management and modeling; order management and electronic trading; pre-trade and post-trade compliance for the centralized management of trade matching, confirmation, and settlement workflow. It enables the Equity Managers and Equity Traders to process and trade the equities securities by creating orders, checking compliance, placing orders, executing orders, filling orders, account updates, report generation. The system offers functionalities such as send orders to trade; delete orders, view & query orders, tracking orders, targeting orders, re-balancer, and displaying reports.
• Created business requirement documents and functional specification document by interviewing end users, subject matter experts ensuring involvement of the stakeholders at all levels
• Adopted Agile SCRUM methodology - maintained product backlog & sprint backlogs throughout the project and conducted daily scrum meetings, sprint planning meetings, sprint review meetings, sprint retrospective
• Examined business requirements and employed UML guidelines to segregate requirements into high-level and low-level Use Cases, Written Use Cases, Activity Diagrams, Sequence Diagrams, Data-flow Diagrams, Business Workflows, Swim Lane Diagrams, using MS Visio
• Performed data mapping defining data source, target, and transformation rules to assist ETL team in setting-up the data load process into data warehouse
• Responsible for creating SQL queries to extract and analyze data from the underlying relational database in response to user’s data requests
• Assisted database designing team in Data Modeling by providing data requirements and helping in creating Entity-Relationship diagram classifying & identifying entities, attributes, and define the relationships
• Responsible for performing certain project management tasks along with project manager such as developing the scope, identifying the project deliverables, work breakdown chart, estimating & allocating resources, issue management, and change management process
• Worked on Clearing & Settlement and Accounting Module - setting-up functions to get the transactions cleared & settled, custodian reporting, accounting books maintenance, and reconciliation
• Served as liaison between strategic business units and IT development team to reconcile the conflicts, monitor day-to-day operations, and coordinate resources
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end-state requirements
• Organized JAD sessions to confirm consensus in the team, develop an architectural solution to address the business requirements, resolve open issues, and manage change requests
• Assisted QA team in developing test plan, test design, and test cases to perform Functional testing, Integration testing, End-to-end testing, GUI testing, Performance testing, Usability testing, Smoke testing, Regression testing, and User Acceptance testing (UAT)
• Worked on Quality Center for Defect tracking and management by logging defects, prioritizing defects, tracking defects, documenting defects, and generating defects summary reports
• Prepared the requirements traceability matrix (RTM) document, to track the test cases back to its business requirements and system specifications, ensuring both forward and backward traceability to confirm that all requirements are met in all phases of project

Environment: Windows/Unix, MS Visio, Quality Center, Java, MS Project, MS Office, Java/J2EE, HTML, Oracle, QTP, PL/SQL, Load Runner

Confidential, CT

Lead Business Systems Analyst

• Fixed Income Trading Station is a web-based solution designed to serve the front office, middle office, and back office. Fixed Income Trading Desk have the ability to process all fixed income products like government bonds, corporate bonds, asset backed bonds, mortgage back securities, and money market securities. This application is capable of performing order capturing, electronic trading, trade matching, and trade confirmation. It allows users to enter, view, modify, search, allocate and also match trades with five main views which are open trade, today’s activity, trade search, and unmatched trades in the application. The system also enables the use of processes like Allocating and Rolling over trades; and provides views like order status and execution status.
• Gathered, analyzed, and translated user needs into detailed business requirements capturing in BRD and translating requirements to system specifications capturing in System Requirements Specifications (SRS)
• Adopted RUP an iterative methodology to manage the project requirements, responsible for creating storyboards, and organized brainstorming sessions to understand the client needs
• Generated data mapping document to capture data requirements as well as identifying data source (respective data vendors / feeds); destination database (tables, columns); corresponding business rules
• Constructed complex SQL queries to generate reports and run DMLs to modify the data according to end-user’s specifications and criteria
• Created UML diagrams such as use cases, class diagrams, data flows, business workflows, swim lane diagrams, and state diagrams using MS Visio to communicate, explore, validate potential application design
• Provided strategic support to the project manager in developing project plan, statement of work, scope statement, work-load management, sprint scheduling, project timelines, and communication plan
• Served as liaison between project stakeholders, development team, and quality assurance team to ensure that business needs are well understood and technical implications are conveyed in user-friendly manner
• Worked with Data modeling team to design & build database for the application using Entity-Relationship (ER) diagram defining relational tables, primary & foreign keys, stored procedures, entities, and triggers
• Performed GAP analysis to identify the existing functionalities and desired end product, documented the gap and developed application development roadmap to fill the variance
• Conducted numerous walkthroughs & JAD sessions to define and review the business requirements, to develop an architectural solution, resolve open matters, and handle change requests
• Assisted QA team in creating test plan, test cases, and test scripts to conduct various types of testing such as Functional testing, System testing, Performance testing, Load testing, GUI testing, Usability testing, End-to-end testing, Sanity testing, Regression testing, and User Acceptance testing
• Used Quality Center to manage testing & defect life cycles, and map requirements to test cases
• Developed Requirements traceability matrix (RTM) to illustrate logical link between individual business requirements and other project artifacts including functional specifications, use cases, and test cases

Environment: s: Windows 2000/Unix, Requisite Pro, SQL, Rational Rose, MS Project, MS Office, ASP, VB, .Net, MS SQL Server, Web logic, Java, Management Studio, Quality center, QTP

Confidential, NY

Business Analyst

• The project entailed the development of full-fledged front-to-back office processing application for broad range of derivatives such as Options, Futures, Credit Default Swaps (CDS), Total Return Swaps (TRS), Credit Linked Notes (CLN), Collateralized Debt Obligations (CDO), Bonds, and Risky Bonds. The system captures all of the market data needed to price and trade derivative products, including Recovery Curves, Default Probabilities and Correlations. The application have significantly reduced time-to-market new products and increased control over the business.
• Interviewed business users to identify, gather, and analyze business requirements; created Business Requirement Document (BRD); transformed user requirements into functional specifications over various design meetings with development team; authored Functional Specifications Document (FSD)
• Adopted Agile SDLC methodology for application development and took lead role throughout all the phases
• Conducted GAP analysis to estimate the benefits of the new system v/s existing system
• Conducted JAD sessions with project stakeholders including business users, QA analysts, and project management team, to analyze requirements and design development plan resolving all discrepancies
• Acted as a strong liaison between the business unit and technical team to develop a solid knowledge base of the business line, including the business plan, products, and processes
• Acted as SPOC between Project managers, Project leaders, and Development teams throughout the project
• Extensively created UML diagrams which included Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Business Workflow Diagrams, and Class Diagrams, using MS Visio
• Analyzed data coming from external data providers, designed data mapping document, connecting external data with internal database and monitored data warehousing team in data integration
• Constructed Entity-Relationship diagram defining data objects, associations, attributes, domains, and constraints
• Worked with the QA testing team, creating test plan, test cases, test scripts and performed Functional testing, Integration testing, End-to-end testing, GUI testing, Performance testing, Usability testing, Smoke testing, Regression testing, and User Acceptance testing

Environment: s: Windows/UNIX, MS Visio, Use Case Analysis, Microsoft Office Suite, MS Project, UML, Visual Basic, .Net, SQL Server, Test Director

Confidential, CA

Systems Analyst

• Global Trading Application allows for trading baskets of securities designed to facilitate all traders on the same trading desk to see each other’s orders and baskets on a single window. Global Trading Application allows traders to gain faster and more complete visibility into the market via single system.
• Interacted with traders to gather requirements and specifications for the development of new application and worked extensively with equity trading group to leverage features and functionalities of equity trading system, was involved in preparing business requirement documents including use cases
• Utilized RUP Methodology to successfully work on and assist in managing the project to completion, in time and under budget
• Administered weekly meetings to ensure all groups were represented, requirements identified, work plans submitted and all deliverables & issues tracked to completion, provided project management umbrella for the development of Global Trading Application
• Conducted JAD sessions for open and pending issues with Management, Subject Matter Experts, vendors, users and other stakeholders
• Participated in the UI stage of application design, interacted with screen design team and users to ensure user experience and application requirements are taken into consideration; created wireframe models using MS Visio for GUI screen improvement
• Prepared the functional requirement document for two way communication with derivative service interface, performed cross-functional impact assessment for the integration and configuration of the GTA
• Participated in developing test strategy, test plans, test scripts, involved in cycle testing, regression testing, end-to-end testing to identify and track bugs, provided coordination for the UAT (User Acceptability Testing) execution

Environment: MS Project, Windows 2000, Visual Basic, Oracle, RUP, Rational Rose, UML, OOAD