Gurleen Kaur Email & Phone Number

• Over 2+ years of Data Analyst experience in using SQL and Python, with data manipulation, transformation, and statistical analysis to extract meaningful insights from complex datasets and hands-on experience in data reporting, analysis, cleansing, Modeling, and visualization.• Excelled in SQL for intricate data extraction and analysis, demonstrating proficiency in executing sophisticated ETL processes and optimizing queries for peak efficiency • Proficient in Python, employing libraries like NumPy and Pandas for extensive data manipulation, achieving marked improvements in data processing workflows and analytical efficiency• Expertise in analysing structured data records with NumPy and Pandas, generating actionable insights that have directly contributed to measurable enhancements in business operations.• Skilled in Tableau to develop innovative data visualizations, crafting intuitive dashboards that translated complex datasets into accessible and influential business intelligence• Advanced user of Excel, mastering functionalities such as VLOOKUP and Pivot Tables to elevate data analysis, and reporting capabilities, and automate repetitive tasks, by optimizing data organization strategies• Specialized in advanced Power BI applications, focusing on data Modeling and DAX queries to refine data analysis and enhance the accuracy• Hands-on experience in designing and implementing machine learning models to uncover deep insights, optimize business processes, and predict outcomes• Adept in VBA, with a notable track record of automating Excel operations, enhancing process efficiency, and developing robust Excel Macros to simplify complex workflows, significantly boosting productivity.• Expertise in designing and implementing Key Performance Indicators (KPIs) that have led to significant advancements in business efficiency, performance, and profitability• Highly proficient with SSIS and SSRS, adept at streamlining ETL processes and generating impactful reports, significantly enhancing data-driven decision-making and operational efficiency• Demonstrated proficiency in leveraging CRM (Customer Relationship Management) systems to analyze customer data effectively, optimize marketing strategies, and drive business growth.• Experienced in utilizing Power Query for adept data extraction and transformation, applying strict data validation techniques to guarantee data integrity and accuracy• Exhibited expertise in utilizing SAS Statistical Analysis System for advanced data analysis, predictive Modeling, and statistical inference

• 

  Data Analyst

  Spin Master

  Dec 2021 - Present - Ontario, Canada

  • Designed, developed, and maintained a comprehensive suite of Power BI dashboards, providing real-time visibility into financial metrics across the organization• Led detailed analyses of financial and customer data using SQL and Python, uncovering critical insights that significantly influenced business strategy and operational efficiency.• Transformed reporting efficiency by automating critical Excel reporting processes with VBA, improving data accuracy and operational… Show more • Designed, developed, and maintained a comprehensive suite of Power BI dashboards, providing real-time visibility into financial metrics across the organization• Led detailed analyses of financial and customer data using SQL and Python, uncovering critical insights that significantly influenced business strategy and operational efficiency.• Transformed reporting efficiency by automating critical Excel reporting processes with VBA, improving data accuracy and operational productivity.• Stayed updated on industry trends, emerging technologies, and best practices in data analytics and financial services and pursued ongoing professional development opportunities, such as certifications or advanced training programs, to enhance skills and knowledge in relevant areas.• Worked on Microsoft Power BI, including advanced data refresh techniques, dynamic Modeling, DAX functions, sophisticated visualizations, and thorough content management and deployment.• Involved in the development and management of Key Performance Indicators KPIs, delivering critical insights that directly impacted strategic decisions• Documented methodologies, assumptions, and data sources used in analysis to ensure transparency and reproducibility and shared insights and findings with internal teams through presentations, training sessions, and knowledge-sharing platforms.• Played an active role in evaluating and choosing advanced CRM software for data analysis, resulting in improved reporting and analytical efficiency company-wide• Utilized Power Query to conduct thorough variance analysis on quarterly financial reports, identifying inconsistencies and delivering actionable insights to senior management for performance enhancement• Employed macros and SAS to interpret intricate financial data, such as market trends, investment performance, and risk analysis Show less