IT Business Analyst
Ministry of Labor and Transportation - Ontario
Total years of experience :9 years, 5 Months
Collaborated and Enhanced the Employment Ontario (EO) portal as per Ministry Directives after carefully understanding the impact to the data streams shared with other Ministries. Coordinated with the ministry integrators (System Service Managers) to share Employment Ontario data via API and catering to their ongoing data requests and responses. Maintained functional design documents (FDDs) to record the updates and enhancements.
• Project included planning and execution of the Discovery and Alpha phases of the project.
• Collaborated with cross-functional and cross projects teams to gather project requirements from product Owners and Ministry Integrators and to define objectives.
• Regularly communicated progress updates to the Senior Business Leads on timelines and go live dates.
• Conducted JADs with System Service Managers (SSMs) to identify and resolve the issues faced by the integrators and to cater their evolving needs.
• Conducted feasibility and impact analysis to assess the viability of project initiatives.
• Participated in project scoping activities and provided estimates for project work.
• Cleared the backlog of missing documentation on Functional Design Documents and also created/maintained user guides communicated them to the stakeholders via SharePoint and DevOps.
• Identified areas for process improvement and recommended solutions by reengineering the data/workflows.
• Engaged in requirements elicitation, gathering detailed project requirements and translated them into detailed specifications.
• Conducted or participated in walkthroughs at key project milestones.
• Evaluated project progress and provided insights to improve project outcomes and stabilize the releases.
• Facilitated knowledge transfer sessions to educate key team members.
• Reported project status to Project Manager and stakeholders.
Mortgage, Discharge and Transfer Document Registration using API integration with BC Land Title Services Authority (LTSA). Used Automation Anywhere to program Bots to perform repetitive tasks to conduct Title Searches in TeraNet as well as BC LTSA. It was developed with Agile (Scrum) methodology and the application was enhanced to service the in-flight as well as new deals.
• Project included receiving Mortgage particulars from the Lenders (Brokers) currently integrated with FCT through the API mostly banks and credit unions including Tangerine Bank which FCT has a POA for.
• The automation (Bots) processes the PI (Personal Information) to get the Title Searches, Mortgage and Discharge Registrations through TeraNet for ON and LTSA for BC and SPIN ll for AB.
• Relevant Form B (mortgage), Form C Charge and Form C Discharges were generated and sent back to the Lenders (Brokers) for signing by their clients.
• Documents were then trued up by the Title Officers and once confirmed shared to the lawyers for final review and registration with relevant provincial authorities as mentioned above.
• The registration particulars (Parcel register) were then sent back to the Lenders (Brokers) through the API
• Parcel register was then Parced for quick processing and retrieval of information.
• Worked on the following artifacts; Open API Specification through Swagger, ICD documents provided by the Integrator, Integration Data Dictionary, Registration forms template data dictionary, Schemas for the forms and YAMLs.
• Used interviews, workshops, controlled brainstorming sessions, and prototyping to elicit business requirements from the stakeholders
• Provided guidance and acted as an integral part of Scrum Ceremonies namely Sprint Planning Meeting, Daily Standup Meeting, Sprint Review Meeting and Retrospect Sprint meeting.
• Using Agile methodology in highly flexible and interactive manner for project cohesive team building, collaboration with clients, to deliver a working application, using scrum groups.
• Engaged clients to gather and translated stakeholder requirements into different tangible deliverables such as Functional Specifications, use cases, user stories, workflow/process diagrams, data flow/data model diagrams
• Translate business requirements into functional & technology requirements and design & development plans to implement
• Facilitated dialogue between internal and external stakeholders, prioritizing between competing objectives, including meetings, focus groups, joint sessions, workshops
• Created UML: Use Case Diagrams, Process diagrams, Activity Diagrams, Sequence Diagrams with MS Visio
• Conducted walk-through sessions to validate User stories, acceptance criteria, acceptance testing, and story point estimations
• Used Axure to create Wireframes as per business UI/UX guide to enhance user experience.
• Documenting and updating Issues (Epics, Stories, and Tasks) into Azure DevOps application
Merchant Resource Management Tool: Delivered Web based customer facing Merchant Resource Management Tool for e-commerce vendors. It was developed with Agile (Scrum) methodology and was enhanced to serve the existing and new prospective customers with new digital payment technology channels.
• Translate IAM strategies and direction into actionable, measurable controls and ensure the alignment of IAM controls with data governing policies like FIPA, HIPPA, PIPEDA
• Used interviews, workshops, controlled brainstorming sessions, and prototyping to elicit business requirements from the stakeholders
• Collaborated with security architects to classify and validate open end points to data and solution
• Advance the IAM program by driving policy and standard adoption and compliance
• Responsible for planning and execution of the access management initiatives, worked with diverse teams of business stakeholders, application owners and administrators to understand and define the key functional and technical requirements and milestones.
• Provided guidance and acted as an integral part of Scrum Ceremonies namely Sprint Planning Meeting, Daily Standup Meeting, Sprint Review Meeting and Retrospect Sprint meeting
• Using Agile methodology in highly flexible and interactive manner for project cohesive team building, collaboration with clients, to deliver a working application, using scrum groups
• Engaged clients to gather and translated stakeholder requirements into different tangible deliverables such as Functional Specifications, use cases, user stories, workflow/process diagrams, data flow/data model diagrams
• Translate business requirements into functional & technology requirements and design & development plans to implement
• Facilitated dialogue between internal and external stakeholders, prioritizing between competing objectives, including meetings, focus groups, joint sessions, workshops
• Created UML: Use Case Diagrams, Process diagrams, Activity Diagrams, Sequence Diagrams with MS Visio
• Conducted walk-through sessions to validate User stories, acceptance criteria, acceptance testing and story point estimations
• Documenting and updating Issues (Epics, Stories, and Tasks) into JIRA application
• Acted as an SME to clarify queries regarding Mutual Funds, Options, Derivatives and Swabs.
• Worked on Broadridge data system to analyze day to day market trends.
Advisor Planning Tool in Wealth Management: Enhanced Advisor Planning Tool in Wealth Management Group to aid the Financial Planners/ Advisors to better serve the existing as well as the new clients by using Agile (SCRUM) methodology.
• Advisor planning tool catered Advisors from Canadian and American offices. This project led to portfolio management system migration. The system managed investment portfolio security accounts for Equities, Derivatives, Term Deposits, Bonds, Fixed Income, GICs, Mutual funds, Index funds, EFTs, TFSA, RRSP, RESP, RIFFS
• Replaced the current enterprise Provisioning process to a complex enterprise wide solution
• Documented Use cases, GAP analysis and future state for implementing new Identity Management system
• With AS-IS and TO-BE state analysis, performed GAP analysis of business rules, business and system process flows
• User stories documentation resulting in a clearer, detailed and more complete understanding of project deliverables
• Coordinated with business partners and assisted the Product Owner in prioritizing product backlog on an ongoing basis to meet release timelines and value to the business
• Coordinated with cross-functional subject matter experts with new functionality and the Scrum process
Retail Banking and Investment Product Modernization: Designed Banking and Investment product modernization solution to serve prospective customers with Digital only technology channels. It managed retail banking, loan accounts and Investment accounts for savings accounts, current accounts, GICs, TFSA, RRSP, RESP.
• Document the current state of existing account management lifecycle, including conducting stakeholder interviews with multiple teams to gather information on what is done today for account provision/de-provision
• Elicited business requirements through one on one interviews, workshops, controlled brainstorming sessions, prototyping with product owners, SMEs, architects, SOA developers and technology partners
• Identified the Document Owners within each Business Unit that were associated with the process. Collected business, system, and functional requirements by conducting detailed interview with business users, stakeholders, and Subject Matter Experts (SME'S). Nurture and grow positive relationships with stakeholders. Alter communication style for each partner engagement.
• Worked with external organizations and business partners to coordinate cross-team deliveries and dependencies
• Provision/de-provision of account and assign roles in central directory which is fed from the HR
• Assisted product owner in prioritizing requirements in Product backlog and improved user stories
• Participated in Sprint Planning, Daily Scrum Standups, Sprint reviews and Sprint Retrospective meetings
• Managed Active Directory, GPO, user accounts, shares, security permissions etc.
• Facilitated iteration planning meetings, lead work within individual sprints and coordinate retrospectives and demos with Scrum master
Net Worth Calculator (FHNC) - Wealth Management: Developed a financial planning tool, 'Financial Health & Net-worth Calculator (FHNC)' to aid the financial advisors to better serve the existing as well as the prospective clients.
• AS- IS process analysis to determine project feasibility
• Ensured all usability related items which must be executed are captured in the form of Product Backlogs
• Participated in JAD sessions for requirement and risk analysis with various stakeholders
• Used VB Script to automate the MS Excel repetitive word functions as well as data related functions.
• Extensively used Use Case diagrams and Activity Diagrams to depict system functionality and user interaction
• Validated Sprint backlogs with the team by conducting sprint review meetings and daily stand up meetings
• Used SharePoint as a single point of access to everything including business applications, email, calendars and feeds.