Andrew P. Profile

ESPLORA

0,0

(0 valutazioni)

Stai seguendo

Impossibile seguire l'utente.

Questo utente non consente agli altri utenti di seguirlo.

Stai già seguendo questo utente.

Il tuo piano di abbonamento ti consente un massimo di 0 segui. Cambia abbonamento qui.

Non segui più

Impossibile non seguire più l'utente.

Hai consigliato .

Impossibile consigliare l'utente.

Si è verificato un problema. Aggiorna la pagina e riprova per piacere.

Email verificata.

$25 USD / ora

roberts,

united states

$25 USD / ora

Attualmente sono le 4:19 AM qui

Registrato il ottobre 28, 2015

0 Consigli

Andrew P.

@apierson0

0,0

(0 valutazioni)

0,0

$25 USD / ora

roberts,

united states

$25 USD / ora

Lavori completati

Nel budget

Nei tempi previsti

Tasso di riassunzione

Excel Data Analyst

I have worked corporate positions for high end data analyst work including creating functioning spreadsheets used on a national scale.

Vedi tutti i Data Processing Executives in United States

Contatta Andrew P. per il tuo lavoro

Accedi per discutere i dettagli via chat.

Portfolio

Basic manual entry with accuracy and titles.

Basic Data Entry

This spreadsheet is an example I created to show daily goals and updated results for retail stores in an entire district. Each store number can be located in each graph, table, and in their own tab. They each have their daily and ending results, then are shown in the main district daily summaries.
The data shows each of the stores final daily results. These results are as follows:

UP (how many phones were sold as an account upgrade.)
Act (phones sold as a new line or new account.)
Lease and IB (phones sold with a payment plan of lease or installment billing.)
Phone Points (if a retail store has a certain point goal to hit or another variable.)
ACCY (accessories sold total.)
Dollars per phone (accessory dollars per handset goal.)
Breakdown of other non-cell phone devices (tablets, home phones, hot spots, pre-paid, and repurposed.)
Insurance Plus (insurance added, opportunity of insurance could be added, and insurance add percentage on all devices.)

Retail Cell Store Regional Tracker

This is a small example of a basic pivot table function. In this case, the function shows which reps have open and closed Purchase Orders as well as a graph for viewing purposes.

Pivot Table and Simple Graph

This is an example of easy scheduling for day to day meetings, training, activities, and more for administrative tasks.

Select the drop-down name and drop-down Meeting they would like to attend to book them.

This can be updated to any format for anyone's needs.

Automatic Forms

Introduction
This graph example shows detailed information about daily scheduling for a department. In this example, the departmnet is for a call center, and their coverage for customer phone calls.

Data
Staff - available to take calls
OT Workers - those who came in for overtime to help handle coverage.
Lunch
Breaks
Supervisor Meetings
Team Meetings
Sick - agents who calling in sick that morning.
Calls Forecasted - This line doesn't indicate the amount of actual calls, but the amount of agents we need to handle the forecasted amount. For example, if we have 100 calls an hour, and the average handle time is 5 minutes and 30 seconds per call, we would need 19 available agents for that hour.

Goal
The goal of this graph is to move scheduling and shift coverage to insure all calls are being answered with the lowest call hold times. Agents and Overtime Agents are scheduled in blue, so the call center will attempt to keep the Calls Forecasted line in that range.

Detailed Graph

Basic Data Entry

Retail Cell Store Regional Tracker

Pivot Table and Simple Graph

Automatic Forms

Detailed Graph

Valutazioni

Modifiche salvate

Nessuna valutazione da vedere qui!

Esperienza

Sleep Number

gen 2014 - giu 2017 (3 anni, 5 mesi)

● Responsible for analyzing call volume data for the Customer Service department to forecast future estimated calls and staff accordingly. ● Manually created, updated, and inserted data hourly on multiple advanced spreadsheets. ● Knowledgeable in Excel, Word, Aspect, Workforce Management, Empower, and many other business operating systems. ● Analyze average handle times, hold times, call times, and other stats to evaluate agent scorecards.