Mark Macaranas Email & Phone Number

San Jose, Ca, Us

Redwood City, California, United States

Fremont, California, United States

Client: Azuga-Supported to help with cleaning up NetSuite and helping to improve the efficiencies of the system, especially in the areas of AR and revenue

San Ramon, California

Client: Accela-Supported the General Ledger team with the sale of company through balance sheet reconciliations for half the fiscal year and retrieving lease agreements

San Francisco Bay Area

Client: ClearCare-Managed, monitored, and reviewed the month-end close cycle, and generate financial statements in accordance with GAAP and corporate accounting policies-Managed journal entry system for proper supporting information for all entries-Reviewed and reconciled credit card statements and manage expense reporting-Ensured effective internal controls and policies and procedures are in compliance

Client: Keeco-Learned to close the books for a recent acquisition by communicating with the employees at the acquired company and learning their processes-Closed the books by reconciling all the balance sheet accounts that includes accounts receivable, accounts payable, deferred accounts, fixed assets, prepaids and many other accounts-Consulted and supported the NetSuite integration for accounts payable and accounts receivable-Provided support documents for the audit

Mountain View, Ca

-Executed monthly accounting close that includes journal entries, reconciliations, reports, contra revenue operating expense, contra revenue classification, and bad debt write-offs-Prepared monthly consolidated income statement flux analysis for management reporting that includes analysis of financial results that includes accounting ratios and variance analysis-Worked with FP&A, sales and marketing to ensure compliance with corporate accounting policies, procedures and provide support for contra revenue operating expense account-Reviewed sub-ledger accounting entries and ensure timely completion and review of all assigned general ledger account reconciliations-Provide day to day support to sales operations, sales, marketing, FP&A and revenue -Assisted in the preparation of audit schedules and related annual audit activities-Drive to continuously improve the automation of the accounting and reporting process by working with the business applications team -Assisted in the management of customer onboarding process and relevant customer follow-up that includes fully executed contract and if applicable, tax exemption forms-Performed ad-hoc projects that includes supporting the recognition and allocation of revenue for bundles

San Jose, Ca

-Worked with the Finance Department and Planning & Development Department in wrapping bond projects-Analyzed invoices and contract using data functions in Excel to make sure the payments are being made in the correct structure -Processed journal vouchers and personnel reports for payroll by calculating hours worked and getting the manager’s approvals-Accrued project expenses for year-end close by working with stakeholders who manage the projects which receive bond funding

San Jose, Ca

Untangle has been involved in four mergers and acquisitions when I was there. The mergers and acquisitions are Cymphonix (Oct 2013), eSoft (Dec 2013), Total Defense (Apr 2014) and Provident Equity Partners (Aug 2016). Untangle consisted of two subsidiaries: Untangle and Total Defense. Untangle provides SaaS by being an innovator in cybersecurity for the below-enterprise market, safeguarding people’s digital lives at home, work and on-the-go. Untangle’s integrated suite of software and appliances provides enterprise-grade capabilities and consumer-oriented simplicity, bringing a new generation of smart security to homes and small-to-mid-sized businesses. Total Defense is a security endpoint business that provides SaaS by providing a commitment to cybersecurity, from installing the software effectively to helping the consumer with recovery in the highly unlikely event of a breach.

San Jose, Ca

-Experienced with enterprise reporting technologies that includes methodologies, development, and implementation of NetSuite, Zuora and FloQast-Created royalty reports that follows the royalty expense contracts and procedures and reviewed royalty contracts-Reconciled royalty expense for month end close-Understood the accounting, financial, taxation, human resources and payroll of the company-Helped with the due diligence of four mergers and acquisitions-Reconciled approximately 20 accounts per month for close-Helped with the mapping of the GL accounts when switching accounting software from QuickBooks to NetSuite-Created custom financial reports in NetSuite and other external software for the accounting team -Filed and paid state sales tax filings monthly, quarterly or annually and adjust accordingly to revised tax changes-Helped with the PBCs for annual income tax filings-Developed and documented accounting and operations processes that lead to easy transitions of passing on responsibilities-Managed, trained and supported a strong, performance-oriented accounting team of two in intrastate taxation, accounts payables, accounts receivables, billing, facility management, fixed assets, operations, month-end close functions, etc. in a fast-paced environment-Handled human resource processes such as onboarding, terminations, benefits, 401K and other human resource processes-Processed payroll every two weeks that includes paid time off, timesheets, commissions, and expense reports in TriNet-Approved over fifty bills every month and made sure the amount, account, department, subsidiary, and memo are correct-Processed bills and made sure the amount, account, department, subsidiary, and memo are correct when the accounts payable accountant took PTO-Communicated with customers regarding renewals and sales orders, and made the necessary billing arrangements when requested with approvals from managers

Sunnyvale, Ca

-Analyzed cash balance on a daily basis and reconciling cash accounts every month-Worked with the third party vendors to get inventory reports and reconciled inventory every month-Created custom inventory report through NetSuite that reduced the reconciliation time from 3 hours to 1 hour-Processed intracompany journal entries and reconciled the intercompany accounts -Analyzed deferred revenue by making the necessary adjustments in the waterfall Excel file, processed journal entry and reconciled the deferred revenue-Recorded prepaid assets and in the memo, adding the account number and department so at month end, I know what account number and department should be expensed-Researched new softwares and services that Untangle may purchase by analyzing the cost, pros and cons, value and why Untangle should purchase that software or service-Lead ad-hoc and special projects

Sunnyvale, Ca

Untangle is the pioneer in multi-functional firewall for small businesses, schools, and non-profit organizations. They provide multiple gateway applications installed at the edge of a network. Untangle's applications include anti-spam, content filtering, antivirus, anti-phishing, anti-spyware, intrusion prevention, firewall, OpenVPN, router, and web cache software on the Untangle Gateway Platform.Reports to the Controller. Responsibilities to include accounts payable, collections, cash flow reporting, facility management, some month-end close functions, preparing journal entries, write-offs, etc.

San Jose, Ca

Raging Waters San Jose, Northern California's Largest Water Park, offers 23-acres and millions of gallons of family fun and attractions, including the newest ride Bombs Away. Raging Waters features thrilling high-speed slides, and family attractions like the 350,000-gallon Wave Pool and The Pirate's Cove-an interactive themed water fort.Responsible for the day-to-day handling of cash generated at sales points throughout the park. Responsibilities include opening and closing of cash control, checking cashier banks, and recording sales figures.

Fremont, Ca

Responsible for managing various customer accounts creating sales reports to show the monthly sales by quantity, editing and double checking volume incentive rebates and sales orders, creating spreadsheets showing the clients purchases for the month, and creating a resource product guide for HDMI cables and surge protectors.

Fremont, Ca

Responsible for generating sales, invoice and accounts receivable aging reports through SAP, creating sales orders, delivery notes and billing documents quickly by figuring out how to drag icons together, and creating or changing purchase orders according with the statement of orders. Every Monday morning, I create clients weekly shipment and SAP weekly shipment reports while managing an excess of $1 million of revenue per month to make sure that shipments are delivered to the customers on time by coordinating with the warehouse manager and account coordinator. Assisting the staff accountant by maintaining and generating accounts receivable aging accounts and processing invoices by e-mails, website templates or inquiries for payment according to terms with a discount if applicable.

San Jose, Ca

Primarily served students by tutoring in financial accounting, intermediate accounting II, markets and institutions, investment analysis, financial management, and international finance.

San Jose, Ca

Responsible for the utilization Microsoft Access, Word, Excel and Outlook to input commercial real estate data such as original commitment, undisbursed commitment and many entries in order to have the necessary information into the database. Worked with the financial analyst manager to learn quickly about commercial real estate documents since it was the year end.

Intensive Web Development & Programming Course, Programming Language Stacks: Python, Mean & Ruby On Rails

Activities and Societies: Intensive web development & programming courseTo be completed on April 28, 2017

Business Administration, Corporate Financial Management: Accounting And Finance Courses

Activities and Societies: Delta Sigma Pi, Beta Alpha Psi, Banking Investing Association, Financial Management Association, National.