Summary
Overview
Work History
Education
Skills
References
Timeline
Generic

Sajal Malhotra

Victoria

Summary

Over all 6+ years of experience as a Business System Analyst with good understanding of Business Requirements Gathering, Business Process Flow, Business Process Modeling and Requirement Analysis. Strong knowledge of Software Development Life Cycle (SDLC) including Waterfall, Agile/Scrum, Rational Unified Process (RUP) methodologies. Experienced in Business Analysis, Data Analysis, Quality Analysis and Project Management. Extensive experience in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirement document (BRD), Functional Requirement Document (FRD), Software Requirement Specification (SRS) across the deliverables of a project. Successful in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) using Rational Rose & MS Visio. Experience in conducting GAP analysis, User Acceptance Testing (UAT), SWOT analysis, Cost benefit analysis, Portfolio Analysis and ROI analysis. In Depth understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans. Organized Joint Application Developments (JAD) sessions and Joint Requirement Planning sessions (JRP), walkthrough, Interviews, workshops and Rapid Application Development (RAD) sessions with end-user/clients/stake holders and the IT group. Excellent Business scripting skills and proficient in developing Use Case Models, Analysis Models, Design Models, Implementation Models, Use Case Diagrams, Context Diagrams, Dataflow Diagrams, State Transition Diagrams, Functional Storyboards, Behavior Diagrams (sequence diagrams, collaboration diagrams, and activity diagrams), also Class Diagrams based on UML Standards using MS Visio. In depth experience in Requirements gathering, Functional and Technical design docs, Data Cleansing and Process Flow diagrams, Data Analysis, Linear and conceptual data modelling. Experience in analyzing and reporting using tools like Tableau, Power BI and SSRS. Experience working with Product Owner in Agile Environment to build, groom, and maintain Product Backlog, Sprint Backlog and manage User Stories using JIRA/Rally. Experience in working with QA teams for creating and reviewing Test Plans and Test Cases and creating and mapping defects in the HP Quality Center and JIRA. Experience in Test Planning, Test Preparation, Test Execution and Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements. Experience using MS Visio, MS Project and MS office tools like MS-Word, PowerPoint, Excel and Access. Exceptional problem solving and sound decision making capabilities, recognized by alternative solutions, and confident, accurate, decision-making coupled with excellent communication and interpersonal skills.

Overview

8
8
years of professional experience

Work History

Business System Analyst

Meridian
09.2021 - Current
  • Functioned as the liaison between the business and the technical areas, throughout the project life cycle along with Product Owner
  • Interfaced with the client as part of requirements gathering and analysis
  • Gathered requirements from business by developing static mock-ups, and dynamic prototypes using HTML and CSS
  • Identified 'As is' process and 'To be' process as parts of Gap Analysis for new functionality requirements, as well as prioritizing them based on business to align them with the project
  • Created business process workflow diagrams using Business Process Modeling Notation (BPMN)
  • Created Unified Modeling Language (UML) diagrams for Business Process Modeling
  • Conducted JAD sessions and meetings with developers, QA team, and users for communicating primary requirements, also discuss different versions of requirements, queries, and clarify the issues
  • Conducted sprint planning with development & QA team
  • Participated in Scrum Ceremonies (Grooming, Sprint Planning, Daily Stand-Ups, Review and Retrospectives)
  • Supported Product Owner in Building, Grooming and maintaining Product Backlog with writing user stories, acceptance criteria in JIRA
  • Proficiently helped development teams to understand user requirements and break down large user stories for execution so that they can perform better estimation of each user story with Planning Poker Estimation
  • Elaborated User Stories with Story boarding Technique – Theme, Epic, Story
  • Actively assisted in acceptance and validation of the stories by testing the delivered stories
  • Developed Test Cases to validate the requirements and documented the Traceability Matrix for Test Cases and Requirements
  • Defects were tracked with JIRA software
  • Reviewed test scripts as per the business specifications and design documents
  • Worked with development and testing teams to accomplish timely release objectives
  • Help business in developing UAT test cases
  • Ensured delivered features address customer needs and achieve expected business outcome
  • Created and Designed logical database schema for data warehouse environment to prepare ETL and Implemented basic SQL queries for QA Testing and Report/ Data Validation
  • Performed numerous data extraction requests using SQL scripts to prepare ad hoc reports Using SQL 2014 to write query for extracting different department and data for multiple applications
  • Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server environment
  • Identified and removed impediments to the success of the sprint by working with every single team member
  • Communicated dependencies and potential risks to the completion of the sprints including resources, costs, and systems
  • Coordinated and prioritized outstanding defects and enhancement based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.

Business System Analyst

Sun Life Financials
09.2019 - 08.2021
  • Requirements gathering from Product Owner, Technical stakeholders and Business users so as to obtain maximum details of requirements and involved in documenting Business Requirements into Product Backlog
  • Acted as Liaison between the Business needs (business users and Product Owner) and the Technical team (development and testing staff), ensuring technical solutions satisfied business requirements
  • Conducted JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication
  • Performed Gap Analysis by doing an in-depth study of the current process, planned implementation actions and change control process and also interacting with business heads to finalize High Level Business Requirements for the application by doing the requirement analysis
  • Apply UML notations and methodology in developing models that accurately represent the business process and workflows and clearly communicate them to the stakeholders
  • Organized requirements into High level Use Cases and modeled them into UC, Activity Diagrams using MS Visio
  • Used MS Word and MS Visio to document data flow of the AS-IS and TO-BE process with BPMN notation
  • Organized JAD sessions to flush out requirements, performed work flow analysis, outlined business rules, and developed domain object models
  • Supported Product owner in developing product backlog, Sprint Backlog and writing User stories in JIRA
  • Participated in sprint planning and design sessions to ensure design complies with requirements
  • Assisted Product Owner with Backlog grooming, User Story management and prioritization in JIRA
  • Developed and written User stories that directly support the primary objective of the project and are appropriate size for iterative development
  • Responsible for creating UI mockups using Ms Visio and Azure
  • Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database
  • Involved in service-oriented architectures (SOA) suitable for secure, reliable, and high-performance deployment
  • Worked closely with the Scrum teams to ensure technical solution meets requirements and functional solution
  • Reviewed Test Plans developed by the testing team for testing the application
  • Effectively interacted with user and CRM system to gather business requirements across multiple business process areas maintain and gathers customer base information
  • Organized meetings to discuss outstanding issues with QA and developers
  • Defects were tracked, reviewed, analyzed using JIRA
  • Created data model and data analysis using SQL
  • Used MS Office Word, Excel, Visio, and PowerPoint & Project for project tracking and documentation
  • Continuously revalidate requirements with Product Owners/Managers & delivery partners to ensure that key deliverables are 'fit for purpose' and meet customer/delivery expectations
  • Involved in UAT process and coordinated with the UAT team to get the feedback to make change requirements document
  • Used MS SharePoint as the version tracking tool for managing the requirements documentation.

Business Analyst

BirlaSoft
01.2017 - 12.2017
  • Participated in the identification, definition and documentation of impending work flows for the purpose of migrating to a superior version of party information system
  • Translated Business requirements to functional and technical language with the help of Use cases and UML diagrams for developers
  • Gathered Business Requirements and wrote Business Requirements Document (BRD) by working with the client IT staff, project managers
  • Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business people and technical people
  • Worked with different phases of RUP starting from Inception through Transition
  • Generated and maintained multiple RUP artifacts including UML models
  • Performed gathering, analysis, review and signoff of business requirements and conducting of interviews, sessions
  • Conducted GAP analysis between two applications to understand the differences and identifying the scope of the new product
  • Documented various workflow diagrams like AS-IS and TO-BE processes
  • Created various User defined objects including Dimensional, Detail, and Measure objects and tested them to ensure correct mapping of data
  • Created new classes, objects and made structural changes to Universes in Designer which includes adding new objects, updating tables and joins
  • Coordinated project schedules with the software project manager
  • Supported the Program Manager in balancing project goals and business needs
  • Worked on Oracle database to retrieve data of interests using SQL tools
  • Retrieve data from database using SQL
  • Gather Business Requirements, analyze data/workflows
  • Defined the scope, financial projections and Cost/benefit analysis
  • Progressed from Problem Statement to well-documented Designs
  • Assisted QA Team in developing test cases and performed Functional testing of the various customers' fields and tested the message behavior functionality.

Education

PG Diploma -

Centennial College
Toronto, ON
05.2019

The Bachelor of Commerce With Honors -

Amity University
Noida(U.P), India
02.2016

Skills

  • Methodologies: SDLC, Agile, Scrum
  • Business Modeling Tools: MS Visio, Rational Rose
  • Requirement Management Tools: MS SharePoint, Rational Requisite Pro, HP ALM
  • Defect Tracking Tools: JIRA, HP Quality center, Rational Clear Quest
  • Business Applications: MS Office suite- MS Word, Excel, Outlook, PowerPoint, Project
  • Scripting Language: C, C, XML, HTML, Visual Basic, Python, Shell scripting
  • Reporting Tools: Tableau, Power BI, SSRS, SSIS
  • Database: SQL, PL/SQL, MS Access, Oracle
  • Operating Systems: Windows Variants

References

Will be provided upon request.

Timeline

Business System Analyst

Meridian
09.2021 - Current

Business System Analyst

Sun Life Financials
09.2019 - 08.2021

Business Analyst

BirlaSoft
01.2017 - 12.2017

PG Diploma -

Centennial College

The Bachelor of Commerce With Honors -

Amity University
Sajal Malhotra