Cloud Migration

Client is a Class I railroad and holding company with railroad investments in the United States, Mexico and Panama. The company has a rail network which comprises approximately 6,700 route miles in the U.S. and Mexico.
DOWNLOAD
Business Need
  • Migrate legacy systems to Cloud
  • Maintain 10 years of history data
  • Modernize the entire application landscape by upgrading the databases and establishing a new data warehouse
  • Real-time map visualization of train traffic for routes, yards/terminals and other linear assets
  • Establish Data quality and Data Governance
Our Solution
  • Leveraged Informatica Cloud platform to customize ETL Solutions, to support the migration and optimization of data transfers between legacy system and Azure cloud data warehouse
  • Built custom API’s using Cloud Application Integration to maintain the history in Data Lake
  • Developed customized dashboards using Power BI to visualize and monitor the live feed
Business Benefit
  • Upgraded underlying applications and services while boosting efficiency and effectiveness
  • Live dashboards helped monitor testing of track, yard /terminals Automated migration process to monitor and restart the job, if there is any failure
  • Improved business’ operational efficiency
DOWNLOAD