AARON ELLIS
**********@*******.***
EDUCATION
¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬
MBA University of Michigan, Ann Arbor, Michigan 2007
BBA University of Michigan, Ann Arbor, Michigan 2001
• Major: Accounting/Finance
PROFESSIONAL SUMMARY
¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬
Over 12 years of professional experience in the Financial, Program Management, and Procurement arena. Skilled in both domestic and international, trend analysis, contract management, soliciting and analyzing bids and contracts, cost regression analysis, cost estimating, financial reporting analysis, budgeting, forecasting, operational expenses, capital forecasting and analysis, accounting, linear/non linear analysis, negotiating long-term contracts. Strong background in contract development and contract administration. Proficient in SEC Reporting, SAP, Hyperion-Essbase, GAAP, IFRS, GASB and SOP 98-1. Demonstrated ability to analyze and reduce costs, manage multiple work assignments, meet deadlines and achieve desired goals.
TECHNICAL SUMMARY
¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬
Languages/Tools: MS Office (Word, Excel, PowerPoint), Excel Pivot Tables, Macros, Conditional Formatting, Ad –Hoc Reporting, VBA scripts, MS Project, APQP, SGA, SQL, EPR, SAP(FI/CO, PS, PP), Ariba, Hyperion-Essbase, SOP 98-1, Cognos, Minitab, Crystal Reports, SOX, SPC (Statistical Process Controls), Value Stream Mapping, iGrafx, Outlook, Lotus Notes, PeopleSoft, data models/transformation/extraction, web-based reporting
Databases: MS Access, Oracle
Environments: Windows 98/2000/2003/2007/NT/XP/Vista, UNIX, CAD/CAE, Mainframe
Certifications: Six Sigma Green Belt
PROFESSIONAL EXPERIENCE
¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬
HP, Pontiac MI July 2009 – December 2009
Asset Management Program Specialist (Contract-short term assignment)
Managed global asset management supporting and responsible for IT equipment, operational expenses, managed the lease/purchased, invoiced/purchased order validation, tracking, analyzing, budget, created daily metrics, monthly and ongoing budgets and forecasting, and generated executive presentations.
• Directed the performance indicators for asset management & operational indicators to ensure continued value & accountability
• Directed global portfolio tracking and cost management
• Managed asset management operational expenses
• Managed process improvement policy and procedures
• Executed budgeting and forecasting for global telecommunications projects & contracts
• Managed the development of targeted & realized savings
• Managed the collection preparation & interpretation of financial & business data presentations for corporate & management
GMAC, Detroit MI March 2009 – June 2009
Senior Financial Specialist (Contract-short term assignment)
Functional Finance supporting SAP into Ariba. Responsible for accounting, tracking, analyzing, budget, forecasting, and reporting to information technology spending, analyzing portfolio investments, and preparing executive presentations to communicate IT spending.
• Ariba configuration within the existing realms into SAP links
• Preformed month-end close, balance sheets, cash flow, project accruals, P&L, utilizing SAP and Hyperion-Essbase
• Managed capital accounts for correct allocation centers
• Conducted project reconciliations for IT expenses
• Developed, recorded, and managed forecasts and budget for projects and operational spending collaborating with Global Budget Owners
• Monitor and reported on variances between actual and forecast and budget
• Performed IT hardware lease management activates, including lease bid management, asset tracking, lease termination, and fixed assets
General Motors, Detroit MI February 2007- December 2008
IS&S Senior Financial Specialist
Responsible for Global Telecommunications annual spend of $178 million in budget, forecasting, accounting, trend analysis, operational expenses, fixed assets, accounting transactions, and special assignments.
• Executed budgeting and forecasting for global telecommunications projects & contracts
• Performed monthly, quarterly, and annual financial close activities utilizing SAP and Hyperion-Essbase
• Project accounting for all capital IT expenses
• Generated derivative accounting reporting of assets/liabilities
• Managed global capital equipment accounts and cost centers
• Prepared senior leadership reporting’s on consumption on daily, weekly, ad monthly reports
• Worked with technology and operational budget owners in portfolio tracking and cost management
• Managed global fixed assets, contractor labor reporting related with projects
• Tracking of capital reconciliation by budget vs. actual expenses
• Reviewed vendor’s SOW (Statement of Work) for accessory and accountability
• Reviewed, validated, project input on IT related contracts, and performed validation of spending against budget
• Conducted budget to actual variance
• Performed IT global telecommunication trend analysis
• Reviewed and validated business cases and Appropriation Requests for IT projects
• Creation of global project plans
• Execution of regional business analysis, created business cases
• Prepared management reporting for Executive Governance Council
• Reduced over $5.3 million annually in telecom expenders through rate reductions
• Created and managed global allocation methodology keys
• Led in Telecommunications & LAN/CAN ITSR (Incremental Spend Requests)
SDE Business Partnering, Detroit, MI September 2005 – January 2007
Purchasing Manager
Responsible for establishing a centralized regional purchasing department of $30 million in goods and services for DaimlerChrysler/AT Kearney MRO, buying throughout the US and Canada. Successfully managed a direct staff of six senior buyers.
• Responsible for 11 commodity codes and spot buys. Reduced vendor list and produced cost savings over $950,000 annually
• Negotiated supplier catalog price reductions of $1.5 million annually
• Performed numerous supplier cost analyses
• Obtained new supplier sources to ensure lower costs, better quality, and improve delivery
• Developed buyer training manuals that proved highly beneficial in orientation/training of new buyers
• Created and managed metrics
• Implemented a computerized procurement system
Ford Motor Company, Dearborn, Michigan April 2000 – August 2005
Senior Commodity Planning/Purchasing March 2004 – October 2005
Responsible for North America Product Development Procurement, budget, forecast, capital equipment, and special assignments.
• Co-Chaired 2 commodity codes with an annual spend of $115 million
• Generated performance metrics and Total Cost of Ownership models including direct, indirect and capital procurement
• Benchmarketing/Process Improvements in “Lock and Load” global parts program
• Reduced $5.2 million in annual supplier contracts by utilizing internal capacity
• Created and managed purchasing blankets for Tier 1 suppliers for multiple areas in Product Development Community
• Executed numerous piece pricing/trend analysis for tooling cost proposals
• Preformed multiple tasks of cost regression analysis for vehicle components
• Created internal preferred supplier list for North America engineering community
• Validated supplier/s SOW (Statement of Work) for accessory and accountability
Senior Finance/Procurement Analyst April 2000 – February 2004
Responsible for procurement, budgeting, forecasting, accounting, and implemented cost cutting strategies throughout North America Product Development.
• Managed the departmental budgets of $47 million, which includes salary costs, material purchases, training expenditures and travel
• Managed annual service contracts of $25 million
• Conducted monthly, quarterly, and annual financial close activities utilizing SAP
• Performed various forecasting's analysis on capital equipment, budget and project expenditures, and including correct department/s accounting alignment for program teams
• Headed business budgetary process for North American build program teams
• Executed cost models on engine, transmission, driveline, and chassis. Built cost models based on material cost, labor, machining, tooling cost/amortization, SGA, packaging, transportation costs
• Led F-Series Diesel Powertrain program team procurement (castings and stampings)
• Managed government contracts on specialty vehicles