Jeremy Clover

Current

• Owner at Orange Box Technologies
• Financial Systems Analyst at Foundation 9 Entertainment

Past

• Marketing Analyst at Westinghouse Digital
• Business Analyst at Gateway
• Secondary Marketing Analyst at Secured Funding

see less...

Education

• University of California, Irvine - The Paul Merage School of Business
• California State University-Long Beach - College of Business Administration

Recommended

1 person has recommended Jeremy

Connections

94 connections

Industry

Computer Games

Websites

• My Employer
• MicroStrategy Blog

Jeremy Clover’s Summary

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.

Jeremy Clover’s Specialties:

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".

Jeremy Clover’s Experience

• Owner

  Orange Box Technologies

  (Information Technology and Services industry)

  June 2009 — Present (6 months)

  Data Automation and Business Intelligence Solutions

• Financial Systems Analyst

  Foundation 9 Entertainment

  (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.

• Marketing Analyst

  Westinghouse Digital

  (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.

• Business Analyst

  Gateway

  (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.

• Secondary Marketing Analyst

  Secured Funding

  (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.

Jeremy Clover’s Education

• University of California, Irvine - The Paul Merage School of Business

  MBA , Business , 2009 — 2012 (expected)

• California State University-Long Beach - College of Business Administration

  Business , Marketing , 1999 — 2005

  Activities and Societies:

  Presidents Scholar - Acadamic Scholarship

Additional Information

Jeremy Clover’s Websites:

• My Employer
• MicroStrategy Blog

Jeremy Clover’s Interests:

Computer Gaming, Data Mining, Learnin' Stuff, Music Creation and Enjoyment

Jeremy Clover’s Honors:

MicroStrategy CRD (Certified Report Developer)

Jeremy Clover’s Contact Settings

Interested In:

• job inquiries
• business deals
• reference requests
• getting back in touch