Ted Hansen Email & Phone Number

Alpharetta, GA, US

Alpharetta, Georgia

• A detail-oriented and dedicated finance manager with a history of successes in creating operational and reporting efficiencies across various business units. Utilizes a broad-based understanding of myriad reporting.
• Created a billed revenue forecast reporting tool that is central to detailed monthly reporting by segment, customer and product. Reports used by segment planners and various finance organizations across VES include.
• Work with Verizon Enterprises Anaplan team to create requirements for Billed and Booked Revenue Forecast and Billed Revenue Plan models.
• Created model to determine revenue impact of bookings variance to plan using breakage and revenue ramp assumptions by product. Analysis also include a calculation to estimate additional bookings required to hit.
• Manage booked revenue reporting and consolidation, including restatements of baselines, CV and forecasts related to periodic customer level transfers.
• Provide M&A support related to recent divestitures including restatement calculations. Working with IT to create self-service centralized restated results across all Verizon business units that can be used to align.

Greater Atlanta Area

• Directed alignment of financial and operational reporting across various reporting divisions in an enterprise data warehouse used to meet the needs of stakeholders from across the enterprise. Continuously met with.
• Managed creation of data marts include comprehensive detail for various modules, including financial data, purchase orders, shipments, bookings, accounts receivable, inventory.
• Coordinated development of all data mart dimensionality used to create alignment of master data across enterprise, most recently customer and vendor groupings to determine top customers and vendors.
• Worked with various ERP teams across the enterprise (SAP, JD Edwards, MAPIX, Lawson) to provide increasing detail as requirements become more complex.
• Collaborated with all stakeholders (executives, SMEs and IT teams) to determine effective execution of new solutions.
• Directed and tested calculation of currency rates and line item currency conversions in financial statements (in Hyperion Enterprise) and OLAP cubes.

Greater Atlanta Area

Served as primary liaison between expense accounting and the IT team in charge of SAP, Essbase, and other Hyperion related reporting. Drove efficiencies through change in general ledger and reporting systems. Produced network domestic transfer pricing accounting entries to align legal entity expenses to revenue producing entities. Supported automated.

Greater Atlanta Area

Communicated need to executive management and created requirements for Master Data Management (MDM) solution which served as foundation for Verizon Business financial reporting. Enabled MDM to include all facts surrounding data entities such as vendor, GL account, profit center, and company code, as well as centralized management of master data to provide.

Greater Atlanta Area

Managed expense budgeting application for Verizon Business. Oversaw consolidation of revenue and telecommunications budgets. Created analytical scenario in Essbase to align conversion of U.S. dollars to foreign currencies in monthly results. Administered budgeting process using Excel templates, Hyperion EssbaseToolkit, and VBA to automate transfer of data.

Greater Atlanta Area

Maintained contact with key business users to ensure we were meeting their reporting needs. Implemented system enhancements as required by business users. Monitored metadata to understand aspects of reports and queries. Scheduled on-call staffing for nightly loads of data warehouse. Managed data warehouse staff of four. Offered monthly training classes for.

Greater Atlanta Area

Managed Essbase OLAP (Online Analytical Processing) planning and reporting applications for MCI WorldCom with over 200 users system wide. Developed expense budgeting template application used to load budgets into Essbase. Used Hyperion EssbaseToolkit and VBA to automate transfer of data from Excel into Essbase database. Trained planning and reporting.

Greater Atlanta Area

Developed project management application used for maintenance and reporting of commitment authorization requests using MS Access. Worked with field, accounts payable, procurement, and accounting to ensure accurate recording of project related expenses against approved budgets.

Greater Atlanta Area

Developed automated dynamic lease contract application. Created and maintained financial statements using FOCUS. Produced quarterly product line profitability reports. Designed application to calculate lease balances and create lease payment and balance schedules for customers.

Greater Atlanta Area

Analyzed monthly, quarterly, and annual financial statements to identify and document variances to plan. Developed and maintained automated financial reporting systems used for reporting to shareholders, board of directors and management committees

Masters Of Business Administration

Concentration in Information Technology

Bachelor'S Degree, Finance