Scroll To View More
Brian Shurley

Brian Shurley

Englewood, CO, United States
Member since December 16, 2015
Brian is an expert data architect and well-rounded technology professional. For the last 15 years, he's created and implemented many projects with information technologies. He would like to continue to apply his skills and experience to help companies solve their biggest and boldest problems.
Brian is now available for hire
  • SQL Server Integration Services (SSIS), 10 years
  • Transact-SQL, 10 years
  • Database Modeling, 10 years
  • SSRS, 8 years
  • SQL Server Analysis Services (SSAS), 8 years
  • Data Warehouse, 6 years
  • Mule ESB, 1 year
Englewood, CO, United States
Preferred Environment
MS SQL Server, SSIS, SSAS, C# .NET, Mule ESB
The most amazing...
...experience is looking back at all the interesting, challenging and diverse projects I've been a part of and the impact they have had!
  • Data Architect
    DHI Group Inc /
    2015 - PRESENT
    • Selected and implemented Attunity Replicate as a technology for building a data lake / persistent stage for consolidating data from heterogeneous sources and maintaining change history to feed analytic structures and future data mining.
    • Coordinated implementation with teams on three continents.
    • Was a top-tier technical troubleshooter and a resource for the support team on critical issues.
    • Led and managed the ETL pattern development and data warehousing best practices.
    • Was an effective project manager and lead.
    Technologies: Microsoft SQL Server, Oracle, AWS RedShift, Attunity Replicate
  • Integration Architect
    Chipotle Mexican Grill with Slalom Consulting
    2015 - 2015
    • Implemented MuleSoft Mule ESB and the Anypoint Platform suite of products to integrate data between source systems and Semarchy MDM.
    • Built foundations for ESB-based application integration, i.e. infrastructure, token-based security, high-availability, management and logging, message queuing and publish-subscribe (pub sub) messaging using RabbitMQ, and built patterns for future service development.
    • Built services exposing “golden” restaurant data and worked with software development teams to utilize these services.
    • Was the SOA evangelist and thought leader.
    • Our team was awarded the Slalom “Team Mogul” award for Q3 2015.
    • Was the AWS engineer pro, helped the team configure and host solutions in AWS.
    Technologies: Mule ESB, Java, AWS, RESTful Web Services, Master Data Managment
  • Data Architect
    Vail Resorts with Slalom Consulting
    2014 - 2015
    • Our client enlisted us to build a modern enterprise data warehouse focusing first on customer and transaction data, replacing the legacy data marts.
    • Built a conceptual data model of their enterprise to inform and steer the overall design.
    • Used dimensional data modeling techniques to design and build the EDW and related ETL processes.
    • Built ETL packages using SSIS.
    • Designed and trained team on DevOps best practices: branching & merging strategy, and release management.
    • Our team was awarded the Slalom “Team Mogul” award for Q1 2015.
    Technologies: Microsoft SQL Server, SSIS, C# .NET, ER/Studio Data Architect
  • Integration Architect & Data Modeler
    Xcel Energy with Slalom Consulting
    2013 - 2014
    • Our team built a based web application to process customer applications for solar incentive programs, retiring an existing application, as well as developing a data mart and reporting on solar applications, installations, electricity production and consumption.
    • Led data integration efforts and coordinated multiple internal teams, including: enterprise application integration, data warehouse, reporting, and billing.
    • Developed data migration process for existing application data from MSSQL to using Pentaho Data Integration.
    • Modeled data mart and drafted technical design of data mart ETL processes and the operational integrations between and internal billing system.
    • Assisted developers in designing near real-time event-based integrations.
    Technologies: Pentaho Data Integration,, Teradata, IBM Websphere ESB
  • BI Architect / Developer
    Level3 Communications with Slalom Consulting
    2013 - 2013
    • Designed and built a framework for measuring individual contributor performance across over thirty functional areas.
    • Architected a data mart to store the performance measurements and the scoring and target values; also built the ETL processes to populate it.
    • Designed and developed a set of scorecard reports that met the requirements across all functional areas, leveraging the abstracted data in the data mart.
    • Implemented advanced data visualization techniques which were used in reports to better understand and correlate information.
    Technologies: Microsoft SQL Server, SSRS
  • Database engineer
    Vail Resorts with Slalom Consulting
    2013 - 2013
    • Having experienced numerous issues with database stability the previous season, our client hired us to isolate and mitigate these issues and perform load testing and scalability analysis of their primary point-of-sale system which was responsible for nearly $1 billion in annual revenue.
    • Discovered numerous blocking and performance issues and implemented repairs on the database.
    • Performed extensive load testing of application, services and database before and after to validate fix.
    • Used statistical methods and regression analysis to predict database capacity and impact of addition resort acquisitions.
    • Implemented high availability using SQL Server AlwaysOn.
    • Following our project, our client had their busiest season ever and reported no issues with the stability of the database.
    Technologies: Microsoft SQL Server, AlwaysOn, Visual Studio Load Testing
  • BI Architect / Developer
    DCP Midstream with Slalom Consulting
    2012 - 2012
    • Our client wanted additional insights into their process of connecting natural gas wells to their natural gas gathering and processing systems.
    • Made additions to existing data warehouse and cube to support dashboards and built ETL processes to populate this data.
    • Developed dashboards to display key metrics around well connect projects and measure performance by geographic region.
    Technologies: Microsoft SQL Server, SSAS, SSRS
  • Data Architect
    onTargetJobs Inc. (now part of DHI Group Inc / Dice Holdings)
    2010 - 2012
    • Provided architectural direction over the continuous development on four different high-traffic websites which together has over 3 million unique visitors per month.
    • Designed and guided implementation of enterprise-wide information factory and business intelligence applications.
    • Modeled and implemented a data warehouse using Microsoft SQL Server and anchor modeling techniques.
    • Built dimensional data marts and SSAS multidimensional cubes. Developed various BI applications using SSAS Tabular databases and Power View.
    • Was a top-tier technical troubleshooter and data analyst. Solved problems of a critical and complex nature.
    • Was the company-wide thought leader: educated developers, defined best practices, and improved SCM processes.
    • Advocated for technologies to improve efficiency and performance.
    • Used various data mining and unstructured data analysis tools to generate adaptive autosuggest search terms.
    • Explored better ways of connecting employers and job seekers using predictive analytics.
    Technologies: Microsoft SQL Server, SSAS, SSIS, SSRS, C# .NET, nServiceBus
  • BI Architect
    Denver Public Health with EMC Consulting
    2010 - 2010
    • Modeled and developed a data warehouse to meet current and anticipated future needs across the entire domain of public health.
    • Implemented ETL processes, data warehouse, SSAS cube, reports and dashboards to track immunizations across the City and County of Denver and vaccine inventory levels at clinics.
    • Heavily used GIS technologies including: SQL spatial data types, ESRI ArcGIS Server/Desktop and Bing Maps to geocode addresses, assign addresses to geographic regions and display data on interactive maps.
    • Built a framework for managing Metadata and Master Data.
    Technologies: Microsoft SQL Server, SSAS, SSRS, ESRI ArcGIS
  • BI Architect
    General Motors with EMC Consulting
    2009 - 2009
    • Built warehouse and delivered dashboards showing storage capacity, utilization and performance data for GM’s numerous Petabytes of data stored on EMC storage arrays in data centers worldwide.
    • Heavily involved in the requirements/discovery process and developed a deep understanding of storage engineering.
    • Designed and implemented ETL processes using T-SQL and SSIS, data warehouse, SSAS cubes, and Performance Point dashboards.
    • Worked with multiple GM storage/IT vendors to understand GM’s storage infrastructure and coordinate deployment of BI solution.
    Technologies: Microsoft SQL Server, SSIS, SSAS, Performance Point
  • Database Architect and Developer
    National CineMedia
    2008 - 2009
    • Member of an Agile/Scrum development team building an enterprise sales management .NET web application and part of the corporate systems DBA group.
    • Modeled data from user stories. Researched business and worked with users to write software requirements. Extensively used ERStudio modeling tool for design, modeling, and documentation.
    • Taught in-house workshops and was go-to guy for various SQL technologies for in-house developers, DBA team, and IT managers.
    • Developed an operational data store for near real-time reporting on inventory availability and utilization using SQL Server 2008, and asynchronous replication using SQL Service Broker.
    • Developed complex finance and inventory reports using Reporting Services.
    • Built Analysis Services cubes on inventory data.
    • Used Microsoft Office SharePoint Server, Performance Point, and ProClarity to develop prototype executive dashboards from sales and finance KPI data.
    • Managed database migrations and deployments across environments. Revolutionized database development, versioning, and deployment processes by migrating to the Visual Studio Team System 2008 Database Edition.
    • Helped manage continuous integration and integrated database projects into TFS team build.
    • Consulted on DB performance across the enterprise; profiled and analyzed internal databases and then wrote recommendations.
    Technologies: Microsoft SQL Server, SSIS, C# .NET
  • BI Architect / IT Manager
    Axiom Solutions
    2006 - 2008
    • Designed and developed tools to analyze data from client’s ERP systems to calculate research and development tax credits using MS SQL Server 2005 and Analysis Services.
    • Built ETL processes and SSAS cubes from ERP systems of numerous defense contractors and engineering firms.
    • Began development of knowledge discovery/data mining architecture using a variety of tools.
    • Researched requirements and customized platform to automate company workflows and provide cash flow predictions.
    • Designed, implemented, and managed information infrastructure from the ground up; incorporating the best of diverse technologies including: Linux, VMWare, Windows Server, and many others.
    • Responsible for IT policy creation, including: information best practices, security, and data management/retention. Hired and managed a full-time Systems Administrator.
    Technologies: Microsoft SQL Server, SSAS,
  • Owner / Founder
    Brilliant Technology Management
    2004 - 2007
    • Designed, implemented, and maintained IT infrastructure for over 20 medical practices.
    • Developed ETL processes, middleware and custom reports on billing and health record data from EHR systems.
    • Found cost-sensitive, effective solutions for clients using Microsoft and open-source software including: Windows 2003 Server, Linux, MySQL, and VMware.
    • Implemented and managed Microsoft SQL and AIX-based electronic health record systems from various vendors.
    • Helped offices design efficient workflows and trained doctors, nurses, and staff to best use their EHR systems.
    • Provided solutions for complex networking needs. Implemented multi-site, redundant IPSEC VPNs using open source BSD UNIX based software. Provided mobile VPNs with PPTP, IPSEC and OpenVPN. Optimized and secured networks with QoS and VLANs.
    • Installed and managed Asterisk-based VOIP systems as well as Avaya PBX systems.
    Technologies: MIcrosoft SQL Server, Windows Server, VMWare, EMR
  • Team Manager, Destination Imagination (Other amazing things)

    Spent two years co-managing a team of 1st and 3rd graders in creativity, problem solving, and cooperation. Appraised (judged) one of the challenges at a regional tournament.

  • Microsoft Certified Solution Expert (MCSE) - Business Intelligence (Other amazing things)

    The globally recognized standard for IT professionals

    Prove that you have the skills and techniques needed to design, build, and deploy SQL Server business intelligence solutions that deliver more data to more people across the organization.

  • Languages
    SQL, XML, Transact-SQL, XPath, C#, Java
  • Tools
    SSAS, SSRS, TFS, Enterprise Architect, Visual Studio, Git, Pentaho Data Integration (Kettle), GIS, Eclipse IDE
  • Paradigms
    Entity-relationship Diagrams, Database Design, Scrum, Agile Software Development, Service-oriented Architecture (SOA), REST, Load Testing, Test-driven Development (TDD)
  • Storage
    Database Lifecycle Management (DLM), SQL Server 2014, Attunity Replicate, SQL Server Integration Services (SSIS), Database Modeling, Data Integration, DBA, SQL Server 2012, SQL Server Analysis Services (SSAS), ER/Studio Data Architecture, Microsoft SQL Server, SQL Server Reporting Services (SSRS), Master Data Management (MDM), Azure SQL Databases, JSON, AWS Redshift, Semarchy MDM, PostgreSQL, MySQL, PL/SQL Developer, Oracle PL/SQL
  • Misc
    Data Warehouse, MCSE | Business Intelligence, Data Modeling, Data Visualization, Multidimensional Expressions (MDX), Business Intelligence (BI), Enterprise Integration Patterns (EIP), Enterprise Integration, Team Mentoring, RESTful APIs, SOAP, Performance Optimization, Load Balancing, OData
  • Frameworks
    Entity 6, Windows PowerShell, NHibernate, OAuth2
  • Platforms
    Mule ESB, Salesforce, Azure, ArcGIS, Amazon Web Services (AWS)
I really like this profile
Share it with others