Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Arjav Prajapati

Ontario,Canada

Summary

Having intense experience of 6 years as Business Systems Analyst in Wealth Management, Capital Market and Banking. Team player with a friendly attitude and professional approach. Having excellent written and oral communication skills.

Summary:

  • Expert in Waterfall, Agile(Scrum & Kanban) and Sigma.
  • Strong knowledge in creating user stories, analyzing test scenarios, and release plans for XP methodologies.
  • Worked closely with the Stakeholders and SMEs to gather requirements and finally give presentations about various reports generated by using different data visualization tools like Tableau and Power BI.
  • Good understanding of Data Warehousing, Business Intelligence Reporting, analyzing Fact Tables and Dimension Tables, Master Data management (MDM).
  • Proficient with UML(Use cases, Activity Diagrams, Sequence diagrams, ER diagrams etc.). Expert in writing Business Requirement Document(BRD), FRD, Vision Document.
  • Expert in developing, writing and maintaining gap analysis, business requirements and technical documentation. Familiarity and understanding of Key Performance Indicator (KPI) analysis and performance measurement.
  • Good Understanding of Dimension models(Star or Snowflake Schema) using ERWIN. Strong knowledge of Risk Management Procedures, performing risk analysis.
  • Working knowledge and experienced in GUI design/prototyping including web interfaces.
  • Strong knowledge in conventional and non-conventional requirement gathering techniques such as interviews, questioners, and JAD sessions.
  • Expertise in Data Quality Processes which includes Data Mapping, Data Mining, Data Validation and Data Cleansing.
  • Worked extensively with QA Team in understanding Test Cases, Test Plans, User Acceptance Testing (UAT) and ensuring that the software meets the system requirements
  • Experience in working with off-shore development teams. Experience working with Banking and processes, tools and project methodologies.
  • Basic programming skills with SQL.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Business Systems Analyst (Capital Markets Intelligence)

Franklin Templeton
Ontario, CA
04.2024 - Current
  • Ensure completion of technical reviews, quality assurance checks, and post-implementation reviews through ServiceNow, JIRA, and Confluence.
  • Provide time and personnel resource estimates for procurement of IT testers, developers, and subject matter experts (SME) based on the scope of the software solution.
  • Organize meetings and interviews with testers, developers, SMEs, and other relevant stakeholders to gather and analyze change requirements.
  • Design SQL queries in production, testing, and maintenance environments with the use of PLSQL to support business needs and meet business requirements.
  • Collaborate with the production control team and business BSAs to schedule batch jobs for year-end processes in production and maintenance environments with the use of Chronicle.
  • Facilitate meetings with the development and operational support team to map out details of change requirements with the use of functional specifications, entity-relationship diagrams, and process workflows.
  • Collaborate with release management and integration teams to administer installation and configuration solution components of our enterprise solution RMS and IPAS.
  • Work with relevant stakeholders to resolve and troubleshoot conflicts around functionality, gaps, features, and specification.
  • Design test cases and scenarios to support IT tester for user acceptance testing in test and MUAT environments.

Business Systems Analyst

CIBC Mellon
01.2024 - 03.2025
  • Worked closely with businesses and stakeholders to design the desired future state after identifying, validating, and documenting the current state process.
  • Started the project with discovery sessions.
  • Conducted meetings with different Executives to know about the project, and stakeholders involved with the process as well as the Internal/External business partners.
  • Developed User Stories having components like Acceptance Criteria, Done Criteria, Linkages, Documents, Tasks, etc, using Jira and Confluence.
  • Provided Agile project management controls, project plans, and timeline schedules, facilitated RAD sessions, and reviewed software defects.
  • Played a pivotal part in the success of the agile ceremonies like a daily standup, sprint planning, sprint review, sprint retrospect, and backlog grooming sessions.
  • Led Requirement Gathering Sessions, Joint Application Development (JAD) sessions.
  • Created and managed User Stories, Product and Sprint Backlog.
  • Conducted meetings with key Stake Holders, SMEs, and Decision makers from Front, Middle and back office to have a successful collection of requirements from all domains areas.
  • Released presentations to the Project team, and also conducted walkthrough with different department heads to have deeper understanding of the requirements.
  • Assisted in the development team in demos to the Product Owner, and ensured that any changes requested in the demos were implemented.
  • Coordinated Sprints, from Iteration Planning thru daily scrum, and Iteration Reviews and Retrospectives.
  • Used SQL to query the data.

Key Components:

  • Capital Markets, Bloomberg, Murex, Jira, Portfolio Accounting (PA), PCR, Trust, Blue Prism, Power BI, Tableau, Excel, Oracle, SQL, Data Mapping, Data Modeling and Flow diagrams, User Stories Agile Methodology.

Business Systems Analyst

Blackrock
01.2022 - 12.2023
  • Provided Agile project management controls, project plans, timeline schedules, facilitate RAD sessions and review software defects.
  • Worked closely with Front Office and Middle office stakeholders to gather requirement and transferred business requirements to product development team and helped understand the requirement in detail.
  • Facilitated and followed a structured approach to plan, elicit, analyze, document, communicate, and manage business requirement with stakeholders by applying a variety of elicitation techniques to probe, challenge and understand requirement according to the requirement management discipline.
  • Created User Stories with all the information required for its correct estimation.
  • Participated in all the agile ceremonies like daily standup, sprint planning, sprint review, sprint retrospect and backlog grooming sessions.
  • Worked alongside the Lead Business Analyst. Furthermore, supported to various business lines, including Front Office, Middle Office and back office.
  • Gathered Business Requirements, Interacted with the Users, Designers and Developers, Project Manager and SMEs to get a better understanding of the Business Processes.
  • Conducted JAD Sessions periodically with various stakeholders at various phases of the Software Development Life Cycle (SDLC) to discuss open issues and resolve them.
  • Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT)/and modeled them into Use case, Activity and Sequence Diagrams using MS Visio.
  • Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
  • Used SQL to check the authentication of data attributes.

Key Components:

  • Wealth Management, Broadridge, Bloomberg, Jira, Waterfall, Agile, Tableau, Excel, .NET, Data Models, Data warehousing, SQL, Data Mapping, Schema Documents

Technical Analyst

Blackrock
01.2021 - 03.2025
  • Improved team performance by providing support and backup to the production team.
  • Assist the Project Coordinator to ensure project objectives, scheduling, budgeting, cost and margin calculation, milestones, procedures, and performance standards.
  • Determine operational objectives by studying business functions, gathering information, and evaluating output requirements and formats.
  • Define project requirements by identifying project milestones, phases, and elements, forming a project team, and establishing a project budget.
  • Coordinated with staff to clarify information and enforce procedures resulting in effective problem solving and smoother operations.
  • Communicating with internal and external stakeholders for scope creation.

Education

Post Graduation - Information Technology Business Analysis

Conestoga College
Ontario, CA
12.2024

Bachelors - Information and Communication Technology

Adani University
05.2023

Skills

  • Key Skills
  • Technical Skills
  • Requirement Elicitation
  • Jira
  • Leading JAD sessions
  • SharePoint
  • Gap Analysis
  • Agile / Scrum / Waterfall
  • Business process redesign
  • SQL
  • Use Case Development
  • Confluence
  • Data Warehousing
  • Use Case Modeling
  • Data Modelling
  • UML / Wire framing
  • Rally
  • Prototyping
  • Business Requirement Document
  • Visio

Certification

  • Certified Scrum Master (CSM)
  • Scrum Fundamentals Certified (SFC)
  • Scrum for Operations & DevOps Fundamentals Certified (SODFC)

Timeline

Business Systems Analyst (Capital Markets Intelligence)

Franklin Templeton
04.2024 - Current

Business Systems Analyst

CIBC Mellon
01.2024 - 03.2025

Business Systems Analyst

Blackrock
01.2022 - 12.2023

Technical Analyst

Blackrock
01.2021 - 03.2025

Bachelors - Information and Communication Technology

Adani University

Post Graduation - Information Technology Business Analysis

Conestoga College
Arjav Prajapati