SUMMARY:

Senior Financial Analyst with experience working for global manufacturing organizations. Possess skills that include financial planning and analysis, management reporting, sales reporting and analysis, budget preparation and forecasting, cash flow forecasts; AP/AR and GL month end close, balance sheet reconciliations, and journal entries. Database skills include writing queries and extracting information for customized reports. Advanced Excel skills include pivot tables, V and H lookups, sum if calculations, charts and graphs. Good communication skills both oral and written with all levels of the organization as well as cross - functional teams. Work independently and in a team. Proactive, takes initiative to resolve all business matters. At Confidential and Confidential and Confidential participated in the implementation of the SAP system during the post go-live stage as well as testing in the BI system.

COMPUTER SKILLS:

SAP systems include: Legacy, FSP and Genesis; SAP BI and BW; Business Objects; PeopleSoft Enterprise and Financials; Hyperion Essbase; Hyperion System 9 Planning and Workspace; Excel, Word and Access; Sun Microsystems; JD Edward; Macola; HMA (Hierarchy Maintenance Application).

PROFESSIONAL EXPERIENCE:

Confidential, Riverwoods, IL

Financial Analyst

Responsibilities:

• Prepared budget templates for business units to complete and return for review by finance management.
• Checked purchase requisitions completed by business units to ensure costs were included in budget and appropriate management approvals were in place.
• Check and update Open Purchase Order report for review by business units
• Update Software tracker for management review
• Prepare monthly accrual journals

Systems: SAP; Excel; GEAC

Confidential, Hoffman Estate, IL

Financial Analyst

Responsibilities:

• Worked directly with BI Finance Director to produce customized reports in SAP for review and analysis of operating costs and compare actuals to budget.
• Calculate sales commissions using customized sales report.
• Reconcile Coke and Pepsi accounts.
• Prepared analysis for two plants to report the manufacturing and operating costs.
• Produced customized monthly sales reports to analyze sales volume, margin and net sales.
• Produced the Citric Acid Mid-Order Status report required to be completed by the US Government. The report involved gathering a large amount of data from numerous sources and I documented this process in detail.
• Ran reports in the new SAP system and liaise with IT to discuss how business requirements could be implemented to support the reporting needs of the department.
• Delivered all ad hoc requests from management to provide accurate and timely reports.

Systems: SAP Legacy and Genesis; Excel.

Confidential, Deerfield, IL

Merchandising Analyst

Responsibilities:

• Update vendor contracts and ran weekly reports in Solutions Central to capture all changes to the contracts.
• Mapping debit notes entered in GEM, which was a customized report in Access database.
• Maintained the Supplier Summit file in Excel.
• Checked for data integrity between existing system and the new Vistex system.
• Document the processes performed within the department.

Systems: Excel, Access database.

Confidential, Vernon Hills, IL

Senior Financial Analyst

Responsibilities:

• Analyzing data and producing financial reports for ten business units across the organization.
• Prepared monthly and quarterly financial reports by downloading data from PeopleSoft Enterprise.
• Develop annual plans and forecasts for payroll, headcount and SG&A by extracting data from Hyperion Essbase.
• Coordinate monthly close; prepare journal entries; check financial statements; variance analysis.
• Update financial models with current actuals and future estimates.
• Work closely with key internal customers and cross functional teams to obtain relevant information.
• Prepare analysis to support capital projects using complex Excel spreadsheets.

Systems: Hyperion Essbase; Hyperion System 9 BI + Workspace; Hyperion System 9 Planning ; PeopleSoft Enterprise 8; PeopleSoft Financials 9.1.

Confidential, McGaw Park, IL

Senior Financial Analyst

Responsibilities:

• Calculate monthly admin fee accruals for approximately 200 contracts relating to 6 Group Purchasing Organizations (GPO).
• Perform Balance Sheet reconciliations for 24 general ledger accounts for each GPO in each of the 4 business units.
• Analyze GPO admin fee variances and provide explanations to each business unit
• Prepare the Quarterly Adjustment journal and upload on to SAP using a standard upload template.
• Prepare the Quarterly Medical Segment Reserve Review schedule for Corporate Accounting.
• Compile the Quarterly Fee Trend report and the IPS Admin Fees Rolling 12 months report to send to Health Systems Management team for review.
• Produce an analysis of the Health Systems and Strategic Accounts cost center reports and provide detailed variance analysis in narrative form and graph form using Excel spreadsheets.

Systems: SAP Legacy and FSP (Financial Systems Program); Business Objects; Excel and Access

Confidential, Lincolnshire, IL

Financial Analyst

Responsibilities:

• Assisted the SFA in preparing and reviewing annual budgets for each cost centre within the Confidential .
• Responsible for completing and reporting all balance sheet accounts within the Confidential .
• Published monthly Financial Book for reporting to Management by downloading data from Hyperion and transferring to Excel templates.
• Prepared daily sales reports using data downloaded from Oracle to distribute to management.
• Prepared P&L and Inventory spreadsheets to load on to Hyperion for consolidation.
• Developed and maintained spreadsheets to calculate customer incentives based on sales.
• Set up templates for complex fixed program journals.
• Performed monthly, quarterly and year-end close.
• Updated documents and internal controls to comply with Sarbanes-Oxley (SOX).
• Assisted with special projects for the Confidential .

Systems: Oracle; Macola; Excel.

Confidential

Financial Analyst

Responsibilities:

• Uploaded Cash, FX and Short Term Investment files created from the XRT system on to SAP.
• Intercompany loan variance analysis reports updated with explanations.
• Booked operating expenses and other centralized costs to the entities local SAP ledgers.
• Processed all intercompany invoices approximately 1,800 per month.
• Prepared bank reconciliations on a weekly basis
• Prepared and posted journals

Systems: SAP; LRC (London Re-invoicing Center); Excel.

Confidential

Financial Analyst - R & D Finance

Responsibilities:

• Responsible for producing monthly management reports, monitoring cost centers and account codes.
• Consolidated operating expenses, capital expenditure and headcount figures on to Essbase.
• Published the Capital Cube on the intranet for management information.
• Set up and maintained cost centers on the Hierarchy Maintenance Application system.
• Posted month-end journals.
• Streamlined the invoicing process by creating standard templates in Excel.
• Processed a high volume of journals for Promotional Allowances for Sundry Debtors.
• Accomplished all inter - company deadlines at month-end and resolved all queries promptly.
• Systems: SAP; JD Edward; HMA (Hierarchy Maintenance Application); Excel