More than 18 years experience and hands on expertise as Enterprise Data Architect and Enterprise Solution Architect covering Business Intelligence, Data Warehousing, Enterprise Data Architecture, Data Design, IIW and BASEL II Banking Risk Assessment and Compliance.

• Extensive expertise covers full life cycle design, development, and implementation of complex Multi-Terabyte Data projects using Best of Practice Implementation and ensuring high quality results. Industrial experience covers Banking, Finance, Insurance, Health Care, Telecommunication, Retail and Government.
• Leading expert in Enterprise Information Data Architecture and Data Warehousing.
• Business Intelligence: Enterprise Data Warehouse, Data Marts, Data Mining, Data Analytics, Multidimensional Analysis, Design and Modeling, OLAP, Cubes and BI tools.
• Data Governance and Control: Metadata Architecture, Data Stewardship, Data Traceability Lineage, Data Mapping Data Management Techniques.
• Enterprise Data Architecture: Conceptual, Logical Physical Data Modeling, Operational Data Stores ODS , OLTP, JAD Sessions.
• Strategic Analysis and Enterprise Engineering: Business Process Modeling, Redesign, Improvement and Reengineering BPR for Business Expansion, Performance Improvement and Market Extension, Growth, Adaptability and Flexibility.
• Data Integration of Legacy Systems: Master Data Management, Data References and Data Synchronization across Distributed Databases.
• Financial Systems: Customization and implementation of IBM Banking Data Warehouse BDW for BASEL II Banking Risk requirements, Information FrameWork IFW , IBM Insurance Application Architecture IAA and Insurance Information Warehouse IIW .
• Data Conversion, Migration Strategy and Architecture. Conversion Implementation Techniques. Development and implementation of ETL ELT.
• System Development Life Cycle SDLC : Strategic Planning, Requirement Analysis, Systems Analysis, Design, Modeling and Testing. Object Oriented Architecture, UML and RUP.
• Program and Project Management, Budgeting, Staff Recruiting and Managing.

Confidential

President Chief Technical Advisor

• Providing Best of Practice Consulting in Business Intelligence BI , Enterprise Data Warehousing, Data Architecture, Data Integration, Data Modeling, Data Quality, Data Governance, Master Data Management MDM , Metadata and Data Solution Architecture.
• Marketing, Pre-Sales, Sales and Post-sales of Consulting Services.
• Conducted many successful assignments in BI, Enterprise Data Warehousing, Enterprise Data Architecture Modeling, Data Integration, Data Governance, MDM, Data Solution Architecture, Data Strategy and Information Strategic Planning.
• Budget Control, Resources Management.
• Conducted projects and training classes.

Confidential

• Strategy and Development of Enterprise Data Solution Architecture and Data Warehouse:
• Developing MDM Strategy, Solution and Modeling Approach for using Trillium and Initiate Software through an Integrated Enterprise Data Architecture and Logical Models for ODS and EDW including Data Integration, Data Synchronization.
• Conceptual, Canonical, Logical Physical Data Modeling
• Initiate Tool for MDM and Trillium for Data Profiling
• Design the Service Oriented Architecture SOA
• Software: Erwin 7.3, Model Mart, Oracle, Agile, Trillium, Initiate MDM, PL/SQL.

Confidential

The Health Insurance Project consists of Data Governance and Master Data Management Architecture including Integration, Quality Assurance, and Conversion from old Legacy systems into new environment. The scope covers Data Profiling, Cleansing and Integration of Providers and Claims and Customer Data Integration CDI . Responsibilities include:

• Analysis of requirement and Development of Implementation plans and roadmap.
• Development of Master Data Management for Providers, Claims, and Customers.
• Development of Implementation Framework for Data Governance, Data Quality and MDM Architecture including Conversion, Migration, Data Mapping and Transformation.
• Development of the Data Architecture for the integrated Providers, Claims, and Customers.
• Conceptual, Logical Physical Data Modeling. Selection Criteria for Tools Evaluation.
• Translating business requirement specifications into detailed conversion logic and mappings
• Developing Architecture for Data Mapping, ETL, Data Cleansing, and Metadata.
• Development of Conversion ETL specifications and ensuring efficient ETL processing
• Technical evaluation of IBM Insurance Application Architecture IAA and Insurance Information Warehouse IIW for possible acquisition and use.
• Software: Erwin 7.3, Informatica Data Explorer, Oracle, Teradata, IAA, IIW, PL/SQL.
• Confidential the largest cellular company in Turkey and has 56 million subscribers, assigned a major and proficient IT consulting company in Europe, to develop a sizeable and complicated Data Warehousing project. The European Consulting Company requested the support of Bill Inmon.

Bill Inmon recommended Dr. Naoulo to provide Solution Architecture and consulting services to this project and save the project from collapsing due to the size, complexity, and sophistication of the project. I turned around the project successfully. Turkcell was very satisfied with the performance and expanded the scope and contract of the European Consulting Company. Assignment included:

• Data Security, Data Archiving, Data Backup and Recovery.
• Metadata Strategy, Business Metadata, Technical Metadata, Metadata Presentations. Foundation Architecture. Metadata Alternatives evaluation: Integrated tool, In house Development or Integration of Software Tools Metadata: Ab Initio, Oracle, and PowerDesigner MicroStrategy. Metadata Implementation. Tools Evaluation.
• Master Data Management, References Data, Customer Data Integration CDI .
• Data Quality Management, Data Profiling, Data Cleansing and Data Consistency.
• Developed Strategies, Roadmaps, Frameworks, and Project Plans for Customer Data Integration CDI and Customer Relationship Management CRM .
• Developed Methodology, Guidelines, Techniques and Standards for the Data Governance, Data Warehouse and Business Intelligence covering:
• Developed the IS Solution Architecture including the design of Service Oriented Architecture SOA , Technical Solution and Architecture. SOA Implementation.
• Developed Data Governance Framework, Roadmap and Implementation Plan.
• Assessed, validated and rectified the Data Warehouse Modeling Architecture and Design
• Assessed, validated and rectified the Data Marts Design.
• Evaluation of Customer Data Integration CDI using Oracle Customer Data Hub CDH .
• Guided, mentored and provided direction to the Data Warehouse teams.
• Guided the ETL, Logical Modeling, Physical Modeling and Database, Migration, Query and Reporting, and Testing teams to develop tasks specifications and procedures.
• Conducting Workshop sessions with Bill Inmon.
• Conducted Solution Architecture Workshops with Bill Inmon to appraise the Architectural Solutions based on the Corporate Information Factory DW 2.0.
• Software: Ab Initio, Oracle, Teradata, PowerDesigner, MicroStrategy. DB size: 60 TB.

Chief Data Warehouse Architect Data Architect

• Strategy and Development of Enterprise Data Architecture and Data Warehouse:
• Analyzed the Reporting Requirements and Input Legacy Source Systems and designed the Data Governance for Source to Target mapping and reporting solution.
• Designed multidimensional Data Marts that provide detailed Data Mining and Business Intelligence Reports.
• Developed an Integrated Enterprise Data Architecture and Logical Models.
• Designed and implemented of a Risk Management Reporting and Analysis System.
• Assessment and recommendation of tools for Risk Management.
• Subject matter expert to the project and Development of Analytical Models to assess the Customers behavior and correlation to Market fluctuations.
• Data Mapping, Data Cleansing, Data Integration, Data Synchronization, and Metadata.
• Software: Erwin 4.1.x/7.1.x, Model Mart, Oracle, PL/SQL, Informatica, Business Objects, PowerBuilder.
• Chief Data Warehouse Architect Data Architect Confidential
• Data Architecture for BellSouth Broad Band Telephony BBT , which involves moving from Line Telephony to Internet Telephony and adding On-Demand Multimedia: Feature films, Customized News and TV series:
• Analyzed reporting requirements and designed Logical and Physical Multidimensional Data Mart Models that provide detailed Intelligence Reports.
• eveloped the Data Marts for Call Centers, Billing, Troubleshooting, Offers and Orders.
• Customized and enhanced the Teradata cLDM Communication Logical Data Model: an Integrated Enterprise Database
• Master Data Management Architecture MDM , Hyperion MDM tool.
• Web Data Mining and Statistical Analysis of Offers, Marketing Campaigns, Sales, Orders and Call Centers' info and performance.
• Data Mapping: Source Systems Data Marts via the cLDM.
• Guided the reports development team using Business Objects and the ETL team using Informatica. Evaluation of Metadata tools.
• Data Governance and Data Integration, Service Oriented Architecture SOA .
• Software: Erwin 4.1.x, Teradata, DB2, Oracle, Informatica, Business Objects, Hyperion MDM, PL/SQL, MS Project.

Chief Technical Advisor Confidential As Chief Data Architect at the Kuwait Public Institution For Social Security PIFSS , the assignment covered Data Governance to convert PIFSS systems from COBOL/CICS/VSAM and DATACOM/DB into DB2 environment. The assignment included analysis of current VSAM files and DATACOM tables, development of Logical and Physical Data Models, and building a DB2 database to support the systems.

• Functional Analysis including Investment Banking and Portfolio Management.
• Currencies Fluctuations, Stocks and Bonds Analysis, Risks Assessment and Mitigation.
• Software: Erwin 4.1.4, DataStage, VSAM, DB2, COBOL/CICS, DATACOM/DB.

Enterprise Data Architect Confidential

Confidential aims to enhance the employability and job opportunities to the residents of Georgia who are between jobs. The assignment as Chief Data Architect and Enterprise Architect covered the analysis of the requirements to meet GDOL objectives and review, enhance and implement the Data Governance, Application Architecture, and Technical Architecture for the migration from multiple quasi independent systems based on VSAM/DB2/COBOL infrastructure into an integrated Architecture based on DB2/JAVA/XML. The assignment included the redesign the IT Architecture Infrastructure platform to assimilate the new technological trends and the Internet.

• Analyzed GDOL information and business requirements for job opportunities to residents
• Analyzed GDOL information requirements for education and employability of residents and correlate these requirements with Georgia Department of Education offerings.
• Developed the Strategy for Enterprise Data Architecture and Technical Architecture.
• Developed the Data Architecture for an Integrated Data Model and Data Warehouses.
• Developed the Technical Architecture encompassing the incremental use of the Internet
• Built a Roadmap and Project Plan for Data Integration, Migration, and Transition.
• Analyzed the Data Structure of the current VSAM files and DB2 tables.
• Developed an Integrated Enterprise Data Architecture and Logical Models. Converted Logical Models to Physical Models and generated the DDL for the database Schema.
• Responsible for enterprise-wide data design, balancing optimization of data access with batch loading and resource utilization factors
• Customized the DDL scripts for database enhancement and tuning.
• Built the Mapping and Transformation Rules between the current Legacy Systems Databases mainly VSAM/COBOL, DB2, Oracle, MS SQL Server and the target Database DB2 UDB including the Integrated Data Model and Data Warehouses.
• Guided the development of the Extraction, Transformation, and Loading ETL Process.
• Assessed the Impact of transition from Batch to Online Environment on current Applications Size of Change, Implementation Process, Coding .
• Assessed the Conversion and Synchronization Tools.
• Validated the Service Oriented Architecture SOA .
• Developed Testing Strategy and Unit, Functional, System, and User Acceptance Testing
• Developed a Strategy to store Historical Data and its retrieval.
• Developed the Implementation Rollout Plan as it involves many offices and the rollout has to be incremental with the possibility of safe fall-back.
• Developed Data Synchronization Process between the current Databases and the target Database during the Rollout and Transition Period.
• Software: Erwin 4.1.4, VSAM, DB2, DataStage, SQL, COBOL/CICS, JAVA, MQSeries, WebFocus, MS Project, MS Visio, UNIX, Linux, JDBC, ODBC.

Confidential

• Assessment Evaluation of IBM's Banking Data Warehouse BDW for BASEL II Credit Risk.
• Development of Metadata Model. Database Reverse Engineering DBRE . Development of Metadata Model. Customization and Implementation of the models.
• Analyzed the Bank business and Credit Risk requirements
• Assessed and Evaluated IBM's BDW to support the Bank's BASEL II Credit Risk
• Customized BDW models to support the Bank business and Credit Risk requirements
• Developed the Data Architecture for Commission Management Utility.
• Developed a Metadata Model for Database Reverse Engineering DBRE and implemented the Database
• Created detailed documentation of Data Models and Data Management
• Identified business rules and developed interface processing logic and rules to be used across all inbound interfaces. Developed detailed design specifications for interfaces into BDW for BASEL II Credit Risk Implementation.
• Worked with functional team to determine reusable processes and objects as per industry best practices.
• Cleansed the source data, extracted and transformed data with business rules.
• Software: IBM BDW, DB2, Informatica Power Center v7.1.2, Erwin 4.1, MS SQL Server 2000, Oracle, PL/SQL, UML.

Confidential

• Design and implementation of a Risk Management Reporting and Analysis System. Assessment and recommendation of tools for Risk Management and IBM BDW.
• Developed Data Architecture for HomeBanc covering Loan Applications, Risk assessment, Products and Eligibility Messages.
• Developed Physical Standards, Testing Plan and implemented Unit, Functional and User Acceptance Testing.
• Software: Erwin 4.1, ModelMart 4.1, MS SQL Server 2000, Windows 2003 Server, UML, XML.

Confidential

Senior Consultant

Providing Consulting in Data Warehousing, Business Intelligence, Data Architecture, Data Integration, Data Modeling, Data Quality, and Data Governance.

Confidential

Establishment of an Internet Company to provide Health services and e-Commerce for Internet Business-to-Business and retail. The assignment included the development of Health Website as well as Portal, Search Engine and Health Databases. Responsibilities included:Business requirements analysis and Design and development of the Enterprise Data Architecture and Models for Health Claims processing and history, Health Plans comparison and drugs shopping.

• Architecture Development and Implementation of:
• Operational Data Store, Data Warehouse, OLAP and Data Marts
• Website Data Warehousing, Metadata Repository and Data Mapping to the Web pages
• Evaluation of ETL tools, Reporting tools and Data Mining tools
• Software: Rational Rose, Erwin, Oracle, MS Project, Visio, Java, XML.

Confidential

Responsibility as Enterprise Data Architect covered the transition of BankBoston to the Internet environment to provide Internet e-Business services to its customers:

• Reengineered the business processes to include e-Business techniques and procedures
• Developed the Enterprise Architecture to support the e-Business services
• Analyzed designed Data Architecture and Enterprise Processes for e-Business services
• Developed a plan to integrate the new e-Business services and infrastructure with the current systems.
• Assessed and evaluated IBM BDW for possible implementation at the Bank.

Confidential

Principal Consultant

• Built the Business Process Re-engineering practice for Texas Instruments in Canada:
• Marketing, Pre-Sales and Post-sales of Business Process Re-engineering Consulting Services and Software products. Submitted proposals for 10 millions. Succeeded in getting 3 million projects.
• Conducted projects and training classes in Business Process Re-engineering.
• Conducted many successful assignments in Data Strategy, Information Strategic Planning, Systems Development, and Information Engineering.
• Conducted many successful assignments in Data Architecture and Data Modeling,
• Software: Texas Instruments BPE BDF, System Engineer, Oracle, PowerBuilder, SQL.

Confidential

CIO Principal Consultant

• Assignments cover:
• Direction of the IT Center, Information Strategic Planning
• Budget Control, Resources Management
• Data Architecture, Financial and Engineering Applications Development
• Technical Architecture, Software and Hardware RFP and Acquisition
• Portfolio Management, Investment Strategy, Planning and Evaluation, Return on Investment
• Risk Assessment, RISK Mitigation.

Modeling, Case Software Tools ERWIN 3.x, 4.x 7.x, Model Mart, IBM Rational Rose Data Modeler, IBM Banking Data Warehouse BDW , IBM Insurance Application Architecture IAA , IBM Insurance Information Warehouse IIW , IBM DataStage, Unified Modeling Language UML , Telelogic System Architect, PowerDesigner, Q Designer, Composer Case Tool, Informatica, Business Objects, Ab Initio, Hyperion MDM, Trillium, Initiate MDM, Microstrategy, Teradata Communication Logical Data Model cLDM , MS Office, MS Project, MS Visio.

• Methodologies
• LANGUAGES SQL, PL/SQL, C , C, COBOL, PL1, Java, JavaScript, MS-Visual C , HTML, XML.
• Databases
• IBM DB2, DB2/UDB, QMF, Teradata, Oracle, MS SQL Server, Sybase, MS Access, VSAM.
• Inmon DW2.0, Kimball, Rumbaugh OMT, Jacobson Use Cases, Waterfall SDLC, Rational Unified Process RUP , Agile, RAD, UML, IBM WSDDM, Information Engineering.

Fluent in English, French and Arabic

• IBM Insurance Application Architecture IAA and Insurance Information Warehouse IIW
• IBM Information FrameWork IFW , Statistical Analysis, Financial Risk Analysis
• IBM Banking Data Warehouse BDW for BASEL II Banking Risk Requirements
• Enterprise Data Warehouse and Data Marts Architecture Design Modeling
• Business Intelligence and Analytics, Data Mining, Decision Support Systems
• Strategic Planning, Enterprise Data Architecture and Data Stores Design Modeling
• Database Reverse Engineering, Mapping As is Physical Models to To Be Logical Models
• Identify Enterprise Needs Identification, Assessment of Current Data Architecture
• Needs and Measures Validation, Planning Transition to New Architecture Environment
• Strategic Information Warehouse Engineering, Building comprehensive Enterprise Architecture Model, Gap Analysis, Data Dictionaries Generation
• Data Marts, Operational Data Stores ODS , Data Staging Areas, RDBMS
• Multidimensional Analysis and Design, Multi Star and Snowflake Schemas, OLAP
• Data Integration, Data Quality Assurance and Audit, Data Profiling and Data Cleansing
• Data Quality program Implementation, Data Security, Data Archiving
• Data Governance Framework, Concepts, Policies, Standards, Roadmap, Project Plan and Implementation, Data Stewardship, Resolve Data Conflicts, Redundancies and Duplications
• Metadata Vision, Strategy, Architecture, Modeling, Standards Layers of Functionality
• Metadata Management, Analysis, Design Implementation, Data Traceability Lineage
• Master Data Management and Architecture, Customer Data Integration CDI , Data References, External Data References Incorporation Integration
• Data Modeling Strategy, Framework, Techniques and Implementation, OLTP, 3NF
• Conceptual, Canonical, Semantic, Logical Physical Data Modeling
• Entity Relationship Diagrams ERD , Data Repositories. Adobe XMP/RDF/OWL
• Data Modeling Process and Procedures and their adaptation to specific environments
• Program Management, Project Management, Profit and Loss and Budget Management
• Rational Unified Process RUP , Zachman, Facilitating JAD Sessions, Agile
• Architecting Data Solutions in Multiple Systems and Multiple Platforms Environments
• Information Engineering including Data and Process Modeling, Data Design Documents
• Technical Architecture, Service Oriented Architecture SOA
• Enterprise-wide Data Design, balancing optimization of data access with batch loading
• Database design, software procedures, constraints, indexes, DDL Performance Tuning
• Data Migration: Mapping, Conversion, Extraction, Transformation Loading ETL ELT
• Development of Strategies, Framework, Roadmap, Policies Standards
• Requirements Analysis, Project Plans and Implementation Tasks Specifications
• Business and Operations Strategy, Process Redesign, Process and Data Flow Improvement
• Reporting and Query: Reporting tools, SQL, Oracle PL/SQL, IBM QMF
• Testing Strategy and Implementation, Unit, System, and User Acceptance Testing.
• Creating Data Architecture policies, procedures, standards, and leading their implementation
• Data Standards Business Rules, Data Dictionary and Repository
• Application Architecture, Software Reuse, Object Oriented Development
• Object Modeling, Use Case Modeling, UML, Application Architecture
• Object Oriented Analysis OOA , Design OOD , Modeling, Programming OOP .
• Interaction of Class and Object Models with Data and Relational Database Models
• Process Improvement, Business Process Re-Engineering BPR
• Software Engineering Institute - Capability Maturity Models SEI-CMM .