Gordon Scarlett
H: 303.955.6365
M: 720.256.1303
EXPERIENCE
Janus Capital Group Denver CO 10/2015
- Present
Data Architect/Strategist
·
Developed and
implemented an analytics roadmap as well as a strategy to align IT's Data
Integration and Warehousing team with the business' Business Intelligence Team
so as to enable the ability to address more sophisticated and perplexing
challenges.
·
Apply statistical
and machine learning methodologies to persistent business challenges like
advisor propensity to increase/decrease assets, attrition analysis, asset build
analysis, actionable dynamic segmentation and profiling of advisors for more
productive/profitable targeting by our external sales team.
·
Developed a
segmentation model utilizing R that identified advisors with high propensities
to both acquire our funds and to engage with our salesforce by including
variables that were not attainable with previous methods. This was due to the
degree of feature engineering and data analysis required to identify variables
as viable and delivered thousands of advisors that had been previously
overlooked.
·
Implemented an
Analytics Sandbox for the BI team to introduce the concepts of feature engineering,
data manipulation, regression and classification modeling as we evolve our capabilities
from historic reporting to addressing core business challenges.
·
Built an
Analytics Dimension in our sandbox that consolidated transactions, asset
holdings, digital interactions, and traditional interactions into continuous
variables, binary and qualitative groupings at the advisor level in order to
facilitate analysis and classification/prediction model development. This dimension had over 100 variables
capturing a holistic view of our advisors’ experience with Janus.
·
Developed a
profiling engine to enable the ability to compare and contrast distinct
populations against each other on ~100 variables within 5 minutes.
·
Introduced and taught
analysts SQL so that they were better able to understand our underlying data
models and thus develop more robust reports as well as reduce inaccurate report
publications by being able to understand and test the underlying SQL in their
reports prior to promotion to production.
Probuild Holdings Denver CO 11/2013
- 9/2015
Director, Enterprise Information Management
·
Developed a
strategic roadmap, tactical plan, and budget
to consolidate a geographically dispersed data environment consisting of
data warehouses and teams utilizing BI suites from Microsoft (SQL Server, SSIS, SSRS), Oracle (OBI, MySQL), and Informatica.
·
Created a BI
newsletter to better communicate and connect with our partners in the business. This document was designed to provide
transparency into our day to day activities and long term mission as well as to
facilitate the relationship needed to deliver superior solutions.
·
Implemented a Hadoop staging layer as our staging
platform as a method to quickly consolidate all of the disparate environments
from which we would source enterprise data and begin to clean, transform, and
model for business consumption.
·
Due to a
financial freeze, implemented a training plan for my team so that 2 hours a
week was allocated to taking Udacity
Courses (http://www.udacity.com) relevant
to our environment in a reserved and private room. Insights implemented from these courses
became a variable in their performance reviews.
·
Introduced a more
scientific approach based upon Monte Carlo Simulations to estimate efforts to
counter a reputation that IT had garnered for over promising and under
delivering.
·
Developed,
socialized, and implemented an intake process that allowed us to move away from
developers being the touch point for the business for enhancement/break-fix
requests. By establishing business
relationships with regular interactions, we were able to develop a holistic
enterprise strategy designed to move our business partners and EIM towards our
common goal of a single source of accurate, timely, and actionable data.
·
Utilize R statistical programming language to
apply statistical methods to data to develop insights for ProBuild. Ex. Developed a predictive model for 2014
sales in Q1 of 2014 to show that Plan sales were unrealistic.
Sports Authority Denver CO 10/2011
- 11/2013
Director, Business Intelligence and Data Warehousing
·
Lead a team of
data architects, Informatica
developers, and MicroStrategy
developers tasked with consolidating and maximizing the value of operational
data by aligning its accessibility with the business’s informational needs around
strategic decision making.
·
Developed,
socialized, and implemented a BI roadmap that guides and drives our evolution
from static report development through decision support analytics.
·
Created and
implemented an embedding program that had BI developers and data architects sit
in business meetings in key business areas to learn how the business did
business and how information was used to guide decision making.
·
This embedding
strategy evolved into a program where MicroStrategy
developers were permanently housed in business units while being supported by
data architects and Informatica developers
in IT.
·
Developed a
“sandboxing” strategy that made our Teradata
environment accessible to more advanced analysts around the business as part of
our self-service BI strategy as well as our BI marketing campaign to reduce the
usage of “rogue” BI solutions rampant in the enterprise.
·
Transformed the
business requirements development process into an analytics requirements development
process as we determined that requirements for deliverables only solidified
when the analyst had had some experience with the data.
·
Wrote and
published the first BI newsletter which keeps the executive leadership abreast
of our roadmap progress and key initiatives.
·
Championed
and implemented a data architecture team charged with building the data
infrastructure necessary to support our mission to enable 360 degree customer
behavior analytics.
·
Challenged
by a project estimation process that became misaligned with reality early in
the SDLC, developed a template based upon a Monte Carlo Simulation that allowed
for more accurate estimation ranges in light of tremendous uncertainty.
·
Developed
a Regression Model that predicts daily sales so as to assist the Finance team
with their budgetary forecasting exercises.
Janus Capital Group Denver CO
Director, Business Analytics 1/2011 – 10/2011
Senior Manager, Marketing Analytics 6/2007 - 1/2011
·
Developed a
framework for a marketing analytics function within the Marketing department
and designed and developed a data infrastructure with Microsoft SQL Server that integrated previously disparate data
sources in order to better analyze our customers’ behavior, target effectively,
and analyze our marketing efforts.
·
Utilized R statistical programming language
analysis of campaign performance and studies on customer behavior.
·
Developed a CRM
Classification process that applied the business rules that defined the
contacts of each channel and summarized them to a value in one field. This allowed for the continuation of email
campaigns with the reduced risk (Legal) of touching an unintended contact with
unapproved material.
·
Developed an
engagement model that allowed for all business channels to see the business
from the same perspective providing a more integrated approach to expanding our
footprint among prospects and increasing product diversity among existing
clients.
·
Developed a
propensity model based upon the most impactful variables from an advisor
behavior and industry restrictions perspective providing the ability to target
far fewer contacts with our campaigns without a negative impact on our response
rates.
·
Developed
Campaign tracking and analysis function that allowed for the ability to
determine the impact of campaigns on post campaign behavior from whether or not
the incidence of meetings with our wholesalers had improved to interaction on
our website to whether or not there was an impact on prospect to client
conversions or a client's product diversity.
·
Developed a data
mining capability that allowed us to examine purchase patterns, determine which
product pairings/bundles
occurred naturally in the marketplace
allowing us to develop campaigns with improved relevance to the target
audience.
·
Developed
scheduling process to manage emails being sent out by the various channels so
as to not inundate our target audience with emails and instituted data rules
that automatically limited target list creation to contacts who had received
less than a determined threshold for emails allowed in a 30 day period.
JPMorgan Chase Columbus OH 8/2004 – 6/2007
Data Mining
Analyst, Customer Insights
and Targeting
·
Utilized SAS (Base, Stat, Macro), SQL, and Business
Objects in the analysis of CRM data in order to perform data mining and
analysis in support of Marketing, Product, and Executive Managers.
·
Applied
statistical methods and principles in the analysis of direct marketing and
media campaigns in order to determine the effectiveness of various offers and
the profitability of the campaign by measuring response rates of the targeted
audience as well as their eventual product selection, balance levels, service
usage, and attrition rates.
·
Performed channel
analysis to determine acquisition and service channel’s impact on customer
tenure, lifetime value, and attrition as well as the channel’s utilizations
impact on customer profitability.
·
Developed a profiling
tool for senior management that provides a quick view of many descriptive and
behavioral variables so that different populations could be easily and quickly
compared to uncover areas for further research.
·
Developed an
attrition prediction model to enable proactive measures against customers who
appeared to be approaching the attrition phase of their life cycle.
·
Developed risk
models to highlight small business customer activity that raised suspicion of
money laundering activity in order to comply with the Money Laundering
Guidelines adopted by JPMorgan Chase.
·
Performed ad hoc
discovery and root cause analysis and reporting for Marketing and Product
Managers.
Masco Corporation (Mill's Pride Division) Columbus OH 11/2002 – 8/2004
Sr. Data Analyst,
Marketing and Sales
·
Performed the
analysis to support and guide Category Managers, Product Managers, and
Production Managers with the selection, production, and placement of our
products on the shelves of 1,700 Home Depot stores.
EDUCATION
·
MBA, Finance and
Information Technology, University of Colorado, Boulder CO 1996
·
BBA Economics,
Georgia State
University, Atlanta GA 1989
SIGNIFICANT ACCOMPLISHMENTS
Competitive swimmer in the Olympic Games, Los
Angeles 1984
- 100M Free
- 4 X 100M
Free Relay
- 4 X 100M IM
Relay
