New Role

[JMichaelM]

Hi Everbody! I hope all is well with you. I wanted to share with you that I start a new role and was wondering if you have any advice for my first month or so:

Compiling a solution working with MS Access and Excel to consolidate data from multiple infrastructure repositories that contain information about the applications where we have NPPI data.

Need to understand infrastructure at a high level I.e. Database repositories, File Servers, Networking components, Vendors etc.

Data must be rolled back up to the associated application. Down the road we will evolve the Excel/Access into a SQL datamart or extend the APM schema to house the data. APM is the application that Architecture uses to inventory all of our enterprise apps.

 

[MarkK]

Congratulations and all the best!!!

 

[Lightwave]

Yes Congratulations hope it goes well

 

[The_Doc_Man]

First, congrats on stepping up to a higher plate.

Second, you asked for advice. Anyone who knows me knows I've got advice.

If it isn't done already, or if what was done isn't clear - draw pictures! Make the moral equivalent of a table-relationship diagram and/or data-flow diagram to know where everything resides, know what transactions (gross, not detailed level) occur and how often, know who/what "owns" each element of that diagram.

I was with Dept. of Defense before I retired and they ALWAYS drew pretty (but also very useful) pictures showing high-level relationships. The most important thing to get from such pictures to more easily understand how everything fits together. This is CRUCIAL for you to be able to selectively change focus from forest to trees and back again. Trust me, CRUCICAL.

 

[jdraw]

I concur with Doc_Man. Get yourself a high level model of the whole shootin' match. It can be fairly nebulous at first -such as the artist's concept of the new subdivision - but you have to be able to place anything you are planning, designing or developing within that framework. That way people --managers, workers (and you) can see where/how things fit/will fit together.

All the best with your project.