Aditya Joshi

Working on Market Mix Modelling for a CPG client. Involved in pipeline creation, modeling, finalizing results and presenting Insights Decks and Scorecards for clients. Worked as Solutioning Associate performing Industry and client research, POV creation and solution designing for client acquisition and account growth.

Built Regression models which can correctly predict the estimated time of arrival of parts ordered by dealers or customers for our Automobile Industry client. Created SQL pipeline to store a large amount of data into a data lake from multiple parent tables. Improved ETA results as compared to legacy code by increasing predictions of on time delivery results days. Built result matrices to display percentage of ETA calculated as early and delayed by 1 to 10 days. Built Pipeline code to deploy our model in production so that it can generate results in real time. Visualized results and provided insights to the customers using Power BI. Migrated on-premise pipeline to AWS and migration of data from greenplum data lake to Snowflake. Wafer fault detection project to identify defected wafers using sensor data. Developed Clustering model to group data points into multiple clusters and build individual Classification models for each cluster to get most optimum results. POC to automate Ticket and Incident Classification into multiple categories based on the description provided in the particular ticket or incident.

Developed web applications for automobile Industry clients. One Dealer facing and one for DSP. Developed Each application with 2 views, admin access and general access. Designed the entire database schema and project architecture from scratch by understanding the business and its requirements. Worked on dynamic report generation for clients to generate DSP and Dealer activity reports.