*Hi Partner,* *Please send me updated resumes to **[email protected]* Job Description : IT Analyst
Duration: 6+ months Location: Reston, VA Rate: Open/HR *Change: the entry for SMS so that it’s clear we’re asking about Microsoft System Center Configuration Manager (SCCM) or Microsoft System Management Server experience – in addition, we’re looking for prior experience with the SQL table structure in System Management Server or SCCM – someone who has run queries against the System Management Server or SCCM SQL database. On a 1-5 scale, looking for 3. * *Addition: Experience in ad-hoc query building and command line queries. Experience in SQL best practices and producing well-turned SQL queries that maximize accuracy, efficiency, and performance while minimizing impact. On a 1-5 scale, looking for 4.* *The analyst will generate reports primarily from BMC Remedy, Microsoft SMS and PeopleSoft data and from other sources to assist the IT Asset Management effort to review and make decisions on software products in the Fannie Mae Windows PC environment. The analyst should have the following attributes: * Good command of Microsoft Excel - proficient in use of filters, sorts, subtotaling data, use of VLOOKUP/HLOOKUP functions and other functions used to assess, associate, organize and report data. * Strong working knowledge of Windows PCs, the Windows O/S and how software is installed/run in Windows - the ability to identify software that installed on Windows PCs * Understanding of WMI on Windows PCs and how to access/query WMI classes to extract information about PCs * Working knowledge of Microsoft SMS - ability to run reports and queries in SMS to extract software and hardware information about Windows PCs that have been scanned by SMS * Working knowledge of Microsoft SQL querying and reporting * Working knowledge of BMC Remedy - ability to run queries and reports on asset records in Remedy and extract the data to Microsoft Excel * Working knowledge on joining data from disparate sources (e.g. Microsoft SQL + LDAP Data Source + Remedy Sybase) to form reports where data from all three sources are required to product a report. * Must be detail oriented and have the ability to produce reports that are appropriate, repeatable, automated where possible and polished/esthetically pleasing* Please send the updated resume of the consultant along with the rate, location and contact information. Please make sure the Consultant's skills match the requirement. After reviewing the resume I will contact you if I need more information. *Thanks,* *Sahitya priya* * Nihaki Systems Inc 346 Georges Road, Suite # 1, Dayton, NJ 08810. Phone: 732-823-6471/6472 Extn:112* ***Fax :732-438-6973 **www.nihaki.com* <http://www.nihaki.com/>* **[email protected]* <[email protected]>** -- You received this message because you are subscribed to the Google Groups "KNOW.IT" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/know_it_az?hl=en.
