Aayush Lingam

Experience

• 

  Selloship

  Oct 2020 - Sept 2022

  Business Analyst

  Enhancing Customer Experience and Sales Optimization for E-commerce Platform.Led a comprehensive project aimed at enhancing customer experience and optimizing sales performance on the company's e-commerce platform. The project involved in-depth data analysis, stakeholder collaboration, and implementation of strategic recommendations to drive business growth and improve customer satisfaction.Key Responsibilities:• Data Analysis and Insights• Stakeholder Engagement• Customer Experience Enhancement• Sales Optimization• Reporting and DocumentationTools and Technologies Used:• Data Analysis: SQL, Python, Excel• Data Visualization: Tableau, Power BI• Project Management: JIRA, Asana• Customer Feedback: SurveyMonkey, Zendesk• A/B Testing: Optimizely, Google AnalyticsThe project was a significant success, demonstrating the critical role of data-driven decision-making in enhancing customer experience and optimizing sales performance. Through collaborative efforts and strategic implementations, I was able to contribute to the overall growth and efficiency of Sell-O-Ship. Show less

• 

  NTPC Limited

  Oct 2021 - Oct 2021

  Internship Trainee

  During my internship at NTPC (National Thermal Power Corporation) for Industrial Training, I gained hands-on experience in the operations and management of thermal power plants. Over the course of the training, I was exposed to various aspects of power generation, including boiler operations, turbine mechanisms, and control systems. I had the opportunity to work alongside experienced engineers, participating in maintenance activities, safety drills, and performance analysis. The training provided me with a comprehensive understanding of power plant engineering, efficiency optimization, and environmental regulations. This experience not only enhanced my technical skills but also honed my problem-solving abilities and teamwork. Show less

• 

  Freelance Consultant

  Oct 2022 - now

  Freelance Consultant

  Project Title: Local Restaurant Chain: Menu Optimization• Industry: Food and Beverage• Project Overview: A local restaurant chain used data science to optimize its menu. By analyzing sales data,customer preferences, and feedback, the restaurant identified high-performing dishes and introduced newitems that aligned with customer tastes.• Key Technologies: SQL, Python, Data VisualizationProject Title: Artisan Coffee Shop: Price Optimization• Industry: Food and Beverage• Project Overview: An artisan coffee shop implemented a price optimization project to maximize revenue. Byanalyzing sales data and customer preferences, the coffee shop adjusted its pricing strategy for differentproducts and time periods.• Key Technologies: Excel, Python, Machine LearningProject Title: Local Tourism Company: Sentiment Analysis for Service Improvement• Industry: Tourism and Hospitality• Project Overview: A local tourism company used sentiment analysis to analyze customer reviews andfeedback. By identifying common themes and issues, the company made data-driven improvements to itsservices and customer experience.• Key Technologies: Natural Language Processing, Python, RProject Title: Small Logistics Company: Route Optimization• Industry: Logistics and Transportation• Project Overview: A small logistics company implemented a data science project to optimize delivery routes.By analyzing traffic patterns, delivery locations, and vehicle data, the company reduced fuel costs andimproved delivery times.• Key Technologies: Python, Geospatial Analysis, Optimization AlgorithmsProject Title: Local Health Clinic: Patient No-Show Prediction• Industry: Healthcare• Project Overview: A local health clinic used machine learning to predict patient no-shows. By analyzingappointment data and patient history, the clinic implemented reminder systems and overbooking strategiesto reduce no-show rates.• Key Technologies: Python, Logistic Regression, Power BI Show less