Business Analyst Resume
CA
SUMMARY
- Result oriented professional with 8+ years of experience in financial domain as Business Analyst.
- In - depth knowledge of Equities, ETFs, Mutual Funds, Options, Fixed Income, Forwards, Futures, Swaps (plain vanilla swap, basis swap), Collateralized Debt Obligation (CDO), Collateralized Mortgage Obligation (CMO), Asset Backed Securities (ABS), Mortgage Backed Securities (MBS), Credit Derivatives (Credit Default Swap (CDS), Credit Linked Notes (CLN)).
- Strong experience in application development employing various Software Development Life Cycle (SDLC) methodologies such as Agile Scrum, Waterfall, RUP and RAD.
- Proven expertise in interacting with business team as well as technology to analyze, assemble, and document Business Requirements Documents (BRD); and identified and transformed into Functional Specification Documents (FSD).
- Expertise in identifying requirements as functional / non-functional and created the Requirement Traceability Matrix (RTM) for reviewing and tracking requirements.
- Hands on experience in performing GAP analysis to effectively identify the existing technologies and document the development to meet the desired end state.
- Expertise in organizing & participating in project meetings such as JAD sessions to obtain business requirements from project stakeholders and subject matter experts.
- Constructed Data Mapping documents to setup the data load process for data feeds sourced from Bloomberg, Reuters, and Telecurs into Security Master Database.
- Extensive experience in creating UML documentation using MS Vision such as Use Cases, Activity Diagrams, Business Workflow Diagrams, Class diagrams, Sequence Diagrams, and Data Flow Diagrams.
- Strong experience with Data Modeling - assisting in building ER diagrams, via ERwin data modeler.
- Extensive experience in executing SQL statements with databases like Oracle, MySQL, and Sybase to conduct data analysis and generate user reports.
- Experience in analyzing risks such as Interest Rate Risk, Default Risk, Volatility Risk, Inflation Risk, Market Risk, and Credit Risk associated with instruments in various markets.
- Excellent work experience and proven track record for executing application development process in Retail, Commercial & Investment Banking, Mortgages, Brokerage and FX trading.
- Good understanding of financial networks & protocols like FIX, SWIFT and FpML.
- Knowledge of financial regulatory compliances like Dodd Frank and Basel II / III.
- Strong understanding of trading lifecycle for various financial products from initiation-to-settlement.
- Experience in actively liaising between end users, development team, and QA team to address system issues and identify the appropriate solution.
- Proficient in supporting QA team in documenting Test Plan, Test Cases, Test Scenarios, Test Scripts to conduct application testing - Functional Testing, Integration Testing, System Testing, GUI Testing, Performance Testing, Load Testing, Stress Testing, Smoke Testing, Regression Testing, and UAT.
- Hands on experience with test management and defect tracking tools such as HP Quality Center Test Director, Bugzilla, JIRA and Rational Clear Quest.
TECHNICAL SKILLS
Operating Systems: Windows 2000/NT/XP/7, Mac OS, Unix
DBMS: Oracle, Sybase, MS SQL Server, DB2, MS Access
Languages: C, C++, C#, HTML, Java Script, XML, VB Script, .NET, SQL, PL/SQL
Defect Tracking: Quality Center, Bugzilla, Rational Clear Quest
Testing Tool: Quality Center, QTP, JUnit, Selenium, Load Runner, SilkTest
Other tools: MS Sharepoint, MS Visio, Rational Rose, Rational RequisitePro, ERWin
PROFESSIONAL EXPERIENCE
Confidential, NH
Business Systems Analyst
Responsibilities:
- Analyzed business needs by extensively interacting with business and collected requirements to document in the System Delivery Specifications
- Created data mapping for new functionalities that was in scope through MS Excel spreadsheet from XML & JSON files using Notepad++ tool
- Created and sized Product Backlog and participated in backlog grooming sessions with product owner and Scrum Master.
- Analyzed Product Backlog according to the prioritization and created Sprint backlogs.
- Involved in Sprint planning sessions with the scrum team and assured that the correct numbers of points are accomplished within the sprint and provided daily status meetings and updated tasks for every sprint.
- Involved in meetings with vendors like Bloomberg, Reuters, Google and Nuance team in managing data for the application.
- Created Blogs know as Spaces for team members to discuss about any issues which dragged lengthy email chains.
- Performed and contributed on Show and Tell sessions to the Stakeholders after every sprint with the accomplished functionalities.
- Conducted and participated in Retrospective meetings and planned for the necessary improvements for the future sprints.
- Created Workflow and use case diagrams using MS Visio
- Verified and analyzed design specification with the design team and played active role in giving necessary feeds through usability sessions.
- Participated in triage meetings with the Business and the Technology team in planning and identifying defects according to priority and analyzed accordingly.
- Ran test cases in Quality Center, logged, assigned and verified defects to the appropriate team members.
Environment: s: Windows, MS Office, Agile, MS Share point, Quality Center, Notepad++, MS Visio.
Confidential, NY
Senior Business Analyst
Responsibilities:
- Interpreted and analyzed the business need by extensively interacting with traders, operations and SME’s to gather requirements; translated them into system specification, and authored BRD & FRS
- Analyzed the existing investment management system with which we had to integrate the Credit Derivatives trading system
- Organized JAD Sessions with the SME’s, stakeholders to develop architectural solution, compare functionalities with the user requirements, analyze & prioritize system requirements
- Created Workflow and Activity diagrams using Rational Rose
- Prepared a project plan with the Project Manager using MS Project and helped assign tasks and responsibilities
- Identified the stakeholders, their roles and involvement in the project
- Documented business rules and business processes using the business requirements document
- Developed use case scenarios which contained a cohesive sequence of interactions
- Hands on experience in executing SQL statements to conduct data validation testing for the security master database
- Provided research, data integrity, data analysis and application support by generating adhoc SQL queries and MS SQL and Oracle
- Built data mapping document identifying data source, target database tables, and business rules to setup the ETL process for external data feeds such as Bloomberg, Reuters, and Interactive Data
- Strong experience in performing data analysis - assisting data modeling team to create data models identifying the entities, relationships, and database constraints
- Held intermediate brainstorming sessions to understand the obstacles in the system development lifecycle
Environment: s: Windows, Visual Basic, MS SQL Server, MS Project, MS Excel, SDLC, JAD, Rational Rose, MS Share point.
Confidential, CA
Business Systems Analyst
Responsibilities:
- Interacted with project team to define system objectives and scope, and to identify constraints and the measures of success for the system to be developed.
- Gathered data requirements for the system by interacting with the users and data administrators.
- Designed Business Process Model (Activity diagrams, Sequence diagrams and Collaboration diagrams).
- Ensured application forms and reports followed client’s development standards and guidelines in terms of usage, naming conventions etc.
- Conducted workshops for internal users (processors, underwriters etc.) to provide training.
- Performed SQL queries for generating ad-hoc reports, data reconciliation, and data cleansing on downstream data bases for market and reference/static data
- Broad use of SQL Statements using SQL, PL/SQL and hands-on experience in data analysis by identifying, analyzing, and documenting data requirements in data mapping document.
- Identified, researched, analyzed and documented business processes and uses case scenarios.
- Analyzed the business requirements and participated in creating Test Plan for GUI and database testing.
Environment: s: MS Office Suite, MS Project, Windows, MS SharePoint, J2EE, SharePoint, MS Access, PL/ SQL
Confidential, MA
Business Systems Analyst
Responsibilities:
- Organized meeting and presented storyboards to ensure accurate comprehension of the existing situation with rewards to mismatched scenarios.
- Depicted the flow of different kinds of credit mismatch scenarios through activity diagram.
- Developed use case diagrams for every conceivable scenario - such as use case to determine the sales credit mismatch, use case for the matched scenario, allocation etc.
- Supervised the development of the application by simultaneously interacting with the clients and the technical team.
- Formulated SQL queries for the creation of exception reports, trade data files and investigation files to support the traders/users
- Assisted in developing test case objectives for verifying the accurate functioning of the system with respect to various mismatching under different permutations and combinations of scenarios.
- Involved in UAT process before rolling out to production.
Environment: s: Windows/Unix, J2EE, Oracle, Rational Rose, Test Director, MS Project, MS Office, MS SharePoint.
Confidential, CA
Business Analyst
Responsibilities:
- Providing users with a comprehensive real time report of P/L and risk assessment of municipal bonds, Syndicates, Short-term products, Fixed Income Futures, Bond Options
- Provides real time and end-of-day values of positions of all the active positions
- Liaison between the functional and technical teams involved in the project
- Provides a comprehensive risk analysis of all the active positions and their P/L implications
- Identify, research, investigate, analyze, define and document business processes
- Analyzing the current systems in place and evaluating their use and scalability in developing this system
- Reviewed sessions with the users and development teams to understand the bottlenecks and areas of improvement
- Involved in performance testing, functional testing and integration testing
Environment: s: Windows, MS Project, MS Visio, Rational Requisite Pro, SQL
Confidential
Associate Business Analyst
Responsibilities:
- Participated in Requirement review meeting and given feedback on inconsistencies requirements and ambiguous requirements.
- Analyzed and created requirement documents for the technology team and QA team
- Identified business users and stakeholders for preparing requirements
Environment: s: Windows, HTML, MS Office, MS SharePoint