Robert Ippolito Email and Phone Number

• Manage all financial systems. Responsibilities include all systems maintenance, enhancements, and upgrades.• Manage the daily general ledger system processing including all general ledger imports and exports.• General ledger system administrator responsible for maintaining user, roles and permissions, and all master data.• In charge of general maintenance on core banking system including financial account setup, maintaining direct post accounts and transaction mapping for all deposit and loan products into the general ledger.• Collaborate with key teams to help execute monthly, quarterly and annual reporting requirements.• Responsible for creating CRM/BI queries for Accounting and Reporting.

* Responsible for regular maintenance of the general ledger system, which includes, creating items, general ledger accounts, cost centers, and business areas, open and closing accounting periods, and running monthly overhead assessments.* In charge of creating new financial reports and queries for the accounting department using NetSuite Report Builder.* Prepare and distribute P&Ls, Balance Sheets, Cash Flow Statements, and other financial reports and analyses for upper management. * Maintain the fixed assets system, analyzing all capital expenditures, and managing the fixed assets close process. * Improve Accounting/Finance efficiency by identifying opportunities for improvement and streamlining workflows.

* Project lead and liaison between IT and Finance; developed accounting business models using complex Excel formulas (including pivot tables, lookups etc.), BW queries and data extracted from external sources/systems.* Maintained financial models used to budget/forecast daily and annual cash receipts, bad debt expense and expected returns. * Key liaison during external audits to ensure all applicable information was provided to auditors in a timely and organized manner towards the goal of achieving an unqualified opinion.* Worked closely with Assistant Controller to ensure that the company’s reporting requirements were met and special projects were assigned to appropriate staff as needed.

• Spearheaded the integration and improvement of accounting and financial systems following company mergers, which resulted in a more efficient and productive workflow.• Redesigned and implemented reserve models used to calculate the expected returns and expected bad debt using various systems (MS Excel, SAP, BW and Mainframe systems).• Worked closely with IT in implementing system upgrades and enhancements, as well as provided end-user training for newly implemented systems (SAP BW) and upgrades (SAP upgrade to version 6.0).• Managed preparation and distribution of key management reports such as daily flash sales, divisional operating statements and departmental expense reports used by senior management.• Responsible for analyzing all capital expenditures and issuing quarterly commentary which included significant purchases as well as variances versus budget.• Created automated databases that significantly improved inventory monitoring, invoice tracking and journal entries, which increased the department’s productivity and efficiency.• Supervised accounting and financial systems staff and directed various accounting and system functions, including monthly closings, monthly commentaries and systems analyses.

• Accounting system lead; worked closely with IT in the development of BW info cubes ultimately used to feed sales into the G/L system and provide detailed information on daily sales. • Evaluated areas in Accounting/Finance for conversion from manual to computerized systems. Upon defining these areas, responsible for exploring the possibility of self-designed internal programs or consulting with outside vendors on purchasing existing software.• Responsible for designing, implementing, and maintaining various end-user application systems using Access, Excel and Visual Basic for applications. • Responsible for documenting and providing end-user training in SAP Business Warehouse.