Profileimage by Abhi Jain Retail/CPG/FMCG Business Intelligence & Data Analytics - Solutions Implementation from SaintPaulMNUSA

Abhi Jain

available

Last update: 01.02.2016

Retail/CPG/FMCG Business Intelligence & Data Analytics - Solutions Implementation

Graduation: Masters Johns Hopkins University
Hourly-/Daily rates: show
Languages: English (Native or Bilingual) | Hindi (Limited professional)

Attachments

abhijain_resume_201601.doc

Skills

Introduction
 
How > What. That’s my philosophy: what you can achieve is both enabled and limited by how you get to the solutions. I have a deep interest in improving how organizations get work done, driving efficiencies & better decisions through tools and systems.  I’m a Product Owner, Project Manager, Scrum Master, & Functional Business Analyst with Business Intelligence Data Analytics & Forecasting/Planning subject matter expertise, along with experience in deploying large web-based solutions and bulk data feed projects.  Most of all I’m a fire drill problem solver, with a skill for rapidly mobilizing the necessary people and resources to drive results.
 
Industries
 
 
  • Retail & eCommerce/Online
  • Consumer Packaged Goods (Electronics, Food Manufacturing)
 
  • Health/Medical Insurance
  • Filmed Entertainment
  • Higher Education

 
IT Projects
 
 
  • Hadoop-based SAS Analytics Engine feeding Tableau Dashboard (“ICD10-Early Warning System”)
  • Teradata EDW Bulk Feed Design & Change Mgmt
  • SalesForce Web-based Promotional Planning, Forecasting, Analysis, & Reporting Tool (“MovieZone”)
 
  • MicroStrategy Web-based Design, Backlog & Migration
  • Retek Data Stream Changes
  • Excel-based Forecasting Tool

 
Systems/Tools
 
 
  • Microstrategy & Visual Insights BI (Desktop & Web) (PM & User)
  • SalesForce CRM & Admin Tool (Web) (PM & User)
  • Oracle/Teradata DB Back-ends feeding BI GUI (PM)
  • Accellion (PM)
  • Hadoop-based SAS Analytics Engine (PM)
  • Tableau BI (Training)
  • SAP APO Forecasting/Planning (User)
  • Business Objects BI (User)
  • Qlikview BI (User)
  • Target InfoRetriever (BI) (User)
  • Lumidata SOLYS BI (User)
  • Essbase BI (User)
  • JIRA (User)
  • Clarity (User)
  • Sharepoint (User)
  • Proprietary Retail Software: TGT & BBY (User)
  • Advanced Excel Analysis (Pivot tables, Advanced Functions, some Macros, etc.)

 
Education & Certification
 

Johns Hopkins University
M.A. Government                                                    2006
  • GPA: 3.87
 
Johns Hopkins University
B.A. Intl. Studies                                                       2005
  • Dean’s List last semester
 

Scrum Alliance
Certified Scrum Product Owner (CSPO)                      2016
  • Scrum Alliance Accredited
 
University of St. Thomas
Certified Professional Project Manager (CPPM)          2013
  • PMI Accredited
 
Lean Six Sigma
White Belt                                                                2008
  • Interested in Pursuing Green Belt Certification
 
 

Key Qualifications
 
 
  • Familiar w/Agile, Scrum environments + Waterfall
  • Project Management, Coordination
  • Product Owner, Management
  • Functional Requirements Analysis & Documentation
  • Project Financial Tracking & Reconciliation
  • Business Intelligence, Data Analysis
  • Some familiarity w/Hadoop-based implementations
  • Conduct UAT, UAT Script Writing
  • Excel-based Tool Improvement, Design
  • Supply Chain/Demand/Inventory Planning
  • Sales Forecasting (Retail, Consumer Goods)
  • Effective Meeting Facilitation
  • Working w/International Team
  • Basic HTML, C++ & Java exposure
  • Fluent in English & Hindi

Project history

Professional Experience
 
Experis Consulting (Minneapolis, MN)                                                                                                          
 
Internal Role: Senior Data Analytics Consultant                                                                                          Aug 2015-Nov 2015
 
Client Roles:
Senior Project Manager, Scrum Master, Optum Data Management, United Health Group              Aug 2015-Nov 2015
Responsible for Leading Development team, working with Operations and Support teams to automate & transition, and working with Cross-Functional Project & Business teams to address functional needs/technical concerns.
 
  • Industry wide Medical coding migration to ICD-10 from prior ICD-9 required Analytics engine to alert Finance in case of any erroneous or outlier inputs from Providers & Institutional Clients (Hospitals, Clinics)
  • Oversaw Final Development & Deployment of Hadoop-based SAS Analytics Engine feeding Tableau Dashboard (“ICD10-Early Warning System”)
    • Oversaw post-Deployment QA & UAT
    • Oversaw post-Deployment Operationalization & Issue Resolution for 2 month warranty period
    • Oversaw Automation of Processes & Handoff to Operations/Maintenance Team
  • Responsible for All Financial Management, Tracking & Reconciliation
    • Key Interface with Finance Department
    • Put together Financial Tracking Spreadsheets where none existed
      • Learned Project Financials Reporting system & Utilized Effectively to Sort out Project Financial History
      • Identified key overcharges by Cross-Functional Partners & Offshore Vendors
      • Negotiated Significant Savings Adjustments:
        • $74k reduction in actual receipts for 2 months of work
          • Hours per resource revised by Partners, realized actual savings.
        • $45k reduction in Forecasted/Projected work for 3 months
  • Key Liaison between Developers, Program Managers, Business Process Consultants, Infrastructure & Architecture Teams, Finance, External PMs (Ernst & Young):
    • Oversee Scrum team of 7 Onshore resources
    • Lead multiple weekly & ad-hoc meetings with cross-functional Project/Scrum teams, Experts, Program leadership
  • Systems: Hadoop, SAS, Tableau, Sharepoint, Rally, PlanView, FieldGlass
 
AIM Consulting Group (Minneapolis, MN)                                                                                                   
 
Internal Role: Business Intelligence Consultant                                                                                           Aug 2014-June 2015
 
Client Roles:
Scrum Master, Business Intelligence, Target Corporation                                                                         Apr 2015-June 2015
Project Manager/Product Lead, Business Intelligence, Target Corporation                                          Dec 2014-Apr 2015
Business Analyst, Business Intelligence, Target Corporation                                                                    Aug 2014-Dec 2014
Responsible for Solutions Development, Leading Development team (On & Offshore), working with Business & Project teams to address functional needs/technical concerns, and gathering requirements from Target’s external Vendor partners.  Lead massive 3500+ external Vendor-facing Business Intelligence projects: Teradata based Bulk Data migration of 4 Market Share/Insights Vendors to new EDW setup, and Web-Based Microstrategy development & migration of 3500 external users.
 
  • Projects span multiple Epics and Products
  • Key Liaison between Developers, Program Managers, Business Process Consultants:
    • Oversee Scrum team of 22 resources (5 Onshore, 17 Offshore)
    • Lead multiple weekly & ad-hoc meetings with cross-functional Scrum teams, Experts, Program leadership
  • Key Point of Contact for External Market Share Vendors
  • Drive development of Web-Based Microstrategy “MerchIQ” Business Intelligence reporting tool for 3500+ users
    • Oversee migration of users from legacy Info Retriever BI tool to MerchIQ
  • Design and oversee development of new EDW based Bulk Data feed for Market Share/Insight Vendors (AC Nielsen, IRI Worldwide, NPD Group, SPINS)
    • Win: Vendors will now receive Omni-Channel bulk data (a first) and this data will separate order origin points (ie Web, Mobile, Store, Amazon, etc.) from Order Shipment Channels (Whse, Store, Direct from Vendor)
    • Win: previous feeds were weekly cadence, now sales data is Daily
    • Win: previous feeds missed any POS sales data that came in 1 day late (ex: Hawaii & Alaska) – this amounts to ~1% sales, Vendors will now receive these sales.
  • Systems: MicroStrategy (Desktop & Web, Visual Insights) Business Intelligence, Teradata EDW, Accellion, Clarity, Sharepoint, JIRA
 
Twentieth Century Fox, Filmed Entertainment Group (Richfield, MN)                                                  July 2012-Aug 2014
 
Category Manager, Best Buy Account
Responsible for System Development, Process Improvement, Promotion Planning System Support, Customer/Internal Reporting, Excel-based Tool Development for New Release Movie, Catalog Movie, and TV businesses. Enable Demand Planning team to put in place inventory analysis best practices and develop/maintain/update excel based tools to help them project and correctly time inventory acquisition. Help Demand Planning analysts make faster, more accurate decisions. Point of contact for Demand Planning & Merchant system/IT concerns, so can serve as conduit by translating business to IT language and vice versa, and helping gather high level requirements and coordinating projects.
 
  • Key Point of Contact for Data & Systems between Fox Cat Man leadership, Fox IT and Best Buy Demand Planning, IT, Merchant, & Finance teams (Operating as Hybrid Product Owner, Business Analyst, & Data Analyst)
    • Lead multiple weekly meetings with cross-functional teams including Open Labs
    • Drive development of solutions for Web-based SalesForce CRM-based Planning & Forecasting system (“MovieZone”) & manage through Salesforce Admin Tool
    • Oversee development and changes to Daily Retek/RMS/EDW/Apptalk Data Feed
    • Enable Citrix-based MSTR Reporting & Access for BBY users; create canned reports
    • Conduct User Acceptance Testing (UAT), Write UAT Scripts
  • Write Functional Requirements Documentation for Web-based SalesForce MovieZone Enhancements & Features
    • Gather high-level requests, Work w/End Users to Refine & Prioritize, Coordinate Communication & Mtgs
    • Translate IT requests/issues and Business/Client requirements back and forth
    • Create & Maintain Development Log to compile & track all system implementation & enhancement timelines
  • Took initiative on creating new value-added reporting and tools:
    • New Release Lifecycle & Fixture Performance Forecasting Tool: Work w/BBY on gathering requirements and constantly modifying to build New Release Lifecycle Planning Tool in Excel.  This was the proof of concept and allowed refinement/optimization of the logic and functionality, and was eventually integrated into SalesForce functionality.
    • Forecasting Accuracy Report, Box Office/Comp Title Forecasting Tool
    • Decay-Curve based Order Estimator Tool
    • Weekly Demand Planning Reporting to optimize Inventory by various characteristics relevant to filmed entertainment.
      • Tracking forecasting/inventory accuracy and optimizing inventory mix along Format, Working Group and especially by Vendor.
      • BBY Team uses this in Weekly/Monthly Presentation to Merchants & Leadership
      • BBY Team uses this in Weekly Conversations w/Studio Inventory Teams
    • Store-SKU reporting to show Sales performance & Inventory efficiency by store, as well as SKU performance by Store Groupings
  • Working w/IT on Regular Data Validation of Sell-thru & Inventory Reporting
  • Training Best Buy and Vendor Team -members on Systems Functionality (MicroStrategy, MovieZone, Excel Help)
  • Initiate, Gather Requirements, Prototype Forecasting Tool (complex multi-variable)
  • Systems:Salesforce.com CRM/API interface (MovieZone) & Admin Tool, MicroStrategy (Desktop & Web, Visual Insights) Business Intelligence
 
Philips Consumer Lifestyle (Minneapolis, MN)                                                                                            Mar 2011-June 2012
 
Business Planning Manager, Target & Best Buy Accounts
Responsible for Forecasting/Inventory Planning, Purchase Order Management, Customer/Internal Reporting, Item Setups, Sales Support, and Incremental Selling for Philips Portable DVD, MP3 Players, Apple Docking, Micro Stereo Systems, Headphones, Mobile Phone Accessories, Home A/V and Surge/Power Categories.
 
  • Forecasting Tool: Developed Excel-based Consumption (POS) and Receipts Forecasting Tool for SKU-Weekly periodization in the absence of statistical forecasting system
  • Process Improvements: Implemented Process where none existed for better alignment between internal cross-functional partners, designed & implemented Excel based tracking and forecasting tools
  • Systems: SAP APO, Business Objects, Qlikview, Target InfoRetriever, Partners Online (POL), Extending the Reach (BBY Vendor Portal), BBY PIM, Lumidata SOLYS BI
 
General Mills (Minneapolis, MN & Rogers, AR)                                                                                           May 2010-Feb 2011
 
Customer Demand Planner, Walmart Account
Responsible for Forecasting/Inventory Planning for entire Walmart Dry Channel: Big G Cereals, Dry Snacks, Progresso Soup, Green Giant, Betty Crocker, Dry Meals/Box Dinners, Old El Paso brands.
 
  • Process Improvement Project: Streamline Workflow & Cross-Functional Setup/Interaction of Customer Demand Planner Role
  • Systems: SAP APO, Trade Planner, Allocation Tracker, Bex, Business Objects, AVE, Essbase
 
Paradigm Sourcing International, LLC                                                                                                            Mar 2009-Dec 2010
 
Entrepreneur/Small Business Owner (Minneapolis, MN)
Utilized skills and knowledge from Retail and Supply Chain industries to start small business venture focused on sourcing and distributing EVA plastic products at advantageous prices from China/Vietnam/India.
 
  • Attended Canton Import Export Fair as buyer/vendor—largest Chinese trade expo
  • Arranged for service with Warehousing & International Logistics/Shipping Providers
 
Best Buy Co., Inc. (Richfield, MN)                                                                                                                    Dec 2007-Feb 2009
 
Demand Planning Analyst, Best Buy Mobile
Responsible for day-to-day management, involving sales/inventory projection, ordering, purchase orders, supply chain/logistics coordination, and reporting to leadership for Verizon and Alltel Wireless accounts.  Daily analysis of inventory status, sales data, and Open-to-Buy financial viability to pursue best business decisions.  Weekly presentations to VPs, Director, and Supply Chain Manager on sales analytics, promotional/pricing events, and inventory availability.
 
  • Successfully launched Verizon Blackberry Storm across Best Buy Chain
    • Set the department standard with Blackberry Storm Inventory Plan utilizing advanced excel-based modeling
  • Worked with eCommerce Planning team to guide BBY Mobile product offerings via Simplexity
  • Systems: Retek, JDA, ETR, Simplexity
 
The Target Corporation (Minneapolis, MN)                                                                                                  Dec 2006-Sept 2007
 
Business Analyst, Merchandise Planning
Responsible for day-to-day management, involving marketing/pricing strategy, financial analysis, sales/inventory projection, import commits/domestic ordering, safety stock calculations, supply chain/logistics coordination, and reporting to leadership for six highly profitable and visible categories.  Balanced Open-to-Buy financial allowances for weekly spending reviews and monthly forecasting with VPs, Directors, Senior Buyer, and company accountants.  Weekly status reporting to Merchandise Planning Managers, 2 Buyers, and Division Captains.
 
  • Ran top two most profitable categories in Domestics division, Shower and Beach
  • Negotiated $800,000 discount on shipped inventory with Asia-based vendor; engaged in frequent negotiations on cost/markup, vendor inventory procurement and positioning, inventory reserves, and shipping timing
  • Systems: InfoRetriever (IR), Prospace, IMN, POL
 
The Johns Hopkins University (Washington, DC)                                                                                                         2005-2006
 
IT Administrator, Advanced Academic Programs
Responsible for day-to-day management of University IT Infrastructure (Networking Hardware, Computer Labs, Minor Student and Faculty Software Issues) for Washington, DC campus.  Handled small projects and initiatives, while juggling the responsibilities of a Master’s thesis.
  • Systems: JIRA

Local Availability

Only available in these countries: USA
Physical Location: anywhere within the Minneapolis-Saint Paul, Minnesota, USA area.

Telecommute: available to telecommute/work remotely.
Profileimage by Abhi Jain Retail/CPG/FMCG Business Intelligence & Data Analytics - Solutions Implementation from SaintPaulMNUSA Retail/CPG/FMCG Business Intelligence & Data Analytics - Solutions Implementation
Register