PROFILE SUMMARY:

IT veteran having advanced Operational / Business Intelligence design skills and Governance experience in areas such as Gov't Services, Finance, Investment Banking, Automotive/Aircraft Mfg., Medical Records, Utilities and Insurance. Excels in data architecture, logical & physical data modeling, metadata design/profiling and master data management design. Worked very closely with many Industry Thought Leaders particularly in the BI, Analytic, Metadata, Master Data and Data Governance spaces.

SKILLS:

ERWin

Architecture Design

Architecture Frameworks

Architecture Governance

CA - All Fusion

Data Architectures

Embarcadero - ER/Studio

Enterprise Architecture

Enterprise Architecture Managed Services

Enterprise Architecture Planning

High Level Enterprise Architecture Design

Sybase-Power Designer

Oracle SQL Developer Data Modeler

Microsoft SQL Server Designer Studio

JOB EXPERIENCE:

Confidential

Senior Data Modeler

Responsibilities:

• Senior Data Modeler / Architect for Program Momentum, a 5 - year multi-project master plan to integrate all the company product investment data at an enterprise scale.
• Charged and successfully designed an Enterprise Logical Data Model to merge the private sector Retirement Plans information with the public sector Retirement Plans information for reporting consumption using an existing single application that was predesigned just for public sector.
• Facilitated design workshops with business SME’s identifying and prioritizing stakeholder pain points, needs and requirements.
• Identified and created the use-cases / stories necessary for all data design flows and quality assurance testing.
• Incorporated data lineage and requirement traceability mapping tracing data and requirement evolution.
• Successfully designed the Logical Data Model underpinning core PRODUCT business subject areas instrumental to the sharing of the PRODUCT data for use across the entire enterprise.
• Created source to target gap mapping and logic, profiled sources of record to determine a data quality baseline and documented the Logical Data Model’s glossary.
• Assisted in the facilitation and authorship of a Metadata Strategy to support the sharing of the core PRODUCTS.

Confidential

Data Architect

Responsibilities:

• Experienced in creating a centralized master data hub solution
• Defined Data Hub modeling tool usage guiding principles, roadmap, modeling methodology and all necessary methodology templates.
• JDE Instance for centralized master data hub
• Supported the definition of and created the conceptual data model and corresponding logical data model for first key data object area (e.g. customer) using Oracle Data Hub, Oracle SQL Developer Data Modeling Tool, JDE Master Data, combined with Data Modelling Experience.

Confidential

Senior Enterprise Architecture Data Modeler

Responsibilities:

• Served as Lead Data Modeler on an internal project.
• Responsible for and successful in creating the logical data for specific business subject areas.
• Provided recommendations to improve data quality through the use of data profiling.
• Was action oriented and good client communication skills as role required direct interaction with the business and development teams through the facilitation of model design workshops.
• Created conceptual, logical and physical data models.

Confidential

Business Analyst/Governance Consultant

Responsibilities:

• Was responsible for working with the client on the Governance initiative to establish a new BI/Shared Analytics Center of Excellence.
• Responsibilities included working with the Confidential to conduct the following activities: a) the provision of services to manage the Confidential ’s Leadership Alignment activities and communications, b) set up the structure to review and prioritize BI/Shared Analytics projects, c) provide a framework to drive awareness and demand for the BI/Shared Analytics services, and d) establish a scalable structure and methodology to support growth of the Confidential ’s Enterprise Data Warehouse environment and resulting BI Analytics space.

Confidential

Data Architect

Responsibilities:

• Modeled the extension of the Sales Force EDW models to include quotes and unified the current business products with master data.
• Worked with Business Analysts and customers collecting, organizing, profiling and analyzing sales data to validate user-stories and identify key existing design issues.
• Proposed a modeled future- Confidential to mitigate issues identified and made recommendations for proceeding to implement future Confidential .
• Wrote the necessary business, technical and user specifications and documentation to achieve an appropriate business solution.
• Configured the data modeling environment to allow concurrent parallel model development, model conflict resolution and model versioning management by way of a successful architected installation of the modeling toolsets.
• The concurrent-development produced a development reduction time savings when modeling solutions.

Confidential

Data Modeler

Responsibilities:

• Redesigned current Mortgage Banking data model to correct and in corporate BI best-practice logical and physical design principles.
• Profiled current design to identify GAP issues and to determine the quality of the sources of incoming data.
• Worked in tandem with Business Analysts to identify current and future Business Intelligence conceptual, logical and physical definitions and the required physical data structures.
• Identified key current logical and physical design issues.
• Modeled future Confidential to identified GAP data and made recommendations to implement future Confidential and integration with semantic models.
• Facilitated information gathering sessions with Governance and Business Analysts to identify/clarify project BI design scope and requirements.
• Worked in tandem with ETL team and Business Objects team to provide logical and physical design understanding and support during ETL coding.

Confidential

Technology Ops Support Practitioner

Responsibilities:

• Performed a Data Management Direction (DMD) examination and assessment of the Contact Management business unit.
• Conducted interviews and surveys of business SME's and product consumers.
• Collected and analyzed the resulting interview and survey information to identify current Confidential required revisions based on the analysis results.
• Profiled the existing data within their current Confidential data structures.
• Analyzed the resulting information and profiled data creating Data Management Direction Assessment & Direction.
• Analyzed the current Confidential, identified key business, design and data issues, and logically modeled a future Confidential to mitigate issues identified from the assessment.
• Made recommendations for proceeding to implement future Confidential .
• Created and performed presentation of all findings and recommendations to Data Governance Committee and Contact Management business unit.

Confidential

Data Architect

Responsibilities:

• Created enterprise standards for designing logical 3rd normal form models, denormalization of physical data models, ETL mapping and logic, data quality, and performance, all in support of enterprise-level Business Intelligence environment.
• Instructed and in tandem with the client project modeling team designed and developed the required Enterprise Conceptual Model and the Enterprise Logical Data Model.
• Used Knowledge Transfer Contracts to mentor in-house modelers in Data Warehouse 2.0 logical and physical design techniques for Business Intelligence kinds of structures that were used to intervene an existing in-house technical knowledge gap.
• Assessed and critiqued the IBM Banking Industry model in its use to jump-start the Enterprise Data Warehouse design efforts. Assisted in the facilitation of an enterprise cross-section of business SME's in their creation and delivery of a Business Functional Capability Architecture by way of aligning the existing business units with each other and their respective supporting IT Services.
• Modeled the EDW's and Analytic subject areas and respective data objects by employing the use of the IBM Banking Data Model.
• Turned the modeled conceptual-stub over to the project’s internal modelers and continued oversight of the overall model design as the in-house modelers continued extending its functionality.
• Assisted in the facilitation and authorship of a Metadata Strategy to support the Enterprise Data Warehouse and Analytic Spaces.