Post Job Free

Resume

Sign in

Director of Business Intelligence & Data Warehouse

Location:
United States
Posted:
January 17, 2010

Contact this candidate

Resume:

R. BRENDAN ALDRICH

*** ****** ****** #***

Hartford, CT, 06103

805-***-****

fg1yrq@r.postjobfree.com

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