Senior Business Analyst Resume Profile
PROFESSIONAL SUMMARY
- 8 years of extensive IT work experience, with emphasis on Business Analysis, Project Management and Quality Assurance
- Experienced in all phases of SDLC application developed process, software development methodologies Waterfall, RUP, Agile Scrum
- Hands on experience with financial instruments such as Stocks, Corporate Bonds, Treasury Bills, Treasury Notes, and Treasury Bonds, Municipal Bonds, Asset Backed Securities ABS
- Excellent understanding of financial risks, such as Credit Risk, Market Risk, Operational Risk, Interest-Rate Risk, Volatility Risk, and Counter-party Risk, associated with securities and measuring risk using metrics such as VaR, Duration, Convexity, Yield, and YTM
- Strong knowledge of Security Data Financial Analysis, Basel II III Accord for Compliance / Risk Management, GAAP, and Dodd-Frank for financial regulations
- Proficient in process analysis design with an ability to transform business users stakeholders needs into functional technical requirements
- Expertise in performing GAP analysis, creating BRD, FRD conducting JAD sessions
- Expertise in project management in defining project scope, goals and deliverables that support business goals, liaise with project stakeholders, manage project dependencies, quality control and status report
- Proficient in UML diagrams - use case diagrams, activity diagrams, swim lane diagrams, sequence diagrams, class diagrams, state diagrams and business workflow diagram using MS Visio, Rational Rose
- In-depth experience with data mapping preparing data profile document capturing data conversion, validation transformation rules to process incoming data error-handling rules and exception management
- Possesses experience writing SQL queries for data analysis, retrieving data, combine data from multiple tables
- Hands on experience dealing market data, reference data, counterparty data to create customers report for clearing and settlement purposes
- Experience in assisting data modeling team to create ER model conceptual, logical, and physical data model - identify entities, attributes, relationship, and data integrity constraints, using Erwin
- Good understanding of STP financial protocols such as SWIFT MT MX series , FpML, and FIX
- Hands-on experience assisting QA team in documenting test plan, test scenarios, test cases, and requirement traceability matrix managed defect tracking lifecycle using Quality Center
- Strong experience in quality assurance - performed functional testing, integration testing, GUI testing, performance testing, stress testing, regression testing, smoke testing, and supported UAT
SKILLS
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
PROFESSIONAL EXPERIENCE
Confidential
Senior Business Analyst
Project Description
The project was to build a trading system to allow business users to configure, enter, and process the fixed income securities trades using Confidential. It facilitated users to accurately and swiftly determine the price, process fixed income instruments. The outcome is efficient real-time cross-asset trading and management, including pricing, analytics, product structuring, pre-deal checking, trade capture, position management, P L, and defines how to price bonds by reference benchmarks in a single unified view. From high volume flow trading in simple instruments to low volume trading of complex structures and hybrids, the workstation provided full support for all vanilla and exotic products.
Roles Responsibilities
- Acted as a liaison between business owner technical team
- Performed the GAP analysis by identifying existing technologies, mapped the existing processes and the expected processes, also facilitated JAD sessions to analyze prioritize business requirement
- Organized executed requirement gathering session with business users and stake holders to identify and document the business requirements prepared clear and concise functional specifications
- Followed the principles of Rational Unified Process RUP methodology during software development life cycle progressing through different phases - inception, elaboration, construction, and transition
- Worked on MS Project to assist project manager PM with developing project plan, milestones, and deliverables management throughout the project life cycle
- Identified different securities types and data source for securities ABS, MBS, Corporate bond, Treasury bonds
- Analyzed data source, identified various data attributes Such as Reference data, client data, etc.,
- Prepared the Use Cases, Sequence Diagrams, Process flow, Cross functional flow Diagrams and Data Flow Diagrams in MS Visio to signify the system workflow and to find out any bottleneck in the system
- Participated in data modeling session with data architects and data modelers to understand logical physical data models, define entity-relationship
- Extensively used Stt6QL queries to conduct data validation testing, data load testing, and generating user reports
- Created Requirements Traceability Matrix RTM to identify end-to-end association between business requirements and test cases to meet the expected results
- Assisted QA team to document test plan test cases performed various types of testing functional, regression
- Involved in UAT, defect tracking, coordinating Change Control worked with users to prevent scope creep and conducted walkthroughs with the end users and project stakeholders
Environment : MS Project, MS SQL Server, Java, MS Office Suite, MS Visio, Quality Center, Erwin
Confidential
Business Systems Analyst
Project Description
The project was to implement Charles River Investment Management System for equities trading. The application provides Equity Portfolio Managers and Traders with a highly customizable Order Blotter, pre-trade and post-execution compliance monitoring tools, modeling, and what-if analysis tools. Application supports numerous interfaces to external accounting systems and electronic trade execution system. Equity system database imports data from various external sources also it monitors trades and portfolios to ensure that specific account guidelines, regulatory requirements, prospectus guidelines, and risk exposure limits are properly followed. CRIMS assigns specific status codes to each order. The codes represent where the order is in the life cycle, the types of functions that can be performed on that order, and who has authority to that
Roles Responsibilities
- Followed the Agile Scrum methodology to manage project schedule, team coordination and deliverables throughout the software development process
- Performed GAP analysis to study the current business process, documented the characteristics factors of the present situation, factors needed to achieve future objectives, and highlighted the gaps that exists and need to be filled
- Facilitated several JAD sessions all through the software development lifecycle scope management, prioritize project needs, identify deliverables, and address critical issues
- Identified and interviewed project stakeholders to elicit business requirements, captured user stories in product backlog
- Liaised between product owner, scrum master, development team, and QA team throughout the project to derive and execute action plans, meeting deadlines, and organization standards
- Assisted Scrum Master in project management with developing project plan, project milestones, project charter, product backlog, sprint backlog, and burndown metrics participated and leaded daily scrum meetings, sprint planning meetings, and sprint retrospective meetings
- Designed UI for various screens such as new order entry, blotter, allocation, merge order, split order etc.,
- Created front end Dashboard to generate reports display with updated information
- Created UML diagrams to define clear system's visual structure using use cases, swim lane diagrams, class diagrams, activity diagrams, business workflow, and data flow diagrams in MS Visio
- Performed data analysis data validation by executing SQL queries to validate database dependencies and constraints, to create custom user reports, and to conduct data load process testing
- Conducted functional testing, system integration testing, performance testing, stress testing, smoke testing, and regression testing also helped QA team to prepare test plan, test cases, and test scripts
- Extensively involved in defect tracking and management open defects, prioritizing defects, assign to the concerned developers, track status, ensure fixes and summary reporting
- Facilitated UAT process for project stakeholders - identified test group, prepared test environment, tracked defects, managed status updates, and generated summary reports
Environment : Oracle, MS Office Suite, MS Project, UML, Java, Rational Requisite Pro, MS Visio, Autosys, Crystal Reports, Toad
Confidential
Business Analyst
Project Description
The project was focused on automating the exchange of data related to pre-trade phase of trading cycle. This was a robust application built on java platform oracle database. The application was built to help shorten lengthy phases of the trading cycle, thereby reducing risk and improving efficiency and also to address regulatory concerns about backlogs at certain points in the trade cycle. Also the scope of the application was to improve the efficiency by providing seamless messaging using FpML for affirmation confirmation. The application also supported novation protocol. It also analyzed price discovery, product coverage, market data monitor, multi asset historical analysis, excel integration. The various credit derivative products supported by the application were Credit Default Swap, Credit Linked Note, Collateralized Debt Obligation, CDO square, etc. .
Roles Responsibilities
- Interviewed business user, operations analyst to understand and document business requirement in BRD
- Performed analysis of contract specifications, trade validation, trade processing and settlement, compliance, risk management as per ISDA and FpML standards/specifications
- Prepared BRD, use case models, FSD and ER diagrams for the analysis and modeling of derivatives trade clearing and settlement
- Analyzed various data feeds/document coming from Markit for market data, reference data, counterparty data and mapped them to the oracle database for clearing and settlement
- Interacted with business users to capture various data such as default probability report, volatility report, etc.
- Worked with cross-reference team to identify various data source for data attributes such as credit event type, document type, etc.
- Collaborated with Change Management Group and IT to prepare a detailed derivatives infrastructure
- Supported data modeling process including documenting ER Diagram specifying entities, relationships, attributes, and integrity constraints.
- Conducted data mapping to design, deploy, and manage the entire data integration process by defining source data, target data, and transformation rules
- Employed SQL to query the database tables and performed data analysis for the financial data
- Facilitated UAT, user training, and created user manual to help the business users
- Created wireframe models using MS Visio for effective GUI design
- Led QA team in developing test strategy, test plan, test cases, and test scripts and conducted functional testing, integration testing, system testing, and regression testing
Environment: Oracle, MS Project, MS Office Suite, UML, Java, Crystal Reports, Toad, Rational Rose, HP Quality center, AutoSys
Confidential
Business Analyst
Project Description
The scope of the Project was to create a global data warehouse by integrating data from multiple databases and other information sources. The purpose of developing data warehouse was to expand and enhance the underlying data in the data repository, data capture, local report delivery, change the data sources and data infrastructure, expand to include new data feeds. Also built is a dynamic assumption engine that customizes the measures on a regional basis. The repository was built for storing reporting data for different products such as Options, Swaps, Stocks, Prime Brokerage, and DMA from across the globe.
Roles Responsibilities
- Followed and implemented RUP methodology for defining project objective, requirement gathering and system analysis
- Performed GAP analysis to understand 'as is' process to evaluate the benefits of the 'to be' process flow
- Facilitated the JAD sessions to gather the business requirements and to understand the development environment to build the application
- Prepared BRD by identifying, interviewing users stake holders by setting up calls and one to one meeting also supported system analyst to prepare FRD
- Conducted data mapping to setup the data integration process ETL workflow to assist with data mediation, data lineage, and data consolidation
- Performed Data modeling by determining the data requirements and define the relationships between them using conceptual, logical and physical data model
- Extensively used MS-Visio for UML to facilitate documenting the environment, requirements and overall design such as use case diagrams, activity diagrams and sequence diagrams to represent the workflow
- Performed end to end application testing using QC tools documented the results
- Liaised with other system groups, business groups and project managers to ensure coordination of projects affecting other functional areas
Environment: SQL Server, UML, .Net, HTML, Informatica, MS Visio, Erwin, Management Studio, MS Office
Confidential
Business Analyst
Project Description
Online banking allows customers of a financial institution to conduct financial transactions on a secure website operated by the institution to re-organize its infrastructure and system features to better support online Banking. This included re-developing the entire online banking solution with more comprehensively defined business and user requirements. Task involves end to end testing of the online application.
Responsibilities:
- Interviewed clients and application owners from different business lines to gather information, understand the users need, defined requirements and developed specifications
- Gathered business requirements, analyzed business requirements and segregated them into high level and low level Use Cases, Activity Diagrams/State Chart Diagrams
- Facilitated collection of Functional Requirements from system users, and prepared Business Requirement documents
- Assisted Project Teams in preparing Software Requirement Specifications SRS , Software Design Documents SDD , User Interface Design, designing of Application Architecture Database Modeling
- Performed analysis, design and development for User Interface wireframes, and sitemaps that illustrate the data and flow of the system
- Worked closely with end-users and stakeholders to develop a detailed understanding of the requirements
- Coordinated work plan between IT team and clients with MS Project, implemented and managed risk migration process and developer fixes, retested fixes, and scheduled and tracked progress for team members of project through completion
- User Interface testing was done to validate so that the navigation of the application properly reflects business functions and requirements
- Supervised and coordinated the UAT testing. Evaluated the test results with the product team and provided the feedback
- Created and executed manual test cases for GUI and Functionality testing using Test Director
