Fredrick W. Miller								July 5, 2009	 
Cell: 763-557-5194
Day: 763-202-7075 
5938 324th Street - Cannon Falls, MN 55009
Email Address: [Send email using form at bottom]

PROFESSIONAL OBJECTIVE

Exploring opportunities to contribute IT expertise towards
consulting/contracting with organizations in evaluating, defining, and addressing
their technology needs.

United Health Technology Feb 2005 through Present (Contract Extended until Jan
01, 2010)
6150 Trenton Lane
Plymouth, MN 55442

Extensive SQL Server 2000 and SQL Server 2005 development to support ongoing
Tangoe data input and updates using DTS Packages and Stored Proceedures.  Design
and and implement Access Projects for user input and reporting.  Design process
for scheduled updates and FTP transfer.
Design and Development of a 7 separate MS Access Relational Database for the PCS
Optimization project to analyze Telecommuter expenses.  This requires gathering
data from various source types such as CSV Files, MS Excel Files, and SQL Server
Tables from various vendors and locations.  Cleansing the data and creating new
normalized tables in MS Access for analysis.
Prepare multiple MS Access databases for conversion  to SQL Server 2000. 
Modification of MS Access queries to conform to SQL syntax.  Creation of Stored
Procedures , DTS Packages and Views.  Schedule jobs for updating SQL Tables.  
Extensively invlolved with  Data migration from existing Databases to Tangoe SQL
Server 2000    

Ansell Health Care Oct 2004 through Dec 17, 2004 (Contract)
1500 Industrial Road
Dothan, AL 

Design and build Cognos Decision Stream Fact Builds to extract,  cleanse and
query data from an Orcale Data Warehouse and deliver it to csv files.  Builds
consist of Sales Data, Credit Data, Salesman Information, Company and Region
Data.

Cargill Salt  Jun 2004 until Sep 2004 (Contract)
12800 White Water Drive
Minnetonka, MN

Cognos Decision Stream and SQL 2000 Data Transformation Services development to
extract data from JD Edwards and the Cargill Salt Data Wharehouse.  Incorporate
functions and Decision Stream Build to transform and deliver data to  to a .csv
file for Daily updates.

MS Access Customer Price Quotation stand alone Database for approximately 70
users.  This is a complete bottom up development.  It includes the ability to
export data to MS Excell format,  save Reports to Word or PDF format.  The
ability to send a report either by Email or Fax to the customer.  It also allows
data entry and address lookup of both shipper address and shipment address as
well as the buyers information.

Young America Client Services Facility  Feb 2004 until May 2004  (Contract)
18671 Lake Drive East
Chanhassen, MN
 
SQL Server 2000 and SQL Server 2000 Analysis Services Developer 

Duties: 
Design, modify and troubleshoot DTS Packages.  
Create and modify SQL Views and SQL Tables.
Active X Scripting for DTS Packages 
Implement VB Script and Stored procedures.
OLAP Cube processing


88TH Regional Readiness Command (USAR)  Jan 1998 until Nov 2003 (Civilian
Employee) 
506 Roeder Circle
Ft Snelling, MN 55111

Information Technology Specialist

Duties:
MS Access Training development and coordination
MS Access Database Instructor
MS Access Development (Reports, Queries, Macro’s and Forms)
Project Coordinator, Developer and Administrator of the 88th RRC CDMS
Leve I and II Help Desk support for MS Access and SQL Server
Level II Help Desk for HP Network Printers, HP Scanner and Xerox Copiers
Database Management and Maintenance (SQL Server and MS Access mdb’s)
COGNOS Reports, Cube Development and  Decision Stream development and
implementation
COGNOS Project Manager

PROFESSIONAL DEVELOPMENT

Associate of Science Degree in Information Technology 
MS Access Developers Course, MS Visual Basic  Developers Course,
MS SQL & Developers Course, MS SQL 2000 Developers Course
COGNOS Impromptu and Administration,  COGNOS Power Play Reports and
Administration, 
COGNOS Power Play Transformation and Administration,  COGNOS Decision Stream
Currently enrolled in MCAD/SD AND MCDBA Certification Training


CAREER HIGHLIGHTS

Demonstrated strong leadership skills and technology expertise in
developing/delivering MS 
Access Database Queries, Forms and Reports training materials for 400+
civilians, soldiers and reservists.

Appointed to drive critical project migrating MS Access Data Warehouse to SQL
2000, 
including DTS package design and deployment.

Significantly enhanced and successfully maintained a database management system

comprised of MS Access Data Warehouse and MS Access Interface with switchboard
and 
forms/reports/macros vital to facilitating access of 200+ team members.

Created, developed and programmed numerous stand-alone databases utilizing MS
Access Backend for data, VBA, VB   and MS Access Application for front end user
interface for multiple facility sections 

Proficiently applied vast MS Access 97 and 2000 skills towards designing
databases, 
building queries, developing forms, creating reports, and designing macros.

Strategically extracted/cleansed data from multiple data sources including SQL,
FoxPro dbf., Excel Spreadsheets, CSV Files, and MS Access Databases through
application of refined 
decision stream modification and design techniques.

Collaborated with COGNOS Consultants in designing and developing Power Play
Cubes and 
Reports, and subsequently spearheaded the design of a monthly process to run,
maintain, and modify Power Play Cube and Reports to effectively address static
numbers reporting needs.

Project managed COGNOS Development Team initiatives, utilizing Decision Stream,
Power 
Play Report/Transformer, Impromptu Report, Upfront, Visualizer, and Access
Manager to effectively meet project timelines and objectives.

Entrusted with directing the design and modification of COGNOS Impromptu
Catalogs, Reports and Web Reports, with accountability for troubleshooting,
defining, and addressing problems to ensure integrity and reliability of
reporting systems.

Design, Modification and Implementation of  Decision Stream Dimension, Fact and
Hierarchic Builds.  Creation of User Defined Function and Transformation
processing

PRIOR EXPERIENCE

Fred’s Audio Video 1984 – 1998  (Owner)
Cannon Falls, MN

Electronics Technician

US Army Reserve Active Duty  1977 – 1984
Recruiter and DAC