Rick Cook

**** *. **** **. *********, WI *****

C: (630) 464 – 0887 ac2vus@r.postjobfree.com

Objective

I’m interested in joining a progressive organization. 7 years of experience in SQL Server Management Studio establishing data warehousing, development, and reporting. I have a record of accomplishment and meet timelines and exceeding expectations. I’m highly organized, friendly, professional, and able to create relationships with clients, co-workers, and outside resources. I’m confident and resourceful and I believe I can become one of the team’s key personnel bring to the table problem-solving, debugging, and multitasking on projects skills.

Experience

Consultant 6/2017 – Current

Specializing in the MSBI Stack Milwaukee, WI

Various clients current focus;

ETL process improvement

SSIS & SSRS upgrades and new process

Database Administration maintenance plans and Backup & Recovery

Database performance tuning

Database Management Specialist 7/2013 – 6/30/17

Managing 2012 MSSQL Server Industries for the Blind West Allis, WI

Designed and built the data warehouse for vendors feeds.

Upgraded MS SQL Server from 2008 to 2012 BI. Addressed all the conversion issues in both the databases and visual studio projects.

Monitored server updates and assessed if issues came up.

Created maintenance plans and monitoring for the databases. Created the backup and disaster recovery process. Key point of contact for any issues 24/7 support.

Debugged user issues and tuned stored procedures for optimum performance.

Designed vendors data integration for Major Catalogs for continuous updates.

Identify required source data. Builds the various links and mapping.

Built ETL (SSIS) processes for vendor database for staging and data cleansing.

Built and maintained user databases for consumption after transformation.

Create workflows for updates to maintain the vendors sources data. Address changes that were either vendor related or internal related and adopt these changes into the workflow or design if needed.

Map or create vendor attributes to conform to internal attribute structures.

Additional Files; Create workflows for both vendor and internals files so they can be utilized in the main workflows.

oExamples would be Inventory updates, Catagory Updates, Discontinued status changes, Images. Any file that the vendor may offer that was not part of the Vendors Base Offering.

Site supported was https://ibsupply.com/

Sales Project Analyst 6/2006 – 7/2013

National & New Channel Accounts Reporting Essendant

Deerfield, Illinois

Create reports sourced from the Mainframe and Oracle then consolidated into Microsoft Sequel Server and Microsoft Access for reporting.

The types of reports varied from sales, operational day-to-day activity to transportation activity and billing reports.

Managed various databases for scheduled reporting for both Internal and External customers.

Scheduled Reports-Daily, Weekly, and Monthly timelines.

Supported issues in reports or the update process.

Created new reports and update or enhanced current reports.

Used various tools for coding tSQL-Management Studio, Hyperion-Oracle bolt-on, and FOCUS-Mainframe. Used VBA in both Access and Excel for report creation and presentation.

Work on Internal & External projects regardless of the size with a strong ability to think creatively and outside the box.

Wrote queries for ad-hoc's and to development of new reporting request.

Automated Reporting; Streamline Internal & External Reporting both source files and front end. Create recurring canned report that is used across multiple end users

11/1994 – 6/2006 - Quebecor World Logistics, Bensenville, Illinois

7/1991 - 5/1994 - Royal Management, San Antonio, Texas

1991 U.S. Air Force, Honorable Discharge

TECHNICAL SKILLS

Microsoft SQL Server 2012

Microsoft Visual Studio 2010/1013 – ETL Process

Microsoft SQL Server 2008 & 2008R2

(SSIS) Integration Services

(SSRS) Reporting Services

(SSAS) Analysis Services

Microsoft Transact-SQL

Hyperion-Oracle base reporting

Highly proficient with advanced options in Microsoft Access, Excel

Experience with MySql

Experience with volume reporting using WebFrame (FOCUS)

Proficient with Microsoft Office Word & PowerPoint

Strong communication and interpersonal skills

Strong analytical and financial modeling skills

Demonstrated ability to manage and work within high-performing team’s while meeting tight deadlines.

Good problem-solving skills

EDUCATION

New Horizons

Microsoft SQL Server 2012/2014

Harper College – Palatine, IL

Microsoft SQL Server Business Intelligence CE Certification

Microsoft SQL Server, Transact-SQL

(SSRS) Reporting Services

(SSIS) Integration Services

(SSAS) Analysis Services

Microsoft Access

ONLC Training Center

Microsoft SQL Server 2008 - tSQL

Online Courses-Microsoft Virtual Academy

Querying with Transact-SQL

SQL Database Fundamentals & Column Store

Boost Your T-SQL with the APPLY Operator

Implementing a Data Warehouse with SQL Server Jump Start

Administering Microsoft SQL Server 2012 Jump Start

Querying Microsoft SQL Server 2012 Databases Jump Start

Developing Microsoft SQL Server Databases

Microsoft SQL Server 2012 training: Reporting Services

Implementing Data Models and Reports

Designing Solutions for SQL Server

Designing Business Intelligence Solutions

Faster Insights to Data with Power BI Jump Start

Implementing Tabular Data Models

Upgrading to Microsoft SQL Server 2014

Introduction to System Administration in Microsoft Dynamics AX

Introduction to Microsoft Dynamics AX Reporting and Analytics

Microsoft Dynamics 365 for Finance and Operations, Business Edition: Overview

MS Excel & Access WEB Services 2007 & 2010

Cameron University - Lawton, Ok

Basic courses in computer programming & business

Great Plains Area Vocational - Lawton, Oklahoma

Vocational various computer courses & graphic design

REFERENCES

Available Upon Request

Contact this candidate