Database Specialist Resume

SUMMARY

More than 13 years BI experience in a SQL server environment using products ranging from Crystal Enterprise to the latest Microsoft BI Stack.

TECHNICAL SKILLS

Expert in: T - SQL writing and tuning queries and complex stored procedures

Familiar with: C#, Microsoft Visual Basic®

Database: Microsoft SQL Server and Microsoft Access

Platforms: Microsoft Windows® XP and Microsoft Windows 8 and Linux

BI Tools: Expert in SSRS, SSIS, and Excel; Proficient with SSAS, Crystal Reports

PROFESSIONAL EXPERIENCE

Database Specialist

Confidential

Responsibilities:

Primary responsibilities include Data Warehouse development and report design and delivery systems using SQL Server 2012 SSRS, SSAS, and SSIS.
Sole responsibility for Data warehouse design and maintenance for US and UK divisions.
Designed, built, and maintained flexible system for selecting, sending, and tracking customer emails through customer and order lifecycle.
Developed system to normalize, load, store, and error check UPS billing data for our third party UPS bills that now total over 100K records each week. This has resulted in over $600K in savings over the last 3 years.
Converted reporting systems from MS Access reports run by IT department to a self-service / automated delivery system using Crystal Reports then was an early adopter of SSRS.
Developed an inventory tracking system to assist Merchandising team with managing inventory when one product may be sold as several different skus and is held by vendors for exclusive products.
Developed system to deliver invoices to government clients that paid by credit card.
Published an early comparison between Crystal Reports and SSRS
With no budget in spare time conceived, designed, developed data warehouse using SSAS and ETL using SSIS improving information available to management.
Standardized data handling practices for our list management eliminating problems with loading and extracting our mail lists for catalog mailings.
Developed reporting system that uncovered inefficiencies in inventory management demonstrating the structural problem in how corporate stock programs were managed.
Developed reports showing gaps in pricing policy that resulted in an inability to convert large quotes into orders.
Developed customer retention reporting system to better track how frequently and quickly customers return to make subsequent purchases.

Programmer

Confidential

Responsibilities:

Developed standardized data extractions to send sales data to clients
Developed reporting systems for payroll for employee bonuses
Developed queries to filter call lists improving sales performance.

Analysis Assistant

Confidential

Responsibilities:

Automated reporting systems making what was a full time job into a part time position.
Developed data systems for managing long term incentive programs
Helped develop down time tracking system to better track rep time off the phone.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship