Sales Analyst

Alda Williams

**** ******** ******* #*

West New York, NJ 07093

Mobile: 904-***-****

************@*****.***

Employment History

Financial Analyst, Horizon Media, Inc., New York, NY (April 2010 - Present)

. Works on team of 3 to manage monthly sales revenue reporting,

forecasting, and expense variance analysis for $2B privately held

media buying agency

. Analyzes monthly sales variances to determine shifts in revenue and

correct sales team forecasting errors

. Investigates changes in monthly sales team forecasts

. Collaborates with HR and Payroll to administer company Time Tracking

system

. Completes weekly and ad hoc reporting on employee time spent working

on various clients

. Codes expense invoices for A/P department

Financial Analyst, Starwood Vacation Ownership, Orlando, FL (March 2009 -

January 2010)

. Worked on team of 8 to manage annual budgeting, monthly P&L,

forecasting, expense variance analysis, cash flow reporting and

business reviews for 48 entities

. Completed annual $2MM budgeting process for seven groups (zero base

budget broken into monthly and per unit amounts, 150+ line items per

group)

. Forecasted groups' changes in expenditures, revenues, and variance to

budget on a live, daily basis

. Analyzed monthly controllable and non-controllable expense variances;

partnered with resort operations and accounting teams to review

updated contracts, maintenance and construction plans

. Updated monthly Reserve and Operating cash flow reports using

accounting GL; collaborated with Facilities Mgmt to record any changes

in reserve replacement planning

. Conducted monthly business overview with VP of Eastern Operations to

discuss KPIs

. Provided quarterly reports to Boards of Directors reviewing each

group's financial picture (including summary of treasury accounts,

analysis of KPIs, collection rates, year end Operating cash flow

projections)

Volunteer, Duval County School Board, Jacksonville, FL (July 2008 - March

2009)

. Supported Special Education teacher on ad hoc classroom projects

. Designed and maintained class website using OnCourse systems

. Video-taped classroom activities for National Board Certification

process

. Proofread and edited written components of National Board

Certification packet

. Designed and created instructional classroom components and displays

Inventory Yield Management Analyst, Wyndham Vacation Ownership, Orlando, FL

(June 2007 - July 2008)

. Contributed to team of 4 responsible for all aspects of inventory

support for 40+ sales sites

. Created, presented, and updated weekly variance analyses of inventory

sales trends for department VP

. Managed inventory for 11 Western region sales sites, including

providing daily inventory availability, quarterly and demand-based

changes in pricing, monthly updates to legal sales authorizations

. Monitored variances in projected vs. actual sales at each site;

communicated significant changes in pace to management

. Utilized Access databases to analyze significant variances in

projected vs. actual sales on an individual sales contract level

. Maintained pricing models in Excel calculator for all national sales

sites

. Maintained internal team SharePoint website

. Completed ad hoc reporting for internal departments and external

customers, including communicating the number of unsold units for

insurance reporting and coordinating holds on inventory for

reallocation

Education:

B.A. - Economics, December 2006

Florida State University

Minors: Business Administration and Spanish

GPA: 3.66, Cum Laude

Skills & Strengths

. Strong proficiency in Microsoft Office - Excel (including Pivot

Tables, Vlookups, SumIfs, Modeling, Macro editing); PowerPoint

(Linking Tables/Charts, Master Formatting); Word

. Reads, writes, speaks proficient Spanish

Contact this candidate