SUMMARY:

A Senior IT professional experienced in managing, developing and implementing complex Enterprise Architectures; strong expertise in centralized and cloud based Data Warehouse, Business Intelligence and OLAP solutions that assist in improvement in corporate operations; expert in establishing and enhancing data storage plans and improving data utilization, quality, reliability, flexibility and performance; successful at conducting requirements and usage analysis and implementing processes and methodologies that improve overall IT project execution, system efficiency and operational performance.

CORE COMPETENCIES:

• Leadership and Team Building
• Business Relationship Management
• Technical Environment Specification & Configuration
• Data Utilization, Quality and Performance Process Improvement
• BI and Analytics roadmap development and implementation project execution
• P & L and Budget Management
• Strategic Architecture Design and Implementation
• Security and Availability Planning
• Data Storage Planning and Management
• Execute Project Development
• Enterprise Level Data Management and Governance
• Contract and Service Level Agreement Negotiation

PROFESSIONAL EXPERIENCE:

Confidential

Program Delivery Executive - Consultant

Responsibilities:

• Managed 38 consultants in three teams during transition of a three year SAP implementation from external Systems Integration effort to Internal IT Support and development teams.
• Transition included a ramp up of data integration (BODS, LSMW), Data Cleaning (Information Steward), management of Master Data Quality improvement and BI teams, Contract negotiation, Budget management during transition as well as establishing cut over transition, Knowledge transfer and training programs.

Confidential

Enterprise Data Architect

Responsibilities:

• Re-engineered, using an agile development approach, reporting and Analytics and BI environment (Oracle, ODI, OBIEE) to accommodate migration to a cloud based healthcare client service/CMS platform (Kentico/SQL Server 2012) supporting Client employee Health, Fitness and Wellness systems. Maintained legacy custom data reporting capability to avoid financial penalties through the two year transition.
• Designed interfaces and change data capture process from cloud (Azure) as well as local and remote data sources.
• Developed roadmap for Client service dashboards and standardization of client facing reporting delivery.

Confidential

Director Enterprise Information Management

Responsibilities:

• Lead product evaluation and deployment for a Consolidated Financial Reporting and Analytics Architecture to eliminate product redundancies in a multi-national, multi-ERP environment (SAP (R/3 & ECC 6), BAAN, Proteus, Confidential One World, Confidential Manugistics, TMM, Sage MS etc.).
• Facilitated the development of Executive level dashboards and developed multiple delivery options with using BOBJ, BODS Reduced software footprint from 7 reporting, 5 ETL and 4 data platforms to 2 reporting, 2 data and two ETL platforms Informatica and BODS).

Confidential

Director, Business Intelligence and Analytics

Responsibilities:

• Managed consolidation of multiple data reporting silos.
• Developed and executed multi-year development plan for data warehouse infrastructure.
• Minimized implementation costs through rationalization and reuse of licensing. Lead deployment of near real-time data integration (Attunity) and reporting (BOBJ) and Analytics (SAS) solutions, Implemented measurement feed-back loops to operational systems.
• Identified process leakage that resulted in elimination of payment losses, migrated BI team from an onshore to a mixed (16 person) on-shore/off-shore model.

Confidential

Enterprise Architect - Consultant

Responsibilities:

• Developed 4 year data technology and BI roadmap.
• Developed high availability plans for mainframe and open systems data environments.
• Reduced operating and support costs for data integration by 60%.
• Developed data encryption plans and conducted DW Appliance, Dashboard, BI tools and ETL vendor evaluations, managed project budgets, negotiated contracts for software hardware and staff training.
• Managed off-shore software conversion team.

Confidential

Director, Enterprise Architecture and Director Data Architecture

Responsibilities:

• Created, budgeted and staffed DB Administration, Data Architecture, Business Intelligence and Enterprise Architecture teams for a rail transportation company engaged in reengineering all IT systems to a Microsoft .NET/SOA platform over a four year period.
• Negotiated hardware and software purchases and managed department level budgets.
• Maintained legacy system operational integrity during phased system re-engineering and cut-over. Implemented development methods and procedures and methods that permitted the design and implementation of integrated EDM and EDW for deployment in a SQL Server (2000, 2005 and 2008) environment. Lead ERP (SAP), EDM and EDW Cognos, Business Objects, Performance Point, integration efforts.
• Introduced new BI/DW that reduced operational costs by over $250,000 annually. Introduced concepts and implemented data governance, master data management (MDM) and taxonomy utilization and management procedures. Introduce DB Load balancing to permit growth during re-engineering efforts.

Confidential

Manager, Database Systems

Responsibilities:

• Managed DBA and Data Warehousing teams supporting web advertising for all (over 200) major North American retailers.
• Developed consumer activity tracking reporting improvements that contributed to the organization exceeding annual income targets by over 38%.
• Re-architected the existing operational analytical environment to double the capacity while meeting existing budgetary constraints.
• Managed upgrade of in-house and hosted DBMS environment resulting in an overall 30% improvement in processing capacity and a 15% reduction is disk usage.

Confidential

Enterprise Architect - Consultant

Responsibilities:

• Designed and developed a data migration utility for customized implementations of commercial judicial systems management software.
• Used a meta-data approach to tag data for migration from multiple data sources into multiple target RDBMS platforms.
• Completed assignment 2 months ahead of schedule.

Confidential

VP Data warehouse & Business Intelligence

Responsibilities:

• Managed an on-shore and off-shore data warehousing and business intelligence team that supports over 8,000 users throughout the USA.
• Completed development and implementation of a two year effort aimed at shortening Financial reporting cycles for a large insurance company by over 30%.
• Identified opportunities for savings of over $16 million annually. Managed consolidation of multiple stove-pipe data marts into the foundation of an EDW.
• Lead implementation of SOX compliance procedures into the Business Intelligence (Business Objects and Hyperion) environment.
• Lead vendor negotiations and planning for an enterprise wide consolidation and simplification of Oracle, DB2, IMS, SQL Server, Business Objects, Hyperion, Constellar and Informatica environments and licensing.

Confidential

Technical Director, Data Architecture

Responsibilities:

• Designed the data architecture for the main data flows for a commercial Consumer Packaged Goods Competitive Intelligence data vendor.
• Architecture employed large scale grid computing techniques. This architecture was designed to support the loading of over 4 terabytes of Point of Sale Data daily.
• The data architecture employed Grid technology to facilitate loading and rapid reporting from a database that exceeded 250 terabytes, using Oracle, DB2, Data Stage, Meta Stage and Quality Stage.
• Re-architected the data warehouse for a large retail organization to permit the loading of daily point of sale data that previously took 2 days to load one day’s data.
• The data warehouse was also expanded to accommodate the piloting of new product and service lines in regional markets.

Confidential

Manager Business Intelligence Practice

Responsibilities:

• Saved over $18 million annually for a large telecommunications company by reducing over 40 data marts and Hyperion Essbase data cubes into a single reliable Financial Data Mart. Worked with senior management to reduce over 600 report metrics to the critical 80 required to run the business and developed KPI and Financial reporting standard templates.
• Employed Kimball techniques to identify subject areas and dimensions, developed Star Schema to support corporate wide financial reports.
• Applied Best Practices approach to reduce over 600 custom monthly reports to a standardized suite that eliminated over 200 man years of manual effort annually and facilitated the migration from a product centric to a customer centric financial reporting environment.

Confidential

Data Products Development Lead/Data Architect

Responsibilities:

• Consolidated custom batch applications into a Data Warehouse that is used to support Web (Business Objects) based order and delivery of market competitive data in the travel industry.
• Used Kimball methods and Erwin to develop the star schema to house data sourced are the Global Distribution systems as well as internet based reservation organizations (Expedia, Travelocity, Orbitz and Pegasus).
• The data within the warehouse is drives sales of competitive marketing data to the travel industry.

Confidential

Partner

Responsibilities:

• Developed Data Architecture for a commercial ERP software company that facilitates user data definition without Data Structure change and deployment in any RDBMS (DB2/UDB, Oracle, SQL Server Sybase etc.) environment. Utilized a Meta Repository and XML approach to identify data and allow data interchange with other applications. Custom developed a database design process that avoids the need to create a separate 0.5 Peta Byte Operational Data Store for Data Mart or Warehouse creation.
• Designed Knowledge Database based automated Data Mart creation process for data mining client data and identifying additional service opportunities. Employed Kimball and Normalization techniques to design the database that reduced over 2,000 logical tables into a 300 table data store. Integrated financial data from multiple sources including BAAN, Peoplesoft, Oracle, SAP, LAWSON and Informatica.
• Designed and implemented Architecture for an Internet based Global Tax Software Development system. Facilitated JAD sessions to gather requirements from internal and external business domain experts. Developed a proof of concept approach to reduce problem set into smaller solvable issues. Managed the development of prototypes to prove application and database (Oracle, SQL Server, DB2/UDB and Sybase) architectural concepts. Developed construction and implementation plans. Reduced a 2,000-entity data model into a smaller robust and scalable data model that was proven capable of supporting over 250 TB of data, 4,000+ users in a distributed 24X7 Intranet environment.