Post Job Free

Resume

Sign in

Microsoft Office Financial Analyst

Location:
Lake Mary, FL
Salary:
85000
Posted:
March 25, 2019

Contact this candidate

Resume:

Daniel J Tuttle

*** ********* ***

Lake Mary, FL 32746

678-***-****

ac8wc1@r.postjobfree.com

SUMMARY

I am an accomplished Finance and IT professional with 15 years of experience within the Telecom industry. I take pride in analyzing data and enhancing processes to provide improved reporting to a variety of stakeholders.

EXPERTISE IN:

Reporting from large data sets, queries and data warehouses

Troubleshooting and serving as a liaison for reporting issues & process improvement initiatives

Subject-Matter Expert for Voice Traffic analysis, Revenue & Expense reconciliation, Budget requests & Report analysis

Proficient in the completion of Internal Audit activities and Internal Control testing

Well versed in posting journal entries, as well as the completion of Month-end-Close & Year-end-Close activities

SOFTWARE SKILLS

Microsoft Office Suite, with significant experience in Excel (pivot tables, vlookups,, linking files, formulas), and Access (including database queries and macros),

Oracle (including SQL programming), Hyperion Essbase, Teradata, SQL Server (creating SQL Scripts within the Data warehouse),

SAP (including electronic submission of Journal entries, importing data records)

Peoplesoft (including GL and query tools).

Telarix Voice System and Verizon iVoice.

WORK EXPERIENCE

Verizon, Alpharetta, GA and Lake Mary, FL October, 2004 – December 2018

Access Accounting – Consultant (August 2013 to Present)

Selected to relocate from Alpharetta, GA to Lake Mary, FL as part of the Finance Transformation Initiative.

Completed an IVoice systems project that transferred system procedures to Tulsa Bill/Audit Center. Spent a year parallel testing and troubleshooting various IVoice modules. Project was highly successful as system procedures were removed from Lake Mary Accounting.

Responsible for performing monthly estimates and preparing actual accruals for International voice traffic. This task involves reviewing Revenue & Expense totaling $42+ million, involving 200+ Foreign Traffic carriers.

Monthly responsibilities include preparing monthly journal entries of Revenue & Expense in SAP, as well as reviewing of contracts and rates. As part of these responsibilities, I am involved in developing & enhancing processes, procedures for transactions occurring within Verizon’s iVoice system.

Respond to numerous ad-hoc reporting requests from FP&A team members located overseas. Requests include compiling month over month analysis of International carriers. In this role, I frequently present information to Upper-Level management.

Software used: SAP, Microsoft Office Suite including Access, Voice systems including Telarix and Verizon iVoice.

Verizon Wireless Fraud – Sr. Analyst (August 2012 to August 2013)

Using Teradata SQL, performed monthly and weekly reporting of fraud results by exporting & analyzing information from the Enterprise Data Warehouse. Results were summarized & presented in PowerPoint format.

Using Essbase, exported monthly Capital expenditure data to consolidate information to prepare Budget reports.

Working under tight timeframes, responded to ad-hoc reporting requests by the various Area & Corporate teams.

Software used: Microsoft Office Suite, including Access, Oracle, Teradata, Peoplesoft and Essbase

Verizon Business Consultant – International Telco (October 2004 to August 2012)

Completed monthly reporting of all Latin American products and services, Europe, Asia Pac and Canada VOICE/VOIP/IP services including account reconciliations, and journal entries.

Prepared monthly aging on xxx products & services by exporting data from numerous sources & consolidating results into a uniform report format.

Offered suggestions & provided assistance to less experienced team members in their efforts to develop & enhance departmental reporting needs.

Monthly responsibilities included completing account reconciliations, preparing external reporting requirements, completing SOX testing and responding to external audit inquiries.

Given responsibility to complete several special projects working with multiple stakeholders in Europe, Asia Pac and Canada.

Recognized by Director for outstanding efforts to improve Reporting processes

Software used: Microsoft Office including Word, Excel, Access, PowerPoint and Outlook, SAS, SAP

MCI/WorldCom, Alpharetta, GA & Clinton, MS

November, 1999 – October, 2004

Financial Analyst – Corporate Accounts Receivable (March 2003 to October 2004)

Responsible for reporting for Accounts Receivable transactions for the Consumer, Government, and Educational segments of the business.

Conducted analysis & review of company-wide Accounts Receivable data to prepare financial restatements of 4 prior data to comply with bankruptcy filing.

Member of a team responsible for reporting on Reserve Requirements.

Presented restatement numbers to management and consulting partners.

Software used: Microsoft Office Suite, including Access, Hyperion Essbase, SAP

Restructuring Audit Team Specialist (October 2002 to March 2003)

Hand selected to be part of a core team travelling to Clinton, MS for a six-month timeframe to serve as a subject-matter expert on Intercompany Reporting.

In this role, I was responsible for the development of Reporting of all Inter-company transactions for post-petition bankruptcy filings

Ensured the successful electronic submission of restatement entries were completed in a timely manner

Called upon to present Intercompany transaction reporting to management and consulting partners

Software used: Microsoft Office Suite, including Access, Hyperion Essbase, SAP

QA Report Developer Wireless (January 2002 to October 2002)

Developed and processed weekly audit reports of wireless reseller data including minutes, rates and plans

Developed daily customer status reports of all resellers and reporting any issues to call center

Communicated with resellers and management team of any issues

Received award for development of Customer Status Report

Software used: Microsoft Office including Word, Excel, Access and Outlook, SQL Server

Commissions Analyst (November 1999 – January 2002)

Member of 60 person team responsible for reporting on $6M annually in Commission payments.

Processed monthly commission reports of prepaid calling cards including sales targets and compensation plans

Presented monthly analysis of revenue, rates, minutes, COGS and SG&A, actuals vs plan

Communicated with sales representatives and managers of any compensation/commission issues

Software used: Microsoft Office Suite, including Access

EDUCATION

American Intercontinental University, Atlanta, GA

Masters of Information Technology

Liberty University, Lynchburg, VA

Bachelor of Business Administration (BBA)

Concentration in Finance

TRAINING

Train4Less, Atlanta, GA March 2009-April 2009

Oracle 10g Certified Professional Training

Training includes SQL, PL/SQL, Architecture & Administration, Backup & Recovery, Performance Tuning and Network Administration.



Contact this candidate