Sql Server Management

Tim Hogan

th

***** * *** *****

Surprise, AZ ***74

Phone: 623-***-****

**********@***.***

SUMMARY

IT Professional with excellent troubleshooting abilities, adapt at applying new technologies to

address business needs with a multi-functional perspective allowing management of cross-

disciplinary endeavors. I have developed analytical skills in accounting and finance needed to

conduct sound analyses to provide understanding of the financial implications and the ability to

solve real-world management problems, and to exercise sound management judgment through

practical application of project management concepts and skills. I have also gained a solid

appreciation of the structure, management and operation of the economic system to interpret

economic trends.

EDUCATION

DeVry University

2/09 – 6/11

Keller Graduate School of Management Phoenix, AZ

Master of Project Management

MPM Graduated June 2011 with Distinction

GPA 3.77

Master of Business Administration

MBA Graduated April 2010 with Distinction

GPA 3.73

Concentration Information Technology

Microsoft SQL Server Training

5/08 – 8/08

SetFocus, LLC. Parsippany, NJ

Completed SetFocus Master’s Program in Microsoft SQL Server 2005

Extensive DBA training including SSRS, SSIS, TSQL, DDL, DML, backup/recovery, stored

procedures and database optimization.

Created numerous simple to complex queries involving self -joins, correlated sub queries and

XML techniques for diverse business requirements.

Analyzed the business requirements and systematically designed a bank database that stores

Customers’ and their Account information. Employed best practices in creating a complete

schema including tables, relationships, stored procedures, views, clustered and non -clustered

indexes and triggers.

TECHNICAL SKILLS

Programming Languages:

Transact SQL, XML, PL/SQL, C#, ASP.NET, VisualBasic.NET, HTML

Microsoft Technologies:

SQL Server 2005 Reporting Services

Databases:

Microsoft SQL Server 2000 / 2005, Oracle 9i

Operating Systems:

W indows 98/2000/XP/Vista, Windows Server 2003, UNIX, Linux

Software:

SQL Server Management Studio, Microsoft Visio, Microsoft Office, Database Engine Tuning

Advisor, SQL Server Profiler, SharePoint

Tim Hogan

PROFESSIONAL EXPERIENCE

TCS

05/11 – 11/11

Systems Analyst Glendale, AZ

Supporting both external and internal customers of Humana RightSource 2 web based pharmacy,

used SQL queries to check status and health of applications and to update, insert and delete

data. Triaged incident and problem tickets and routed to correct support or development teams.

Monitored systems for problems, affected repairs to resolve problems using T-SQL, reviewed T-

SQL triggers and stored procedures and created T -SQL scripts to query, update and insert data

into database, created change requests and communicated the change requests to Humana

management for approval. Created technical documentation and reviewed technical

documentation created by both on and off shore associates and currently coordinating between a

vendor and the Humana IT during a new database installation project working directly with project

management, development and testing groups.

10/06 – 2/08

Mortgage Cadence Greenwood Village, CO

SQL Server Data Analyst

A developer role the job included writing T-SQL queries to find the data entered into database

tables in a Windows form by loan underwriters. Used .NET to insert that data into an

automatically generated mortgage document and interfaced with off shore programmers and legal

team to ensure all documents fit legal definitions.

4/98 – 4/04

Avaya Inc W estminster, CO

System Application Specialist

Took inbound customer calls and using a UNIX based operating system remotely connected to

the customer equipment to diagnose and repair, was able to clear over 90% of all calls.

Dispatched technicians to customer site to replace any defective p arts and assisted field

technicians while at customer locations. Generated leads that resulted in over $10 million in

sales and received numerous customer commendations and awards for teamwork and pride.

3/97– 4/98

Gestetner Denver, CO

Senior Field Engineer

Field service of Ricoh, Savin and Gestetner copiers.

1/96 – 1/97

Danka Inc Phoenix, AZ

Field Engineer

Field service of Canon copiers, faxes and printers.

Contact this candidate