US 12,321,323 B1
Data migration factory
Bobby Melvin Underwood, Jr., Shawnee, KS (US); Patrick David O'Connor, Rocky River, OH (US); Sujit Ghosh, Pittsburgh, PA (US); Dave Blackett, Pittsburgh, PA (US); Avneet Buttar, Pittsburgh, PA (US); Kelly Drake Winters, Pittsburgh, PA (US); Megan Dahlinger, Pittsburgh, PA (US); Andy Fedigan, Pittsburgh, PA (US); Marie Hoge, Pittsburgh, PA (US); Amit Shrivastava, Pittsburgh, PA (US); Mark Martonchik, Pittsburgh, PA (US); Brian Klein, Pittsburgh, PA (US); David Solomon, Pittsburgh, PA (US); Aaron Krocker, Pittsburgh, PA (US); Shaun Lineberry, Pittsburgh, PA (US); Rahul Gaikwad, Pittsburgh, PA (US); Robert Depasquale, Pittsburgh, PA (US); John Lysowski, Pittsburgh, PA (US); Matthew Lehn, Pittsburgh, PA (US); and Suhail Hasham, Pittsburgh, PA (US)
Assigned to The PNC Financial Services Group, Inc., Pittsburgh, PA (US)
Filed by THE PNC FINANCIAL SERVICES GROUP, INC., Pittsburgh, PA (US)
Filed on Feb. 20, 2024, as Appl. No. 18/582,301.
Claims priority of provisional application 63/486,225, filed on Feb. 21, 2023.
Int. Cl. G06F 16/21 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/214 (2019.01) [G06F 16/254 (2019.01)] 25 Claims
OG exemplary drawing
 
1. A system for migrating data from a legacy system to one or more target systems, the system comprising:
a memory storing instructions; and
at least one processor configured to execute the instructions to:
request data from the legacy system is via a data request feature, the data being requested by the one or more target systems;
package and move the requested data to a first landing zone specific to the legacy system via a data packaging feature;
receive a copy of the packaged data in the first landing zone at a second landing zone specific to the one or more target systems;
generate control counts and balances related to the packaged data at the second landing zone;
ingest the packaged data from the second landing zone in a staging layer;
map the packaged data received from the second landing zone in the staging layer to data expected to be migrated to the one or more target systems;
establish data transformation rules in the staging layer for transforming the packaged data into data that is compliant with the data requirements of the one or more target systems;
load general enterprise reference data and reference data specific to the one or more target systems in the staging layer to facilitate the data transformation process;
perform a completeness check in the staging layer against the originally requested data to confirm all requested data remains present;
if determined to be complete, transform the packaged data in a transformation layer to data that is compliant with the data requirements of the one or more target systems;
run data quality and identification rules in the transformation layer to identify any data gaps that arise during transformation;
if no data gaps are identified, load the transformed data via a first loading feature into applications specific to the one or more target systems;
validate the loaded data via a validation feature to confirm the loaded data is both complete and accurate;
if determined to be complete and accurate, load the data via a second loading feature to such downstream systems as an enterprise data storeroom or advanced analytical systems; and
publish the status of the data via a migration reconciliation dashboard as it is migrated from the legacy system to the one or more target systems.