Kairav Pandya

Experience

• 

  Viva Development Strategies

  May 2019 - May 2021

  Data Analyst

  • Prepared and provided 4M rows of data using python and SQL to aid the data science team to bring out insights from data• Created performance dashboards and ad-hoc reports on Tableau to visualize times series data filtered by products for thesales team to increase sales by 22%• Performed A/B Testing and analyzed customer data, thus increasing add-to-cart conversion of products by 37%• Managed a team of 5 interns for the Summer Project on Customer Segregation using SQL, Python and AWS Show less

• 

  Technology Services University of Illinois Urbana Champaign

  Jan 2022 - Nov 2022

  Infrastructure Support Consultant
• 

  Insurance Institute for Business & Home Safety

  May 2022 - Jul 2022

  Data Engineering Intern

  Designed an ETL pipeline for storage and access of experimental sensor data for the largest non-profit research institute company in the US that simulates real life natural disasters to study effects of these perils on the safety of the houses across the US and promotes new building codes to make homes a safer place• Set up database on local SQL server after understanding the data model and developing ER diagrams for a dataset that increases at a rate of 300,000 data points per day.• Automated enterprise BI with Azure Synapse and Azure Data Factory for smooth functioning of the data flow from the sensors attached to the house to the final point of Power BI making the process 3 times more efficient and time saving• Aided senior management in strategic decision-making by creating reports and dashboards using PowerBI thereby reporting anomalies that affected product performance by 20% Show less

• 

  Gies College of Business - University of Illinois Urbana-Champaign

  May 2022 - Dec 2022

  Course Assistant

  Assisted professors over 4 courses through the summer and fall semester in the field of data visualization and data science.Completed 6 online courses on Coursera with an overall grade of 98% gaining hands-on knowledge working with tools like RStudio, Alteryx, Excel, Python, SQL and Power BIGraded assignments of around 600 students per week and single handedly managed the Q&A forum for the coursesConducted and participated in weekly meetings discussing the weekly processes with the team Show less

• 

  Caterpillar Inc.

  Aug 2022 - Mar 2024

  • Efficiently managed Product Lifecycle Framework (PLF) for 40 data entities stored in Snowflake, ensuring seamless data management• Developed and maintained code to create and update data pipelines, rigorously testing functionality across development, integration, and production environments using Python and AWS, having maintained the code repository in Azure DevOps• Designed 4 mapping documents/ feature to map dataflow through pipeline as mentioned by the solution leads using excel• Formulated and analyzed A/B tests for the eCommerce team aiding in causal inference for the sale of parts at Caterpillar• Developed advanced statistical models using python, enhancing sales forecasting accuracy 20% contributing to 15% inventory reduction• Created 10 Tableau dashboards, providing stakeholders with intuitive and real-time insights into sales performance of 10 products Show less • Developed a custom neural network system from scratch for image classification, successfully processing over 4 million machinery parts images, and achieved an accuracy rate of 96%• Led efforts in logo detection and watermark removal using advanced neural network and presented the results of the image classification system to company executives• Spearheaded the creation of an AI-powered summary bot for machinery manuals, enhancing information retrieval efficiency within the organization through large language models processing and chatbot technology reducing load on customer service by 40% Show less

  • Data Specialist

    Aug 2022 - Mar 2024

  • Digital Data Analytics Intern

    Aug 2022 - Dec 2022