SUMMARY:

• Over 16 years of IT experience of which my last 6 years were with SMS 2003 (3.5 years), SCCM 2007 (2 years), and SCCM 2012 (2 year). A creative problem solver and team player with both technical and soft skills, and a strong work ethic.
• Worked in the SMS/SCCM Admin Console since SMS 2003, SCCM 2007, SCCM 2012
• Extensive knowledge of SCCM’s 350 SQL Views & WQL for build complex reports, queries, and status message queries, and queries in scripts.
• Rebuilt SCCM 2007 from the ground up
• Build test lab from ground from Sever 2008 R2, DNS, AD, SCCM 2007, & 5 Workstations
• Uninstalled and reinstalled SMS 2003 secondary’s multiple time at Confidential
• Installed SCCM 2007 Primary Site Server, WUS and SUP, at Confidential
• Monitored log files trouble shoot issues with WUS/SUP at Confidential
• Certificate Issues on SCCM 2012 Clients
• Discovered Hotfix when *.mmc consoles wouldn't load on remote SCCM Primary site servers.

PROFESSIONAL EXPERIENCE:

Confidential, Grand Rapids, MI

SCCM Admin

Responsibilities:

• Repackaged, tested, and deployed Imprivata Single Sign - On solution using the state based features of SCCM application model to deploy different settings depending on what value was read from the registry for each unique business unit. Used Orca to find all of the public properties (all caps) to customize the MSI installer properties for each unique business unit.
• Provided team awareness of the compliance and state based features of the SCCM software application model.
• Repackaged, tested, and deployed Java 8 Update 121 using the SCCM Task Sequences that reference both 64 and 32 bit SCCM packages.
• Repackaged, tested, and deployed Adobe Reader
• Repackaged, tested, and deployed Adobe Flash
• Repackaged, tested, and deployed Adobe Shockwave
• Reached, documented, and submitted architectural design for MBAM to manage Windows 10 Bitlocker encryption to protect data at rest for HIPPA compliance.
• Discovered problem where stale computer account cleanup was disabling (after 90 days) and deleting (after 120 days) computer accounts that were online and in use because lastLogonTimestamp and pwdLastSet attributes where not being updated in Active Directory
• Wrote complex SQL queries.

Confidential, Columbus, OH

SCCM Administrator/Analyst

Responsibilities:

• Large fortune 100 company with 42,000 workstations
• Collaboration methodologies were ITIL and Agile for Infrastructure with two week iterations tracked in SharePoint.
• Monitored, maintained, updated, and remediated all aspects and components of Workstation and SCCM Client Health including: Hardware Inventory, Software Inventory, Software Metering, SCCM Client Versions, Pending Reboots, Waiting for content, Content replication, etc.
• Used Venn Diagram concept with SQL to compare AD and SCCM datasets with other managed services such as Telemetry for Office 365 to identify clients that needed remediation.
• SCCM 2012 Data Analysis, and reporting using complex SQL queries (aggregates, derived tables/fields, variables, joins,), with Excel connections strings to create pivot tables and charts to establish trending and baselines.
• Monitored results of a test application that we redeployed daily for real time reporting
• Defining new industry standards for AD & SCCM client health project (> 99% for 42K workstations)
• Measuring results using complex SQL Server queries; defining data sources, datasets, & KPIs
• Making reports standardized and easily consumable by publishing them with SSRS
• Assisted with upgrade from SCCM 2012 CU3 to SCCM 2012 R2 SP1 CU1
• Microsoft PFE Remediation tool (Microsoft’s Client Remediation Services - CRS)
• Leverage GPOs to remediate SCCM health issue that couldn't be fixed with SCCM
• Leverage computer startup script to look for SCCM client (CCMExec.exe) file, & install current if not found

SMS/SCCM Administrator

Confidential, Reston VA

Responsibilities:

• Secret Security Clearance
• Maintained SCCM Client Agent Health of about 98%
• Replaced SMS 2003 environment with SCCM 2007 environment
• Assisted with zero touch Windows 7 desktop migration project to be completed by 12/2011
• Wrote complex SQL queries in SQL Server Management Studio, some with aggregate functions, to produce detailed SCCM web reports. Also wrote WQL queries in the SCCM admin console for dynamic collections to target workstations for advertisements, further analysis, or reporting.
• Architected, developed, and maintained a One-Click-Fix shell scripts that empowers the Help Desk and Desktop Support teams to easily and quickly fix broken SCCM Clients and or WMI issues, which can otherwise be a complicated and time consuming process.
• Implemented, designed, and maintained software metering rules and SCCM web reports for Asset Inventory to monitor the use of installed software to validate and save on software licensing costs.
• Extending SCCM hardware inventory of the WMI repository by editing the two Managed Object Format files called Sms def.mof and Configuration.mof files (no longer supported in 2012) to collect more information about computer hardware, registry values, and installed software for better reporting, targeting of dynamic collections, etc.
• Created software packages, replicated packages to distribution point, created advertisements to run silently during off hours, reported on the success/failure of the software push, then created catch-up advertisements to try and catch the leftovers before sending to Desktop Support.
• Wrapped packages in Wise (*.exe /s)
• Re-engineered and wrote Visual Studio C# console application

SMS Administrator

Confidential, Livonia, MI

Responsibilities:

• Administered 3 primary SMS Servers, and 20,000 plus SMS Clients
• Monitored SMS Status Messages, SMS Log files, Event Logs, and disk space on SMS servers
• Achieved better than 99% SMS Client Health during two separate Enterprise software deployments to 15,000 SMS Clients. In Healthcare this is a high priority because devices that support and monitor Patient health are physically connected to SMS Client Workstation.
• Developed scripts, tools, and documented processes for troubleshooting and repairing broken, or partially broken, SMS Clients.
• SMS Client Health
• SMS Software Distribution
• Troubleshot SMS Software Distribution, and SMS Client issues

Confidential

Southfield MI, SMS Administrator

Responsibilities:

• Support experience for Secondary SMS Site Servers included: Stopping and restarting SMS Services, uninstalling and reinstalling the Management Points, and uninstalling and reinstalling the Secondary Site Servers.
• Designed and implemented security model for users of SMS using Active Directory groups. This enabled the Security to administer access to SMS through Active Directory group membership.
• Wrote instructions and provided training on how to use the SMS Report Viewer for SMS Web Reports.
• Provided SMS training via Live Meeting video conference calls for F-M departments such as Auditing, Asset Management, Global Site Support, and the Help Desks in Romania, India, and China.
• Deployed MS Office 2003 packages using multiple transforms in multiple programs in 14 different languages to 16,000 workstations.
• Combined the install source and language packs into one folder for “Office Professional Plus 2007” pilot with other MS Office programs such OneNote, Project, Visio in preparation for Global deployment.
• Deployed other software packages, and tracked progress and success of the deployment through SMS status messages and web reports.
• Deployed the ACT (Application Compatibility Tool Kit) to determine Vista compatibility with existing F-M applications.
• Troubleshot, repaired, and reinstalled SMS secondary sites to resolve IIS communications between SMS sites.
• Developed, deployed, and supported virtual Windows XP desktops on VMware servers in the US and UK data centers for Help Desk in Romania, India, and China.
• Managed the lab environment for image building and software testing on all production models of workstations, desktops, and laptops.
• Deployed SMS software packages such as Courion DIRECT, McAfee ePO Agent, Adobe Flash Player, and MS Shadow Copy Client globally to dynamic query based collections of 16,000 workstations, desktops, and laptops.
• Created query base SMS collections using WMI values that were collected from SMS inventory to sort computers by system model.
• Wrote a Daylight Saving Time registry file for 500 computers in Brazil and deployed it with SMS, because the DST patch for Brazil was not available from Microsoft.

3 rd Level Desktop Support

Confidential, Troy, MI

Responsibilities:

• Wrote a shell script wrapper for NetDom.exe so PC Support could easily and quickly add computers to the domain, put the computer accounts in their correct Organizational Units, and nest global groups into local groups - all within one step.
• Developed shell script to automate the 2005 refresh of 950 PCs
• Wrote shell script for IBM’s SMA tool for 2002 refresh of 900 PCs
• Assisted with the F-M Windows XP English desktop image
• DOS boot disks for Novell and Windows 2000
• Wrote and edited Novell login scripts
• Provide exclusive PC Support for the Confidential Executive wing at the world headquarters in Southfield Michigan
• Created MSI snapshot packages with WinInstall LE tool
• Resolved support problems escalated by level 2 PC Support
• Provided dedicated support F-M Executives
• Designed the standard naming convention based on floor and location for the Xerox MFD(Multifunctional Devices used for printing, scanning, copying, and faxing) printer consolidation project.
• Started SMS Administration and Support on 05/15/2006

Confidential

Responsibilities:

• Motor City Electric Technologies, Detroit MI, Quality Assurance for the data centers and wiring closets during the Metropolitan Airport McNamara Terminal expansion project
• Research Federal Credit Union, Warren Michigan
• Hartland Equestrian Center, Highland Michigan
• M.J. Whelan Construction, Milford Michigan
• Muir Middle School, Huron Valley, Milford Michigan
• Heritage Environmental & Pump, Highland Michigan
• J.O.A Construction Co Inc, Detroit Michigan

Confidential, Farmington Hills, MI

Novell Administrator

Responsibilities:

• Novell Netware administrator, 3rd level support, and some HP UNIX connectivity
• ARCserve backups for NetWare file server, and BackUp Exec backups for Exchange 5.5 eMail
• Microsoft Exchange 5.5 eMail account administration
• Installed and administered Norton AntiVirus Corporate Edition for Microsoft and Novell
• Managed Xiotech Storage Area Network (SAN)

Confidential, Farmington Hills, MI

Micro Analyst II

Responsibilities:

• Level 2 support at headquarters and 3 remote sites
• File Server consolidation projects
• ARCserveIT 6.6 backups for Novell NetWare
• Provided support and training for Trinity Executives