Mohana Gupta

Mohana Gupta Scarborough, ON M1K 2P1 • - •- Summary Business Systems analyst, Agile Scrum Master (CSM) with over 6+ of experience in the Banking and Financial Services and IT industry. Experience in scrum, waterfall and hybrid software development frameworks for project delivery Expertise in sprint ceremony facilitation, conduct, and agenda creation (sprint planning, daily scrum, sprint review, sprint retrospective and backlog refinement). Capable of business development activities, handling contracts, client service and requirement gathering through interviews, survey, workshops, and existing records. Extensive years of expertise working in an Agile setting to gather and document technical requirements. Proficient in project scheduling activities, project coordination activities Performed data analysis for created reports by data visualization tool such as PowerBI and Tableau Extremely proficient at writing Business Requirement Documents, Functional Specification Documents, Systems Requirement Specifications, acceptance criteria, User Stories, epics, Use Cases, business case, Test Cases and test scenarios. Proficient in conducting Business Process Analysis to evaluate the compatibility of the current system infrastructure with the new business needs and in interpreting user expectations. Conducted JAD sessions including Subject Matter Expert (SME's) inquiring about the functioning components of the business process and meticulously updating the material as per the needs in an easily comprehensible style. Proficient in Use Case Diagrams, Activity Diagrams, Data Flow Diagrams, Entity Relationship Diagrams, root cause analysis, flowcharts and creating sops. Knowledge of AS-IS and TO-BE analyses, Gap Analysis, Process Mapping and process improvement Highly confident, innovative, self-motivated, driven and passionate with interpersonal, leadership, communication, analytical, interpersonal, presentation, and problem-solving skills, project management skills, strong analytical skills and stakeholder management skills Work Experience Business System Analyst Manulife Bank and Trust, Canada | Aug/2022 – Present Hired as a Business Systems Analyst for Banking KYC AML Regulatory reporting and Data Warehousing projects Collaborate with the clusters and the technical and cross-functional team to support and execute data quality check, data validation and data processing via systems and the data warehouse for payments. Ensures that all necessary reports are completed; identifies and resolves issues and threats that may interfere with daily operations. Accepts responsibility for resolving issues and moving the firm forward. Worked on industry trends, information gathering, enterprise system/architecture, project management, user stories, data mapping, data modeling, API development, and data extraction using technologies such as JIRA and Confluence. Performed data analysis using SQL and created reported using data visualization tool- PowerBI Conducted data cleaning, manipulation, and reconciliation; quality control; management of duplicate, outlier, and missing data; live and batch feed processing; information synthesis and communications ; SQL As the Agile Scrum Master, I showed verbal communication skills and organized sprints, daily stand-ups, and overall development for the offshore team (5-6 individuals) to guarantee that the project was finished on schedule and ready for deployment. Informed appropriate persons within the Bank Group and Business Units of the Run's progress and related processes. Managed defects/bugs using tracking systems such as MS Team Foundation Server and Azure DevOps, as well as general support for SDLC (software development life cycle), UAT(User acceptance testing), Go-live, and post-Production support. Created visual representations of "as-is" and "to-be" state diagrams, customer journeys, swimlanes,activity diagrams, sequence diagrams, and component-based diagrams using Microsoft Visio. Managed the frequent entry of data feeds from Businesses required for the operation, ensuring that they are timely, regular, accurate, and complete using Microsoft Power BI. Ensured that the appropriate management information system (MIS) is in place to provide senior management with timely, complete, and accurate information. Maintains a consistent flow of performance management information (MI) and engages with the company to discuss and improve its use. Tools: SQL, MS office, Jira, MS Visio,Microsoft office suite ,Python, PowerBI, SAS, UML & SharePoint. Business Analyst Home Trust Bank - Toronto, ON | March/2020 - July/2022 Project: The objective of the project was to identify business risk, credit risk and high-risk or potentially fraudulent activities before it negatively impacts business. Seamless integration with the existing systems to ensure no loss of finance data. Served as a liaison between the business and information technology teams.· Contributed to the success of company by primarily using financial software to create wealth management plans for individual clients· Conducted detailed and extensive data analysis of large data sets using data analytics tools of multiple stocks and bonds, Kpis, Key metrics which has greatly assisted the team and the team's client in expanding investment opportunities. Assisted in identifying and documenting business processes through interviewing clients and reviewing and analyzing existing systems and processes· Collaborated with the project team, product management team and vendors to outline specifications, conduct project planning, analysis, implement tasks, maintain schedule and status reporting to stakeholders and conduct risk management. Complete with dedication personalized needs assessments and reviews by leveraging tools,resources, and calculators to demonstrate value and support advice recommendations. Design and prepare technical specifications and assist in project artifact documentation in business requirement documents and functional specification documentation Conducted JAD sessions to allow different internal stakeholders to communicate their perspectives with each other, resolve technical or business issues and come to an agreement Created use case scenarios and documents workflows and business process design of new/enhanced reporting system platform, policies, procedures and address known deficiencies. Conducted current state analysis on existing reporting systems, documented gaps and developed future state and solution approaches. Supported the maintenance and development of the job aids like end users guide, knowledge base and training guide to ensure smooth change management. Conducted training of the customers and supported investigation, analysis, and response to incidents Captured technical business requirements in User Stories, diagrams and supporting artifacts Tools: SQL, Microsoft office, Jira, MS Visio, Power Point, Excel, Word, Outlook, MS project, MS TeamsTableau, UML, Trello & SharePoint Business System Analyst Motus Bank, Toronto, ON | January/2019 - February/2020 Project: The project was to develop mobile applications to help the customers conduct online transactions in the easiest manner and with better UX . Perform stakeholder analysis to identify impacted or influenced groups and business stakeholder Collaborated in the service design process for the client journey for ensuring smooth and user-friendly experience. Develop plans and accurate estimates for completion of requirements, while continuously improving the level of detail and accuracy of estimates. Apply advanced coverage analysis techniques to ensure relationship between scope, detailed requirements, and testing through to implementation. Communicate the impact of changes through cost-benefit analysis taking into consideration time, effort, and business priorities. Lead requirements prioritization and leverage techniques to drive out business priorities. Facilitate collaborative sessions with large and diverse business/ internal stakeholder groups (marketing, compliance, legal, architecture, UX/UI etc) to drive requirements discovery, analysis, and review. Developed wireframes and mockups for mobile application Support QA in development of the Functional System test plans/cases, validate that the Functional System test plan and test cases have full coverage of the critical requirements. Support UAT including planning, defect triage, and root-cause analysis for requirements-related issues. Performed Business analysis to define and document needs and requirements, supported th the consulting Business relationship Environment Tools: SQL, Microsoft office, Asana, MS Visio, Power Point, Excel, Word, Outlook, MS project, MS TeamsTableau, UML, Trello & SharePoint Jr. Business Analyst EasyFinancial-Victoria BC | January/2018 - December/2018 Synthesized current business intelligence data to produce reports and polished presentations Conducted interviews with key business users to collect information on business processes and user/ customer requirements. Reviewed files, records, and other documents to obtain business information and key data information responses to development requests. Assigned tasks to associates, staffed projects and updated all involved parties to enhance optimal business flow. Provided customer support and resolved problems while ensuring continuous improvement. Provided systems support related to integrated custom applications with complex business processes. Facilitated the completion of projects within budget and timelines by identifying potential risk and devising mitigation strategy Professional Certification Certified Scrum Master (CSM) Certified Scrum Fundamentals IBM Data Analyst Professional Certificate Microsoft Azure AI fundamentals Professional Certificate Microsoft 365 fundamental certified Education Master’s Degree | Master of Business Administration in Agribusiness |- | Symbiosis International University, India Bachelor’s degree | Bachelors in Biotechnology |- | Amity University, India