TECHNICAL SKILLS

Software: AUTOAUDIT, WORKIVA/WDESK, ACL, IDEAS, HYPERION, RED PRAIRIE, HIGHJUMP, TABLEAU, COGNOS BI, PEOPLESOFT, ORACLE, EAGLE - EPICOR, JDE, AS400/MMS, SAGE ERP, MICROSOFT DYNAMICS, CRYSTAL REPORTS, FRX REPORT WRITER, QUICKBOOKS, 3270, Web Query, MICROSOFT OFFICE SUITE (Excel Power Query, Microsoft Access, VBA), ADP PAYROLL, SAP (Retail Banking, Cost Point)

PROFESSIONAL EXPERIENCE

Confidential

Senior Financial Analyst

Responsibilities:

• Managed company wide annual budgeting process for all departments.
• Created and consolidated forecast templates dat included prior years of actual results vs budget for sales, margin, expenses, EBITDA.
• Prepared quarterly board of director packages, provided root cause analysis to drivers of fluctuations
• Analyzed capital expenditures, investments, fixed assets, EBITDA to calculate ROI of stores, identified drivers to low and high performing stores.
• Reviewed cash position, short - term and long-term debt, net income, EBITDA while preparing bank covenants, and calculated financial ratios and other metrics to comply with debt agreements.
• Managed data transition of legacy systems to current systems for newly acquired stores.
• Analyzed store profitability versus lease payments and terms; analyzed options to improve profitability (lease re-negotiation, moving location, changing merchandise endcap layout, turnover). Analyzed profitability metrics (sales per square foot, etc.) and researched why stores were under/over-performing.

Confidential

Senior Internal Auditor

Responsibilities:

• Promoted to internal audit department from Senior Accountant to halp with ITGC/BLC analytics and provide more insight and value to operational audits
• Planned and performed full scope audits, including financial, SOX 404, operational, compliance and process reviews across AAP and its’ subsidiaries
• Audited SEC filings of 10k/10Q/footnotes; worked with technical accounting in implementation of new lease standards ASC 842 and revenue recognition ASC 606
• Collaborated with company leaders and finance associates regarding the identification, monitoring and testing of key controls; collaborated with other departments to develop and improve policies and procedures
• Analyzed and interpreted large volumes of data using data analysis tools (e.g. IDEAS/ACL) to identify company risk exposure and fraud; collaborated with Asset Protection department to analyze inventory movement

Confidential

Senior Accountant

Responsibilities:

• Reviewed and analyzed inventory and margin reports; conducted research and performed analytical studies related to cost analyses and profitability
• Created/maintained/updated queries used for data analysis in Oracle, PeopleSoft and AS400 for Finance; provided gross margin analysis; remedied vendor EDI issues
• Provided analysis for management and business unit teams to determine financial liabilities and prepare appropriate accruals; prepared month end journal entries and assisted with month end close process
• Provided P&L variance analysis on budget vs actuals; analyzed P&L trends and created predictive models
• Established and maintained reserve accounts and amortization accounts; analyzed and reported pricing discrepancies to decision support team and halped to identify growing concerns in supply chain

Confidential, Torrance, CA

Accounting Manager

Responsibilities:

• Project Lead for Epicor ERP implementation to consolidate Centinela’s retail ERP system, AS400 and Lotus Pet Food’s manufacturing ERP system, SAGE/MAS500.
• Promoted from Senior Cost Accountant to Accounting Manager within first 6 months and identified as the Accounting/Finance Lead in new system implementation
• Managed inventory procedures including cycle count process by decreasing rotation write off, physical inventory results, and maintained a net variance of 1%
• Supervised a staff of four; provided weekly KPI, cash flow, and sales forecast reports to management
• Managed all areas of A/P, A/R, Cash Application, Daily Cash Management, Inventory, Vendor Billbacks, and RTV products
• Maintained financial statements, and schedules for rent, intercompany transactions, A/P, A/R, long term debt obligation, and other required schedules
• Developed Sales Audit Department and commercial rebate program; created process flows for purchase credit cards and streamlined sales credit card processing systems
• Created and implemented 30 day Return to Vendor procedure to ensure timely deduction of credits or receiving of cash; worked with DC and Category Managers to ensure timely processing of returns, callbacks, and defectives
• Developed weekly financial reports (rolling 21 sales report, KPI report, cash flow, gross margin report); developed budget and accurate projections for sales, cash flow, and inventory labels
• Analyzed inventory variance and reconciled inventory cost to the GL; analyzed inventory valuation, roll forward, and reserve analysis; reconciled finished goods inventories
• Made estimates of new and proposed product costs; analyzed actual manufacturing costs and prepared periodic reports comparing standard costs to actual production costs

Confidential

Senior Accounting Analyst

Responsibilities:

• Obtained additional credit facilities for company by working with Confidential in securing funding and providing documentation
• Created company projection model and daily cash reporting; Updated cash flow forecast to maintain integrity by tracking past cash transactions and working with other departments to predict future sales and funding obligations. Locked in rates for revolving debt on Confidential CEO based on company needs.
• Prepared daily cash flow spreadsheet dat reports cash balances for all domestic companies, investments, outstanding intercompany loan balances, and calculates final cash position. Prepared bi-weekly cash flow forecast to determine future incoming cash flows, payables and debt obligations. Prepared monthly credit card analysis to determine total sales, fees and discount rates.

Confidential

Financial Analyst

Responsibilities:

• Worked on the integration of newly acquired Wachovia retail banks by analyzing market share, product differentiation, customer retention, product comparison, and real estate