Professional Summary

Experienced IT professional with exposure in Insurance, Consulting, Marketing and Banking/Financial systems. Proficient in gathering requirements, Data Analysis, Data Modeling, designing systems and managing projects. Excels in communication with technical and non-technical people alike, at all levels of the business. Focusing on being technically sound specializing in database management while being client centered.

Platforms:

• Windows XP/2000, 2003, 7
• MS SQL Server 2008 R2, 2008, 2005, 2000, 7, 6.5
• MS SQL Reporting Services 2005, 2000
• MS Great Plains 9.0, 7.5
• Citrix

Platforms:

• Windows XP/2000, 2003, 7
• MS SQL Server 2008 R2, 2008, 2005, 2000, 7, 6.5
• MS SQL Reporting Services 2005, 2000
• MS Great Plains 9.0, 7.5
• Citrix

Platforms:

• Citrix
• MS Great Plains 9.0, 7.5
• MS SQL Reporting Services 2005, 2000
• MS SQL Server 2008 R2, 2008, 2005, 2000, 7, 6.5
• Windows XP/2000, 2003, 7
• Software Packages:
• MS Enterprise Manager
• MS Query Analyzer
• Erwin
• Visual Source Safe 6.0
• Visual Studio .Net, 2003, 6.0
• SQL Server Management Studio
• Brio

Skills:

• Crystal Reports 10, 9, 8
• Qlikview
• MS Active Directory
• MS Office
• Sharepoint
• SCOM

Work History:

• Requirements gathering
• Documenting
• Test plan writing
• Data Analysis
• Data Modeling
• Code Standardization
• Specifications writing
• Lightweight Project Management /Team Leadership small teams
• Coding T-SQL, C , stored procedures, VBA
• Testing
• Written Communication
• Verbal Communication

Professional Duties

Confidential

Business Intelligence Senior Consultant

Consulted on database server tuning for SQL Server systems

• Migrated ETL systems from DTS to SSIS for multiple clients
• Wrote custom, database applications for an Oracle 10g system.
• Wrote multiple custom reports using Qlikview and Microsoft SQL Reporting Services.
• Tools and databases used:MS SQL Server 2000 2005, 2008, 2008 R2, MS Office, Windows 2000/XP/2003, SQL Developer for Oracle 10g, Qlikview 10.

Confidential

Senior Database Analyst III

Database analysis and tuning systems.

• Upgraded the primary client facing application from MS SQL Server 2000 to MS SQL Server 2005.
• Designed and implemented a release management structure to support changes to the primary customer facing application.
• Designed and implemented a restore system for SQL 2005 that interfaced with the both the application team and the database administration staff.
• Managed multiple disaster recover exercises overseeing the work of a team consisting of 4 members.
• Provided mentoring to junior level SQL Server database administrators.
• Migrated multiple financially significant applications from SQL Server 2000 to SQL Server 2005.
• Worked across multiple cross functional teams to work towards meeting IT wide objective related to application currency.
• Stabilized a Cognos reporting system with a SQL Server 2000 back-end, implementing job error notifications and job monitoring tools.
• Tools and databases used: MS SQL Server 2000 2005, 2008, SCOM, MS Office, Windows 2000/XP/2003, Vertias NetBackup for SQL Server, Quest Lightspeed for SQL Server.

Confidential

Senior Database Administrator

Professional Duties

• Database design, analysis and tuning for both existing legacy systems and new ground up systems.
• Working within a controlled three tiered environment consisting of development, QA and production. Also help managed SQL script versioning for use with the previously stated environments.
• Work on diverse teams consisting of end users, system analysts and business process owners. Focusing my database design to best meet and fulfill the business user needs.
• Was an integral member of a team the upgraded a company-wide phone system on a strict time and financial budget. As a database administrator on the project team I was responsible for ensuring a clean back-end cut over when the project moved to production.
• SQL Server developer and administrator, along with backup maintenance and performance tuning of existing systems across 3 different database platforms.
• Extensive work designing and building SQL business continuity plan for both SQL Server 2000 and 2005.
• Databases used: MS SQL Server 6.5, 2000, 2005.
• Data Analysis, Database Design and Data Modeling, Database Development plus Requirements Gathering for multiple platforms/projects.
• Primary developer for the corporate ERP system MS Great Plains . Duties include Transact SQL stored procedure development, database design and implementation using MS Enterprise Manager Visual Basic coding, requirements gathering and user acceptance testing.
• Managed testing for a major ERP MS Great Plains version upgrade. Responsibilities included writing and assigning end user test plans for approximately 30 testers. The half a million dollar project spanned 4 months and was implemented without a major disruption to the end user community.
• Redesigned and reimplementation of a 50 plus report MS Reporting Services site. Project responsibilities included security design and implementation using embedded tools and Active Directory group policies, design and development of reports. Gathered requirements from mainly executive level end users. Wrote Transact SQL stored procedures and implemented stored procedure naming convention and inline documentation standards. Implemented report format standardization The MS Reporting Services site now serves as the primary reporting source for a 450 million dollar company.
• Initiated development of a Windows Sharepoint Site used in creating and tracking Help Desk issues. Gathered requirements from end users based on the needs. The resulting system has served in aiding the IT department in tracking and resolving end user issues. Wrote documentation used in end integration.
• Major contributor to the continuing enhancement of the corporate ERP system MS Great Plains using VBA and Transact SQL.
• Primary provider of data analysis and support for the implementation of 60 million dollars in new revenue for the company using MS SQL Server 2000. Created a new database and stored procedures based on data provided from the new vendor in a flat file format
• SQL Server developer and administrator, along with some backup maintenance.
• Tools and databases used: Microsoft Visual Studio, VBA, MS SQL Server, MS Office, Windows 2000/XP/2003, Citrix, Visual Studio.NET 2003.

Confidential

Consultant

Database Architecture, Data Analysis and Data Modeling

• Managed a team of 2 client developers and functioned as the primary database administrator for a 2 million dollar state project. Responsibilities included SQL Server object naming convention standardization. Provided client side documentation along with client developer mentoring. Used Erwin for database design. Worked with site developers to implement Transact SQL code based on application requirements during this 6 month project.
• DBA - SQL Server 2000 production and development
• Worked with a medium sized West Des Moines insurance company to asses their reporting and data needs. Designed and implemented a SQL Server 2000 reporting database by porting over and existing DB2 database. Along with Transact SQL and MS Reporting Services development provided extensive client side documentation. The end result of this 4 month project was a flexible and scalable SQL Server 2000 reporting database.
• Worked with account executives to gauge initial project requirements and estimated approximate billable project hours. Presented project proposals to potential clients.

Confidential

Professional Duties

• Wrote, designed and implemented client websites MS Visual Studio 6.0 ASP , SQL Server 7.0 and SQL Server 2000. Interacted directly with client marketing departments during the design phase of projects.
• Teamed with the internal marketing department to create client centered HTML email marketing campaigns. Campaigns were supported by a SQL Server 2000 database that drove data driven customized content within the body of the email.
• Significantly contributed to the design, development and implementation of SQL Server 2000 and SQL Server 7.0 queries, views stored procedures and DTS packages.
• Acted as technically lead on projects spanning multiple departments. Worked on project through the entire project lifecycle.
• Created internal reports developed with Crystal Reports 10 supported by a SQL Server 2000 database.

Confidential

Programmer Analyst

• Worked with departmental managers to create user driven reports written in Crystal Reports 9 and 8. Developed Transact SQL queries to support user reports.
• Developed a data driven digital dashboard using Brio and Transact SQL queries that was used by department mangers and vice presidents.
• Wrote Transact SQL queries, stored procedures and views for a SQL Server 7.0 environment following existing coding standards.

Confidential

Business Analyst

• Primarily work in a business analyst role gathering requirements from clients and communicating those requirements to a group of 3 programmers.
• Worked on a team that that developed a customized customer centric ERP system designed to revamp the clients communication with it's front line employees
• Coded Transact SQL queries and stored procedures on a SQL Server 7.0 platform.
• Analyzed and aided in the design of a customer site using ASP and SQL Server 7.0.
• Redesigned and rewrote the enterprise cite using Macromedia Flash.