Portfolio

My Projects

Data Science & Analytics

End-to-End Sales Data Analytics & BI Dashboard

Developed a robust analytics dashboard to evaluate sales and marketing performance across various global regions and product lines. Cleaned and structured unstructured sales logs, stored them in optimized database schemata, and built user-friendly visualization layers.

Key Tasks: Handled full data ingestion, cleaning, transformation, and Exploratory Data Analysis (EDA). Optimized relational tables and designed high-performing SQL queries. Drafted interactive Power BI dashboards highlighting regional sales KPIs.
Outcome: Delivered actionable, real-time insights on revenue trends, top-selling products, and regional sales distribution, aiding business management in planning campaigns.
Python Pandas MySQL MS Excel Power BI
Software Development

Online Bill Payment System

Built an electronic billing portal that manages vendor-to-customer billing cycles. Ingests electronic invoices from utility, rental, and credit card vendors and dispatches scheduled email alerts to customers. Supports flexible user accounts and automated bank withdrawals.

Key Tasks: Developed business logic layers using Java Servlets. Integrated Redis caching to track active transaction sessions. Structured database tables in PostgreSQL to log transactional history.
Outcome: Established a secure, high-concurrency payment engine charging monthly administrative fees and handling high transactional volume securely.
Java Servlets HTML JavaScript Bootstrap CSS PostgreSQL Redis
Software Development

GEOMINDER - Location Aware To-Dos

An innovative mobile-responsive task application that structures lists and triggers user notifications based on geographical coordinates. Analyzes active GPS coordinates to remind users of tasks relevant only to their current location (e.g. suggesting domestic chores while at home).

Key Tasks: Engineered location parsing logic and servlet routing. Designed structured JSON message exchanges between the front-end browser and back-end servlet context.
Outcome: Improved client task completion rates and timeliness by reducing location-irrelevant notification clutter.
Java Servlets JSON HTML5 Geolocation API
Big Data Pipeline

Big Data Processing & Analytics (IBM Stack)

Designed and deployed a distributed processing architecture to manage, transform, and analyze multi-gigabyte datasets using enterprise Apache Hadoop systems.

Key Tasks: Configured ingestion channels using Sqoop to bridge databases and HDFS storage. Structured analytics tables inside Apache Hive. Created Python data validation validation checking scripts.
Outcome: Enabled scalable distributed data analysis workflows and significantly decreased batch processing times.
Hadoop Sqoop Hive IBM InfoSphere IBM BigInsights Python
Data Science & Analytics

Customer Segmentation & Behavior Analysis

Conducted quantitative data mining on user behavior logs to identify distinct user personas and behavioral patterns.

Key Tasks: Cleaned historical user activity tables. Performed exploratory analysis, correlation mapping, and cluster statistics inside IBM Watson Studio notebooks.
Outcome: Identified discrete customer groups which enabled targeted marketing strategies and product adjustments.
Python NumPy Pandas IBM Watson Studio Matplotlib
Big Data Pipeline

Data Engineering Pipeline (MySQL & MongoDB)

Created a hybrid ETL data integration pipeline combining structured SQL databases with semi-structured document databases.

Key Tasks: Designed database schemas for structured columns (MySQL) and flexible JSON collections (MongoDB). Wrote Python synchronization scripts to maintain consistency across tables.
Outcome: Delivered a highly reliable data foundation supporting structured queries and unstructured document tracking in parallel.
MySQL MongoDB Python ETL Scripting
Cloud & DevOps

Cloud-Based Analytics Solution (IBM Cloud)

Deployed an enterprise reporting workspace hosted entirely in the cloud, utilizing cloud servers and cloud-native databases.

Key Tasks: Provisioned cloud resource nodes and secured database network ports. Integrated live database structures directly with IBM Cognos for BI reporting.
Outcome: Provided a secure, highly scalable analytics workspace with centralized, real-time dashboard reporting.
IBM Cloud Python MySQL IBM Cognos
Cloud & DevOps

Containerized Data Analytics Application

Built a modern, containerized deployment pipeline for a Python-based data mining framework to guarantee seamless execution across development and production servers.

Key Tasks: Wrote Dockerfiles to build light Python runtime images. Created Kubernetes configuration YAMLs (deployments, services) to handle scaling and load balancing.
Outcome: Achieved portable, fault-tolerant analytics service deployment, reducing environmental configuration errors to zero.
Python Docker Kubernetes CI/CD Pipelines
Data Science & Analytics

Uber Pickups Demand Analysis (SQL)

Analyzed millions of Uber ride pickups to determine ride demand dynamics across major metropolitan coordinate zones and time intervals.

Key Tasks: Ingested pickup datasets into optimized relational indexing structures. Developed analytical SQL queries utilizing window functions, datetime grouping, and joins.
Outcome: Delivered crucial peak-hour demand and coordinate heatmaps, enabling operational improvements and driver allocation strategies.
SQL MySQL RDBMS Data Aggregation