IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

Microsoft Great Plains as ERP and Microsoft CRM as Client Relation Management system is very robust combination and could serve midsize to large corporation as Business System. Being VP IT or IT Director you need to foresee the positions to have in your IT department to do internal MS Great Plains and MS CRM support.

Let us give you the directions, based on our research and consulting practice.

  • Microsoft SQL Server Specialist ? we specially do not name this position as MS SQL DBA, because both Great Plains and MS CRM are not very complex from the database administration side, they do not use indexes optimization, referential integrity, probably do not require complex transaction log backup/recovery scenarios. On the other hand this position requires Great Plains and Microsoft CRM tables structure analysis and some primary Great Plains data fixing skills via SQL queries, described in MBS Customer source techknowledge database. The best candidate should have some accounting background - to be able to address ongoing issues to MBS technical support.
  • Network Administrator with good Microsoft Exchange and Active Directory skills. Microsoft CRM uses all the newest Microsoft technologies, and Exchange is a workhorse here. In order to install and upgrade MS CRM this guy needs to understand the under-laying Microsoft technology. In the best case - she/he should know Exchange security structure and probably program Exchange handlers, due to the fact that CRM/Exchange connector is not a perfect tool yet.
  • C# or VB.Net programmer with excellent SQL Skills? if you are midsize or large company - you should have this position - you will need web publishing and MS CRM customization and its support. Currently Microsoft CRM SDK has C# examples - so C# programmer would be the best fit, it may have more VB code in the future, so the C# - VB balance maybe restored.
  • Crystal Reports Designer/Programmer - Crystal Reports is the best tool available on the market to address both Great Plains and MS CRM reporting needs. This position maybe merged with one of the above.
  • These people should be probably cross-trained in both Great Plains, Microsoft CRM, Crystal Reports, SQL and C# programming, so you do not depend on the unique skills of one person. In our opinion, which is based on our long term consulting practice - these skills will allow you to keep the cost of IT support reasonably low and avoid paying high consulting price to your Microsoft Business Solutions Partner.

    Happy hiring and training! But in any case you need to select Microsoft Business Solutions Partner/Var/Reseller to be your official representative. This is how MBS has its channel working - it assures that Microsoft Business Solutions products are properly implemented. If you want us to be your Microsoft Business Solutions Partner - give us a call 1-866-528-0577! help@albaspectrum.com

    Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Microsoft CRM, Microsoft Great Plains implementation and customization company, based in Chicago, Boston, New York, San Francisco, Los Angeles, Phoenix, Houston, Atlanta, and Miami and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, VB/C#.Net, Crystal Reports and Microsoft CRM SDK developer.

    In The News:


    pen paper and inkwell


    cat break through


    Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware

    Spyware and malware are large problems for Internet users today... Read More

    Falling in Love With More Than One Screensaver: The Fun Part

    Having from five to ten and more favorite screensavers is... Read More

    Microsoft Moves to Small Business Accounting/Retail Market ? Stakes and Thoughts

    In this small article we will be looking at the... Read More

    Accounts Payable: A Powerful Document Management and Workflow Solution

    Accounts payable is just one area of office management where... Read More

    Cisco Certification: Introduction To ISDN, Part IV

    In part III of this ISDN primer, we learned that... Read More

    Start Developing Your Own Software

    Learning how to program software seems like a daunting task... Read More

    Microsoft Great Plains in Construction & Building ? Implementation & Customization Highlights

    Microsoft Great Plains could be tuned and setup to fit... Read More

    Know-how in Microsoft Publisher

    For those who still don't know, Microsoft Publisher helps computer... Read More

    Microsoft CRM for Large Corporation ? Security

    Microsoft Business Solutions CRM proved to be reliable solution in... Read More

    Three Steps To Windows Safety Heaven

    Now there are Three Steps To Heaven Just listen and... Read More

    Great Plains Custom Development: Dexterity, VBA, SQL, Crystal, eConnect ? Overview For Programmer

    Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

    Microsoft eCommerce Web-development: Great Plains eConnect .Net ? Highlights for Programmer

    In our small article we'll consider Microsoft Business Solutions Great... Read More

    5 Easy File Management Tips in Microsoft Word

    How many steps does it take you to locate and... Read More

    Microsoft Great Plains Implementation in Russia ? Overview for Consultant

    Microsoft Business Solutions Great Plains is very popular ERP platform... Read More

    Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

    Microsoft Retail Management System serves retail single store as well... Read More

    Microsoft Great Plains, Navision, Axapta ? Selection Considerations

    During the years of our consulting practice, which comes back... Read More

    Selecting Corporate ERP: Microsoft Business Solutions Great Plains ? Estimation Parameters

    As we could imagine, if you are reading this article... Read More

    What You Must Know About Spyware Right Now

    Spyware is like the new technological nuclear weapon on the... Read More

    Is Your Small Business Ready For A CRM Software Solution?

    I have yet to see a business that, sometimes in... Read More

    Professional XP Style Icons in Software and Website Development

    Using professional icons in your application or website can bring... Read More

    Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer

    ... Read More

    Microsoft CRM in Latin America: Implementation, Customization, Support ? Overview for Consultant

    Microsoft Business Solutions CRM is present several years on the... Read More

    Save Your Resources - Combine Your IM Clients

    There are so many different programs that clutter up your... Read More

    Microsoft CRM Data Conversion FAQ

    Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More

    Microsoft CRM Implementation - US Market Lessons

    Microsoft CRM is CRM answer from Microsoft Business Solutions. If... Read More

    Microsoft Great Plains Customization: Project Organization ? International Business Example

    Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More

    Backing Up And Restoring Your MySQL Database

    If you've been using MySQL database to store your important... Read More

    Choose your Java Wisely

    Java has come along a long way. Many would agree... Read More

    Anti-Spyware Protection ? Holes in the Shining Armor

    Looking at all the ads which promise to get rid... Read More

    Microsoft Great Plains Customization Tools Evolution ? Overview for Consultant

    When Great Plains Software introduced the first graphical accounting application... Read More

    Great Plains Dynamics/eEnterprise Upgrade ? Things to Consider and FAQ

    If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More

    Microsoft Navision and Crystal Reports - An Overview

    Microsoft Business Solutions ? Navision is an integrated solution for... Read More

    Configure Windows Indexing Service for Performance

    The Windows Indexing Service provides you with the ability to... Read More