Senior Microsoft BI Consultant Resume Profile

Summary of Qualifications

Talented and accomplished IT professional with 20 years expertise in Microsoft Business Intelligence solutions including extensive experience in ETL, Reporting, and Data Warehousing.

Expertise

Expertise

Years of Expertise

Relevant Technical Expertise:

SQL Server Management Studio SSMS

SQL Server Reporting Services SSRS

SQL Server Integration Services SSIS

SQL Server Analysis Services SSAS

T-SQL

Microsoft Team Foundation Server TFS

Microsoft Visual Studio

Enterprise Data Warehouse EDW

Microsoft Parallel Data Warehouse PDW

Oracle PL/SQL and Toad

Erwin

Relevant Project Expertise

Data Warehouse

Data Conversion

ETL

Data Modeling

Report Development

Technical/Project Lead

Consulting

Relevant Industry Expertise

Healthcare

Telecommunications

Financial

Government

Relevant Project Experience

CONFIDENTIAL
Title	Senior Microsoft BI Consultant
Responsibilities	Build/Design SSIS packages for implementations into EDW. Build/Design SSRS reports from EDW. Source code control using Microsoft Team Foundation Server TFS . Toad for Oracle used for conversion of PL/SQL stored procedures to Microsoft SQL Server. Microsoft PDW stored procedures using CTAS Create Table as Select . Provided technical leadership on multiple projects from 3 to 5 team members. Provided technical leadership and redesign of billing project to include redesign of ETL solution and provided new solution for generating bills that was approved by client. Build/Design QA Test SQL scripts for testing EDW. Development using SQL Server 2008R2 and 2012.
Title	Database Analyst VI
Responsibilities	Implementing SSRS reports and configuring SQL stored procedures to pull from DB2 databases using open query. Wrote stored procedures using OpenQuery to access DB2 data. Source code control using Microsoft Team Foundation Server TFS . Designed Reporting Data Mart using Erwin data modeling and SSIS packages. Development using SQL Server 2008R2.
Title	BI Consultant
Responsibilities	Microsoft SQL Server 2008R2 Business Intelligence BI Development including SSIS, SSRS, and T-SQL development. Development of 10 SSIS packages used to load data and execute federal audit programs. Dynamic T-SQL used to load year based information thru SSIS. Source code control using Microsoft Team Foundation Server TFS . Pragmatic Works BIxPress used to Deploy/Monitor SSIS Packages. Conducted knowledge transfer sessions on how to maintain SSRS Report Manager. Conducted training classes on how to create SSRS reports thru Visual Studio and Report Manager.
Title	SQL Server Developer/DBA
Responsibilities	Data loading of internal application using SQL Server SSIS, SSRS, T-SQL, SQL and stored procedures. Source code control using Microsoft Team Foundation Server TFS . Database administration on as needed basis including backups and restores of QA and Development databases. Responsible for coordinating with the business to gather database/reporting requirements.
Title	Technical Advisor
Responsibilities	System Administration of two Customer Relationship Management CRM systems Sales Logix and SalesForce.com Designed application including building out entire Legal application using SalesForce.com. Managed the conversion from Sales Logix to SalesForce.com. Data loading of application using SQL Server DTS, SSIS, SSRS, T-SQL, SQL and stored procedures. Designed several Reporting/Analytical Data Marts using Erwin.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship