Jamie Pinchen

Bentonville, AR 479-***-**** ad02pv@r.postjobfree.com

www.linkedin.com/in/jamie-p-865927

Data Solution Architect

Design Data Architectures and Solutions to Support Analytical and Machine Learning Initiatives

A highly experienced consultant with expertise in designing within multiple industries, focusing on Financial Services. Extensive experience in working with Metadata to support automation of analytical data needs. Capable of leading teams that successfully solve complex, business-critical problems by adopting a collaborative approach. A strong communicator who can operate at both a senior executive and an operational level, translating intricate technical details into business-focused and understandable concepts. Providing connected tactical solutions to complex strategic data management requirements.

Skills

MS SQL Server

SSIS, SSAS

Scripting (Python/SQL)

Erwin Data Intelligence Suite

Erwin Data Modeler

Sybase PowerDesigner

ER / Studio

Data Architecture

Data Integration (ETL/ELT)

Talend

Information Delivery (BI)

Metadata Driven Process Design

Data Security, including data encryption

Process Automation

Professional Experience

ERWIN BY QUEST, Aliso Viejo, CA

Automation Solution Architect 2020 – 2023

Re-designed DIS Automation framework architecture, making it more modular, allowing for the reuse of components across projects, reducing time to delivery, and improving quality. Provided architectural design of forward engineering automation solutions to multiple clients, saving time and money in ETL development, modeling and information delivery projects, for the client. Designed automation of Denodo query creation at HCSC

DXC TECHNOLOGY, North America

Professional Services Consultant 2010 – 2020

Solution Architect, Client: CALSAWS, Sacramento, CA

Designed overall data provisioning solution, including source-to-target mapping standards and data integration code automation solution to allow early completion of CalSAWS data migration project, saving thousands of hours of code development time.

Solution Architect, Client: HPE FINANCIAL SERVICES, Berkley Heights, NJ

Completed full business requirements capture and source system analysis, leading to a final solution architecture design, including logical and physical data models with source-to-target mappings. Along with Information Mart Star Schema, allowing the client to move forward with the End-of-Life Profitability reporting solution.

Data Modeler, Client: ONE AMERICA, Indianapolis, IN

Designed a Dimensional Data Mart (Star Schema) model supporting Enterprise Claims from Employee Benefits, Individual Life and Retirement lines of business, integrating business lines into OA Data Hub Architecture.

Solution Architect / Data Modeler, Client: PROTECTIVE LIFE, Birmingham, AL

Designed Azure-based Solution Architecture, including data model, data integration and information delivery for annuities experience data mart, from initial scoping to final project delivery, translating business requirements into technical and data deliverables, including source-to-target mappings with business rules for data integration. Provided ad-hoc data modeling recommendations on other client Business Intelligence initiatives, resulting in faster development and more accurate reporting.

Data Architect/Team Lead, Client: HP INTERNAL, Atlanta, GA

Architected an Azure solution to address the issues raised by the Basel Committee BCBS 239 Risk Data Aggregation and Reporting paper, covering Compute, Storage, Networking and Security. Created HPIC metadata catalog. Enhancing HPIC to support BCBS319 reporting requirements.

Senior Data Architect, Client: WALMART – WELD, Bentonville, AR

Part of the design team responsible for the WELD framework using standard data model techniques. Developed customer area of WELD to 3rd normal form. Mapped same to client's existing physical data models showing that the WELD customer was complete. Developed the Associate, Store and Transaction subject areas.

Data Architect / Modeler, Client: HP INTERNAL, Atlanta, GA

Designed and delivered the HPIC technical education program and technical aspects of the sales enablement Road Show, providing global pre-sales support. Led integration effort of HP SOA4FSI and HPIC solutions. Provided Conceptual and Logical models for a combined solution, resulting in a solution for ODS and Reporting. Extended HPIC dimensional model to ensure capture of data required to support LEI, Dodd-Frank and FATCA regulatory requirements by adding subject-specific Star schemas to guarantee HPIC remained viable as a solution.

Additional Experience

MICROGEN, London, UK

Senior Professional Services Consultant

Client: Nokia, Espoo, Finland, Functional Lead (Content Fee Management)

QUADRANT RISK MANAGEMENT INTERNATIONAL, Global

Senior Professional Services Consultant

Client: REPUBLIC BANK, Port of Spain, Trinidad & Tobago, Solution Architect (Data Warehouse)

Client: MAURITIUS COMMERCIAL BANK, Port Louis, Mauritius, Team Lead (Data Warehouse)

DIAMAS SOLUTIONS LTD, Europe

Senior Professional Services Consultant

Client: LOMBARD GATX, London, UK, Report Developer

Client: REUTERS THOMSON, Geneva, CH, Data Modeler

Client: PFIZER INC, Memphis, TN, Data Modelling Team Lead

Client: RNIB, Peterborough, UK, Report Developer

Client: ROOM SOLUTIONS, London, UK, Data Warehouse Consultant

Client: ALMBRAND, Copenhagen, DK, Data Warehouse Consultant

SYBASE, UK and Ireland

Senior Systems Consultant, Data Warehouse

Client: ERICSSON, Stockholm, SE, SQL Developer

Client: NPOWER, Worcester, UK, Data Warehouse Architect

Client: STANDARD CHARTERED BANK, London, UK, Data Modeler

Education Certifications

Ralph Kimball Dimensional Modeling

MS Azure Fundamentals

MS Azure Data Fundamentals

Basel III Certified Professional

Basel III Pillar 3 Professional

Capital Requirements Directive

Contact this candidate