Arthur D. Lorenzini Email & Phone Number

 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. Provided Office 2007 training (Word, Access, Excel, Powerpoint, Outlook) to staff members..

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

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

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

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

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