Annie L. McDaniel
**** ********** ***** ? Lawrenceville, Georgia 30044
Home: 770-***-**** ? Cell: 770-***-**** ?
**************@*********.***
SUMMARY
Expert accounting professional experienced in financial package
implementations and dedicated administrator of General Ledger systems
including conversions, process mapping, month-end closing, and reports.
Software packages include Oracle, PeopleSoft, and Hyperion. Excellent
problem solver and team builder understands interrelated processes and
attention to detail.
EXPERIENCE
ricoh americas corporation, Atlanta, GA 2007 - Jan 2009
Accounting / Finance Specialist
Managed and maintained the legacy Oracle general ledger (GL) and Hyperion
reporting systems. Transitioned to a new GL system and assisted accountants
with month-end accounting entries and reports.
. Implemented system changes (revenue recognition project) to meet new
business requirements as legacy Lanier and Ricoh successfully merged
integrating the two companies.
. Screened, interviewed, hired, and supported Hyperion system administrator
replacement needed for rapid start to successfully meet mandatory
management changes for new year.
. Maintained Hyperion system used for consolidations, inter-company
eliminations, and consolidated reporting for accurate and timely data to
meet legal and management requirements for company reporting.
. Wrote SQL queries to provide data for external auditors and accountants
to support year-end audit requirements without IT intervention, allowing
IT to remain working on other mandatory high profile projects.
. Provided Sarbanes Oxley (SOX) auditors with documentation of financial
processes and financial system security access procedures for mandatory
SOX compliance.
. Assisted accountants with newly implemented ERP Oracle system in using
the ADI application for uploading journal entries to GL from Excel
spreadsheets, thereby eliminating re-keying of data.
. Modified Oracle Discoverer reporting queries to meet finance user
requirements to enable data extraction from the new system for journal
entries; provided analysis data while adapting to a new system, meeting
month end close schedules and requirements.
lanier, a ricoh company / lanier worldwide, Atlanta, GA 1998 - 2007
Manager, Financial Management Systems
Responsible for the Oracle General Ledger system including maintenance, sub-
system interfaces, allocations, month-end closing, and financial system
reports.
. Wrote SQL queries using Tool for Oracle Application Development (TOAD) to
provide tax personnel with GL detail for IRS statutory compliance and
avoid legal action.
. Interacted with Finance and IT to interpret, design, and validate timely
changes to program rules that transformed sub-ledger transactions into
journal entries to be interfaced into the general ledger to meet changing
management and business needs.
. Created a process to approve and track changes to financial systems
resulting in clear communication with IT and Finance enabling tracking of
time, status, and priorities resulting in more efficient and accurate
resource management.
. Managed system administrators (super users) for Oracle GL, PeopleSoft,
and Hyperion enterprise providing complete, accurate, and timely
information for period end close of the company's books and required
reporting.
. Key team member for ERP project, which included gathering data
requirements, design, configuration data, and testing scripts resulting
in implementation of integrated system.
. Managed Financial Management Systems department including performance
appraisals, cross-training and development to promote individual growth.
. Planned time and resources to support accounting and auditors for year-
end close and prepare system for the new fiscal year with organizational
and policy changes.
lanier worldwide, inc., Atlanta, GA 1990 - 1998
Finance Training Manager (1996 - 1998)
Responsible for financial policy updates and end user training to ensure
accurate transactions.
. Assigned to project office to design and implement ERP solution for
PeopleSoft Financials with emphasis as functional lead on Payables,
including time line, tasks, requirements, configuration, data mapping,
reporting, scenarios, and scripting to have these systems implemented
before Y2K in order to be able to continue to process transactions.
. Administrated set up and maintenance of the GL module, GL business
analyst and financial management reporting to support Payables,
Purchasing, and Accounts Receivable.
. Designed, tested, and implemented PeopleSoft Financials including policy
and procedure role, Accounts Receivable report design, GL configuration
data, and AP implementation resulting in successful software
implementation by deadline.
Accounting Systems Administrator (1990 - 1996)
System administrator of the Oracle GL system, which included developing and
maintaining sub-system interface rules, month-end closing, reporting, and
year end requirements. Worked closely with Information Systems to meet and
improve processes for accuracy and timeliness.
. Evaluated and selected General ledger software package (used for 15
years) to replace the legacy package (used for 10 years) resulting in
appropriate return on investment.
. Re-engineered and implemented Oracle General Ledger including chart of
accounts design, conversion, and configuration data setup.
. Defined the specifications for IT to develop an allocation module,
flexible enough to be used for a variety of entries and future
requirements without requiring programmer intervention. Defined and wrote
allocation formulas. Tuned allocations and set up allocation schedules
to run these allocations in the appropriate order for monthly reporting
and analysis.
. Gathered requirements for financial reports and created templates for
profit and loss and department statements. Modified as organization and
legal requirements changed.
. Participated on a team to close the month in two days and have all
subsidiaries report concurrently providing financial results to
management for timely decision making.
EDUCATION
BS, Mathematics Major, Information Systems Minor, Georgia State University,
Atlanta, GA
Additional Relevant Experienced
Experienced in MS Office Suite, Monarch, FTP, SQL (TOAD )