Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  General  Advising Jr. Analyst on migrating Excel + Access to Cognos/Oracle solution
Previous Previous
 
Next Next
New Post 7/6/2009 2:08 AM
User is offline Michiel Erasmus
13 posts
thebusinessanalystpodcast.blogspot.com
10th Level Poster


Advising Jr. Analyst on migrating Excel + Access to Cognos/Oracle solution 

My client wants me to;
* Document current business process
* Advise on a technological upscaling Acess/Excel to Cognos
* (FUTURE) manage the transition

I need advise on the uspcaling from a BA perspective. Why? How to do it?

BACKGROUND;
1. Import. My client has a primary process importing invoicing files from suppliers into Excel/Access.
2. Processing. Verifying the imported supplier invoices against business rules comparing & double checking that to a 2nd set of verification invoices.
3. Output. Is a excel spreadsheet differentiating discrepancies.

WHAT I HAVE DONE SOFAR;
* Did full scale analysis for scope
* Requirements workshops
* Vision Statement, Business process
* Modeled Use Cases, UML, wrote use cases.

The choice for Cognos/Oracle was automatic because of expertise and people "sitting on the bench" ready to get started. On Wednesday we would have a meeting with these techies to determine their goals and future possibilities.

Its The choice for Cognos/Oracle was automatic because of expertise and people "sitting on the bench" ready to get started. On Wednesday we would have a meeting with these techies to determine thier goals and future possibilities.

QUESTION;
1. How would you approach such a migration? Specifically: why coose oracle/Cognos? What advantages/disadvantages does it have?
Which questions/issues would you be asking?

When i have this migrating issue solved i will post my (advised) solution here, or blog it during an interview in my podcast --> http://thebusinessanalystpodcast.blogspot.com/

 

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  General  Advising Jr. Analyst on migrating Excel + Access to Cognos/Oracle solution

Community Blog - Latest Posts

I have always loved cooking. I learned from my Grandma June and her kitchen was her sanctuary, a small, warm sunlit space filled with jars of spices, stacks of cookbooks, and the comforting smell of something always on the stove or baking in the oven. Grandma June was as great a cook as she was a teacher to me. She never followed a recipe “to...
Now, I know, I don’t know what kind of new intro BPO may require, but at least I can promise you upfront that I have something different to say about Business Process Outsourcing or simply BPO. What is it? This hasn't been a call center job or a sales job as we all think. It is a mammoth profile, and firms are grappling to ge...
Leveraging Blockchain Technology for Enhanced Data Security in Business Operations
In an age where data breaches and cyberattacks are becoming more frequent and sophisticated, businesses are searching for robust solutions to safeguard their data. Blockchain technology has emerged as a promising tool in this quest, offering a way to secure data with unparalleled reliability. Although initially known for powering cryptocurrencies l...

 






 

Copyright 2006-2025 by Modern Analyst Media LLC