The Metropolitan Transportation Authority (MTA) is North America’s largest transportation network, serving 8.6 million customers a day in New York City, Long Island, southeastern New York State, and Connecticut – equivalent to one in every three public transit customers in the country.

Challenge

Initially, most of the client’s resources were stored in a centralized data repository in Oracle. The Orion team planned to migrate these resources to the SQL Server, and the client asked us to execute the migration, assessment and training processes for the internal teams. Before starting the migration, we assessed the migration challenges, trained the internal IT team on the SQL server and provided a digital road map.

Solution

The Orion team conducted a Data Environment Assessment and impact analysis on the challenges and areas of the system that could possibly affect migration using a proprietary Data Assessment Scorecard Framework. Next, we installed and configured the SQL Server Migration Assistant and our Orion Data Migration Accelerator, before identifying the gaps within the system, submitting a detailed report, updating the road map and conducting internal SQL Administration trainings.

Results

Orion successfully provided guidance on navigating the migration road map. Thus, the migration was successful without any disruption to the existing business, as we reconfigured the required dashboards and reports to the SQL Server, resulting in data-insight based decision making.

Related Work
Keep Connected