SUMMARY:

I have over 12 years of experience in the IT field working at county, state, national, and international level projects in multiple industries. Currently I am focusing on Microsoft BI (Data and Analysis) with an emphasis on efficiency, integrity, and automation. Some of my strengths are big picture understanding with the ability to analyze and present focused subjects in the setting of business and/or technical audiences alike.

TECHNICAL SKILLS:

Tools: BIDS 2005/8/8 R2/SSDT/Azure MS Excel, MS Word, MS Visio, MS Project

Data Analyst: T - SQL, Excel, Warehousing, SSAS

Data Architect: Relational, Dimensional, ERwin Data Modeler 7.3r/8, Visio

Database Developer: T-SQL, SSDT, SSIS, SSAS, DTS, C#/VB.Net, MDX, PL/SQL

Data Warehouse: Star/Snowflake Schema, SSIS, SSAS

DBA: SQL 2000/5/8/12/14/ Azure, Red-Gate

DB/T-SQL Tuning: Report Writer

SQL 2000/5/8/12/14/ Azure: SSRS, SSAS, Crystal Reports

Systems Analyst: MS Suite of Client and Server Applications

Systems Admin: MCSA 2003, Fluent in Server 2008

Others: IIS, TFS, ISA 2006, Exchange 2003/07, VMWare

EXPERIENCE:

Confidential, Minneapolis, MN

Data Architect

Responsibilities:

• Supporting the current Data Warehouse loads focusing on T - SQL/SSIS implementation, load performance, and general process improvements (including SDLC and Automated Production Deployments)

Confidential, Oak Park Heights, MN

Database Developer

Responsibilities:

• Brought in to create an automated system to manage the daily tasking, for the Warehouse Manager, and time-log entries, for employees.
• The system takes into account the availability of inventory in the warehouse, weighted restocking needs for Sales and availability of the work-force to complete the tasks.
• Designed and implemented the database model in SQL 2014
• Designed and implemented the C# .Net WinForm front-end in VS 2013
• Designed and implemented the reporting framework in SSRS 2014

Confidential, Grove Heights, MN

Lead BI Developer

Responsibilities:

• Lead a team of 5 BI developers/testers
• Analyzed, mapped and created design documentation for development of incoming vendor files
• Automated the development/testing of packages for incoming flat/XML data feeds
• Converted text file reports to SSRS 2008 R2 (from VB6 code and SQL)
• Translated historical data (mapping and SSIS packages) into their new models for Production (transactional) and the DW (dimensional)
• Designed development and testing strategies for their Payment Solutions project (BI specifically)
• Created an automation utility for testing the historical and daily processing across multiple servers from a single point of administration

Confidential, Bloomington, MN

Database Developer

Responsibilities:

• Utilized as the Data systems resource in the following capacities:
• Analyze data streams
• Create USE cases for developers
• Design the logical data model
• Implement physical data model (tables, indexes, procedures, etc.)
• Implement statistical reporting utilizing SSRS 2014
• Administer SQL Azure databases
• Primary and Geo-redundant databases
• Implemented an SSDT project to…
• Maintain the source of truth
• Schema comparisons
• Publish changes to the primary/secondary databases in an automated fashion

Confidential, Minnetonka, MN

BI Architect

Responsibilities:

• Hired as a Lead BI developer/architect for the Confidential team to consult with

Confidential, St. Paul, MN

Sr. BI Developer

Responsibilities:

• Primarily utilized as a BI Developer and Data Modeler
• Cube Modeling and Development
• Physical and Dimensional Modeling
• Data Analysis
• SSIS Development
• Also utilized as a floating resource for all other positions on the BI Team

Confidential, Eagan, MN

Data Team Manager

Responsibilities:

• Managed a team of Data Architects, DBAs, Data Analysts, and Database Developers overseeing multiple projects to deliver data needs at the enterprise
• Financial
• Data Warehouse
• Rewrite of current policy administration system
• Continued as a Development DBA/Data Modeler as mentioned in Data Architect/DBA

Confidential, Eagan, MN

Data Architect/DBA

Responsibilities:

• Lead data team member for the rewrite of Confidential ’s policy administration system
• Worked with all four Agile scrum teams to ensure efficient interaction of sub-systems and to maintain a consistent definition of the data system
• Architected the logical model for Licensing (authorization) and Quoter in a 3rd normal form
• Analyzed logical models to create physical models for the two aforementioned projects as well as continuous data feeds (ETL) and Claims
• Developed and administered the physical models in a SQL 2008 R2 environment
• Administered database servers in Data Warehouse, Production, Testing, and Development environments (SQL 2005/08 R2)

Confidential, Eagan, MN

Business Systems Analyst/Lead Analyst

Responsibilities:

• Utilized as a floating resource for Business Analysis, Systems Analysis, Development, and Quality Assurance

Confidential, Laramie, WY

Internal Deployment Manager

Responsibilities:

• Multi-functional resource to ensure the company met and/or exceeded project timelines.
• Technical liaison between IT and Business Development
• Supported deployments, aided the development efforts, assisted technical support, and customized demonstrations for the sales team
• Managed databases and servers across 9 MSSQL Server Instances, C# coding, TFS Management, IIS Administration, Report Building and convention design/implementation.