Prerak Shah Email & Phone Number

Menlo Park, Ca, Us

Investigated EDI data points from various suppliers/vendors and performed risk analysis for Meta stakeholders.Developed data pipelines to streamline commodity pricing across all networks within Meta.Created data ingestion, validation and reporting for transnational data from Order Management systemConsolidated inventory by doing netting analysis leading to $1.5M worth of savings every month.Evaluated inventory aging across di erent sites and developed business reports leading to reduction of inventory by 40%.Produced Forecast signals for suppliers with improved lead-times, helping them achieve 90% target deliveries.Recommended python and sql scripts to automate data management and quality checks saving approx 20 hours of human e orts.Designed business allocation models for di erent services/vendors using time-series forecast models.Designed and developed Vendor Scorecards with more than 7 KPIs for half-yearly business reviewsStreamlined Open-Order Reports from more than 30+ Vendors and developed dashboard to track the shipping info by Sites.Coordinated supplier communications using data-driven KPIs.Created and maintained Supplier Health Dashboards, Commodity pricing trends and Inventory management dashboards for stakeholders across Infrastructure teamDesigned end-to-end pipeline for Dashboards and reports for 7 Integrated Product Teams across 43 equipment categories for more than 50+ Suppliers.

Boston, Massachusetts, Us

The Dekel Lab conducts studies using physiological, psychological, and neuroimaging tools to investigate PTSD and postpartum depression in order to improve the mental health of mothers and their infant(s).As a Research Analyst, I was involved with 3 main tasks:1. Perform Statistical Models on the PTSD and Suicide Ideation data before and during COVID period2. Apply Machine Learning Models such as Random Forest, XGBoost algorithm to predict the symptom3. Prepare and clean data using SPSS and create visualizations for the research paper

Boston, Ma, Us

Boston, Ma, Us

Boutique Employability is an outcome of synchronizing PERSONAL STRATEGIES of multidimensional talents with ORGANIZATIONAL STRATEGIES of companies of their choice through the BE-EDGE sequence of actions. It lets multi-dimensional talents “Making Your Case" for "Shaping Your Space" in the industry.My Role:Create Survey's and link to the LMS platformsCollect, Transform and Manage incoming data through different platforms Create and Manage Dashboards Create Data PipelinesProvide valuable insights for a group as well as individuallyStrategy planning for Social-media campaign and E-mail marketing

Rockville, Maryland, Us

Goodwill Industries International, Inc. is an internationally recognized leading social enterprise of 157 independent, community-based organizations in the United States and Canada as well as a presence in 12 other countries. My Role: - Review and analyze Goodwill member business and mission services data to support the delivery of analytic insights through the development of new Tableau reports and dashboards. - Collaborate with GII business leaders to understand internal reporting needs, analyze data, use measurement techniques, identify KPIs, and build reports/dashboards to address business questions. - Build Data Pipelines and flows for data modeling and visualizations - Apply Statistical Data Models using SPSS to analyze trends - Optimize the Dashboards and flows to meet the requirementsAchievements:• Designed ETL dataflows in Tableau Prep to integrate data from various sources and generated executive-level dashboards and reports based on financial KPIs using SQL, Tableau, and Python for strategic and tactical decision making.• Created SQL scripts for daily extracts, ad-hoc requests, reporting, and analyzing large datasets using stored procedures, transactions, triggers, views, and indexes.

• Developed Machine learning models to detect patterns from customer-delivery data to improve delivery by 30% • Integrated Elasticsearch and Kibana as Analytics engine using ETL with data transformation• Index mapping by inserting about 250k data into Elasticsearch• Developed database for localities and pin codes of India by mining data from heterogeneous sources

Mumbai, Maharashtra , In

• Worked on a Chatbot to give assistance for major stock-market trends• Used NLP techniques to automate the process of matching comments on stocks w.r.t to company • An improvement of 25% over manual classification and matching• Performed Exploratory analysis on AAPL, S&P500 stocks into detail reports that gave key insights• Performed Hypothesis testing to prove that KPI’s for stocks and portfolios peak during seasonal events

Mumbai, Maharashtra, In

* Worked on SQL for CRUD operations on databases * Created website in PHP for our client named United Gulf Safety* Created Admin panel, to update and notify of changes in the website* Using Kibana Dashboard to analyze activities on the website

Master'S Degree, Data Analytics

Bachelor Of Engineering (Be), Computer Engineering

Diploma, Computer Engineering

Ssc