Data Manager
Resume:
CHARLEY TOCKEY
*** ********* ****** **** ****, CA 94303 949-***-**** *******@*****.***
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