Gourav Ganesh

About Gourav Ganesh

As a Data Analyst passionate about transforming raw data into powerful business insights, I thrive at the intersection of analytics, AI, and innovation. My work revolves around helping organizations make smarter, faster, and data-backed decisions — whether it’s optimizing performance, predicting trends, or automating complex workflows.With hands-on expertise in Power BI, Tableau, Python, SQL, and PostgreSQL, I love bringing numbers to life through compelling visualizations and intelligent automation. I’ve also explored the frontier of Generative AI, Large Language Models (LLMs), NLP, and Chatbot Development, leveraging them to simplify analytics and enhance business intelligence capabilities.I’m deeply motivated by challenges that push me to learn — from integrating AI with data pipelines to implementing MLOps-driven process automation. My goal is to bridge the gap between technical precision and business value, ensuring every insight leads to meaningful impact.Beyond work, you’ll often find me riding through scenic routes, exploring nature, and drawing inspiration from the world around me — because I believe curiosity fuels both discovery and data. Always open to conversations about AI, data storytelling, and opportunities that create real-world impact.

Experience

1. Trade Analyst

   Tata Consultancy Services

   Sep 2023 — Present · Bengaluru, IN

   Orchestrated license assignment analysis for goods and export shipments using SAP GTS, optimizing compliance processes and reducing shipment delays by 25% across multiple trade lanes. Engineered interactive Tableau dashboards to visualize license assignment criteria for exported goods, improving client understanding and decision-making accuracy by 20% across international markets.🧩 Leveraged Hadoop to extract, clean, and process high-volume data from GTS Block Enhancement Reports, refining license criteria application and accelerating order processing time by 30%.🧠 Performed high-risk data manipulations in Excel, including advanced formulas and cross-sheet validations, achieving a 15% reduction in export operation costs through improved data accuracy and process visibility. Automated multiple subprocesses using Python, SQL, and Excel VBA, significantly improving end-to-end efficiency and cutting manual effort by 40%. Developed and deployed VBA automation scripts to generate daily license and QC reports, replacing repetitive manual data handling and saving approximately 6 hours per day for the operations team.🧾 Automated the AMC Trade Backlog Report by creating SQL-based data pipelines in Azure Databricks, integrating multiple raw datasets, and visualizing outputs through a custom Tableau dashboard — improving real-time tracking and communication with stakeholders. Extracted unstructured data from multiple SAP tables and utilized SQL joins (INNER, LEFT, and FULL) to merge and restructure datasets into an analytical-ready format, ensuring data integrity and completeness. Enhanced reporting accuracy and performance by establishing end-to-end data validation checks across Excel, SQL, and Tableau layers, minimizing reporting discrepancies by over 20%.🤝 Collaborated with global trade compliance leads to align automation outputs with business rules, enabling faster identification of shipment blocks and more accurate license assignments.

Education

• Amrita Vishwa Vidyapeetham

  Master's degree, Applied Statistics and Data analytics

• Amrita Vishwa Vidyapeetham, Coimbatore

  Bachelor's degree, Mathematics

• Bala Vidya Mandir

  Higher education