Data Analyst
CurrentAutomation: I created automation for analytical tasks such as accessing SQL data via R for many reports, generating contract data, and sending automated email notifications. This improved efficiency provided up-to-date reports, and ensured data security.Market Intelligence Reports: I automated market intelligence reports using R, SQL, and RMarkdown for generating pdf outputs saving time and increasing productivity. Reports now include visually engaging charts, tables, and qualitative insights for decision-making.Contract Pricing Track & Price Updates: I automated data sets for contract information visibility in MS Dynamics AX. Automated emails with spend summaries were sent to team members, enhancing contract management and spending control.Lyons R Package: I developed an R package (lyons) to streamline analytical tasks, saving time and enhancing productivity. The package empowered tackling complex tasks like normalizing vendor names and units of measure.Machine Learning Predictions: I used historical data along with supporting data and machine learning (Random Forest, XGBoost, MLP, LSTM, CNN) to predict pricing for the following year, optimizing pricing strategies.Categorization: I introduced an automated approach to categorization, achieving 92% accuracy using NLP techniques (Word2Vec, Logistic Regression, Linear SVM, BERT, RoBERTa) for item categorization.Consumption Tracker & Quantity Analysis: I created a comprehensive data set to track inventory consumption and estimate run-out dates. Predictions helped avoid shortages and optimize inventory management.RFP & Jaggaer - Advanced Sourcing Optimizer: I automated data preparation for RFPs, improving efficiency and decision-making. An RMarkdown-based report provided actionable insights for vendor selection.
