
Financial Analyst at Foundation 9 Entertainment
Greater Los Angeles Area

Financial Analyst at Foundation 9 Entertainment
Greater Los Angeles Area
Financial Analysis, Database Design, Data Warehousing, Querying, Forecasting, Microstrategy software solution (report, metric, filter, security, ETL understanding, Freeform SQL) and Rock Snobbery...this means I liked bands before you did (HA!).
Financial Planning and Analysis. Heavy Excel, Access, SQL Querying, SQL Management Tools, TOAD (makes some SQL easier, some not so much easier), and now it seems general Data "stuff".
(Privately Held; 501-1000 employees; Computer Games industry)
March 2008 — Present (6 months)
Data Analysis, and Financial Forecasting. Implementing Microstrategy IS solution, integrating with current systems, and harnessing old ones to better understand and interpret financial reporting.
Data scrubing, data validation, and data ______ (fill in the blank).
(Privately Held; 51-200 employees; Consumer Electronics industry)
July 2007 — March 2008 (9 months)
Creation of sales forecast system using SQL data structures, Access, and Excel. Gross margin analysis, contribution analysis, and revenue analysis with the ability to "dig" and slice the data to the retailer/SKU level. Analysis and integration of sell through, seasonal, historical, and NPD data for future inventory (company and retailer) analysis.
(Public Company; 1001-5000 employees; GTW; Computer Hardware industry)
January 2007 — July 2007 (7 months)
Business Analyst - Created and maintained International Financial forecasting model for Gateway and eMachine retail sales division. Utilized hedging, currency exchanges, variable freight costs, dynamic demand and product listing, multiple international and individual retailer business models. Created and maintained databases and automated spreadsheets to categorize, sort and analyze sell through data using EDI imports (raw data), Visual Basic Macros, and program integration between Microsoft Access and Excel. Responsible for “Profitable Sell Through Report” – used to analyze and predict retail sell through data based on seasonal cycles, predicted and trend data, actual data, historical ad lift, and additional qualitative and quantitative data. Determined effectiveness of retailer ad lift based on criteria such as placement, savings, seasonality, etc.
(Privately Held; 1001-5000 employees; Financial Services industry)
June 2005 — January 2007 (1 year 8 months)
Secondary Marketing Analyst - Negotiated Trade Sales, Developed and maintained rate sheets and loan pricing mechanisms for both wholesale and retail branches, including creation of underwriting matrix. Data mining with Access and Excel. Review for integrity and accuracy of data. Reviewed all financial transactions associated with respective trades, including but not limited to: pricing, purchase advices, premium recapture, repurchases, and post purchase adjustments
Financial Analyst/Treasury Analyst (until July 06) - Lead in mining and Analyzing financial metrics to determine profitability of divisions/product lines as well as cost management and budgeting for a 1000+ employee company. Worked with and compiled daily cash report based on account balances, projections, and float. Set up online systems for transferring money between operating, excess, investment, and credit card accounts. Project Management for several different interdepartmental projects.
Business, Marketing, 1999 — 2005
Bachelors, Business - Marketing, 1999 — 2005
Computer Gaming, Music Creation and Enjoyment
Junior High Mathlete (had to put something right?)