SUMMARY:

• I have over 20 years combined experience in Data Governance, Data Architecture, Logical and Physical Database Design, Data Services, Facilitating JAD Sessions, Business Analysis, ErWin, ACORD, ErStudio, Data Warehouse Architect, Dimensional Data Modeling, and Kimball Data Warehousing Data Mart design for Data Warehouse, Gap Analysis, Object and Relational Data Mapping, Data Modeling, Master Data Management (MDM),Data Administration, Metadata, Data Cleansing, Data Dictionary, Health Care Insurance and Confidential at Confidential, Confidential, Confidential, Confidential and for the - Army Medical Project/Army Medical Clinical Trials, Financial Services (SAP environment) at the Confidential in Washington DC and Confidential Credit Card, International Shipping at APL, Project Management, SDLC, Project Management, Data Architecture and Confidential and Payor experience at Mass Mutual.
• I have over 18 years of strong experience as a Senior Consultant, Data Governance, Business Analyst, Information Engineer, Requirements Analyst, Financial Systems Analyst, Financial Systems Data Modeler, Data Modeler, Gap Analysis, Master Data Management (MDM), Data Administrator, Manual Data Cleansing, Metadata, Data Dictionary, Object and Relational Data Mapping, Process Modeler and Junior Database Administrator (DBA).
• I also have expertise in Data Warehouse Architect and Kimball Data Mart design, logical data modeling in the 3rd Normal Form using IDEF1X, Process Modeling using IDEF0, ER/Studio, ErWIN/ERX CASE Tool, IEF CASE Tool, BP/Win, creating and reviewing Use Cases, SAP and CLARIFY.
• I have strong experience in developing and implementing fully normalized, Physical Models, Oracle Physical Databases (RDB), DB2, Sybase RDB and Informix RDB using ER/Studio and ErWIN/ERX CASE Tools.
• I have experience working in Relational Development environments.
• I am a Strategic Systems Architect, Information Engineering, Business Area Analyst, Systems Re-Engineer, Data Modeler, Requirement Analyst, Process Modeler and JAD Workshop Facilitator.
• I am also experienced in logical data modeling in the 3rd Normal Form and logical data mapping, at the entity level, to the physical database.

TECHNICAL SKILLS:

Technology and Tools: Business Process Reengineering Process Redesign Business Area Analysis Gap Analysis Use Cases Requirements Analysis Data Administration Master Data Management (MDM) Project Management Data Modeling IDEF1X IDEF0 Information Engineering JAD:GroupWare QUERY TOOL:Brio Query ADDITIONAL TOOLS:Toad Visio

PROFESSIONAL EXPERIENCE:

Confidential, Seattle WA

Senior Level Data Architect and Project Manager

Responsibilities:

• Assigned to MS SAP HR MDM Project. Responsible for providing Data Services for HR Project. I provided a simplified, integrated view of real-time, high-quality information about a specific SAP HR business entities, such as a Customer. Analyzed, mapped diverse sets of information resources, including operational systems, operational data stores, data warehouses, content repositories, collaboration stores, and even streaming sources in advanced cases. I also provided Master Data Management (MDM) Customer Data Integration (CDI) participating in Data Modeling, JADs, Data Mapping and review sessions. During my assignment I also acted as an Information Architect. Additional responsibilities included source to target mappings, creating Business Conceptual Models, Logical Data Models and Physical Models. Facilitated Model Review and Mapping Sessions. Collaborated in final solutions recommendations for HR Systems consolidations.

Confidential, Philadelphia

Mid-Level Data Warehouse Architect

Responsibilities:

• Responsible for creating Data Warehouse and Kimbal Data Mart designs using ErWin. Senior Data Modeler and Database Designer. Experienced in using Netezza to compare, update and create SQL scripts using. Knowledgeable in comparing Netezza DBs to ErWin Models. I am also responsible for performing Gap Analysis reviews, Data Analysis, Data Model reviews, Data Mapping and Project Management.

Confidential, Heights NJ

Responsibilities:

• Responsible for implementing Data Governance and Master Data Management (MDM) program for Multi-National Insurance Project. I am also responsible for performing Gap Analysis reviews, Data Analysis, Data Model reviews, Data Mapping and Project Management.

Confidential, Parsippany, NJ

Data Modeler/Data Architect/Project Manager

Responsibilities:

• I perform Gap Analysis reviews, Data Analysis, Data Model reviews, Data Mapping and Project Management. I am also responsible for analyzing and designing of As-Is Data Model and To-Be Dunn & Bradstreet Enterprise Business Logical Data and Physical Models utilizing Teradata Mappings Reports. I assist in identifying Data Gaps in various projects. I act as Process Facilitator for all projects on team and am responsible for ensuring that changes are being completed in a timely manner. I am responsible for identifying risks and issues for all assigned projects.

Confidential, Minneapolis, MN

Data Modeler/Data Architect

Responsibilities:

• I am responsible for ensuring that their Data Architecture and Data Administration Standards are followed and enforced. I am also responsible for Data Governance, data analysis and data mapping of Health Care Insurance and Confidential related data. I create, update and maintain logical data modeling in the 3rd Normal Form using IDEF1X and ER/Studio. ERD and Entity-Relationship Modeling using ErWin. Queried data using Teradata.

Confidential, Denver, CO

Modeler/Data Architect

Responsibilities:

• I am responsible for performing Data Governance, data analysis, business, analysis, conducting JAD sessions with Subject Matter Experts, Metadata Management, Manual Data Cleansing, updating Metadata Repository, Netezza and data modeling of my assigned business area. Review and create Use Cases and Technical Documents. Created and maintained Staging and Target Tables for Data Warehouse. I am also responsible for analyzing and designing of As-Is Data Model and To-Be Dish Enterprise Data Models using ER/Studio. I am also responsible for identifying business areas for improvements in the Conceptual and Enterprise Level Data Models. I create ERD and Entity-Relationship Modeling. I have also been responsible for creating Data Flow Diagrams and conducting JAD Sessions. Maintenance of existing Logical and Physical Models and the responsibility for consolidating of Models was also in my job requirements.

Confidential, Somerset NJ

Data Architect

Responsibilities:

• Performed Data Governance and data quality analysis of Corporate Level data. Acted as Data Architect and Data Modeler on assigned Projects. I am also responsible for setting data standards, performing data analysis, business, analysis, conducting JAD sessions with Subject Matter Experts and data modeling of my assigned business area. Master Data Management (MDM), Object and Relational Data Mapping. Oracle Physical Database Design Modeling. DA Team Leader for various HP Projects. I create, update and maintain logical data modeling in the 3rd Normal Form using IDEF1X and ER/Studio. ERD and Entity-Relationship Modeling using ErWin.

Confidential, Springfield MA

Data Governance/Data Modeler

Responsibilities:

• As a member of Insurance and Confidential Data Governance/Data Modeling team assigned at Mass Mutual, I am responsible for Data Warehouse Architecture and Dimensional Data Modeling for Data Warehouse design. I am also responsible for performing Gap Analysis reviews, Data Analysis, Data Model reviews, Data Mapping and Project Management. I am responsible for ensuring that their Data Governance, Data Architecture and Data Administration Standards are followed and enforced.
• Created and maintained Staging and Target Tables for Data Warehouse. Enforcing data standards and BPR for various business areas. I am also responsible for data analysis and data mapping. I create, update and maintain logical data modeling in the 3rd Normal Form using IDEF1X and Erwin. Participating in JAD sessions. Mapped Objects to Relational Elements in Model. Software tool evaluation. Acted as backup Vendor Liaison during software tool evaluation. Acted as Project Manager for assigned Data Modeling Projects. ERD and Entity-Relationship Modeling using ErWin for Confidential and Payer business areas.

Confidential, Hartford, CT

Data Governance/Data Modeler Consultant

Responsibilities:

• As a member of Insurance and Confidential Data Modeling team assigned at CignaI am responsible for ensuring that their Data Architecture and Data Administration Standards are followed and enforced.
• I am also responsible for Data Governance, data analysis and data mapping of Confidential data.
• I create, update and maintain logical data modeling in the 3rd Normal Form using IDEF1X and ER/Studio.
• ERD and Entity-Relationship Modeling using ErWin.

Confidential, Oakland, CA

APL Data Governance/Data Modeler Consultant

Responsibilities:

• As a member of Data Modeling team assigned at APLI am responsible for ensuring that APL's Data Governance, Data Architecture and Data Administration Standards are followed and enforced.
• I am also responsible for setting data standards, performing data analysis, business, analysis, conducting JAD sessions with Subject Matter Experts and data modeling of my assigned business area.
• I create, update and maintain logical data modeling in the 3rd Normal Form using IDEF1X and ER/Studio.
• ERD and Entity-Relationship Modeling using ErWin.

Confidential, San Francisco, CA

Data Governance/Data Architect Consultant

Responsibilities:

• As a member of a team of Insurance and Confidential Data Architects assigned to Confidential Dental's Enterprise Streamlining ProjectI am responsible for ensuring that the ESP Data Architecture is coordinated with the Confidential Dental Enterprise Data Architecture and Confidential ’s Data Governance.
• I am also responsible for setting data standards, performing data analysis, business, analysis, conducting JAD sessions with Subject Matter Experts and data modeling of my assigned business area.
• I create, update and maintain logical data modeling in the 3rd Normal Form using IDEF1X and ErWin.
• I also ensure that current data model entities and attributes comply with data model standards.
• ERD and Entity-Relationship Modeling using ErWin.

Confidential, San Francisco, CA

Data Governance/Data Architect Consultant

Responsibilities:

• Assigned to Re-Engineer Confidential Credit Card Confidential (GPP) Pre-Paid Card Financial System. I am responsible for performing Data Governance, data analysis, business, analysis, conducting JAD sessions with Subject Matter Experts, Metadata Management, Manual Data Cleansing, updating Metadata Repository and data modeling of my assigned business area. Also responsible for analyzing and designing of As-Is Data Model for GPP Financial System that currently resides on AS400 mainframe. Identify business areas for improvements for the Conceptual Data Model. Data Administration.
• Participate in project management. ERD and Entity-Relationship Modeling using ErWin.

Confidential, Oakland, CA

Data Governance/Business Analyst Consultant

Responsibilities:

• Use Case Design and development, performing Requirement Analysis, Business Analysis and Data Analysis of National Medicare Finance (NMF) data, Prescription Drug Event (PDE) Record Data, Pharmacy Claim Data, Data, True Out-Of-Pocket Expense (TrOOP) Data, Manual Data Cleansing and MMA Reporting Data.
• Create Concept and Event Response Diagrams, Use Case Business Designs and Initial Data Element List for KP MMA / Part D Benefit Program.
• Participate in MMA Report Requirements Workshops and Data Governance.
• Investigate and gather MMA data elements for NMF Standard Reports and Data Submission.
• Create MMA Initial Data Element documentation.
• Identify data groupings. Identify data sources.
• Identify data needed of each NMF Reporting.
• ERD and Entity-Relationship Modeling using ErWin.

Confidential, Alexandria, VA

Consultant

Responsibilities:

• Website designer.Responsible for designing and preparing content for the World Wide Web, including text, images and site architecture. Leverage the client's brand identity in a web-specific way.Foresee what visitors will want to do on the site and create navigational interfaces that facilitate those needs.Establish the look and feel of web pages, including typography, graphics, color, layout, and other factors.

Confidential, Arlington, VA

Data Governance/Data Architect Consultant

Responsibilities:

• Create Business Data Model for ABC, CBS, FOX, CNN and NBC Voter News Service (VNS) Board of Directors.
• Acted as Vendor Liaison for the data modeling team with the client Voter News Service. Document current Business Systems Design and Architecture in an Object Oriented and Oracle back end development environment for VNS.
• Create and maintain fully normalized Enterprise data models and logical data models.
• Create and maintain entity relationship diagrams (ERD) by applying IDEF1X techniques using various ErWin CASE Tools.
• Transform user's business requirements into business assets in the form of client/server systems.
• Define system requirements as entities, attributes and relationships.
• Evaluate and choose the appropriate design options for complex entities, attributes and relationships.
• Document business rules.
• Maintain the data repository.
• Perform quality analysis, Manual Data Cleansing and scrubbing of data and metadata.

Confidential, Falls Church, VA

Data Governance/Financial Systems Analyst

Responsibilities:

• Performed Data Governance. Created and maintain data models for Data Warehouse. Create and maintain entity relationship diagrams (ERD) by applying advanced formal data modeling concepts and techniques using various CASE tools. Transform user's business requirements into business assets in the form of client/server systems.
• Define system requirements as entities, attributes and relationships. Evaluate and choose the appropriate design options for complex entities, attributes and relationships. Document business rules.
• Maintain the data repository. Perform quality analysis, Manual Data Cleansing and scrubbing of data and metadata. Compare and synchronize different data models and ERD. Perform Business Area Analysis and Financial systems Analysis.
• Facilitate data modeling workgroup sessions. Produce system documentation. Create and maintain logical naming standards. Interview Functional Area Experts.
• Acted as Project Manager for assigned Data Modeling Projects.
• Vendor Liaison for the Red Cross and Software Vendor.
• Evaluate and recommend CASE Tools and other relevant software to resolve customer Business Systems Design requirements. Document current Business Systems Design and Architecture for SAP and CLARIFY and Object Oriented front ends and Oracle and DB2 back end development and database environments. Analyze as-is Business System Design and Architecture.

Confidential, McLean, VA

Requirements Analyst

Responsibilities:

• Perform Data Governance, Business Area Analysis. Facilitate JAD sessions. Analyze knowledge of the Telecommunications business, including defining what fields of information will be grouped together, to the business data in the database systems. Work closely with the user to develop Telecommunications Business Requirement Reports.
• Design database queries and reports using Brio Query. Participate in the analysis phase of the system development cycle. Project Management - Responsible for scheduling and planning the Requirements development. Establish time frames for completion of the project. Set priorities for the work to be done.

Confidential

Data Governance and Business Analyst

Responsibilities:

• Create and maintain entity relationship diagrams (ERD) by employing IDEF1X modeling concepts and techniques using various CASE tools. Transform user's business requirements into business assets in the form of client/server systems. Define system requirements for Army Medical Clinical Trials entities, attributes and relationships.
• Evaluate and choose the appropriate design options for complex entities, attributes and relationships. Document business rules. Maintain the data repository. Perform quality analysis, Manual Data Cleansing and scrubbing of data and metadata. Compare and synchronize different data models and ERD. Perform Business Area Analysis.
• Vendor Liaison for the Department of Defense Vendor and Government Programs. Facilitate data modeling workgroup sessions. Produce system documentation. Create and maintain logical naming standards. Interview Functional Area Experts.

Confidential, Rockville, MD

Data Governance/Data Architect

Responsibilities:

• Responsible for Data Governance and performing the pre-conversion analysis of converting the existing Sales and Marketing Oracle data and database structures. Analyzed the impact of conversion of the database structures, datatypes and data. Created SQL scripts and recommended solutions to conversion problems. Evaluate and choose the appropriate conversion design options for complex entities, attributes and relationships using IDEF1X.
• Create data models and design Oracle database structures. Create and maintain physical naming standards for each database. Document the physical naming standards. Create and maintain entity relationship diagrams (ERD) by applying advanced formal data modeling concepts and techniques using various CASE tools.
• Forward and re-engineer Oracle databases.
• Acted as Project Manager for assigned Data Modeling Projects.

Confidential, Dulles, VA

Financial Systems Analyst/Consultant/ Data Governance/Data Architect

Responsibilities:

• Data Governance Project Manager for the establishment and implementation of Physical Naming Standards Project and the Meta-Data Repository Project. I created and maintained physical naming standards for each of the Momentum Financial databases. I documented the physical naming standards and created the meta-data repository. Directed team effort to recreate existing Momentum Financial Oracle and Sybase databases using the new physical naming standards. I created and maintained entity relationship diagrams (ERD) by applying advanced formal data modeling concepts and techniques using various CASE tools. Forward and re-engineer Oracle and Sybase databases. Created Power Designer and Erwin Data Dictionaries. Lead team effort to define entities and attributes for the Meta-Data Repository.
• I was also the Team Leader for the Analysis Phase Project of the Informix Database Conversion Project. I was responsible for performing the pre-conversion analysis of converting the existing Momentum Financial Oracle database to a Momentum Financial Informix database using IDEF1X. I analyzed the impact of conversion of all the database structures, datatypes and data. I recommended solutions to conversion problems. I evaluated and choose the appropriate conversion design options for complex entities, attributes and relationships.

Confidential, McLean, VA

Data Governance/Data Architect

Responsibilities:

• Transform user's business requirements into business assets in the form of client/server systems. Define system requirements as entities, attributes and relationships. Evaluate and choose the appropriate design options for complex entities, attributes and relationships. Forward and re-engineer Oracle databases.
• Data Governance which included mapping the data model, at the entity level, to an initial database table design. Document business rules.
• Maintain the data repository. Perform quality analysis and scrubbing of data and metadata. Compare and synchronize client application and database servers. Compare and synchronize different data models and ERD. Perform Business Area Analysis. Facilitate data modeling workgroup sessions. Produce system documentation. Create and maintain logical naming standards. Interview Functional Area Experts.
• Perform Oracle Database Administration (DBA). Write SQL scripts and queries. Create SQL tables. Define the system architecture of the Oracle 7.3 server. Provide strategic planning and implementation of information technology solutions. Design Oracle databases. Install, create and maintain Oracle 7.3 Relational Database (RDB) and data dictionary. Configure the system for heterogeneous network environments when additional software options are required. Perform database performance tuning. Create and maintain physical schema. Manage data. Monitor system performance. Implement basic security and data integrity measures. Enroll, monitor and maintain database users. Manage access to data by granting privileges to individual users. Support end users. Create and maintain physical naming standards.

Confidential, Washington, DC

Senior Consultant Information Engineer/Oracle DBA/Data Modeler

Responsibilities:

• Perform Oracle Database Administration (DBA). Write SQL scripts and queries. Create SQL tables. Define the system architecture of the Oracle 7.3 server. Provide strategic planning and implementation of information technology solutions. Design Oracle databases. Install, create and maintain Oracle 7.3 Relational Database (RDB) and data dictionary. Configure the system for heterogeneous network environments when additional software options are required. Perform database performance tuning. Create and maintain physical schema. Manage data. Monitor system performance. Implement basic security and data integrity measures. Enroll, monitor and maintain database users. Manage access to data by granting privileges to individual users. Support end users. Create and maintain physical naming standards.
• Create and maintain fully normalized logical data models. Create and maintain entity relationship diagrams (ERD) employing Information Engineering and IDEF1X modeling concepts and techniques using various CASE tools. Transform user's business requirements into business assets in the form of client/server systems.
• Define system requirements as entities, attributes and relationships. Evaluate and choose the appropriate design options for complex entities, attributes and relationships. Forward and re-engineer Oracle databases. Map the data model, at the entity level, to an initial database table design.Document business rules. Maintain the data repository. Perform quality analysis and scrubbing of data and metadata. Compare and synchronize client application and database servers. Compare and synchronize different data models and ERD. Perform Business Area Analysis. Facilitate data modeling workgroup sessions. Produce system documentation.Create and maintain logical naming standards. Interview Functional Area Experts.

Confidential, Falls Church, VA

Senior Information Engineer / Oracle DBA / Data Modeler

Responsibilities:

• Perform Data Governance and Oracle Database Administration (DBA). Define the system architecture of the Oracle 7.3 server. Provide strategic planning and implementation of information technology solutions. Process Change Requests. Design Oracle databases. Install, create and maintain Oracle 7.3 Relational Database (RDB) and data dictionary. Configure the system for heterogeneous network environments when additional software options are required. Perform database performance tuning. Create and maintain physical schema. Manage data. Monitor system performance. Implement basic security and data integrity measures. Enroll, monitor and maintain database users. Manage access to data by granting privileges to individual users.
• Support end users. Create and maintain physical naming standards.Vendor Liaison for the Department of Defense Vendor and Government Programs.
• Perform the duties of a Senior Functional Analyst and Data Administrator for a full life-cycle development project. Develop detailed functional specifications, system specifications and program specifications using Information Engineering, IDEF1X, ErWin and IEF CASE tools. Works directly with management and users to analyze specify and design business applications. Utilize data modeling techniques to analyze and specify data usage within an application area. Responsible for defining both logical views and physical data structures. Administers and controls an organization's data resources. Utilize data dictionary software packages to discover corrupted data and eliminate data redundancy and tuning tools to improve database performance.
• Maintain and update data models. Create description files for entities and attributes that include entity names, definitions, attribute names, definitions and metadata. Work directly with systems analysts to write and edit system documentation, user manuals, courses and procedures. Prepare proposals and technical reports. Responsible for creating reports that included entity names and definitions, attribute names and definitions for submission into DDDS. Perform cross-functional reviews of proposal packages submitted to DESCIM for in corporation into DOD's Enterprise Data Dictionary. Prepare ErWIN ERD strawman model for functional area. Review functional requirements in preparation for ERD strawman model. Initiate and coordinate preparations for Toxic Substance GroupWare sessions that included creating text files for the facilitators that include entity names, definitions, attribute names, definitions and relationships. Facilitate GroupWare modeling sessions.

Confidential, Arlington, VA

DATA ADMINISTRATOR/ INFORMATION ENGINEER/ DATA MODELER

Responsibilities:

• Perform Data Governance, business area analysis, data administration, information engineering and data modeling in support of the DOD Corporate Information Management/Business Process Improvement Program (CIM/BPIP) for the Department of the Army's Human Resource (Personnel & Readiness (P&R)) military project.Reverse engineered HR source code into logical elements for analysis and integration into P&R logical data model. Perform data repository management and quality assurance of data. Design, develop and analyze HR data models. Participate in subject matter expert workshops to determine and obtain descriptive HR data element definitions and to evaluate data analysis of source data. Produce new documentation from data analysis. Maintain HR logical data models, structured diagrams and entity-relationship diagrams. Map source data elements to logical elements for use in data dictionary.Developed re-engineering strategies using IDEF1X and ErWIN/ERX CASE tool.

Confidential, Suitland, MD

COMPUTER SPECIALIST/ INFORMATION ENGINEER/ DATA GOVERNANCE/ DATA MODELER

Responsibilities:

• Vendor Liaison for the Department of the Navy and Program Vendors. Provide Data Governance, business area analysis, data administration, and information modeling in support of the DOD Corporate Information Management/Business Process Improvement Program (CIM/BPIP) for the Department of the Navy's (DON) Data Administration (DA) program. Plan, direct and manage the implementation phase of the DON DA program. Provide program and project management for DON. Establish Plan of Actions and Milestones (POA&M) using MS Project Manager for the DA program.
• Provide quality assurance of source data in Naval databases. Responsible for performing quality analysis and control of logical data models.Produce data standards and structures' manuals, plans and meeting reports.Coordinate formal responses to DOD and DON manuals, policies and candidate data element reviews.Brief Senior Staff members on project status. Participate in subject matter expert workshops to determine descriptive data element definitions and to evaluate data analysis of source data. Maintain logical data models, structured diagrams and entity-relationship diagrams. Additionally, develop re-engineering strategies IDEF1X and ErWIN/ERX CASE tool.