Anong Junior
Virtual assistant helping entrepreneurs save time
New to Contra
Anong is ready for their next project!
PROJECT Title: E-Commerce Data Organization & Inventory Dashboard Setup
PROJECT Role: Virtual Assistant / Data Entry Specialist
Project Description: Overview
A growing online retail brand needed assistance cleaning, structuring, and organizing a messy inventory dataset containing over 500 product listings across multiple supplier sheets.
The Challenge
The original dataset suffered from inconsistent product formatting, duplicate entries, missing SKU codes, and broken pricing logic. This caused delays in tracking stock levels and updating store prices.
My Approach & Solution
Data Cleaning & Standardization: Audited the raw dataset, removed duplicate listings, standardized formatting across all product columns (SKUs, categories, pricing), and filled in missing details via targeted web research.
Formula & Automation Setup: Applied custom VLOOKUP, INDEX/MATCH, and conditional formatting rules to automatically highlight low-stock items and calculate dynamic profit margins.
Executive Summary Dashboard: Created a clean, visual summary tab allowing the client to monitor total inventory value and top-performing categories at a glance.
The Results
Cleaned and organized 500+ product entries with 100% data accuracy.
Reduced the client's weekly inventory tracking time by roughly 4 hours.
Delivered an easy-to-use spreadsheet template ready for immediate team use.
1
122
TITLE: Web Research & Data Collection Sample
DESCRIPTION: A sample project demonstrating my ability to research information online, collect accurate data, organize findings, and create clear reports. This showcases my attention to detail, research skills, and ability to provide useful information that supports business needs.
1
28
TITLE: Social Media Management & Content Planning Sample
Description: A sample project demonstrating my ability to support businesses with social media planning, content organization, scheduling, and maintaining a consistent online presence. This showcases my skills in content coordination, organization, and virtual assistance.
1
25
Title: Virtual Assistant Administrative Support Sample
Description: A sample project demonstrating my ability to provide reliable virtual assistance, organize tasks, manage schedules, and support daily business operations. This showcases my skills in administration, organization, and helping businesses stay productive.
1
28
Title:Data Entry & Spreadsheet Organization Sample
Description: A sample project demonstrating my ability to organize, format, and manage business data using spreadsheets. This showcases my attention to detail, accuracy, and ability to create clean, structured data that helps businesses manage information efficiently.
1
35