1 / 18

Prepaid Services

Prepaid Services. What we started with. About 10 different files to manually import into 5 databases Random data stored in Excel files 1 day to import all this data into the 5 databases 2 days to produce weekly Excel reporting by: Write database query Dump raw data into excel

Download Presentation

Prepaid Services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Prepaid Services Delivering Awesome Web Applications

  2. What we started with • About 10 different files to manually import into 5 databases • Random data stored in Excel files • 1 day to import all this data into the 5 databases • 2 days to produce weekly Excel reporting by: • Write database query • Dump raw data into excel • Clean up any data • Crazy pivoting and VLookupsacross dozens of excel files

  3. Enter SSW

  4. We automated…

  5. We consolidated… Shipments Apply SSW Magic:- Primary Keys- Foreign Keys- zsValidateprocs- Naming Conventions- Data validation GAR PPS Activations Regional Recharge

  6. We built…

  7. We created and automated…

  8. Today • SSIS packages are scheduled nightly • Cube processing is scheduled nightly • Can do data loads daily, currently they only get their files monthly • Time to build ad-hoc reports: • Before: Hours/Days • Now: 5 – 30 minutes

  9. We also deployed an MVC 4 app • For helping them match customers coming from two different systems with no unique identifier • Razor, jQuery • 1.5 days

  10. Thank You! Sydney | Melbourne | Brisbane | Adelaide info@ssw.com.au www.ssw.com.au

More Related