Alex Shpak

**** **** *** **. *** #*B • Brooklyn, NY 11224 • 917-***-**** • acfzg4@r.postjobfree.com

COMPUTER SKILLS

Microsoft Office, Hyperion Essbase, Oracle, Micro Strategy, Concur, SAP, JD Edwards, Business Objects, Omniture and

AS400

PROFESSIONAL EXPERIENCE

Juicy Couture, Inc., New York, NY 06/13– 07/14

Financial Analyst

• Assisted in the monthly financial close and forecasting process including the development of budget templates and

monthly P&L file set ups.

• Delivered accurate financial results including comprehensive analysis of key expense and balance sheet items.

• Created & uploaded journal entries during monthly close process and completed account reconciliations with

supporting documentations.

• Executed and maintained store P&L Budgets and monthly forecasts with emphasis on field level controllable

expenses.

• Collaborated with Finance Manager in the preparation of monthly business reviews, annual budgets and long-term

strategic planning.

• Maintained and monitored expenses by budget owner and expense type to hold them accountable for their spending.

• Compiled sales bonus statistics and bonus eligible store manager listings on a monthly basis.

• Analysis of on hand inventory to assist Director in supporting the business to identify and manage distressed

inventory.

• Uploaded P&L forecast into Hyperion from sales down to EBITDA on a monthly basis.

Lacoste, Inc., New York, NY 07/10 – 02/12

Corporate Analyst

• Prepared and presented accurate retail sales data, with context, to financial managers

• Collected daily sales data from all retail locations into daily sales report as well as distributed key performance

indicators (KPIs) on a daily, weekly, monthly and yearly basis.

• Monitored revenue and cost performance at the store level, reported on actual vs. projected or budgeted line items.

• Created monthly sales forecast by reviewing historical sales data.

• Determined areas of strength and weakness through analysis of MTD and YTD profit and loss.

• Analyzed competitor data and shared information with the Finance team on a quarterly basis.

• Reduced wasteful spending via monthly review of travel and entertainment expenses.

• Identified top wholesale customers for referral to the sales department.

Fendi North America, New York, NY 04/10 – 07/10

Senior Accountant (Temporary Assignment)

• Oversaw monthly financial transactions and accounting operations, including monthly G/L closing, journal entries,

reconciliations and analysis of balance sheets and income statement accounts.

• Reviewed and analyzed vendor invoices and inventory on hand to verify proper credits, reduce waste and eliminate

fraud.

• Maintained logs to track unresolved chargebacks, deductions and resubmission chargebacks.

• Provided financial analysis and reporting to the Controller as needed.

Anvil Knitwear, Inc., New York, NY 10/08 – 01/09

Business Analyst

• Developed a pricing model that calculates margin and customer profitability for each special pricing request.

• Prepared weekly schedules for senior management detailing sales, budget goals and inventory on hand.

• Provided forecasts for potential sales to determine possible CRC credits by distributor.

• Monitored gross margin/selling prices on a daily basis with sales team.

• Reviewed customer sell-thru information and approved customer trailing credits based on their sell thru.

• Prepared ad-hoc sales and profit margin reports by style and customer utilizing Business Objects.

• Reviewed pricing promotion programs to ensure the information was entered properly into the billing system.

Simon & Schuster Inc., New York, NY 04/07 – 10/08

Financial Analyst

• Provided forecasts and estimates of monthly, quarterly and full year expenses to management.

• Prepared monthly financial packages that provided management with insight into variances between current amounts

vs. prior forecasts and periods.

• Monitored operating expenses for Children’s Publishing Division to ensure compliance with budget by performing

monthly variance analyses.

• Reviewed actual performance against departmental budgets, alerting management of potential areas of exposure and

recommending solutions to ensure on-budget performance.

• Created Hyperion reports to track expenses as well as maintain and upload forecasts and budgets into Hyperion.

• Prepared and posted monthly journal entries and accruals to support the monthly closing process.

• Reviewed and coded all invoices in preparation for management approval.

• Created presentation schedules for senior management highlighting budget/estimate variances.

• Prepared and responded to special projects and ad hoc assignments as requested by senior management.

Duane Reade Inc., New York, NY 03/06 – 04/07

Inventory Accountant

• Reconciled annual physical inventories for the entire chain on a store to store basis.

• Updated and adjusted the Retail Stock ledger to complete monthly, quarterly and annual Gross Profit reports.

• Posted and corrected journal entries in AS400.

• Prepared detailed management reports explaining variances and discrepancies as well as other daily adjustments made

to the operating balances.

• Compiled monthly, quarterly and year-to-date Rx inventory Roll-forward reports detailing purchases, transfers, third

party discounts, sales, PDX margin percentages, cost of sales, price file adjustments and physical inventory results.

• Prepared weekly reports detailing changes in the inventory levels of all warehouses and stores.

• Reviewed and analyzed high shrink results with District Managers and Store Managers to determine possible cause.

EDUCATION

BS in Finance & Business Management, CUNY Brooklyn College, Brooklyn, NY

Contact this candidate