Developer Sales .Net Business Sql Consultant Server

Greg A. Bloom

Certification: MCTS - Microsoft SQL Server 2005 Business Intelligence

MCTS - Microsoft SQL Server 2008 Business Intelligence

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

Wolcottville, IN 46795 - 260-***-****

Microsoft Business Intelligence and Data Warehouse Consultant

Specializing in Microsoft SQL Server SSIS, SSAS and SSRS

[pic]

[pic]

Proficient Microsoft Application Developer for windows/website/web

applications. Database developer offering over 23 years of database and

software development experience. Have converted FoxPro applications to

.Net Windows app and web applications.

Skills:

Visual Basic .Net 2003/05/08/10 Microsoft SQL 2000/05/08

Crystal Reports Developer C# .Net Developer

ASP.Net Developer FoxPro/dbase/Access

End User Support/Training Database Developer

Silverlight RIA Developer RIA Services

Experience with:

. Microsoft SQL Server Reporting Services (SSRS 2005 & 2008)

. Microsoft SQL Server Integration Services (SSIS 2005 & 2008)

. Microsoft SQL Server (2000, 2005 & 2008)

. SQL Server Business Intelligence Development Studio (BIDS/Visual

Studio 2005/08/10)

. Business Objects Crystal Reports V4.0 - V11.5 R2

. Converting Crystal Reports to SQL Server Reporting Services

. Ad Hoc reporting using Microsoft Report Models and Report Builder

. Microsoft SQL database development and administration.

. Microsoft SQL Server stored procedures / T-SQL development

. Microsoft .Net Visual Studio - VB.Net, C# development for windows

forms and web (ASP.net)

. Microsoft Visual Source Safe, Microsoft Office, Microsoft Project,

Microsoft Visio

. Microsoft FoxPro, dbase III

EDUCATION Purdue University, West Lafayette, Indiana - Bachelor of Science

Attended DEVConnections 2009 Orlando (SQL/SharePoint Tracks) - March 2009

Attended Kimball University - Microsoft Data Warehouse in Depth -

Certificate - March 2009

Attended Microsoft SQL 2008 Business Intelligence Boot Camp (SSRS, SSIS,

SSAS) - May 2009

PROFESSIONAL EXPERIENCE

Contractor - October - Current 2010

.Rolling Video Games of Indiana, Kendallville IN - Design and develop

ASP.net website for booking Mobile Video Game Parties. Create booking

calendar, shopping cart integrating multiple party fee structures, travel

fees and sales tax.

Technologies use: SQL 2005, Visual Studio 2008, Visual Basic .Net.

Consultant - October - November 2009

Contractor - January - October 2010

.AEP Cooke Nuclear Plant, Bridgman Mi - Design and develop SQL 2005

Reporting Services reports for ActionWay Software program for corrective

actions. Test and validate data for ActionWay software compared to INDUS

mainframe application. Document all aspects of project. Work with data

warehouse to validate reports. Worked in team environment on converting

current systems to ObservationWay and Dashway. Technologies used: SQL

2005, Visual Studio 2005, Visual Studio 2008, C# and SQL Reporting

Services.

Consultant - October - November 2009

.Trinity Church - Design and develop website for Trinity Church United

Methodist in Kendallville, Indiana. Project requirements were to create

calendar for events, display weekly events on home page and send out weekly

calendar events via email. Also, create on-line newsletter system and make

sermons available for listening and downloading.

Technologies Used: SQL 2005, Visual Studio 2008, VB.net, and ASP.Net 3.5.

Consultant - September - 2009

.Kits, Inc - Create email shipping confirmation and maintenance email

reminders. Export data from Foxpro based system to SQL Server 2005

database. Create ASP.net application to create shipping confirmation

emails from daily sales and also create a maintenance reminder for

purchases greater than 2 years.

Technologies Used: SQL 2005, Visual Studio 2008, VB.net, and ASP.Net 3.5.

Consultant - June-August 2009

. Paragon Medical - 2 month contract to create data mart for manufacturing

delivery reports. Combine several tables from Visual Manufacturing

Software to create supply and demand report via VB.net and exporting SQL

data to Excel.

Technologies Used: SQL 2000, Visual Studio 2008, VB.net, Excel 2003/2007,

Visual Mfg Enterprise Software.

Consultant 2008 - Present

. Therma Tru Finishing Systems - create data warehouse for analyzing new

pricing strategy for products, customers and geography, using the Kimball

Methodology. Conducted requirements gathering and interviews. Develop

data warehouse bus matrix to document business processes and dimensions.

Designed the business process dimensional model. Developed the data

architecture plan. Create SQL 2008 data warehouse and developed fact and

dimension tables with appropriate business keys. Document the high level

ETL plan. Create SSIS packages to move FoxPro Order Entry data into SQL

staging tables. Create ETL packages to move facts and dimensions into star

schema SQL 2008 tables. Create master package to control each individual

SSIS package. Define Business Intelligence applications concepts. Create

initial reports on relational data warehouse with SSRS 2008. Create cube

with SSAS 2008, defining data source, views, cube, dimensions, facts,

hierarchies, attribute relationships, deploy and process cube. Create

canned static reports in SSRS for sales analysis utilizing report

parameters. Train how to use Excel 2007 to access the cube for ad-hoc

reporting. Technologies Used: SSIS 2008, SSAS 2008, SSRS 2008

.Consultant 2007 - 2009

Star Fleet Trucking - Create static daily sales reports with SSRS 2005 for

report delivery via email.

Technologies Used: SSRS 2005, SQL Report Server

. Consultant 1995 - 2008

Redman Homes, Fortune Home, Dutch Housing, Champion Homes, Commander Homes,

Four Seasons Housing, Manufactured Housing Enterprises - Located in NE

Indiana and NW Ohio

Work with Champion Home Enterprises management to collect requirements for

converting invoicing main frame application to PC-based server system.

Designed database tables, screens, reports, work flows and then code

system. Worked with team for verification and testing. Created set-up

disks for deployment. Work with end-users for maintenance and

enhancements. Design, develop and deploy business reports and analysis

solutions for Manufactured Housing Tracking (MHT) Software Project. Re-

design and create 750 plus Crystal Reports from mainframe to custom

relational database application. Reports were developed for purchasing,

plant scheduling, invoicing, sales, customer service and warranty. Created

Visual Basic front end application for report library based on department

and report filter criteria for reports.

Technologies used: Visual Basic 6, FoxPro 2.6, Crystal Reports 8, Visual

Source Safe

. Consultant 1995 - Present

Design TripTrack software for trucking firm for creating freight bills,

paying drivers, invoicing customers and integrating with Microsoft Great

Plains software. Developed hundreds of reports using Crystal Reports

11.5R2 for management and daily operations based on SQL 2005 database and

C# application. In 2005, converted FoxPro TripTrack to C# .Net

application.

Technologies used: FoxPro, Squiter Codebase, C#, SQL 2005, Crystal Reports

11.5R2, Visual Source Safe, SSIS, SSRS

. Consultant 2008 (Independent Contract)

Four Seasons Housing - Middlebury, IN

Create purchase order system and bill of materials by each manufactured

housing model number.

Technologies used: Microsoft VB.net, SQL 2005, Crystal Reports 11.5r2,

Visual Source Safe

. Consultant 2008 (Independent Contract)

Keystone RV / Dutchmen RV - Goshen, IN

Designed and implemented a Recreational Vehicle freight quoting system for

rate quotes from manufacturer to dealer. This system integrated a web

service from ALK Technologies PC Miler web service to bring in toll miles

and toll rates with miles traveled through each state.

Technologies used: Microsoft C#, XML, Microsoft SQL 2000, Web Services

. Consultant 2007 (Independent Contract)

Tri-State Ag - Edgerton, OH

Created a database driven web site that allows farmers to search by

category and sub-category for products and request price quote.

Technologies used: Microsoft VB.Net 2005, SQL 2005, ASP.Net

. Consultant 2008 (Independent Contract)

Boat Transit, Inc.

Web based system to share quotes, freight bills, and movements of boats

throughout the US.

Technologies used: Microsoft VB.Net 2003, SQL 2000, ASP.Net

. Consultant 2002-Present (Independent Contract)

Kits, Inc. - Wolcottville, IN

Create windows based order entry system integrating with UPS World Ship

product, to print sales orders. Create Data Warehouse to analyze sales and

shipments through SQL Services Analysis Server.

Technologies used: Microsoft Visual Basic 6.0, FoxPro 2.6, Crystal Reports

8, SSRS, SSIS, SSAS

Computerized Business Solutions, Inc.

1987 - 1995

Provide computer hardware, software and network solutions to local

companies in northeast Indiana. Also, provide custom database solutions to

local manufacturing companies using FoxPro database systems.

Contact this candidate