SIDDHARTH MANI

Boston, MA 617-***-**** adl82z@r.postjobfree.com LinkedIn GitHub

EDUCATION

Northeastern University Boston, MA

Master’s, Analytics (Statistical Modelling) – GPA:3.89 Sep 2019 - Apr 2021

Manipal University Jaipur Jaipur, India

Bachelor of Technology, Computer Science Aug 2012 - Jul 2016 TECHNICAL

SKILLS AND COMPETENCIES

Programming Languages: Python, R, SQL, PySpark

Tools: RStudio, RShiny, Jupyter NB, Google Colab, Databricks, MySQL, Hive, AWS, JSON

Analytics and ML: Data Mining, EDA, NLP, Predictive Modelling (Regression, Classification and Clustering), Descriptive Analytics (Hypothesis & AB testing, ANOVA, Chi-Sq), PCA, Regularization, NumPy, Pandas, Scikitlearn, Matplotlib, TensorFlow, Keras, NLTK, Spacy, Google Analytics

Database and BI: MS SQL Server, MySQL, MongoDB, PowerBI, Tableau, Advanced Excel (Pivot Table, VLookup)

Techniques: Web scrapping, ETL, Big Data (Spark, Hadoop), Time-Series Analysis, Requirement Gathering

PROFESSIONAL EXPERIENCE

Indigo Airlines Gurgaon, India

Data Analyst (Operations) Apr 2018 - Aug 2019

Minimized delays in the flight network by building an automated routine using SQL and Python to draw insights on flight performance by analyzing key metrics such as On-Time Performance and On-Time Turnaround

Executed SQL queries on Python IDE to extract data from MySQL database and performed data cleaning and descriptive analytics in Python to identify the most influential factors causing delays

Improved On-Time Performance of base flights by 11.5% and overall daily performance by 6% by developing 2 dashboards in Tableau for functional reporting, enabling executive actions

Ernst and Young Gurgaon, India

Consultant (Risk Advisory) – Contract Dec 2017 - Feb 2018

Analyzed large volume of data and assessed account-level fraud by reconciling Journal Entry data to Trial Balance files which lead to catching 2% fraudulent transactions

Utilized MS Excel (Vlookup/Pivot table) to filter and clean data by reviewing reports and performance indicators

Validated and generated reports using Audit Command Language and Global Analytical Tool

Bits and Byte IT Consulting Bangalore, India

Associate Sales Manager, (IT) May 2016 - May 2017

Analyzed sales data using SQL by obtaining data from multiple tables in MySQL Server and track KPIs such as sales pipeline, orders and monthly sales

Prepared PowerBI dashboard to monitor sales KPIs to help management interpret how the sales team is tracking against goals

Boosted company sales by over 12% by analyzing category and geographical area performance

ACADEMIC PROJECTS

Experiential Project sponsored by Sustainable Apparel Coalition (SAC) (R, Tableau)

Carried out sentiment analysis to determine why customers unsubscribed from SAC’s social media channels with over 100 marketing lists containing multiple customers

Managed a team of 5 to examine performance, advertising efforts, key KPIs via the KPI dashboard

Data-Driven Story of Airbnb, Northeastern University (R)

Predicted the rental value of New York City Airbnb by conducting data cleansing, exploratory data analysis and implementing various machine learning algorithm while identifying important features through regularization

Achieved a Mean Absolute Error Percentage of 14% through Gradient Boosting algorithm

Hospital Readmission for Diabetic Patients, Northeastern University (Python)

Predicted hospital readmission for patients through exploratory analysis, feature engineering, feature selection and machine learning algorithms. Evaluated various model performance by comparing recall score on test data

Gradient boosting classifier with optimized hyperparameter tuning performed best with a recall score of 58%

COMMUNITY SERVICE AND VOLUNTEER EXPERIENCE

Led a team of 10 people in an NGO to help enhance the quality of education in Indian village schools and focus on personal and social qualities among children through extracurricular activities

Contact this candidate