Sales Representative

LARA L. JOHNSON

** ****** ******, #**, **********, NJ 07070; Phone: 860-***-****; Email:

********@*****.***;

LinkedIn: http://www.linkedin.com/in/larajohnson

PROFESSIONAL EXPERIENCE

GLAXOSMITHKLINE

Parsippany, NJ

Financial Analyst, Consumer Healthcare, Research and Development (R&D),

Financial Operations June 2009 - March 2011

. Acted as day-to-day finance business partner providing support to R&D

Medical, Regulatory, New Product Development and Future groups for a

global company with $45.4B annual revenue.

. Developed annual budgets for project and operating expenses and provided

monthly forecasts; created insightful management reports and dashboards;

and presented financial results to key internal stakeholders. Reported to

a UK-based Finance Director.

. Performed month-end close including converting British pounds to dollars;

preparing and posting accruals; reclassing expenses; completing

intercompany cross-charges; and preparing general ledger account

reconciliations.

. Acted as US contact for capital projects and budgets. Managed and tracked

$10M budget; worked closely with business departments to ensure that all

project investment proposals were comprehensive; prepared detailed write-

off analyses related to new capital projects; liaised regularly with

outside India vendor to maintain Fixed Assets register; and conducted

Fixed Assets inventory.

. Created automated files using Hyperion to forecast project spend and to

compare monthly operating results by cost center.

AFFINION GROUP

Norwalk, CT

Senior Financial Analyst, Revenue Forecasting, Financial Planning and

Analysis June 2007 - November 2008

. Analyzed performance data and developed three-year plans for a company

with $1.3B annual revenue.

. Prepared detailed monthly variance analyses and reports for billings and

other metrics by client, portfolio, product and media type.

. Created and reconciled monthly revenue forecasting files coordinating

with IT to load to Hyperion each month.

. Implemented improvements to current processes and created reports

enabling transition from Microsoft Access to Hyperion.

THE HARTFORD FINANCIAL SERVICES GROUP

Simsbury, CT Financial Analyst, Hartford

Life, Group Benefits Division, Financial Reporting

June 2004 - June 2007

. Created models to provide detailed forecast and budget reports and to

project the annual operating plan by product and segment.

. Prepared detailed monthly financial reports for division with $2.5B in

annual revenue including Financial Results package and Operating Metrics

report which were reviewed by division CFO and other Senior Management.

. Partnered with business segment managers on special projects and to

provide monthly variance analyses by product and segment.

. Assisted in the month-end close process: automated processes in

PeopleSoft nVision using macros, lookup tables and other functions in

Excel; posted journal entries, provided reconciliations and prepared 10-Q

and 10-K SEC filings.

ASSOCIATED BANC-CORP

Green Bay, WI

Senior Financial Analyst, Community Banking, Financial Planning and

Analysis August 2002 - June 2004

. Provided detailed financial analyses and recommendations to Senior

Management for growing community bank with $22B in assets.

. Analyzed the profitability of new products and services and new business

line and revenue enhancement initiatives. Prepared scenario analyses;

profit/loss reports; detailed forecast and budget reports; expense and

staffing analyses; cost-benefit analyses; and other ad-hoc analyses and

reporting for the nine Community Banking regions with $500M annual

revenue.

. Managed and tracked all capital projects. Met with Regional Presidents

and Facilities Management to project cash flows and NPV.

. Automated new branch initiative model and created a post-audit model to

analyze new projects.

. Coordinated bi-weekly service charge team meetings to discuss operational

issues, reporting, and strategies to increase fee income.

SALLIE MAE

Reston, VA

Financial Analyst, Financial Planning and Analysis

January 2001 - August

2002

. Created models and prepared scenario analyses for loan portfolio

purchases, loan amortization schedules and proposals to schools.

. Structured transactions for Sallie Mae's $6B securitization program:

determined tranche percentages and bond overissuances; stress-tested bond

cashflows based on rating agencies' criteria; updated quarterly cashflows

for trusts viewable on Bloomberg; and produced and delivered asset and

bond cashflows and reporting packages to rating agencies and

underwriters.

Strategic Sales Analyst, Strategic Sales

November 1998 - January 2001

. Assisted in developing Incentive Compensation plans and calculated awards

for the Sales divisions.

. Developed quarterly purchase volume forecasts and budgets for the Sales

divisions with $6.5B annual revenue.

. Acted as a liaison with Financial Planning and Analysis department to

provide profitability analysis proposals to schools.

. Compiled and distributed weekly Sales status reports.

. Promoted from Strategic Sales Specialist in 2000.

Lara L. Johnson, Page 2 of 2

CHADWYCK-HEALEY (Acquired by ProQuest in 1999)

Alexandria, VA

Marketing Manager

August 1995 - November 1998

. Reported to US President and acted as a member of the US management team

for a UK-based online publishing company.

. Developed and managed $6M Marketing budget projecting revenue for new

products. Planned and managed the company's participation at over 10

trade shows annually. Managed direct mail, advertising and public

relations campaigns.

. Promoted from Marketing Coordinator in 1996.

HELDREF PUBLICATIONS (Acquired by Taylor & Francis in 2009)

Washington, DC Advertising

Assistant

September 1993 - August 1995

. Generated and managed advertising billing for 46 scholarly reference and

research publications.

. Monitored the aging of receivables, reconciled accounts with Accounts

Payable and managed the collection of past due accounts.

. Acted as an advertising sales representative for one journal exceeding

the sales goal for the year within six months by creating a database of

leads; designing flyers mailed and contacting potential customers.

EDUCATION

THE GEORGE WASHINGTON UNIVERSITY

Washington, DC

Master of Business Administration, Finance

August 2000

VIRGINIA COMMONWEALTH UNIVERSITY

Richmond, VA

Bachelor of Science, Mass Communications,

Advertising May 1992

TECHNICAL SKILLS: Access; Excel; Hyperion; JD Edwards EnterpriseOne;

Microsoft Windows 7; PeopleSoft; PowerPoint; Word

Contact this candidate