Profile

Summary of Qualification

14 years of experience developing SQL Server and Access databases and applications for data transformation and validation projects for state government, housing, IT, and marketing industries. As well as providing database administration duties in support of these databases.
Solid history in table and query design and implementation in both SQL Server and Access databases. Custom form design, report design, and developing VB modules to support custom Access applications. Writing stored procedures for SQL Server application.
Strong experience in working with project teams and stakeholders to define functional specifications. Proven communication, interpersonal and project management skills.

Availability

From Oct 2010 (ASAP)

Key Skills

Proficient or familiar with a vast array of programming languages, concepts and technologies, including:

SQL Server (7.0, 2000, 2005, 2008), Access (XP,2000,2003,2007, 2010) , OLAP Cubes, Data Warehousing, Oracle (Limited), Sybase (Limited), Visual Fox Pro, Coefficient, Log Analyzer
DBArtisan, Red Gate SQL Backup

Windows Clustering, Heat, Track-It, Reporting Services (Limited), Litespeed, T-SQL, IIS, HTML

Track-It, Windows 2000-2008,XP, Vista, Windows 7, Network fundamentals, Spot Light, Toad for SQL Server

Education

2003 to Present

Pursuing B.S in Information Technology
Confidential,University Phoenix, AZ

Work Experience

Confidential,Eagle Butte, SD

Contract

SQL Server Developer (SQL Server 2008, Access 2007, VBA, Office 2007)

March 2006 to Present

• Creating customized Access 2007 front-end applications to track Rental and Tax Credit applicants. Setup SQL Server tables, views and created stored procedures on a SQL Server 2008 Enterprise.
• Creating a customized Access 2007 database to track CRHA Unit inspection and history
• Installed and configured CRHA’s SQL Server 2008 Enterprise SQL Server. Currently install service packs and security patches.
• Migrated CRHA Unit inspection and history Access database to SQL Server 2008 environment using SSIS packages as well as migrating legacy account data into Microsoft Dynamics SQL Server backend.
• Installed and configured Microsoft Reporting Service. Created a number of reports via the Report Writer.
• Created Database Administration policies and procedures documentation
• Creating a customized Access 2007 database for GED Initiative;.
• Creating a customized Access 2007 database for Homebuyer Counseling for PDO department.
• Creating a customized Access 2007 database to track Grant renovation inventory for Modernization department.
• Creating a customized Access 2007 database to track applicant, waiting list and unit history and inspections.
• Provided Office 2007 training (Word, Access, Excel, Powerpoint, Outlook) to staff members.
• Provided recommendations for hardware purchases (Dell Desktops, laptops, printers, and faxes, software) to support the GED Initiative.
• Aided staff in developing appropriate forms for collecting appropriate data for GED application.
• Provided grant writing technical assistance
• Provided a comprehensive IT assessment report and provided a path to solve issues found.
• Currently working on IT Policies and Procedures documentation and implementation plan.
• Currently working with IT personnel to create and implement a disaster recovery plan.
• Developed and implemented Windows 7 migration plan.
• Develop and execute a Windows 7 training course for CRHA staff

Confidential,Davenport, IA

Full-Time Job

SQL Server DBA (SQL Server 2000 and 2005, Access 2007, Visual Studios 2005, Office 2007)

Aug 2008 to Dec 2008

• Create Database Administration Policy and Procedure documentation
• Develop and implement backup strategies for SQL Server 2000
• Move new SQL Servers into production clustered environment
• Performed database optimizations on SQL Server database including but not limited to indexes and re-structuring of the tables.
• Developed weekly maintenance plans for SQL Server 2000
• Performed periodic production restores to BETA environment.
• Troubleshoot connection issues,
• Provided DBA support to developers
• Created schema documentation

Confidential,Golden Valley, MN

Contract

Database Analyst (SQL Server 2000 and 2005, Access 2007, Visual Studios 2005, Office 2007)

Nov 2007 to Aug 2008

• Create tables, views and stored procedures for Microsoft Reporting Services Reports. The client was migrating from Crystal Reports to Microsoft Reporting Services 2005. On of my primary responsibilities was to convert Crystal Reports stored procedures to Reporting Services store procedure. Also collaborated with the Report Writer to move these stored procedures to the new environment. This also including having to restructure tables and views to accommodate the changes.
• Create ETL solution for Integration of Consultant data from Legacy system (Fox Pro) and new application (Prowess) into Data warehouse. This involved using SSIS to create migration paths from the legacy systems to the new Data warehouse. Used Visual Studios in conjunction with Team foundation to create these packages. Also converted multiple DTS (2000) packages to SSIS via the upgrade wizard and manually.
• Migrated Microsoft Access database in SQL Server database and updated the Access to perform as a frontend.
• Performed database optimizations on SQL Server database including but not limited to indexes and re-structuring of the tables.
• Worked both onsite and remotely for Tastefully Simple, Inc in Alexandria, MN.
• Monitored backup and restores as well as documenting the disaster recovery plan.

Confidential,Lincoln, NE

Full-time job

Database Analyst (SQL Server, Access, Office 2003, VB.NET)

December 2006 to August 2007

• Provided database administrative support for Microsoft SQL Server (2000 and 2005 versions) with primary focus on the Survey Point database and the report server MicroStrategy 7.0
• Aided in the migration of an SQL Server 2000 application into a SQL Server 2005 version;
• Aided development staff in troubleshooting connectivity issue and TSQL code optimization;
• Designed DTS and SSIS package in support of the primary application.
• Maintained the existing disaster recovery plan for the corporation. Also improved the documentation by adding section for backup logging and also instituting a monthly testing process.

State of South Dakota, Pierre, SD

Full-time job

Senior Database Administrator (SQL Server, Office 2003, VB.NET, ASP.NET)

November 1998 to November 2006

• Provided support for Microsoft SQL Server (6.5, 7.0, 2000 and 2005 versions) databases for state-wide agencies;
• Develop application for analysis of database configuration, security, and usages as well as perform standard maintenance, and performance tuning and monitoring.
• Develop and implement a disaster recovery plan for state-wide agency databases. Monitor clustered SQL Server environments.
• Monitor and provide performance tuning services in the SQL Server Development, Test and Production environments.
• Aide the development staff in troubleshooting applications with database issues and provide feedback about any performance issues they might have.
• Help design DTS packages with developers for ETL solutions.
• Troubleshoot Microsoft Access (97, 98, 2000, and 2002 versions) front-end client issues.
• Perform migrations from Microsoft SQL Server 6.5 and 7.0 to the 2000 environment.
• Perform service pack and security updates on SQL Server installations.
• Research the State\'s current database infrastructure issues as they relate to the upcoming release of SQL Server 2005. Set up and maintain SQL Server 2005 installations in clustered environment.
• Develop an inventory reporting module for the Data Center as well as a Database Object copying application using ASP.NET and Visual Basic.NET.
• Develop various DTS package to update server configuration spreadsheets.
• Provide performance trending analysis and index analysis through the implementation of daily profiler traces

Confidential,Aberdeen, SD

Full-time job

Director of MIS (Visual Foxpro, Office)

June 1993 to June 1998

• Managed personnel and was fiscally responsible for the department.
• Responsible for federal grant compliance for the data collection module as mandated by the federal guidelines
• Developed case managed client tracking and reporting application utilizing Visual Basic and Visual FoxPro and implemented it at 19 remotes sites in a four state area.
• Provided hardware and application training to remote and central office staff. This included training on Microsoft Office, the actual application and simple computer hardware maintenance and repair.
• Develop and implement a disaster recovery plan for remote and central office site databases.
• Performed grant writing for renewal of federal funding on an annual basis.

Activities and Interests

Internet

Creating ASP.NET, VB.NET application for learning purposes, learning advanced SSIS topics, researching SQL Server 2005 and the new 2008 topics

Off hours

Reading, Soft-tip dart league, Nascar, Pro football