Data Cleansing and Business Insights

Transforming raw business data into actionable insights

Technologies: Microsoft Excel, Macros, Pivot Tables, Charts

Coffee Shop Sales and Trends Analysis

Transforming sales data into actionable insights for business growth.

Technologies: Microsoft Excel, Pivot Tables, Charts, Descriptive Statistics

Interactive Business Dashboards

Uncovering trends and enhancing decision-making through advanced dashboards.

Technologies: Microsoft Excel, Power Query, Power Pivot, Pivot Tables, and Charts

Optimizing Café Operations

Maximizing efficiency through optimization models for profitability and resource utilization.

Tools - Microsoft Excel with Solver Add-In Advanced Macros and VBA

Linear Programming Techniques

Form Controls, and Dynamic Excel Features

Monte Carlo Cost and Investment Analysis

Leveraging probabilistic modeling to guide construction cost estimation and strategic investment allocation.

Technologies: Microsoft Excel, Macros, Conditional Formatting

Predictive Analytics for Healthcare Claims Processing

Leveraging data science to optimize claim approvals and reduce financial unpredictability in healthcare systems.

Technologies: Random Forest, SARIMA, Logistic Regression, Python, Pandas, NumPy, Scikit-learn, Data preprocessing, and visualization

The Ethical Implications of AI

Exploring innovation, responsibility, and the balance of ethics in AI development.

Technologies: Research Literature Analysis, Natural Language Processing (NLP) Models, Big Data Analytics

Social and Ethical Impacts of Big Data

Exploring the balance between innovation and responsibility in data systems.

Technologies: Case Studies (e.g., Aadhaar System), Articles and Research Papers, Ethical and Social Frameworks

Linear Algebra and K-Means Clustering

Exploring the mathematical foundations of machine learning algorithms.

Technologies: Linear Algebra (eigenvectors, matrix operations), Python (Numpy library), K-Means Algorithm

Portfolio Optimization and Efficient Frontier

Analyzing returns, risks, and the efficient frontier using a two-stock portfolio model.

Technologies: Microsoft Excel for calculations and visualizations, Portfolio theory concepts including average return, standard deviation, and correlation, Efficient frontier and minimum variance portfolio analysis.

2012 Benghazi Attacks

Analysis and Key Learnings.

Technologies: Investigative Matrix, Scenario Building, Hypothesis Generation and Testing, Intelligence Memoranda and Indicators Analysis

Optimization Models and Decision Analysis

Solving real-world problems using decision analysis and optimization models.

Technologies: Microsoft Excel, Solver Add-In, Optimization Techniques

Demand Forecasting Analysis

Utilizing advanced forecasting techniques to optimize demand predictions.

Technologies: Microsoft Excel, Statistical Analysis Techniques, Exponential Smoothing Models, Data Visualization

Wine Classification with Multi-layer Perceptron (MLP)

Classifying wine types using a custom-built neural network model.

Technologies: Python, NumPy, Pandas, Jupyter Notebook

Breast Cancer Classification with Multi-layer Perceptron (MLP)

Using neural networks to classify tumors as malignant or benign.

Technologies: Python, Sklearn, NumPy, Pandas, Matplotlib

Deep Learning for Multi-Class Classification Using CIFAR-10

Designing and implementing multiple DNN architectures to classify CIFAR-10 dataset images into 10 classes.

Technologies: Python, Keras, TensorFlow, Jupyter Notebook

Sentiment Analysis Using Logistic Regression

Classifying IMDb movie reviews as positive or negative using a logistic regression model.

Technologies: Python, Scikit-learn, NLTK, Pandas, NumPy, Matplotlib, Seaborn

Predicting Admission Chances with Machine Learning

Building machine learning models to predict the probability of university admission based on key metrics like GRE, TOEFL scores, and CGPA.

Technologies: Python, Scikit-learn, Pandas, NumPy, Matplotlib, Seaborn

ITC Ltd. Strategy Analysis

A comprehensive strategic report analyzing ITC Ltd.'s competitive positioning and growth strategies.

Technologies: Porter’s Five Forces, STEEP Analysis, SWOT Analysis, Microsoft Excel (Data Visualization)

Performance Analytics: Data Extraction and Scatter Plot Analysis

Extracted structured data from HTML pages and visualized variable correlations using scatter plots with linear regression.

Technologies: Python, Pandas, BeautifulSoup (HTML Parsing), Matplotlib, Jupyter Notebook

Data Analysis: Empirical Distributions and Visualizations

Analyzed performance data to generate probability distributions and visualizations highlighting patterns and trends.

Technologies: Python, Pandas, BeautifulSoup (HTML Parsing), Matplotlib, Jupyter Notebook

Final Report: Data Collection, Parsing, and Analysis

A comprehensive project combining web scraping, parsing, and visualization to analyze "performance" data.

Technologies: Python, Pandas, BeautifulSoup (HTML Parsing), Matplotlib, Jupyter Notebook

MapReduce Algorithm for Word Counting on Fraudulent Email Corpus

Analyzing fraudulent emails using the MapReduce algorithm to extract key linguistic patterns.

Technologies: Python, Scikit-learn, Pandas, Jupyter Notebook

Locality-Sensitive Hashing for Document Similarity Detection

Exploring efficient methods to detect document similarities using Locality-Sensitive Hashing (LSH).

Technologies: Python, Scikit-learn, Pandas, Matplotlib, Numpy

Mining Frequent Itemsets with Apriori and PCY Algorithms

Uncovering customer purchasing patterns through market basket analysis with Python.

Technologies: Python, Scikit-learn, Pandas, Matplotlib, Numpy, MLxtend, Seaborn

Movie Recommendation System

Building a recommendation system using user-based collaborative filtering with k-Nearest Neighbors (KNN).

Technologies: Python, Scikit-learn, Pandas, Matplotlib, Numpy, Seaborn

Titanic Survival Prediction

Using machine learning models to predict survival probabilities of Titanic passengers.

Technologies: R Programming, Libraries: rpart, e1071, class, dplyr, ggplot2