Summary:

Expert in Microsoft SQL Database Administration and Software Configuration Management. Passed Microsoft Certified Technology Specialist (MCTS) exam in SQL DBA 2005 (exam 70-431), over 4 years SQL experience. Expert in configuration and administration of IBM Rational ClearCase 15 years and ClearQuest 10 years. Excellent communication, teaching and presentation skills making me a great addition to any Software team.

Scripting, Reports: T-SQL, PERL, UNIX Shell, Crystal Reports
Languages: Java, C, Visual Basic, C#, .NET, XML, HTML
Web Development: Visual Studio, SharePoint Designer, Dreamweaver, Flash
Configuration Management Tools: ClearCase, ClearQuest
Databases: SQL Server, MySQL, Oracle, SharePoint, MS Access
Operating Systems: UNIX, Windows

Professional Experience:

• SQL 2005 administration activities such as performance tuning, backup, recovery, writing T-SQL scripts
• Maintaining database user accounts and access control rights
• Patching and Optimizing existing database environments
• The local technical expert, responsible for rollout, maintaining and supporting IBM Rational products, ClearCase and ClearQuest at Allstate
• Administering and supporting Allstate SharePoint environments.
• Web site development and maintenance using .Net and Visual Studio, Visual Basic, C#

Environment: SQL, ClearCase, ClearQuest, UCM, .Net, Visual Studio, Visual Basic, C#, SharePoint, SharePoint Designer, MS Access, Crystal Reports, Dreamweaver, Flash, Windows, UNIX

Confidential, Chicago, IL 3/2008 to 8/2008
Configuration Management Engineer/DBA, (Consultant)

• Maintaining Database user accounts and access control rights
• Monitoring, tuning and optimizing database performance
• Creating SQL queries and reports
• Designing and implementing Database backup and recovery schemes
• Maintained the Rational ClearQuest user databases and schemas.
• Administered Rational ClearCase environment.
• Created VOBs, triggers, projects, streams and views.

Environment: SQL, T-SQL, ClearCase, ClearQuest, UCM, Java, Perl/shell scripting, UNIX, Windows

Confidential,Lake Zurich, IL 10/2006 to 2/2008
Configuration Management Engineer/DBA

• Patching Microsoft SQL Server and Access Databases
• Designing and implementing Database backup and recovery schemes
• Maintaining Database user accounts and access control rights
• Monitoring, tuning and optimizing database performance
• Creating T-SQL queries and reports
• Developed branching strategies for multiple projects designed and enforced CM practices with Perl scripts and ClearCase triggers.
• Improved the linkage between IBM Rational Suites products, ClearCase and ClearQuest with custom scripts.

Environment: SQL, T-SQL, ClearCase, ClearQuest, DOORS, Perl/Korn scripting, UNIX, Windows

Confidential,Schaumburg, IL 5/2005 to 10/2006
Software Engineer, (Consultant)

• Served as the technical expert and Source Code Management (SCM) Administrator responsible for maintaining and supporting all IBM Rational products at Zurich
• Maintained the Rational Suites products, ClearCase, ClearQuest, UCM, Rose, TestManager, and RequisitePro.
• Maintained the Rational License Server
• Upgraded and patching the Rational products in a timely manner
• Trained and providing tech support to users on the Rational Suites products
• Maintained the ClearQuest user databases and their schemas
• Maintained the ClearCase Servers and resolve system crashes with very little downtime
• Created new UCM projects and streams when needed
• Executed branching and merging according to release policy in weekly builds.
• Ensured backups of Rational products and their data
• Maintained documents including Administrative Document, the SCM Plan, SCM Process document, the SCM User Guide.

Environment: ClearCase, ClearQuest, UCM, Java, Perl, UML, HTML, SQL, Windows

Confidential,Libertyville, IL 11/2003 to 5/2005
Configuration Management Engineer, (Consultant)

• Administered ClearCase
• Compiled and built one 3G phone software version using ClearCase clearmake.
• Built new 3G phone software from existing baselines by adding feature branches.
• Helped to create the automatic generation of Test Cases for QA.
• Applied release label to all software components.
• Moved executables to release areas.
• Helped to create the automatic generation of release notes.
• Added Perl scripts to automate the execution of builds and releases.
• Resolved any build errors with the development teams.
• Provided training in ClearCase and best practices to release team.
• Developed ClearCase triggers to enforce best practices.

Environment: ClearCase, UCM, C, Perl, DDTS, HTML, XML, XSL, MySQL, UNIX, Solaris, shell scripts

Confidential, Chicago, IL 4/2001 to 3/2003
Lead Software Engineer

• Administered ClearCase UCM integration with ClearQuest.
• Created builds for Java and .NET applications.
• Performed system, integration and regression testing.
• Developed and promoted best practices, procedures and the creation of reusable components.
• Wrote test plans and test cases from business requirements and function specifications.
• Installed, configured, tested, maintained and tuned Rational and Mercury products for best performance.
• Taught 3 in-house training classes in Rational ClearCase.
• Worked with ClearQuest schemes and SQL.
• Wrote ClearCase triggers and have experience with ClearTrigger.

Environment: ClearCase, ClearQuest, UCM, C, Perl, VB, Java, HTML, XML, Microsoft.Net, Windows, Oracle, SQL, TestManager, RUP, Mercury TestDirector, LoadRunner

Confidential, Lisle, IL 11/2000 to 3/2001
Software Engineer, (Consultant)

• Improved the efficiency of SCM builds by making changes to the ClearCase, ClearQuest environment.
• Developed and extended software tools for SCM builds and metrics.

Environment: Java, C, Perl, ClearCase, ClearQuest, NT/UNIX, Solaris, shell scripts

Confidential,Lisle, IL 4/2000 to 11/2000
Configuration Management Engineer, (Consultant)

• Upgraded the Configuration Management (CM) software for the Supply Chain e-commerce group.
• Worked with ClearCase and ClearQuest in a NT/UNIX environment.

Environment: C/UNIX, Perl, ClearCase, ClearQuest, NT/UNIX, Solaris, shell scripts

Confidential,Libertyville, IL 7/1995 to 4/2000
Software Engineer, (Consultant)

• Developed software components in C++ as part of the GSM Man-Machine Interface. Cellular phone features I updated included subsidy lock, phone lock, call establishment, emergency call, redial, call hold, multi-party calls, pending call drop and call termination.
• ClearCase and DDTS Administrator.

IT Environment: C++, ClearCase, VRTX, RTOS, Discover, Framemaker, DDTS, UNIX, Solaris, shell scripts, MySQL database, Six Sigma

Education and Professional Training:

Bachelor’s Degree in Computer Science

Microsoft Certified Technology Specialist (MCTS) SQL DBA 2005 (exam 70-431)