John Almario T. Mendoza Iii

CAREER OBJECTIVE I'm seeking an engaging data analyst role at your company, where I can fully utilize my experience in data analysis and predictive modeling to optimize operations. I'm thrilled to apply my proficiency in spreadsheets and advanced software for analytics, to fuel your company's data-driven decision-making for the future. With years of experience in various industries and startups, I aim to further expand my expertise through various data projects by proving my expertise with automation, process improvement, and overall data management. Phirst Park Homes Batulao, Nasugbu, Batangas, 4231 JOHN MENDOZA Automation and Data Specialist You’re patient, empathetic, and enjoy understanding others. You don’t mind asking questions or explaining things twice (or sometimes more). You’re curious and adaptable, with the ability to shift strategies quickly to meet the needs of our customers. You love to solve tricky technical problems. You are driven to find the underlying issue and how to resolve it. You enjoy working independently and can keep yourself on track with minimal supervision. An ideal candidate will have: At least one year of experience in customer support or a related field Excellent written and verbal communication skills - much of the day is spent communicating in written form with both customers and team members. Strong interpersonal skills, compassion, enthusiasm, and diligence. BONUS: Experience in at least one of these industries or specialties – consumer electronics, consumer goods, B2C software, B2B software, product design, engineering. BONUS: Experience working with customers via ticketing software CORE COMPETENCIES Data-Driven and Enjoys Deep Data Dives and Research Proven Problem Solving Capabilities and Attention to Detail Efficient Data Visualization and Presentation Applied Internet Security and Data Privacy Experience Strong Data Validation and Monitoring Proficiencies SKILLS SPREADSHEET PROGRAMS GOOGLE SHEETS MICROSOFT EXCEL LIBRE OFFICE CALC DATA ANALYTICS METABASE GOOGLE DATA STUDIOS IBM COGNOS ANALYTICS POWER BI TABLEAU -- linkedin.com/in/mendoza-johnalmario - MOST RECENT WORK EXPERIENCE Business Analyst Sep 2022 - Aug 2023 HYPOTHESIS / ANNOTATION UNLIMITED PBC. (USA-REMOTE) https://web.hypothes.is/ https://www.linkedin.com/company/hypothes.is/ Wrangled a combination of multiple arrays of structured and unstructured data into a functioning data warehouse Identified several opportunities for process improvement, singlehandedly deployed automation and solutions, presented and then trained stakeholders with updated systems Expertly utilized Google Sheets and MS Excel to provide a working repository for data from various facets of customer usage data automated analysis of the aggregated data stored in all systematic repositories a tabulated KPI report containing concise high-level information regarding customer usage and predictions detailed charts numbering over 100 that serve as a quick reference for the VP of Education and Revenue a dashboard utilized by company executives to monitor the health of the company clean and analyzed data presented to the board every month by the company executives Optimized and maintained a CRM and a database to enforce data-driven company decisions and operations Performed migration and management of customer usage data from inconsistent legacy repositories into a centralized CRM and recreated systems to facilitate proper big data architecture Created highly complex automated workflows for optimizing data management and audited legacy workflows to fully calibrate the entire data architecture and ecosystem STATEMENT Dedicated data professional with several years of experience identifying efficiencies and problem areas within data streams while communicating needs for projects. Adept at receiving and monitoring data from multiple data streams. Ability to synthesize quantitative information and interact effectively with stakeholders. Proven track record of generating summary documents for senior management for periodic audit and compliance reporting. Phirst Park Homes Batulao, Nasugbu, Batangas, 4231 JOHN MENDOZA Automation and Data Specialist You’re patient, empathetic, and enjoy understanding others. You don’t mind asking questions or explaining things twice (or sometimes more). You’re curious and adaptable, with the ability to shift strategies quickly to meet the needs of our customers. You love to solve tricky technical problems. You are driven to find the underlying issue and how to resolve it. You enjoy working independently and can keep yourself on track with minimal supervision. An ideal candidate will have: At least one year of experience in customer support or a related field Excellent written and verbal communication skills - much of the day is spent communicating in written form with both customers and team members. Strong interpersonal skills, compassion, enthusiasm, and diligence. BONUS: Experience in at least one of these industries or specialties – consumer electronics, consumer goods, B2C software, B2B software, product design, engineering. BONUS: Experience working with customers via ticketing software SKILLS (CONT'D.) PROGRAMMING LANGUAGE VBA EXCEL SQL PYTHON C++ Business Development Analyst IT Helpdesk I (International) May 2021 - April 2022 Customer Care Specialist Sept. 2020 - May 2021 CRM AND CS SOLUTIONS HUBSPOT ZENDESK FRESHDESK SALESFORCE COMMUNICATION Social Media Manager and Virtual Assistant March - Sept. 2020 Senior Support Specialist July 2019 - March 2020 SLACK ZOOM PROJECT MANAGEMENT Customer Success Specialist May - July 2019 ASANA NOTION NZ Collections Officer Feb. 2018 - May 2019 AUTOMATION TOOLS ZAPIER AUTOMATION ANYWHERE - linkedin.com/in/mendoza-johnalmario - EXPERIENCE April - Sep 2022 GOOGLE SCRIPT - Customer Support Specialist Jan. 2017 - Jan 2018 HOME PICK INC. | USA-REMOTE Analyzed business needs and developed automation programs to facilitate inhouse growth and organization MARYRUTH ORGANICS | USA-REMOTE Supported international employees with troubleshooting, onboarding, maintenance, and offboarding of company equipment MARYRUTH ORGANICS | USA-REMOTE Supported international employees with troubleshooting, onboarding, maintenance, and offboarding of company equipment CALEB ZYSK FITNESS | USA-REMOTE Oversaw and boosted engagements, implemented social media content strategies, and facilitated the continuous growth of the online community JUMPCUT INC. | USA-REMOTE Supported and coordinated the management of the customer success team, Resolved higher-tiered tickets as a primary function JUMPCUT INC. | USA-REMOTE Assisted customers in answering inquiries, facilitating requests, and resolving complaints; handled minor tasks as a secondary function ANZ BANK (GLOBAL) | MANILA-ONSITE Supported onshore bank processes facilitating back-office maintenance and upkeep of accounts and balances CONCENTRIX | MANILA-ONSITE Responded to customer inquiries, provided solutions and alternatives in a timely fashion; followed up to ensure resolution. STATEMENT Dedicated data professional with several years of experience identifying efficiencies and problem areas within data streams while communicating needs for projects. Adept at receiving and monitoring data from multiple data streams. Ability to synthesize quantitative information and interact effectively with stakeholders. Proven track record of generating summary documents for senior management for periodic audit and compliance reporting. JOHN MENDOZA Automation and Data Specialist You’re patient, empathetic, and enjoy understanding others. You don’t mind asking questions or explaining things twice (or sometimes more). You’re curious and adaptable, with the ability to shift strategies quickly to meet the needs of our customers. You love to solve tricky technical problems. You are driven to find the underlying issue and how to resolve it. You enjoy working independently and can keep yourself on track with minimal supervision. An ideal candidate will have: At least one year of experience in customer support or a related field Excellent written and verbal communication skills - much of the day is spent communicating in written form with both customers and team members. Strong interpersonal skills, compassion, enthusiasm, and diligence. BONUS: Experience in at least one of these industries or specialties – consumer electronics, consumer goods, B2C software, B2B software, product design, engineering. BONUS: Experience working with customers via ticketing software CORE COMPETENCIES SKILLS (CONT'D.) GOOGLE WORKSPACE Phirst Park Homes Batulao, Nasugbu, Batangas, 4231-- linkedin.com/in/mendoza-johnalmario - EXPERTISE AUTOMATION & PROCESS IMPRV. SYSTEMS ANALYSIS AND AUDITING EXTRACT, TRANSFORM, LEAD (ETL) DATA MIGRATION GOOGLE SHEETS MS EXCEL DATA VISUALIZATION INFORMATION SECURITY SCRIPTING AND VBA PROJECT MANAGEMENT ALTERNATIVE SOLUTIONS CRM & DATABASE ADMINISTRATION TEAMVIEWER MALWAREBYTES NORDLAYER CLOUD IDENTITY OCTA AZURE AD JAMF CLOUD STORAGE DROPBOX GOOGLE DRIVE MISCELLANEOUS PROFESSIONAL CERTIFICATIONS AUGUST 2023 MICROSOFT OFFICE SUITE Data Analytics Essentials Credential ID LJM753LHQ2JK CANVA You’re patient, empathetic, and enjoy understanding others. You don’t mind asking questions or explaining things twice (or sometimes more). You’re curious and adaptable, with the ability to shift strategies quickly to meet the needs of our customers. You love to solve tricky technical problems. You are driven to find the underlying issue and how to resolve it. You enjoy working independently and can keep yourself on track with minimal supervision. An ideal candidate will have: At least one year of experience in customer support or a related field Excellent written and verbal communication skills - much of the day is spent communicating in written form with both customers and team members. Strong interpersonal skills, compassion, enthusiasm, and diligence. BONUS: Experience in at least one of these industries or specialties – consumer electronics, consumer goods, B2C software, B2B software, product design, engineering. BONUS: Experience working with customers via ticketing software TIME DOCTOR JUNE 2023 EDUCATION University of the Philippines Bachelor in Library and Information Science | School of Library and Information Studies BS in Computer Engineering | Electrical & Electronics Engineering Institute Excel for Data Analysis Credential ID WLN3WUHFP2EE MARCH 2022 HubSpot Sales Software Credential ID 2316acd-e7b221d9ea3a 57bf7a IT Security: Defense Against the Digital Dark Arts Credential ID Y785TASL8EQH GOOGLE IT SUPPORT SPECIALIZATION Credential ID 64K35P7NVQST | Issued March 2022 Coursera Specialization Record https://www.coursera. org/account/accomplis hments/specialization/ certificate/64K35P7NV QST STATEMENT Dedicated data professional with several years of experience identifying efficiencies and problem areas within data streams while communicating needs for projects. Adept at receiving and monitoring data from multiple data streams. Ability to synthesize quantitative information and interact effectively with stakeholders. Proven track record of generating summary documents for senior management for periodic audit and compliance reporting. Phirst Park Homes Batulao, Nasugbu, Batangas, 4231 JOHN MENDOZA Automation and Data Specialist CHARACTER REFERENCES LOREE BUCHAN Head Revenue Operations Annotation Unlimited PBC (Hypothes.is)-https://www.linkedin.com/in/loree buchan/ T: - You’re patient, empathetic, and enjoy understanding others. You don’t mind asking questions or explaining things twice (or sometimes more). You’re curious and adaptable, with the ability to shift strategies quickly to meet the needs of our customers. You love to solve tricky technical problems. You are driven to find the underlying issue and how to resolve it. You enjoy working independently and can keep yourself on track with minimal supervision. An ideal candidate will have: At least one year of experience in customer support or a related field Excellent written and verbal communication skills - much of the day is spent communicating in written form with both customers and team members. Strong interpersonal skills, compassion, enthusiasm, and diligence. BONUS: Experience in at least one of these industries or specialties – consumer electronics, consumer goods, B2C software, B2B software, product design, engineering. BONUS: Experience working with customers via ticketing software PEG FOWLER Vice President Business Operations and Finance Annotation Unlimited PBC (Hypothes.is)-https://www.linkedin.com/in/pegfowler-7b79323/ T: - CHRISTIE DECAROLIS Manager Customer Success Annotation Unlimited PBC (Hypothes.is)-https://www.linkedin.com/in/chri stiedecarolis/ IRENE REYES Coordinator Marketing Department Annotation Unlimited PBC (Hypothes.is)-https://www.linkedin.com/in/irenereyes-a90229a7/ T: - -- linkedin.com/in/mendoza-johnalmario - PROFESSIONAL CERTIFICATIONS (CONTD.) FEBRUARY 2022 JANUARY 2022 DECEMBER 2021 System Administration and IT Infrastructure Services Credential ID 4WEHLZT7AYQT Operating Systems and You: Becoming a Power User Credential ID FJQXDZTYBG6M The Bits and Bytes of Computer Networking Credential ID LTQQHEPDTSKZ Technical Support Fundamentals Credential ID LNAFWUJRRBTG ONGOING CERTIFICATIONS Data Visualization and Dashboards with Excel and Cognos Python for Data Science, AI & Development Python Project for Data Science Databases and SQL for Data Science with Python Data Analysis with Python Data Visualization with Python IBM Data Analyst Capstone Project HOBBIES COOKING ANIME VIDEO GAMES MANGA STATEMENT Dedicated data professional with several years of experience identifying efficiencies and problem areas within data streams while communicating needs for projects. Adept at receiving and monitoring data from multiple data streams. Ability to synthesize quantitative information and interact effectively with stakeholders. Proven track record of generating summary documents for senior management for periodic audit and compliance reporting. JOHN MENDOZA Automation and Data Specialist LINK: https://www.linkedin.com/in/mendozajohnalmario/details/recommendations/ You’re patient, empathetic, and enjoy understanding others. You don’t mind asking questions or explaining things twice (or sometimes more). You’re curious and adaptable, with the ability to shift strategies quickly to meet the needs of our customers. You love to solve tricky technical problems. You are driven to find the underlying issue and how to resolve it. You enjoy working independently and can keep yourself on track with minimal supervision. An ideal candidate will have: At least one year of experience in customer support or a related field Excellent written and verbal communication skills - much of the day is spent communicating in written form with both customers and team members. Strong interpersonal skills, compassion, enthusiasm, and diligence. BONUS: Experience in at least one of these industries or specialties – consumer electronics, consumer goods, B2C software, B2B software, product design, engineering. BONUS: Experience working with customers via ticketing software Phirst Park Homes Batulao, Nasugbu, Batangas, 4231-- linkedin.com/in/mendoza-johnalmario - RECOMMENDATIONS STATEMENT Dedicated data professional with several years of experience identifying efficiencies and problem areas within data streams while communicating needs for projects. Adept at receiving and monitoring data from multiple data streams. Ability to synthesize quantitative information and interact effectively with stakeholders. Proven track record of generating summary documents for senior management for periodic audit and compliance reporting. JOHN MENDOZA Automation and Data Specialist Phirst Park Homes Batulao, Nasugbu, Batangas, 4231-- linkedin.com/in/mendoza-johnalmario - WORK SETUP DEVICE SPECIFICATIONS You’re patient, empathetic, and enjoy understanding others. You don’t mind asking questions or explaining things twice (or sometimes more). You’re curious and adaptable, with the ability to shift strategies quickly to meet the needs of our customers. You love to solve tricky technical problems. You are driven to find the underlying issue and how to resolve it. You enjoy working independently and can keep yourself on track with minimal supervision. An ideal candidate will have: At least one year of experience in customer support or a related field Excellent written and verbal communication skills - much of the day is spent communicating in written form with both customers and team members. Strong interpersonal skills, compassion, enthusiasm, and diligence. BONUS: Experience in at least one of these industries or specialties – consumer electronics, consumer goods, B2C software, B2B software, product design, engineering. BONUS: Experience working with customers via ticketing software WORKING CONDITIONS FINEPRINT Device name DESKTOP-6JAB4BT Processor AMD Ryzen 7 5700G with Radeon Graphics | 3.80 GHz Installed RAM 16.0 GB (15.4 GB usable) Device ID F492335B-2D66-40B3-824C-5DCD43B40872 Product ID--AAOEM System type 64-bit operating system, x64-based processor Pen and touch No pen or touch input is available for this display Own dedicated office space WINDOWS SPECIFICATIONS Flood-free location Edition Windows 11 Pro Version 21H2 Installed on 3 ‎ 0/‎01/‎2022 OS build- Experience Windows Feature Experience Pack- GRAPHICS NVIDIA GeForce GTX 1650 Approx. Total Memory: 11833 MB Display Memory (VRAM): 3962 MB Shared Memory: 7871 MB INTERNET CONNECTION Quiet and safe location Noise-cancelling headset available Rare power interruptions Uninterrupted Power Supply equipped Backup generator accessible Landslide free area No children/dependents Non pet owner (currently) Wife assists me with day-to-day needs Zero distractions and disruptions Fast computer Dependable internet connection Several backup mobile internet connection ready Reserved Laptops at hand ISP: Globe: 500mbps Fiber Unli Plan 2699 w/ Landline Car owner allowing mobility if required speedtest.net/result/- backup location timestamp: 08/07/2023 2:04 PM (PHT) Ability to work on hybrid and on-side Mobile during emergencies to work in rarrangements as necessary