Gursimran Singh Email & Phone Number

Markham, Ontario, Canada

Toronto, Canada Area

• Overview:o Worked in multiple fast paced teams for PC Optimum program (Loyalty & Rewards program for Loblaw (LCL), Shoppers Drug Mart (SDM) and partner companies) in a cross functional agile environment to solution and deliver prioritized product improvement initiatives resulting in loss prevention and revenue growth.• Responsibilities:o Gathered, defined, and clearly documented business requirements after clarifying scope and acceptance criteria.o Facilitated… Show more • Overview:o Worked in multiple fast paced teams for PC Optimum program (Loyalty & Rewards program for Loblaw (LCL), Shoppers Drug Mart (SDM) and partner companies) in a cross functional agile environment to solution and deliver prioritized product improvement initiatives resulting in loss prevention and revenue growth.• Responsibilities:o Gathered, defined, and clearly documented business requirements after clarifying scope and acceptance criteria.o Facilitated workshops and design sessions with Subject Matter Experts, product management and technology teams to brainstorm solutions, acting as a bridge between Business and Technical teams, and to estimate work efforts + timelines.o Translated business requirements into epics and user stories with acceptance criteria for validation and ensured alignment in Business and Technical Requirements both Functional and Non-Functional Requirements (performance, SLAs etc.)o Developed Functional Design / Business Requirement Document (FDD, FRD, BRD) and got approvals from stakeholders.o Collaborated with Product Managers to identify dependencies, manage product backlog and do sprint planning.o Developed wireframes for visual clarity so that solution is clear and unambiguous.o Created process models (flowcharts, use case diagram, sequence diagram) to document end-to-end workflow.o Maintained functional design documents with source to target data mapping and business transformation rules.o Worked closely with development and quality assurance team to implement solution and did acceptance testing.o Ensured all levels of stakeholders are aligned with the requirements, solution, scope and its value proposition using verbal and written communication skills.o Participated in daily scrums, solution demonstrations, deployments, and retrospectives.o Helped support teams in troubleshooting and timely resolution of production issues to avoid customer impacts. Show less

Toronto, Canada Area

• Overview:Worked on Data Governance project for Business Banking department to analyze their current and legacy data, reports to develop Lineage artifacts and documented them in database to have data visibility and to improve data quality. • Responsibilities:o Backtracked report fields to their ultimate sources to have clear view of dependencies, transformations of report elements and captured results in SQL Server database (output of 1 report was input to another… Show more • Overview:Worked on Data Governance project for Business Banking department to analyze their current and legacy data, reports to develop Lineage artifacts and documented them in database to have data visibility and to improve data quality. • Responsibilities:o Backtracked report fields to their ultimate sources to have clear view of dependencies, transformations of report elements and captured results in SQL Server database (output of 1 report was input to another report).o Identified and prioritized new reports, exchanged updates and resolved any blockers or doubts to attain maximum working efficiency in the scrum meetings.o Interacted with end users and subject matter experts to understand use case of reports and assigned priorities.o Developed data mapping documents to capture source to target transformation rules for each data element.o Created process manuals, sequence diagrams and process flows to document each step in various workflows.o Worked independently and collaborated with team while maintaining multiple project activities and deliverables.o Collaborated with Managers to develop, prioritize and assign user stories during backlog grooming and sprint planning. o Researched details for legacy dataset elements to maintain multiple Lineage documents like Report Element Mapping, Metadata and Business Glossary documentation, to name a few.o Training in multiple Information Management areas like Data Management, Data Mapping, Analytics, Data Warehousing, Project Delivery with major focus on Business Systems Analysis. Show less

Toronto, Canada Area

• Overview:Worked with Network Services team for migration project from HP to CISCO devices with focus on improved efficiency.• Responsibilities:o Demonstrated strong communication skills with field representatives, department heads and network services team to understand their needs and priority to develop and maintain user stories in JIRA and ServiceNow.o Utilized SQL to query data and used that data to develop dashboards for reporting on metrics and key performance… Show more • Overview:Worked with Network Services team for migration project from HP to CISCO devices with focus on improved efficiency.• Responsibilities:o Demonstrated strong communication skills with field representatives, department heads and network services team to understand their needs and priority to develop and maintain user stories in JIRA and ServiceNow.o Utilized SQL to query data and used that data to develop dashboards for reporting on metrics and key performance indicators.o Developed value stream maps, use case diagrams and process flow diagrams to document workflows.o Developed functional design, mapping documents and training manuals for the team to prepare, implement, and document updates for quick and efficient flow and to avoid any technology risks.o Quickly grasped and maintained multiple tasks for system development with subject matter experts (SME), gathering requirements, data analysis, supporting test strategies and User Acceptance Testing (UAT). Show less

Cambridge, Ontario, Canada

• Overview:Worked to configure, troubleshoot and for quality assurance of products to ensure they adhere to industry standards• Responsibilities:o Assembled articles based on user requirements adhering to acceptance criteria and guided for any issue resolution.o Prepared reports to gather insights on key metrics and inventory.o Helped improve work efficiency by recommending changes to UPC location in the warehouse by leveraging sales data to reduce processing… Show more • Overview:Worked to configure, troubleshoot and for quality assurance of products to ensure they adhere to industry standards• Responsibilities:o Assembled articles based on user requirements adhering to acceptance criteria and guided for any issue resolution.o Prepared reports to gather insights on key metrics and inventory.o Helped improve work efficiency by recommending changes to UPC location in the warehouse by leveraging sales data to reduce processing time, resulting in increased productivity by up to 15%.o Analyzed shopping patterns and did item tracking to maintain inventory.o Investigated product issues and recommended course of action to resolve customer escalations/complaints.o Demonstrated effective communication and time management skills to deliver under tight deadlines.o Conducted quality assurance testing to ensure final product meets or exceeds client needs/requirements.o Consolidated information from multiple sources to form weekly reports using advanced MS Excel, Tableau Show less

Ontario College Graduate Certificate, It Business Analysis - Operations, Gpa: 3.76/4 - Dean'S Honour List And Graduate With Distinction

Bachelor’S Degree, Computer Science, 81% - First Class With Distinction

Activities and Societies: Technical Society, Cultural Society Technologies: C, C++, JAVA, HTML5, JSON, XML, SAS, CSS3, Bootstrap.