
Financial Systems and BI Analyst at Foundation 9 Entertainment
Greater Los Angeles Area

Financial Systems and BI Analyst at Foundation 9 Entertainment
Greater Los Angeles Area
Financial Analysis, Database Design, Data Warehousing, Querying, Forecasting, Microstrategy Certified Report Developer, general MicroStrategy knowledge (reporting, metric creation, filters, security, ETL understanding, Freeform SQL) and Rock Snobbery...which means I liked bands before you did.
MicroStrategy Reporting and Projects, Financial Planning and Analysis. Heavy Excel, Access, SQL Querying, SQL Management Tools, TOAD (makes some SQL easier, some not so much easier), and general Data "stuff".
(Information Technology and Services industry)
June 2009 — Present (6 months)
Data Automation and Business Intelligence Solutions
(Privately Held; Computer Games industry)
March 2008 — Present (1 year 9 months)
Data Analysis, and Financial Forecasting. Implementing and Maintaining Microstrategy (ETL processes, SQL, report making, project maintenance, Dashboarding, OLAP Cubes, Administration) IS solution, integrating with current systems, and harnessing old ones to better understand and interpret financial reporting.
Data scrubbing, data validation, etc.
(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.
MBA , Business , 2009 — 2012 (expected)
Business , Marketing , 1999 — 2005
Computer Gaming, Data Mining, Learnin' Stuff, Music Creation and Enjoyment
MicroStrategy CRD (Certified Report Developer)