Reporting and Data Analyst
Resume:
Gregory T. Mitchum
**** **** *** **., *******, VA 22033
***.*******.*******@*****.***
https://www.linkedin.com/in/gregory-mitchum/
SUMMARY
A highly motivated, successful team player with over 15 years of experience in finance, accounting, FCC tariffs, corporate contracts, and cost auditing within the telecommunications industry. Has a demonstrated history of excellence through dynamic leadership, strategic planning and process improvement. Possesses strong interpersonal and technical skills necessary to create innovative solutions to complex problems.
WORK EXPERIENCE
Data Analyst American Red Cross (Contracted by Adecco)
September 2017
Key Responsibilities
Primary role was to support the disaster relief efforts of hurricanes Harvey and Irma
Created templates of relief workers to upload in SharePoint
Prioritized care tickets and settings in SharePoint to aid relief workers
Created and maintained spreadsheets of zone coverages in order to save future employees time in maintaining the SharePoint site
Worked with internal developmental teams to increase employee productivity in the organizations databases
Data and Reporting Analyst- National Reporting and Metrics Charter Communications (Formerly Time Warner Cable)
February 2011 – May 2017
Primary point of contact for reporting needs and statistical analysis for the Time Warner Cable national and regional sales support teams.
Key Responsibilities
Provides statistical data to Sales and Customer Service Managers to support their Quarterly Business Reviews (QBRs) for Regional and National customers
Creates executive level performance reports on group level and department statistics
Recommend, create and track key performance indicators for process improvement
Track various channel growth in order to accurately forecast staffing needs
Identifies potential improvements in current reports, including source data elements, data base structure, data management, data retrieval and supporting applications
Create, maintain and update various data sources for departmental/management use
Works with project managers and business intelligence teams to build out reports for company wide use
Performs ad hoc projects and reports in accordance with business needs
Created automated reports in Salesforce for team members
Worked with team members to ensure the data integrity in Salesforce and internal databases
Telecommunications Billing Analyst Time Warner Cable (Contracted by AppleOne)
October 2009 – September 2010
Primary point of contact for Enterprise Customer Care telecommunications finances, supporting the business unit’s off-shore call centers. Secondary responsibility was to provide informational support regarding vendor data to various internal departments.
Key Responsibilities
Created monthly Telecom accruals for business unit using historical trends, forecasts as well as real time costs and expenses billed in arrears
Managed and audited multiple Telecom AP accounts to ensure costs did not exceed budgeted amounts
Responsible for performance reporting to internal managers and directors to ensure offshore vendors comply to company standards
Resolved financial and contractual issues, processed expedite charges, labor hours, cost adjustments, and tracked issues related to the adjustments and ancillary charges
Tracked telecom usage/services and performed trending analysis to ensure costs are under budget and the following years budget will be submitted properly
Senior Network Cost Analyst Transaction Network Services
April 2000 – July 2009
Member of the Accounting and Finance team that’s main function is to receive, audit and approve telecom expenses. Developed and demonstrated accounting and technical functions to aid to TNS’s best practices. Proven knowledge of IXC, LEC, ILEC circuits costs at multiple bandwidths, 800 and 950 traffic, IVR costs, LIDB, CNAM, LCR, DBUs as well as tax exemptions, USF and FET.
Key Responsibilities
Managed multiple vendor accounts exceeding $15M annually
Reduced billed expenses by at least $100K annually by identifying cost savings through:
Incorrect wording or application of pricing within vendor contracts
Misapplication of pricing billed in accordance with FCC Tariffs
Erroneous pricing sent via email price quotes/correspondence or online pricing tools
Negotiated with vendors in accordance with contracts, price quotes or tariffs to close out financial disputes
Set up account/service with billing vendor, including assigning costs to appropriate departments for proper cost allocation
Analyzed company network invoices to ensure accuracy and adherence to either contract, tariff or price quotes
Assisted with the development and maintenance of company cost schedules
Assisted management with the month end/quarter end/ year end close as needed helping to identify any erroneously accrued items and services
Worked with internal groups such as sales, legal, provisioning and engineering to rectify billing/setup issues as well as to prevent future occurrences of ordering/design errors
Tracked telecom usage/services and performed trending analysis to ensure budget costs are maintained and the following year's budget is submitted properly and in accordance with company policy and standards
Access Cost Administrator Transaction Network Services
Provided accounting and technical services for the Finance and Accounting AP team. Developed and demonstrated accounting and technical functions to aid to TNS’s best practices.
Key Responsibilities
Created and maintained financial reconciliation spreadsheets for reporting to Senior Level Management
Worked in cooperation with internal departments to resolve charge and hardware disputes
Analyzed network history to ensure functions charged correctly
Tracked telecom usage/services and performed trending analysis to ensure costs are under budget and the following years budget will be submitted properly
Assisted with the development and maintenance of company cost schedules
Responsible for weekly data push to ensure that all employee entered telecom payables accurately transferred over to the company AP system in order to ensure an accurate check run
Contract Analyst AT&T (Contracted by Virtual Corp)
January 2000 – March 2000
Provided Stage 1 billing implementation and setup for contracts pertaining to new customer services as well as existing contracts.
Key Responsibilities
Analyzed and assessed validity of customer network contracts
Resolved contract level disputes with various billing departments
Applied contract level terms to customer billing database
Researched contractual specifics concerning network components to provide accurate information to requesting parties
Maintained database to ensure billing accuracy
Accounts Receivable Associate PSINet (Contracted by Advantage Human Resources)
August 1999 – January 2000
Key Responsibilities
First level contact for customer related billing disputes, delegated appropriately
Responsible for entering cash receipts and posting credits/debits to the correct accounts
Responsible for the approval or denial of upgrades on current accounts to sales by researching customers account status and payment abilities
Researched and analyzed customer billing and payment history for sales representatives as well as made recommendations to collections department based on those findings
SOFTWARE/HARDWARE EXPERIENCE
Remedy
Verizon Enterprise Center (VEC)
MS Excel, Outlook, Word, PowerPoint and Access
ACES (Access Cost Engineering Systems)
MARS Business Intelligence
AVAYA CMS Supervisor
Microstrategy/Caremart
Salesforce
SharePoint
Contact this candidate