SUMMARY:

• Enterprise Data Architect with a history of leading IT organizations to leverage technologies toward accomplishing strategic and tactical business objectives. Recent experience involves working with senior management, business users and technical teams in order to define and implement data architecture strategies that achieve expense - reduction, business flexibility and data quality improvements.
• Expert knowledge of design principles, best practices and methodologies in data analysis, modeling, integration and data warehousing
• Extensive experience in the development and management of enterprise- wide data architectures using subject oriented models
• Vast experience in Extraction, Transformation and Load (ETL) strategy, design and implementation. Includes ETL across different platforms, MS SQL to Oracle and flat files.
• Outstanding ability to translate business requirements into conceptual, logical, and physical data models.
• Expert in design standards for using normalized data structures, de-normalized structures, and dimensional structures
• Solid experience using Meta Data to support data lineage tracking and operational data governance, enabling systems to provide long-term stability and reliability
• Proven ability to deliver highly comprehensive Master Data Management designs to consolidate data across a wide range of business entities
• More than two decades of delivering extremely robust and efficient Information Management Solutions, on-time and on-budget
• Excellent teamwork skills, good oral, written communication and presentation skills.

TECHNICAL SKILLS:

Products: Business Objects, Informatica, Infosphere, ERwin, ERStudio, PowerDesigner

Databases: MS SQL Server, Oracle, DB2, MYSQL, Sybase, (IDMS, VSAM)

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Enterprise Data Architect, responsible for the design of an Enterprise Data Warehouse using a Hub-Spoke Architecture to support the operational data flow between (50+) external and internal systems and provide Operational and Management reporting. Analysis of legacy systems and business processes was performed to identify areas contributing to poor data quality. Designed and coordinated standardized interfaces with external vendors, converted legacy data warehouses and developed new system interfaces, resulting in a more accurate and timely processing and reporting environment.

Confidential

Responsibilities:

• Lead Enterprise Data Architect, responsible for the design of an Enterprise MDM/ODS and Analytic Data Warehouse solution integrating ten (10) front-end legacy applications that support the Commercial P&C and Reinsurance business lines. Performed data analysis and profiling on legacy systems, developed Logical and Physical data models as well as ETL specifications for populating the Enterprise ODS, Analytic Data Warehouse and was responsible for the coordination of cross-team design solutions and execution.

Confidential

Responsibilities:

• Senior Data Architect challenged to address a reduction in the number of system interfaces. Responsible for the analysis of the current system architecture and the development of a Conceptual model used as a semantic hub to track the location of business data throughout the organization as well as highlight potential areas for system consolidation. A phased approach was developed to reduce the number of data stores as well as to simplify the current interface strategy.

Confidential

Responsibilities:

• Senior Enterprise Data Architect, responsible for communicating best practices, developing architectures, product evaluations and gaining consensus across multiple disciplines in a federated IT organization.
• Established the Enterprise Information Architecture practice including the following initiatives:
• Common Business Vocabulary/ Enterprise Conceptual Data Model
• Logical/Physical Data Architecture
• Master Data Architecture
• Business/Data Service Architecture
• Metadata Architecture
• Confidential provided a unique opportunity to hone my application integration skills through the analysis and evaluation of more than 1600 applications and 9000 databases. Confidential ’s IT principle, “Reuse before Buy, Buy before Build”, required the development of architecture strategies that blended industry products, legacy systems and new development.
• Of particular note was the Customer Visioning initiative which involved integrating 36 applications across the enterprise to meet the business objective of ‘a single view” of the firm’s customer base. This project involved the development of a Data Architecture to address the need for “gold stores” of Customer and Product Information, an Infrastructure Architecture to compensate for a diversity of mainframe and distributed application platforms and the re-architecting of business processes across the enterprise to improve data quality and work-flow efficiency.
• One ofmy primary areas of responsibility was the creation/maintenance of an Enterprise Conceptual Data Model, encompassing the major business areas of Confidential, which includes not only Life & P/C Insurance but also Retail Banking and Brokerage Services. The Conceptual Model was used as a basis for applicationscoped Physical Data Models and XML Schemas used in application messaging. The XML Schemas were mapped to Conceptual Data Model to insure consistency in data structures and to track application usage of business data.
• In addition to conducting in-house courses in Data and Process Modeling, my role also involved establishing Relational Database strategy, Information and Messaging standards, Metadata Architecture as well as the associated governance processes.

Confidential

Responsibilities:

• Performed as Project Manager and Lead Data Architect on business process re-engineering projects. Project responsibilities included requirements analysis, data and process modeling, application architecture and technical specifications as well as test plans and user . Also provided public courses in SDLC methodology, data and process modeling.
• Confidential - Performed requirements analysis to develop functional specifications for a State-wide Student Registration and Enrollment System, which included the Web-Based data capture of Student registration, enrollment and profile information as well as state and federal reporting. Designed the Data and Process Architecture for integrating diverse vendor based data feeds from over 600 school districts.

Confidential

Responsibilities:

• Major Pension and Annuity Provider ( Confidential ) - Managed the development of a CRM system to support the firm’s direct marketing activities and customer analytics. The system requirements included a set of custom data-warehousing tools for multi-dimensional analysis and cascade counts. In addition to being responsible for the technical design including the logical and physical data models and the application architecture, coordinated the business requirements definition and testing efforts performed by the client. In managing the development team, ensured that the schedule of monthly deliverables, were provided on time, for the entire three and a half years of the multi-million dollar project.
• Major Banking Institution ( Confidential ) - Managed the data modeling activities of the Derivatives and Securities Lending development areas. Responsibilities included the management of Logical and Physical data models and the development of Visual Basic prototypes to facilitate the determination of functional requirements through working models.

Confidential

Responsibilities:

• Provided management consulting and data modeling expertise in the strategic planning and design of a system architecture for downsizing the Investment and Dealer Banking applications. Developed an Enterprise Model, analyzed and documented the operational work flow, and evaluated legacy systems and commercial off-the-shelf (COTS) products to determine the most cost effective downsizing solution.
• Produced the functional requirements and logical design for a Quotation, Execution and Clearing system. This included the development of procedures to integrate CASE technology for Data and Process Modeling, and the management of multiple project teams and the integration of their data and process models.

Confidential

Responsibilities:

• Performed as the Functional Manager to coordinate the development of a new Enterprise model for a Fixed Income and Equity Trading system that would provide global support for the firm. The development of an enterprise-wide model was crucial to my success in establishing the strategic direction for all development projects, toward the goal of integrating three discreet trading systems.

Confidential

Consultant

Responsibilities:

• Managed and participated in the Functional Requirements Definition and detail design phases for a Fixed Income Trading system. Responsibilities also included coordinating User sign-off, Acceptance testing and User . The requirements of the new system ranged from Trade Capture and Real-time P& Confidential /positioning to automated Journal entry generation and General ledger processing.

Confidential

Senior Consultant

Responsibilities:

• Hired as a senior consultant for the Fixed Income Trading Systems Division, participated in many projects, often simultaneously, providing business expertise for modeling activities as well as technical skills for system implementations. Was the primary support personnel for the sales staff in evaluating client needs and producing project proposals for trading systems.

Confidential

Senior Systems Officer

Responsibilities:

• Hired to perform maintenance on a Fixed Income Dealer Trading and Accounting system. After many successful major system enhancements, was promoted to Project Manager for the conversion of the system to new a hardware platform. Responsibilities included a hardware feasibility study, reverse engineering the legacy systems to extract the baseline business requirements and the integration of new requirements.