Financial Analyst Accountant
Resume:
Sydney Atkinson
Austin, TX 78717
***************@*****.***
Accountant financial analyst Operations Support
Financial Reporting Reconciliation Process Improvement
Experienced financial accountant and analyst with a demonstrated history of working in the private, non-profit, and government industries. Whether working individually or collaborating with teams, I am an innovative problem solver, whose skills include analyzing general ledger accounts, testing compliance requirements and internal controls, and preparing audit reports and financial statements.
Core Competencies
Financial Analytics
Accounting
Bookkeeping
Decision Making
Budgeting and Forecasting
Customer Service
Cost-Benefit Analysis
Utility Ratemaking
Financial Planning
Education
General Assembly, Austin, TX, July 2020
Data Analytics Intensive Bootcamp
Temple University Fox School of Business, Philadelphia, PA
Bachelor of Business Administration: Accounting, 2008
Professional Experience
City of Austin Public Works Austin, TX 2019 – Present
Financial Analyst IV
Develops and prepares reports, analysis, and models used in revenue and economic forecasts and budgets
Prepares complex financial analysis, periodic and ad-hoc reports by researching financial information and data, reporting on variances, and compiling financial information from various financial systems.
Cost of Service rate studies and structure recommendations
Develop and maintain financial dashboard in Power BI for monthly Transportation User fee revenue trends
Report monthly gross margin forecasts and presentation to senior management
Austin Energy, The City of Austin, TX Austin, TX 2017 – 2019
Accountant III
Compile monthly financial reports by analyzing routine internal and external financial documents, supporting schedules and financial reports to ensure accuracy; researching, compiling, monitoring, and summarizing current and historical financial and budget information and data; and reporting on financial and budget condition and trends.
Develops components of the utility’s cost of service studies and rate analyses.
Provides analysis of utility customer characteristics, usage patterns, seasonal trends, and cost of service impacts.
Compiles financial data for corporate sales tax payments and process improvement to comply with state government requirements.
Prepare complex audit work papers for annual or special audits according to GAAP and SOX. Provides explanations to auditors of City policy and procedures and responds to questions and requests for information in a timely and accurate manner.
Reports monthly utility financial usage data for all city departments and provides further financial analysis on utility accounts
Prepares and provides information necessary for the preparation of the City's annual financial report (CAFR) and Official Statements.
Austin Energy, The City of Austin, TX Austin, TX 2013 – 2017
Utility Financial Analyst
Troubleshoot financial data integration between Storms, Maximo, Power Plan, and AIMS. Monitor application data validation standards in accordance with FERC Utility reporting requirements and GAAP
EAM Application functional support
Document system configuration, business requirements and processes for multiple departments
Provide training for over 750 Maximo users to ensure procedural compliance.
Collaborates with AE IT Service validation/ Testing department on system requirements, functional specification, & test strategy for upgrades to diverse EAM software
Led User Acceptance regression testing and Analytics module implantation for Powerplan Software upgrade
Serve as financial liaison to and interact with IT, Material Planners, Project Managers, and AE budget staff to aid in managing and monitoring O&M & capital projects as well as safeguarding the data in production environments.
Partners with vendor-enhanced support to expedite any technical issues specific to EAM software
Collaborated with an interdisciplinary team to assist with the development of integrated revenue/expense analyses, projections, and reports
Accountant (Temporary): 2012-2013
Skillfully unitized over $3M in assets backlogged for multiple years by creating, pricing, and tracking units in multiple work management systems
Research and query capital and operation expenses incurred by Austin Energy in compliance with FERC financial reporting requirements
Recommended financial actions by analyzing and researching accounting options and utilizing knowledge derived from auditing and bookkeeping operations
Aspyr Media, Inc. Austin, TX 2010-2012
Staff Accountant
Prepares and processes monthly royalty calculations in accordance with contract terms
Monitored asset, liability, and capital account entries by compiling and analyzing account information
Effectively summarized financial status by collecting information, preparing balance sheets, profit and loss statements, and maintaining depreciation and amortization schedules of tangible assets and intellectual property
Disseminated monthly financial statements to key stakeholders to inform financial business standings reports
Completed & successfully submitted video game publishing grant applications with the Texas Film Commission
Splashlight, LLC New York, NY 2009-2010
Staff Accountant
Supported financial operations of accounts payable/receivable, month and year end account reconciliations, asset management, and financial reporting
Efficiently processed payroll for company subsidiary by receiving and verifying expense reports and requests for advances and preparing disbursements
Employed competencies in research and analysis to answer any accounting procedure questions regarding accounting policy and regulation
Ehrenkrantz, Eckstut, and Kuhn Architects New York, NY 2008-2009
Staff Accountant
Managed all accounts payable responsibilities including payroll processing, scheduling and preparing vendor payments, and reconciling processed work as well as supported general administrative operations
Notably ensured compliance with federal, state, and local financial legal requirements by studying existing and new legislation and enforcing adherence to requirements
Executed monthly bank reconciliations for various accounts and reconciled financial discrepancies by collecting and analyzing information
Additional Credentials
Technical Skills
Affiliations and Activities
Microsoft Power BI
Tableau
Oracle CC&B
Microstrategy
Powerplant by PowerPlan
IBM Maximo EAM software
STORMS WM software
Advantage 3 financial software
Microsoft Great Plains
Quickbooks
Advanced knowledge of Excel
Knowledge of utility ratemaking methodology
Cost-benefit analysis
Treasurer Capital View Arts 2017-Present
Mentor The Seeding Foundation 2017-Present
Treasurer Austin Area Urban League Young Professionals 2014-2016
Mentor Big Brothers Big Sisters of Central Texas, Fall 2010-2014
Junior Achievement, Austin, TX, Fall 2013
References: Available Upon Request
Contact this candidate