Simran Kaur Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

Supply Chain Analytics: As an Analyst at Metro Inc., I developed an Excel-based dashboard for vendor performance tracking, analyzing key performance indicators (KPIs) such as Customer Satisfaction (CSAT), Transfer Rate, and Retention Rate. This tool allowed for more effective monitoring and a faster response time in addressing discrepancies, directly enhancing vendor relations and overall operational performance.Data Integrity & Compliance: At Metro Inc., I ensured data integrity within SAP systems by conducting regular validations, which reduced discrepancies by 15%. My work supported Metro’s compliance efforts, enabling smooth facilitation of product recalls and store credit processes to adhere to regulatory standards and maintain customer trust.

Toronto, Ontario, Canada

Troubleshoot and Resolve Issues: Efficiently identified and resolved issues raised by various business units using relevant systems and tools, including SAP, SAP BW, and various databases, ensuring minimal disruption to operations.Data Management and Reporting: Maintained accurate records of reports and data entries, utilizing Excel and Excel Analytics to perform data validation and ensure accuracy while promptly addressing critical concerns.Stakeholder Correspondence: Managed communication with stores and business units regarding queries on cost, retail, interim adjustments, and relines, implementing process modifications and updates related to ongoing issues.Support Compliance Initiatives: Assisted the compliance group with product recalls by accurately entering pertinent information into the system, leveraging SAP to facilitate timely action by the business and mitigate risks.Customer and Store Support: Guided stores and customers through the store credit application process, ensuring adherence to accounting procedures and policies while utilizing financial management systems for tracking and reporting.

Toronto, Ontario, Canada

*Developed online category strategies in alignment with omni-channel goals by collaborating closely with category managers, leveraging Microsoft Excel for data analysis and Tableau for visualization of key metrics.*Conducted item-level assortment analysis to enhance inventory turnover and improve financial performance across categories, utilizing Power BI for reporting and tracking trends.*Provided analytical support for high-priority projects, including category refreshes and online event collections, driving eCommerce growth through data-driven insights.*Streamlined vendor onboarding processes and managed ongoing vendor activities, ensuring compliance with store standards and aligning with organizational goals.*Participated in requirements elicitation workshops with stakeholders to accurately document project requirements and visualize process flows using Lucidchart.*Performed competitive analysis and data analysis using tools such as Beyond Compare and Excel, generating reports that informed strategic decision-making.*Projected and anticipated five-year profit margins through comprehensive market research and trend analysis, utilizing Tableau and Power BI to present findings effectively.*Identified new vendors, supported negotiation processes, and coordinated delivery schedules to enhance vendor relationships and ensure alignment with business objectives.

AML and Financial Risk Specialist | Data Analytics | Process ImprovementAt KPMG Global Services, I played an integral role in identifying high-value investment opportunities and conducting detailed financial risk assessments. By leveraging data analytics tools like SQL, Tableau, and Power BI, I enhanced reporting efficiency, ensured AML compliance, and provided actionable insights that empowered portfolio managers to navigate complex market conditions strategically.Reporting and Insights GenerationQuarterly Funding Utilization Analysis: Using SQL for data extraction and Tableau for visualization, I analyzed quarterly funding utilization and calculated ROI, providing Firmwide leadership with data-driven insights on usage patterns and growth opportunities. This led to a 10% improvement in funding efficiency by optimizing fund allocations.Stakeholder Reporting: Developed custom Power BI reports to address specific fund usage queries. Leveraging conditional formatting and drill-through capabilities, I ensured insights were both relevant and easily navigable, enhancing transparency and aiding in prompt decision-making.Dashboard Preparation and Review: Created dashboards with Tableau that featured interactive filters and dimensional analysis, and performed rigorous quality assurance checks pre-release. This improved dashboard accuracy by 20%, empowering stakeholders to monitor trends and compliance metrics confidently.Process ManagementDocumentation: Maintained AML protocol and funding process documents in Confluence, supporting process consistency and reducing onboarding time by 30% through accessible, clear guidelines.Process Automation: Using SQL and Power Query, I automated repetitive reporting steps, reducing manual workload and reporting time by 20%. This enabled greater focus on high-value analysis, streamlining workflows and minimizing errors.

Senior Analyst | Transaction Monitoring | Better.comAs a Senior Analyst at Better.com, I played a vital role in optimizing transaction monitoring processes and ensuring compliance through strategic data analytics and effective collaboration. My key responsibilities included:Production Analysis: Utilized SQL and Tableau to conduct thorough analyses of daily and weekly production metrics. Identifying trends and performance gaps led to improved resource allocation and a 20% increase in team productivity.Task Allocation & Support: Managed the distribution of ad hoc tasks among Internal Consultants (ICs) using project management tools like Asana. I provided guidance to ensure efficient task completion, enhancing team effectiveness.Refunds and Appraisal Deposits Management: Oversaw customer and borrower refunds and appraisal deposits, utilizing Excel for tracking and automated systems for compliance. This focus on accuracy improved processing times and customer satisfaction.Collaboration on SOPs: Worked closely with management to develop and refine Standard Operating Procedures (SOPs) and presentation materials in Microsoft PowerPoint, promoting workflow improvements aligned with best practices.Data Preparation for Analysis: Prepared and maintained comprehensive datasets using SQL and Excel, enabling data-driven decision-making and supporting compliance initiatives.Training and Development: Assisted leadership in training new Internal Consultants on transaction monitoring processes and compliance standards, using Microsoft Teams for effective virtual training sessions.Root Cause Analysis: Conducted root cause analysis using Tableau to identify inefficiencies and implemented data-driven solutions, achieving a 15% reduction in turnaround times (TATs) and enhancing overall service delivery.

-Escalation Management: Streamlined escalation workflows, reducing backlog by 32% through structured follow-ups and root cause analyses, improving resolution timelines.-Client Solutions: Partnered with Account Managers to develop tailored solutions and implemented performance dashboards using Excel and Power BI, improving SLA adherence by 18% and enhancing client satisfaction.-Data Governance: Identified and resolved data discrepancies, introduced standardized reporting templates, and ensured compliance with regulatory standards, reducing data errors by 20%.-Process Optimization: Automated financial workflows using SQL and Excel, increasing accuracy by 25% and reducing manual processing times by 15%.-Vendor Management Expertise: Provided actionable insights and improved vendor management processes, boosting productivity by 13%.Tools Utilized: Leveraged SQL for data analysis, while utilizing Excel for financial tracking and dataset management. Employed Asana for task allocation, and Microsoft PowerPoint and Teams for presentations and training facilitation, enhancing team collaboration and communication.

-Conducted comprehensive KYC (Know Your Customer) reviews to verify borrower identities and assess potential risks, ensuring compliance with regulatory requirements.-Leveraged technology to drive continuous optimization of the mortgage production process by identifying and resolving operational and compliance gaps.-Analyzed consumer finance data, including income, assets, credit, and property information, to assess borrower eligibility and detect potential fraud or anomalies.-Performed in-depth reviews of financial documentation to ensure accuracy, compliance with internal policies, and adherence to regulatory standards.-Managed and organized borrower loan documentation efficiently, maintaining audit-ready records and streamlining processing workflows.-Applied AML typologies such as structuring, identity theft, and synthetic identities to detect red flags during borrower eligibility assessments.-Maintained effective communication with clients, addressing concerns to ensure smooth workflows and promote customer satisfaction.-Monitored and upheld Service Level Agreements (SLAs) with internal and external partners to ensure timely processing and high-performance standards.

-Gathered, organized, and analyzed large datasets with a focus on accuracy and detail to support data-driven decision-making.-Utilized tools such as Power BI, Hovers, and Bloomberg to extract and analyze datasets for comprehensive technical analysis.-Prepared and compiled data into presentations, spreadsheets, and reports to address regular and ad hoc requests, assisting senior management in delivering impactful insights.-Maintained and updated data sheets, ensuring accuracy and relevance for ongoing projects and analysis.-Monitored and tracked weekly production metrics of Associates across various projects to streamline operations and ensure timely delivery.-Conducted market and trend analysis to identify key insights and opportunities, enhancing the effectiveness of research deliverables.Skills: Research Projects · Data Analysis · Market Analysis · Trend Analysis · Financial Statements · Data Visualization

Closely observe and monitor Market Research and Customer Acquisition . Help in implementation of the new schemes to promote the product and capture the market share.

Postgraduate Certificate, Business Analysis

Master Of Business Administration - Mba, Banking And Finance

Postgraduate Certificate, Health Informatics

Bachelor Of Commerce, Honours