Devarsh Shah

adm5u1@r.postjobfree.com 516-***-**** LinkedIn

EDUCATION

Northeastern University Boston, MA

Master of Science / Operations Research Sep 2019 – Apr 2021 Coursework: Probability and Statistics, Database Management, Data Mining, Project Management Kadi Sarva Vishwavidyalaya Gandhinagar, India

Bachelor of Engineering / Mechanical Engineering Sep 2014 – Apr 2018 WORK EXPERIENCE

Shah Bhogilal Jethalal & Bros. Santej, India

Data Analyst May 2018 – July 2019

● Automated the Demand Planning model from Excel Macros to Python and visualized demand forecasting Models in Tableau

● Automated old marketing reporting mechanism (Excel sheets) to dynamic Power BI Dashboards for presenting KPI's to marketing team, saving 600+ effort hours of manual report generation

● Collaborated with Engineering and Product Management teams to test the hypothesis that variance in density affect pellet ignition by analyzing test data pulled from SQL Server decreasing failure rate by ~70%

● Evaluated aggregated sales data in SQL and recognized high usage and high value items which generated 80% of sales, optimized their placement relative to dispatch area and fill rate frequency, reducing inventory carrying cost by ~25%

● Analyzed nationwide supply orders by aggregating and cleaning databases having over 400,000 entries totaling over 10M USD in inventory to provide backlog of mismatched invoices and payment schedules Supply Chain Analyst Intern Jan 2018 – April 2018

● Identified bottlenecks in material handling & warehouse operations and reduced lead time by 50% by developing Value Stream Map in MS Visio

● Customized an automated Excel tool with PivotTables to monitor sales trends which led to saving 250+ effort hours

● Developed and implemented supplier score cards to evaluate supplier performance based on critical selection metrics

● Appointed as the contact person for Digital Infrastructure Redevelopment and Data Migration to local ERP Systems ACADEMIC PROJECTS

Project Manager for development of Aerosol Fire Extinguisher Jan 2021 – Apr 2021

● Formulated project charter by using tools like Gantt, WBS, RACI, SWOT Analysis using MS Project to organize workflow

● Conducted budget estimation calculate net cash flow, operational costs, payback period for a $700 Aerosol extinguisher Database Management in Aviation Supply Chain Sep 2020 – Dec 2020

● Designed secure enterprise database model in Oracle with dedicated database user created for each new customer, with restricted access to Tables, Procedures, and custom Views using User Roles and Synonyms

● Normalized the database to 3NF, Designed an ER model and translated the model to relational schema

● Developed Procedures, Triggers, Views, Indexes, and Packages, to automatically execute Database Transactions Radiation Therapy Optimization for Cancer Treatment Sep 2020 – Dec 2020

● Developed AMPL code using CPLEX solver with multiple objective optimization model with 126 beams

● Optimized radiation dosage by changing model parameters with engineered approaches reducing dosages by ~10% / patient Taiwan Credit Default Jan 2020 – Apr 2020

● Developed a model to estimate the probability of default of credit card payment based on 30,000 past records and 24 predictor variables of financial institute of Taiwan using R

● Compared predictive accuracy of different Machine learning algorithms; kNN, Classification Trees, Naïve Bayes and Logistic Regression by visualizing them on Lift Charts and Scatter plots and generating error rates LEADERSHIP EXPERIENCE

National Cadet Corps. Gandhinagar, India

President (Student Chapter) Aug 2015 – Apr 2018

● Spearheaded Blood Donation Camps, Cleanliness Drives, Seminars and supported Senior Leadership in event management

● Supervised 235 Cadets to attempt World Record of Biggest Yoga Chain held on World Yoga Day 2016 at GMDC TECHNICAL SKILLS

● Database Systems: Oracle (PL/SQL), Hive, MSSQL Server (T-SQL), PostgresSQL, MySQL

● ML Packages: R(Caret, dplyr, Tidyverse, ggplot), Python(Scikit-Learn, statsmodel, NumPy, Pandas, Matplotlib, Seaborn)

● Business Intelligence: SSRS, Tableau, Power BI, Looker, QlikSense

● Project Management: Agile Methodologies, Jira, MS Project

● Miscellaneous: Advanced Excel (VLOOKUP, VBA, macros, PivotTables), MS Visio, SAP, ERP

Contact this candidate