Simranjit Kaur Email & Phone Number

Toronto, Ontario, Canada

• Collected and analyzed data from various sources within the company, such as customer databases, insurance claims, and financial records, to provide insights that inform strategic decisions and improve business performance• Created interactive Power BI Dashboards, KPIs, and Reports for Monthly Metric analysis to replace traditional excel reporting and automate data refresh using Power BI • Used analysis and visualization tools such as SQL, Excel, and Tableau to analyze the data and draw accurate and reliable conclusions to provide insights to upper management• Conducted analysis of various sets of data using SQL contents, culminating in an overall analysis summary that was precise and trustworthy by relevant industry standards• Reorganized data into more easily navigable and intuitive categories that benefited not only team data analysts but also everyone who has the access to data• Designed and implemented complex Excel formulas, pivot tables, and conditional formatting to automate data analysis and reporting tasks. • Developed and optimized DAX calculations and measures in Power BI to perform complex data manipulations and calculations, enabling advanced analytics and reporting. • Automated repetitive tasks in Excel using VBA macros, reducing processing time by 50% and improving overall productivity. • Experienced in utilizing data visualization tools like Tableau or Power BI to create interactive dashboards and visual representations of complex data sets, facilitating data-driven decision- making. • Developed and initiated more efficient data collection procedures• Collaborated with other team data analysts to accomplish delegated tasks by effectively communicating with team members, and developing new reports

Toronto, Ontario, Canada

• Collect, clean, and preprocess data from various sources to ensure data quality and accuracy.• Create data visualizations to effectively communicate insights, trends, and patterns to non-technical stakeholders.• Maintain proficiency in SQL for data extraction and manipulation, as it's a crucial skill for both data analysts and data specialists.• Translate data findings into actionable recommendations and insights for business decision-makers.• Apply more advanced statistical analysis, predictive modeling, and machine learning techniques to extract deeper insights from data.• Understand and practice data governance principles, including data security and compliance with data-related regulations.• Developed compelling and interactive data visualizations using tools such as Tableau, Power BI, or other relevant visualization tools.• Presented data in a visually appealing and informative manner to convey insights to stakeholders.• Ensured the accuracy and completeness of the data. This includes validating the data using VLOOKUP to identify and correct errors or inconsistencies. • Designed Python libraries such as Pandas, NumPy, and Matplotlib to explore and visualize the data. This involves identifying patterns, trends, and relationships in the data, as well as creating visualizations such as scatterplots, histograms, and heatmaps.• Identified opportunities to enhance data collection, analysis, and reporting processes, leading to increased efficiency and accuracy.