Close

Prerak

Patel


Introduction


Resume


Linkedin

About Me



  • Seasoned business analyst, with 4+ years of experience in data analytics and business intelligence.
  • Competencies:
  • Business Analytics (A/B Testing, Time Series), Machine Learning (Regression, CARTs, Deep Learning), Data Management (ETL, Wrangling), Data Visualization, Predictive & Prescriptive Analytics, Data Modeling, Cloud Computing, Product Development, Project Management (Agile) and Supply-Chain Analytics.
  • aCAP (Associate Certified Analytics Professional) – December 2021 Candidate.


  • Experience

    Undisclosed Multinational Lodging Partner

    Graduate Analytics Consultant

    • Deployed hyper-tuned demand forecasting models (including SARIMA, Prophet & bi-directional LSTM), using parallelization on Bell Cluster, to improve 48-hour booking window prediction accuracy by ~18%.
    • Implemented Gurobi Optimization of short-term dynamic pricing-policy to maximize projected revenue by ~9%.

    Concept Petro-Chem Pvt. Ltd.

    Business Analyst

    • Devised a 3-step asset management system – predict performance, incorporate end-of-life/failure criteria, track actualvs-predicted performance – that helped to reduce the maintenance cost by ~9% and the downtime by ~11%.
    • Revised the demand forecasting models using Python, in the wake of reformed GST tax regime, with a MAPE of ~13%.
    • Conducted stochastic market-entry analysis using @RISK, for LNG purification, with an expected profit of ~$ 0.8M.
    • Formulated demand-pooling & segmented-pricing strategy amidst furnace-oil crisis, due to IMO’s Sulphur Limit.
    • Modeled Margin-Variance analysis, using Excel simplex solver, to identify and minimize ~2% profit leakage.
    • Led Systems-Analysis and IT design for successful adoption of ZOHO CRM (Customer Relationship Management).

    Reliance Naval and Engineering Limited

    Graduate Engineer Trainee

    • Achieved 6 project milestones and 2 invoice milestones, with a cumulative value of ~$ 0.6M.
    • Assisted project management team, using MS Project, to reduce cost-overruns by ~5% and time-overruns by ~11%.

    Education

    Purdue University

    Indiana, USA

    January 2021 - December 2021

    Master of Science in Business Analytics & Information Management

    Graduate Teaching Assistant: Database Management Systems

    Vice President: Krannert Energy Club

    Relevant Courseworks:

    • Advanced Business Analytics
    • Unstructured Data Analysis
    • Data Mining and Machine Learning
    • Python and R programming
    • Database Management
    • IT Project Management

    Pandit Deendayal Petroleum University

    Gujarat, India

    May 2012 - June 2016

    Bachelor of Technology in Petroleum Engineering

    Projects


    Espoir - Mental Health App For Workplace

    Developed a web-platform, using HTML, CSS, Python, Git & Tableau, to calculate and access mental health indicators at individual as well as organization levels (Winner - ECS Hackathon).

    View Espoir App

    View Project

    YouTrends - Popularity Prediction App For YouTubers

    Built an R-based interactive webapp to showcase descriptive & predictive analytics for youtubers to gauge likely popularity of a video using RStudio’s ShinyApp package (Rank # 2).

    View YouTrends App

    View Project

    Authenticating Categorization of Sales Advertisements

    Categorized Craigslist’s sales ads into spam / non-spam, based upon category & sub-category listed, with NLP and Image Processing using Scrapy, RNN and CNN models.

    View Project

    Bitcoin Trends Prediction using Twitter Sentiment Analysis and Deep Learning

    Conducted Sentiment Analysis of BTC (at hourly basis), using BeautifulSoup, Textblob and Vader, and translating it into an actionable insight for trading strategy using LSTM.

    View Project
    View More Projects

    Mortgage Survival Analysis

    Applied R based survival analysis for predicting event-time and event-probabilty of default on mortgages.

    View Project

    Peer To Peer Loan Classification

    Deployed supervised learning methods, like XGBoost and ANN, to identify bad loans.

    View Project

    Public Library Database Management System

    Deployed DDL & DML to design a DBMS for a public library using MySQL.

    View Project

    Skills

    • Business Analytics
    • Machine Learning
    • Statistical Modeling
    • Data Mining
    • Data Visualization
    • Predictive Analytics
    • Prescriptive Analytics
    • Spreadsheet Modeling
    • Time Series Analysis
    • Cloud Computing

    Tools

    Certificates

    • Tableau Desktop Specialist
    • Oracle Database SQL
    • AWS Cloud Practitioner
    • ML Scientist with Python
    • Data Scientist with R
    • IBM Data Science Professional
    • Applied Data Science Specialization