Rick’s Resume

Rick Grantham 2015-01 <– Formatted version of Resume

Rick Grantham, CBIP, 6SBB

Director: Business Intelligence Solutions
EPI-USE Office Location EPI-USE America, Inc. Atlanta, GA
EPI-USE Phone Number (678) 872-0040

Profile

  • Specializes in developing Business Intelligence and Data Integration strategies to improve data quality, reliability and end-user adoption
  • Extensive experience in managing Business Intelligence and Analytics deployments. Leading Business Intelligence deployments on four continents.
  • Highly analytical consultant that can solve complex business problems. A Six Sigma Blackbelt that has led the Data Mining and Six Sigma Divisions for a Fortune 500 Company.
  • Leadership and Management consultant with over 20 years Executive/Director level experience. Holds a CBIP (Certified Business Intelligence Professional) certification fro The Data Warehouse Institute with the specialty in the Leadership & Management of Business Intelligence teams.
  • Consultant is an eloquent communicator. Consultant typically speaks at 2 Business Intelligence and & Analytics conferences a year with a focus on Analytics strategy.

Key Skills Summary

Technical & Leadership

  • Enterprise Data & Business Intelligence Architecture
  • Business Process Engineering – Six Sigma Blackbelt
  • Data Integration – Data Warehouse and ETL. Data Cleansing, Staging, etc
  • Business Mergers – Extracting Business needs from acquired companies and delivering analytics
  • 20 years in Analytical leadership roles – High-end analytics and data mining
  • CBIP Certification in BI Leadership & Management from TDWI (Certification #111546)
  • 17 years Process and Program Management
  • Process Design Improvement Engineer – 6 Sigma Blackbelt – BMG Certified

Functional

  • HCM
  • Sales
  • Manufacturing
  • Inventory
  • Finance

Project Experience – Detail

Employer EPI-USE America
Duration 2010 to Present
Role 2012-Present Director: Business Intelligence Solutions
2010-2012 Business Intelligence Strategy & Project Manager
Industry Business Intelligence

Clients served

Newport Corporation – (Laser Manufacturing) – 2014
2,550 employees
Role: Chief Business Intelligence Architect and Developer

Versions: Qlikview 10.0, BusinessObjects 4.2, Explorer, Design Studio, Analysis for OLAP, Dashboard Designer (Xcelsius), Crystal Enterprise, Advanced Analysis for Office, WebIntelligence.

  • Systems were being merged due to an acquisition.
  • Responsible for architecting, scoping and redeveloping analytics and reports used by the acquired company.
  • Management of team responsible for data acquisition, data modeling, and data presentation
  • Functional areas include Sales, Purchasing, Quality Management and Human Resources.

Koch Business Solutions K.B.S. – (Conglomerate) – 2013
70,000 employees
Role: Chief Strategist, Business Intelligence

  • Drove the functional and technical review for the Business Intelligence landscape.
  • Advised client on tool deployment, optimizing user adoption, and data architecture.
  • Led team that provided a roadmap for data architecture, data governance, business intelligence and analytics
  • Final delivery included a multi-year Business Intelligence strategy for HR Department.

Massachusetts Institute of Technology M.I.T. – (Higher Education) – 2013
1,000 employees
Role: Leader of Process and Data Stream Redesign

  • Process redesign and Six Sigma project
  • Responsible for analysis, design, project management and consensus building amongst the Technology departments to create the TO-BE process for new employee provisioning
  • Redesigned data flow so that the provisioning process decreased from 5 days to real-time.
  • Led the effort to design and evaluate integrated systems used to manage the new hire provisioning process.

Gwinnett County – (County Government) – 2013
5,000 employees
Role: Chief Strategist, Project Manager, Daily Point of Contact
Ongoing Role: Trusted Ongoing Advisor for BI Program Management

Versions: BusinessObjects 4.4, Explorer, Dashboard Designer (Xcelsius), Crystal Enterprise, Advanced Analysis for Office, WebIntelligenc

  • Led team of technical and functional analyst to determine the “ultimate reporting strategy” for the County
  • This included interviews with departmental stakeholders (Police, Fire dept, etc) as well as a technical review of the Business Intelligence landscape
  • Final delivery included the installation/configuration of BusinessObjects 4.4, as well as a multi-year Business Intelligence strategy to maximize user adoption.

Newport Corporation (Manufacturing) – 2012
2,550 employees
Role: Project Manager & Dashboard Designer

Versions: BusinessObjects 4.2, Explorer, Dashboard Designer (Xcelsius), Crystal Enterprise, Advanced Analysis for Office, WebIntelligence

  • Definition and execution of Business Object POC
  • Primary point of daily contact with client.
  • Led design sessions with customer to brainstorm, gather, and document POC deliverables.
  • Led development team for installation and deployment of POC.
  • Primary developer for Dashboards and Advanced Analysis for Office.

Pacific Gas & Electric – PG&E (Energy) – 2012
22,000+ employees
Role: Chief Strategist for Business Intelligence and Analytics

Versions: SAP e-Recruiting, Xcelsius, Crystal Reports, WebIntelligence

  • Drove multi-year Business Intelligence Roadmap for HR
  • Advised customer on how to optimally deploy analytics that meet corporate strategic goals

Rowan Companies (Energy) – 2012
2,500+ employeesRole: Business Intelligence Workshop Leader

Versions: BusinessObjects 4.2, Explorer, Dashboard Designer (Xcelsius), Crystal Enterprise, Advanced Analysis for Office, WebIntelligence

  • Translated HR executive opportunities into viable Business intelligence recommendations via workshops and long/near term roadmap
  • Drove the collection of metrics, dimensions and reporting pain points for client.
  • Recommended a BI Roadmap to meet long/short-term objectives

SAP (Enterprise Software) – 2012
52,000+ employees
Role: Project Manager and Daily Point of Contact

Versions: SAP EPM10 Excel Add-in, Payroll Cost Planning, BW

  • Leader and Project Manager for development team that built a Rapid Deployment Solution for Operational Headcount Planning.
  • Drove the execution of requirements gathering, product delivery, timelines, and development team leadership.

Pacific Gas & Electric – PG&E (Energy) – 2011
22,000+ employees
Versions: SAP e-Recruiting, Xcelsius, Crystal Reports, WebIntelligence
Role: Functional Lead

Work with business leaders to determine KPI’s and reports needed to support SAP e-Recruiting rollout from legacy systems such as Taleo. Facilitated requirements gathering workshops, documented requirements, and designed prototypes for Dashboards and reporting.

EPI-USE (Internal e-Recruiting project) – 2011
1,100 employees
SAP BW 7.01, BI4.0
Role: Developer

Worked with recruitment team to understand process in talent sourcing in order to identify KPI’s and metrics for comprehensive e-recruitment reporting solution.

Eskom (Energy) – 2011
32,000+ employees – South Africa
Versions: SAP BPC 7.0
Role: SAP BPC Developer

Gathered reporting requirements, compiled specifications and delivered SAP Business Objects BPC reports.

Pacific Gas & Electric – PG&E (Energy) – 2010
22,000+ employees
Versions: SAP R/3, LMS

Optimized data entry processes for data related to Trainer and Course assignments. Led team that created function modules to extract data from SAP to supply to the BW team. Responsible for timelines, escalation, and deliverable of function module data.

Employer Convergys, Jacksonville, FL
Duration 2002 to 2010
Role Global Director
Industry Business Intelligence & Analytics Consulting – HR Outsourcing

Responsibilities Business Intelligence & Reporting

  • Delivered Business Intelligence solutions to clients such as the State of Florida, Boston Scientific and Johnson & Johnson.
  • Initiated, sold internally, and led a team to deliver a Business Objects Business Intelligence Environment to Convergys HRM operations and technology teams – worldwide.
    Analytics
  • Saved $10M per year. Led Six Sigma project that recaptured stranded seat capacity around the globe at Convergys.
  • Led team of Seven 6-Sigma Blackbelts and Four Dataminers that managed high priority projects for the corporation

Clients served

Johnson & Johnson (Consumer Products)

100,000+ employees – Global Footprint
Versions: Cognos 8.4 ETL, Dashboards, Scorecards, Reports and Query Studio

State of Florida (Public Sector)

100,000+ employees
Versions: Oracle Warehouse Builder and Oracle Reports

Boston Scientific (Medical Devices)

20,000 employees – Mostly North America with a small presence in Ireland, France and Puerto Rico
Versions: Cognos ETL, Reports, Query Studio and Analysis Studio

Responsible for the entire HCM Business Intelligence environment, from requirements gathering teams, to data warehouse development and BI deployment teams. Integration of ERP PeopleSoft data with non-ERP legacy systems such as Taleo for Recruiting and Kronos for Timekeeping.

Employer Citibank, Jacksonville, FL
Duration 1994 to 2001
Role Vice President – Risk Management
Industry Finance – Credit Cards

Responsibilities

Analytics

  • Saved $20M per year. Built Over-Limit and Past-Due Algorithms.
  • $5 Billion Bankruptcy Paper Sold. Lead Analyst in determining appropriate strike price for $5B in Bankruptcy paper sold.

Finance

  • <1% Forecast Variance Credit Loss Forecasting at Citibank based on $686M forecast. Achieved by correlating Bankruptcy losses to GDP and Nationwide revolving credit.

Operations

  • 15% productivity improvement as the Jacksonville Leader for the Citibank Recovery Department.
  • “Top Collections Manager in Credit Card Industry”. Distinction provided by Roger Willis Associates.

General Information

  • Citizenship US
  • Consultant’s home Location Jacksonville FL
  • Languages English
  • Education BS, Jacksonville University
  • CBIP Certification in BI Leadership/Management, tdwi
  • Six Sigma Blackbelt – BMG
  • SAP Business Objects BPC 310 – BPC Application Configuration
  • SAP Business Objects BPC 320 – BPC Reporting, Budgeting, Journals
  • SQL Server 2005 Reporting Services (SSRS)
  • Minitab – Basic Statistics, Factoral Design, ANOVA, Advanced Service Quality
  • Cognos Report Studio
  • Cognos Data Manager ETL

Public Speaking

2015

PASS Business Analytics Conference – April 2015
http://tinyurl.com/laf9rjy

2014

Sapphire/ASUG 2014 – Gwinnet County BusinessObjects Strategy Update
http://tinyurl.com/ofb85x3

HR2014 – Requirements Strategies for defining your HR Dashboards
http://tinyurl.com/llenpq6

2013

ASUG BOBJ Annual Conference – Gwinnett County: Why and How Gwinnett County Developed a Multi-Year SAP BusinessObjects Strategy
http://tinyurl.com/mo76cfz

HR2013 – Guidelines for creating an effective HR reporting strategy for your organization: Tools, metrics, and analytics