Stuart A. Morrison

**** ******* ***, ******, **, 73012

Cell: 405-***-**** acxjco@r.postjobfree.com

Business Intelligence Professional

Talented and disciplined Business Intelligence and Data Warehouse Professional with a unique blend of

technical, business analysis and team leadership skills. Successful development of full lifecycle Business

Intelligence (BI), Data Warehouse and Geographic Information Systems (GIS) environments in support of

business objectives and as a technical contributor. Skilled at managing product development through the

entire life cycle from requirements to support and managing relationships with customers and service teams.

Continually seeking business improvement through innovative technology and integration.

Business Intelligence - Data Warehousing Microsoft Azure Cloud - Geographic Information Systems Business

Analysis - Team Leadership Software Development Life Cycle- Project Management

PROFESSIONAL EXPERIENCE

SANDRIDGE ENERGY, Oklahoma City, OK (Mar 2011 - Present)

Oil and Gas Production and Exploration

Applications Lead Data Delivery (Data Warehouse/Business Intelligence/GIS/Geoscience)

Led the Data Delivery team in establishing, managing and growing services for Enterprise Data Warehouse, Business Intelligence

and GIS, as a hands-on technical leader in a flat organizational structure. Established self-service reporting, querying and data

management environment for power users and business customers, including a Report User Group and collaborative Report Center.

Adopted and installed TIBCO Spotfire at SandRidge Energy, training users in Spotfire and establishing an analytics culture. Led the

Data Governance initiative to meet Audit compliance needs in a self-service environment including security, monitoring and

documentation. Built a Spotfire WebPlayer javascript mashup for the Operations Dashboard project. Participated in the upgrade to

SQL Always On for the Data Warehouse servers. Led the initiative to stream Well telemetry to Microsoft Azure PaaS for machine

learning projects.

Key successes

Architect dimensional models for Production and Finance

Implemented Self Service culture

Established Data Governance initiative

Doubled the size of the Data Delivery team

Migrated to SQL Always On

Proof of concept for Azure telemetry

COLDWATER CREEK, Sandpoint, ID (2003 - 2010)

Womens Apparel Specialty Retailer Multi Channel $1B revenue

Geographic Information Systems (GIS) Manager - Business Intelligence (Sept 2010Dec 2010)

Establish the technical direction of GIS, focusing on core deliverables with the highest business value. Upgraded legacy ETL

processing and developed a dimensional data model for fully integrating geographic data analysis into the Enterprise data warehouse.

Performed analysis of psychographic clusters to define regional cluster ratings using Tableau software.

Key successes

Improved site location decisions with better estimates of store cannibalization through new sales transfer methodology

Reduced support hours by removing dependence on external systems for processing GIS data, consolidating all processes into

SQL ETL

Increased usability of geographic data through design of a geographic dimensional data model

Data Warehouse Manager - Business Intelligence (Apr 2008Sept 2010)

Led a strong data warehouse team responsible for Enterprise Data Warehouse and SAP/BW integrity and on time delivery of data

according to established service levels. Managed a 30Tb Microsoft SQL Server Enterprise Data Warehouse and SAP/BW instance

balancing resources and priorities between executive approved projects, quick hit projects and 24/7 on-call support. Established

architecture and standards for Operation Data Store and Dimensional Modeling tiers in the Enterprise Data Warehouse, and executed

development for these standards. Performed two major source system migrations to SAP systems and integration with SAP/ERP and

SAP/BW, and led the development of Dimensional Data Models for information delivery, and migration of the data warehouse from

SQL2000 to SQL2008. Managed customer relationships and data needs for Business Intelligence, Direct Marketing, Inventory

Planning and Finance. Frequently performed roles of Business Analyst and Project Manager on internal projects, and acted as Scrum

Master through 1st half of Finance Data Model agile (Rally) project, extracting SAP GL/AP/MM data through BW OpenHub into

SQL Server. Managed the implementation of IT Service Management for the data warehouse, and coordinated data management

with all stakeholders in the matrix organization. Completed 2 year EMBA curriculum in 2009.

Key successes

Implemented data warehouse Architecture and Standards for ODS and Dimensional Modeling layers to improve throughput and

increase consistency of Data Warehouse projects

Maximized data availability through ERP cutover with uninterrupted data flow on SAP projects: SAP HCM/FI (2007), SAP

MM (2009)

Increased productive development time by reducing support overhead through tracing data delay problems to the source and

correcting data delivery in conjunction with IT service teams

Improved stakeholder data confidence through implementation of in-house QA checkpoint system for data integrity and quality

assurance in job scheduling and control

Reduced future storage costs by compressing all of the data warehouse 50% using SQL2008, as part of the multi-server Data

Warehouse hardware replacement and database upgrade

Business Intelligence Manager Finance & Operations / Inventory Planning (Mar 2007 - Mar 2008 / Aug 2006 Feb 2007)

Led business intelligence analysts and data warehouse engineers, prioritizing functional project and support needs for SQL Server

Reporting Services (SSRS) and SQL Server 2005. Led the architecture and development of HR and Finance data models during SAP

conversion. Established analytical and reporting architecture for Finance and Operations; Finance in support of loss prevention and

statutory reporting, Call Center Operations in support of call routing and revenue analysis, Distribution Center Operations in support

of cost per unit analysis and optimization of activities. Participated in research and development of executive dashboard designs as

prescribed by Stephen Fews information visualization techniques. Liaised with functional department heads to establish priorities

for effective delivery of Business Intelligence projects and support, and provided data collection and analysis for their 5 year strategic

planning presentations. Coached and mentored analysts and contributed in authoring SSRS reports and providing analysis in T-SQL.

Supported the Financial Planning and Analysis department in consuming data, scheduling updates and troubleshooting data integrity

from the data warehouse into Forecasting systems, automating Cognos with SQL jobs to refresh data nightly. Adapted to a changing

business intelligence organization by managing multiple functional areas over a short space of time.

Key successes

Compiled inventory and sales analysis from the data warehouse for VP Inventory Planning in preparation of 5 year strategic

planning presentations

Increased productive hours for the financial reporting department by streamlining statutory report delivery from multiple

disparate sources to a single source in Business Intelligence

Improved frequency and depth of retail customer fraud detection by co-authoring and automating loss prevention reporting

framework for Finance

Senior GIS Analyst / Developer (Sep 2003 July 2006)

Architect, design and develop the Geographic analysis environment for Coldwater Creek by incorporating analytical tools, reporting

systems, and creating a new Geographic Data Warehouse, integrating into the Enterprise Data Warehouse. Provide GIS analysis,

reporting and support using the geographic analysis and data warehouse environment. Analyzed and presented site location and

neighborhood information for Marketing and Real Estate, maintaining a relationship with the Real Estate dealmakers. Research and

development of spatial analysis techniques, data gathering and ETL to create a capable geographic data warehouse; viz trade areas,

market analysis, competitor data, sales grid interpolation, symbology/fonts, and cluster segmentation. Supplied geo-demographic

information to strategic and board meetings, investor relations, and office of the Chief Executive Officer.

Key successes

Improved site location analysis for Real Estate Committee presentation, providing a report as the single source of truth for

geodemographic information, underpinned by Coldwater Creeks first integrated geographic Data Warehouse

Reduced labor hours by automating map creation for Real Estate Committee meetings

Maximized marketing contribution using psychographic cluster groups to increase market penetration for store openings and

rental list acquisition

Facilitated the communication of the impact of Hurricane Katrina on organizational performance, through research and

development of geographic sales trend analysis

PBI RESEARCH SYSTEMS INC. PBI Research Systems Inc, Marietta, GA (Apr 2003Aug 2003)

MapInfo Consultant

Reduced labor hours for map creation though automated production of territory map books for all LOreal divisions, using MapInfo

Professional, MapBasic and VBA programming in MS Word and MS Powerpoint. GIS consultant to LOreal Professional Products

Divisions Manhattan, NY. Managed distribution and sales boundaries in MapInfo Professional.

SPATIAL TECHNOLOGIES PTY LTD, Johannesburg, South Africa (1997 - 2003)

MapInfo Distributor for Southern Africa www.spatial.co.za

Software Development Manager / Enterprise Support Manager (Aug 2000Feb 2003)

Ensured timely delivery of software components for an in-house product Xtreme2Go by managing day to day development tasks

and milestones. Maintained a high billable ratio of work for 6 development employees and 2 support staff. Integrate web based GIS

software into enterprise systems as a contributor, installing web server and customer software, writing JavaScript to customize the

customer user interface, setting up configuration databases in SQL, and troubleshooting database connectivity in MSSQL/Oracle.

Implemented Xtreme2Go Web into 6 new key client sites for Mortgage/Banking, Wireless Telecom and Outdoor Advertising.

Managed and transferred these skills to technical support engineers ensuring high quality installation, configuration and support of

the organizations key Enterprise software. Provide leadership through the entire product life cycle; initial client contact, installation

and maintenance. Provided product management to new enterprise XML Web Services platform MI2Go, based on MapInfo

MapXtreme Java (Win/Linux)

Key successes

Increased profitability of Spatial Technologies by maintaining a high billable ratio of work and by transferring skills to technical

support engineers

MapInfo Trainer / Pre-Sales Engineer (May 1997Aug 2000)

Developed MapInfo Professional and MapBasic training curricula from the ground up and delivered monthly training. Acted as

Technical lead in MapInfo Desktop and Enterprise sales supporting Account Managers and providing Technical support and

consulting. Achieved Certified MapInfo Professional certificate.

EDUCATION

UNIVERSITY OF IDAHO, Sandpoint Campus (2007 2009)

Executive MBA (2 year curriculum)

UNIVERSITY OF NATAL, Pietermaritzburg, South Africa (1993-1996)

Bachelor of Science - Computer Science Major / Zoology Major (1999-2001)

Training and Certifications

Microsoft Data Science 4-day Oil and Gas Hackfest October 2016

SandRidge Energy Leadership Academy Fall 2014

Spotfire Introduction 2-day TIBCO 2012

PerformancePoint Designing and Implementing Scorecards and Dashboards #50465 3-day OaktreeIT 2011

Introduction to SAP/BW Knowledge Transfer (2008)

Information Dashboard Design / Show Me the Numbers 2-day Stephen Few (2006)

Certification Managing by Project Simulation Davis & Dean (2001)

MapInfo Technical Accreditation - Product Specialist MapInfo Corporation Inc (1999)

Affiliations

Professional Petroleum Data Management Association - Oklahoma City Leadership Team - 2015/2016

OKC SQL User Group - Member

TECHNICAL SKILLS

Microsoft SQL Server 2016 Reporting Services

Microsoft SQL Server 2014 - Database Development, SSIS, Database Administration, Always-On, Dimensional

Modeling, Analysis Services

Microsoft PowerBI Development and Administration (2 years)

Microsoft Azure Data Management and Administration (1 year)

TIBCO Spotfire Professional and Server Development and Administration (5 years)

Sharepoint Site Content Configuration (4 years)

Spatial analysis techniques and spatial data management

GIS Software: MapInfo (10 years) and ArcGIS

Database: Microsoft SQL Server (16 years), Oracle

Development: T-SQL, Powershell, Javascript, IronPython, R, HTML, XML, .NET, VBScript, VBA

Contact this candidate