Analyst Accounting

Tracy Jensen

**** * **** ***** ****, #**-*** ( Superior, CO ( abmbd0@r.postjobfree.com ( 303-

***-****

SUMMARY OF QUALIFICATIONS

. Accounting/Finance - Experience with budgeting & forecasting, strategic

planning, P&L and revenue modeling, general ledger accounting, management

& external reporting, accounts payable, property tax, commissions,

revenue & spending analysis, consolidations, fixed assets, account & bank

reconciliations

. Systems - Hyperion, Essbase, SAP, Oracle, JD Edwards, BPC, Excel, Word,

PowerPoint, Access, FAS, Brio Query, Business Objects, Cognos, custom

applications, many more...

PROFESSIONAL EXPERIENCE

Medtronic Navigation, Louisville, CO Feb

2009 - Jul 2010

Consultant

. Developed revenue and COS model for annual planning, allowing for more

efficient & dynamic planning.

. Provided SAP BPC database administration and documented procedures for

the recently implemented system.

. Wrote reports in BPC and trained end users.

. Optimized the Annual Operating Plan and monthly forecast submission

models. Resulted in timely and accurate submissions to corporate directly

from planning system.

InfoPrint Solutions, Boulder, CO Jun

2007 - Jan 2009

Sr. Financial Systems Analyst

. Loaded data for monthly accounting close, ensured accurate data in all

consolidated financial systems.

. Coordinated monthly & annual closes from a systems perspective,

documenting and improving processes. Realized more efficient closes and

ensured cross-training of business-critical processes.

. Created the Worldwide Chart of Accounts for Oracle ERP implementation

through successful leadership and coordination on a worldwide basis.

. Served as Hyperion Enterprise database administrator. Rebuilt database

annually to enhance and simplify logic.

. Maintained complex system logic for automated consolidation journal

entries.

Hudson Financial Solutions, Minneapolis, MN May 2005

- May 2007

Consultant

. Coldwell Banker Burnett, Edina, MN

. Assisted with general ledger close activities, month-end reporting,

and account reconciliations.

. Reconciled 12 prior months of commission prepayments and found

overpayments, resulting in recovery of overpayments back to the

company.

. St. Jude Medical, Minnetonka, MN

. Assisted with Strategic Planning, Annual Planning, & Quarterly

Forecasting, developing extensive revenue models for the newly formed

AF division.

. Trained users on Hyperion Enterprise.

Medtronic CRDM, Minneapolis, MN Mar 2006 -

Sept 2006

Sr. Financial Systems Analyst

. Served as Hyperion Essbase administrator.

. Supported Cognos during Corporate Planning season.

South Dakota State University, Brookings, SD Feb 2005 -

Apr 2005

Budget Analyst

. Reviewed and approved budgets for research grants.

. Created and maintained research grant accounts.

Medtronic Navigation, Louisville, CO May

2002 - Nov 2004

Senior Financial Analyst

. Implemented a project accounting system and Hyperion Enterprise.

. Managed the Annual Operating Plan process and quarterly re-forecasting.

. Trained project managers and cost center managers on financial tools.

. Assisted the R&D and Marketing teams with financial direction as needed.

. Prepared monthly reports. Researched and reported variances to Plan.

. Performed complex royalty calculations and ensured timely payments.

Storage Technology Corporation, Louisville, CO Feb

1998 - May 2002

Advisory Accountant/Financial Analyst

. Prepared management and external reports, including 10K footnotes.

. Analyzed financial statements, researched variances to plan for

international subsidiaries.

. Reconciled inter-company accounts including profit elimination. Developed

models for balancing inter-company accounts.

. Translated and consolidated domestic and international subsidiary's

financial statements.

. Re-designed and simplified Hyperion Enterprise Database.

. Converted Hyperion database to the Euro mid-year with no disruption in

reporting.

. Served as Hyperion Database Administrator and systems expert for the

department.

. Loaded and validated sales detail into enterprise data warehouse.

OTHER RELEVANT EXPERIENCE

Valleylab Inc, Boulder, CO Apr 1996 -

Jan 1998

Fixed Asset & GL Accountant

Blue Cross Blue Shield, Cheyenne, WY Jan 1994 -

Apr 1996

Medicare Auditor

EDUCATION AND TRAINING

BACHELOR OF SCIENCE - ACCOUNTING 1990

Southwest Minnesota State University

Marshall, MN

Passed CPA Examination

Contact this candidate