Jon Acampora Email & Phone Number

Huntington Beach, Ca, Us

Excel Campus is dedicated to helping you improve your Excel skills and boost productivity.I am the creator and instructor for our Excel Training Program: - The Elevate Excel Training Program https://www.excelcampus.com/elevate-excel-invite/A wide range of topics are covered in the program and these include financial modeling, chart techniques, data visualization, advanced functions, efficient formula writing, Visual Basic (VBA), pivot tables, keyboard shortcuts, add-ins, toolbar (ribbon) development, structured reference tables, data mining, manipulation, lookups, power query, power bi, and automation.I am the author and owner of the Excel Campus blog:- The Excel Campus Blog & Training resource - www.excelcampus.com/blogThe blog is updated frequently with tips, techniques, tutorials, and videos to help make you a smarter and more efficient user. I'm focused on continually learning and improving my Excel skills, and enjoy sharing this knowledge with you.I encourage you to sign-up for my free email newsletter to stay updated with new blog posts and product enhancements.I specialize in: process improvement, data and systems integration, financial modeling, spreadsheet consolidation, budget/forecasting/reporting automation, dashboard design, toolbar (ribbon) development.With all my services, I focus on empowering the user with the tools and knowledge they need to maximize their efficiency.Customer satisfaction is our number one priority and we look forward to helping you learn Excel. Professionals from all departments and industries that are looking to spend less time manipulating data and more time making decisions will really benefit from our services.

Austin, Tx, Us

Epicor is a global software company with over $800 million in revenue and 4,000 employees.Well rounded finance and systems knowledge with experience in: advanced analytics, data visualization, process improvement, advanced automation with VBA, data mining, financial modeling, project planning, dashboard design, database design, and systems development.Great experience working in FP&A in a team environment by: leading many successful global projects, conducting Excel training courses, providing superior support and customer service, becoming the "go-to" person for Excel and systems related issues, focusing on personal development through continual learning, and always sharing knowledge and ideas with others.Key Accomplishments:Automated annual budgeting process with Excel VBA and Hyperion Essbase Planning (Oracle) to reduce budget preparation and submission times by 94%, saving over 400 labor hours per year. Developed Excel Toolbar Add-in for Oracle's Essbase to drastically improve user efficiency, automate daily tasks, and greatly enhance the user experience. Financial modeling projects include: P&L forecasting, budgeting, sales pipeline, commission sensitivity, product profitability, pricing, discounting, exchange rate impact, industry, cash flow, incentive plans, etc.Data Integration - Experienced with integrating data and databases from multiple ERP, GL, and reporting systems. Developed automated processes manipulate data in Excel and Access (SQL) for reporting, analysis, matching, lookups, pivot tables, etc.Dashboards & Data Visualization - Developed dashboards for executive management in Excel, Tableau, and SharePoint. Focus on simplicity and ease of use; allowing the data to clearly communicate the story. Excel Skills - Expert in a broad range of topics – See ExcelCampus.com for samples of my work. AwardsReceived multiple Service Awards for providing valuable solutions, improving efficiency, and sharing knowledge.

Us

DPFG is a consulting firm that provides services to the real estate industry development, financing, and planning. Experienced in forming Community Facilities Districts (Mello-Roos) by structuring the financial deals and bond sizing. Requires detailed research, analytical, planning and organizational skills to manage projects and devise custom solutions. Responsible for managing client relationships including: determining client needs, presentation of new ideas and concepts, communicating progress updates, and planning future projects.Restructured Commercial Property Investment financial model to improve efficiency with project financing calculations and cash flow forecasting. Developed Excel Consolidation process to consolidate data from multiple Excel workbooks to publish financial reports including income statements, balance sheets, and cash flow forecasts.Created Visual Basic Macros to automate financial model updating process to update forecasts with actual accounting data.Created Excel models with advanced functions including: lookups, index, data tables, pivot tables, data manipulation, and automated reporting.Restructured tiered return financial model for commercial property investment fund to produce financial performance results for multiple investors and investment projects.

Austin, Tx, Us

Responsible for financial reporting, financial analysis, and systems analysis and development for multi-national manufacturing and distributing company.Automated inter-company netting procedures for treasury department with use of MS Excel Macros (Visual Basic) to eliminate data entry. Reduced overall job time by 95%. Created and analyzed financial reports through MS Access linked to Oracle E-business Suite Financials 11i for domestic and international divisions reporting in multiple currencies.Performed month-end and year-end accounting tasks including financial reporting, allocations, chart of account maintenance, and general ledger closing.Analyzed and restructured global chart of accounts to implement Upstream software (linked Oracle Financials to Hyperion Financial Management Reporting). Worked with international users to plan implementation strategy. Developed plan to restructure workloads for Accounts Payable department through database analysis of employee performance and complexity of vendor payables.

Finance, General

Bachelor’S Degree, Finance