MICHAEL WALSH
112 Riverwood Glen
Dallas, GA 30157
[Send email using form at bottom]
[Send email to request phone number] 45-6640
EDUCATION
Certification of Achievement- Deploying and Administering Microsoft SQL 2000
Certification: George Mason University, Fairfax, VA 9/2000
JAVA Train to Technology Certification
Certification 5/2001 Great Plains University Fargo, ND
Dexterity Certified Software Engineer
Certification 2/2001 Great Plains University Fargo, ND
Earned Certified Human Resources w/ Payroll Specialist
Certification 12/1999 Great Plains University Fargo, ND
Accounting Applications Specialist (CAAS)
Strayer College, Washington DC, July 1994
Bachelor of Science in Business Administration (BSBA)
PROFESSIONAL EXPERIENCE
April 2008 – Current, Contractor - Allsource - PRG Schultz, Atlanta, GA SQL
Server DBA
Responsible for installing, configuring, performance tuning and monitoring
SQL Server 2000, 2005 and 2008 installations.
Support front end users, project managers and development teams.
Support of SQL Server Reporting Services, database mirroring, snapshots Design,
implement, and support database backup and recovery
Create databases including sizing and objects (tables, views, indexes etc.)
Creation/analysis of stored procedures, triggers, functions utilizing T-SQL.
Install software updates, service packs, hot fixes to maintain databases
Performed Migrations from 2000 to 2005
Design and development of SSIS packages for data import and export
Creation and maintenance of server technical documentation
Dec 2007 – March 2008 Contractor - Everest Consulting - IBM\Honeywell Roswell,
GA
SQL Server DBA
Responsible for installing, configuring, performance tuning and monitoring SQL
Server 2000 and 2005 servers.
Support front end users, project managers and development teams.
Support of SQL Server replication, clustering and Reporting Services
Design, implement, and support database backup and recovery
Create databases including sizing and objects (tables, views, indexes etc.)
Creation/analysis of stored procedures, triggers, functions utilizing T-SQL.
Install software updates, service packs, hot fixes to maintain databases
Performed Migrations from 2000 to 2005
Design and development of SSIS packages for data import and export
Creation and maintenance of server technical documentation
Feb 2007 – October 2007 Talbots Inc. Tampa, FL
SQL Server DBA Responsible for installing, configuring, performance tuning and
monitoring SQL Server 2000/2005 with over 100 SQL Servers and more than 75
databases. Design, develop, and maintain database structures
Experience with Quest LiteSpeed
Support numerous front end users including development teams.
Experience with SQL Server replication, clustering and Reporting Services SQL
2005 Data Mirroring
Design, implement, and support database backup and recovery
Create databases including sizing and objects (tables, views, indexes etc.)
Creation/analysis of stored procedures, triggers, functions utilizing T-SQL.
Perform software updates, service packs, hot fixes, etc. to ensure databases
with up-to-date versions
Performed Migrations from 2000 to 2005
Design and development of SSIS packages for data import and export Support of
data warehouse dba with scripts and maintenance on 64bit system Experience with
Erwin data diagram/modeling tool
Creation of technical and non-technical documentation relating to software
installation and custom VB.NET applications and SQL scripts.
Nov 2005 – Feb 2007 Liberty Furniture Industries, Atlanta, GA
Systems Analyst/SQLServer DBA Maintenance of multiple SQL 2000 production and
development servers. Create databases, create users, and manage user security.
Create database objects (tables, views, indexes etc.) Creation/analysis of stored
procedures, triggers, functions utilizing T-SQL.
Creation of DTS packages, data diagrams and job schedules for automating DTS
Imports/Exports.
Perform software updates, service packs, hot fixes, etc. to ensure databases
with up-to-date versions
Design, implement, and support database backup and recovery.
Perform data cleanup and data integrity maintenance.
Creation of technical and non-technical documentation relating to software
installation, training manuals, process analysis and custom VB.NET applications
and SQL scripts.
Provide development and technical support to a 40 user ERP system (MS Dynamics
GP).
Develop and modify applications utilizing VB.NET, VBA to enhance existing IT
systems.
Management of Crystal XI reports and report delivery applications.
Jan 2004 - Oct 2005 Freedom Scientific, St. Petersburg, FL
Systems Analyst/SQL DBA
Maintenance of multiple SQL 2000 production and development servers.
Administer and maintain MS SQL servers for CRM and ERP systems. Develop and
maintain DTS to work with other SQL databases and automated processing
functions.
Import of data from flat files (with different delimiters like comma, tab etc.)
into the SQL Server 2000 Database tables using Microsoft SQL DTS from external
sources.
Created and maintained database security, database utilities and maintenance
(disaster recovery) plan for core SQL databases.
Monitor and maintain production databases to ensure database efficiency and
optimal performance
Created database objects (tables, views, indexes etc.)
Development of stored procedures, triggers and functions utilizing T-SQL.
Creation of DTS packages, data diagrams and job schedules for automating DTS
Imports/Exports.
Design, implement, and support database backup and recovery.
Perform data cleanup and data integrity maintenance.
Creation of technical and non-technical documentation relating to software
installation and custom VB.NET applications and SQL scripts.
Creation of technical and non-technical documentation relating to software
installation, training manuals, process analysis and custom VB.NET applications
and SQL scripts.
Provide development and technical support to a 30 user ERP system (MBS Great
Plains eEnterprise).
Develop and modify applications utilizing VB.NET, VBA to enhance existing IT
systems.
Develop user reports utilizing Business Objects Server Enterprise XI system,
Crystal Reports XI, SQL Reporting Services, database views, stored procedures and
queries.
Project management working with outside developers in developing custom
software for Internet based software-licensing system and CRM/ERP linking. Feb
2002 - Oct 2003 Ideas International, Inc., Tampa, FL
Application Consultant
Provide consulting and technical support of proprietary automated accounting
system designed in VB with MS SQL\Oracle platform to US and International
clients
Work directly with end users and other consultants to solve a variety of issues
related to the accounting software and business processes
Review VB program code and T-SQL queries using the VB step through process and
SQL Query Analyzer debugger tool to debug stored procedures
Perform the following for clients: SQL server Installation and service pack
implementation, Database Management and Administration, Database upgrades, DTS,
DB Import/Export, Replication, Backups/Restore functions via Maintenance plans,
object creation, database performance monitoring and tuning via SQL Profiler and
Trace functions, recommending and implementing improvements as needed, review of
T-SQL queries for highest performance within the application, including stored
procedures and triggers
Work closely with software development team to submit code changes, software
testing and client customization requests to adhere to client requirements and
overall improvement of product. Design and modify Crystal reports to developer,
customer requirements.
Sep 2001 - Feb 2002 Independent Contractor, Tampa, FL
Great Plains Senior Consultant
Worked as a Great Plains Consultant on several eEnterprise projects
Requirements analysis for SQL database consolidation
Preparation of modified and customized reports using Report Writer, Crystal
Reports
End user module training
Created and maintained database security, database utilities and maintenance
(disaster recovery) plan for core SQL databases.
Jan 2001 - Aug 2001 Mills & Murphy Software Systems, Inc.
Great Plains Senior Consultant
Perform Great Plains Dynamics system implementations for clients
Deployed project plan based on system requirements
Analysis and transfer of legacy data to new system
Educate and train end users on system operation and procedures
Perform on site and off-site technical support
Supported end users with accurate and timely responses to any technical issue
relating to the financial system
Maintained system updates and ensured software always running on latest
software releases and service packs
Devised and maintained complete security and protection of all data enabled by
systematic and documented backup and recovery strategies
Created and maintained database security, database utilities and maintenance
(disaster recovery) plan for core SQL databases.
Documentation of all procedures, technical support and reporting requirements.
Custom report design including report writer and Crystal reports
Provide continuing support for all accounting and financial, technical, and
reporting needs
Oct 1999 - Jan 2001 EYT (formerly Ernst & Young Technologies, Inc.), Chantilly,
VA
Senior E-Business Consultant
Project lead on internal Great Plains eEnterprise system implementation
Designed Project Plan
Gathered system requirements
Deployed project plan based on system requirements
Performed data integration from legacy system, data mapping
Deployed SQL Server 7.0 database
Created and maintained database security, database utilities and maintenance
(disaster recovery) plan for core SQL databases.
Business Process Re-engineering
Performed extensive on site technical support
Set up client server network for implementation of the software
eEnterprise administrator, including updates, backup and restore strategies
,service pack implementation and technical support
Custom report development utilizing report writer and Crystal reports
Creation of technical and non-technical documentation relating to software
installation, training manuals, process analysis and custom VB.NET applications
and SQL scripts.
COMPUTER EXPERIENCE
Applications/Modules-MBS Great Plains, MS Dynamics GP versions 7, 7.5,8 & 9, GL,
HR with Payroll, RM, PM, Returns Management, IV, SOP, POP, Integration Manager,
FRx, Integration Assistant for Excel, Horizons Configurator, Forestar Fixed
Assets, Kairos Direct Deposit, Intellisol International, Liaison Messenger, MAS
90, Microsoft Office, MS Visio, MS Project, Peachtree Accounting, Quickbooks Pro,
Timeslips, Business Objects Crystal Reports XI (Professional and Developer
editions), Business Objects Crystal Reports Server XI, Microsoft Exchange,
Microsoft Outlook, Lotus Notes, SQL Reporting Services.
Software Development-VB 6, VB.NET, VBA, ASP.NET, C#, Visual Studio
2003/2005/2008 .NET, ADO.NET, .NET Framework 2.0,3, 3.5, HTML, Dexterity,
Modifier w/VBA, Visual Café, Rational Rose, Microsoft Frontpage, Macromedia
Flash, Dreamweaver, Visual SourceSafe, T-SQL
Database- MS SQL Server 2008, 2005 (SSIS, SSAS, SSRS, SSMS), MS SQL Server
2000, MS SQL Server 7.0, MS SQL 6.5, MS Access, Quest LiteSpeed, Redgate
SQLBackup, DataMirror, Spotlight, ERWIN
O/S- Windows Server 2003 (32 bit) (64 bit), Citrix, Terminal Server, Windows NT,
Windows 98, Windows 95, DOS
|
