•> Worked with a startup on building advanced analytics for supply chain visibility and transportation management platform.
•> Implemented ArcGIS to geocode the location addresses and performed Geo-fencing to track and map the loads to their corresponding vehicles.
•> Performed data cleaning, data transformation on 600K+ rows of data.
•> Performed ETL into the Snowflake data warehouse
•> Parsed the map data source using python to extract all the data related to interstate highway rest areas. Created a dataset of 1000+ records using the data
•> Scraped data related to all the gas stations in the USA using selenium and geocoded the address using ArcGIS to get the coordinates. Created a dataset of 40000+ records using the data.
•> Access SQL database to manipulate the data, create visualization and reports to give insights about the data.
•> Improved the functionality of the product by performing UAT.
•> Participated in product development efforts