Dikshak Khanna

Experience

• 

  EGain Corporation

  Nov 2020 - Jul 2022

  Implementation Solution Engineer 1

  • Collaborated closely with the top 5 highest revenue-generating clients, providing strategic recommendations and personalized analytics report, leading to a 15% increase in client retention and a 25% growth in revenue.• Reviewed and analyzed data and transcript reports to identify trends and areas for improvement, using analytics dashboard resulting in a 20% increase in Virtual Assistant performance and efficiency within 3 months.• Implemented and optimized Virtual Assistant functionality, achieving a 90% accuracy rate through training the recommendation engine with personalized prompts and training using customer integrated data with product platform.• Collaborated with clients on a weekly 1 to 1 basis to provide performance insights and create personalized dashboards for their analytics team and drove efficiency improvements, also reaching a 92% precision rate in VA operations.• Implemented PL/SQL integration of Customer DB with product platform along with creating dashboards using Microsoft Power BI and Tableau, resulting in a 30% increase in software delivery speed and a 20% reduction in post-release defects. Show less

• 

  Hoosier Community Network

  Dec 2023 - Aug 2024

  Senior Consultant

  • Collaborated with a team of data experts to support the goal of an antique shop to make their products available online, we developed a comprehensive Azure-based ETL pipeline and analytics solution, transforming up to 1M+ raw data and making it accessible.• Employed Azure Data Factory to orchestrate and migrate data from over 20 large Excel files and REST APIs to Azure Blob Storage, providing a secure, scalable and cost-effective storage solution.• Engineered a robust data pipeline using PySpark for efficient data transformation, cutting processing time by 35%; integrated data into Azure SQL Database for streamlined querying and comprehensive reporting• Conducted real-time data processing in Azure SQL Database and used Azure Functions to trigger personalized notifications to customers via Azure Notification Hubs based on their interests.• Leveraged Power BI to create interactive dashboards for stock management and sales analysis, using DAX to craft complex calculations and metrics, providing actionable insights to different stakeholders.• Implemented Azure Monitor to track the performance and health of the ETL pipeline and services, and use Azure Cost Management and Billing to optimize resource usage and manage the budget efficiently Show less

• 

  Crawford, Murphy & Tilly

  Aug 2024 - now

  Data Engineer