iPad app to manage photos stored in cloud?
Adobe Revel ($5.99pm or $59.99py)

Adobe Revel (previously called carousel) is a cloud photo editing and storage app, similar to Adobe Lightroom with the added function of being able to store images in the cloud. It is a subscription based service.

However this is currently only available on iOS, and Mac, with both Windows and Android currently in development.

If you were desperate to use this solution, you can get the iPad app, and sync the photos over iTunes and then use the app to pop the images in the cloud, however this would be time consuming, the Adobe website has a notify me, button on Windows/Android, so this platform will be available.