John Paul Dela Cruz

John Paul Dela Cruz

$20/hr
Financial Analyst, Revenue Analytics | Amazon General VA
Reply rate:
-
Availability:
Hourly ($/hour)
Age:
33 years old
Location:
Quezon City, Ncr, Philippines
Experience:
4 years
DELA CRUZ, JOHN PAUL B. Road 7, Brgy. Bagong Silangan, Quezon City, Metro Manila Mobile: (- Skype: live:.cid.13515c28530bfb77 LinkedIn: www.linkedin.com/in/johnpauldelacruz Email:- Qualifications • • A designated General Accounting Associate with strong financial reporting and planning experience in SME and BPO companies within the Healthcare technology, Manufacturing, Sales and Consultancy Industries. Possess strong working knowledge of Advanced Microsoft Excel, Helium10, Keepa, IBM Cognos Analytics and Amazon Seller Central Account Education Philippine School of Business Administration, Quezon City Degree Earned: Bachelor of Science in Accountancy (BSA) w/ Diploma Graduation Date: October 2014 Special Order (B) No.:- s. 2015 BSA Curriculum Highlights: Management Consultancy, Auditing, Financial Reporting – IFRS Standards, Corporate Social Responsibility and Good Governance, Management (Business Organization, Human Behavior in Organization, Production and Operation, and Business Policy and Strategy), Principles of Marketing with Environmental Management, Business Finance with Introduction to Global Business Environment, General Psychology with Drug Addiction, Statistics, Principles of Economics with Tax Agrarian Reform and Economic Analysis, Law (Law on Obligation and Contract, Law on Business Organization, Law on Negotiable Instruments, and Law on Sales, Agency, Labor, and other Commercial Laws), Philippine Tax System and Income Tax, and Business and Transfer Tax, Accounting Information System Knowledge & Skills • • • • • • Strong Microsoft Office Applications especially in MS Excel with VBA Knowledge with Amazon Seller Central account Knows how to use Helium10, Jungle scout and other product listing software Proactive, able to work independently and meet tight reporting deadlines Knowledgeable in Supplier Sourcing, Product listing/ Optimization, Keyword research, Basic Copywriting, Amazon Sponsored Ads/PPC, Inventory Management, Customer Service Productivity innovation such as improvement of templates used in repetitive task to have day time savings. Mr. John Paul B. dela Cruz Curriculum Vitae Page 1 of 3 Training and Seminars Attended • • • • • • • • • • Amazon Virtual Assistant Masterclass Cybersecurity Foundations – CY2022 Innovation Framework Advance MS Excel How to Identify and Escalate Signs of Money Laundering Writing with Precision Find the Phish Automation Anywhere (BOT) Accountancy Profession Updates Using Microsoft Excel in CAATs (Computer Assisted Auditing Techniques) 05 Mar 2022 01 Feb 2022 01 Jun 2019 15 Mar 2019 22 Mar 2019 29 Aug 2018 29 Oct 2018 07 Dec 2018 06 Oct 2017 26 Feb 2015 Work Experience Change Healthcare - Multinational Leading Healthcare Technology company Finance Analyst, Revenue Analytics December 2020 – Present • • • • • Led data enhancement initiative to design and operationalize a new SQL data platform combining revenue and Salesforce CRM data to create a single source of truth for revenue reporting and forecasting for utilization across finance organization, sales and account management achieving 95% forecast accuracy Developed and implemented a streamlined process to combine and automate the work of multiple financial analysts to support Account Management revenue retention compensation, saving 200 hours/mo of manual effort Created an automated process to collect customer assignments from Salesforce to accurately reflect Sales and Account Management books of business and pair with revenue data where a system did not previously exist. Translated data into reporting and dashboarding supporting 15 teams and 160 account managers Strategically aligned company-wide account retention and sales compensation procedures, streamlining 10 disparate processes and increasing forecast accuracy for compensation and revenue Go-to-Market data leader supporting company-wide strategies for revenue and pipeline growth on 60K customers, 500 products and account management across 1K+ sales professionals Mango loco & InTeaGo - Local Beverage SME Sales & Marketing Manager April 2019 – March 2020 • • • Researches and develops various marketing strategies for products and services. Implements marketing plans and works to meet sales quotas. Tracks marketing and sales data and identifies areas of improvement Mr. John Paul B. dela Cruz Curriculum Vitae Page 2 of 3 Accenture - Multinational professional services company Finance Analyst February 2018 – April 2019 • • Developed a financial model via Excel to significantly reduce the month-end accounts reconciliations process from an hour to minutes. Supporting Month-end reports including but not limited to processing manual journal entries, recording, amortizations, bookkeeping, providing analysis and commentaries to account movements and variations, requesting for supplementary information and other activity related (i.e. Intercompany Transaction) to the closing period. Hydro Phil. Asia, Inc. - HDPE and Pvc Pipe Manufacturer Internal Accountant & Tax Accountant December 2014 – January 2016 • • Build program and implement automation of accounting department reports by using advance Microsoft application esp. in Excel such as -Payroll Program (from Payroll preparation to Pay Slip including Government remittances) -Inventory Program (from Data Entry to Product Consolidation reports) -Collection Program (from invoicing to issuance of SOA w/ aging of Accounts Receivable) -Sales Commission Program (from preparation to payment summary) -Cash Flow Program Compliance with all client-published policies and procedures and any legal and internal tax revenue requirements that the company is obliged to submit. Character References Mr. Sunny S. Cortes Ms. Michelle M. Gregorio Mr. Antonio B. Burgos, CPA Mr. John Paul B. dela Cruz Professor in Miriam College - Q.C. Customer Service Associate, Transcom Corporation Professor in Philippine School of Business Administration - QC Curriculum Vitae - Page 3 of 3
Get your freelancer profile up and running. View the step by step guide to set up a freelancer profile so you can land your dream job.