Overview
Looking for full-time work (8 hours/day)
at $4.50/hour ($792.00/month)
Bachelors degree
Last Active
June 1st, 2024 (16 days ago)
Member Since
May 16th, 2024
Profile Description
B.S. Architecture
Google Sheet Experience
GVACO - Florida, USA
August 2019 to April 2022
Data Automation Specialist
- initiated to developed a CRM entirely from scratch using Google Sheets and AppScript codes
Data Analyst and Automation Specialist
Appointments Today - Cleveland, USA
January 2017 to February 2019
- Initiated to developed an automated data gathering system from multiple Google Sheets
Excel Skills
- data analysis, reporting, and management
- advanced formulas and functions (if/then, pivot tables, sum if, etc.)
- data cleansing, manipulation, and transformation
- customized dashboard and interactive representations of key metrics
- integrating charts, graphs, and pivot tables
- conduct in-depth data analysis, uncovering trends, patterns, and anomalies
- automate repetitive tasks through macros and VBA
Data Analytics Course -
May 20223
- Cleaning, calculating, and visualizing data using Excel and SQL
- Running SQL queries to retrieve information from databases
- Creating pivot tables in Excel
- Conducting statistical analysis through Excel
- analyze and interpret data using Power BI
- designing and developing end-to-end dashboards
- data sourcing, modeling, and visualization components
- Ad-hoc (as-needed real time reports)
Workflow Integration, and Online Form Management
- Klaviyo, Zapier, and JotForm
- leveraging
- workflow integration
Web Development and Content Management Experience
- creating the structure and style using HTML and CSS
- utilizing WordPress for content management
- and cPanel for website administration
Freelance Graphic Artist -
December 2012 - November 2022
- 10 years experience
- Proficient in Photoshop, Illustrator, InDesign, Premiere Pro
- 3D modeling and rendering with sketchup and twin motion
- 2D animation using after effects
- color separation
- digital illustrations, graphics, logos
- design elements for web and prints
- update/revise designs as needed
- prepare final files for print or web production
- visuals for social media platforms and online promotion
- designs that align with brand style and campaign objectives
Top Skills
Design » Graphic Design
Experience: 5 - 10 years
Freelance Graphic Artist - https://www.upwork.com/freelancers/~01290f30bc12d29ea7?viewMode=1 December 2012 - November 2022 - 10 years experience - Proficient in Photoshop, Illustrator, InDesign, Premiere Pro - 3D modeling and rendering with sketchup and twin motion - 2D animation using after effects - color separation - digital illustrations, graphics, logos - design elements for web and prints - update/revise designs as needed - prepare final files for print or web production - visuals for social media platforms and online promotion - designs that align with brand style and campaign objectives
Office and Administration » Google Sheets
Experience: 5 - 10 years
Created CRM in Google Sheets with Apps Script Codes: - Dashboard with functions like: > Input data > Update, delete, and save records > Search - Extracted real-time data from website tables into Google Sheets - Removed duplicates - Fixed formats to prevent computation errors - Cleaned scrambled data - Filtered data to obtain only needed information
Other Skills
Office and Administration » Data analysis
Experience: 2 - 5 years
Created CRM in Google Sheets with Apps Script Codes: - Dashboard with functions like: > Input data > Update, delete, and save records > Search Analysis on disputes made in Yellevate: Excel Pivot Table Reports on: - Financial losses due to client disputes - Delays in revenue collection and resolution - France experiencing the highest loss Currently maintaining a database for NBA and MLB: - Extracted real-time data from website tables into Google Sheets - Removed duplicates - Fixed formats to prevent computation errors - Cleaned scrambled data - Filtered data to obtain only needed information - Created a dashboard for daily reports > with filter "Last 7, 15, 30 days" "Yesterday's and Today's Game"
Basic Information
- Age
- 52
- Gender
- Male
- Website
- Sign Up with Pro Account to View
- Address
- Butuan City, Agusan del Norte
- Tests Taken
- None
- Uploaded ID
- Sign Up with Pro Account to View
“They're not only loyal and hardworking, they're super detail oriented!”
- Travis OVAAnswers
You have successfully pinned this profile! You can manage pinned profiles in your Employer dashboard.
Onlinejobs.ph "ID Proof" indicates if "they are who they say they are".
It DOES NOT indicate skill level.
ID Proof scores are 0 - 99 with 99 being the best. It is calculated based on dozens of data points.
It's intended to help employers know who they're talking to is real, and not a fake identity.
Small Shop Dreams to Amazon Realities: Hershe’s Story
Hershe Fe Saloma is a rockstar Online Filipino Specialist Santo Tomas City, Batangas! She's a content maestro -- creating courses, emails, scripts, and more.
READ STORYEMPLOYERS
workers
talented va's
other
contact us
connect with us
