Professional Summary:

• Proficient in 'hands-on' Canonical, Conceptual, Third Normal Form 3NF , Operational Data Store ODS and dimensional modeling techniques.
• Have the ability to understand, extract, analyze and transform business requirements/rules by applying normalization and dimensional concepts.
• Promote and follow Enterprise Architecture standards, guidelines, and best Data quality assessment practices integrated with my data base design efforts.
• Ability to develop, interpret and articulate data models and holds LDM and PDM Reviews with Data SMEs and Data Architecture teams.
• Have excellent oral and written communication skills, analytical ability and the ability to work independently with systems technical staff and internal business customers.
• Have honed the ability to drive the Conceptual/Logical/Physical design of data structures to meet/exceed organizational requirements.
• Extensive knowledge base of David Hays, Bill Inmon and Ralph Kimball methodologies, Business Process Re-engineering, and Database Design Methodologies.
• Possess the formal training, corporate and government experience required to support complex IT projects.
• Understand 'Big Picture' concepts as well as fundamental 'hands-on' details required to make complex projects succeed.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Modeler/Architect

• Generated the initial Canonical, Conceptual, Logical and Physical Enterprise Operational Data Store ODS Data Models for the second-largest producer of natural gas and the 10th largest producer of oil and natural gas liquids in the US.
• Analyzed/Documented the initial Business requirements, established Oil and Gas Industry data structures and concentrated detailed data analysis by the US Corporate Technical staff.
• The Environment was primarily Informatica MDM, SAP, MS SQL Server, Oracle, and DB2. A custom in-house designed Data Modeling/Governance/Repository tool was the primary design interface used.

Confidential

Solutions Architect/Technical Manager

• Defined the initial approach to eliminate, and consolidate 15,000 reports generated from a legacy Database to 500 consolidated reports generated from an Oracle 11.2 Enterprise Data Warehouse.
• Analyzed/Documented the initial reporting requirements and managed the detailed data analysis by the US and Off-shore Technical staff.

Confidential

Senior Data Modeler

• Defined the initial Data Architecture, Data Governance, Data Naming Standards and Conventions, Data Flow Diagrams, Data Requirements and initial deliverable template formats for a new Oracle 11.2 Business Intelligence BI Enterprise Data Warehouse EDW Project.
• Initiated and participated in the Data Modeling tool research, analysis and selection process. Computer Associates CA Erwin 9.xand Embarcadero ERStudio Data Architect 9.7 were considered.

Confidential

Senior Data Modeler/Architect

• Performed design, detailed data analysis, mapping, logical design intranet Adobe PDF documentation and physical data modeling for 2 proposed Oracle 11 Health Insurance Provider Information Management Systems Databases, using the CA Erwin R 8.2 data modeling tool and McKesson Insurance Provider third party application structures.
• Supported additional requirements to Generate Data Model updates using CA Erwin R 7.3 for member, benefit, claims, and provider data for 12 integrated Data Marts of the Rosetta Systems Databases and made additional updates to the Jive Database Data Model.

Confidential

Senior Data Modeler/Architect

• Performed design, detailed data analysis, mapping, logical design and physical data modeling for a proposed Oracle 11 Automobile Manufacturing Financial Enterprise Data Warehouse EDW and Roadside Assistance Insurance Data Store, using the CA ERwin R 8.2 data modeling tool. HCA is a comprehensive Financial Enterprise covering Automobile Retail, Lease and Supporting Insurance Systems.
• The EDW was designed and was compatible with the Oracle Financial Services Data Foundation OFSDF product family.

Confidential

Senior Data Architect

• Performed detailed data analysis, mapping, logical design and physical data modeling for 130 DB2 9.5-7 and MS SQL Server 2008 database schemas using the ERwin V 7.3 and R 8.2 data modeling tool.
• Analyzed and enforced corporate naming standards and new enhancement requirements for Auto and Fire Insurance related systems.
• Designed a fully attributed Enterprise Customer Data Warehouse. Lead the testing and conversion processes to convert all current Erwin 7.3 corporate ERDs to the Erwin R8.2. Data modeling tool.
• On a daily basis, I altered Forward Engineered DDL code to conform to corporate Database requirements and was responsible for Quality Assurance reviews of Data Architecture Team deliverables.

Confidential

Senior Data Architect

• Performed detailed data analysis, mapping and data modeling Cannonical, Conceptual Logical and Physical for the Property, Party, Role and Auction Subject areas for the re-design of all Enterprise Databases, Using ErWin V 7.3.
• Analyzed needs and requirements for converting the existing Corporate MYSQL 5.0 databases to Oracle 11G and proposed IT systems upgrades to support future corporate data related requirements. Consolidated and generated corporate business definitions, standards and naming conventions to enhance on-going Enterprise Database processes.

Confidential

Senior Data Modeler

• Assigned to perform data analysis and data modeling Canonical, Conceptual Logical and Physical for the Battle Red Development Project, Contract Proposal Subject areas of the new Enterprise Data Warehouse, using the ErWin V7.3 data modeling tool .
• Analyzed needs and requirements of existing and proposed IT systems to support data related requirements.
• Consolidated and generated database standards and naming conventions to enhance Enterprise Data Architecture processes.

Confidential

Senior Data Modeler

• Assigned to perform data analysis, metadata mapping documents, data based diagrams and design conceptual, logical and physical data models for the International Sales, Marketing and Commissions subject areas of the Enterprise Data Warehouse, using the ErWin data modeling tool. Provided installation support to data integration and corporate DBA Teams.
• Analyzed needs and requirements of existing and proposed IT systems to support data related requirements. Supported existing database standards and naming conventions to enhance corporate data dictionaries.

Confidential

Senior Data Warehouse Architect

• Assigned to the primary responsibility for supporting Lockheed/Martin in maintaining the Naval Standard Integrated Personnel System NSIPS - the naval equivalent of HR and assignments/training systems Analytics Data Warehouse data models using the ErWin 7.3 data modeling tool.
• Provided support to the Operations Support and DBA Requirements analysis Teams. Designed, modeled documented, and guided the logical and conceptual relationship of data and database changes for complex applications.
• Analyzed needs and requirements of existing and proposed systems and developed technical, structural and organizational specifications.
• Created standards and naming conventions to enhance capacity and systems performance.

Confidential

Data Warehouse Architect

• Assigned to the Enterprise Data Warehouse Project responsible for data research, analysis, metadata definition, data mapping, and ErWin logical and physical data modeling for the Billing Detail/Tax Audit Data Mart and the Acxiom 3rd party providing Demographic data interface and usage in the MS SQL Server and Oracle Business Intelligence BI Enterprise Data Warehouses EDWs .

Confidential

Data Warehouse Architect

• Assigned to the Enterprise Data Warehouse Project responsible for data research/Analysis/metadata definition/Data Mapping and logical and physical Data Modeling using CA AllFusion Erwin Data Modeler for the EDGE Enterprise Data Gathering Engine NCR Teradata V 6.0 Enterprise Data Warehouse.
• Responsibilities included migration and integration strategies for corporate production databases i.e., migration/integration of data from recently merged corporate acquisitions formerly Bell Atlantic, Nynex and GTE logical and physical design for both Operational Data store ODS and Dimensional/Hierarchical Data Warehouse data structures.
• Generated data source-to-target mapping documents and data model change control processes. Additional responsibilities included developing Business Processes for change control and configuration management of the Enterprise Data Warehouse.

Confidential

Data Warehouse Architect

• Assigned to the Enterprise Data Warehouse Project responsible for data research/Analysis/metadata definition/Data Mapping and logical and physical Data Modeling using PowerDesigner 10.0 for the DB2 Claims Subject Area.
• Responsibilities included generating the Integrated i.e., integrating the 10 blue Cross and Blue Shield company State data warehouses owned by Wellpoint logical and physical design for both Operational Data store ODS and Dimensional Data Warehouse data structures.
• Developed data source-to-target mapping documents, data model change control processes and assisted other data architects with customized use of the PowerDesigner modeling tool.
• Exposure to the Evoke Axio data analysis and integrity tool and the Rochade metadata repository tool.

Confidential

Data Analyst

• Assigned to the Data Management Team responsible for Data Research/Analysis/Data Modeling.
• Primarily responsible to support development projects that are migrating the corporate Network Platforms from Circuit to Packet technologies.
• The primary focus of this assignment was to integrate Accenture developed Objectel/Metasolve and Nortel Access Care Systems applications and their Database/Data Warehouse structures to support the Sprint Network requirements.

Confidential

Data Warehouse Analyst

• Participated in various Business and Data Analysis tasks supporting new releases of the Enterprise Data Warehouse.

Confidential

Data Warehouse Adviser

• Advised ACS consultants in Business Process, Informatica Extract, Transformation, Load specifications, data analysis, logical and physical design of Medicare and Public Assistance Subject Areas, and source-to-target data migration strategies in support of a new Oracle Information Warehouse with a Business Objects and SPSS reporting and query front end. Conducted and participated in several JAD video teleconferencing sessions to understand required data structures. Utilizing the ErStudio data modeling tool, the target design included 4 database platforms: Non-normalized Staging Area, 1NF -3NF Operational Data Store /Summary Reporting Database and the fully integrated Dimensional Information Warehouse. Analyzed and documented data requirements to support Federal and State of NJ legislative mandates e.g., HIPPA and Personal Responsibility and Work Opportunity Reconciliation Act of 1996 .
• Advised client on Data Warehouse strategies and structures based on Ralph Kimball dimensional constructs and the Bill Inmon Government Information Factory Methodology.
• Developed data architecture approaches for Mississippi and Georgia State Government Projects.
• Developed an in-house Multi-dimensional Data Warehouse training course for client data architects.

Confidential

Data Warehouse Analyst

• Responsible for data analysis, logical and physical design of several subject areas Human Resources, Generated Electrical Power and Business Unit Performance Measurement of a new DB2 Data Warehouse.
• The Data Warehouse was structured using the Bill Inmon Corporate IT Factory Methodology and the logical design was integrated into the Corporate Enterprise Model.

Confidential

Data Architect

• Responsible for the analysis, logical and physical design of the Patient Management System DB2 Data Mart using the Cool Gen modeling data tool for the largest health insurance company in the USA.

Confidential

Data Architect and Business Analyst On-going Part time support

• Responsible for on-going Systems Analysis, Logical and Physical Database design using the ErWin data modeling tool for several Web based E-Commerce/B-B Applications for an Internet startup company.

Confidential

Data Architect

• Responsible for Logical and Physical Data Model development using Sybase PowerDesigner modeling tool and MetaWorks Repository 6.15 and 7.5 . Converted 5 MS Access databases to an Oracle 8i platform.
• Responsible for the Logical and Physical Design of the Private Label Services Billing Invoicing, Invoicing Reference, Reporting and Customer Business Billing Enterprise Reporting areas for a major conversion from the Converges to Amdocs Wireless Billing Systems project.
• Developed and administered the Change Control Process for corporate Billing databases/data models and reverse engineering processes.
• SBQA Sprint PCS Billing Quality Assurance Billing Verification Capacity Analysis Project
• Rodeo PLS Private Label Services and Business Billing and Invoicing Conversion Projects

Confidential

Business Process and Data Analyst

• Responsible for analysis and development of the AOL Corporate Information and Business Systems Landscape Design deliverables were data and process flow charts and applicable metadata documentation .
• This short term assignment involved frequent travel between AOL and Netscape Communications locations to understand, document, and create an integrated Enterprise view of those recently merged entities.

Confidential

Data Architect

• Responsible for development of a Metadata design and capture process for an International Enterprise Level Operational Data Store. Designed and Developed a Decision Support Multi-dimensional Data Warehouse. Enterprise responsibility for Meta Data definition and the Overall Logical/Physical Relational Database designs using ER/Win 5.3.2 for Corporate DB2 databases.
• Marketing, Accounting Customer Services System MACSS Database Metadata design.
• Marketing, Accounting Customer Services Multi-dimensional Data Warehouse MACSSDW .

Confidential

Data Architect and DBA Manager

• For the Judicial Case Management Department, was responsible for the final design and implementation of an integrated Judicial Case Management System i.e., Supreme, Commonwealth, and Superior Courts Data Base design and Development.
• Management responsibility for the Overall Logical/Physical Relational Database design using PowerDesigner 6.0 for a Sybase 11 database with a MS Visual Basic and Crystal Reports front end.
• State of Pennsylvania Unified Judicial Case Management System Database.

Specialized experience:

Methodology: Kimball Data Warehouse Toolkit Bill Inmon Corporate and Government Information Factory IDEF0 IDEFIX Anderson Consulting METHOD 1 Warnier/Orr Yourdon/Constantine James Martin Information Engineering.

Databases: My SQL 5.z ORACLE 7.x 11.x NCR Teradata V 6.0 MS SQL Server 6.5 and 2008 ACCESS 7.0 INFORMIX, SYBASE 10 11 SQL Anywhere WATCOM Pilot Lightship OLAP MicroStrategy DSS Agent/Architect ROLAP Business Objects SPSS Teradata IBM DB2 V9.5 and 9.7 IMS IDMS 12 RBASE AS/400 MODEL 204.

Telecommunications Packages: Amdocs Ensemble Billing Systems, Nordik Telecom billing s/w, Nortel Access Care network application , Accenture Objectel packet applications Converges Telecom Billing System.

Software Tools: CA ERwin 7.3.11- R8.2.x, Cool:Gen, BP/Win 2.5 TestBytes1.0 PowerDesigner and MetaWorks 6.0 through 7.5 Toad for DB2 4.7 Oracle SQL Developer, Evoke Axio, Rochade Repository, Informatica Abinitio Embarcadero ER/Studio 5.1, 9.7x Cayenne GroundWorks 2.2.1 BACHMAN PowerBuilder 5.0 InfoMaker MS: Office Professional IBM Lotus Notes and Suite MS Visual Basic 5.0 Project SQL COBOL FORTRAN MVS/JCL S.P.S.S. TSO/ISPF.

Hardware: IBM Mainframes Pentium PCs AS/400 SP2 SUN SPARC CDC UNIVAC DEC VAX.

Operating Systems: IBM OS/MVS/VM MS WINDOWS NT, 3.1, 95, DOS 6.2 Various UNIX.

Security Clearances: Top Secret/SBI Special Background Investigation . Not current .