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, ClearQuest 10 years and RequisitePro 5 years. Excellent communication, teaching and presentation skills making me a great addition to any Software team.

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

Professional Experience:

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

Environment: ClearCase, ClearQuest, UCM, RequisitePro, .Net, Visual Studio, Visual Basic, C#, SQL, SharePoint, SharePoint Designer, Dreamweaver, Flash, Team Foundation Server (TFS),Windows, UNIX

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

• Maintained the Rational ClearQuest user databases and schemas.
• Administered Rational ClearCase environment.
• Created VOBs, triggers, projects, streams and views.
• 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

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

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

• 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.
• 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

Environment: ClearCase, ClearQuest, DOORS, Perl/Korn scripting, SQL, T-SQL, 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, RequisitePro, 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

Education and Professional Training:

Bachelor’s Degree in Computer Science

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