LinkedInRob Hatton

Rob Hatton

Business Intelligence Architect at Children's Hospital of Orange County

Location
Orange County, California Area
Industry
Information Technology and Services
Previous
  1. CHOC Children’s Hospital of Orange County,
  2. Convergence Consulting Group,
  3. W.S. Badcock Corporation
Websites
141connections

Join LinkedIn & access Rob's full profile

Join LinkedIn & access Rob's full profile. It's free!

As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you know in common
  • Get introduced
  • Contact Rob directly
141connections
View full profile

Background

Summary

I'm a seasoned Business Intelligence developer and architect with proven technical and communication skills. While I'm quite productive (and enjoy) designing and coding relational & multidimensional databases and ETL facilities, my real value is in helping organizations create a highly capable BI team and build Business Intelligence into the organizational culture.

I'm not simply one of those people that happens to work on BI projects. As a co-leader of a local BI user group, regular speaker at BI focused meetings, and author of 'The Business Intelligence Team Handbook', I'm an active member of the community.

Specialties: Relational and Multidimensional design, Extract / Transform / Load processes & tools, reporting tools, requirements gathering & mentoring.

Experience

Business Intelligence Architect

CHOC Children’s Hospital of Orange County
(11 months)Orange County, California Area

During my tenure at CHOC, I worked in both a consultative and individual contributor capacity.
On a conceptual level, I provided counsel to the Executive C level on Business Intelligence patterns and practices. This included assessing the viability of dimensional modeling for several different domains of knowledge (ambulatory, inpatient, labs, ER, etc.) and the various coding systems (ICD-9CM, CPT-4, HCPCS, SNOWMED, etc.). I also created a proof of concept multidimensional hypercube based on encounters which included multiple hierarchies for the time dimension, an organization dimension, and a problem dimension.
As an individual contributor, I constructed ETL packages to interface new systems to a legacy analytic environment (McKesson HPM).

Business Intelligence Consultant

Convergence Consulting Group
(1 year 10 months)Tampa/St. Petersburg, Florida Area

Providing Business Intelligence development and consulting services to multiple clients using both Microsoft and Business Objects tools. Clients included Hillsborough County School District and PODS. One highlight at PODS was refactoring an ETL process to reduce execution time from 4 days to 40 minutes.

Business Intelligence Consultant

W.S. Badcock Corporation
(4 years 6 months)Mulberry, FL

Led an effort to re-architect Business Intelligence systems and re-establish credibility for the group. This involved restructuring relational and multidimensional databases, re-designing ETL components,establishing a reporting system, and championing Business Intelligence within the organization. My efforts encompassed requirements gathering, design, coding, and mentoring.

Skills

  • SQL
  • Relational Databases
  • Multidimensional...
  • SSIS
  • Database Development
  • SSAS
  • T-SQL
  • SSRS
  • Databases
  • Analysis Services
  • Business Intelligence
  • Business Objects
  • Business Intelligence...
  • ETL
  • Data Modeling
  • OLAP
  • Requirements Gathering
  • Dimensional Modeling
  • Data Integration
  • Data Warehousing
  • Data Warehouse...
  • Database Design
  • See 7+  See less

View Rob's full profile to...

  • See who you know in common
  • Get introduced
  • Contact Rob directly

Not the Rob Hatton you're looking for? View more

Insights


People Also Viewed

LinkedIn member directory:

  1. a
  2. b
  3. c
  4. d
  5. e
  6. f
  7. g
  8. h
  9. i
  10. j
  11. k
  12. l
  13. m
  14. n
  15. o
  16. p
  17. q
  18. r
  19. s
  20. t
  21. u
  22. v
  23. w
  24. x
  25. y
  26. z
  27. more