B rian L Custer

206-***-****

acgmu5@r.postjobfree.com

SKILLS & PROGRAMM I NG AND SCR IP T I NG LANGUAGES

• Vb.Net, C#, T-SQL, Visual Basic for Applications (VBA), PL \SQL, JavaScript,

A BILIT IES

JQuery, ANSI SQL, DAX, MDX, M

DEVELOPME N T TOOLS

• Visual Studio (2005-2013), Business Intelligence Studio(2005-2008R2), SQL Server

Data Tools (SSDT), Microsoft Office Development (VBA) Integrated Development

Environment (IDE), Visual Studio Tools for the Microsoft Office System (VSTO),

M icrosoft InfoPath, SharePoint Designer (2010-2013), Microsoft Access (2000-2013)

MARKUP LANGUAGES

• HTML 4/5, oData, ATOM 1.0/2.0, HTML 5, XHTML, XML, XSD, XSLT, XAML,

XOML, SOML and JSON

RELAT IONAL DATABASE SYSTEMS

• Microsoft SQL Server (6.5-2014), Oracle (9i-11i), DB2 (AS400 Series Embedded),

Sybase Adaptive Enterprise Server/Replication Server, GreenPlum, PostgresSQL and

M ySQL (Mac OSx, Windows, Unix)

M ULT I D I ME NS IONAL (OLAP) DATABASE SYSTEMS

• Microsoft SQL Server Analysis Server (SSAS)(2000-2014)

• MicroStrategy Intelligence Server (9.2) and Intelligent Cubes

• Microsoft Excel Offline Cubes

• SQL Server 2012-2014 Tabular Data Model

DATA I N T EGRAT IO N

• Microsoft SQL Server In tegration Services (SSIS) (2008-2014)

• WCF Data Services

• ASP.net Web API

REPORT I NG AND DATA V ISUAL I ZAT IO N

• Microsoft SQL Server Reporting Services (SSRS)(2005-2014)

• Microsoft Excel Pivot Tables/Charts, Power View, Power Pivot, Power Query, Power BI

• MicroStrategy 9.2

• Microsoft SharePoint Business Intelligence Center

• PerformancePoint (2007 and PerformancePoint Services)

• ASP.net Custom Dashboards/Scorecards

OPERAT I NG SYSTEMS, BUS I NESS SOFTWARE AND COLLABORAT IO N

• Operating Systems: Microsoft Windows Server (2003-2012), Windows 7

P rofessional/Enterprise – Windows 8/8.1 Professional and Enterprise, Mac OSx

L ion/Mountain Lion, Apple iOS 4-7

• Productivity: Microsoft Office 2010-2013 Professional (Word, Excel, PowerPoint, Visio,

M icrosoft Office 365, Adobe Acrobat, Microsoft InfoPath, Microsoft SharePoint Server

1 Page

B rian L Custer

206-***-****

acgmu5@r.postjobfree.com

CLOUD

• Azure Web Sites, Virtual Machines, Mobile Services, Cloud Services, SQL Databases,

Storage, HDInsight, ML Studio

• Office 365

• OneDrive, OneDrive For Business, Box.net, DropBox and SalesForce.com

2 Page

B rian L Custer

206-***-****

acgmu5@r.postjobfree.com

3 Page

B rian L Custer

206-***-****

acgmu5@r.postjobfree.com

EXPERIENCE SEN IOR CONSULTANT, AVANADE

J U L 2013 – CURRE N T

• Lead contributor for database unit testing, database optimization and performance

testing/tuning for a new version of an existing desktop t ransformation application

• Lead Developer on an End-to-End BI solution including a data mart, OLAP cube,

M icrosoft Excel reporting, Power Pivot and Power BI

TEC H N ICAL CONSULTANT, LG CONSULT I NG, I NC .

APR 2013 – J ULY 2013

• Developed a data model using Excel 2013 PowerPivot and Excel tables linked to

several SharePoint 2007 custom lists for a Fortune 50 software company. The data

model was used to build reports that provided insight into a change request process

t hat enabled the client to become more proactive with customer requests.

S EN IOR APPL ICAT IONS DEV E LOPER, M OSS ADAMS, L LC

JAN 2013 – MAR 2013

• Assisted with new feature development and revisions of an ASP.net MVC web

application used by the company to assist their clients in completing certain tax

forms. The new feature and revisions increased the overall usability of the

application thus enhancing the user experience.

SOFTWARE ENG I NEE R I I I, CAMB IA H EALT H SOLUT IO NS, I NC.

JAN 2012-JAN 2013

• Automated a formerly manual process for loading SQL 2005 OLAP cubes with

monthly refreshes from the Enterprise Data Warehouse using Microsoft SSIS and

custom data sources. Automation allowed business users to refresh the cubes and

deploy them to their respective query servers themselves

SEN IOR SOFTWARE ENG I N E ER, SELLEN CONSTRUCT IO N CO., I NC.

MAR 2000 – JAN 2012

• Won numerous awards for excellence, dedication and most improved employee

• Responsible for all phases of the software development lifecycle including

requirements elicitation and definition, domain modeling, specifications, test-driven

development, testing, deployment and support

4 Page

B rian L Custer

206-***-****

acgmu5@r.postjobfree.com

• Developed and administered application databases and administered SQL Server

back ends for SharePoint. Trained a new employee to take over the administration of

t he company’s new accounting system built using Microsoft .Net and SQL Server

• Developed a business intelligence application for the company’s estimating

department that included complex ETL from a DB2 data source (accounting system)

and writable dimensions that could be modified by estimators. The system allowed

t ransformation of job cost records into detailed historical cost information for specific

scopes of work and increased the accuracy of estimates

• Re-designed and developed a VB 6 application using Microsoft .Net and Windows

Forms that allowed project managers and team members to collaborate, manage and

d istribute important project documentation including drawings, Request for

I nformation and Submittals to subcontractors, suppliers and architects

• Re-designed and developed a VB 6 application used by the warehouse to manage

rental equipment and supplies including inventory, project billing and maintenance

• Developed a project manager time t racking system that allowed the company to

capture an estimated 2,000,000 per year in lost revenue

SEN IOR SOFTWARE ENG I N E ER, SOLUT IO NS I Q

FEB 1999 – MAR 2000

• Consulted with one of Microsoft’s call centers on the design of a data mart and

business intelligence application to monitor call center performance

• Re-designed two line of business desktop applications for a client (Sellen

Construction) which corrected problems with revenue reporting and billing which

saved the company hundreds of thousands of dollars by re-capturing the correct

amount of revenue generated by the division

SOFTWARE ENG I NEE R, BEST CONSULT I NG

J UN 1997 – F EB 1999

• Developed complicated reporting applications using Microsoft Access which sourced

data from Oracle, Btrieve and SQL Server based systems along with VBA automation

( to load and perform ETL), job scheduling and report delivery via email to managers

and executives on a daily and weekly basis

• Developed a data mart and reporting solution for a fortune 500 food services company

i ncluding custom ETL using Microsoft Access and VBA which loaded and cleaned

data from multiple DB2 OLTP systems located across the country which was used by

sales executives to analyze and monitor sales performance by region, sales territory,

5 Page

B rian L Custer

206-***-****

acgmu5@r.postjobfree.com

sales person and compare real time data with forecasts

• Developed a Microsoft Access database and application that was used to measure the

success of marketing campaigns of a large t ruck manufacturing firm

E NV I RO N ME NTAL CHE M IST, DA MES & MOORE

J UN 1994 – APR 1997

• Responsible for sampling and analyzing groundwater, soil and air samples for clients

i ncluding the federal and state government environmental protection agencies

• Provided advanced chemical and elemental analysis using gas chromatography,

spectrometry, field assays and other monitoring equipment

• Worked with large data sets compiled from sampling and analysis data using Oracle

and Microsoft Access and created visualizations of contamination using Microsoft

Excel, Microsoft Access and custom VBA solutions

• Managed numerous site cleanups throughout western Washington, Oregon and

California and contributed to the successful cleanup and re-determination of the

environmental status of the sites.

L EAD PROCESS CHE M IST, P H I L L I PS E NV I RO N M E NTAL

J UN 1992 – APR 1994

• Developed novel chemical processes for t reating hazardous materials and waste water

i ncluding a process to extract precious metals from electroplating sludge and another

one that enabled the company to de-emulsify waste water contaminated with oil and

other petrochemicals. Both processes enabled the company to increase its market

share and gross revenue by 10-15%.

A NALYT ICAL CHE M IST, CHE M ICAL WASTE MANAGE ME NT, I NC.

AUG 1991 – J U N 1992

• Identified, characterized, packaged, labeled and shipped hazardous materials

confiscated from clandestine drug laboratories seized by the Drug Enforcement

Agency (DEA)

P ROTE I N B IOCH E M IST, ZY MOGE NE T ICS, I NC .

MAR 1989 – AUG 1991

• Assisted with research into developing wound healing agents using recombinant

p roteins including Factor XI I I

R AD IO LOG ICAL CONTROL ENG I NE ER, BRE M ERTON NAVAL SH I PYARD

AUG 1987 – FEB 1989

6 Page

B rian L Custer

206-***-****

acgmu5@r.postjobfree.com

• Monitored and controlled the amount of radiation exposure naval and civilian

personnel received while working on re-fueling and overhaul tasks

7 Page

B rian L Custer

206-***-****

acgmu5@r.postjobfree.com

texas a&m university - Kingsville, tx - 1986

EDUCATION

• Graduated with a GPA of 3.1 while working full time for my father’s oil field service

company

• Worked as a research assistant in Molecular Biology in my last year of undergraduate

study assisting two professors who were researching the ability to create novel

compounds for destroying cancer cells. One project involved collecting rattlesnake

venom, extracting several hemorrhagic proteins and then conjugating the proteins

onto immunological agents

u niversity of washington extension - seattle, wa - 2004 and 2010

• Obtained a certificate in Microsoft .Net Framework Programming including

developing ASP.net and Windows Forms applications

• Obtained a certificate of completion in the first course in a series of three on

developing data warehouses and data marts using Microsoft SQL Server 2008 R2

Certifications

• 70-461 Querying Microsoft SQL Server 2012 (February 2014)

8 Page

Contact this candidate