Ganeshkumar Gandhikumar Email & Phone Number

Toronto, On, Ca

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.•Provide expert technical support and comprehensive training on data analysis tools, empowering colleagues to effectively leverage analytical capabilities for informed decision-making.•Demonstrate a commitment to continuous learning and professional development particularly in latest technologies like PowerApps, PowerPages, PowerAI, Dataverse etc., staying abreast of emerging trends and advancements in analytics technologies to drive innovation and excellence in data analysis practices.

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 data processing efficiency.•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 preprocessing.•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 enhancement in overall business performance.•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 and improved report turnaround.•Utilized data analysis techniques and tools to generate valuable insights and actionable recommendations for business improvements, contributing to data-driven decision-making and positive impacts on the organization.•Built deployed and maintained data management systems and back-end data infrastructures for the Business Intelligence Pipeline.

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 groups for tailored marketing campaigns, resulting in a 15% increase in conversion rates.•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 of marketing projects.•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 trends and alignment with business strategy.•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% improvement in data visualization accuracy and insights for stakeholders.•Worked on ETL data process required to reach user defined objectives in visualization.•Automated tested data extraction and reporting using Python and VBA reducing manual effort by 35% by minimizing errors.•Worked in an agile environment and have good insight into agile methodologies and lean working techniques participated in Agile ceremonies and scrum meetings.

Postgraduate Certificate, Big Data Analytics

Post Graduate Certificate, Market Research And Analysis

Bachelor Of Engineering, Mechanical Engineering