Kristi L. Taylor
abl2y0@r.postjobfree.com
La Habra, CA 906**-***-***-
5413
SUMMARY
Financial Analyst with both technical & financial experience and a proven
ability to successfully implement new processes and systems which requires
building collaborative working relationships with other employees in other
departments.
EXPERIENCE
MASTER HALCO, INC., Orange, CA 06/08-Present
MH is the worlds leading distributor and manufacturer of perimeter security
and fencing.
Financial Analyst
As a Financial Analyst, my primary focus is analyzing & building budgeting
and forecasting solutions using Cognos software.
. Design and build models for business planning using Analyst
. Build, administer, and deploy Contributor applications through the
Contributor
Administration console
. Prepare, review and analyze the annual budget process and quarterly
forecast for over 90 departments
. Prepare financial statements and managerial reports
. Prepare quarterly summaries for executive management and BOD Board
package
. Analyze, research and explain variances to budget, prior year and prior
forecasts
. Involved in annual Inventory Audits
. Compile JSOX compliance reports
. Data extraction & analysis
. Load budget/planning to parent company using Hyperion Fusion
. Helped with Cognos Planning 8.4 upgrade from 7.3
. Train users in new processes and system usage
. Provide technical guidance and support
. Establish and maintain JDE System General Accounting module
. Maintain and create JDE FASTR Reports
. Prepare and maintain Spreadsheet Server Templates
ROSE HILLS COMPANY, Whittier, CA 09/07 - 05/08
Rose Hills is the largest single-operated cemetery in the world.
Accounting Analyst/Accountant
Prepared and analyzed financial statements and financial reporting
. Managed monthly and year-end closing process
. Processed monthly financial statements and prepared reconciliations
. Mapped general ledger accounts to parent company's financial statements
. Prepared Financial Statement template to conform with parent company
. Created JDE reports to pull quick and accurate
. Compared SGA expenses versus budget to identify risks and opportunities
. Conducted Gross Margin Analysis to monitor cost of sales of merchandise
. Constructed sales reports and distribute to management
GORDON BERNARD COMPANY, Milford, OH 06/05 - 07/07
Gordon Bernard is the nation's leading custom calendar fundraising company.
Advertising Editor
Complete responsibility for accuracy of advertisements
. Organized and edited advertisements on calendars before final printing
. Ensure all advertisements meet customers' requirements
SNAAC, Cincinnati, OH 02/03 - 03/04
SNAAC provides finance products to auto dealerships that serve military
personnel in the US
Staff Accountant/Accounting Systems
Prepared financial statements and created accounting reports with new
system
. Implemented and maintained general accounting systems and daily analysis
of financial information
. Maintained the fixed asset system
. Audited the work of the accounting clerks
. Prepared the daily wire information for money transfer of sold loans
. Implemented and customized company's new information system using Oracle
. Wrote queries using tables residing in an Oracle database to write
reports using Oracle 6i
. Used Crystal Reports to generate reports
. Tested the accuracy and efficiency of new program in regards to company's
unique needs
. Trained and educated staff on the new system
EDUCATION
Bachelor of Science in Accounting, GPA 3.5 The Ohio State University,
Columbus, OH
. Full Scholarship in OSU Softball
IBM, 3 IBM Cognos 8.4 Training Courses
. Analyst: 5 day course
. Contributor: 4 day course
. Administer the Technical Environment: 3 day course
Oracle University, JDE
. JDE/FASTR online course
SYSTEMS EXPERTISE
Microsoft Excel
. Expert level Excel user including: pivot tables, macro creation, and
formula building (IF, AND/OR, VLOOKUP, HLOOKUP, etc)
Microsoft Power Point
. Advanced level user including: creating slide masters, working with
templates and layouts, inserting object, creating graphs and organization
charts
JD Edwards/FASTR
. Advanced user of FASTR reporting including report libraries, use of
common rows and columns, and use of override cells
Hyperion Fusion
. Data submission through FDM, Hyperion Reporting and Smart View
Cognos 8 Planning
. Analyst: Design and build models for business planning
. Contributor: build, administer, and deploy Contributor applications
through the Contributor Administration Console, manage security using the
Cognos 8 security, perform administrative tasks, such as importing and
publishing data, and deploy the application to the Cognos 8 portal.