SUMMARY

• Accomplished, results - oriented, and strategic professional, who consistently meets budget requirements, is detailed oriented and develops improved methods and systems.
• Over 20 years of experience in the finance/engineering fields and manufacturing industries.
• Key strengths include: strong work ethics, is deadline driven, has solid multi-tasking skills and communicates well at all levels of an organization.

PROFESSIONAL EXPERIENCE

Confidential

Lead Financial Data Analyst

Responsibilities:

• Daily analysis of Voya SEC filers/non-filers trust funds’ net assets, operations, spin-off costs, and SCA testing.
• Prepare PDF books for E&Y annual audit, train and coach my team members, assist with the spin-off transition of 327 funds, support the carve-out team for RLIOD (SEC fund).
• Identify and reconcile variances on all 10K financial reports.
• Meet with my team weekly for FTP (Reporting Dept.) updates. Budgeting, forecasts, and investment ratio process testing.
• Reviewed and internally audited 700 trust fund accounts that passed the EY audit

Confidential

Sr. Financial Data Analyst

Responsibilities:

• Analyze bottler accounts on a daily basis to assist with the transition of Confidential -Cola refranchising from all domestic bottlers to International consolidated plants.
• Answer Due Diligence questions and follow-up with PwC’s representatives and plant managers on any SAP cost centers or production costs variances due to our comparison analysis, create/update weekly power point presentations for each plant to review year-to-year financials drivers to our Dir. and VP for KPIs.
• Created Comparison decks for South West Operating Units (nine plants) that revealed a new process of Cost-Savings Initiative for Scrap Ingredients, Down Operating Lines, and Inline Blow Molding startups

Confidential - Atlanta, GA

Sr. Financial Data Analyst

Responsibilities:

• Review sales and invoice reports, locate pricing variances. Created Excel and Access reports to analyze product issues, duplicate transactions, and set up errors.
• Ran weekly A/R reports in Oracle to ensure merchant accounts are current, and all aged items are cleared up. Audit and confirm that all price books are updated and comply with billing invoices for my merchants.
• Communicate with merchants and Account Managers daily to follow-up on any action items, as needed.
• Recuperated $6.4 Million from Game Stop USA, by discovering underpaid X - Box gift cards that occurred for a quarter, prior to my employment. Additionally, recovered $1.1 Million from the same merchant, by discovering unpaid Face Book gift cards, during Christmas season within a 2 week period
• Discovered and recovered $525K from Game Stop Nordic/European entities, due to pricing errors in their system
• Trained Cash Dept. team members on Oracle cash applications procedure for several US/Canadian merchant accounts
• Took on International Reconciliation Team Lead, due to personnel shortage
• Collected 34.2 Million pesos from Wal-mart Mexico, due to past due unpaid invoices (while on vacation)
• Ran A/R transaction reports in MS Dynamic GP and Essbase with automated processes for invoices, receipts, and recons
• Tracking Financial (Visa/MasterCa rd/Amex) cards transactions through FCMS to find variances, as well as fraud

Confidential

Financial Analyst/Accountant

Responsibilities:

• Performed financial analysis on revenue, costs, and operating efficiencies for Ford, Chrysler, Mazda, and Confidential s Japanese, Chinese, and Mexican Vendors finished products.
• Monthly Reconciliation of (27) accounts utilizing GLOVIA ERP with a budget of over $21M, and recovered over $10M
• Supplied bi - weekly Budget/GP Forecast Reports, Report Modeling, including Revenue/Expense Analysis using COGNOS 8.0/Advanced Excel (utilizing v-lookups, h-lookups, macros, sum-ifs, concatenates, etc.), noted any variances for the Sr. Accounting Mgr., and successfully exceeded the forecasted business plan FY08
• Monitored and analyzed weekly Freight expenses, recommended new coding for BOL (Bill of Lading)
• Spearheaded the development, integration, and publication of The Pricing Control Access database via our shared point by creating queries reports to reduce pricing variances for Manufacturing, Sales, and Accounting Dept.
• Completed Month-end closing duties, including inventory-in-transit accruals, standard cost changes, warranty reserve analysis, cost closing process, inventory revaluation. Also did annual physical inventory, and customer service cost assessment and assisted with SOX documentation requirements, resulting in a positive quarterly SOX/KPMG Audit

Confidential - Atlanta, GA

Financial Metrics Support Analyst

Responsibilities:

• Assisted on various key accounts in reviewing, evaluating, and making recommendations for the corrections/improvements to ensure appropriate payment of warranty claims, credit memos, and manufacturing supplies, and cost savings. Generated monthly Ad hoc reports (SAP/Hyperion Essbase/Brio/MS Excel) to assist with month - end closing duties and deadlines.
• Analyzed manufacturing costs by composing exported Excel Reports from SAP (utilizing v-lookups, sum-ifs, and pivot tables) and compared standard costs to actual production costs for Ch. 11 Cost Savings Initiative Project, which successfully met forecasted dept. budget of over $2M
• Interacted with Finance/Sales/Engineering management and directors to identify and implement a paperless Excel system to improve cost reduction strategies, which increased accuracy and efficiency in the work force