Andrew Muller Email & Phone Number

San Marcos, Texas, United States

● Spearhead data science initiatives, presenting insights directly to the executive team, driving data-informed decision-making.● Produced reports and statistical analyses, addressing key business needs for directors and executives.● Enhance and maintain the nightly ETL processes for the data warehouse, reducing errors and ensuring accuracy.● Mentor and train new team members, including report authors, data engineers, and data scientists.Professional Projects:Website Search● Natural Language Processing: Developed and deployed NLP models using NLTK to preprocess and analyze product descriptions andother textual data, enabling more accurate search results.● Search Matching: Implemented TF-IDF and cosine similarity algorithms to match queries with products, increasing search accuracy.● Cross-Functional Collaboration: Partnered with software engineers and product managers to seamlessly integrate the solution into theexisting e-commerce platform, ensuring smooth deployment.● User Experience Enhancements: Designed and integrated a category search feature at the top of search results, streamlining the userjourney and increasing search efficiency.Inventory Optimization● Forecasting: Developed time series models (using Amazon Forecast, SARIMAX, and weighted averages) to predict sales, transactioncounts, and lead times for over 1 million branch-item combinations monthly.● Inventory Management: Calculated precise reorder points, safety stock levels, and average inventory values, resulting in fewerout-of-stocks and better allocation of inventory dollars● Data Infrastructure: Designed and implemented new tables, views, and procedures in the data warehouse, supporting robust inventorytracking and forecasting.● Collaboration: Partnered with experts to establish an item hierarchy, model stores, and item codes, aligning models to business needs.● Automation: Automated the forecasting, and POS system uploading process, significantly reducing error rates.

Technical Projects include:Game Review Classification and AnalysisTrain an NLP model on user-submitted video game reviews in order to classify unlabeled internet comments, then perform topic analysis based on the predicted classes. - Used Steam API to obtain labeled user reviews of various video games. - Performed lemmatizing, tf-idf, document embedding, etc. and tested to determine best processing methods. - Trained and tested classic classification models and neural networks to create the optimal model. - Created a (local) website frontend using Flask.Springfield Housing Prices AnalysisUse time series models to predict housing prices over two year by zip codes in the area of Springfield, Missouri. - Performed stationarity, seasonality, autocorrelation, and partial autocorrelation tests to determine ARIMA order. - Trained baseline ARIMA and Facebook Prophet models and computed cross-validated RMSE values. - Tuned hyperparameters via gridsearch and improved RMSE values. - Compared two-year forecasts to determine 65804 as the best zip code to invest in.Tanzanian Water Well ClassificationUsing data from Taarifa and the Tanzanian Ministry of Water to predict the functional status of water wells in Tanzania. This is an active competition on drivendata.org. - Condensed 39 independent variables to 13 categorical features, or 100 when one-hot encoded. - Trained baseline models on various model types, with a greatest accuracy of 79.30%. - Performed hyperparameter tuning on best-performing models, resulting in a greatest accuracy of 80.25%. - Retrained best model on competition test set, resulting in a competition accuracy of 81.50% (rank 1303 of 10458).

Houston, Texas, United States

- Worked on projects for large diameter threaded pipe connectors.- Created project scope and initiation documentation.- Modelled new pipe connector designs to customer requirement.- Planned and oversaw testing of pipe and connector specimens.- Produced official engineering reports based on test data.

Houston, Texas, United States

- Met with clients and management to define project bounds and goals for turbine and compressor control systems.- Performed on-site field surveys and wrote technical narratives for varied turbine and compressor systems.- Read and interpreted blueprints, technical drawings, schematics, and computer-generated reports.- Specified system components and directed product modifications with design and performance specifications.- Created CAD models and drawings using SolidWorks and AutoCAD.- Supported engineering designs through analysis and simulation using SolidWorks Simulation and ALGOR.- Developed cost estimates, procured equipment, and tracked construction progress to efficiently complete large scale projects.- Presented drawings to clients and project managers and incorporated recommended changes.- Managed design and manufacturing teams to build proprietary process equipment within cost and time constraints.- Coordinated all aspects of production, including selection of manufacturing methods, fabrication, and operation of product designs.- Wrote protocols, qualification documents, test plans, and test reports for quality assurance purposes.- Performed complex customer-witnessed component and product tests at in-house hydraulic and mechanical lab.- Hands-on experience assembling, installing, and troubleshooting pumps, valves, solenoids, servos, cylinders, pressure vessels, accumulators, and other hydraulic and mechanical devices.- Oversaw installation and maintenance of rotating equipment (pumps, compressors, turbines, etc.) and their components and control systems (hydraulic cylinders, pressure vessels, accumulators, etc.).- Troubleshooted and performed failure analyses on installations on-site at oil refineries, power plants, chemical refineries, nuclear plants, etc. and made appropriate maintenance recommendations.- Applied mathematical skills and understanding of engineering principles to design new products.

Immersive Data Science Bootcamp Program

Bachelor Of Science - Bs, Mechanical Engineering