Director of Business Intelligence & Data Warehouse
Resume:
R. BRENDAN ALDRICH
Hartford, CT, 06103
*********@*******.***
DIRECTOR OF BUSINESS INTELLIGENCE & DATA WAREHOUSING
Accomplished IT management professional with extensive background in directing data operations. Consistent
record of business intelligence and data warehouse re-engineering to facilitate revenue growth. Expertise in
business unit management, application development and reporting systems alignment to enterprise goals.
Adept at leading development and launch of global systems. Excellent problem-solving and leadership skills.
Business Intelligence * Data Warehousing * IT Operations * Strategic Planning * Metrics
Data Management * Business Process Reengineering * Analytics/Reporting * Communications * Leadership
Systems & Application Development * Cross-Functional Team Management * Problem Resolution
PROFESSIONAL EXPERIENCE
THE TRAVELERS COMPANIES, INC., Hartford, CT
2008 - Present
Director, Business Systems
Currently leading a team of up to 22 business and data analysts dedicated to enterprise business intelligence
and data warehousing programs within the Business Insurance division of The Travelers Companies, a 20B+
international provider of commercial and personal property & casualty insurance products and services.
* Established cross-functional relationships and directed all requirements gathering, data analysis and
documentation for enterprise projects to centralize insurance policy, premium, claim and loss data from
the Travelers & St. Paul Companies into a single multi-terabyte data warehouse with advanced
reporting.
* Improved team efficiency by 60% with the definition of a business & data analysis practice including
standardized processes, reusable templates and extensive business intelligence / data warehouse training.
* Led development of and implemented metadata-based analysis tools for both dynamic SQL code
generation & management of cross-project data mappings from originating data sources to target
models.
J2 GLOBAL COMMUNICATIONS, INC., Los Angeles, CA
2005 - 2007
Director, Billing & Data Warehouse
Oversaw development, improvement, and management of billing platform, business intelligence reporting
services and data warehouse for provider of faxing, voicemail, and unified messaging solutions with over
$180 million in annual revenues. Administered $5M operations and capital budgets. Supervised multi-
departmental task force, including 11 direct reports. Carried out project planning, risk management, and
implementation.
* Facilitated $20 million annual revenue increase by providing supplementary systems for billing
platform.
* Led development and implementation of the company's first data warehouse. Replaced 400 existing
reports with 90 new metric-unified warehouse reports for sales, marketing and revenue management.
* Improved month-end closing process by 70%. Created multi-department task force to resolve issues
with data management infrastructure, formulation of corporate metrics, and standardized reporting.
* Refined corporate Sarbanes Oxley controls for web revenue, data handling, and financial reporting.
ROUSE ASSET SERVICES, Beverly Hills, CA
2004 - 2005
Director, Business Intelligence
Coordinated, implemented, and distributed reporting services for major firm specializing in appraisal,
auction, and marketing of heavy equipment. Customers include Top 10 US rental equipment companies.
Supervised matrixed team of developers and project managers. Led design and launch of products.
* Managed development of 2nd generation .NET web interface to facilitate client report consumption.
* Directed creation of 35 industry-specific reports for deployment to client senior executives.
* Formulated dashboard summary reports that presented VP-level overviews of each client's fleet.
THE WALT DISNEY COMPANY, North Hollywood, CA
1998 - 2004
Manager, Business Intelligence Team, Walt Disney Internet Group (WDIG) (2001-2004)
Managed full life cycle development of business intelligence systems for entertainment giant's internet arm.
Led delivery of data and reporting on all internet initiatives. Communicated with all business areas.
Supervised multi-departmental task force, including 7 direct reports. Authored project proposals, defined
scope of work, and prepared cost estimates, schedules, budgets, and resource requirements.
* Facilitated $3.2 million revenue growth in 1 quarter through design and creation of finance datamart to
consolidate billing data and new financial reporting tools for tracking of subscription revenues.
* Increased accuracy of revenue recognition and accelerated time-to-close by 60% via leadership of 10-
month task force to resolve data collection & reporting issues and inconsistencies across the enterprise.
* Improved team efficiency by 85% via the establishment of standardized development procedures.
Project Manager, E.Piphany Team, WDIG (2001)
As Consulting Project Manager, led team of 10 engineers and software developers in supporting and
improving operating systems, database, and applications.
* Planned and carried out detailed analysis of existing systems and developed functional specifications,
risk plans, and acceptance procedures as well as direction of application and operating system upgrades.
Project Lead, Year 2000 Team/Remedy Team, WDIG (1999-2000)
Supervised staff of 5 consultants in remediation of BIOS, operating system, and 3rd-party desktop software to
ensure Y2K compliance for over 700 desktops and servers. Responsibility for development of customized
version of Remedy Help Desk 4.0 application. Prepared operational documentation and training materials.
* Completed Y2K project on schedule and 20% under budget.
* Planned and led rollout of Remedy to over 250 users in 4 geographically-separated locations.
Senior Business Analyst, Y2K Team, Disney Consumer Products (1998-1999)
Defined and created documentation supporting Y2K compliance efforts, including questionnaires and
methodology. Managed business unit reimbursements for allocated resources from 23 worldwide business
units. Monitored project progress and carried out risk mitigation, change control, and other activities.
* Conducted or supervised interviews with project managers and executives at >2,500 partner companies.
* Created customized cost models to manage reimbursement charges.
PREVIOUS EXPERIENCE
Sr. Analyst, HOME SAVINGS OF AMERICA, Irwindale, CA 1997 - 1998
EDUCATION
BA in Theater Arts, California State University, Los Angeles, CA
TECHNICAL PLATFORMS
Business Objects, MS Reporting Services, Cognos, SQL Server, Oracle, Teradata
Ab Initio, MS Office, Project, Visio, FrontPage, Remedy Suite, PGP
AWARDS & RECOGNITION
* Nationwide Top Performer in Intel Focus '97 Incentive Program, Incentives Magazine (12/97)
* 61st top speaker in the nation, American Forensics Association/National Individual Events Tournament (04/94)
Contact this candidate