CHARLEY TOCKEY

*** ********* ****** **** ****, CA 94303 949-***-**** aczx1t@r.postjobfree.com

Data Warehouse Architect

Healthcare Financial Manufacturing Insurance Service

Dedicated and accomplished professional with 25+ years experience capable of delivering large scale, complex programs/projects and expertly implementing solution designs across multiple market industries; an exemplary manager responsible for all project portfolio actions, including initiating, planning, executing, installing, monitoring, controlling, and closeout; ensure deliverables are completed on time, within budget, and according to contract scope.

CORE COMPETENCIES

Team Leadership

Data Architecture

Data Modeling

Testing & Evaluation

Local Data Manager

Project Management

Training & Development

Lifecycle Management

Design & Development

Customer Support

Budget Negotiation

Risk Management

EXPERIENCES AND ACHIEVEMENTS

BANK OF THE WEST, SAN FRANCISCO, CA Oct 2015 - PRESENT

Data Modeler

Perform data analysis and identify data from multiple source systems. Create Local Data Manager (LDM) for both third normal form (3NF) and Dimensional structures. Analyze source data structures and coordinate with Business Analyst for best granularity. Enhance Source to Target mapping document. Prepare, review and revise technical data architecture artifacts with an attention to security standards, compliance, and information assurance.

Develop Physical scripts and create tables in development environment.

Create scripts for migration between Dev, Test, UAT and Prod environments. Assist ETL developers and Q/A testers, as needed.

Attend status and daily agile meetings for five different projects that have deployment dates at different times.

Environment: Oracle 11g, MS Project, ERWIN, SQL Developer, Agile and waterfall methodologies

GORILLALOGIC / COUNTY OF SANTA CLARA PROPERTY TAX, SAN JOSE, CA Dec 2014 – May 2015

Data Architect

Expertly developed strategic plan to migrate data from legacy database into new system database; reviewed and analyzed target and source databases. Created project plan and identified resources; estimated Scrums and deliverables.

Formed development team of one (1) analyst, two (2) developers and Scrum Master/analyst.

Partitioned workloads into scrums; created Mapping Documents.

Environment: Oracle 11g, MS Project, SQL Developer, waterfall project.

SAAMA TECHNOLOGIES, SAN FRANCISCO, CA March 2013 – Nov 2014

Data Architect

Adjusted Project Plans to changing workloads; maintained Project Schedule to deliverables. Developed Business Objects Universes and Reports. Performed gap analysis between existing data and new data sources; documented strategy for data movement from data sources. Assisted ETL developers, as required; created volume test data.

Documented source to target data mappings with business rules and transformation rules;.

Gathered and documented requirements from source entities, process developers and data consumers.

Developed data models: ERWin for SalesForce and CISCO, Embarcadero with NVIDIA.

Created Project Plans and contributed to exitsting plans.

Environment: Embarcadero, ERWin, MS Project, DB2, MS SQL Server, Oracle, Unix AIX, Pentaho, Business Objects Webi, Agile.

ACCENTURE, SAN FRANCISCO, CA Feb 2011 – March 2013

Senior Solution Architect

Developed project schedules and created data models. Regularly coordinated with management, team, and customer, reporting on all progress, financial activities, and time schedules. Built Business Objects Universes and Reports; assisted ETL developers in Data Stage.

Proficiently utilized Informatica MetaData Manager for data lineage.

Execute high quality deliverables and solutions by effectively analyzing risk assessments and meticulously follow Method Statements.

Environment: MS Project, Sybase Power Designer, DB2, TeraData, Unix AIX, Data Stage, Business Objects Webi, WIKI Web Sharing

BILLMELATER, SAN FRANCISCO, CA Sept 2010 – Nov 2010

Data Modeler

Handled database server tuning, application tuning, maintaining documentation, capacity planning and database security; executed gap analysis between existing data and new data source; composed strategy for data movement from new data source; developed data model for new operational data; authenticated source to target data mappings with business rules and transformation rules. Partnered with ETL developers to ensure mapping documents are clear.

Identified and operated within project scope for a new data source.

Interpreted data source from existing documentation and Cobol Copybooks.

Environment: ERWIN, Oracle, Unix AIX, Informatica, Windows XP, WIKI web sharing

BLUE SHIELD OF CALIFORNIA, SAN FRANCISCO, CA May 2010 – August 2010

Data Modeler for Enterprise Datawarehouse

Translated project scope into the conceptual data model; identified business subject areas for data model scope development; coordinated data modeling team members model changes into the EDW. Partnered with Data and Business Analysts regarding physical data model creation. Coordinated with BusinessObjects Developers concerning business intelligence solution design and development.

Created and test scripts for physical database schema creation and modification.

Developed the following models: Claims, Capitation, Provider – Physician, Pharmacy, Hospital, Dental, Contract, Membership, Group, Subscriber & Enrollee, Eligibility, Financial, Payments, and Cost of Healthcare.

Environment: ERWIN, Oracle, Unix AIX, Informatica, Windows XP, Microsoft Office (Word, Access, Visio, Excel)

WELLS FARGO, SAN LEANDRO, CA Nov 2009 - March 2010

Business Analyst/Data Analyst for Wachovia to Wells Fargo migration

Developed the Functional Specification for Commercial entitlement migration for Wells Fargo services; cultivated the Data Migration Document and data/process flow diagrams; developed cross-reference matrix between Source to Target mapping document and Business Requirements Document and Business Mapping Document.

Reviewed data profiles with business users and established data cleansing and exception rules.

Identified and documented data risks and contingency strategy; proposed Data Governance to establish data Lineage requirements.

Environment: Oracle, Unix AIX, Informatica, Windows XP, Microsoft Office (Word, Access, Visio, Excel)

ADOBE, SAN JOSE, CA May 2009 - Oct 2009

Data Warehouse Architect – for Enterprise Data Warehouse

Profiled data from SAP BW as the source for DW utilizing SQL, TOAD, and Excel; developed data validation processes for each project phase with expected results. Documented communication plans for exception processes. Created data model for the EDW both staging and Star Schema used ERWin as the Data Modeling tool. Executed data validation scripts after each step of a data load; documented data validation process for DW loads within the STM documentation; monitored Reporting performance and tuned DB, SQL, or Data Model for increased performance.

Validated data integrity after DW data loads compared the results with expected results.

Established data modeling standards. Established documentation standards. Coordinated conformed Dimensions between EDW projects.

Maintained Dimension and Fact table matrix as well as data source for each table.

Designed data flow between project teams and loads. Established performance standards for data loads and SQL data reporting performance.

Environment: MS Project, ERWIN, Oracle, Unix AIX, Informatica, Windows XP, Microsoft Office, SAP BW

EMODELERS, PALO ALTO, CA April 2008 - Jan 2009

Data Architect/Data Analyst

Transformed Case Management Data and Account Data from current Case Management tool into SalesForce; developed Functional Specifications for all data migration objects which migrated from Case Management System into SalesForce. Built Use-Case Functional Specifications for Case Management; trained, coached, and mentored new Data Analysts, Developers and QA Analysts on Source to Target Mapping documents. Designed, Developed, and Maintained a table used to store pick-list values for different objects, fields, and mappings; designed Migration Strategy for Case Management data.

Validated Account data after loaded into SalesForce. Participated with a team of Data Architects in the development of a Genentech Canonical Data Model.

Developed Data Model for Case Management Migration Data and integrated the model into the Canonical Data Model.

Performed Reviews for the Functional Specifications and Source to Target Mappings with Business Analysts and Developers.

Provided templates for the Business Analyst to use for Business, Data, and Exception requirements.

Used AXIO/Informatica Data Viewer for Data Profiling for the following steps of development: Functional Specification Analysis, Source to Target Mapping Analysis, and Data Validation after development.

Environment: Embarcadero, Oracle, Unix AIX, Informatica Data Explorer, Windows XP, Microsoft Office

INFOSTEP, PALO ALTO, CA Oct 2007 – Jan 2008

Data Warehouse Architect/PM

Developed new business process to send data to insurance companies; introduced Life Cycle Templates such as Business Requirements, Project Scope, Data Matrix. Created Risk Assessment with contingency plan. Managed Project plan and resource allocation. Architected new data sources into existing data warehouse.

Built the relational data model for the Staging database.

Developed the multi-dimensional data model for the datamart; identified data merges areas that minimized table and data duplication.

Architected the phases for data scrubbing, normalization and integration.

Identified risks and mitigation strategies. Provided templates for the Business Analyst to use for Business, Data, and Exception requirements.

Environment: ER Studio, SQL Server, DB2, Unix AIX, BusinessObject XI, Windows XP, Microsoft Office

HEWLETT-PACKARD, PALO ALTO, CA Nov 2006 – Oct 2007

Asset Analyst

Managed and oversaw Supply Chain Assets; administered project Plan for Data and asset migration. Performed migration analysis into the Consolidated Data Center; issued coordination between business users, first line of support and support developers.

Environment: ERWIN, SQL Server, Unix AIX (scripts), SQL Server DTS, Windows XP, Microsoft Office

MIDCOM, IRVINE, CA April 2006 – Oct 2006

Methodology Lead/Data Warehouse Architect – Client Pratt & Whitney

Data Architect for the Pratt & Whitney’s financial Data Warehouse. Supervised BO v6.5 to XI; created project plans for the different projects. Trained team on Development Methodology. Integrated Development Methodology into existing PM infrastructure.

Lead member of the corporate architect review board where we develop standards and policies for development methods.

Designed database schemas both relational and star schemas to improve reporting and drill down performance.

Documented the scopes iterations by leading user requirement meetings. Design and many data source to target transformation for developers using Ascential.

Established the quality initiative for the Data Warehouse team, business users, and data source systems.

Environment: ERWIN, Oracle, Unix AIX, Data Stage, BusinessObjects, Crystal Reports, Windows XP

NEW CENTURY MORTGAGE, IRVINE, CA Feb 2005 – Feb 2006

Chief Data Warehouse Architect/Methodology Integration Lead

Organized a cross domain team for resource and methodology deployment. Trained cross functional team on different aspects of resource management and methods to capture required data. Developed implementation plan for development methodology and resource planning. Established documentation standards and means for governance.

Architected the new Data Warehouse SQL Sever 2000 DBMS. Architect and supervised the migration to SQL Server 64 bit from 32 bit.

Developed the transition plan for migrating uses from the existing Data Warehouse to the new.

Led member of the corporate architect review board where we develop standards and policies for development methods.

Assisted Project Manager with plan development.

Designed database schemas both relational and star schemas to improve reporting and drill down performance. Documented he scopes iterations by leading user requirement meetings.

Designed and developed many data source to target transformation using MS SQL Server DTS scripts.

Environment: Embarcadero, DB2, SQL Server, NT Server (scripts), SQL (Stored Procedure and user defined function scripts for DML), Windows XP, Reporting Website, Website for ETL processes, Microsoft Office (Word, Access, Visio, Excel)

PAST EXPERIENCE

PROGRESSIVE INSURANCE, CLEVELAND, OH April 2002 – Feb 2005

eServicingIT Chief Data Warehouse Architect/Manager

ATOS ORIGIN, COLUMBUS, OH April 1999 – Nov 2001

Cross Functional Team Analyst Methodology Analyst Manager Management/Analyst Consultant Chief Operational Data Store Analyst/Manager Business Project Manager Analysis Team

4CS, EAST MOLINE, IL April 1998 – Jan 1999

Project Manager

COLLIN COUNTY COMMUNITY COLLEGE, PLANO, TX Jan 1995 – Mar 1997

Visual Basic Instructor

ELECTRONIC DATA SYSTEMS, PLANO, TX Sept 1981 – March 1998

Data Warehouse and Data Architect Medicare and Insurance Claims Trainer Project Manager Developer Pre-Sales

TECHNICAL PROFICIENCIES

Programming Languages

Cobol, Visual Basic, Assembly Language (ALC)

Platforms

Mainframe, NT, Unix

Data Modeling Tools

ERWin, Visio, IEF, ERStudio 7.5

ETL Tools

Ascential DataStage, Ascential QualityStage, SQL Server 2000 DTS, MS Analysis Services MDX, Evoke AXIO 4.4, Informatica Data Explorer 8.6

Metadata

Metadata Manager, Designed and Modeled Processes

BI Tools

BusinessObjects (versions 4, 6.5, XI), Brio, Hummingbird, MS Analysis Services, Crystal Reports V10 and 11

DBMS

BDAM, ISAM, VSAM, QSAM, Oracle, Ingress SQL Server 2000

SUBJECT

YEARS EXPERIENCE

Leading Design and Development Teams

25+

Data Modeling Experience (Conceptual, Logical, and Physical Models)

15

Metadata Design and Usage

15

Project Management

12

Data Architect (Multiple Industries)

14

Business Intelligence Tools

10

Data Governance Processes & Rules

10

Oracle Platform Architecting Solutions

15

SQL Server 2000 Architecting Solutions

3

Transforming Data from DB2

3

Visual Basic

2

TeraData

1

EDUCATION & TRAINING

Continuing Improvement Courses, Texas Institute, Dallas, Texas

W. Edwards Deming Seminar (Process Improvement)

Ralph Kimball's Building the Data Warehouse

Crosby's Quality Management Courses

Contact this candidate