FEATURED WORK

Portfolio Projects

Explore practical projects demonstrating my skills in data management, administrative support, research, organization, and web development.


Data & Research

01

DATA MANAGEMENT

Data Cleaning & Spreadsheet Organization

Cleaned and standardized a fictional customer contact database by removing duplicates, correcting inconsistent formatting, and organizing information into a usable spreadsheet.

Excel Data Cleaning Formatting Data Organization
BEFORE Before screenshot of the unorganized customer database

Before: Messy and inconsistent customer data with duplicates, inconsistent formatting, and unorganized information.

After Organization
AFTER After screenshot of the cleaned and organized customer database

What I did: Removed duplicates, standardized formatting, organized the columns, added clear data checks for easier use, and created a table summary and graph analysis for easier interpretation.

02

REPORTING

Sales Tracking & Reporting

Created a structured sales tracker to organize transaction data, calculate key metrics, and provide a quick monthly sales overview and additional insights.

Excel Data Entry Formulas Reporting
SALES TRACKER Sales tracker spreadsheet showing organized transaction data

What I created: Structured transaction data into a clean sales tracker with organized fields, calculated revenue, and consistent formatting.

SALES REPORT Sales report showing monthly sales metrics and analysis

What I created: Turned the sales data into a quick monthly report with key metrics, summaries, and visual insights for better understanding of sales performance.

03

RESEARCH

Internet Research & Competitor Analysis

Researched competing digital product businesses and organized relevant information into a comparison spreadsheet with key findings and recommendations.

Internet Research Data Collection Excel Analysis
RESEARCH Internet research spreadsheet

What I researched: Collected relevant product, pricing, category, and business information from fictional online sources.

COMPETITOR ANALYSIS Competitor analysis spreadsheet

What I did: Organized the findings into a comparison table to identify patterns, differences, and useful business insights. Provided additional key findings and recommendations as well.

Administrative Support

04

ADMINISTRATION

Email Organization System

Designed a simple inbox categorization system to make important messages easier to identify, prioritize, and manage.

Email Management Organization Prioritization
BEFORE Before screenshot of an unorganized email inbox

Before: An unorganized inbox with read and unread messages mixed together, making important emails harder to identify and prioritize.

After Organization
AFTER After screenshot of an organized email inbox

What I did: Created a simple categorization system to separate messages by priority and purpose for easier inbox management. Archived low-priority emails for a clean inbox view, and remained high-priority messages in the main inbox for quick access.

05

SCHEDULING

Calendar & Scheduling Management

Created a weekly scheduling system for a fictional client, organizing meetings, deadlines, and administrative tasks while preventing scheduling conflicts.

Google Calendar Scheduling Organization
BEFORE

Before: A cluttered weekly schedule with overlapping commitments, inconsistent event organization, and limited focus time.

After Organization
AFTER

What I did: Reorganized events, resolved scheduling conflicts, color-coded events and tasks for easier distinction, and created a more balanced weekly schedule.

06

FILE MANAGEMENT

Digital File Organization

Reorganized a fictional client's digital files using a clear folder hierarchy and consistent naming convention.

File Management Organization Documentation
BEFORE

Before: Files were scattered across folders with inconsistent names and no clear organizational structure.

After Organization
AFTER

What I did: Created a clear folder hierarchy, grouped related files, and applied consistent naming conventions for easier navigation.

07

DOCUMENTATION

Document Formatting

Transformed an unstructured document proposal with inconsistent formatting into a clean, professional proposal with organized sections and clean formatting.

Microsoft Word Formatting Documentation
BEFORE

Before: Unstructured business proposal with inconsistent formatting and information that was difficult to scan quickly.

After Formatting
AFTER

What I did: Structured the information into clear sections, improved formatting, and created tables for easier review and quick scanning.

Digital Business Support

08

SOCIAL MEDIA MANAGEMENT

Social Media Content Planning & Management

Developed and organized a multi-platform content plan for Choyeo Digitals in Notion to coordinate content ideas and scheduling for different social media platforms.

Content Planning Content Scheduling Social Media Notion
CONTENT PLAN

Content Planning: Organized social media content by platform, content type, goal, product, creative direction, and CTA using Notion.

Multi-Platform Planning
CONTENT IMPLEMENTATION Social media content created and implemented from the Choyeo Digitals content plan

What I implemented: Turned planned content ideas into actual social media posts, adapting each piece to its intended format, message, visual direction, and call to action.

09

CONTENT CREATION

Social Media Graphic Design & Content Creation

Created branded social media graphics and promotional content for Choyeo Digitals, combining clear messaging, consistent visual design, and product-focused content for different social media platforms.

Canva Graphic Design Content Creation Branding
SOCIAL MEDIA DESIGNS Social media graphics created in Canva for Choyeo Digitals

Content Creation: Designed social media graphics including educational posts, product promotions, interactive content, and branded visuals using Canva.

Product Promotion
PRODUCT CONTENT Product promotional graphics created for Choyeo Digitals

What I focused on: Created visually consistent content that communicates product benefits clearly while maintaining Choyeo Digitals' brand identity across social media.

10

CRM & CUSTOMER DATA

CRM Contact & Lead Management

Practiced organizing and managing customer information using Zoho CRM, including maintaining contact records, updating lead information, and organizing details for easier follow-up and customer management.

Zoho CRM Contact Management Lead Tracking Customer Data
CONTACT MANAGEMENT Zoho CRM contact management list using fictional practice data

Contact Organization: Organized fictional customer records in Zoho CRM, maintaining consistent contact details and lead statuses for easier tracking and follow-up.

Contact Record & Follow-Up
CRM RECORD

CRM Workflow: Organized the contact record with products, deals, meetings, cadences, tasks, and follow-up email workflows.