System Support Analyst Resume Santa Rosa, California - Hire IT People

SUMMARY

System Support Analyst specializing in supporting enterprise applications and software distribution
using a wide range of UNIX shell scripting and SQL queries in a UNIX and/or SQL database environment.
A hard working and dependable professional with 12 year's experience at Wells Fargo, consistentlydelivering results efficiently and on time. Also contributed scripts to Legacy applications.

10 years of Software Distribution using HPSD (HP), Tivoli (IBM) and SCCM (MS)
12 years of UNIX OS (HPSD, AIX, Linux) and extensive Shell Scripting experience
7 years of MS SQL and Database experience with SQL Server 2005, 2008 using Transact SQL

HIGHLIGHTS

Distributed software to 100,000 XP and Windows7 workstations using SCCM. Involved in the creation of collections and advertisements as well as client health. Knowledgeable in SCCM client tools and SQL.
Managed a high profile application and was responsible to update the Legacy database, monitor thedistribution of files to 10,000 ATMs and provide reports for upper level management. Wrote the majorityof the scripts used to both automate and monitor the distribution. Created shell scripts to monitor health of 15+ UNIX platforms and 2 SQL servers

used in the application.

Involved in a project to distribute data to 100 UNIX servers using HPSD and Tivoli. Needed extensive knowledge of UNIX shell and tools to manage the project. Wrote shell scripts to augment vendor software. Wrote Perl script to access log files and generate reports for an Application.

TECHNICAL SKILLS

Highly proficient in UNIX shell scripting , UNIX tools and AWK
Adept at writing shell scripts and data manipulation using either SQL and/or UNIX tools
Working knowledge of Perl and am comfortable in a UNIX environment
Strong knowledge of UNIX fundamentals

RECENT WORK EXPERIENCE
Confidential, 10/1999 - 4/2012 SYSTEM SUPPORT ANALYST - SCCM, 1/2010 - 5/2012

Responsible for creating collections and advertisements to distribute policies to 100,000+ workstations using SCCM 2007.
Knowledgeable in Software distribution and SQL/WQL.
Applied WQL to query the production SCCM database to populate collections and also used Transact SQL for more advanced queries in a reporting database replicated from the production db.
Queries and other tools were used to investigate client health issues and perform log analysis.
Utilized the reports database to monitor the distribution and detect problems in the distribution.
For individual machines, used Log Parser, DOS Bat files as well as the SCCM Client Center tool
to check machine logs such as CCM and program files.
Used the SCCM Client Center tool to display logs using trace32 but also to rerun advertisements, force the machine to download new policies and rerun hardware inventory. On occasion, will repair the client, and do a WMI rebuild.
Managed all projects to their completion.

SYSTEM SUPPORT ANALYST,Confidential, 5/2005 - 1/2010

Helped manage the database for 9,000+ ATMS as well as monitor the distribution of files and software to the ATMs.
Recreated database schema and wrote new monitoring tools, after inheriting the database from the vendor with no documentation.
Built a development server to test scripts. Placed SQL statements in a UNIX wrapper so that the database could be monitored remotely.
Updated ATMS weekly using a modified vendor script and stored procedures, which were used to add machines and start their deployment.
Write SQL to detect machines that did not receive their software, collect them and restart the distribution.
Was involved in database maintenance (DB update, backup and restoration, adding users, DTS) and made sure the production, backup and test databases were in sync.
Used stored procedures and other SQL statements to help automate the distribution procedure.

SYSTEM SUPPORT ANALYST ,Confidential,10/1999 - 5/2005

Utilized expertise in UNIX and shell scripting to distribute software to Wells Fargo branches using HPUX (Hewett Packard), Tivoli (IBM AIX and Linux).
Used UNIX tools to write scripts to help launch and monitor these distributions.
Worked on Linux project in Tivoli to launch and monitor applications using UNIX shell script and help develop a legacy application.

LANGUAGES
Korn Shell and UNIX tools, Transact-SQL, Perl, Expect

EDUCATION
BA in Biology and General Science with a teaching degree
Graduate Studies in Biology with a Clinical Lab Technology license

We provide IT Staff Augmentation Services!

System Support Analyst Resume

Santa Rosa, CaliforniA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship