Resume

Sign in

Senior Database Developer

Location:
Cloverdale, California, 95425, United States
Posted:
March 17, 2019

Contact this candidate

Resume:

KYLE CAMPBELL

Mobile: 650-***-**** E-mail: ac8tar@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/kyle-campbell-a062b22 Skype: kyle.campbell_421

Database Developer with data warehouse, database, and business intelligence experience

SUMMARY OF QUALIFICATIONS

I am a Database Developer primarily utilizing MS SQL Server and MS BI Full Stack components incorporating .NET languages VB, C# along with shell scripting and Python code.

I have worked in all phases of the database development lifecycle, from gathering requirements to testing and follow-up support while leading a small team in software project management.

My background includes analysis, design, development, customization, implementation, and testing of data marts and data warehouses from conceptual design to publication including ETL/ELT processes.

TECHNICAL SKILLS

ETL: SQL Server Integration Services (SSIS), SQL Server DTS, Pentaho, ETL, ELT

OS: Windows NT/2000/XP/Vista/7/10; HP-UX, AIX, Unix, Linux

Programming: .NET, VB.Net, Python, ASP.NET, JavaScript, C, C++, C#, SQL, T-SQL, UDF, MDX

OLAP/Reporting: MS SSAS, MS SSRS, MS Report Builder, Tableau

Tools: MS Visual Studio 2015 with SQL Server 2012-2016 (SSDT) 2005-2008 (BIDS)

Hardware: IBM PCs, IBM AIX

Software: Microsoft Office Suite

Databases: MS SQL Server 2000-2017, PostgreSQL, MySQL, Oracle, DB2, Informix, Sybase

PROFESSIONAL EXPERIENCE

Star Base Central Santa Rosa, CA

December 2014 – Present

Senior Database Developer – Owner (freelance)

Implement star/snowflake schema data marts in MS SQL Server, PostgreSQL, mySQL, etc...

Design data marts and derived cubes in SSAS from source data in various formats including RDBMS tables, Excel, XML, JSON, delimited, CSV, fixed length files, and whatever other source data is supported for consumption.

Create complex calculated measures and members in SSAS cubes.

Automate ETL processes using SSIS and Pentaho (Kettle).

Create reports in SSRS, Report Builder, and Tableau from source cubes, RDBMS tables, etc...

Office Ecology (partially remote position) Fresno, CA

January 2011 – November 2014

Data Analyst / Data Warehouse Developer

Created and updated tables, views, stored procedures, triggers, and functions for DB updates.

Customized ETL scripts in DTS and SSIS and tested ETL using Pentaho (Kettle).

Created SSAS cube(s) populated from multiple sources for report building and general browsing.

Created reports using SSRS and Report Builder.

Maintained 24/7 support management.

ALH Group San Luis Obispo, CA

April 1995 – July 2010

Lead Data Warehouse Developer

Created UNIX shell scripts and processes to extract data from various sources such as DB2, Oracle, Informix, Sybase SQL Server, and MS SQL Server.

Designed scalable, reusable, and low maintenance ETL/ELT templates.

Implemented complex transformations by creating C++ programs for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.

Created DBA user manuals and defined database schema for server-side ETL/ELT procedures.

Oversaw unit and system tests and assisted users with acceptance testing.

Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL/ELT procedures.

Provided on-call technical support for production system database/server side ETL/ELT procedures as well as client-side operations on a 24/7 basis.

Designed and created custom OLAP data marts in a star schema with custom metadata for the ETL/ELT procedures.

Designed and implemented SSAS cube(s) from the ground up including all facets of construction with simple measures, or metrics, to very complex statistical based ones and ragged or unbalanced hierarchies sourced from one or multiple dimension modeled data marts.

Designed and developed DTS/SSIS packages, stored procedures, configuration files, tables, views, and functions; implemented best practices to maintain optimal performance.

Trained and managed developers and advised other groups in the organization on SSIS development, data warehouse development, and ETL/ELT development best practices.

Conducted code walkthroughs and reviewed peer code and documentation.

Built efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.

Created system for capturing, reporting, and correcting error data.

Created Local SSRS Reports (RDLC Reports) and then displayed them using ReportViewer control in an ASP.Net Web Application using Visual Studio 2010 with C# and VB.Net

Worked with developers, DBAs, and systems support personnel in elevating and automating successful code to production.

Provided on-call support to the production system to resolve any issues.

Designed and implemented .NET ETL application to populate SQL Server database with data supplied from Intuit QuickBooks formatted with XML/XSLT QuickBooks dynamic specifications.

Created a SQL Server database and Analysis Services cubes to hold data from QuickBooks.

Created Analysis Services cubes for use with MS Office Accounting Products.

Designed and implemented simple and complex MDX to provide data based on leaf and aggregate data across multiple dimensions.

EDUCATION AND TRAINING

Bachelor of Science in Computer Science – Summa cum Laude

California Polytechnic State University – San Luis Obispo, CA



Contact this candidate