Amit Mishra

• Ensured data integrity by implementing rigorous validation processes and protocols within the team.
• Trained junior team members on essential research techniques, fostering a culture of continuous learning within the department.
• Supported company growth by delivering accurate, actionable insights derived from extensive dataset evaluations.
• Enhanced data accuracy by conducting thorough research and cross-referencing multiple sources.
• Collaborated with CXOs to define technical requirements and develop innovative solutions for complex problems.
• Championed data-driven decision-making by consistently providing accurate, timely and relevant insights to drive business growth.

Intership Project

• [TCS iON RIO-125: Forecasting System - Project Demand of Products at a Retail Outlet Based on Historical Data], [TCSiON], Completed [2024]
• Mentor: Debashis Roy
• Institute: Amity Online
• Duration: March 25, 2024 - June 25, 2024
• Total Effort: 120 hours
• Environment: Google Colab
• Tools Used: Python, ARIMA, SARIMA

Between study TCS iON Project

Project 2

• Retail Analytics Project – Supermarket Groceries
  Analyzed sales data for a Tamil Nadu-based supermarket chain to support national expansion. Identified 10 key KPIs, created pivot tables and charts for sales and profit analysis, developed an interactive dashboard, and formulated a linear programming model to optimize product-wise profit.
• Tools Used: Excel, Pivot Tables, Data Visualization, Linear Programming

Project 3

• COVID-19 Data Modeling and Visualization
  Tools: R, Shiny, Statistical Analysis
  Analyzed and visualized COVID-19 data using R. Preprocessed a dataset of 1,085 entries, conducted statistical analysis and t-tests on age and gender mortality, developed a predictive model for survival rates, and created an interactive dashboard using Shiny.

Project 4

• Airbnb NYC Data Modeling and Visualization
  Tools: R, Data Preprocessing, EDA
  Analyzed the Airbnb NYC 2019 dataset using R. Preprocessed data by handling missing values, duplicates, and outliers. Conducted EDA to examine host activity, area traffic, and pricing trends. Created visualizations for host clusters, room type preferences, and neighborhood pricing.

Project 5

• Logistic Regression Model for Predicting Customer Default
  Tools: Python, Logistic Regression, Data Preprocessing, AUC
  Developed a logistic regression model to predict customer default within 12 months. Performed univariate and bivariate analysis, handled missing data, created derived variables, and split the data for model development and validation. Evaluated model performance using AUC and assessed the impact of data transformations.

Project 6

• Employee Attrition and Satisfaction Analysis
  Tools: Excel, Pivot Tables, Regression Analysis
  Analyzed employee data to generate reports on satisfaction and attrition. Converted numeric ratings to text using VLOOKUP, created pivot tables and charts for various metrics, developed an interactive dashboard, conducted What-If analysis, and performed regression analysis to identify key factors influencing attrition.

Project 7

• User Interface Design Project
  Tools: MS Office, Lucidchart, HTML5/CSS3, Web Browser
  Conducted user, task, domain, and requirements analyses to design and develop a web-based user interface. Documented the process with problem statements, goals, and methods, and delivered a responsive web interface application, overcoming design obstacles through iterative testing.

Project 8

• Evaluation of Internet Banking Interface Design
  Tools: Nielsen's Heuristics, Documentation Tools
  Evaluated the usability of a transactional banking web application using Nielsen’s heuristics. Analyzed the interface for visibility, consistency, error prevention, and other usability factors. Documented findings on time invested, efficiency, usability problems, and severity with relevant screenshots, addressing obstacles encountered during the evaluation process.