Project Manager Management

JOHN ZIEGWIED, MBA

**** ****** ***

Simi Valley, CA

93063

805-***-**** - (H)

805-***-**** - (C)

abj80b@r.postjobfree.com

SUMMARY OF

QUALIFICATIONS

Accounting and Finance professional who has held positions of increasing

responsibility with several Fortune 500 companies. Management of the

month end close cycle and generation of associated financial reporting

are core strengths. Expert knowledge in the design, implementation,

maintenance and on-going training related to financial systems

applications including Accounts Payable, Purchasing, Fixed Assets,

Payroll and General Ledger modules. Has managed business process re-

engineering initiatives along with the creation of KPI's to monitor

progress, and identify continued opportunities for improvement.

PRINCIPAL AREAS OF EXPERTISE

. Management of Month End Close and Budgeting/Forecasting

Processes

. Financial Analysis and Ad-hoc Reporting

. Cash Management and Forecasting

. Business Process Re-engineering

. Full Cycle SOX Compliance

. ERP Systems Design, Development, Implementation and On-going

Maintenance

PROFESSIONAL EXPERIENCE

Clipper Windpower - Carpinteria, CA

5/10 - present

Project Manager / Consultant

. Assisted the Corporate Accounting department in the development of

policies and procedures related to the procurement to pay cycle.

. Provided training to users in various departments regarding SAP

functionality contained within the AP, GL and Materials Management

modules.

. Analyzed and reconciled AP related accounts including the GR/IR

(Goods Received / Invoice Received) clearing account within SAP.

Prior to my analysis an understanding of the transactions posted to

this account did not exist within the organization.

. Created and updated a weekly forecast of expected AP disbursements by

vendor with invoice detail for each legal entity. This analysis was

provided by creating an Excel pivot table that was based on a data

extract of all open items from the AP module.

. Reviewed vendor master data on a weekly basis to ensure proper setup

of new vendors including verification of payment method and 1099

status.

. Involved in dally interactions with the Supply Chain dept including

providing direction in the resolution of PO setup and unit price

issues.

Anthem/Wellpoint Health Networks - Thousand Oaks, CA

6/09 - 5/10

Project Manager / Consultant

. Created budget variance reporting models utilizing Excel for the IT

application development group to manage all components of project

funding more effectively.

. Interfaced with resource managers to identify need for external

resources and assisted with completion of vendor contracts to ensure

compliance with company policies.

. Provided detailed monthly variance explanations related to outside

services contracts.

. Managed renewal of all software, hardware and licensing contracts for

the department.

TSE Brakes / Marmon Highway Technologies - Fresno, CA

12/08 - 2/09

Assistant Controller / Consultant

. While on assignment in Fresno, CA assisted the Controller with all

day to day accounting functions for a privately held brake

manufacturer that was acquired by a public company.

. Created standardized templates utilizing MS Excel with links to

multiple data sources to allow for an automated method of presenting

variances to forecast for all P&L accounts. Detailed sales,

materials and labor variances by product were also included.

. Developed an MS Access database to enable detailed sales reporting by

state and by point of origin, where this capability did not

previously exist in the organization.

. Completed analysis of all balance sheet accounts and prepared account

reconciliations so that an accurate opening balance sheet could be

finalized.

. Utilized Hyperion Financial Management (HFM) platform to upload data

from the Visual GL software module and verified that all accounts

were properly mapped to ensure accuracy of consolidated financial

reporting by the parent company.

Countrywide Financial Corp - Thousand Oaks, CA

5/05 - 9/08

Director of Accounting

. Led the implementation of the Peoplesoft 8.4 Asset Management module,

and provided functional and technical assistance during the

implementation of the GL, AP and AR modules. Also responsible for

the preparation and presentation of training materials for these

modules to all finance staff.

. Created KPI's along with a monthly status reporting process to

identify opportunities for improvement for various departments, and

presented results to senior management.

. Analyzed balance sheet account reconciliations, created standardized

reconciliation procedures and provided training to corporate

accounting staff.

. Led documentation of process flows including current state and

proposed future state for all corporate accounting processes that

were impacted by the implementation of a centralized data warehouse.

. Managed the implementation of a dashboard application utilizing MS

Access and worked with the Corporate Treasury department to monitor

the cash remittance process for all investors. Total payments to

investors were approximately $10B per month.

. Prepared process narratives and was involved in all areas of Sarbanes

Oxley (SOX) compliance for Corporate Accounting and associated IT

procedures.

Wellpoint / Blue Cross of California - Thousand Oaks, CA

10/99 - 4/05

Manager - Finance

. Responsible for ensuring that the month-end close was completed in a

timely manner, and that financial information was readily available

to users throughout the organization.

. Instrumental in the design, implementation, development and

maintenance of Hyperion Financials and Peoplesoft 8.4 applications.

Prepared and provided on-going training for these systems.

. Developed and maintained an MS Access database utilized as an interim

solution to track and control spending based on budgeted amounts for

all capital projects.

. Verified that all source system interfaces were posted as scheduled

to the general ledger and worked with business unit and corporate IT

staff in the continued development and testing of more fully

automated solutions.

. Responsible for the development, processing and continued maintenance

of allocation methods for over $1.5 billion of administrative

expenses.

. Heavily involved in all areas of Sarbanes Oxley (SOX) compliance

related to various Corporate Accounting and associated IT processes

including planning, documentation, testing, remediation and

coordination with external auditors.

. Responsible for the integration of financial data for various

acquired businesses, including Blue Cross/Blue Shield of Georgia,

Blue Cross/Blue Shield of Missouri and Blue Cross/Blue Shield of

Wisconsin.

. Maintained same number of staff even while the company more than

quadrupled in size due to acquisition and increase in new business.

This was accomplished through process automation and detailed process

documentation to allow the staff to resolve systems related issues

and compliance with information requests in an efficient and

consistent manner.

EARLY EXPERIENCE

Internext Corp - Burbank, CA

2/99 - 10/99

Assistant Controller

Wellpoint / Blue Cross of California - Woodland Hills, CA

12/96 - 2/99

Project Manager

Southwestern Orthopedic Medical Corp - Thousand Oaks, CA

5/94 - 12/96

Controller

Nestle / Westreco Inc - Van Nuys, CA

2/88 - 5/94

Assistant Controller (2/88 - 11/90), Controller (11/90 - 5/94)

Phoenix Furniture - Los Angeles, CA

1/87 - 2/88

Assistant Controller

Sealy Fine Furniture - Los Angeles, CA

10/85 - 1/87

Staff Accountant (9/85 - 5/86), Controller (5/86 - 1/87)

EDUCATION

B.A. Accounting/Business Admin; Northwest Nazarene University - Nampa, ID

M.B.A.; Pepperdine University - Malibu, CA

COMPUTER SKILLS

Microsoft Office Professional Expert User (Access, Excel, PowerPoint,

Word, Visio, MS Project), SAP Financials including AP, Materials

Management and GL, Hyperion Financial Management (HFM), Hyperion Essbase

and Hyperion Planning Applications, Cognos, MAS90, JD Edwards, Peoplesoft

8.4+ including GL, AP, AR, Payroll, Purchasing, Asset Management,

Inventory & Commitment Control Modules, AS400 Applications, Visual

Manufacturing software modules including GL, AP, AR, Payroll, Sales and

Manufacturing, Planview Enterprise Portfolio Management software.

Contact this candidate