Amanpreet Kaur Garaye Email & Phone Number

Toronto, On, Ca

London, Ontario, Canada

Ontario, Canada

• Evaluated processes within information systems and suggest tailored solutions to enhance effectiveness and productivity.• Utilized Tableau to create interactive dashboards that provided real-time sales insights, enabling leadership to make data-driven inventory management decisions.• Performed examinations to verify dependability, precision, and operational effectiveness of system modifications and improvements.• Optimized complex SQL queries using window functions and… Show more • Evaluated processes within information systems and suggest tailored solutions to enhance effectiveness and productivity.• Utilized Tableau to create interactive dashboards that provided real-time sales insights, enabling leadership to make data-driven inventory management decisions.• Performed examinations to verify dependability, precision, and operational effectiveness of system modifications and improvements.• Optimized complex SQL queries using window functions and CTEs (Common Table Expressions) to achieve a 30% reduction in query execution time, improving data analysis efficiency.• Evaluated customer feedback and satisfaction survey data specific to dealer interactions and services.• Ensured that dealerships adhere to Honda's quality standards and compliance requirements through data analysis and reporting.• Examined warranty claims data to identify trends and issues that need attention, such as recurring defects.• Utilized data normalization techniques to address data redundancy and improve the consistency of data across diverse sources, facilitating data integration and analysis.• Created interactive dashboards using Tableau with drill-down functionalities, allowing stakeholders to explore data at various levels of detail and gain deeper insights. Show less

- Developed predictive models and applied machine learning algorithms to enhance customer retention, resulting in increased profits in the subsequent quarter.- Executed end-to-end data integration and ETL processes, ensuring seamless data flow and high-quality reporting.- Analyzed large financial datasets related to transactions, market trends, and investment portfolios, identifying critical insights for stakeholders.- Created financial models to forecast trends, supporting… Show more - Developed predictive models and applied machine learning algorithms to enhance customer retention, resulting in increased profits in the subsequent quarter.- Executed end-to-end data integration and ETL processes, ensuring seamless data flow and high-quality reporting.- Analyzed large financial datasets related to transactions, market trends, and investment portfolios, identifying critical insights for stakeholders.- Created financial models to forecast trends, supporting data-driven decision-making for clients.- Utilized SQL for data extraction and integration, and Tableau for visualizing complex datasets and delivering insights. Show less

Durham Region

Working Experience on Project Life Cycle and SDLC methodologies including Agile. Perform slicing and dicing of data using SQL and Excel for data cleaning and data preparation. Create databases using MySQL, write several queries to extract data from database. Conducted data analysis using SQL and other analytical tools to identify trends, patterns, and insights. Developed complex SQL queries, stored procedures, and functions to retrieve, manipulate, and analyze large datasets efficiently… Show more Working Experience on Project Life Cycle and SDLC methodologies including Agile. Perform slicing and dicing of data using SQL and Excel for data cleaning and data preparation. Create databases using MySQL, write several queries to extract data from database. Conducted data analysis using SQL and other analytical tools to identify trends, patterns, and insights. Developed complex SQL queries, stored procedures, and functions to retrieve, manipulate, and analyze large datasets efficiently. Creating and publishing multiple dashboards and reports using Tableau server. Presented analysis findings and actionable recommendations to management in clear and concise reports. Collaborated with cross-functional teams to gather requirements and translate business needs into technical solutions. Show less

Post Graduate Certificate, Artificial Intelligence

Studied following subjects in the first semester Visualisation And Data Storytelling, ( Tableau ) AI Algorithms I,( supervised.

Bachelor Of Technology - Btech, Electrical, Electronics And Communications Engineering, 8.58

Activities and Societies: Comparing for national Science day'2015 First Prize Inter College Basketball Competition. Second prize in mime.

Post Graduate Certificate, Data Analytics In Buisness Decision Making.