Analyze and organize telecom expenditures for a large international client. Use QuickSight and Access to build internal and external reporting.

Manipulate and analyze internal and external data in order to measure the effectiveness of marketing campaigns. Translate complex sets of data into meaningful insights for better informed business decisions.• Developed and ran a process that combined 16 different data sets with just three clicks of a button. This gave us comprehensive profiles of customers and agents that allow the Social and Digital team to do more targeted campaigns• Came up with an Excel template that let us turn an export from our email system into a full set of reports showing open and click rates by various factors. This saved over two hours a week in manual data manipulation.

● Worked with a large international client to build the logic for custom expense and accrual reports that allocated costs by days in the invoice service periods. Created specifications and did extensive testing with our programmers. This set of reports allowed us to go live with a client that generates over $2.5M per year.● Selected to be part of a task force of top Operations personnel to assist the Product team with Tangoe’s Atlas platform. Successfully advised on usability, needed functionality, validations, compared displayed invoice data to actual data file, tested every report, and performed overall User Acceptance Testing. By the end of our project we were able to go live with numerous clients, something that was not possible prior to our guidance and involvement.● Created a set of margin reports for executives and managers that compared revenue and hours worked from our time-tracking system to show margin by client, percentages each employee spent on each project, and a breakdown by client of the percentage of hours spent working on each client by US employees versus less expensive off-shore resources.● Designed, installed and ran the process that allowed Tangoe to re-rate a Partner's monthly charges for Verizon Business into the custom rates they used to bill back to their client. This generated over more than $60,000 a year in new revenue and help us to retain our partner and their clients.● Prepared monthly revenue forecasts for one of our largest clients to assist Finance with their budget forecasts.● Built and delivered numerous tools in Access and Excel which reduced manual work, errors, and man-labor costs while improving efficiency.

● Oversaw client relationships for 5-10 clients and managed the staff providing service delivery.● Managed with the first client we had take advantage of inventory level billing and trained other employees as this became the standard.● Created an email writing course to improve communications with our clients

● Maintained and updated Excel spreadsheets and Access databases used for complex allocations that ensured clients telecom costs were charged to the correct cost center● Prioritized workloads and assigned tasks among staff.● Worked directly with client to resolve any issues or concerns. Provided ad hoc reports when needed.

● Led team to over $1.6M in direct refunds from vendors in a one year period● Prepared budget forecasts and reconciled variances ● Set up an Intranet site to share training information and helpful links with team members.

● Audited and analyzed invoices from electric, natural gas, and telecommunication providers and made recommendations to clients as to how they can reduce their costs.