Sushindra Kumar
Toronto,ON
Summary
- Overall, 8+ years of experience as a Business Analyst/Business System Analyst specializing in Business Analysis, System Analysis in domains such as Banking and IT Services
- Strong knowledge of Software Development Life Cycle (SDLC) including Waterfall, Agile/Scrum methodologies, and Rational Unified Process (RUP) methodologies
- Experience in Business Data Analysis, Quality Analysis, and Project Management
- Played key client and vendor-facing roles supporting multiple teams for large CRM/ ERP implementations. Distinction of working from the requirement gathering phase to roll-outs of applications in multiple projects and organizations
- Extensive experience in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirement document (BRD), Functional Requirement Document (FRD), and 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 Lucid chart and 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, solution identification, risk analysis, 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), walkthroughs, Interviews, workshops, and Rapid Application Development (RAD) sessions with end-users/clients/stakeholders and the IT group
- Excellent Business scripting skills and proficiency 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, FIGMA, MIRO and Lucid chart
- In-depth experience in Requirements gathering, Functional and Technical design docs, Data Cleansing and Process Flow diagrams, Linear and conceptual data modeling
- Experience in analyzing and reporting using tools like Tableau, Power BI, and SSRS
- Experienced in working on cloud-based solutions like Salesforce, Azure, and GCP technologies
- Experience working with Product Owner in an Agile Environment to build, groom, and maintain Product Backlog, Sprint Backlog and manage User Stories using JIRA
- Experience in Test Planning, Test Preparation, Test Execution, and Issue Resolution and Report Generation to ensure that all aspects of a Project follow the Business Requirements
- Experience in using Office 365 and thorough understanding of concepts including Office 365 identity management with Azure Active Directory, Exchange Online, OneDrive for Business, SharePoint Online, Microsoft Teams and Skype for Business
- Experience in 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, critical thinking coupled with excellent communication and interpersonal skills
Overview
9
9
years of professional experience
1
1
Certification
Work History
Tech Mahindra
Toronto, ON
07.2022 - Current
- Role: Sr. Business Analyst
- Clients: Royal Bank of Canada
- Led requirements delivery across planning, elicitation, documentation, estimation, and validation for medium-to-large RBC Internal Audit's initiatives
- Collaborated with Product Owner and Scrum Master to facilitate Agile ceremonies (backlog grooming, sprint planning, review and retrospectives) and documented key artifacts in JIRA and Confluence
- Managed project risks, assumptions, and while ensuring clear stakeholder communication
- Conducted impact and gap analysis to validate alignment between business scope and test coverage
- Created and maintained a comprehensive repository of reusable documentation, including Scope Modeling, Business Process Modeling, Data Requirements, Data Mapping for data lineage, Business Rules Analysis, Non-Functional Requirements, User Stories, and Acceptance Criteria, aligned with enterprise standards in Confluence
- Contributed to process re-engineering and improvements, supporting the strategic digitization of the audit journey
- Partnered with data management teams to define Critical Data Elements (CDEs), data lineage, and integration points across audit data platforms
- Supported enhancements to monitoring and reporting systems to improve data accuracy and business transparency and ensured adherence to enterprise requirements methodology and data governance policies
- Applied SQL and BI tools to validate data accuracy and perform business impact analysis
- Developed Interface Agreements to publish operational operating procedures with internal and external consumers of audit data
- SQL
- MS SQL Server
- Office 365
- DataIku
- Lucid Chart
- Miro
- MS SharePoint
- JIRA
- Confluence
- Oracle
- Tableau
- Node JS
Bank of Nova Scotia
Toronto, ON
07.2022 - Current
- Role: Sr. Business Analyst
- Worked on Transaction Monitoring Reconciliation project as an audit remediation effort, encompassing all source systems under Canadian Banking, International banking, Global Wealth Management, and FINTRAC (LCTR and EFTR)
- Collaborated with key stakeholders of AML Data and AML Risk teams, and other technology teams, to elicit business requirements, processes, and objectives. Analyzed and translated these requirements into functional specifications
- Reviewed test plans/strategy documents to ensure accuracy and sufficient testing coverage of changes being implemented. Identified and addressed issues, bugs, or discrepancies during the Business Acceptance Testing phase
- Created and maintained documentation such as data mapping documents, and STMs on Confluence, including flow diagrams, and user/technical stories. Provided guidance, consultation, and support as it pertains to the team's systems
- Identified opportunities for business/technical process improvement, streamlining workflows, and enhancing overall efficiency
- Analyzed data using SQL to extract insights, and make data-driven recommendations throughout the business
- Conducted walkthrough sessions with the business users regarding the implementation of business rules and secured their signoff
- Actively pursued effective and efficient operations of their respective by Scotiabank's Values while ensuring the adequacy and effectiveness of day-to-day business controls to meet obligations concerning operational, compliance, and conduct risk
- Owned Release and Change management processes in collaboration with DevOps team and Change Advisory Board members
- Presented the project specifics to the ARB (Architecture Review Board) committee for their authorization, enabling us to proceed with the go-live phase
- Participated in annual data mapping attestation exercise for business lines such as Canadian Banking, International Banking, and wires (Swift and Non-swift) as part of the data lineage assessment
- Championed a high-performance customer-focused environment by communicating effectively, written and verbal, to various audiences (technical and non-technical) to deepen client relationships and contribute to an inclusive work environment
- SQL
- Hive
- MS Office
- IBM DataStage
- MS Visio
- MS SharePoint
- JIRA
- Confluence
- UNIX
- Oracle
- Power BI
- HDFS
Pineapple Financial
North York, ON
03.2020 - 07.2022
- Role: Sr. Business System Analyst
- Led migration efforts and multiple enhancements for the mortgage line of business at Pineapple organization, involving payment portal, deals originating system, and Salesforce CRM
- Participated in the identification, understanding, and documentation of business requirements, keeping in mind the need for the application based on the project scope using Hybrid and Agile methodology
- Performed various Proof of concepts (POCs), Integration DOS Portal (Payment system) with Salesforce CRM
- Liaised between IT and business stakeholders to resolve challenges relating to specifications required for analysis and reporting
- Created BRDs (Business Requirement Document), Data Transformation, and Source-to-Target Mapping Documents (which were inputs for Modeling, ETL/BI teams)
- Developed systems/data Integration strategy, ETL strategy, data staging, movement and aggregation strategy, enterprise information dissemination, and access strategy in light of the merging environments
- Involved in service-oriented architectures (SOA) suitable for secure, reliable, and high-performance deployment
- Organized meetings to discuss outstanding issues with QA and developers. Defects were tracked, reviewed, and analyzed using JIRA. Involved in the UAT process and coordinated with the UAT team to get feedback to incorporate change requirements
- Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS Excel for data mining, data cleansing, data mapping, data dictionary, and data analysis
- Continuously validated the requirements with Product Owners/Managers and delivery partners to ensure that key deliverables are 'fit for purpose' and meet customer/delivery expectations
- Used MS SharePoint and Confluence as the version tracking tool for managing the requirements documentation
- Agile (Scrum) Methodology
- Salesforce
- Power BI
- MS Office
- MS Visio
- MS Access
- MS Project
- MS SharePoint
- JIRA
- Confluence
- SQL
- Windows
DUCA
Toronto, ON
04.2019 - 02.2020
- Role: Business System Analyst
- Worked on the optimization of various business workflows related to the Wealth management line of Business
- Involved in Business Process Mapping and requirement-gathering sessions
- Translated requirements into Epics, User Stories, and Acceptance Criteria and followed Agile methodology
- Conducted User Story walkthrough in sprint planning, reviewed acceptance criteria in sprint demo meeting, and maintained Product Backlog
- Facilitated requirement sessions with multiple SMEs/stakeholders from various business groups to elicit requirements
- Worked with Scrum Master to successfully deliver sprints
- Performed User Acceptance Testing and Data Validation prior to Sprint demos
- Linked JIRA and Confluence to maintain product documentation
- Developed Test Cases to validate the requirements and documented the Traceability Matrix for Test Cases and Requirements while tracking the Defects in JIRA software
- Reviewed test scripts as per the business specifications and design documents. Worked with development and testing teams to accomplish timely release objectives.
- 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
- Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation, and Data Validation using SQL queries in an MS SQL Server environment
- Identified and removed impediments to the success of the sprint by working with each team member
- Worked extensively using web service APIs and REST APIs
- Communicated dependencies and potential risks to the completion of the sprints including resources, costs, and systems
- Provided ongoing support to business users including troubleshooting with work-flow processes and other technical issues
- Documented all the common Issues and solutions saved in the confluence or share point for future business reference
- Agile (Scrum) Methodology
- HTML
- CSS
- MS Office
- Tableau
- MS Project
- JIRA
- MS SQL Server
- Balsamiq
- Windows
HDFC Bank
India
10.2016 - 03.2019
- Role: Business Analyst
- Prepared the project scope and vision and subsequently presented them to the management committee
- Provided expertise in strategic planning, business process modeling, business process analysis, object-oriented analysis & design, use case modeling, use case analysis, component-based development, and quality assurance
- Developed strategies with the Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing)
- Initiated and created business-specific databases to ensure all personnel follow the set requirements
- Perform automated and manual testing based on written test plans and test cases and of end-user needs
- Designed logical and physical data models using the ERWIN Tool after analyzing and understanding the business processes in detail
- Identified/documented data sources and transformation rules required for populating and maintaining data warehouse content
- Developed detail and summary reports including line and pie charts, trend analysis reports, and sub-reports according to business requirements using SQL Server Reporting Services (SSRS)
- Involved in testing Transformations used in Informatica for ETL process and indexing of the tables in the data warehouse
- Involved in mapping and testing custodian data such as holdings, transactions, and validating risk-related reports, trade data sheets of portfolio
- Created the SQL scripts for demonstration of the prototypes and verification of the result sets, and developed/maintained sales reporting using MS Excel queries
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
- Actively involved in building a high-level business case based on the above findings and suggested a transformation roadmap to the future
- SSRS
- Teradata
- MS Office
- SSIS
- Erwin
- MS Access
- Informatica
- MS Project
- MS SharePoint
- JIRA
- SQL
- Windows
Education
Master -
in computer applications
Skills
- SDLC waterfall
- Agile Scrum
- MS Visio
- Lucid chart
- JIRA
- Azure DevOps
- MS SharePoint
- HP Quality Center
- Confluence
- ServiceNow
- MS Office suite
- MS Word
- Excel
- Outlook
- PowerPoint
- Project
- Tableau
- Power BI
- SSRS
- SQL
- Visual Basic
- XML
- JSON
- HTML
- UML
- Java
- MS Access
- Oracle
- Azure
- GCP
- Salesforce
- Windows Variants
Certification
- Certified Scrum Master, Scrum Alliance, 12/01/23
- Salesforce Certified Associate, Salesforce, 08/01/23
- Google Cloud Digital Leader, Google, 05/01/23
- Microsoft Certified: Azure Data Fundamentals, Microsoft, 01/01/23
- Microsoft Certified: Azure Fundamentals, Microsoft, 12/01/22
- Google Project Management Certificate, Google, 03/01/22
Timeline
Tech Mahindra
07.2022 - Current
Bank of Nova Scotia
07.2022 - Current
Pineapple Financial
03.2020 - 07.2022
DUCA
04.2019 - 02.2020
HDFC Bank
10.2016 - 03.2019
Master -
in computer applications