Collin Browning Email & Phone Number

Cincinnati, Oh, Us

Cincinnati, Oh, Us

Bologna, It

Bologna, It

At Coesia, I work as an FP&A Analyst for North America & Mexico. In my current position I am responsible for forecasts, budgeting, financial analysis & financial reporting for all Coesia businesses within our region.• I am responsible for end-to-end financial planning, which includes working with business leaders and executive management• Created financial models to analyze financial performance and KPI analysis utilizing IBM Planning Analytics as a special project from the CFO. Currently this model is being used by the CFO/CEO for monthly review with all business units• Lead the monthly/quarterly/annual reporting process, which includes developing presentations to report to Italy, analyzing the data to develop talking points & work on any questions that arise during monthly review meetings.• Obtained my Lean Six Sigma Green Belt & completed projects uncovering cost savings in Travel & Freight costs, directly improving our Indirect Cost. Currently I work closely with the Operational Excellence team in Italy to implement projects/analysis for the North American businesses.• Lead the monthly financial reporting process. Working with our Finance Director & Company Controller, I ensure accurate financial statements are reported to Coesia Executive Management.• For 2021 I developed a company scorecard that analyzed the movement from Budget, Q2 Forecast, Q3 Forecast, Q4 Forecast and 2021 Actuals. This was used by the Coesia America’s CFO & CEO to present 2020 results to the Coesia CEO.• Develop annual budgets, monthly/quarterly forecasts working with our CFO & individual company controllers• I am also responsible for monthly sales, COGS & margin analysis.• Work with all companies located in other countries (Sweden, France, Italy, etc) who have North American operations.• Led a project to analyze Shared Service costs & the impact that a change in cost basis vs. change in allocation % would have on companies that Shared Services serves.

Cincinnati, Ohio, Us

Working for this Utility company, I used my finance & accounting skills to manage the finance & accounting of a roughly $25mm annual budget.• Creating and analyzing financial models for various uses, such as: electricity usage models, cash flow forecasts, profitability studies, rate studies, capital investment budgets and any other ad hoc reports needed• Oversaw and managed a successful ERP system implementation• Developed monthly report to analyze kWh usage & demand, how it was affected by weather/customer count/time of year, and then used that data to improve our revenue forecasts and budgets.• Completing the monthly/quarterly/annual financial reporting package for the Board & Reporting Agencies• Development & analysis of the operating budget through analyzing utility rate tariffs, working with department heads to prepare a budget, and then report monthly to the Board on the variance to budget reports• Development of the Cash Flow Forecasts, ensuring adherence to our Cash Reserve Policy and then reporting the results to the board on a monthly basis. • I am responsible for reporting results monthly to the Board, as well as working with executive management on developing presentations for the meetings• Developing monthly variance analysis reports for each of our utilities; Electric, Water, Wastewater• I am a regular attendee at industry training/events to make sure current events in the utility industry are correctly accounted for in our forecasts

• Perform financial and compliance audits on entities that receive Federal, State, or Local Funds• Use predictive analytics, forecasting, and other data analysis to perform analytical reviews of various aspects of the entity being audited• Ensure application of applicable laws and regulations to transactions and specific programs• Work with a small audit team to formulate and complete an audit plan with limited oversight• Create relationships with officials and governance at the auditee to ensure the audits are able to be performed as efficiently as possible• Preparation of work papers using advanced Microsoft Excel processes to detail and perform audit procedures for testing

• Complete and File Annual Financial Report• Complete and File Annual Budget for all Departments• 100-R Annual Report• Complete Redevelopment Commission Annual Financial Report• Year End and Monthly Bank Reconciliations and Close Out• Financial Condition Analysis Reports• Provide Quarterly/Biannual/Annual Reports to City Council, Department Heads, and Local News Media• Aurora Recreational Community Center Budget Analysis and Financial Reporting• Investment Analysis and Planning• Revenue Projection and Analysis• Audit Preparation• 5 Year Capital Improvement Plan• Weekly Payroll• Spreadsheet Formulation for City Use

Bachelor’S Degree, Finance

Associate’S Degree, Accounting