Sanchit Sansanwal

I am Sanchit Sansanwal, a motivated BBA student at Trinity Institute of Professional Studies, aspiring Data Analyst with practical experience in data preprocessing, exploratory data analysis (EDA), and visualization through an ongoing analytics project. Proficient in Python (Pandas, NumPy), Excel, SQL, and data visualization techniques to uncover patterns and insights from large datasets. Passionate about using data-driven approaches to solve business problems and support strategic decision making.

APL Logistics Delivery Performance & Profitability Analysis
Python, SQL, Power BI

• Analyzed a global logistics dataset containing 180K+ shipment records and 40 operational variables to evaluate supply chain performance and delivery efficiency.
• Performed data cleaning and feature engineering using Python (pandas, numpy) to create analytical variables such as Delivery Delay, Late Delivery Indicator, Profit Flag, and Shipping Efficiency.
• Identified key operational issues including 57% late deliveries, 18.7% loss-making orders, and 10.7% high-risk orders (late + loss).

Currently Developing

• A SQL database using SQLite to perform structured queries and extract business KPIs for logistics performance evaluation.
• A dataset for interactive business intelligence dashboards in Microsoft Power BI to visualize delivery risk, regional performance, and profitability insights.