Carmen B. Mills
*********@*****.***
SUMMARY:
Sr. Financial Analyst/Financial Project Manager proficient in the use of
Project Management Methodologies. 10 years supporting Information
Technology Procurement projects from the RFQ to timely delivery and
accurate invoicing for the customer. Highly skilled in contract
administration, time management and overseeing complex deals requiring
independent judgment. Detail oriented with excellent analytical,
organizational, interpersonal and problem solving abilities.
Overall 15 years of experience with strong focus in Planning, Executing,
Monitoring & Controlling Finance, Accounting and IT Projects.
Act as the key Finance and Accounting liaison with the Operations team in
areas of financial training, general financial statement support, client
pricing efforts, General Accepted Accounting Principles (GAAP), internal
controls (e.g., revenue Validation, Accounts Receivables [AR], audits,
billing adjustments, etc.), forecasting, and annual budgeting. Top Down
and Bottom Up estimating.
Prepare Engagements Set-ups
Track and report third-party out-of-pocket expenses, hardware/software
costs, client personnel expenses against program budget and any other
expense charges to program budget. Investigate questionable or invalid
expenses.
Hyperion, Oracle Financials PeopleSoft, Great Plains & SAP FICO
International Billing, experience with foreign currencies & rate changes.
Performed International equity reconciliations from Local GAAP audited
financial statements to US GAAP financial statements in the local currency.
Twelve years of strong experience in vendor management, SOW's, PO's RFI's,
expense and invoice validation.
MAJOR STRENGHTHS:
Project Management, Accounting, Management, GAAP, General Ledger, Accounts
Receivable/ AP & Collections, Customer Service, Budgeting/Cash Management,
Training, Implementation, Quality Control/ ISO 9001, Process Improvement,
Strategic Planning, Negotiations, Corporate Policies, SOX Compliance, IT
Governance & Reporting, NDA's, LPO's, RFQ's, Eval Agreements, SOW's and
Contract Employees. Pivot tables, Macros, and Vlookups. Procurement,
Vendor Relations, Full SDLC, ANSI/EIA 2007
MAJOR BILLING ACCOPLISHMENTS:
1999 - Mariner Healthcare - Invoice Validation - $25 Million
2002 - Compbenefits Corp - Invoice Validation - $1.5 Million
2004 - Kuehne & Nagel - Invoice Validation - $100 Million
2007 - BellSouth/AT&T- Invoice Validation - $15 Million (per project)
2008 - The Coca Cola Company - Invoice Validation - $50 Million
2010 - Cox Media - Invoice Validation for Disney, Paramount, Warner Bros &
Sony
Carmen B. Mills Resume
Page 2
TECHNICAL SKILLS:
Windows 2007/XP, Microsoft Office Professional Suite (Word, Excel,
PowerPoint, Access, Outlook) Internet Explorer, Monarch, PeopleSoft
financials, Great Plains, AS400s, Hyperion Essbase, Oracle Financials,
Legacy, Visio, Crystal Reports, SQL, Data Mining, HTML,/HML/SXL, Microsoft
Project, SAP FICO, SharePoint, Lotus Notes, Blackline, NOVAR
EDUCATION:
Gwinnett Technology Center - Norcross, GA - PMP Certificate - Certification
in process
Gwinnett Technical College - Lawrenceville, GA - Excel, Access, PowerPoint,
Word
Christopher Newport University - Newport News, VA - Finance/Accounting
Dale Carnegie Leadership Training
ISO 9001 Certified
WORK EXPERIENCE
1 COX MEDIA, INC, Atlanta GA Feb 2010 - May
2010
2 Pyramid Consulting, Inc., Financial Analyst
Responsibilities:
Performed general finance and accounting processes including researching,
analyzing, creating, and processing monthly journal entries.
Key Finance and Accounting liaison with the Corporate Accounting &
Operations team in areas of financial training, general financial statement
support, client pricing efforts, General Accepted Accounting Principles
(GAAP), internal controls (e.g., revenue Validation, Accounts Receivables
[AR], audits, billing adjustments, etc.), forecasting, and budgeting for
additonal headcount.
Memo billing for key National and Corporate Accounts
Audit cash logs, bank lockbox reports, adjustment summaries, payment
summaries, invoices summaries by Market/BU in preparation for month end
close. Broadcast Close and Conventional Close.
Managed (owned misc cash task) for CoxMedia.
Prepared reports, graphs, charts, and written financial summaries.
Excel, V-lookup formulas, analysis with financial background.
Research, reconcile and correct misc cash entries.
Research, analyze, create, and process monthly journal entries.
Prepare and upload Financial Summaries to SharePoint.
3 Samberg LLC, Atlanta, GA May 2008- Sept
2009
4 Financial Analyst/Consultant
Responsibilities:
Barnabas Christian Church - Start-up, Administrative Consultant
Williams Construction, Inc - PM for GOVT Construction Contracts
Charlotte NC Public Schools - Transportation Spend/Proposal Consultant
Christian Church - Consulted/Created Excel Models, Charts for Director of
Child Dev. Ctr
All Star Movers - Created Business Plan used to secure Bank Financing
Carmen B. Mills Resume
Page 3
Coca Cola Consultant Atlanta, GA Jan' 2008 -Apr'
2008
1 Project Controller/Change Manager
1
2 Responsibilities:
Defined End to End Process for managing On Boarding of Consultants,
Vendors, Contracts, Facilities, Procurement & Security for GLOBAL ERP
Project
Managed the Capital and Operating Budgets
Prepared reports, graphs, charts, and written financial summaries.
Extensive use of Excel, Access, Statistical analysis, Procurement and
Research
Created SOW's, COA's, MSA's, and Change Orders working directly with
external vendors
Created 2008 Build Budget Template and Rolling Estimate Template.
Excellent ability in accessing, processing and analyzing large databases
Used Visio and Power Point to track Consultants/FTE's across the globe by
work streams
AT&T Consultant, Atlanta, GA Feb' 2005 - May' 2007
2 IT Budget Manager
1 Responsibilities:
Managed/Defined Defined End to End Process for managing On Boarding of
Consultants, Vendors, Contracts, Facilities, Procurement & Security for
Dynamic Software Delivery Team
Manage the Operating and Capital Budgets for a dynamic BROADBAND delivery
team - Convergent Services Product Development including all financial
reporting and analysis, SOX Compliance & IT Governance.
Prepared reports, graphs, charts, and written financial summaries.
Prepare monthly and quarterly budget-to-actual reports.
Oversee the management, planning, and control of all IT investments and
expenses.
Conduct detailed financial analyses and cost modeling to facilitate
decision-making.
Created a Capital Budgeting model to prioritize IT investments
Expert level working experience in on MS Excel, Access, Statistical
analysis, Procurement and Research
Established methodology and templates for preparing business cases,
including approval, tracking, and reporting for VOIP, IPT, IM and Portal
Teams.
Strong problem solving skills and ability in accessing, processing and
analyzing large databases
Provided direction to the IT Asset Management program
Carmen B. Mills Resume
Page 4
Kuehne & Nagel, Inc, Forest Park, GA Mar' 2002 - Dec'
2004
1 National Accounting Manager
1 Responsibilities:
Managed/Defined processes to establish a Global Centralized Audit & Billing
Department for a Global Logistics Company
Implemented all operational policies and procedures while servicing global
territory comprised of USA, Germany, Mexico and Canada
Successfully managed $125 million in accounts receivable while achieving
reduction of DSO from 90 days to 33 days
Has Strategic business of procurement and problem solving ability
Implemented all operational procedures pertaining to cash receipts,
adjustments, settlements, refunds, monthly statements, P&L review, new
accounts, tariffs and contract disputes/resolution.
Interacted with all branches while communicating rate changes, billing
codes, audit procedures to all branches
Extensively worked on MS Excel, Access, Statistical analysis, Procurement
and Research
Ensured application of prudent internal controls and proper segregation of
responsibilities
Comp Benefits Corporation, Roswell, GA Jul' 1999 - Jan'
2002
2 Manager - Accounts Receivable
1 Responsibilities:
Managed/Defined the Accounts Receivable Department for a National Dental
Benefit Company
Hired, Trained and Managed 8 Accounts Receivable Specialists and 1 Accounts
Receivable Clerk
Managed accounts receivable process including daily collections, review of
accounts receivable write-offs, refunds, credit memos, adjustments and cash
applications.
Accomplished overall improvement of company's total outstanding
receivables, currently $7 million and company's DSO below 60 days
Extensively used PeopleSoft Financial
Performed account audits and review of accounts receivable specialist
collection effectiveness.
Coordinated the preparation and analysis of spreadsheets and reports on
weekly and monthly basis on Accounts Receivable Aging, Cash Receipts and
Write-offs
Implemented process reviews and developed policies and procedures related
to accounts receivable.
Reduced Bad Debt Reserve by $1 million and improved collections to 97%.
Establish relationships with third party Commercial Insurers to identify
and expedite payment of claims.
Initiated ongoing training of Regional Administrators, Office Managers and
Supervisors on QSI Billing systems & Bank reconciliations
Carmen B. Mills Resume
Page 5
Mariner Post-Acute Network, Atlanta, GA
Sep' 1997 - Jul' 1999
1 Budget Analyst - Team Lead
1 Responsibilities:
Managed/Defined Operating & Audit Department for 444 Acute-Care SNF's.
Prepared Medicare and Medicaid Cost Reports for Indiana, Michigan, and
Illinois.
Extensively used PeopleSoft Financials
Reconciled Accounts Receivable to general ledger (post merger) 144 to 444
SNF's.
Maintained relationships with third party insurers to track company's
"CASH".
Hired and trained group of 11 Accounting Assistants accountable for
analyzing Medicaid expenses.
Supervised preparation and analysis of Bad Debt Logs for Medicare Cost
Reports
Point of contact for resolving billing issues in SNF's
Accountable for inquiries from internal and external Auditors
MCI Telecommunications, Atlanta, GA Mar' 1993 - Jul'
1997
Regional Budget Analyst
Responsibilities:
Managed Operating and Capital Budgets for 5 MCI call centers.
Analyzed monthly expenses and booked monthly accruals.
Prepared yearly Operating & Capital Budgets for assigned regions.
Negotiated and purchased all IT equipment and services to include cleaning
and security contracts.
Authorized for payment all Travel Expenses for Operations.
Anhueser Busch Corporation, Williamsburg, VA Dec' 1991 - Mar'
1993
Cash Control Area Manager
Responsibilities:
Utilized leadership skills to successfully manage 4 cash facilities.
Oversaw efficient supervision of 11 Supervisors, 61 employees, $500,000
daily cash reserve and $4 million ticket inventory.
Designed cash vault to secure $500,000 cash reserves.
Designed and implemented dual control system to secure $4 million ticket
inventory.
Interacted closely with Contractor to improve cash processing eliminating
15,000 labor hours for company.
Initiated courier system and routes to secure company cash transfers.
Implemented use of night deposit bags to be used by 1,500 cashiers to
secure cash.
Improved security in cash facilities by requiring Supervisors to audit cash
and collect employee badges at end of each shift.
REFERENCES AVAILABLE UPON REQUEST