Bobby Rays Email & Phone Number

Auburn Hills, Mi

Administrator of Prophix CPM system. Building and maintaining models, developing automated reporting, and ad-hoc analysis. Lead initiative to full integrate actual and forecast reporting into Prophix and away from Excel. Lead the profitability forecasting process across Project Worldwide’s global network of agencies. Support the preparation of quarterly Board of Director meeting materials and annual budget process.Work closely with agency Managing Directors and Financial Leads, international and domestic, on initiatives that drive overall profitability improvement.Support financial systems modernization initiatives, including the implementation of a corporate Performance Management system.Develop pipeline, to go and actual revenue reporting KPI’s and reporting.Build and refine financial models that encompass financial metrics, economic inputs and client behavior to help drive overall profitability.Analyze performance measurements, sales/orders reporting and pipeline analysis.Plan and support broad financial analysis assignments, including investment cases and product line profitability pricing analysis.Develop strong relationships with executives and others within and outside the finance department, and maintain open flow of communication, thus enabling deep knowledge of current events in the business

Provided monthly/adhoc financial reporting in support of all clientsCoordinated with Prophix to create and optimize automated reportsProvide employee capacity analysis to improve efficiencyHandle day-to-day responsibilities of specific clientsAssist in questions/support regarding client’s monthly forecast Support VP Finance during annual client contract negotiations Perform profitability analysis on current and potentially new clientsProvide employee utilization report, A/R aging, current summaries, income statements, Margin Analysis report, Retainer Analysis reports

Provided monthly/adhoc financial reporting in support of all clientsProvide employee capacity analysis to improve efficiencyHandle day-to-day responsibilities of specific clientsAssist in questions/support regarding client’s monthly forecast Support VP Finance during annual client contract negotiations Perform profitability analysis on current and potentially new clientsProvide employee utilization report, A/R aging, current summaries, income statements, Margin Analysis report, Retainer Analysis reports

Processed invoices from clients for Display ads, Free Standing Inserts, and Trade Payables.Affidavit processingManaged large Excel spreadsheets to be easily used to research past shipping charges.Constant contact with clients by means of email and phoneImproved client relations by working with the newspapers to get past due balances cleared up and accounts kept current. Manage check runs of $50 million a monthProjects: My team and I worked closely with Client Services to reduce the number of invoice discrepancies from newspapers. This was accomplished by both teams working diligently with the newspaper to get issues resolved before any money was paid out. This meant efficiently sending discrepancies notices to newspapers for review.(Summer 2008)When one newspaper had an extremely past due balance on their books I was able to pay off the balance by researching past invoices and payments. I located misquoted rates and unpaid advertising in order to eliminate the balance. (Spring 2009)

Managed the collections of over 150 customer accounts.Processed credit card and electronic check payments made by customers.Worked closely with sales and client services to ensure invoices were sent out accurately and promptly.Developed relationships with the customers to increase loyalty and satisfaction.Worked diligently and confidently to collect on delinquent payments.Analyzed A/R data to forecast cash collections monthly.Analyzed client financial statements to determine credit worthiness.

Strategically positioned inventory to quickly and conveniently locate items.Unloading and loading of inventory supply truck. Increased customer service by efficiently loading merchandise into the customer's vehicle, assembling products for the customer, and delivering items to customer's home.Improved marketability by building display models to be advertised in store.

Bachelors, Finance, Accounting, Marketing

Bachelor Of Business Administration Dec, 2009; Finance