Cheryl K. Clancy ***** Chase Court
Livonia, MI 48150
Mobile: 734-***-**** Email: abhuq5@r.postjobfree.com
Professional
GT Technologies (Automotive Supplier - American Securities firm)
2009 - Present Shared Services Analyst
System and Process Implementation and Improvement
. Designing Shared Service environment for Accounts Payable and
Receivable
. Continuous improvement and re-engineering specialist
. Authored procedures for Accounts Receivable, Cash Applications,
Invoice Processing, ERS Accounts Payable Processing, Collections,
Credit, QAD processing (software)
. Policy and procedure author for Accounting and Audit related
activities
. Responsible for Cash Applications and Collections for over 200
accounts for three locations
. Developed Accounts Receivable reporting techniques for management
review and workable collection program
. Improved collections from 40% past due 60 days to less than 1% past
due
. Manage cash balance in relations to Accounts Receivable to Accounts
Payable
. Designed and coordinate Accounts Payable processing calendar
. Certify all local cash accounts balance to general ledger on daily
basis
. Designed and implemented Sales Report, and Cash Report for management
review
. Responsible for managing the Supplier and Customer Maintenance
Database Programs
. Perform credit analysis and review on customer accounts
. Developed Debit and Credit Memo process documentation and audit
preparation process
. Managed Accounts Payable process for three plants - coordinates
payment status, reviews check registers, approves payments
. Developed Retro-billing program for customers
. Designed automation in QAD software for process improvement
. Cleansed, updated and organized the Supplier and Customer Maintenance
Database Programs
. Designed, implemented and administrated Visa Purchase Card Program
. Completed audit tests and narratives for key Accounts Receivable areas
. Directed the audit review, process and communication with auditors for
Shared Services
Projects and Teams
. Member of ERS Accounts Payable Team
. Audit team for Westland, Michigan office
. System administrator for Purchasing Card, and Automotive Accounts
Payable Websites
. Member of Finance and Accounts Receivable Team (Michigan, Ohio,
Florida)
. QAD design team for US relations
Accretive Solutions (Consulting - Accounting Consulting Division)
2007 - 2009 Senior Associate
DTE, Treasury Group (Gas and Electrical Energy Supplier to Michigan) 6/2007-
3/2009
System and Process Implementation and Improvement
. SOX audit coordinator between audit teams and Treasury, audit testing
and results driver
. Continuous improvement and re-engineering specialist
. Policy and procedure author for Treasury related functions
. Authored procedures for Cash Management, Shareholder Services,
Cash/Bank Reconciliation Certifier/Review, Imaging procedure, Software
- AQA, ARRD, RCTS, Customer Office and Credit Card Audit process
. Reviewed 1600 bank account reconciliations each month for audit
purposes, review, certify and approve
. Certify all bank account reconciliations balance to general ledger on
monthly basis
. Updated leader templates and reconciled reporting for management
review
. Completed audit tests and narratives for key treasury areas
. Responsible for audit review, process and direct communication with
auditors for Cash Management, Shareholder Services, Long and Short
Term Debt, Segregation of Duties (SOD), Effectiveness Assessment and
Change Management areas
. Designed Imaging Process for all Account Reconciliations completed
post SAP Go Live (template creation, naming convention, file design,
review and approval process)
Projects and Teams
. Member of Control Office audit team
. Member of Cash/Bank Reconciliation review team
Valeo Inc, Climate Control Group (International Automotive Tier 1 Supplier)
2/2007-6/2007
Management
. Chief Accountant Deputy responsibilities (start up, no volume)
. Directed Accounts Payable, Accounts Receivable, Payroll- 10 employees
System and Process Implementation and Improvement
. Designed the US plant Accounting Department for recently purchased
assembly plant
. Continuous improvement and re-engineering specialist
. Investigated current Valeo practice with other US locations
. Authored processes and procedures
. Authored job descriptions for all major disciplines along with Fixed
Assets and General Ledger
. Designed and implemented disaster recovery process for all disciplines
. Responsible for staffing recruitment and training for all disciplines
. Designed and coordinated purchase of stationary products and fixed asset
labels
. Consulted and assisted French transplants on professional matters
Projects and Teams
. Implementation team member of SAP/R3 Compass FI module
. Implementation team member of ADP Payroll process
. Design team member of Payroll chart of accounts
. Member of internal steering team for program go-live
. Member of external communication team coordinating data requirements
Professional Tecumseh Products Company (Manufacturer of engines,
compressors)
2005 - 2006 Director, Shared Service Center (Accounts Payables and
Receivables)
Management
. Shared Services Organization
. Directed Accounts Payable (volume $100M annual) with 6 employees
. Directed Receivables Department (volume $25M monthly) with 6 employees
. Managed Customer Master Database and Vendor Master Database (volume
10,000 accounts)
. Managed On Base Imaging and Indexing library system (volume 150,000
documents annually)
. Managed bank lockbox for accounts receivable payments (volume 240,000
checks annually)
. Managed purchasing card for employee non-critical buys (volume $1M
monthly)
. Designed and trained newly formed team of associates, exempt, non-exempt,
union
System and Process Implementation
. Centralized multiple North American locations into account processing
shared service center
. Continuous improvement and re-engineering specialist
. Member of implementation and design team (Oracle, On Base, Neopost,
Banking, PCard)
. Created and implemented terrorist process review for customer addition
requests
. Designed and implemented re-engineered processes for Oracle programming
. Developed key performance metrics for review and analysis
. Developed Shared Service NASCAR team program for Shared Service Center
leaders
. Designed month end review and analysis of account balances, close
process to Ledger
. Designed data approval forms and procedural program for Master Database
system
Projects and Teams
. Partnered with Deliotte Consulting to train and communicate processes of
ORACLE platform to field locations
. Assisted with design and implementation of automatic lockbox receipt
processing and employee purchase card program
. Authored Process and Development Proposals
. Partnered with Internal and External SOX audit and design team for
process compliance
. Month end closure of Accounts Payable and Accounts Receivable balancing
to General Ledger
. Developed Supplier Business Agreement (SBA) for Shared Service Center
customers
Professional Holcim (US) Inc. (Manufacturer of cement and related
products)
2000 - 2005 Manager, Corporate Disbursements (Payroll and Accounts
Payable)
2002 - 2003 Manager, Customer Service (Accounts Receivable)
Management
. Shared Services Organization
. Directed Accounts Payable (volume $900M annual, 12 locations), 10
employees
. Supervised Payroll Department ($130M annual), 5 employees
. Directed Customer Service (volume 3000 customers, 11 regions), 13
employees
. Managed PHH Fleet Vehicle Program (volume $1M annual, 125 vehicles)
. Managed Gelco Travel and Entertainment Program (volume $4.3M annual, 800
accounts)
System and Process Implementation
. Developed key performance metrics for review and analysis
. Continuous improvement and re-engineering specialist
. Designed and implemented re-engineered processes for SAP programming
. Authored process manuals for training purposes, customer service
quotations, software implementation and process change
. Initiated and managed 1099 program for consultants and vendors
(including tax identification confirmation with government based
authorization site)
. Designed system to process and service accounts receivable customers
reduced volume 50%
. Authored the St. Lawrence Cement (Canada) Payroll Service Contract
. Authored PHH Fleet Vehicle corporate fleet and safety policy for employee
drivers
Projects and Teams
. Member of implementation and design team (IXOS Imaging, Gelco, PHH, SAP)
. Designed tracking system and clearing processes for North American Unpaid
Invoice Processing items reduced outstanding invoices value by 80%
. Change Management team centralize Accounts Payable and decentralize
Payroll
. Created imaging program for filing documents and database material
. Partnered with Information Technology and Cap Gemini Ernst and Young
consultants implementation of Human Resources (Payroll) and Accounts
Payable SAP R/3 Financial
Professional Borders Group Inc. (Retailer of Borders Books and Music,
Waldenbooks)
1995-2000 Director of Operational Accounting
Management
. Shared Services Organization - 12 companies, 1200 locations, 5 countries
. Directed Accounts Receivable (volume $80M annual) with 8 employees
. Supervised Lease Accounting (volume 1,000-1,900 units annually) with 8
employees
. Directed Property Accounting (volume $750M annual) with 8 employees
. Directed Bank Reconciliation's (volume 1,400 units monthly) with 8
employees
. Headed NSF Checks (.36% of check sales) with 3 employees
. Administered Fleet Services (volume 120 vehicles, $1M annual) with 2
employee
. Directed Sales Audit and Credit Cards (volume 1,000-1,900 units annually)
with 8 employees
. Designed and trained newly formed team of exempt and non-exempt staff
System and Process Implementation and Improvement
. Authored process manuals for training purposes, new hire orientation and
change management
. Continuous improvement and re-engineering specialist
. Designed and implemented re-engineered processes for Lawson programming
. Developed key performance metrics for review and analysis of financials
. Monthly reporting for Financials of Credit Card Sales, NSF checks,
employee credit card purchases, Lease and Property accounting balances
and forecasting expenses, Leased vehicle expenses, Gift Certificate
sales, Mailing List Revenue, Educational/Institutional Sales, Vendor
Sales Reports, Subtenant Receivables, Co-Op Advertising, Landlord
Allowance, Regional Display Allowance
Projects and Teams
. Member of implementation and design team (Lawson, First Data, SCAN,
Driscoll)
. Developed Fleet Vehicle Lease Program, safety rules and policy for field
personal
. Transitioned three lease agencies for consolidation to single agency
with expense reduction
. Consolidated collection agencies between organizations
. Developed savings program for Lease Accounting, valued at $5M
. Created Accounts Payable Debit Collection Program - $150,000
. Authored Capital Expense Reporting Process to monitor and track assets
. Designed and implemented check recovery award program for success stores
. Authored Process and Development Proposals
Professional Mazda (N.A.) Inc. (Manufacturer of automobiles and
service parts)
1991-1995 Accounts Receivable, Sheet Metal and Past Model Buyer
Management
. Managed subcontractors, final buy and past model purchases for parts and
service
. Buyer for Ford Motor and Mazda service parts
. Directed the coordination of E-coat manufacturers service, parts and
contracts
. Supervised the Accounts Payable transactions for service parts,
miscellaneous purchases, E-coat processing and Air conditioning parts
System and Process Implementation and Improvement
. Developed formal operations manual for Past Model Service Parts
Purchasing Program
. Designed, authored and implemented Supplier Business Agreement (SBA)
. Analyzed and coordinated the Accounts Receivable program for Ford Motor
Company - $15M
. Reconciled outstanding sample and production invoices
. VA/VE continuous improvement
Programs and Teams
. Directed bid preparation and quote completion process for service parts
. Designed cost reduction activities for air conditioning parts
. Teamed with Purchasing Department of current model year to analyze
expected past model requirements based on expected model year sales
Professional American Yazaki Inc. (Manufacturer of automobile wire
harnesses)
1986-1991 Price Controller, Parts Controller
Management
. Managed wire harness price negotiations and gross margin analysis
. Analyzed and reviewed cost analysis reports for wire harness parts
. Forecasted expected production needs for Ford Motor Company and Chrysler
Motors
. Arranged outsourcing bid preparation and quote completion
. Completed analysis and review on open Accounts Receivable balances
. Administered daily shipments, logistics, and price verification for all
wire harnesses
System and Process Implementation and Improvement
. Designed and implemented formal Retro-billing system for Accounts
Receivable
. Authored formal operations manual for Accounts Receivable, Parts Control
and Price Control
. VA/VE continuous improvement
Programs and Teams
. Coordinated internal organization "Brain Stormers" cost reduction team -
initiated, designed and implemented returnable container program for
harnesses
. Controlled shipment of wire harnesses to 11 Ford Motor assembly plants
instituting Just In Time (JIT) production
. Completed request for quotations for all assembly wire harnesses for 80%
of Chrysler Motors
Computer SAP, Oracle, Lawson, QAD, MS Word: XP, 98, 2007, Excel: XP, 98,
2007, Outlook, PowerPoint, Covisint (automotive), VISIO,
Manchester 1099 Reporting, Gelco Travel Service, Driscoll Bank
Reconciliation, On Base Imaging, QuickBooks, RCTS - Risk and
Control Tracking Spreadsheet (audit review database), Documentum
(database library), AARD - Account Risk Ranking Database
(account reconciliation risk rating), AQA - Accounting Quality
Assurance (account reconciliation audit)
Affiliates *International Accounts Payable Professional (IAPP): Current
Member, Guest Lecturer annual conference, Contributing Writer
for AP Matters magazine, Council Member 2008-2009, Test Question
Designer Certified AP Exam (2010 version) Certified Accounts
Payable Professional (CAPP). International Accounts Receivable
Professional (IARP): Current Member, IARP Webinar Instructor
(2010), Contributing Writer for AR Matters magazine, Guest
Interviewee for AR Matters magazine
*Graduate of Dale Carnegie Effective Speaking Course
*Shared Check Authorization Network (SCAN) guest
lecturer
*Dorsey Business Schools guest lecturer
Education Madonna University - Livonia, Michigan
MSA, International Business
BBA, Accounting
Central Michigan University - Mount Pleasant, Michigan
BBA, Marketing and Retail Sales