Business Analyst Resume
New, YorK
PROFESSIONAL SUMMARY:
- 10+ yrs of professional experience working as a Business Analyst in several capital market projects.
- Extensive experience in business analysis, gathering requirements, development and enhancement of trading applications. Involved in Credit Risk Management (Credit Linked Notes/ Collateralized Debt Obligations) and Credit Derivative instruments in the full life cycle of trade.
- Expertise in conducting Joint Application Development (JAD) Sessions, project meetings, reviews and walkthroughs acting as a liaison between application vendors, technical, managerial teams at various levels. Firm Understanding of various asset classes such as fixed income, Equity OTC and Credit Derivatives, (Futures and Options), mortgage backed securities, Treasury securities, Muni - Bonds. Experienced in capital markets catering to a host of financial domains including Charles River IMS.
- Experience in calculating Profit and loss calculations at holding and portfolio level. Have had significant exposure to benchmarks and indices.
- Hands on experience working on several SDLC methodologies such as RUP (Rational Unified Process) Agile and Waterfall in Application development.
- Proficient in creating UML Diagrams and Data Analysis by writing Complex SQL Queries on various databases such as Oracle, MS SQL servers, Ms Access and Sybase.
- Extensive know-how of documenting system blueprints, business process workflows, Data Flow Diagrams using MS Visio.
- Expertise in delivering Time-Sensitive information ensuring the scope & requirements of the project and tracing the deliverables from initiation to implementation via Requirement Traceability Matrix (RTM).
- Experience in performing GAP Analysis, identifying the variances between ‘As-Is’ and ‘To-Be’ business process. Performed incremental improvements to the ‘To-Be’ process by employing Business refinement procedures.
- Experience with Financial terms and calculations: VAR (Value at Risk), Convexity, Duration, Durational/Notional Volume, Greeks, Bond Valuation, Fund performance calculations.
- Assisted DBA’s in building data models identifying various attributes and tables.
- Developed various screen mockups and wireframes using Ms Visio and SnagIT (only used in enhancement for screen capture).
- Expertise in managing testing life cycle - Prioritizing Defects and resolving Critical Issues, reporting, maintaining the issue log.
- Hands on experience in Conducting System Testing, Data Testing, Integration Testing, Functional testing and facilitated User Acceptance Testing.
TECHNICAL SKILLS:
Languages: Java, C++, C, Visual Basic,.NET,J2EE
Operating System: XP/NT/2000/98,UNIX, LINUX
Databases: Oracle, SQL Server, MS Access, Sybase.
Business Modeling Tools: Rational Rose, MS Visio, Visual Paradigm.
Other Tools: Ms Project, MS Office Suite, Ms FrontPage.
Testing/Defect Tracking Tools: Mercury Test Director/Quality Center, Quick Test Pro, WIN Runner and Load Runner.
WORK EXPERIENCE:
Confidential, New York, New York
Business Analyst
Responsibilities:
- Identifying all Local German reports which would be directly affected by this huge trading volume book move.
- Analyzing the Impact in terms of developmental and configuration changes for these reports.
- The migration activity was actively carried out in 2 phases:
- Identifying Local German reports which have are currently being reported under the London branch (LDN:840) which had to be migrated to the Frankfurt branch (DB AG FFT: 0100)
- Identifying Local German reports which were currently reported under the Frankfurt branch (DB AG FFT:0100) which then will be migrated to the New Frankfurt Branch (DB AG FFT:0110).
- Identifying Non-Local German reports which originated outside of Germany but were reported under a German regulator i.e. BAFIN, Bundesbank, Clear-stream and German Exchanges.
- Analyzed all Local German reports and assisted in the implementation of trade volume migration under the stated book move from the UK Entity (840) to the current (0100) and future (0110) German Entity.
- Assisted in the creation of testing scripts, liaised with all cross-functional teams and associated divisions in order to facilitate Regression testing for all local German Reports.
- Elicited Business and Functional requirement documentation from Business Users and SME’s for report economics i.e. Report Names, Description, Regulator, Regulation, Reporting entity and associated division etc.
- Defined Documented, Analyzed and Prioritized requirements for over 1000 local German reports.
- Created a Report Inventory of over 5000 reports both German and Non-German by liaising with various divisions. This inventory served as the base for all analysis which assisted in the regression testing for the German reports and finalizing the report migration to the Frankfurt Reporting Entity.
Confidential, New York, New York
Business Analyst
Responsibilities:
- Elicited Business and Functional requirement documentation from Business Users and SME’s for Position and Collateral Exposure Information by Netting Agreement to be reported at a CUSIP level supplemented by details such as collateral market value, notional value, collateral jurisdiction etc.
- Defined Documented, Analyzed and Prioritized requirements and modeled the Business/ Functional requirements.
- Documented Legal Netting and Collateral Enforceability, Collateral thresholds/haircuts, Collateral Rehypothecation rights and Pending Margin Calls for reporting purposes.
Confidential, New York, New York
Business Analyst
Responsibilities:
- Assisted in development of Collateral Class Reporting, leverage risk weights as derived for the reporting of Basel III risk based capital.
- Assisted in the creation of reports involving Initial and Variation Margin. IM is further segregated depending on Confidential ’s position as the House or the Customer.
- Assisted in development of enhanced Liquidity and Funding Reports used for CCAR/CLAR Reporting.
- Elicited Business and Functional requirements from Business Users and Subject Matter Experts for 5G/CCAR/CLAR reporting.
- Defined Documented, Analyzed and Prioritized requirements and modeled the Business/ Functional requirements.
- Documented Security Segmentation characteristics in order to build business logic to create reports for various securities.
- Created File Specification and Business Rules Documentation for various collateral sources and under collateralized deposit accounts in order to update correct balances to be reflected on the Liquidity Reports prepared for the business stakeholders.
Confidential, New York, New York
Business Analyst
Responsibilities:
- Assisted in the calculation of Portfolio returns (Cumulative/Average Total Return) and Portfolio Risk (Alpha, Beta, Sharpe Ratio and Standard Deviation).
- Assisted in the calculation of various expense ratios. (Gross Expense, Gross Expense to Net Asset, Net Expense to Net Assets and Net of Inverse Floaters).
- Assisted in calculating Total/Average Annual Returns (With/Without Percentage of Sales Charge)
- Created spreadsheets for Traceability analysis for resolving defects and created client reports using Cognos Reporting Tool.
- Served as the principal conduit for managing system requirements between the Business and IT Team to be used in completion in various segments.
- Effectively communicated and assisted other team members in ongoing assignments.
- Assisted in development of Commentaries, Involved in extensive Product Analysis, Sector Attribution Analysis, formulation and strategy for Investment processes involving Duration, Yield Curve and Sector/Rating.
- Assisted in the development of Factsheets focusing on Style, Strategy Focus and Investment Approach for Domestic Debt/Equity, Global Debt/Equity and Emerging Markets Equity Assets.
- Assisted in the development of Portfolio construction by doing market research, valuation and quantitative analysis for various asset classes.
- Elicited Business and Functional requirements from Business Users and Subject Matter Experts for Client Reports, Factsheets, Commentaries and Pitch Books.
- Defined Documented, Analyzed and Prioritized requirements and modeled the Business/ Functional requirements.
Confidential, New York, NY
Financial Business Analyst
Responsibilities:
- Liaised with business stakeholders from Bridgewater and BNY Mellon and assisted in the integration of varied asset classes i.e. ETD Futures, Options, Commodities, Repo’s and Swaps (IRS, TRS, CCY, CDS, CDX) in their trade capture systems.
- Assisted in product end-to-end lifecycle events and Security Validation from Bloomberg to be integrated across all systems of Bridgewater and Confidential .
- Served as the principal conduit for managing system requirements between the Business and IT Team to be used in completion in various projects.
- Elicited Business and Functional requirements from Business Users and Subject Matter Experts for Client Reports, Dodd Frank Requirements and Trade Financial Enrichment Applications.
- Assisted in creating and presenting complex stakeholder presentations with Project L senior executives from PriceWaterhouse Coopers.
- Defined Documented, Analyzed and Prioritized requirements and modeled the requirements/specifications.
- Effectively communicated and assisted other team members in ongoing assignments.
- Involved in extensive product analysis, formulation and strategy for trading in the complex business systems.
- Created spreadsheets for Client Reports, Traceability Analysis for resolving defects and graphs to illustrate technical reports.
- Performed Business Process Design in conjunction with operational teams.
- Assisted in requirements validation and requirement traceability analysis.
- Interviewed Middle Office users and Operations to understand their current business processes, identified and assessed functional requirements and managed production releases.
- Formulated and Implemented strategies for resolving data integrity issues assisting in operational rollout and support.
- Served as the principal conduit for managing system requirements between the Business and IT Team to be used in completion in various projects.
- Elicited business requirements from Business Users and Subject Matter Experts.
- Defined Documented, Analyzed and Prioritized requirements and modeled the requirements/specifications.
- Effectively communicated and assisted other team members in ongoing assignments.
- Worked as a Financial Business Analyst on OTC Derivative Products, Trade Capture, Dodd-Frank and Data Management requirements as per stakeholder specifications.
- Assembled spreadsheets created and presented charts and graphs to illustrate technical reports.
- Performed Business Process Design in conjunction with operational teams.
- Assisted in requirements validation and traceability analysis.
- Formulated and Implemented strategies for resolving data integrity issues assisting in operational rollout and support.
Confidential, New York, NY
Business Analyst
Responsibilities:
- Decommission Project: Liaised with diverse business stakeholder groups and managed overall project which involved migrating users from Confidential Sales Workbench to Lehman Application Sales Workstation. Used MS SQL for querying data for users spread globally across Rates Sales Desks. Assisted DBA’s in writing these complex queries as the user desks needed to be combined with the kind of products traded and also the branch to which they were tagged in a particular sales desk.
- CP Migration to Rates Project: Commercial Paper was traded on a separate platform (CP Sales Workstation) which had to be migrated to Rates Sales Workstation. Liaised with Business Users and assisted in project initiation and completion. Designed User Guides detailing out the salient features of the new application.
- Client Allocation Portal (CAP) Project: A Web based portal in Client Facing Technology which enables Confidential clients to enter allocations for their trades. Prepared BRD and liaised with users to have the Web portal go-live and get the clients on boarded.
- Managed end-to-end product stream. Involved in user prioritization meetings and resolved issues with business users/stakeholders for the system enhancements deployed in the CDS Trading Platform.
- Prepared Business Requirements Document and created Functional Specification and Data Flow diagrams in Ms Visio. Performed business analysis, requirement specifications using Rational Unified Process (RUP).
- Facilitated and Implemented Dodd-Frank requirements in the CDS Trading Platform. (Eg: USI Indicators, Novation Requirements)
- Interviewed front office, middle office users to understand their current business processes, identified and assessed functional requirements and managed production releases.
- Liaised with worldwide Business, Operations and Tech teams to ensure timely delivery of new enhancements per stakeholder request. Eg: P12 Project (Initiating E-trading in Asia).
- Performed business and system level analysis, and provided documentation for deliverables.
- Used Advanced MS Excel for creating Pivot Tables for users spanned across global credit derivative desks, kind of credit derivatives traded and defects logged while booking trades to be prioritized and fixed as per User Prioritization meetings.
- Coordinated between cross channel teams to identify and resolve daily production issues.
- Prepared test cases for User Acceptance Tests (UAT) and designed test plans for system integration testing phase.
- Involved in writing and analyzing test scripts/data and liaised with QA team to ensure functional requirements have been covered prior to any production release.
- Facilitated and ensured user awareness of new functionality through sessions, demos and release notes post every production release.
- Gathered Business Requirements from stakeholders located globally, ran user prioritization meetings, overviewed production releases and was involved in the entire SDLC for the application.
- Devised performance metrics for business users in terms of Hit and Fair-Hit Ratios which give the management a clear perspective on the trading performance of their diverse product teams.
- Liaised with DBA’s to gather backend Trade data, creating indexes, Joins, and functions using MS SQL.
Confidential, New York, NY
Sr. Business Analyst
Responsibilities:
- Interviewed traders, portfolio managers, SME’s (Subject Matter Experts) to gather business requirements for the TBA mortgage securities mostly steered towards financial risk management for TBA securities and credit derivatives.
- Employed RUP Methodology to prepare Business Requirement Document based on the information gathered and adhered to Software Requirement Specifications as per client need.
- Documented Functional Requirement Document from Business requirement Document.
- Organized the JAD session and did the analysis of the requirement.
- Prepared Data Flow-diagrams using Ms Visio to document the flow of varied Mortgage Pool Positions in the MBS Trading Module.
- Managed the information flow and data processing of various mortgage pool positions traders entered, based on mortgage type, issuer type and coupon rate.
- Monitored system processes on a daily basis and maintained log of any bottlenecks encountered and reported for proper system functioning.
- Prepared UML diagrams, Use-case scenarios using MS Visio and analyzing data threads adhering to Traceability Matrices, Activity and Class diagrams to support functional specifications.
- Analyzed application complexities encountered during the trade process and devised change management procedures based on Credit Derivatives and risks encircling the same.
- Performed Data Gathering to develop custom reports for trading platform users.
- Wrote SQL queries for data retrieval from various databases for performing data analysis.
- Assisted QA Team in writing Test Plans and Test Cases.
- Performed User Acceptance Testing before application deployment.
- Ensured proper application deployment along with the QA Team.
- Provided Production Support to the traders by providing resolution to any reported system issues that may arise during a trading business day.
Environment: s: Java, .Net, Ms Visio, Oracle, Ms Access and Test Director/Quality Center.
Confidential, New York, NY
Sr. Systems Analyst
Responsibilities:
- Bridged the gap by performing Variance Analysis by creating new application platform by automating the old system.
- Interviewed clients to understand business and functional specifications in light of current business processes. Involved with SME’s in risk management techniques to hedge any foreign exchange risk encountered in the trade process.
- Involved in defining the project objectives and scope, applied RUP methodology to meet business processes, business rules and constraints.
- Prepared BRD detailing all aspects relating to the application.
- Conducted the JAD session to bring all the team members as well as the business people on the same wavelength and took sign offs from the business people.
- Added Baseline requirements to the business by conducting the requirement analysis and translated them into functional requirement document.
- Developed various process/data flow diagrams such as activity, use case diagram, UML, Sequence diagram.
- Assisted developers in understanding the automated administrative function requirements for wealth management functionalities.
- Assisted QA Team by writing test cases and performing all functional tests like regression testing, smoke testing, sanity testing.
- Organized and co-coordinated UAT testing. Designed and Developed UAT test plans, test scenarios and test cases
- Managed project requirements by controlling project scope, identifying and resolving key issues and risks timeline to ensure quality, on-time deliverables.
- Performed data analysis to identify trends and Used Data Modeling as a means to integrate current and future business requirements and workflow.
- Used SQL to query data from the Security Master Database and gathered data from multiple live data feed sources such as Bloomberg, Confidential .
- Participated in design review to ensure the integration of both applications.
- Prepared several checklists and deployment plans, maintained excel sheets with detail information of support procedures, roles and Roles and Responsibilities of the support team
- Managed and delivered client reports using Crystal Reports Tool.
- Assisted in developing a Change Management Plan in accordance with the team to document different system scenarios and identified roles impacted by the same.
Confidential, New York, NY
Business Analyst
Responsibilities:
- Worked with business users for gathering and defining business requirements, writing specifications and translating statement of work into business and system level requirements.
- Interviewed front office, middle office users to understand their current business processes and functional requirements, User Interface Requirements to gauge their future needs.
- Liaised with worldwide Business, Operations and Tech teams (trade data source systems, dev teams).
- Performed business analysis, requirement specifications, and project planning in UML using Rational Unified Process (RUP).
- Prepared Data flow-diagrams using Ms Visio to pinpoint system privileges ensuring organized work flows.
- Performed business and system level analysis, and provided documentation for deliverables.
- Developed detailed functional specifications, built data and functional models, and developed reports. Assisted in credit risk management and foreign exchange risk management.
- Prepared Business Requirement Document and converted business requirements to Functional Requirements adhering to Technical Specification using Rational Requisite Pro.
- Performed detailed non-functional requirements analysis, including usability, reliability, performance, and scalability. Transformed business requirements to technical models.
- Coordinated between the cross channel teams to identify and resolve issues.
- Prepared test cases for User Acceptance Tests (UAT) and designed test plans for system integration testing phase.
- Involved in writing test scripts and analyzing test scripts/data to ensure functional requirements have been covered.
- Facilitated implementation of new functionality through sessions, demos, and the development of appropriate documentation and provided relevant test scenarios for the testing team.
Confidential
Business Analyst - Enhancement of SX3
Responsibilities:
- Gathered requirements from mortgage servicers and lending institutions on forms and pre-requisites for getting modification.
- Prepared BRD listing each requirement detailing the variant requirements of each servicer coordinating with government policies using Agile methodology.
- Prepared flow-diagrams using Ms Visio to pinpoint system privileges ensuring organized work flows.
- Prepared FRD to assist developer team and conducted weekly meetings to make sure that application was developed in phases meeting the deadline.
- Developed Test Cases for the Testing Team and performed UAT.
- Performed Black Box Testing, Smoke testing and Sanity Testing regarding application.
- Researched for future developments in terms of Fax Support, handling huge data management.
Confidential
Business Analyst:
Responsibilities:
- Studied the basic screen layout whose enhancement was the main functionality of the job requirement. Crucial fields were to be seen while looking at an account and sourcing business like Account Type, Account Status, Current Balance, Cleared/Un-cleared Funds, any additional liens pending in the account, co-signers or joint account holders
- Interviewed current users for the problems they faced on a daily basis while querying data in terms of server response time, data accuracy, and data refreshing when changes made to respective accounts. Project followed Agile Methodology.
- Built Data flow diagrams using Ms Visio and identified key parameters to be given to developer team
- Prepared BRD and analyzed functional specifications of the application and prepared FRD which aided the developers for coding system enhancements to the GUI (Graphic User Interface).
- Assisted QA team with Test Scripts and Test Plans for the tabs with additional account information to be added.
- Performed UAT to check whether the appropriate changes could be used by existing users.
- Assisted Developer Team in analyzing defects using Defect issue list.
- Acted as a liaison between the developer team and the research team for taking the HOST application to the next level in future for it to become GUI Based.
