- decomission a legacy bespoke PHP application
- replace it with an open source ETL where it makes sense to do that
- transition it's functions into other things where it doesn't
So the bits which jump out immediately:
- Replace with open source ETL
- List items to replace with OS ETL
- Evaluate for commonalities
- Refactor into separate item
- Foreach item
- Detail how they will be replaced
- Transition to other things
- List "other things," each and every one of them
- Evaluate for commonalities
- Refactor those into separate item, if applicable
- Foreach item
- Decide to what will it be transitioned
- Deciding can be a project in itself, alas.
- How will that transition occur
- Decide to what will it be transitioned
Once you have those items identified…
- Split into phases
- Common bits for ETL & non-ETL (if applicable)
- Break down each phase
- Run past team member(s) for reality check/best & worst case scenarios
- Work with teams for estimates
- Correlate against customer needs
- Add appropriate padding
- Set delivery dates for each phase