Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Agile Data Warehousing

No description
by

bruce szalwinski

on 20 August 2013

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Agile Data Warehousing

Chris Mills and Bruce Szalwinski
Agile Data Warehousing
Agenda
Assessing Agile
at Cobalt
Introduction
Where we’re at now
What the journey to Agile looked like
What was required
Results, good and not so good
Future Directions
Roles, Process and Infrastructure
Agile at Cobalt
An Agile Success Story
Let's Migrate the
Warehouse!
Benefits, Challenges, Next Steps
Release cadence:
Now: 70+ releases / year
Before: 6 – 8 releases / year

Improved quality
Now: 1 “must fix” issue / quarter
Before: 1 “must fix” issue / month, at least :)

No longer need headcount dedicated to testing
Growth in technical skill set on team
Able to adjust as business demands
Process
Phase 3: Automate Everything!
What Does the Team Look Like?
Team
Improve the break / fix cycle
Move along the Continuous Integration path
Continue to build “generalized specialists”
Make testing cycles more efficient

Company
Rolling out Agile to all of ADP development

Partners
Rolling out to EMC development
Where Do We Go From Here?
Finding qualified Product Owners
Teams bog down without good inputs

Growing the Dev team’s skill set
Must focus on tests first. Not their preferred tasks.
Traditional ETL work turned into SW Engineering.
Need to invest in learning curves

Coordination across multiple fast moving teams
Coding and testing standards
Feature incompatibility or collision

Agile with 5 teams and 3 time zones is tough
Lots of early morning or late night meetings
Infrastructure
Product Owner
Key stakeholder, has vision of what is to be built

Scrum Master
Process owner, coach, removes obstacles, protector

Scrum Team
5-9 people, cross-functional, self-organizing
Roles
Phase 2: Starting the Move to Agile
2009: The Manual Days
Waterfall process, one small team
2010: Move to Agile
Team gets introduced to Agile
BI culture starts to evolve
2011: Automate, automate, automate
Team growing rapidly
2012: Complete migration
Agile Timeline
Marketing Services for the Automotive Industry
Platform: Websites, Inventory, Search, Display, Email, Social
Covering ~50% of US market, and 4 countries
Our BI focus is to measure:
Consumer behavior
Vehicle supply / demand
Advertising performance
BI Customers
Automobile manufacturers and dealers
Bid Engine, Ad Optimization Specialists
Product owners
What Does Our Team Do?
Thank You

Chris Mills – cmills@cobalt.com
Bruce Szalwinski – bszalwin@cobalt.com
Questions?
Getting to Agile
Phase 1: Everything is Manual
2009
2011
2010
Three easy phases :)
Benefits
Challenges
(c) ADP Dealer Services, Inc. All Rights Reserved. Confidential and Proprietary.
Doing an Agile Migration
75 Workflows
100's of Reports
5,000 Unit Tests
Test
Release
2,000 more tests
Molasses Swamp
Zero Defects!
Load
System Overview
Where we have been since Feb 2013
Build a build light, emphasis on being responsible for checkins

Looking for ways to test dynamic data sources

Rotating scrum master role

Agile continuing to rollout across ADP
Full transcript