Ted Hansen

Ted Hansen Email and Phone Number

Manager, Financial Planning and Analysis @ Verizon Enterprise Solutions
Alpharetta, GA, US
Ted Hansen's Location
Alpharetta, Georgia, United States, United States
Ted Hansen's Contact Details

Ted Hansen personal email

n/a

Ted Hansen phone numbers

About Ted Hansen

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 applications to resolve issues and increase efficiency. A highly analytical leader who strives for continual improvement and excellence in the ever changing world of corporate finance.Computer Skills include:Hyperion Essbase, Hyperion Enterprise, , Excel (PowerPivot, PowerQuery, Analysis Toolpack), MS Report Builder, Access, VBA, HTML, VB Script, Oracle, SQL Server, Google Analytics, Informix, Microstrategy, UNIX.

Ted Hansen's Current Company Details
Verizon Enterprise Solutions

Verizon Enterprise Solutions

View
Manager, Financial Planning and Analysis
Alpharetta, GA, US
Website:
vzbiz.biz/3M52BFD
Employees:
16517
Ted Hansen Work Experience Details
  • Verizon Enterprise Solutions
    Manager, Financial Planning And Analysis
    Verizon Enterprise Solutions
    Alpharetta, Ga, Us
    View
  • Verizon Enterprise Solutions
    Manager, Financial Planning & Analysis
    Verizon Enterprise Solutions Aug 2015 - Present
    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 applications to resolve issues and increase efficiency. A highly analytical leader who strives for continual improvement and excellence in the ever changing world of corporate finance.• 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 customer rankings and in-year revenue walks (RunRate, Acquisition, Writedowns, Term/Churn).• 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 full-year plan.• 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 baselines with current results.• Model Verizon Enterprise bookings planning model with GVP push-down.
    View
  • Mueller Water Products
    Sr. Mgr Of Financial Systems And Internal Reporting
    Mueller Water Products Aug 2008 - Aug 2015
    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 executives and business stakeholders to assess current state and delivery of new solutions. Trained user base on how to effectively use data warehouse solutions to drive process improvement and ultimately improve market share.•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.•Coordinated team of stakeholders to evaluate RFP for new consolidation and reporting tool then created capital requests for required hardware and software that included ROI, efficiencies, cost savings and risk avoidance measures.•Coordinated migration of fixed assets from SAP to JD Edwards for various fixed asset schedules.•Developed and maintained controls to ensure data accuracy and SOX compliance.•Generated ad-hoc analysis as needed to support internal customers.
    View
  • Verizon Business
    Senior Analyst
    Verizon Business 2005 - 2008
    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 applications for treasury and accounting departments.
    View
  • Verizon
    Business Analyst - Enterprise Business Intelligence
    Verizon 2004 - 2005
    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 integration with all applications, data sharing, automating workflow, improving reporting and analysis, and placing management of master data strictly into hands of business users owning data.
    View
  • Verizon
    Budgeting Systems Coordinator - Expense Planning And Analysis
    Verizon 2001 - 2004
    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 from Excel into Essbase database. Directed Essbase data transformation and loading, dimension building and calculation scripts using UNIX shell scripting, Essbase EssCommand scripting, Essbase MaxL scripting, MS Access macros, VBA, and Essbase API.
    View
  • Verizon
    Data Warehouse Manager
    Verizon 1999 - 2001
    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 users to understand and utilize web-based Microstrategy reporting application, as well as managed helpdesk. Managed migration from Informix to Oracle for traffic, billing revenue, and data circuits data warehouse applications.
  • Verizon
    Systems Administrator
    Verizon 1996 - 1999
    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 analysts on Essbase reporting systems. Created dynamic SQL headcount reporting application in MS Access.
  • Verizon
    Senior Analyst
    Verizon 1995 - 1996
    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.
    View
  • Bank Of America
    Senior Accountant
    Bank Of America 1993 - 1994
    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.
    View
  • Bank Of America
    Reporting Analyst
    Bank Of America 1990 - 1993
    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
    View

Ted Hansen Skills

Process Improvement Accounting Financial Reporting Budgets Project Planning Financial Analysis Management Internal Controls Access Business Process Improvement Auditing Forecasting Sarbanes Oxley Act Business Analysis Leadership Strategic Planning

Ted Hansen Education Details

Frequently Asked Questions about Ted Hansen

What company does Ted Hansen work for?

Ted Hansen works for Verizon Enterprise Solutions

What is Ted Hansen's role at the current company?

Ted Hansen's current role is Manager, Financial Planning and Analysis.

What is Ted Hansen's email address?

Ted Hansen's email address is ha****@****cts.com

What is Ted Hansen's direct phone number?

Ted Hansen's direct phone number is (770) 206*****

What schools did Ted Hansen attend?

Ted Hansen attended Georgia State University, University Of Tennessee, Knoxville.

What skills is Ted Hansen known for?

Ted Hansen has skills like Process Improvement, Accounting, Financial Reporting, Budgets, Project Planning, Financial Analysis, Management, Internal Controls, Access, Business Process Improvement, Auditing, Forecasting.

Not the Ted Hansen you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.