Appropriations Analyst

Posted on: 2007-09-04

Marvella A. Johnson, MBA 9805 Brickleberry Lane #203 Charlotte, NC 28262 Home: 704-499-8971 Email: [email protected] Mobile: 330-207-9356 EDUCATION Tiffin University Mentor, Ohio Masters of Business Administration – General Management June 2004 Youngstown State University Youngstown, Ohio Bachelor of Science in Business Administration - Accounting December 1999 COMPUTER SKILLS • MS Office (Word, Excel, PowerPoint, Outlook, Project, Visio, Access), Peachtree • Delphi Systems: CPRS, Olimpic, GSD, eChange, On Demand, GMTOPS, IMS, SAP HIGHLIGHTS • Inventory Auditor Team Leader • Six Sigma – Green Belt Certificate • Certified Trainer for all of Delphi P- Northeast facility. • Planning & Controlling IT Projects Certificate – Duquesne University • Procurement & Contract Certificate – Duquesne University • Member of NABA and NBMBA’s • Certified Assessor in Training for Delphi Packard WORK EXPERIENCE Delphi Packard Electric Systems 8/1994 - 9/2006 Warren, Ohio - A previous division of General Motors Corporation Automotive Manufacturing Industry ~ Annual Sales $26B Employees: 180,000 Appropriations Analyst 2002-2006 • Primary role was to establish tooling investment for sales to negotiate with the customer for engineering changes, new business quotes, model changes, and additional capacity tooling requests. • Utilized MS Excel to calculate capacity tooling based on volume, percent penetration, capacity and tooling costs for engineering changes. • Accessed the internal mainframe system for part descriptions, in-house or fully purchased part information, customer information, bill of materials, and wire charts. • Liaison with other Delphi divisions to gather current information for capital and operations analysis. • Writing Appropriation Requests Projects for executive approval which included preparation of Cash Flow Statements, a detailed analysis of required capital, tooling, and operations requests with required costs for tiered customers, Delphi customers, and allied customers. • Analyzed the Cash Flow Statement within the Appropriations Request Project to determine profitability based on the price analysis, cost allocations, operating income, net present value, and rate of return. • Provided financial information to finance managers and finance controllers. • Assisted capital analyst with closing capital projects. M.A. Johnson, cont’d Accounts Receivable Clerk – Invoicing 2002-2006 • Entered and maintained purchase orders for a region of over 8300 employees. • Reconciled projects to determine consistency with unbilled receivables. • Uploaded file of purchase orders to be invoiced during month end closing in MS Access. • Wrote Manual Accounts Receivable Adjustments when required. • Assisted with a customer requested projects to change tables and queries in the Access database to improve the invoicing process. • Prepared accounts receivable forecast for management when requested. • Exposed to month-end closing processes and procedures. IT Operations Business Analyst 2000-2002 • Worked as a Project Manager in order to establish and create a procurement process for software/hardware and to coordinate/document/and eliminate unnecessary software. • Maintained the tracking of asset depreciation & amortization schedule using MS Project/Excel. • Calculated total asset depreciation expense and amortization per year for upper management. • Prepared burden allocation segment of the budget using percent of completion method. • Responsible for the IT Asset Inventory Project which involved tagging and identifying all assets within Delphi P-Ohio Operations. • Worked with relational databases and intranet basics. Assembly Operator/U-Cell Coordinator 1994 – 2000 • Supervised six to ten co-workers. • Scheduled weekly job assignments. • Managed inventory for production. • Prepared paperwork for employee’s rates and quality issues. • Building electrical harnesses. • Training/Auditing hourly employees. • Reading blueprints. AVI Foodsystems 1992-1994 Warren, Ohio Asst. Branch Secretary • Prepared expense reports • Controlled warehouse inventory • Manually prepared payroll • Dispatched workers to different locations • Prepared and approved bill of lading statements • Scheduled caterings with the customer.