Ganeshkumar Gandhikumar Email & Phone Number

Toronto, ON, CA

Toronto, Ontario, Canada

• Employ Power Query and SQL extensively to extract, manipulate, and transform diverse datasets from various sources, ensuring data integrity and consistency.
• Leverage Power BI and Python for comprehensive data analysis, employing statistical methods and visualization techniques to derive actionable insights and trends.
• Proactively identify areas for process automation, utilizing Python scripting and VBA macros to streamline workflows and enhance operational efficiency.
• Implement robust data cleansing methodologies, including data validation and error handling, to maintain high data quality standards throughout the analysis process.
• Vigilantly monitor data pipelines, tracking performance metrics and generating detailed reports to assess data accuracy, completeness, and timeliness.
• Foster collaboration across multidisciplinary teams, facilitating effective communication of analytical findings and strategic recommendations to key stakeholders.

Canada

• Improved data accuracy through rigorous data cleansing processes, resulting in 97% significantly higher accuracy across all datasets. Automated ETL workflows, greatly reducing manual data handling efforts and enhancing.
• Accelerated data analysis with advanced Excel techniques, such as pivot tables and VLOOKUP, reducing analysis time. Enhanced data preparation efficiency using Python libraries like NumPy and Pandas for data.
• Developed interactive Tableau dashboards, increasing data visibility and comprehension by 30% among stakeholders.
• Achieved a significant improvement in predictive accuracy by implementing machine learning models for data-driven decisions. Collaborated with cross-functional teams to define and monitor KPIs, contributing to an.
• Streamlined report generation through automation, saving time and improving reporting efficiency. Facilitated effective project management and documentation using Jira and Confluence, increasing team productivity.
• Developed SQL queries and scripts to transform raw data into standardized tables, enhancing data consistency and usability Utilized SQL to optimize data retrieval, resulting in a 50% reduction in query execution time.

India

• Developed and maintained advanced Power BI dashboards. Increased dashboard interactivity by 40%, leading to more in-depth data exploration. Conducted in-depth customer segmentation analysis to identify target customer.
• Created data statistical analysis and visualizations, leveraging data querying languages within available data management technologies. Built a database and used SQL to store and analyze data for measuring the success.
• Designed for special requests such as Project Needs Assessment based on the Power BI report tool using an action filter which provided the first-ever ability to easily review and drill down into needs to identify.
• Worked on Forecasting or Predictive analysis based on historical data using DAX in Power BI. Migrated monthly reports from Excel to analysis services using Power BI as per the client's requirements.
• Utilized VBA, SQL, and other programming languages to make the database and reporting process more efficient. Used DAX to create complex calculated columns and measures, optimizing data models and facilitating a 25%.
• Worked on ETL data process required to reach user defined objectives in visualization.

Postgraduate Certificate, Big Data Analytics

Post Graduate Certificate, Market Research And Analysis

Bachelor Of Engineering, Mechanical Engineering