Data Entry and Research
As a Data Entry Specialist, I can perform:
- Data Mining: Assist in researching and collecting data from various sources, such as social media, online directories, and other online platforms.
- Data Cleansing: Assist in cleaning and organizing your data to ensure consistency and accuracy in your databases.
- Data Analysis: Assist in data analysis tasks such as creating pivot tables, charts, and graphs to show trends and patterns in your data.
- Data Visualization: Create presentations to display data in a visually appealing and intuitive way.
- Transcription: Transcribe audio and video recordings into written text documents.
- Design and Formatting: Create custom forms and documents such as invoices and receipts, to streamline your data management and record-keeping activities.
Tools I use:
- Microsoft Office (Word, Excel, PowerPoint, Publisher, Outlook)
- Google Workspace (Docs, Sheets, Slides, Drive, Calendar, Gmail)
- Adobe Acrobat
Some of what I've worked on in the past:
(Important Note: To ensure confidentiality, names, contact details, and other data referenced in the samples have been replaced with placeholders.)
A. Employee Databases
I maintained a monthly employee database with 800+ names. This database was used to monitor new hires, resignations, transfers, and number of employees per Division and Department per month. It also served as a reference file in creating attendee master lists for events and Performance Reports.
B. Product Inventory and Pricelist
I maintained a pricing and inventory Google Sheets file for some food products I sold over at Facebook Market Place and Carousell (Buy and Sell Website/App).
Below are the actual product pricelist and inventory sheet with names, stock quantity, description, expiry dates, net weight, and corresponding costs, overhead, and selling prices.
I first set up the product pricelist and assigned codes to each product. When I worked on the inventory sheet, I set up a VLOOKUP function to populate the price column of the inventory sheet. Basic functions were also used to compute for cost price, overhead, and final selling price, and profit.
Price List:
Inventory:
C. Directories
I coordinated with various departments within and outside my former sector in consolidating contact information for the sector Sales Kit. Relationship Managers would refer to this kit for product offerings, procedures, and resource persons they can contact within the bank. (Note: Full sales kit cannot be shown here in sample works due to sensitive bank information).
The sample below shows the actual headings of the directory. Names, e-mail addresses, departments, and contact numbers have been replaced by placeholders as they are confidential in nature.
D. Process Manuals / Guidelines
I developed process manuals that employees can refer to whenever they use document templates. This is also very useful for document and task turnover for when an employee resigns.
Below is a sample manual I created for a travel agency client:
----------
I had the opportunity to assist and head sector-wide onsite and online events and programs with 800-900 attendees. This involved coordinating with personnel from different departments and external sectors, and ensuring that everything is well-documented to ensure a smooth flow of programs. Below are some of the tasks that I had experience in when it came to events management and assistance:
E. Event Attendee Lists and Seat Plans
I coordinated with the bank's Events and Marketing team in preparation for my former sector's annual convention, and acted point-person for all documents and data that the Events and Marketing Team may need. In this example, the events team needed a list of all confirmed convention attendees and seating arrangement.
Using my Employee Database file, I filtered all personnel who were required to attend the event (Rank Junior Assistant Manager and above). I then got in touch with the Executive Assistants (EA) of each division to confirm if the initial attendee list is accurate and complete, and also requested them to get the shirt size of each attendee. Once confirmed with the EAs, I prepared a consolidated file with a summary on the first page, showing total attendee headcount per division and total number of shirt sizes to be ordered.
I also strategically assigned seat numbers for each attendee, making sure that high-ranking officers and awardees are seated near the event's stage during the awarding ceremony.
The Attendee Master List with Shirt Sizes and Seat Numbers were then sent to the Events and Marketing team which they used as reference in developing the program, booking the venue and catering, event registration, and hotel arrangements.
Summary Sheet:
Attendee List Sheet (first 20 entries):
F. Event Presentations
As a coordinator for events, I also prepared PowerPoint presentations for event planning and title cards for live programs.
Presentation 1 - Meeting PowerPoint for a themed party (excerpt)
Presentation 2: Event Title Cards
Font was developed using Adobe Illustrator, with animation done in Powerpoint. For the actual animated deck, click HERE and download the PowerPoint Show file.
Note: Preview does not have animation, please download the file to your computer then open with Powerpoint.