Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  Requirements  Migration User Requirements
Previous Previous
 
Next Next
New Post 1/23/2015 11:46 AM
User is offline Davie
1 posts
No Ranking


Migration User Requirements 

Hi I am on a short term contract to come up with a solution for a data catch up between the migration phase and the go live phase of a migration program.  I have to document the user requirements for this and I am currently analyzing the data fields and sources for each.  I have this in a good place in the requirements catalogue but I am unsure how to transfer this into the user requirements document.  Is there a standard way this is documented?

I am thinking of recommending a SQL database for the comparison of migrated data to new/changes to the data entered in the legacy system but I do not have template or previous example for the functional specifications for this .  Can someone point me in the direction of one or both of these.

Apologies for the short explanation.  Any help greatly appreciated.

 

Davie.

 

 
New Post 1/23/2015 8:02 PM
User is offline NitWitNick
249 posts
6th Level Poster


Re: Migration User Requirements 

I'm probably reading your problem wrong ... but ...

Data Catch-Up ? What are you catching up ? Are you migrating and mapping data from some source-to-target (another system) ? Is there a table with data somewhere waiting to update the current database (ie: LockBox - a collection payments, orders, etc. that needs processing).

What could the user requirements be on a data migration ? ... "The Data Must Be Migrated Correctly And Available For Use By Monday Morning" ? Other user requirements could be identifying, processing, running reports on the migrated data differently ... which could be programming / user interface changes.

Don't you have a test database somewhere to initially load the migrated data in, unit test it and run current applications against it to test the successful mapping of migrated data ?

Now that things look OK, you will move the data into the production database and test again for success ... 

"a solution for a data catch up (between the migration phase and the go live phase of a migration program)." ... isn't that the QA part of the migrated data with end-users, test scripts and scenarios to verify that the new data was mapped correctly for your current system applications ?

Make sure none of the migrated will overlay any of the current system data ... wiping out current stuff with older stuff.

Do you have a Roll-Back plan in case something goes wrong on the production system ?


Like I said ... I probably read it all wrong and am missing some computer term ... but I'm not familiar with a "Data Catch Up".

 

 
New Post 9/15/2015 7:14 AM
User is offline Ndome
1 posts
No Ranking


Re: Migration User Requirements 
Modified By Chris Adams  on 9/15/2015 10:15:48 AM)

Hi NitwickNick,

Hope this finds you well. Your response above tells me you know your way around data migration undertakings. I am hoping you can help clarify or give me some pointers to help me fuflil my role in such a project. I am a 2 year BA but this is my first Data Migration project. My general feeling is that the role of a BA is not full in such projects. I am currently looking at Migration Principles/Rules/Requirements & Data Mapping. Some tips and guidance on best practice on these would really help. Also, could you please give me an idea of which areas to really take ownership for apart from the above?

Many thanks

Ndome

 
New Post 9/26/2015 6:46 PM
User is offline NitWitNick
249 posts
6th Level Poster


Re: Migration User Requirements 

Depending on technical you are, I would take a look at the databases you are using for migration ... check the data you have and where to put them in the new database (data mapping) ... data might be the same but field names might be different or one field might now hold the concatenation or calculations of other fields, etc.

Data mapping always took the longest for me because I was not familiar with the other system ... I usually worked with some tech person from the new database ... once that was done, then I could write the specs so it is know what goes where, what does not, needed database changes, etc. I usually set up an As-Is / To-Be database table images and showed the data migration in pictorial form.

What data is needed (all or just the last 5 years), what could be eliminated or stored in some data warehouse so it could be accessed if needed.

 

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  Requirements  Migration User Requirements

Community Blog - Latest Posts

Limor Wainstein
Limor Wainstein
Business analysts typically gather and interpret data from many areas within an organization, finding solutions to business problems and improving business processes with all that data. A business analyst may measure and improve on such disparate things as warehouse efficiency and cloud software implementation. A marketing analyst, on the other...
0 Responses
EA Learning
EA Learning
My current, favourite question for Executives and Architects is “How do you see Architecture operating in an Agile environment.” This question usually elicits a wry smile and a response along the lines of “I will need to get back to you on that!” Many people are wondering how Architecture will fair in the world of Agile. My ...
0 Responses
Limor Wainstein
Limor Wainstein
The age of cloud computing is now so firmly established that research firm Gartner predicted by 2020, a corporate "no-cloud" policy will be as rare as a "no-internet" policy is today. In the same press release, Gartner went on to predict that spending on compute power sold by cloud providers will exceed that of compute power sold and deployed into ...
0 Responses


Upcoming Live Webinars



Latest Articles

5 Business Analysis Trends to Watch in 2018
Jan 14, 2018
0 Comments
Given the speed of change, it is really tricky to predict what trends will grow in popularity or relevance. I am sure whatever emerges will seem obvio...
Featured Digital Library Resources 
Copyright 2006-2015 by Modern Analyst Media LLC