Amanda Beckham, Mba Email & Phone Number

Batavia, Illinois, Us

Chicago, Il, Us

• Develop and conduct short-term and long-range business planning. Conducting complex A/R and Bad Debt modeling, forecasting, trending, variance analysis, business case development, and other financial and operational analysis. Providing broad analytical and operational support to the business unit. Finished the year $11.8M favorable to bad debt target set in 2022 and $12M favorable for 2023.• Created a new financial model to reflect new bad debt methodology utilizing average customer balances and risk assessment ranking. Collaboration with accounting to align and streamline new process.• Served as internship lead for summer interns, managed their workload and professional development for duration of their time.• Develop, organize and present detailed analyses related to the business scorecard and key performance indicators for both internal and external use utilizing VBA and advanced Excel skillset.

Chicago, Il, Us

• Managed financials processes for the energy efficiency (EE) programs specializing in delivering EE recommendations and measures. • Responsible for the development and implementation of a financial business plan for each assigned program. Emphasis on achieving overall savings goals, providing integration with other program offerings.• Provided support to the EE Program Managers in the areas of budgeting, forecasting, performance reporting, and other requirements as identified with the use of advanced Excel formulas for streamlining and simplification to help monitor progress toward program performance and financial goals.

Chicago, Il, Us

• Responsible for the accurate short- and long-term forecasting, reporting and analysis of several ComEd Consolidated income statement and balance sheet items. Reconcile financial systems ensuring data aligns across Hyperion and HSF. • Prepared month-end, quarterly, full-year, long-range reports (financial close package, scorecard and financial performance indicators, key management meeting presentation, Board of Directors presentation). • Partnered with leadership from various functions to discuss potential risks and opportunities to full-year operating earnings and how to concisely message these items in Corporate and Exelon Utilities reporting. Managed cross-functional effort to consolidate key financial data to support CEO/CFO quarterly financial reviews.

Chicago, Il, Us

• Prepared the month-end, quarterly and full-year forecast/reports for the Operations Admin departments, including: journal entries, account reconciliations, vendor rebates, joint work agreement billing, and management of the LE. Ensured that forecasts were properly reflected in planning tools while working with financial systems team to mitigate/resolve forecasting and planning concerns. Regular use of the WPT system, EPS, Asset Suite, General Ledger, Hyperion, SmartView, Microsoft Access and other financial systems of ComEd.• Assisted in preparation of various reports and data requests, answering ad-hoc requests for internal customers. Providing key input to reporting packages such as the monthly financial reporting deck, quarterly management meeting presentation, and annual budget planning models to support the current five-year long-range plan. • Created and maintained access database utilized for identifying costs considered “below the line” that would not be reimbursed. Utilized querying skills and SQL to automate monthly process updates.

Oak Brook, Il, Us

• Analyzed customer data to identify margin, on time performance, and financial trends, positively impacting account margins, growth of volume, and customer satisfaction. Proven success in proactively identifying root cause analysis of issues and innovative solutions utilizing programs such as Tableau and Business Objects (SQL queries).• Organized and conducted meetings while creating action plans and standard operating procedures through multi-departmental collaboration including upper management. Managed top strategic accounts by growing relationships and identifying areas for continuous improvement.• Served as internship lead for summer interns, managed their workload and professional development for duration of their time.

Bourbonnais, Illinois, Us

•Developed and implemented new swim lessons program from the ground up. •Coordinated instructors and schedules while managing customer service and administrative tasks. •Trained swim instructors on various strategies and age appropriate techniques to effectively teach swim skills for each level.

Bourbonnais, Illinois, Us

• Assisted professors in the Department of Mathematics and graded homework assignments and tests in a timely manner with accuracy. • Held tutoring sessions throughout the week and assisted students that needed extra help with mastery of course material.

• Assisted students in all areas of mathematics ranging from Pre-Algebra through Calculus II. • Assessed students’ understanding of mathematical concepts, identified the areas in which they struggled, and effectively communicated concepts in a way they could better understand.

Master Of Business Administration - Mba, Leadership Concentration

Bachelor Of Science (B.S.), Actuarial Science