My Work
A collection of projects that combine technology with social impact
Custom Ticketing System
Developed a customized ticketing system using Asana Project Management tool that impacts 10,000+ learners annually at Tech Goes Home. Streamlined support processes and improved response times.
📊 Impact: 10,000+ learners annually
Challenge
Solution
Historical Learner Database Analysis
Analyzed historical learner database to create actionable insights for program improvement. Used Python and SQL for data processing and visualization tools for presenting findings to stakeholders.
Challenge
Years of learner data was underutilized, missing opportunities for program optimization and better outcomes.
Solution
Conducted comprehensive analysis using Python and SQL to identify trends, success factors, and areas for improvement.
Results
- ✓Identified key success factors for program completion
- ✓Informed strategic decisions for program design
- ✓Created interactive dashboards for ongoing monitoring
AI-Powered Learner Experience Analysis
Implemented OpenAI APIs to analyze learner experience feedback and generate insights. This system helps identify trends and areas for improvement in educational programs.
Challenge
Manually analyzing hundreds of learner feedback responses was time-consuming and inconsistent.
Solution
Built an AI-powered system using OpenAI APIs to automatically analyze feedback, identify sentiment, and extract key themes.
Results
- ✓Reduced analysis time by 80%
- ✓Identified emerging trends in real-time
- ✓Improved program responsiveness to learner needs
Automated Reporting System
Developed automated learner data reports for informed decision-making and better course delivery. This system provides real-time insights to instructors and administrators.
Challenge
Creating weekly reports manually consumed hours of staff time and delayed access to critical data.
Solution
Designed and implemented an automated reporting system that generates and distributes reports on schedule.
Results
- ✓Saved 100+ hours annually
- ✓Real-time access to program metrics
- ✓Improved data-driven decision making
Data Systems Optimization
Analyzed all data systems and tools used by the organization, identifying inefficiencies and implementing solutions that saved $10,000 annually in operational costs.
📊 Impact: $10,000 annual savings
Challenge
The organization was using multiple redundant tools, creating inefficiencies and unnecessary costs.
Solution
Conducted a comprehensive audit of all systems, identified redundancies, and implemented a streamlined tech stack.
Results
- ✓$10,000 in annual cost savings
- ✓Reduced system complexity by 40%
- ✓Improved staff productivity and satisfaction
Salesforce-LMS Integration
Created a near real-time reporting and integration system between Salesforce and LMS using free tools like Postman, Google Apps Script, and SF APIs. Saved $10k annually and 100 hours of manual work.
📊 Impact: $10k savings + 100 hours saved annually
Challenge
Data between Salesforce and the Learning Management System was synced manually, causing delays and errors.
Solution
Built a custom integration using Salesforce APIs, Google Apps Script, and Postman to enable near real-time data synchronization.
Results
- ✓$10,000 annual savings (avoided paid integration tools)
- ✓100+ hours of manual work eliminated annually
- ✓Near real-time data synchronization
- ✓Reduced data errors by 95%
Historical Data Analysis Dashboard
Comprehensive analysis dashboard providing deep insights into historical learner data patterns and trends. Built to inform strategic decisions and improve program outcomes.
📊 Impact: Informed strategic decisions for 5+ programs
Challenge
Years of accumulated learner data needed to be analyzed to identify patterns, success factors, and opportunities for program improvement.
Solution
Developed a comprehensive dashboard combining Python data processing with Tableau visualization to present actionable insights to stakeholders.
Results
- ✓Identified key success factors across programs
- ✓Reduced data analysis time by 70%
- ✓Enabled data-driven program design decisions
- ✓Created reusable analysis framework
AI Chatbot Assistant for Learners
Intelligent chatbot assistant powered by AI to help learners get instant answers to their questions, improving support accessibility and response times.
📊 Impact: 24/7 support for learners
Challenge
Learners needed quick answers to common questions outside of business hours, and staff was overwhelmed with repetitive queries.
Solution
Built an AI-powered chatbot using OpenAI APIs that can understand learner questions and provide accurate, helpful responses based on program documentation.
Results
- ✓Reduced support ticket volume by 40%
- ✓Provided 24/7 learner support
- ✓Improved response time to under 1 minute
- ✓Gathered insights on common learner pain points
Boston Gun Shootings Analysis Dashboard
Interactive Tableau dashboard analyzing gun violence patterns in Boston, revealing trends, demographics, and geographic hotspots. Coming from a country where gun violence is rare, this project explores a pressing issue through data.
Challenge
Solution
Top N Video Games Dashboard
Interactive Tableau dashboard analyzing video game sales, ratings, and trends across platforms and genres with dynamic Top N filtering capabilities.
Challenge
Analyzing vast amounts of video game data to identify trends in sales, ratings, and platform popularity while allowing users to dynamically explore top performers.
Solution
Built an interactive Tableau dashboard with advanced Top N filtering, allowing users to explore games by various metrics and dimensions. Implemented dynamic parameters for flexible analysis.
Results
- ✓Created dynamic Top N filtering system
- ✓Identified top-performing games across platforms
- ✓Revealed genre and platform trends
- ✓Enabled data-driven insights for gaming industry
Celebrating Halloween with Data
Interactive Tableau dashboard exploring Halloween celebration trends, spending patterns, and shopping behaviors. A data-driven look at this iconic American holiday from an international perspective.
Challenge
Coming from another country, I was curious about how Americans celebrate Halloween and what it means for spending trends. This MakeoverMonday challenge helped explore the cultural and economic impact of Halloween.
Solution
Created an interactive Tableau dashboard analyzing Halloween celebration statistics, spending patterns ($108 average per person), shopping behaviors, and candy purchasing trends (95% participation rate).
Results
- ✓Revealed 73% of people celebrated Halloween in 2023
- ✓Average spend of $108 per person
- ✓95% bought candy to mark the occasion
- ✓Identified shopping patterns across grocery stores, home decor shops, and local businesses
- ✓Gained deeper understanding of Halloween's cultural and economic impact
Company Executive Dashboard
Comprehensive Power BI dashboard providing executives with KPIs across Customers, Sales, Operations, and Finances. Features seamless navigation between focused dashboard views.
Challenge
Executives needed a unified view of company performance across multiple business areas without being overwhelmed by data.
Solution
Built an executive dashboard in Power BI with Python integration, featuring separate focused views for different business areas with seamless navigation.
Results
- ✓Consolidated 4 business areas into one tool
- ✓Reduced reporting time by 60%
- ✓Enabled data-driven executive decisions
- ✓Improved cross-functional visibility
Massachusetts Ice Cream Trail Interactive Map
Interactive Tableau dashboard mapping 100+ ice cream spots across Massachusetts, supporting local dairy farms and small businesses. Features Google ratings integration and location-based discovery.
📊 Impact: Mapped 100+ local ice cream businesses with ratings integration
Challenge
Massachusetts Office of Travel & Tourism released an Ice Cream Trail PDF featuring over 100 ice cream spots. Needed to create an accessible, interactive way to explore these locations while supporting local businesses.
Solution
Built an interactive Tableau dashboard map that extracts data from PDF documents using Python, fetches Google ratings via APIs, and links URLs with Tableau actions for seamless user experience.
Results
- ✓Mapped 100+ ice cream locations across Massachusetts
- ✓Integrated live Google ratings for each location
- ✓Created clickable links to business websites
- ✓Supported local dairy farmers and small businesses
- ✓Enhanced data visualization skills with PDF extraction and API integration
BlueBikes Boston Dashboard
Comprehensive Tableau dashboard analyzing Boston's bike-sharing system, exploring usage patterns, popular routes, and seasonal trends to understand urban mobility.
📊 Impact: Analyzed bike-sharing patterns across Boston metro area
Challenge
Understanding bike-sharing usage patterns in Boston to identify trends in urban mobility and popular routes throughout the city.
Solution
Created an interactive Tableau dashboard analyzing BlueBikes data including station popularity, trip durations, seasonal trends, and geographic distribution of bike usage.
Results
- ✓Identified most popular bike stations and routes
- ✓Revealed seasonal usage patterns
- ✓Analyzed trip duration distributions
- ✓Provided insights into urban mobility trends