OBJECTIVE:

Primary Object is to get a FTE role that challenges my intellect and uses my skills and experience as a SQL/BI Developer. My belief is that with my skills and experience I would be an excellent addition to any organization.

SUMMARY:

• Over 20 years’ experience in working with SQL Server as a database developer for both transactional (OLTP) and Business Intelligence systems (OLAP) for both startups and Fortune 500 companies including Starbucks, VISA & Confidential along with United States Postal System. 10+ years’ experience with SQL Server BI toolkit (SSIS, SSAS, SSRS). Exceptional skills in modeling for both OLTP and OLAP systems. There is no role database development that I haven’t done. I have a passion for creating professional solutions using the KISS principle, well documented code and easy to follow coding.
• Excellent communications skills, both verbal and oral, in explaining complex ideas, solutions and problems. Along with having a creative mind and the ability to think of “out of the box” ideas for various situations and providing solutions to complex problems. In my career I have worked with all levels within an organization to help with creating solutions to various problems presented.
• As a contractor can work in any kind of environment, highly structured and loosely organized. One Confidential thrives on challenges and delivering quality solutions. Has a passion for doing database development and learning new technologies. An excellent developer Confidential can work on teams or by himself. Is a self - directed developer and it very good at multitasking or priorities changing.

TECHNICAL SKILLS:

• MS SQL Server (Versions 4.2 to 2014)
• T-SQL
• SSRS (SQL Reporting Services)
• SSAS (Analysis Server)
• SSIS (SQL Server Integration Services)
• Database Modeling (OLTP & OLAP/Star Schema)
• Power BI (Excel)
• Power BI Desktop.
• Power Shell
• Azure
• SQL Azure
• C# (Excel & SSIS) *

AREAS OF EXPERTISE:

• Data Analysis/Analyst
• Scorecard/Dashboard Developer
• ETL Developer
• Mentoring
• Project Manager
• Data Modeler
• QA
• OLAP/OLTP
• DBA
• IT Manager
• Database Developer

PROFESSIONAL EXPERIENCE:

Confidential

Senior Database Engineer

Responsibilities:

• My mission was to analyze and possible upgrade an SSIS system that had major performance issues and to determine if they had the in-house talent for this system. My analysis of the current systems is that the design was inadequate for their needs. My conclusion was that the best solution was to start from scratch as it was fundamentally flawed in its design. I also reached a conclusion that there in house developers were lacking in the skills needed to maintain a newly developed ETL position.

Confidential

Senior Database Developer/System Engineer.

Responsibilities:

• The ISRM team was implanting a new hardware compliance system and they had a need for a SQL Server go to guy to analyze and fix any issues and problems. This new system uses a third party software tool which was wrapped into a batch system that will verify that hardware is in compliance with MS standards and issue notice and reports to management.

Confidential, Montlake Terrace WA

Senior BI/Database Reporting Developer

Responsibilities:

• As analyst, architect, designer & developer of a reporting system that tracks additions & modifications to all media for a health insurance company. Initial system was a reporting system off of a production system. Essentially performed two major tasks, data analysis of old system to set up a migration plan to move data to new system and create a OLAP/Star Schema database and SSAS cubes, from which SSRS reports use data and Excel Pivot table. Monitored execution of packages.

Confidential

Database Engineer

Responsibilities:

• Responsible for overall design & development of a BI data warehouse for the MS Internal Audit team. Which includes identifying various data sources, replacing non-automated ETL packages with automated ETL packages using SSIS, design & development of an OLAP data model, creating cubes & measures as needed and creating SSRS as needed. Team previously was in a reactive mode on customer requests and the goal is to set up a system that is more of a proactive mode.

Confidential

SQL Server Consultant

Responsibilities:

• They had a need of a reporting system to analyze the results of a study on diabetes. I was tasked with coming up with a solution for their needs that a short development cycle. Best solution based up development parameters was a OLAP/Star Schema database and a ETL system to pull new data in to the database and a pivot table in Excel in which to analyze that data and to make it available for other systems to use.

Confidential, Bellevue WA

Senior Database Developer

Responsibilities:

• Develop SSRS reports and SSIS packages for an internal system designed for a self-insured health care company.

Confidential, Montlake Terrace WA

Senior BI/Database Reporting Developer

Responsibilities:

• As analyst, architect, designer & developer of a reporting system that tracks additions & modifications to all media for a health insurance company. Initial system was a reporting system off of a production system. Essentially performed two major tasks, data analysis of old system to set up a migration plan to move data to new system and create a star schema database and SSAS cubes, from which SSRS reports use data and Excel Pivot table. Monitored execution of packages.

Confidential, Redmond WA

Senior BI/Database Developer

Responsibilities:

• In my role as Senior BI/Database Engineer I was responsible for the data analysis, architecture, design and development of a BI reporting system. System was designed to help MS Live Help team monitor the MSDN Forums and Solution Centers and manage off-shore vendors in assessing the work of the vendors, so they could be paid. System consisted of an OLAP/start schema database, SSAS cubes, Excel Pivot tables and SSRS reports, which used SSRS subscriptions as a means to move data to the various vendors.

Confidential, Redmond WA

Senior Database Developer

Responsibilities:

• As analyst, data modeler, architect, designer and developer created multiple BI reporting systems that was used as a means of analyzing customer support calls for the Windows Live division that were handled by Confidential ’s external support organizations. System would allow Confidential to monitor Service Licensing Agreements for customers to determine if SLA was successful or failed. As a member of the support team also work on other systems within the group in my role as Senior Database Engineer.

Confidential

Senior ETL Developer

Responsibilities:

• As data analyst, designer, developer, QA & tester I was responsible for the development of a reporting system that allowed analysis to be done on the viewers Confidential used ABC programs that were offered on their ABC web site. This was done using SQL Server BI tools - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) & SQL Server Analysis Server (SSAS), SQL jobs & Excel Pivot tables for presentation of data. I was also responsible for the development of a reporting system for the Disney games division that mapped demographic metrics against sales as a data analyst, designer, developer, QA & tester using the SQL Server, SSIS, SSRS, SSAS, SQL jobs & Excel pivot tables.

Confidential, Bellevue WA

Senior Database Developer

Responsibilities:

• Responsible for ongoing support for Excel VBA applications and enhancing ETL systems related to those Excel VBA applications.

Confidential, Seattle WA

Senior Database Developer

Responsibilities:

• As Senior Database Engineer, whose roles where that of a mentor, data analyst, architect, designer & developer, I was responsible for 2 different BI reporting systems for different departments of Confidential marketing that was used as a basis how effective the staff was. I was responsible for their migration to a BI reporting where in the past they did reporting off of a relational database, along with a knowledge transfer of how to create BI reporting systems and using VSTF as a source library and a way of tracking issues for clients. Acted as DBA when needed and setup an internal development infrastructure.

Confidential, Redmond WA

BI Developer

Responsibilities:

• Responsible for the creation of a BI reporting system that track downloads of various programs and articles by subscription members of the MSDN & Technet. This allowed program managers to analyze what was being downloaded and the demographics of the members. As the data analyst, architect, designer, developer, QA, tester and DBA I used the MS SQL Server BI tool set (SSAS, SSRS, SSAS) & Excel pivot tables to create this system.

Confidential, Bellevue WA

Lead Developer/Project Lead

Responsibilities:

• I was responsible for the creation of a BI reporting system that tracked headcounts and expenses of the Office division of Confidential . My role in the creation of this system was that of a data analyst, architect, designer, developer & tester. I was also the project manager as I worked with the customer in setting the goals of the projects and worked with customer. The SQL Server BI tool kit was used to create this system. It consisted of a series of SSIS packages, an OLAP database, cubes, stored procedures & functions, jobs & Excel pivot tables.

Confidential, Redmond, WA

Senior Database Developer

Responsibilities:

• Confidential has various activation systems for all of it products but was lacking in a system to consolidate the data from each of this activation systems. My role was multifaceted and I was to create a BI reporting system using the SQL Server BI toolkit that would consolidate data from these activation systems. In the data analyst role I was to examine the data from the activation systems and determine what data was needed for the reporting and what wasn’t. My other roles were as a designer, developer, tester and QA. This system consisted of a series of SSIS packages for each of the activation systems, along with the data modeling of an OLAP database. Multiple cubes were created using SSAS and a series of reports using SSRS and Excel pivot tables.

Confidential, Sammamish, WA

Senior Database Developer

Responsibilities:

• As a member of a team I was responsible for the creation of SSAS cubes for a system that performed cost allocation for the Product Support Services team. I was also responsible for the creation of a data model that was used to as a basis for the OLAP/Star Schema database and created the DDL scripts that were used to create the database. Responsible for the performance and tuning of the various stored procedures & T-SQL queries that were used by SSIS packages. Another aspect of my roles was to create reports and dashboards using SSRS.

Confidential, Kirkland, WA

Senior Database Developer

Responsibilities:

• As a member of a development team that was migrating a reporting system that using a production system as a source for the reporting to a BI reporting system. One of my responsibilities was to migrate the SSRS reports and dashboards to the new SSAS cubes, part of the doing that was to create stored procedures and/or T-SQL queries as the source of each of the reports. Another aspect of my role was to create an ETL system using SQL jobs and stored procedures to move data to the OLAP cube with the goal of having a 5 minutes latency of the data.

Confidential, Seattle WA

Senior Database Developer

Responsibilities:

• I was responsible for development of a reporting system for analysis of security aspects of various hardware components, as they were a VISA processor. My role was that of a data analyst, designer, developer & QA for the creation of this new reporting system. The system consisted of various SSIS packages, an OLAP/Star Schema database, SSAS cubes, SSRS reports and Excel pivot tables. VSTF was used as a source library and as a way of tracking the development of the system & reporting of issues that arose. Set up maintenance places, stored procedures, functions, creation of database objects, jobs as needed. The SSIS packages were created using a template and created dashboards and transactional reports.

Confidential, Redmond WA

Database Developer

Responsibilities:

• As an interim replacement for a team member my role was both as a DBA & Database Developer I was responsible for the Servers for an internal intranet web site. Created replication systems, both snapshot & transactional, performed monitoring as needed, solved problems as they occurred in my role as DBA. In my role as Database Developer created, modified and did performance testing on various database objects in system, which includes DDL scripts for creating objects, stored procedures & functions, along with performance/query tuning. I set up maintenance plans as needed.

Confidential, Seattle WA

Senior Database/Information Architect & Developer

Responsibilities:

• Responsible for all phases of an ETL system, using DTS, that would move orders from the company website to the Order Processing system, along with notifying customers the status of their order by email. Also responsible for the developing of a BI Reporting system using data from the orders placed and making additions or changes in any SQL objects. Part of my role involved doing DBA work, such as performance query analysis, troubleshooting, log shipping and replication.