Daniel Jansen Email & Phone Number

Oakland, Ca, Us

Cupertino, California, Us

Conducting holistic analyses front-to-end delivering actionable insights of customers engagement in entire Apple Ecosystem- Business Manager Product Marketing (NPI, Earnings, ITS billings, forecasting, product pricing) for predominantly iPad and OS but on all Apple products through dashboards or keynote presentations. Using advanced analytical methods (clustering, baselining, segmentation) and visualization techniques for building customer profiles.- Marcom Support Modeling and analyzing marketing campaigns through mining target audience based on consumer engagement and reporting the effectiveness- adhoc work for Investor’s Relationship, Executive Team, Legal, and Technical Accounting

Chicago, Illinois, Us

- Leading analytic modeling team of 4 analysts specializing on marketing mix analyses, shopper marketing analyses, and price and promotion analysis for global client portfolio (major CPG companies like Nestle, Mars Wrigley EFFEM, Tyson Foods, Pinnacle Foods, George Weston Foods Australia, Clorox, Constellation Brands, Molson Miller Coors, and non CPGs like Hyatt Hotels) supporting multi million dollars budget decision - Assuring standardized production for modeling process reducing turn-around time - Integrating industry benchmarks of marketing and shopper marketing tactics - Forecasting budget simulation and optimizing product portfolio

Dormant consultancy anything related advanced analytics: marketing mixed models, price and promo models, machine learning, clustering, conjoints, assortment, media/promo effectiveness and efficiency , visualization through dashboards, simulators and other tools for small and big data.

Chicago, Illinois, Us

- Supporting analytically snack brand portfolio (Slim Jim, Orville Redenbacher, Snack Pack, Swiss Miss and others = $1.25B annual sales) 1. Advising and simulating $25MM in A&P based on Marketing Mix Models with Nielsen – Slim Jim got 50+% in budget (+$7MM) 2. Designing and fielding concept tests or other conjoint surveys for price/pack size optimizations3. Testing new products In-Market and forecasting national launch volume4. Adhoc Due-To analysis using POS, Panel, and other causal data5. Trained with IRI Hendry market structure looking for product placement and white space- Trained and supporting consumer analytics team in designing and analyzing conjoints - Awards: received 7 recognitions for accountability, collaboration, teach & trust, and pushing for excellence

Chicago, Illinois, Us

- Support analytically ConAgra’s West Customers (incl. Albertsons, SuperValu and Safeway = about $800MM in sales) and Channel Customers (incl. Costco, Sam’s Club, Walgreens, Dollar General = about $1B in sales) :1. Delivered retailer specific Marketing Mixes, Assortment Optimization, adhoc Due-To’s, analyzed In-store Tests 2. In-housed Conjoint / Choice based modeling at 75% cost reduction and turn-around time cut more than in half3. Measured $60MM annual Shopper Marketing spend for effectiveness and efficiency 4. Improved and maintained occasion dashboard connecting POS, Panel, and NET data in Excelsius5. Mining Loyalty Card data (Segmentation / Clustering, Affinity scoring, Optimal Store Layout)- Special Projects: SNAP Analysis from Giant Eagle’s transaction data, Meijer Convenience store clustering- Awards: Performance Excellence Setting the Standard 2012

Chicago, Il, Us

- Manage project of Shopper Marketing ROI Analysis of CPG client’s retail customer events (including Wal-Mart and Military):1. Oversee team of Off-shore Modeling Analysts, preparing results of 18+ retailers 150+ Shopper Marketing events per quarter (approx. 1,200 models) 2. Responsible for methodology, SAS code, mapping and error resolution3. Coordinate with Off-shore Data Team, handling large POS databases4. Conduct client Shopper Marketing review meetings sharing model results5. Deliver insights from Shopper Marketing results in Measure, Learn, and Change process6. Research process improvement of additional Shopper Marketing analysis - Manage team of two SymphonyIRI consultants at the client site supporting three of the five category pillars in Advanced Analytics, Consumer Insight, Category Leadership, Shopper Marketing, Marketing, Brand, and Supply Chain- Deliver solutions optimizing assortment at national and customer level- Create and maintain 20+ Forecasting Models on brand, SKU and UPC level for CPG’sDemand Planners below 10% MAPE, including based on Wal-Mart Retail Link data.- Perform regression based Due-To Analysis for marketing supportSpecial Project: Worked on Price Elasticity based Impact Tracker for client, Integrated Trade Event Analysis into Shopper MarketingAwards: Make it Happen! October 2011

I volunteered teaching girls how to play soccer from Kindergarten to 6th Grade.

Chicago, Illinois, Us

- Managed 3 Demand Planning Analysts operating the Restaurant Order Proposal forecasting system of McDonalds at 15% MAPE or lower for large product mix (100+ SKUs) in the Japanese market- Participated in cross functional research projects, e.g. 1. Completed Global Trend Analysis for a declining major brand product 2. Created Strategic Scenario Planning for best positioning of company (new investment, already committed resources, necessary skills and capabilities, etc.) 3. Updated Company-wide Business Continuity Plan of other SBUs 4. Forecast Value Added (FVA) analysis of ROP process- Produced strategic plan for my team laying out the vision for mid to long term horizon and the necessary steps to achieve it, aligning with the company’s goal tripling the business over the next 10 years - Designed and implemented improvement of forecasting process by developing innovative solutions, e.g. promotion library, disaggregating sales records, mapping out information in visual form. The changes resulted in allowing for turn around in less than 24hrs from previously days for promotion planning- Oversaw promotional marketing forecasts of 20 short lead time mobile coupon promotion items per week and 1 major monthly FSI coupon promotion including 10 SKUs, including cannibalization and halo effects of promotions on core items - Worked with McDonalds Japan Supply Chain Management defining acceptable deliverables of forecast performance and expectation management of the Demand Planning capabilities - Accounted for the team meeting Key Performance Indicators assuring reducing MAPEs over time separating non-promoted and promoted periodsExtra Activity: - Participant of Accelerated Career Development Program - Lead of Social Responsibility Group

Chicago, Illinois, Us

- Lead a team operating Restaurant Order Proposal system for McDonalds Japan with 4000 restaurants and 100+ products forecasting with a MAPE of 20% or lower- Trained new analysts in programming and modeling by applying time series- Designed approaches for promotion models applying price elasticity in case of new promotion with lack of historic benchmarks increasing forecast accuracy - Communicated with other internal SBUs as liaison, meeting frequently with members from Methods and Standard, Supply Chain Analytics, Supply Chain Integration and IPL Japan.- Assisted in putting together a new Service Level Agreement (SLA) reflecting Changes in scope

Chicago, Illinois, Us

- Forecasted consumer demand for client McDonalds:1. Pilot Roll out of Restaurant Order Proposal in JapanThe forecast contained a horizon of 90 days for 100+ product mix for 4000 restaurant. Assessing historic PMIX, promotion details (GRPs, price, duration, benchmarks, repetition of promotion, etc.), shipment data2. Volume Supply Plan Forecast in the USUsing historic sales data (PMIX) adjusted for recent trend and Seasonality for creating forecast (regional or national) allowing producing the packaging material with graphic change 3. Launch of New Food Forecasts in the US - Shadowed and assisted Advertised Sales Test (AST) creating forecast of new menu item assuring no break in supply for best test results - Analyzed Advertised Sales Test experience and data, adjusted for geographical, seasonal, and marketing execution difference creating a national forecast for acquiring raw material, securing production capacities, producing packaging material and pre-break supply planning of Distribution Centers (DC) - Constructed statistical baseline models capturing consumer behavior using historic sales (PMIX) data, promotion details, seasonality, holidays, and external factors (such as price change, change in technology, etc.) - Manipulate large data sets / data mining using SAS and SQL Plus

Chicago, Il, Us

- Taught weekly supplementary review sessions to complement lectures- Instructed four teaching assistants on grading

Chicago, Il, Us

Chicago, Illinois, Us

- Managed branch budgets and led team of four employees- Planned and set individual and branch sales goals based on projected performances- Exceeded two of five personal & four of five branch goals by more than 15%- Created and implemented sales incentive program- Raised branch's internal ranking from 12th to 3rd place of twelve- Obtained lending license from Omega, Inc. for un- and secured loansActivity: Member of the Profitability Committee

- Opened and maintained individual and commercial clients’ portfolios- Trained 3 personal banker- Authorized secured and unsecured loans

- Analyzed and approved credit cards and consumer loans- Advised clients on financial investments in stocks, bonds, term life insurance, etc.- Supported commercial clients in new business investments through cost-benefit analyses

- Analyzed and approved credit cards and consumer loans- Advised clients on financial investments in stocks, bonds, term life insurance, etc. - Supported commercial clients in new business investments through cost-benefit analyses

M.A., Economics

B.S., Economics

A.A., Economics

B.B.A., Banking And Finance