Lead Data Analyst
Graybar Electric Company | December 2019 - Present
• Automated collection of 25000+ product pricing from competitors’ websites on Google Cloud and Microsoft Azure by web scraping HTML and JSON data to run every week • Devised a model to scrape data by parallel processing using threading and queuing decreasing the time taken by 75% and validated data sets with statistical tools and analysis • Deployed interactive dashboards with Tableau Online and Power BI (on SharePoint) which displayed interpreted data queried using Google BigQuery for faster decision making and price analysis • Preprocessed email data on Python using Natural Language package NLTK for transforming datasets into an understandable format
Graybar Electric Company | May 2019 - December 2019
• Directed team of 3 to develop mapping visualization tool by utilizing Google Map APIs that allowed warehouse executives to compare normal vs optimized routes for better assessment of route optimization algorithms • Product Development - Engineered prototype to provide strategic direction for scenario planning of various branches in Graybar using a stratification model based on productivity and profitability KPIs • Delivered presentations to an audience of 25+ to demonstrate the prototype which had an impact on staffing across Graybar branches • Automated data gathering and cleaning process of complex datasets extracted from HANA database for data analysis and increased the data quality by 13% by using Pandas and Numpy packages
Lead Data Analyst
Illinois Geometry Lab | January 2019 - May 2019
• Headed team of 4 to collaborate with Healthcare Department of Urbana-Champaign and delivered presentations on predicting inspection scores of restaurants from data collected for over 19000 restaurants in Champaign county • Implemented predictive models like linear regression and 2-layered Neural Network algorithms for inspection score prediction with mean square error of 14.93 and 6.79 respectively
University of Illinois at Urbana–Champaign (UIUC), Champaign
Industrial Engineering, MS | August 2018 - December 2019
Relevant Coursework: Deep Learning, Stats of Big Data and Clustering, Algorithms for Data Analytics, Network Analysis of Systems, Supply Chain Management and Logistics, Operations Research Models of Manufacturing Systems
PES College of Engineering, Mandya, India
Mechanical Engineering, BE | August 2013 - June 2017
User has not solved any challenges yet.
User has not participated in any contests yet.
User doesn't have any discussions yet.