Richard Lewis
|
Citizenship : United States ▪ Date of birth : 25 March 1968
|
|
Contact
|
Tel : 518.052.2252
e-mail : richard.lewis59@gmail.com
|
|
Address
|
29 Judith Lane, Dayton, MN 32014
|
|
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:
.NET Framework (VB.Net), Visual Studios, ASP.NET, Office,
|
SQL Server (7.0,
2000, 2005, 2008), Access (XP,2000,2003,2007, 2010) , Oracle (Limited),
Sybase (Limited), Visual Fox Pro, Coefficient, Log Analyzer
DBArtisan, Red
Gate SQL Backup
|
Windows
Clustering, Heat, Track-It, Reporting Services (Limited), Litespeed,
|
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
University of Phoenix Online, Phoenix, AZ
|
|
|
Work Experience
|
Tribal Ventures, Eagle Butte, SD
|
Contract
|
Access
Developer (Access 2007, VBA, Office 2007)
|
February 2007 to Present
|
ü Created
a customized Access 2007 database to track survey data collected via
Young Voices survey.
ü Created
Young Voices Survey document
ü Created
a customized Access 2007 database to track survey data collected via the
Lakota Immersion Survey for both Lakota and Child Care Components
ü Created
and Implemented a Access 2000 Client tracking database for CRST Support
Service office .
ü Migrated
CRST Support Services database to Access 2007.
|
Cheyenne River Housing Authority, Eagle
Butte, SD
|
Contract
|
Access
Developer (Access 2007, VBA, Office 2007)
|
March 2006 to Present
|
ü Creating
a customized Access 2007 database to track Rental and Tax Credit
applicants
ü Creating a customized Access 2007 database to
track CRHA Unit inspection and history
ü 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
|
Dealer Marketing Service, 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
|
Milestone Systems, 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.
|
National Research Corporation, 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
|
Northern Plains Healthy Start, 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
|
|
|
|
|
.JPG)
0 comments:
Post a Comment