IBMOP BIA Migration
Apply on
We seek a business analyst with strong EXCEL and Data Manipulation skills to help us on a 3-month IBMOP BIA Migration project.
Our client currently uses excel workbooks to capture information supporting their Business Impact Assessment (BIA) process. There are approximately 25 workbooks that currently store all BIA information for the enterprise at Client. The BIA process is migrating to IBM s eGRC OpenPages BCM Module. A contractor resource is needed to migrate the data contained in these excel workbooks, transforming the data where required, into IBM s eGRC OpenPages BCM Module using IBM s FastMap import utility.
Scope of Work
Resource is expected to complete the following activities:
As needed train with IBM to learn how to use the FastMap import utility
Build the necessary jobs using IBM s FastMap import Utility to import/migrate the BIA excel workbook data, transforming the data where required, into the appropriate tables and fields in the eGRC OpenPages BCM Module
Run the FastMap import/migration jobs to populate the BIA data in the IBM s eGRC OpenPages BCM Module from the excel workbooks
After the migration of all workbooks is complete, perform comprehensive testing to confirm all data in every cell from all BIA excel workbooks have been migrated completely and are in the required form/format within the eGRC OpenPages BCM Module
Experience and Skillsets Required
Minimum 2+ year extensive knowledge of MS Excel including (Import/Export data, Pivot Tables, VLOOKUP, SUMIF, VBA Macros, etc.) and experience working with and manipulating data in excel
Demonstrated exceptional analytical and problem-solving skills with strong attention to detail
Prior experience working with IBM s FastMap or any COTS tool import utility is a plus
Length of Contract: 3 months
Remote