Jeremy Johnson Email & Phone Number

Baton Rouge, Louisiana, United States

Baton Rouge

Walker, Louisiana, United States

- Created and maintain the Power BI data models that drive financial reporting (income statement, balance sheet, project performance) for the multinational operations. - Drive the monthly financial forecasting process for all US operations. - Work closely with CFO and Accounting Controller to deliver and provide analysis on monthly results. - Provide analysis and KPIs to monthly Board of Directors meetings. - Designed and created process for consolidation of intercompany transactions and activities. - Manage cash flow forecasting and accounts payable

Baton Rouge, Louisiana, United States

-Responsible for forecasting, tracking, and accruing revenue and expenses for six commercial insurance sales branches across the United States with annual revenue of $80MM-Drove the creation and implementation of a monthly forecasting model which is used by multiple finance teams to project approximately $50MM in revenue each month across multiple regions and branches.-Advanced user of Power Query (M), Power Pivot (DAX), and the Microsoft Tabular Object Model-Gather, organize, and analyze data from disparate sources to derive strategic insights and key business drivers related to the branch offices. Communicate findings with the CFO and regional managers to implement change and help align with company targets.

Baton Rouge, Louisiana

-Served as a Scrum Master on a large data warehouse implementation project. Facilitated agile ceremonies (planning, retrospective, daily scrum, etc.) and championed process improvement for three data warehouse development teams. My goal was to keep the teams focused on delivering software with high business value while constantly inspecting and adapting processes to become more efficient. Delivered weekly presentations to project teams and senior management to report on team progress and deliverables.-Developed an economic model used by a government agency for forecasting and calculating business tax incentives.

Baton Rouge, Louisiana

-Served as a Certified Fraud examiner on the Restore Louisiana Homeowners Assistance Program. Investigated and documented hundreds of fraud allegations involving both applicants and employees. Created and administered a Microsoft SharePoint site which served as the central tracking mechanism for all fraud related issues, process documents, and tools.-Calculated business loss valuation claims for the Deepwater Horizon Economic and Property Damages Settlement. Analyzed accounting data, financial trends, anomalies, and forecasted profits within various financial models. I was the project wide subject matter expert for auto dealership and commercial rental businesses. I delivered training and codified project policies related to these subjects

Baton Rouge, Louisiana