Project Manager Sql Server

Don Anderson

**** ******* ******

Louisville, KY 40220

502-***-**** ************@*****.***

IT Development Manager

Programming, Database Analysis and Design, Project Management, Web

Development

More than 20 years experience on a variety of projects involving

expertise in programming, database design, reporting and data handling

issues. I have worked with a variety of database systems ranging from

early flat file systems to current relational and object oriented

databases including MS SQL Server, Oracle, mySQL, and Progress SQL. I

have worked in the areas of programming, data and database analysis, and

database design. Additionally I have provided systems and workflow

analysis to identify project requirements and potential solution paths,

as well as having extensive knowledge of interface design. I have over 20

years experience with a variety of programming languages from Assembler

and Pascal to .NET and PHP as well as 16 years experience with Crystal

Reports.

o Visual Basic 3 - Visual Basic.NET - 15+ years

o ASP to ASP.NET - 12+ years

o C# - 3+ years

o Silverlight/WPF/XAML - 2 years

o Web scripting including VBscript, Javascript and PHP - 12+ years

o Magento 1 year

o Data Integration Services - 15+ years

o T-SQL coding skills - 20+ years

CAREER ACCOMPLISHMENTS

Health Care Recoveries

. Project to determine degree of automating manual review of insurance

records for subrogation

. Extract statistical sample from millions of records and imported test

sample into MS SQL Server

. Scrubbed data to remove aberrant and out of scope records

. Created indices to speed the process of data analysis

. Created with Dr. Donna Ingram (statistician/mathematician) a formula to

run against a blind year's data set to determine accuracy of the results

. Conservatively estimated a cost savings of 30% of existing manual labor

using the resulting process

Wisconsin Milk Marketing Board

. Approximately two year engagement to initially determine a new

infrastructure for this $25 million per year organization representing

the Wisconsin dairy industry

. Worked as project manager and analyst to provide the infrastructure plan

and guide it's implementation

. Worked with selected employee/management groups to extract information to

determine additional information technology needs of the organization

. Assisted in selection of new accounting software to replace the non-Year

2000 software then in place

Manning & Napier

. Engaged by Stephen E. Arnold to develop a new database and front end

interface for data extracted from scanned government and military

documents for Manning & Napier

. Data was initially stored in an Access database after being normalized,

then converted to SGML format to be uploaded to SPARC Unix computers for

use in a natural language search engine, DRLink

. Data consisted of tif images of the actual records along with related

text data extracted from the documents prior to upload

. Mr. Arnold referred to the resulting database and program interface as a

"world class computer system"

MultiPackaging Systems

. Charged with developing a reporting system for this large printing firm

to report on a variety of business operations with an emphasis on

productivity and sales

. Used Crystal Reports to extract the relevant data from a large Progress

SQL database

. Created a front end for the reporting system using MS Visual Basic

. One line supervisor commented that the reports "finally give me the

information I need to judge the productivity of my department and are

even better than the reports I received at a former company from an

Oracle database"

. Also exported data from the client's database to provide a critical

report to their bank in an older data format

Apple One

. Engaged along with Stephen Arnold to conduct a large data mart study for

Apple One, a Los Angeles based employment agency with over 367 locations

across the United States and the major provider of temporaries for Walt

Disney Productions

. Served as project manager and analyst on the project

. Apple One was in the process of migrating their data from Microsoft

Access to MS SQL Server

. Provided several alternative pathways in a 109 page report entitled

"Apple One: Data Mart Study"

. One recommendation involved establishing several central MS SQL Server

data warehouses or repositories to provide national and regional access

to critical data

Big Brothers Big Sisters of Kentuckiana

. Developed a program to manage the "Bowling for Kids Sake" program which

brings in around $500,000 per year to this non-profit organization

. Created both screen and print reports to track the progress of the

program and its participants

. Created routines to export critical data to Excel and HTML to provide the

necessary information to the organizations billing agency

. Program was written in Visual Basic 6 with reports in Crystal Reports 8

Peabody Painting and Waterproofing

. Developed a program using Visual Basic.NET 2003 to manage jobs, crew

assignments, hotel reservations and vehicles for the company operating in

40 states

. Used Infragistics tools to provide more detailed reporting screens as

well as Crystal Reports 11 to provide the printed reports

. Linked to the company's Quickbooks database to import data on purchase

orders

Smart Business Network

. Managed and implemented a system for a large business magazine publish

operating in 19 city markets to create a mashup of information both from

a traditional MySQL database as well as from RSS feeds in an online

application

. Primary code written in PHP 5

Synerge Systems

. Supervised and assisted in the development and modification of a .NET

2003/2005 application to manage real estate short sales

. Modified the existing program to provide multiple views of the data based

on the role of the user - three initial views and primary roles were

identified and implemented

PROFESSIONAL EXPERIENCE

Ebit Information Systems, Jeffersonville, IN November 2012 -

February 2013

Information Technology

Consultant/Crystal Reports Architect

. Initial project for Clifty Engineering in Madison, IN

. Modify Crystal Reports in E2 Shop System

. Determine technologies and platforms for future growth

. Create new reports based on the data in the shop system database

. Assist moving database from Access to SQL Server 2008

. Analyze the business requirements for current and future projects

Traffic Builders, Louisville, KY June 2011 - April 2012

Marketing

IT Development Manager

. Manage IT vendors and contractors

. Manage IT software projects and modifications

. Determine technologies and platforms for future growth

. Responsible for the performance, integrity and security of the TB

databases

. Develop database structures and procedures for analytics and future

databases

. Analyze the business requirements for current and future projects

. Collaborate with marketing and data teams to improve systems and service

to clients

. Develop, maintain, and present Crystal reporting in the product line

. Create and maintain technical documentation and training to support

applications, systems and processes

Quantum International Corporation, Louisville, KY April 1993 - December

2010

Business and technology consultants

Consultant/Senior Programmer/Analyst

. Managed and led a wide range of analytical and software development

projects ranging from local to international in scope

. Managed day to day operations of a small consulting firm

. Supervised and participated in the development of software packages for

clients

. Provided hands on database administration and analysis

Alpha Omega Software, Louisville, KY 1983 - April 1993

Software development and training

Programmer/Instructor

. Provided database design, software development and training

. Managed a small software development firm

EDUCATION

University of New Orleans, New Orleans, LA

BA, 1968

Jefferson Community College, Louisville, KY

AA, 1992

Contact this candidate