Alex Shpak
**** **** *** **. *** #*B • Brooklyn, NY 11224 • 917-***-**** • *******@***.***
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