Data Management

Peter Panagiotatos

** ********* ****, *** *** West Hartford, CT 06107 646-***-****

*********@*****.***

SUMMARY

Global Business Intelligence & Data Architecture Director with record of

using Business Intelligence technology to drive business performance and

profits. National and international experience in numerous Fortune 1000

companies across all Business Intelligence Systems functions for the

insurance, reinsurance, captives, finance, consumer goods - manufacturing

industries. Leads a broad range of Business Intelligence Analytics

Management Systems and data warehouse strategy for ERP, CRM, and Business

Process Management. Core competencies:

Strategic Planning Data Profiling IT Resource Management

Master Data Management Methodology Model

SDLC Methodology BI Capability Maturity Data Governance Model

BPM Methodology Model ODS Architecture

Acquisitions/Divestiture BI Organizational Internal Consulting

Planning Methodology Assessments Project Management

Staff Development

AREAS OF EXPERTISE

ETL Software Tools: INFORMATICA, Data Integrator, IBM WEBSHERE

BI Software Tools: Business Objects, COGNOS, TM1, ESSBASE

Business Process Management CASE Tools: ARIS, CASEWISE

ERP Software: SAP-BW, CRM-Siebel, Hyperion

Databases: Oracle, DB2, SQL, Sybase

Data Modeling Tools: Erwin, PowerDesigner

SUCCESS HIGHLIGHTS

Business Intelligence-Master Data Management (MDM)

. Developed strategy, managed design, construction and implementation of

the three-tier open global BI architectures for Stanley Black & Decker,

NOVA Chemicals International Data Warehouse, IBM Global Services,

eVantage Solutions, AON Insurance Services, AIG Domestic Brokerage

Services and their associated logical and physical data architectures in

North America, Asia and Europe.

. Initiated the start up BI portfolio management program and the BI PMO

office for five Global Organizations.

. Built a worldwide virtual Business Intelligence Management Information

Technology Department with distributed business intelligence applications

resulting in a $6M decrease in development expense.

. Defined, established and implemented global information resource

management (IRM) components including data life-cycle management, data

management, data administration and individual transactional and decision

support information architecture management. Annual savings of $8M for

systems development by reducing redundancy and cleansing of data through

data profiling tools and methodology.

. Saved up to $4.5M in business reporting analysis and allowed for re-

assessment of the ERP, CRM data configuration and restructuring of the

transactional business model for sales & marketing, logistics and

financial departments.

. Established and executed data and metadata strategies, formalized the

international data administration strategies comprised of the European

Data Protection Regulations. Directed the development and delivery of an

intranet global enterprise logical and physical model.

o Reduced transaction processing time while improving analytical

capabilities by redesigning deficient operational SAP and CRM data

structures.

o Reduced response time to customer requests by two thirds, saved

$1.6M annually, and standardized data definitions and business

processes.

PROFESSIONAL EXPERIENCE

Stanley Works Black & Decker, New Britain, CT 2004 - 7/2010

Global Business Intelligence Director (2005 - 7/2010)

Led the development of the Global Data Warehouse and its associated 16 data

marts.

Defined and implemented the Global BI Engagement and rollout Process

Methodology model to service IT - BI clients. Established the BI center of

excellence (COE) team, which drove and managed the Global BI applications

utilizing internal developers and external contractors enabling the

business to achieve the following financial benefits:

. Inventory reduction of $113.61M

. Integration of Customer, AR detail, open orders and sales data resulted

in an AR reduction from 61 to 55 days and the collection of $37M of

outstanding invoices

. Developed Pricing Profitability Model for Fastening products resulting in

$17M of positive net price profitability increase

. Sales management analytics integrated with POS data achieving $125M

margin improvements

. Product trend analysis increasing incremental sales of $90M

. Global Procurement Analytics achieving an increase of $33.5M of working

capital on annual basis

. Elimination of data redundancy processed with spreadsheets by integrating

with global data warehouse providing an internal productivity savings of

$5M

. Wrote and presented the MDM methodology in relationship to SAP - BW.

Implementation for product and customer data-prototype achieving

standardization of repeatable data extraction.

Independent Business Intelligence Consultant (2004 - 2005)

Recruited to turn around and stabilize the BI environment. Charged with

defining a five-year strategy, building the Global virtual BI team and the

three tier open BI architecture as centralized operating model servicing

for all global operations. Wrote the evaluation methodology for the

selection of BI tools and negotiated with vendors the pricing acquisition

for all BI technologies.

XL Capital Inc & eVantage Cor

Business intelligence independent Consultant 2002 - 2004

Performed business process analysis for SOX404 regulations and proposed the

building blocks for BI and for information resource management.

NOVA Chemicals Inc., Pittsburgh, PA 1999 - 2002

Global Director, Business Intelligence

Led Business Intelligence Architecture Development for $3B Canadian-based,

chemical commodities company with operating headquarters in Pittsburgh and

18 international locations in the United States, Canada, Europe and China.

. Wrote and implemented a global strategy for business intelligence, data

and data warehouse management.

. Directed corporate-wide launch of Global Federated Enterprise Information

Warehouse architectural domains and associated components; successfully

implemented which promoted seamless adaptation of the Business

Intelligence Analysis processing by other divisions.

. Implemented the metrics for sales management and margin models analysis.

IBM Global Services, White Plains, NY 1997 - 1999

Senior Consultant, Business Intelligence Services

Consultant to Fortune 500 companies for Business Intelligence development

of Data Warehouse system building blocks, data architecture, and

organization optimization for technology selection, selection of metadata

repositories, and data management architecture tools.

. Evaluated business intelligence for a multi-million-dollar credit card

company. Recommended and implemented architectural components for an

information warehouse and associated data principles.

. Assessed organizational readiness for the implementation of an enterprise

data warehouse for a multinational retail organization and its associated

logical and physical models.

. Constructed the international data and business model for insurance

industry consulting; models were marketed in North America and in

European Union.

. Directed and implemented the construction of a data model and prepared

data integration for reporting analysis on the placement of 35 investment

funds for the demutualization of a mutual insurance company.

. Improved business processes and saved more than $5M in system development

by recommending and implementing data reengineering activities for two

mutual funds companies.

. Analyzed decision-support systems and SAP architecture for a multi-

billion-dollar petrochemical corporation. Led redefinition of the data

warehouse architecture and designed the reporting framework for

international business units.

. Planned information systems for a new division of a $22B pharmaceutical

corporation; defined the technical architectures and the data resource

management framework infrastructure.

. Co-authored Business Intelligence Methodology on investigating data

patterns and building business decision systems.

Johnson & Higgins, Inc., New York City, NY 1995 - 1997

AVP of Data Administration

Created the corporate data architecture, data warehouse, and global data

model. Defined and recommended technology architecture infrastructures and

business models. Analyzed and re-engineered workflows and established

development methodologies.

. Directed the creation of a Data Administration division to manage the

corporate information architecture.

. Revitalized applications development practice by redesigning Systems

Development and Project Management methodologies; introduced and

standardized CASE technology.

American International Group, Inc., New York City, NY 1994 - 1995

Director of Business Systems

Developed and implemented strategic underwriting and financial applications

for an $8B division.

. Managed Big Six company consultants for applications design and

coordinated international outsourcing for code development while

recruiting and managing a staff of 25.

. Developed and implemented client/server architecture for a domestic and

international insurance risk reservation system servicing 30 national and

international operating units.

. Conducted the business area analysis and development of a three-tier

client/server system for state regulatory compliance rules involving

94,000 insurance brokers and agents.

AON INSURANCE Services 1984 - 1993

Business Systems / Applications Development Manager

Recommended and implemented technology solutions for insurance brokerages.

Established decision support reporting architecture to streamline claims

processing of commercial airline premiums for product liability.

. Developed and implemented the International Brokerage-Aviation

Facultative Reinsurance enterprise system.

. Managed the design and implementation of customized systems applications

for seven self-insured professional liability organizations.

. Managed the development and implementation of mortgage forced placement

system. System interfaces with 25 banks and mortgage companies.

. Performed the work-flow and system requirements for 15 Captives located

in Bermuda, Vermont and Colorado.

. Managed systems interfaces and relationships with Lloyd's of London and

national underwriters.

EDUCATION AND PROFESSIONAL TRAINING

Certified on Data Strategy, eDCI University

Bachelor of Arts, Political Science, Point Park University, Pittsburgh, PA

Coursework in Data Processing, Manhattan Community College, New York City,

NY

The IBM Institute: Business Discovery Methodology, Application Development

Methodology, Data Warehouse Design, Data Architecture Business Principles

Development, OLAP tools and analysis

The Center for Creative Leadership: Management Relationships and Leadership

Development

Carnegie Mellon University: "Executive Leadership" Sponsored by NOVA

Chemicals Inc.

Contact this candidate