| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Data Entry Warehouse Coordinator Midwest City, OK Warehouse Manager A Team Yukon, OK Customer Service Data Entry Oklahoma City, OK Power Bi Master Data Oklahoma City, OK Accounting, data entry, auditor, business analyst, inventory Oklahoma City, OK Data Analyst/Project Management/Program Financial management Oklahoma City, OK Data Entry Unloader Norman, OK |
|
Click here or scroll down to respond to this candidate Candidate's Name
Street Address
Cell: PHONE NUMBER AVAILABLE EMAIL AVAILABLE
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
|
