Data Warehouse Architect/Developer Resume

SUMMARY:

Confidential has a great love of technology and strives to learn new technologies whenever the opportunity presents itself. He is an energetic self - starter and a strong team player and his solid communication skills and diligent work ethic make him an excellent addition to any company.

TECHNICAL SKILLS:

SKILLS: SQL / T - SQL C# .NET MDX VisualBasic.Net JavaScript HTML CSS VBScript Classic ASP XML VBA DOS Software Visual Studio SQL Reporting Services (SSRS) SQL Server Database SQL Server Integration Services (SSIS) SQL Server Analysis Services (SSAS) MySQL Visual Studio Tools for Office MS Visio Oracle COGNOS ORACLE INFORMATICA Framework/Technology AZURE ADO.NET Windows Communication Foundation (WCF) SharePoint ASP.NET 1.1, 2.0, 3.5 Web Services IIS Hardware PC Components (internals) PC Peripherals Networking

PROFESSIONAL EXPERIENCE:

Data Warehouse Architect/Developer

Confidential

Responsibilities:

SSIS/TSQL to extract transform and load data from various data sources
Excel and macros to help automate management of dimensions from a power-user perspective
VB.NET to custom code data cleansing of Excel files to export to CSV
TSQL to transform and apply any business rules. Also to help manage automated content.
Data Modeling
SCRUM and requirements gathering.

Data Warehouse Architect/Developer

Confidential

Responsibilities:

SSIS/TSQL for data migration
SSAS for report consumption
Data modeling
Utilized Trello for project/task management
C#.net for custom transformations and data cleansing

Data Warehouse Architect/Developer

Confidential

Responsibilities:

Utilize combination of SSIS and custom code to import variety of data sources into SQL Azure
Created Azure based virtual pcs for processing in the cloud
Created custom java based scheduling component in Azure
Variety of data/application modeling

Lead Database-ETL Architect/Developer

Confidential, Janesville, WI

Responsibilities:

Led 2 BI developers and 1 DBA
Design and implement data models for wide range of projects
Complex TSQL utilizing XML for web consumption
SSIS for data migration
SSRS for data visualization
SSAS for data analysis
Data modeling
Implemented database and software source control utilizing continuous integration methodology.
Interaction with internal/external business units to gather requirements
Work with business units to determine project requirements and project planning

Senior Business Intelligence Developer

Confidential, Madison, WI

Responsibilities:

Using PL/SQL for business logic (Oracle)
Documentation
Requirements gathering.
Data modeling

Senior Business Intelligence Developer

Confidential, Denver, CO

Responsibilities:

Enhancing current ETL framework
Create/support pivot tables for analysis
Full life cycle creation of SSAS cubes
Integration of new data sources into existing ETL platform
Increase performance while processing more than 1 billion records

Enterprise Data Analyst

Confidential, Denver Co

Responsibilities:

Creating a reporting solution through SSRS and SSIS that reported various I9 employment statuses. This system exported data from a legacy AS400 and decrypted a vendor file while transforming the data into a data warehouse for reporting. The reporting solution contained various reports from a dashboard level, summary level, trending level and down to employee specific history.
Supported legacy financial reports and middleware
Migrated legacy access 97 solutions to SSIS/SSRS.
Took part in an initiative to replace all of our various data processes with a unified master data management system
Documentation of various data processes and flows.

Business Intelligence Analyst-Developer

Confidential, Denver, CO

Responsibilities:

Discovery of current ETL solution and performance enhancement recommendations
Converted SSIS tasks to execute in parallel manner
Optimized SQL stored procedures for performance
Utilized SSIS out-of-box components for maintenance and scalability enhancement

Business Intelligence Developer

Confidential

Responsibilities:

Create data transformation process with SSIS
Create SSRS reporting solution from the data warehouse created from the SSIS solution
Convert previous SSRS reports from MDX to SQL
Document entire reporting solution (SSRS, SQL stored procedures/functions, SSIS, ASPX)
Created ASPX pages to present the reporting solution to the user
Suggest improvements where needed

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship