Analyst

Website: www.linkedin.com/in/eric-davis-*ab**a***

Email: ************@*****.***

Live: West Bend, WI

PROFESSIONAL SUMMARY

Seeking to gain experience and use acquired employee and academic knowledge to fulfill any related position. Hardworking and dedicated worker looking to help achieve company goals.

EDUCATION & AFFILIATIONS

Bachelor’s Degree in Business Administration – Finance

University of Wisconsin-Whitewater

Graduate: May 2020

INVOLVEMENT

-American Marketing Association (AMA) and Institute Management Accountant (IMA) – Treasury Assistant

-Community Service

oSome of the group members from the American Marketing Association including myself took a trip to Janesville to discuss what the EnviroScope Model represented.

oTaught a group of kids about the effects on where our running water is going too, the pollutants that carried away, and where it all ends up.

SKILLS

Advanced Microsoft Excel User- Pivot Tables/VLOOKUP, template creation, data analysis/visualization

Accounts Payable/Accounts Receivable, Access, PowerPoint, Spreadsheets, Oracle

Multitasking, Presentations Skills, DCF Modeling, Cash Flows, AS400, Procore, GC Pay

SQL, QuickBooks, Payroll Processing, Invoice Processing, Oracle, Basic Knowledge (Python)

Desi Production, ERP Systems, SAP, Process Improvement, Ad-Hoc Analysis. Financial Analysis (NRR. IRR, ROI), JD Edwards,

PROFESSIONAL EXPERIENCE

Billing Analyst Intern April 2019-December2020

TDS Telecommunications

Support billing activities such as entering critical billing data into customer accounts (Zolo Billing)

Prepare billing invoices for customers (Zolo Billing)

Creating Excel Spreadsheets for my recurring task.

Working with Data Management Team. (BillProd (a system that tracks down customers’ minutes of usage) and sending invoice copies to customers.

Creating new process documentations for the upcoming interns.

Intermediate knowledge on SQL Developer

o Looking for active customers who would receive a discount promotion of $10.00 before Feb 21,2019.

oFixing a multiple SQL queries for a new task that would be assigned to the interns.

oCreated a SQL query for FCC pledge Insights (COVID-19 LATE FEE CREDIT)

I worked on two projects for my boss called “Bill Presentment and Credit & Banking Fees.

oIn Excel, I made 5 different graphs (histogram, bar chart, line graph) for both projects.

oThe main reason for this task is because our company is spending over 2 million dollars sending invoices to customers electronically and we need to find a better way of doing that. So, by making these graphs, it can give us a better indicator about what we should do going forward.

I have 4 recurring task that affects the Zolo Reconciliation, which is the adjustment summary, prepayment summary, Zolo Month End AR Report, and Invoice Summary. Based on these recurring tasks, I’m creating multiples pivot tables and doing a VLOOKUP as well. The main proposal for this task is because I want to find out the reason for Wide Orbit and Novar being off.

Utilizing SharePoint to create a workflow for the interns’ project tracker, so it wouldn’t surpass the 5,000 limits.

Creating Marcos for some of my recurring task to minimize the time

Use the GetPivotData for the Zolo Reconciliation that I do at the beginning of the month.

Wrote a Python Script for one of my recurring tasks called “Invoice Count”.

Collected customer call records from 2011-2019 for Subpoenas for the Crestview and K2 conversion.

Update the thresholds for CABS Access Billing touching 4,142 screens of data.

Utilized various data driven software system such as Oracle & SAP.

Accounting Intern May 2018-May 2019

Diversified Building Maintenance

Processing transactions, issuing checks, updating ledgers, budgets, and journal entries, and credit memos.

Most of my assignments were worked through QuickBooks: Accounts Receivable, Accounts Payable, processing Invoice copies, packing slips, entering new employee and client.

I utilized Microsoft Excel to create a template for the job costing at the end of the month.

Performing basic office tasks, such as filing, data entry, answering phones, processing mail.

Made the payroll for all employees on a weekly basis and created the checks as well.

Created the invoices and packing slips through QuickBooks to put on the merchandise so it can be shipped to its current location.

Contact this candidate