As a Business Analyst, I worked with various directors, VPs, and other stakeholders to boost organizational efficiency, sales, and customer usage. I analyze large data sets and perform migration and management of customer and account data on CRMs, using my skills in Extract, Transform, Load (ETL), statistics, and process improvement.I have multiple certifications in Data Analytics, IT Infrastructure Services, Cybersecurity, Cloud Identity, HubSpot Sales Software, Technical Support, and Computer Networking from Coursera. I am passionate about solving problems, automating tasks, and optimizing systems, and I constantly seek to learn new technologies and tools. I aim to leverage my analytical and technical skills to deliver value and satisfaction to customers and stakeholders.
-
Data AnalystYextMetro Manila, Philippines -
Data AnalystHearsay Systems Sep 2023 - PresentSan Francisco, California, United StatesFinTech SaaS Go-to-Market Data AnalystHandles various large datasets to determine key actionable insights around data and user activityGenerates data-driven analysis to produce customer and company-level conclusions around areas of improvement, best practices and program effectivenessIdentifies industry-specific customer trends on social media effectiveness and end-user best practicesAnalyzes key improvement metrics on process and product using data collected internally through Customer Success and Support teamsGenerates relevant data to produce data visualization reports for key customer presentationsCollaborates with Customer Success Managers to understand client needs Provides feedback to Hearsay Systems' Product team on customer and company needsCollaborates with internal SMEs on data projects to help drive customers' ROI with HearsayDevelops and implements data analyses, data collection systems, data wrangling, deep data drives and other strategies that optimize statistical efficiency and qualityAcquires data from primary and secondary data sources and maintains databases/data systems -
Business AnalystHypothesis Sep 2022 - Aug 2023San Francisco, California, United StatesInternal title: Customer Success & Support AnalystWorked as a Business Analyst supporting the Success, Marketing, Sales, and Support teams as part of Revenue Operations under the Vice President of Revenue.Analyzed large data sets to identify effective ways of boosting organizational efficiency, sales, and customer usage.Performed migration and management of customer usage on HubSpot and recreated systems to facilitate proper big data architecture.Wrangled a combination of multiple arrays of structured and unstructured data into a functioning data warehouseIdentified several opportunities for process improvement, singlehandedly deployed automation and solutions, presented and then trained stakeholders with updated systemsExpertly 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 executivesOptimized and maintained a CRM and a database to enforce data-driven company decisions and operationsPerformed migration and management of customer usage data from inconsistent legacy repositories into a centralized CRM and recreated systems to facilitate proper big data architectureCreated highly complex automated workflows for optimizing data management and audited legacy workflows to fully calibrate the entire data architecture and ecosystem -
Business Solutions AnalystAmazon E-Commerce Experts Apr 2022 - Sep 2022Palo Alto, California, United StatesAnalyzed business needs and developed automation programs to facilitate in-house growth and organization.Created tens of repositories in Google Sheets after conducting Data Wrangling on Legacy data. Deployed reports and dashboards with interactive tables and charts also in Google Sheets that is used by the company's VP for Revenue. Also furnished complete documentation and guide documents on how to utilize and if needed, modify the spreadsheets. Lastly, using Google Apps Script, created daily reports API for processing all new data coming in (also automated from Amazon via APIs) then creating a report automatically sent via Email to stakeholders. -
Information Technology Help DeskMaryruth Organics May 2021 - Apr 2022Los Angeles, California, United StatesSupported international employees with troubleshooting, onboarding, maintenance, and offboarding of company equipment as an Admin. -
Customer Care SpecialistMaryruth Organics Sep 2020 - May 2021Los Angeles, California, United StatesHandled the functions of a Customer Care Specialist and formulated processes for overhauling the returns process saving thousands of dollars. -
Social Media ManagerFitness Mar 2020 - Sep 2020Michigan, United StatesConversed with the @calebzysk.fit IG community through comments, reactions, and chat. Also reached out to members to initiate engagement up to lead conversion -- private and public Facebook groups included.Oversaw and boosted engagements, implemented social media platforms' content strategies, and facilitated the continuous growth of the online community. -
Senior Support SpecialistJumpcut, Inc. Jul 2019 - Mar 2020Los Angeles, California, United StatesSupported and coordinated the management of the customer success team, Resolved higher-tiered tickets as a primary function -
Customer Success SpecialistJumpcut, Inc. Mar 2019 - Jul 2019Los Angeles, California, United StatesAssisted customers by answering inquiries, facilitating requests, and resolving complaints; handled minor tasks as a secondary function -
Junior Collections OfficerAnz Feb 2018 - May 2019Quezon City, National Capital Region, PhilippinesSupported onshore bank processes facilitating back-office maintenance and upkeep of accounts and balances.Granted the title Kaizen Champion to officially empower my capacity to conduct Lean Six Sigma practices more focused on process improvements and automation.Deployed multiple products mainly furnished through MS Excel, VBA Excel, and Automation Anywhere that saved the company thousands of man-hours and dollars as well as sparing the team from arduous manual labor and human-related risks. -
Applecare AdvisorConcentrix Jan 2017 - Jan 2018Mandaluyong, National Capital Region, PhilippinesResponded to customer inquiries, provided solutions and alternatives in a timely fashion; followed up to ensure resolution.Before transitioning to Apple, I also had a few opportunities working under the accounts of Time Warner Cable/Spectrum as their Tier 2 Technical Support. This was under Convergys (before being acquired by Concentrix).
John M. Education Details
-
Library And Information Science -
Computer Engineering -
Marikina Science High SchoolHigh School/Secondary Diplomas And Certificates
Frequently Asked Questions about John M.
What company does John M. work for?
John M. works for Yext
What is John M.'s role at the current company?
John M.'s current role is Data Analyst.
What schools did John M. attend?
John M. attended University Of The Philippines, University Of The Philippines, Marikina Science High School.
Who are John M.'s colleagues?
John M.'s colleagues are Birgitta Varhainen, Brittany Vlach, Courtney Oliver, Tanishka Chhabra, Victoria Widiez, Charly Beck, Brooke Sabghir.
Not the John M. you were looking for?
-
Nikkol John M.
National Capital Region, Philippines -
-
Free Chrome Extension
Find emails, phones & company data instantly
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial