Experience

Calero-MDSL
• United States
• IT Services and IT Consulting
• 100 - 200 Employee
• Data Consultant

  • Oct 2021 - Present


Calero Software

• United States
• Information Technology and Services
• 1 - 100 Employee

• Telecom Expense Analyst

  • Nov 2009 - Present

  Expense Analyst Calero Software, Rochester, NY Responsible for the analysis of a broad range of telecom billing from carriers to clients to ensure the client is not billed erroneously and provide Cost Savings options. Provided assistance/training to my co-workers in the analysis process using tools available to provide the client with the best results. •Perform analysis to identify billing errors billed by carriers; Cost Saving options and bill payments discrepancies utilizing our tool and advanced Excel skills • Create Adhoc reports using Excel: V-lookup, Pivot tables and other methods needed to provide clients and internal management with necessary billing requests • Manage/create Inventory • Initiate Tier 1 disputes with carriers for incorrect billing; Rate Changes, ETF, Minimum Commitment Charges, Inside Wirline Charges, Third Party Charges, Optimization; as well as any other incorrect charges billed during the account review process. • Provide training and ongoing support to co-workers to better assist them in reviewing invoices that will supply the client with correct information to manage expenses • Conduct client meetings when SDM not available • Act as a liaison for client's with internal management including VP's, CEO's and site managers as well as Carriers concerning billing issues/projects • Managed Bill Pay/Payment Processing for multiple clients; reviewing accounts prior month invoices before sent to AP looking for payment discrepancies. Processed payments via Carrier portals, QuickBooks and vendor phone calls; Worked with carriers to indentify any bill pay issues. • Responsible for Bill Pay reconciliations with clients and internal Bill Pay department to initiate a true up of over funded/underfunded. • Was the key person involved in the original Bill Pay reconciliation process by creating a process for the Expense Management team to use during the reconciliation/true up process utilizing the tool to create a funding correction Show less



Mpower Communication

• Public Relations and Communications Services
• 1 - 100 Employee

• Mpower Communications

  • Oct 2000 - Sep 2008

  Responsible for Analysis and recording the monthly costs/accruals from Balance Sheet to the P&L for Cost of Good using advanced Excel spreadsheets and various reporting systems. • Calculate accruals; prepare/record general ledger journal entries for multiple companies for COGS and Rent Expenses. Assist Manager with monthly close meetings. • Account reconciliations for 35 accounts including Rents Utilities/Maintenance CAM and Rent Escalations. Prepared schedules for prepaid expenses, waterfalls, and rents. • Analysis of monthly cost vs accrual data utilizing various systems such as Business Objects Financial/ Statistical and Oracle GL Financial Reports. Utilizing advanced Excel; pivot tables, vlookup, concatenations, multiple data filters and subtotals. Creating adhoc spreadsheets based on results for management. • Perform monthly and quarterly trending analysis of balance sheet and Cost of Goods Sold expense accounts. Strong Analytical Skills and attention to detail. • Support internal customers and supply financial data to communicate the monthly expense for Cost of Goods Sold to Sr. Management. • Assist in the creation and testing of Sarbanes Oxley.(Mpower only) • Assist in the 10Q & 10K closing information and support for Audits. (Mpower only) Accountant I 2000-2002 Responsible for auditing Network Cost expenses incurred through Accounts Payable along with various month-end duties. • Processed invoices, audits and reconciled billings from various vendors identifying disputes to be filed. • Worked closely with vendors to negotiate and resolve outstanding disputes. • • Developed schedules for Collocation Fixed Assets prepaid holding. Assisted with depreciation of build out expenses. • Calculated accruals, prepared/recorded accounting entries required for multiple markets. • Payables and Balance Sheet data for bankruptcy filing, sale of markets and settlements with various vendors. Show less


Mpower Communications
• United States
• Telecommunications
• Network Cost Analyst

  • Jun 2000 - Sep 2008