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


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

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

    40/sec to 500/sec

    IntroductionSurprised, by the title? well, this is a tour of... Read More

    Is Your Small Business Ready For A CRM Software Solution?

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

    Cisco CCNA Certification: Becoming A Truly Valuable CCNA.

    I've been active in the Cisco Certification track for four... Read More

    Groupware and Version History: Collaboration Series #1

    This article is the first of a series of articles... Read More

    Assertion in Java

    Assertion facility is added in J2SE 1.4. In order to... Read More

    Adware, What Is It?

    Adware is a type of Spyware program that displays some... Read More

    Software Engineering: An Introduction

    Software Engineering is the Systematic Approach for analysis design implementation... Read More

    Why Stick With Email Clients Like Outlook?

    Trying to figure out a stream in banning one email... Read More

    The Dreaded Paper Label - Should it be Used?

    While paper labeling CDs and DVDs may appear to be... Read More

    Simple Solution for Php Includes - IFrames

    I have recently created my first Php program. I wanted... Read More

    Microsoft Blues

    With the advent of 'Service Pack 2' for Windows XP... Read More

    Integrating Microsoft Great Plains Accounting/ERP: RMS, CRM, eCommerce, Lotus Domino ? overview

    Microsoft Business Solutions Great Plains has substantial market share among... Read More

    Screenshots Vista Windows

    Features Additionally, Vista will include many other new features.Aero Vista... Read More

    Microsoft Great Plains Logistics & Warehouse Management ? Implementation & Customization Highlights

    Logistics automation is often considered as barcoding extension to Sales... Read More

    Huddle Up; Groupware on Three

    It could just be me, but my experiences with document... Read More

    Groupware and Online Collaboration: Collaboration Series #4

    This article is the fourth of a series of articles... Read More

    Microsoft CRM: Data Conversion ? Import from Act!

    Best Software Act! is very popular CRM for small and... Read More

    Oracle Development: JDeveloper 10G ? Java, J2EE, EJB, MVC, XML - Overview For Programmer

    In 2004 Oracle, Inc. made its new step toward J2EE... Read More

    Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center ? overview

    Microsoft Business Solutions Great Plains has substantial market share and... Read More

    Linux ? Keyboard Or Mouse

    Just stress testing one of the latest Linux distributions. Been... Read More

    Software: What Suits Me?

    Almost all new and major brand of PCs come with... Read More

    Can You Calculate Complex Financial Calculations?

    Are you a whiz at calculating financial information? Not the... Read More

    Spyware: What It Is and How to Combat It

    Spyware is software or hardware installed on a computer without... Read More

    A Symons Mark II Function Point Counting Example

    I provide, here clear explanations and a count of function... Read More

    International Support - Microsoft Great Plains VAR/Partner Selection ? Overview for V.P. IT

    Looks like Microsoft Great Plains becomes more and more popular,... Read More

    An Easy Way to Develop JAVA Enterprise Applications

    Research bears that less than 70 percent of development projects... Read More

    Alien Intruders!

    You probably didn't casually invite, or extend a formal attendance... Read More

    Four Easy Ways To Prevent Spyware

    How would you like to prevent spyware and adware from... Read More

    Begun, The Browser Wars Have

    As Mozilla Firefox nears 10% market share, with well over... Read More

    Great Plains DOS Support ? Notes for Consultant

    Great Plains Accounting, accounting package for mid-size and small companies... Read More

    Examining the Substance of Studio MX

    To all web designers out there, this article is for... Read More

    Constructionalist Parsing - Deciphering Natural Language

    The research in the field of Natural Language Processing usually... Read More