Angelo Sarmiento
Angeles City, Pampanga
Summary
Advanced spreadsheet expert with strong skills in data entry, account management, and operational support. Proficient in creating, organizing, and analyzing data efficiently using advanced spreadsheet functions and tools. Adept at streamlining workflows and ensuring accuracy in fast-paced environments.
Overview
8
8
years of professional experience
Work History
Accounts Specialist
Booey Tickets
New Jersey
2022.10 - Current
- Maintained accurate records of all data entered into the system.
- Reviewed existing processes and developed new strategies to improve efficiency in the data entry process.
- Created reports summarizing data entry activities, including time frames, volume of entries, errors.
- Managed a large number of emails/accounts for ticket buying.
- Using different browsers such as Insomniac and Jancy with different proxies such as Residential, Rotating and Static proxies for various tasks.
Junior Reports Analyst
Cloudstaff | Ken Hall Plumbers
Adelaide
2022.08 - 2023.09
- Conducted data analysis and created reports to track progress against goals.
- Developed dashboards, scorecards and other visualizations to present key performance metrics using Google Sheets and MS Excel.
- Gathered requirements from stakeholders for custom reporting needs.
- Created ad-hoc reports as requested by various departments within the organization.
- Integrated multiple data sources into a single repository for ease of access and reporting purposes.
- Performed quality assurance on all generated reports prior to release to ensure accuracy and integrity of information presented.
- Maintained accounts payable files and records in an organized manner.
- Entered data into SimPro to maintain accurate financial records.
- Assisted with scheduling jobs for our tradesmen in SimPro.
- Sent follow-up emails to suppliers to request and obtain invoices.
- Managed emails from different suppliers in MS Outlook.
Mortgage Underwriter Support
Clark Outsourcing | Flatiron Realty Capital
New York
2021.10 - 2022.08
- Reviewed appraisal documents to ensure accuracy and completeness of information.
- Ensured all data was entered into the system accurately and timely.
- Assisted in gathering relevant information for appraisals, such as comparables, sales history.
- Prepared reports containing findings from appraisals using Google Sheets.
- Created detailed spreadsheets with pertinent appraisal data.
- Coordinated with clients regarding scheduling of appointments and inspections of properties being appraised.
- Provided support to other staff members during the appraisal process.
- Performed quality control checks on completed appraisal documents before sending them out for review.
- Sent out email to Appraiser to revise/dispute/quote/request appraisal documents
- Created visualizations of complex datasets to enable easy interpretation of information.
Data Analyst
Clark Outsourcing | Flatiron Realty Capital
New York
2021.02 - 2021.10
- Conducted research and identified potential leads through various online sources.
- Created detailed lead profiles to ensure accurate data capture for further analysis.
- Maintained an up-to-date database of qualified leads and their contact information in HubSpot.
- Collaborated with sales team members to develop strategies that would increase lead conversion rate.
- Provided regular reports on the progress of lead generation activities, including performance metrics such as cost per acquisition.
- Checked the validity of phone number and email addresses gathered.
- Gathered, analyzed and formatted large amounts of data into meaningful information.
Technical Content Specialist
Shore360 | Allrites
Brisbane
2019.11 - 2020.11
- Edited existing content to ensure accuracy, consistency and quality standards are met.
- Maintained library of digital assets such as images, videos, audio files.
- Researched, wrote, and edited website content to ensure accuracy and clarity.
- Performed quality assurance testing on new features prior to release into production environment.
Merchandising Coordinator
SmartBuy Glasses
Shanghai
2018.10 - 2019.08
- Assisted with the research and collection of product data from various sources.
- Entered product information into a database accurately and efficiently.
- Checked accuracy of product descriptions, images, prices.
- Updated existing products in the database as needed.
- Maintained accurate records for all product information entered into the system.
- Performed color correction and resizing of photos in batch using Photoshop.
Media Analyst
IBD | Technical Marketing Solutions
Clark Freeport Zone
2017.01 - 2018.06
- Created regular reports to track progress against key performance indicators.
- Developed surveys to collect user feedback regarding product features.
- Gathered data on competitor products, pricing, and strategies.
- Assisted in the creation of marketing materials such as emails, newsletters, and website copy.
Education
Bachelor of Science - Information And Communications Technology
Holy Angel University
Angeles City, Pampanga, PH2017-04
Skills
- Accounts payable management
- Advanced Google Sheets & MS Excel
- Basic SQL and PHP
- Data Management
- Email management
- Expense tracking
- Purchase order management
- Reports and Dashboards
- Research
- Skip tracing & Web scraping
References
References available upon request.
Timeline
Accounts Specialist
Booey Tickets
2022.10 - Current
Junior Reports Analyst
Cloudstaff | Ken Hall Plumbers
2022.08 - 2023.09
Mortgage Underwriter Support
Clark Outsourcing | Flatiron Realty Capital
2021.10 - 2022.08
Data Analyst
Clark Outsourcing | Flatiron Realty Capital
2021.02 - 2021.10
Technical Content Specialist
Shore360 | Allrites
2019.11 - 2020.11
Merchandising Coordinator
SmartBuy Glasses
2018.10 - 2019.08
Media Analyst
IBD | Technical Marketing Solutions
2017.01 - 2018.06
Bachelor of Science - Information And Communications Technology
Holy Angel University