John Sobczak

Experience

• 

  Ford Motor Company

  Feb 1992 - Feb 2007

  • Data Center Service Cost & Revenue Model development/management.• $300M+ budget performance review process, X+Y forecast, cost tracking and revenue analysis.• Teradata and Mainframe IT Billing Model development and monthly IT billings to business units of $12M+/Month.• Recruited and retained professional staff to fill needed resource and skill sets.• Established governance and capacity utilization metrics using Six Sigma for Teradata CPU seconds, GB storage and Nodes.• Supported Global Data Center Consolidation for iSeries systems with Europe, Asia, and Australia.• Led customer SOW funding approval and TCO benchmarking studies for Mainframe and Teradata. Show less * Led integration of Ford of Mexico with Ford US assembly vehicle scheduling systems * Core team member in revolutionary In-Line Vehicle Scheduling Systems for Build to Order Sequence by transient VIN assignment.* Team leader for plant Automated Vehicle Scheduling (AVS) systems lifecycle release planning for 20 assembly plants. * Created test plans, scripts and performed on site training and plant implementation * Performed OS/2 DB2 Database application testing, training and implementation * Supported plant Programmable Logic Controller (PLC) application development Show less

  • Data Center Line of Technology Manager

    Jul 2002 - Feb 2007

  • Business Planner

    Feb 2001 - Jul 2002

  • Project Manager

    Aug 2000 - Jan 2001

  • Systems Analyst

    Feb 1992 - Jul 2000
• 

  JP Asset Management

  Mar 2007 - Oct 2008

  Investment Manager/Consultant
• 

  Assurant Specialty Property

  Nov 2008 - Oct 2013

  Develop highly interactive analytical dashboards with Tableau software for business intelligence decisions.

  • Business Analyst

    Jul 2011 - Oct 2013

  • System Analysis & Integration Manager

    Nov 2008 - Jun 2011
• 

  Sogeti USA LLC

  Oct 2013 - Jan 2014

  Manager Consultant, Business Intelligence

  Tableau Software Architect for GE Power & Water BusinessWorked with GE Power & Water data scientists and vast ERP data and reporting environments to model data from large 100+ table schema and created quarterly Finance operational report metrics dashboard.

• 

  General Motors, Global Purchasing and Supply Chain

  Feb 2014 - Apr 2015

  Senior Analyst/Developer

  Business Intelligence, Data & Reporting AnalyticsSupply Chain LogisticsWorked with GM's EDW to develop a BI comprehensive supplier footprint dashboard as well as supplier logistics dashboards using Tableau.

• 

  Majesco

  Apr 2015 - Apr 2019

  Consultant, Business Intelligence

  BI Tableau Consultant for Property & Casualty Insurance BusinessCreating re-useable Data Models and Analytics for Underwriting and Broker Performance & Property Catastrophe Exposure

• 

  Cox Enterprises

  Apr 2019 - Mar 2020

  Consultant, Human Resources, BI Reporting

  Develop Reporting Metrics and Dashboard Reports for Recruiting and Talent Acquisition

• 

  Self Employed

  Apr 2020 - Nov 2020

  Consultant

  BI & Data Analytics Specializing in Tableau, Data Architecture and Data Visualization

• 

  Centric Consulting

  Dec 2020 - Mar 2021

  Sr. Consultant

  Specializing in Business Intelligence, Data Analytics, Data Visualizations, Power BI, Tableau for Commercial Insurance, Policy Retention, Rate Change, CAT Exposure, Loss Development, Reserves Management, etc.

• 

  Cox Enterprises

  Mar 2021 - Dec 2022

  Consultant, HR/People Analytics

  Develop Reporting Metrics and Dashboard Reports for Recruiting and Talent Acquisition