Sajal Malhotra
Toronto,ON
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 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 working with Product Owner in Agile Environment to build, groom, and maintain Product Backlog, Sprint Backlog and manage User Stories using JIRA.
- Experience in working with QA teams for creating and reviewing Test Plans and Test Cases and creating and mapping defects in the 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
1
1
Certification
Work History
Business System Analyst
Sentrex Health Solutions
02.2022 - 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
- 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 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 and coordinated with the team to ensure the completion of the sprints while reducing 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
- Environment: Agile (Scrum) Methodology, Azure, CRM, MS Office, MS Visio, MS Project, JIRA, Agile-Scrum, MS SQL, HTML, Balsamiq, Windows
Business System Analyst
Sun Life Financials
06.2019 - 01.2022
- 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 architecture (SOA) suitable for secure, reliable, and high-performance deployment
- Worked closely with the Scrum teams to ensure that solution meets requirements and functional solution
Business Analyst
BirlaSoft
11.2016 - 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
- Environment: UML, MS Visio, MS Office, Gap Analysis, MS Project, Windows
Education
PG Diploma : Global Business Management -
Centennial College
Toronto, ON 05-2019
The Bachelor of Commerce With Honors -
Amity University
Noida(U.P), India 02-2016
Skills
- Project Methodologies - Agile, Waterfall, Cost/Benefit Analysis, Gap Analysis, Feasibility Analysis
- Defect Tracking - JIRA, HP Quality Center
- Databases - IBM DB2, SQL Server, MySQL, PL/SQL, Oracle
- Operating Systems - MS Windows, Mac OS, Linux
- Requirement Management Tools - Confluence, JIRA
- Other Tools - Microsoft Project, Balsamiq, R, Tableau, Trello, MS Visio, MS Office Suite, Microsoft tools, Splunk, SAS, ServiceNow Ticket Management, Data Modeling, Azure Cloud services
- Reporting - MS Excel, Power BI, Crystal Reports
Certification
- SAFe
Timeline
Business System Analyst
Sentrex Health Solutions
02.2022 - Current
Business System Analyst
Sun Life Financials
06.2019 - 01.2022
Business Analyst
BirlaSoft
11.2016 - 12.2017
PG Diploma : Global Business Management -
Centennial College
The Bachelor of Commerce With Honors -
Amity University
Similar Profiles
Abithra MahendranAbithra Mahendran
Field Health Case Manager at Sentrex Health SolutionsField Health Case Manager at Sentrex Health Solutions
Michelle CaulMichelle Caul
Clinic Manager at Sentrex Health SolutionsClinic Manager at Sentrex Health Solutions
Lidia PaulLidia Paul
Accounts Receivable Coordinator at Sentrex Health SolutionsAccounts Receivable Coordinator at Sentrex Health Solutions