Sales Analyst

DAVID M. ZEMAITIS

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

Pittsburgh, PA 15236

Work: 412-***-**** Home: 412-***-****

E-mail: *****.********@*******.***

PROFESSIONAL QUALIFICATIONS

Professional Summary ... Numerous years of financially focused experience

within fast paced, customer focused organizations. Particular emphasis on

planning, forecasting, profitability, trend, and business case analyses.

Communication Skills ... Effective in working with groups or in one-on-one

meetings. Delivers persuasive message in presentations to these groups or

individuals. Explains technical matters clearly. Excellent team member.

Analysis & Research ... Significant experience in creating models for use

in budgeting and planning process. Ability to project future opportunities

and risk through the development of appraisals, projections, and forecasts.

Computer / Software Skills ... Proficient in the use of Microsoft

applications (Excel, Access, Word, PowerPoint). Use of numerous database

query tools (Business Objects, Microstrategy, Hyperion Essbase)

PROFESSIONAL EXPERIENCE

AT&T/CINGULAR WIRELESS / CELLULAR ONE 1994 - Present

Senior Financial Analyst (AT&T and Cingular Wireless) - (1999 -

Present)

Supports the Ohio/Western PA District, which consists of over 2M

subscribers. Responsible for developing detailed subscriber, revenue, and

expense budgets, with revenues in excess of $1 billion dollars. Partners

with the Vice President of Sales to identify the factors driving the

District's results in order to make course corrections. Discovers areas

for operational improvement such as revenue enhancements, pricing changes,

reduction of bad debt levels, and opportunities for future subscriber

growth. Provides Senior Leadership Team with accurate and timely

reporting, long-range forecasts, and variances to plan for use in decision

making. Also prepares business cases to support promotional analyses,

calling area enhancements, and capital investments.

Accomplishments:

Spearheaded analysis and recommendations for reallocation of internal

capital distribution. Ultimate outcome was a reduction of $40 M in

operating costs due to better use of capital investment.

Served as financial representative on Philadelphia market partnership board

of directors.

Regional Business Manager (Cellular One) - (1997-1999)

Responsibilities included: preparation of regional operating budget with

revenues in excess of $100 million; oversee monthly variance analysis of

actual results to budget and identify areas of opportunity; prepare monthly

forecasts of regional operating cash flow and key financial indicators.

Partner with local sales distribution to develop and implement new pricing

structures. Direct Regional audit function relative to promotions,

adjustments, and operational policy. Approve and monitor authorized agent

commissions. Additional responsibility included the supervision of three

Regional Financial professionals.

Accomplishments:

Streamlined and automated a monthly management reporting package. This

saved over 40 man hours of work per month

Recipient of 1998 President's Club award for outstanding contribution and

dedication to the business.

Senior Business Analyst (Cellular One) - (1995 - 1997)

Duties included: assist in preparation of regional operating and capital

budgets; monitor actual results vs. budget; operate mainframe report writer

to produce monthly sales distribution and revenue reports; prepare monthly

reporting package including sales trending and key financial indicators.

Additional responsibility included the supervision of Regional Business

Analyst.

Business Analyst (Cellular One) - (1994 - 1995)

Duties included: rate plan analysis relative to payback and incremental

business needed to achieve higher levels of profitability; preparation and

tracking of regional capital budget; verify integrity of billing and

roaming tables; interact with Marketing and Billing Departments in order to

facilitate implementation of Regional promotional offers.

ADVANCED COMMUNICATION SYSTEMS, INC.,

1993-1994

Financial Analyst - Responsible for maintaining an automated financial

database for U.S. Naval satellite communication programs, updating budget

execution plan data, review and analysis of procurement/financial documents

for budget execution reports and various account reconciliation's. Also

responsible for preparing trend analyses through research and comparative

analysis of historical funding profiles.

MALARKEY-TAYLOR ASSOCIATES

1991-1992

Financial Associate - Assisted in the preparation of fair market

valuations, purchase price allocations, feasibility studies and tangible

asset appraisals, primarily in regard to cable television, cellular

telephone and paging companies. Provided research support for various

litigation issues.

EDUCATION

Indiana University of Pennsylvania, Indiana, PA

Bachelor of Science Degree in Finance/Economics, December 1990

Contact this candidate