Bike

Lifestyle

Outdoor

Tech

Home improvement

Travel

Investing

Prototyping (arduino

Raspberry pi)

Auotmation (e.g. smart home

Data flow)

Electric vehicles and aircraft

Sr FP&A/IT Manager

Top Management

?	Maintained an extremely complex operating model used to create a base 5-year operating plan, O&M budgets, Capex budget, create and enforce contract covenants, and communicate ongoing plans with key stakeholders including VC leadership
?	Created GL analysis tool with simplified data import process to expedite the month end process and create dashboards and a financial reporting package
?	Worked with CFO, cost analyst & CPA firm to complete a massive cleanup process of prior years’ poor accounting practices
?	Regularly met with and reported to the CEO & Chairman of the Board to determine overall direction/strategy and next steps in creation of our business model and capital expansion plan
?	Chose and implemented a cloud hosted, a-synchronous input database system to allow for collection of statistical and ops data that could not be managed in our ERP (QuickBase)
?	Streamlined data collection from varied sources in disparate formats into usable, actionable insight for C-suite leaders using QuickBase. Allowed for operational analysis that led to outsourcing of harvesting activities & a 50% reduction in material cost
?	Partnered with executive management to provide data and financial analysis for greater insight into management decisions
?	Assisted with planning process to build 2 new mills over a 1.5-year timeframe (300% growth in production capacity)
?	Set business unit KPI’s as well as contract covenants for incoming M&A partner
?	Created dashboards for internal reporting & managed regulatory reporting to the USFS
?	Implemented new fixed assets management and depreciation system (Sage Fixed Assets)
?	Created reporting tools for staff in field to report statistical data to analyze financial performance & KPI’s for greater insight
?	Created IT department and all P&P’s
?	Initiated first IT security protocols in company history including a sophisticated UTM package (Sophos UTM) and NGFW
?	Migrated all company servers to the cloud & email solutions to MS 365 which resulted in a significant reduction in cash outlay and improvement in flow of information and data retention
?	Security Management practices prevented significant damage from a dangerous breach in 2019

? Regularly created, maintained and distributed dashboards in excel using VBA and simple SQL queries to report to the board of directors, the executive management team, directors and individual department heads.  Analyzed monthly results to highlight areas of achievement or concern in financial review meetings
? Regularly analyzed financials and reported to DOF and CFO
? Developed and maintained detailed rolling forecasts for 17 legal entities across multiple states
? Created and maintained complex financial models in Excel for 17+ entities and 3 different obligated groups
? Managed the capital and $250MM annual budgeting process for all entities and business units.  Collaborated with BU leadership and acted as bridge between technical and non-technical staff.
? Created multi-year projections with what-if scenarios and variable assumptions and drivers for 17+ entities and potential projects
? Produced annual financial reports (consolidated and individual) using Dynamics SL, Adaptive Insights and Excel and handled state reporting requirements for the Arizona Department of Education
? Created a data warehouse to enable the Chief Academic Officer, Director of Academics and the Principals to monitor and improve academic performance in order to improve our state rating and bond rating
? Worked with C-level executives on analytical projects to create a platform for business decisions and performance management
? Assisted in issuing over $100MM in bonds for multiple obligated groups, including creation of bond work papers
? Created ad hoc analysis on both financial and non-financial data as requested by Directors to support strategic decision making
? Found, vetted, and lead implementation of new FP&A software (Adaptive Insights)

Financial Analyst

Four Points by Sheraton at Phoenix Mesa Gateway Airport
? Managed accounts receivable for the property
? Opened new property and established SOP's and systems that created an efficient interdepartmental line of communication
? Managed all group billing, deposits and invoicing and achieved 100% Aging every month
? Responded to all guest and group billing enquiries in a timely and efficient manner
? Created and managed vendor's within Birchstreet P2P system, including applications for direct billing credit accounts
? Assisted Accounting Manager in all accounting duties as required by Starwood policies for segregation of duties

Accounting Generalist/Accounts Receivable Agent

? Audited & analyzed all revenue streams and ensured all Starwood corporate and GAAP policies regarding income were followed
? Maintained general ledger accounts on a daily basis using Excel and SAP and created reconciling journal entries
? Participated heavily in monthly close process and reconciled assigned accounts
? Automated reporting processes using MEE automation software which resulted in a decrease in necessary man hours by 40 hours per month, as well as a significant decrease in paper usage
? Generated and analyzed financial reports and reported to Executive Committee to ensure accounting accuracy
? Trained a new auditor and monitored their progress and work

Income Auditor

Find out detailed information about Josh Ray, Sr FP&A/IT Manager in Mesa, AZ

Josh Ray: Sr FP&A/IT Manager in Mesa, AZ

Josh Ray

W.P. Carey School of Business, Arizona State University