Shivam Khandelwal

Experience

• 

  NTT DATA GLOBAL DELIVERY SERVICES PRIVATE LIMITED

  May 2017 - Aug 2019

  Software Development Senior Associate

  • Collaborated with SQL development and business analysis teams to pinpoint performance improvement opportunities, achieving a 34% reduction in server load through optimized ETL processes, resulting in enhanced system reliability, and reduced costs.• Developed and delivered over 60 interactive visualizations and reports using Tableau and Azure Insights, empowering clients with actionable insights.• Automated data extraction and transformation processes using Python scripts, reducing data preparation time by 25% and increasing the efficiency of analytics workflows.• Proactively designed automation processes for data source monitoring and updates, creating backup procedures that reduced manual effort by approximately 8 hours per week, dramatically enhancing team productivity and operational efficiency.• Managed and optimized SQL database performance, leading to a 15% increase in query speed, which improved overall application responsiveness and user satisfaction.• Conducted thorough data quality assessments and implemented data cleaning techniques using Python and SQL, ensuring high data integrity across reporting systems. Show less

• 

  Technological University Dublin

  Jul 2021 - Mar 2022

  Research Analyst (Data Science)

  • Leveraged advanced statistical techniques to conduct Monte Carlo simulations over 100-year projections, delivering critical insights into the impact of climate change on disease transmission patterns.• Executed sophisticated statistical analyses using regression techniques, achieving model prediction accuracies of up to 95% for COVID-19 and Cryptosporidiosis, thereby enhancing public health response strategies.• Georeferenced open-access data (Google Cloud Earth Engine) with ArcMap, aiding the identification of socio-economic and environmental factors influencing disease spread, which informed targeted interventions.• Contributed to the ideation and execution of data-driven experiments, incorporating analytics and AI methodologies to develop innovative solutions for pressing public health challenges.• Collaborated with interdisciplinary teams, facilitating knowledge exchange that enriched research quality and broadened project scope. Show less

• 

  University College Cork

  May 2022 - Oct 2022

  Research Data Analyst

  • Collaborated with cross-functional research teams and HSE Ireland to analyze 10 years of VTEC transmission data, uncovering critical patterns that directly informed public health strategies and interventions.• Conducted extensive exploratory data analysis (EDA) and data mining, employing robust validation techniques to enhance data integrity, which significantly improved the reliability of research findings.• Developed and structured a comprehensive SQL database integrating over 80 data sources, streamlining access and accelerating ongoing research efforts.• Created dynamic, interactive dashboards using Tableau that transformed complex data into clear visual narratives, driving stakeholder engagement and facilitating informed policy decisions.• Utilized advanced statistical analysis techniques, including regression modeling and hypothesis testing, to derive actionable insights from data trends. Show less

• 

  Careervira

  Apr 2023 - now

  Data Scientist

  • Spearhead the development of innovative recommendation systems, achieving a 32% increase in accuracy, which significantly boosted user engagement and satisfaction.• Analyzing user activity feedback to refine algorithms, resulting in an average 29% increase in user retention, showcasing a strong commitment to enhancing user experience.• Implementing ETL processes for seamless data integration, optimizing overall data architecture efficiency and ensuring accurate reporting capabilities.• Created interactive dashboards that improved data accessibility, reducing retrieval time by 45% and empowering stakeholders with actionable insights.• Engaging with cutting-edge research in product cataloging and NLP, applying advanced techniques to enhance system capabilities and maintain a competitive edge in the EdTech sector. Show less