Business Intelligence Architect
Resume:
B rian L Custer
***********@**.***
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
***********@**.***
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
***********@**.***
3 Page
B rian L Custer
***********@**.***
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
***********@**.***
• 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
***********@**.***
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
***********@**.***
• 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
***********@**.***
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