Tuesday, February 09, 2010

   Quick Links:   Articles     MA Blog     Community Blog     Templates     Books     BA Humor     Events     Jobs     Interview Questions         RSS Feeds

Business Analyst Forums & Systems Analyst Forums

Community Highlights




AddThis Feed Button

AddThis Social Bookmark Button

Forums
 
  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 4:08 AM
User is offline pappavis
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
  





Subject Matter Experts

Modern Analyst Community Expert

Craig Brown
-General Analysis
-Project & Personnel Management
View Posts
View Expert's Biography

Guy Beauchamp
-Data Analysis & Modeling
-Structured Systems Analysis
View Posts
View Expert's Biography

Jarett Hailes
-Agile Methods
View Posts
View Expert's Biography

Kieran Creaton
-Requirements Gathering & Facilitation Techniques
View Posts
View Expert's Biography

Perry McLeod
-UML Modeling
-Project & Personnel Management
View Posts
View Expert's Biography

The Community Expert is just one way that Project Members volunteer their time to help the Modern Analyst Community. Want to become a Community Expert in one of the following areas? Submit yourself to be selected as a Project Member.

Available topics include:

  • General Analysis
  • Data Analysis & Modeling
  • Structured Systems Analysis
  • BPMN Modeling
  • UML Modeling
  • Rational Unified Process
  • Six Sigma
  • QA/Testing
  • Project & Personnel Management
  • User Interface Design
 


Privacy Statement  |  Terms Of Use
Copyright 2006-2010 by Modern Analyst Media LLC