SUMMARY:

• 25 plus years of enterprise data management related experience in the role of architect, project manager, methodologist and modeler. Over 40 successful deployments in the areas of CRM, Finance, Asset Management
• Health Care, DOD, Retail and Insurance. Extensive work in the planning, design, development and deployment of Business Intelligence, Analytic and reporting environments at the Enterprise / Corporate level with over a hundred terabytes of data under management.
• Beta Product tester for Microsoft CRM, IBM Infosphere and Sybase PowerDesigner. Presentations at major conferences including DAMA, TDWI and Oracle User Groups.
• Multiple Assessments providing independent analysis of current state development and providing a roadmap to future deployment. Developed mastering process for Provider, Patient and Encounter/Event subject areas.
• Focus on integration of Medicare Advantage, IMS, NPI, CMS, ICD10, Member/Patent admissions and discharge information.

TECHNICAL SKILLS:

Methodology: Project Management Full and partial project lifecycles using the PM, CCPM as well as lighter weight Agile and Extreme. Responsible for resource identification and scheduling, budget estimation and spend / burn rate tracking. Communication Project plan (Gantt and Pert charts), Issues collection and management, specification development and change control.

Business, Systems and Process Analyst: IDEF0, Rational, Zachman

Framework: Responsible for Requirements gathering and documentation using Use Case, BPL, ICOMs. Developed project success criteria, measures and metrics.

Data Quality: Cleansing, Profiling and QA based on Metadata and Larry English methods

Data Modeling, Meta Data and Data Repository Development: IDEF1x, DoD 8320, Conceptual, Logical, Physical and Canonical Data Modeling. Third Normal Form (3NF), Data Bus, Star Schema, Aggregate and Summary, Data Vault.

Data Modeling: ERWin 9.5, Power Designer v.16, Embarcadero ERStudio 8.0

ETL Tools: Talend, IBM DataSage / InfoSphere, Ab Initio, Informatica, MS - SSIS, Oracle Warehouse Builder

Reporting Tools: Business Objects, Cognos, Qlikview, SSAS/SSRS, Microstrategy

RDBMS: Oracle 11g, DB2, MS SQL/Server 2000/5/8/12, TeraData “Big Data” Hadoop / Cloudera

Process Modeling: BPWin, CaseWise, Requisite Pro

Data Quality: Data Flux, Trillium, First Logic, Quality Manager, Qualitystage

MDM: Initiate, Axiom Abilitec

PROFESSIONAL EXPERIENCE:

Confidential

Independent Contractor / Consultant

Responsibilities:

• A short term review, design assessment and guidance for a product and analytic suite focused on Post Accute Care (PAC/SNF) service provisioning. Provided Master Data Management (MDM) options, recommendations and guidelines for implementing a strategy to resolve integration with multiple acquired companies and customer data sets. Provided guidance on implementation of a Data Governance strategy initated by the Master Data Management needs.
• Developed mastering process for Provider, Patient and Encounter/Event subject areas. Focus on integration of Medicare Adventage, IMS, NPI, CMS, ICD10, Member/Patent admissions and discharge information. Provided roadmap for implementation of the MDM strategy. SQL Server, Oracle and MongoDB.

Confidential - Rosemead / Pomona CA

Data Governance and Data Quality Specialist

Responsibilities:

• Provided guidance for the creation of a data governance platform supporting data quality, data standardization and data integration for Asset and landbase data used with Map3d
• ESRI Mapping and GE Smallworld. Data originates in SAP and is propagated to various analytic and mapping services for the creation and electrical network segments and assets. Directing the establishment of a data governance process based on DAMA principles.
• Creation of Data Quality initiatives focused on data standardization and cleanup using TDQM measures. Working with inhouse and offshore staff for implementation. Use of SAP Information Steward for data Profiling and Data Services for data quality.

Confidential- Colorado Springs CO

Lead Solution and Data Architect

Responsibilities:

• Provided Data Architecture leadership in developing an integrated analytic and reporting service for support of Asset Management, Financials, Event Management, Program Portfolio, Artifact Management and Cyber utilization and security subject areas. Developed Conceptual, Logical and Physical data models for Hive / HDFS data systems based on highly denormalized data structures. Developed meta-model supporting that included security and integration services.
• ERWin 9.5 as data modeling tool with domain attributes and User defined parameters Implemented in a ULAN/CLAN CDS environment on a Cloudera r5.4 implementation of an Hadoop cluster with Talend DI and Microstrategy reporting services.
• Talend was used to generate Scoop and Flume scripts for the data integration services. System acts as the historical repository for various network messaging, audit and event management. This is a multi-petabyte multi node fault tolerant / high availability system. Architected and Developed within a DODAF framework. Also architect the Data Governance process and data quality services as part of the engagement.

Confidential - Stockton, CA

Lead Data Architect/Data Modeler

Responsibilities:

• Provided data architecture related services for specialty healthcare insurer. Provided data modeling services for Pharmacy, Authorization and Member Month Subject areas.
• Responsible for Conceptual, Logical and Physical data models for Base tables as well as Aggregate and Summery / Data Mart environment.
• Providing source to target mappings, integration architecture. SQL Server and DB2 source systems with SQL Server 2012 target Consolidating Data Governance practice for supporting HIPPA, PHI and PCI regulations.
• Data supported analytics and reporting services used through standard KPIs, measures and metrics. Reports generated in Tableau as standard reports and user generated reports.

Confidential, Columbia South Carolina

Data Architect

Responsibilities:

• Provided data modeling and architectural services supporting an Implementation of Asset Management and service scheduling activities.
• Source environment of DB2/SQL Server with a Target warehouse in Teradata. Data modeling in ERWin9. Use of the ADRM canonical / Logical utilities model. Very similar activity to work performed with Confidential .

Confidential - Alexandria, VA

Data Architect

Responsibilities:

• Part of a 12 member Red Team review and assessment of a large personnel management and payment system for the Department of the Army. Managed ETL remediation team schedule and deliverables.
• Responsible for the review, assessment and Project Assurance of data integration (Datastage) and data quality services. Identified deficiencies in process, design and implementation. Developed remediation strategies for data integration services implemented through the IBM Infosphere -
• Datastage product suite. Managed remediation team schedule and deliverables. Responsible for review and assessment of overall Data Architecture (Data Integration, Modeling and Quality) documentation, SLAs, ERDs, DI Jobs and coding. Contributor to final presentation. Evaluated System Integrators and various vendor deliverable as part of my Project Assurance role. Retained following the initial assessment to assist in development of the Critical Design Review documentation and presentation.
• Ongoing assistance to senior management for data quality, change control and development of deployment strategy.

Confidential - Sacramento, CA

Lead Data Architect

Responsibilities:

• Lead Data Architect for design and implementation to revamp Operational and Data Warehouse data model, data acquisition, analytic and reporting services for the revenue arm of the state. Supervised the design and development staff for Data Modeling and Data Integration.
• Responsible for Project Assurance in all data architecture domains as well as data governance. Responsible for the design of the data sourcing strategy using IBM’s Datastage suite including Datastage, Qualitystage, Information Analyzer and MDM services supported through Initiate.
• Responsible for the Initial and incremental load architecture along with scheduling, event notification and exception management. Responsible for ETL operational reporting services based on Datastage generated log data. Implemented, configured and populated metadata workbench for supporting ETL as well as analytic and reporting services. Responsible for data reconciliation, outlier management, source to target mapping documentation. Responsible for the population of the EDW and ODS with Legacy and current state initial load data using Datastage jobs and services.
• Supervised and assisted the development of the conceptual, logical(3NF) and physical data modeling for the complete data warehousing environment supporting 300Tb+ foundation and data marts. Responsible for coordinating the data modeling activities of three major solution provider organization along with state resources. Responsible for identifying and driving enterprise level data solutions. Responsible for developing and implanting Program and Enterprise level data governance. Assisted in the architecting of the states MDM Solution for identification de-duping, merging and splitting individual and organization entities. Responsible for the development and management of the program level metadata repository including full lifecycle data development. Identified and implemented enterprise level information standards including access and authority, retention and integration.
• Identification of a standard CIF architecture framework. Developed standard (canonical) data models as well as structural design patterns for data management. Developed strategy for inclusion of structured (e-file) as well as unstructured data (scanned filing and document) Environment developed with IBM Infosphere (DB2, Metadata Workbench, Initiate, Business Objects, Information Analyzer). Modeling in Powerdesigner 16.1.

Confidential

Data Architect/Data Modeler

Responsibilities:

• Developed EDW architecture and data model for regional electric utility. Supported Confidential transition from CIS+ to SAP for customer management. Supplied guidance in developing an Enterprise Data Warehouse.
• Supervised requirement gathering for analytic and reporting requirements and design, data integration design and development. Warehouse data included above sources and IEE for meter reading. Incorporated third party utilities data model (ADRM).
• Developed Canonical, conceptual, logical (3NF) and physical data model models in ERWin 8. Architected ETL strategy to integrate existing legacy source data with SAP incremental loads using standardized templates in Datastage. Provided design and supervised the data integration scheduling, exception management, event notification and ETL operational reporting and audit services.

Confidential - Denver, CO

Enterprise Data Architect/Data Modeler

Responsibilities:

• Developed multiple Enterprise Data Warehouse (EDW) and Data Mart conceptual, logical and physical data models to support Order Management, Organization and Technician Performance Metrics. Supervised data modeling team for standards and development of data models (Canonical, Conceptual, Logical (3NF) and Physical) and integration team for ETL services. Work performed in ERStudio 8.53 for both Teradata 13.10 and Netezza 6 environments.
• Dish uses Teradata for EDW and publication reporting services (OBIEE and Micro Strategy) while using Netezza for true analytics. Designed target Teradata and Netezza data structures to support migration of executive DSS / Dashboards from SQL Server. Target reporting based on OBIEE. Export / Import data formats for Oracle EBS 12.1.2.
• Developed STM for CSG source structures to new DSS. Engagement designed as a short term contract to resolve and accelerate end of year analytics, data sourcing and reporting needs. Use of Aginity, Golden Gate. Assisted in development of pilot projects using Ab Initio for integration and scheduling services.

Confidential - Phoenix, AZ

EDW Architect and Data Modeler

Responsibilities:

• Designed and developed clinical data warehouse to support Meaningful Use Reporting, Missing Charges Reporting and Provider Task Reporting for a large West Coast Healthcare provider. Information is extracted daily to support physicians and healthcare providers in California, Nevada and Arizona. Primary focus on provider performance analytics for ambulatory clinical care.
• Responsibilities included the design of a target IDS / data warehouse and data marts sourced from IDX, Allscripts and Facets. Responsible for Project Assurance in all Data Architecture Domains including Data Quality. Negotiation of SLAs with 12 separate data providers. Developed refresh, transformation and sourcing logic, capacity planning model, security model incorporating HIPAA compliance. Performed data modeling (Conceptual, Canonical, Logical (3NF) and Physical with ERWin 7.3. Managed team of 2 ETL contractors and 2 BI report developers. Supervised Data Integration and ETL development services with SSIS. Reporting and analytic services provided with SSRS. Developed data profiling and statistics reports using SSRS.
• Coordinated with DELL Professional services to design and implement infrastructure around DL580/380 Dev, Test and Production environments with separate data marts utilizing SQL Server 2008. Initial capacity is 7Tb. This project represents CHWs first data warehousing initiative and supports retirement of two existing third party data warehouses (McKesson and GE) and will be used in supporting their Meaningful Use .

Confidential -Denver, Co

EDW Architect /Data Modeler / MDM Strategist

Responsibilities:

• Performed Audit and Assessment of the Enterprise Data Warehouse for Tavelport, the parent company of Orbitz and Hotel.com, a multinational travel and reservations service. Duties included a review of the current EDW and data architecture focusing on how currently defined Key Performance Indicators, Measures and Metrics have been implemented in the EDW 3nf base tables as well as in Stars designed to support specific analytics. Also identifying and constructing SLAs for multiple data and service sources.
• Supported development of data standards and enterprise governance process. Supervised on and offshore teams developing ETL services for schedule and deliverables. Continued participation in the second phase of the project supporting development of the data integration services using IBM Infosphere platform with IBM DB2 9.7, Informatica ETL services, X-88 / Pandora Data Profiling services and Cognos Analytic and Reporting services. Participated in MDM product evaluation (Oracle and IBM) and POC focusing on development of governance and compliance issues.
• Developed a standard data repository and shared entities used by the EDW and subsequently several other projects. Data modeling (Conceptual, Logical (3NF) and Physical) using Embarcadero ER-Studio 8. Established Data governance with Data Architect Group including the establishment of Data Stewards and Subject Area Functional Proponents. Developed Data propagation services based on Websphere MQ services using a subscription model. The Subscription uses a Q replication strategy (Q Capture/Q Apply) to propagate transaction log events to the target staging area for load to the EDW.

Confidential - Westboro, MA

Data Warehouse Data Architect /Data Modeler

Responsibilities:

• Confidential is the primary electrical transmission and distribution utility for New York State and New England. My responsibilities included designing an Asset Management subject area of the EDW to support Adhoc and standard reports for circuit and critical asset health. Integrates multiple data sources including Cascade, ESRI, Maximo, Computa Pole and Power On. Based on the ESRI Transmission / Miner and Miner Canonical Logical data model.
• Responsible for Data Warehouse Data Model (conceptual, Logical (3NF) Physical), Data Mart Data Model, Source to Target Mappings ETL Service schedules, Exception management and event notification using Datastage for ETL services, and Qualitystage for address standardization. Developed Business Objects Universe specifications. Developed standard data and shared entities for warehouse and GIS services. Worked with and helped identify Data stewardship responsibilities for Asset Management.
• Provided governance and compliance data for TSA and regional utility boards. Work performed in Erwin, Oracle 10g and ESRI. Target OBIEE reporting services. Imported data and structures used in existing Netezza decision support system.

Confidential - Louisville, CO

Data Warehouse Data Architect / Data Modeler

Responsibilities:

• Confidential is a tier 1 provider of merchant payment systems / credit card processing. My responsibilities included the identification of the system architecture for supporting a new Data Warehousing / Business Intelligence environment. Was retained by senior management to translate business requirements into data management processes to support corporate analytics and reporting services specifically around sales force efficacy.
• Developed data content standardization process to improve Merchant Boarding process and Data Quality. Worked with data stewards and SMEs to identify various sensitive or regulated (PCI) information and appropriate management techniques.
• Developed performance metrics reports in SQL SERVER 2008 with SSRS reports. Established data governance policies as part of the data management practices. Developed Conceptual and Logical Data Model (ERWin). Dell Blades with MS-SQL Server 2005/8. SSIS/SSRS/SSAS.

Confidential - Minneapolis, MN

Enterprise Data Architect / Data Modeler

Responsibilities:

• Supported the Medicare Part D analytic and reporting data warehouse architecture and design through the identification of source systems in claims, billing and member to support a prescribed set a member management, sales and finance executive reports and analysis. Identified initial MDM strategy for model standards around billing codes, member and product. Financials sourced in part from SAP. Responsible for Project Assurance in all data Domains including Source System relationships, Data Quality and remediation. Worked with management and business to identify rules associated with data access and roles as well as development of KPIs to report against. Worked with SMEs to identify sensitive and regulated data (HIPPA) used in analytics.
• Developed meta model and metadata management strategy. Developed sourcing strategy based on Datastage suite including Datastage ETL services, Qualitystage for address standardization and Information Analyzer. Multiple sources including FACETS. Supervised ETL on and off shore development teams. Developed scheduling model, exception management and recovery strategy. Developed conceptual and high level logical data model (3NF). Developed overall capacity planning model. Environment consisted of a mixed Oracle 10g / IBM DB2 with Datastage, Qlikview EAI Reporting and Dashboard. ERWin 7.2 Data Modeling

Confidential - Portland, OR

Enterprise Data Architect /MDM Strategist/Data Modeler

Responsibilities:

• Confidential is a leading web traffic analytics product and service company. Worked with the senior management, systems and development staff to architect and redesign Confidential analytics and abstraction data model. This included the redesign of key event tables supporting multiple billions of rows of detailed web traffic data. Responsible for Project Assurance and effectiveness for all data management strategy.
• Developed a meta model for supporting third party and client data. Developed improved detail in the campaign view visit relationship along with standardized structures for contact event and event management. Provided senior management a “read out” on risk associated with current Data Management practices.
• Developed client segmentation strategy for product and infrastructure assignment. Developed prototype analytics in MS-SQLSERVER 2008 with SSRS. Confidential client base includes volume users such as Microsoft and Orbitz. Developed data integration and centralization strategy for corporate financial and performance model. Environment consisted of a generic “wintel” server farm with SQL Server 2005. Assisted in conversion of ETL services from SSIS services to Datastage due to performance constraints.
• Supervised on and offshore ETL developers responsible for the SSIS to Datastage conversion. Architected initial and incremental load strategies for multi 10’s on millions of daily load, transformation and data recovery. Embarcadero ERStudio Data Modeling tool used to re-architect data models. Evaluated third party DW appliances including Netezza and Balanced Warehouse for use in internal facing decision support system.

Confidential - Golden, CO

Data Architect / Data Modeler

Responsibilities:

• Supported the migration of an analytic and reporting data mart containing roughly 360 tables and 100+ views from Teradata to an Oracle 10g environment using Oracle Warehouse Builder (OWB) 10g R2. Responsible for migration of structures, tables and views along with data type recasting as needed. Developed meta-model and updated ERWin metamodel to support data quality and integration.
• Worked with DOL Subject Area Functional Proponents to populate operational and business metadata.
• Constructed mappings with the OWB Data Mapping tool as well as TCL based scripts accessing the OWB API. Reviewed and tuned PL/SQL. Data Integration with Ab Initio with date based partitioning. Developed a tiered scheduling process for handling initial, incremental and on demand refresh processes. Documented existing and target models (3NF) with ERWIN physical model.

Confidential, Redmond, WA

Enterprise Data Modeler / Meta Model Developer

Responsibilities:

• Lead Data Architect and Modeler for development of the Canonical Conceptual and Logical (3NF) data model to support the relationship management subject areas of the Microsoft Enterprise Data Warehouse (EDW). Working very closely with marketing specialists to codify data management processes and information resources required to develop, execute, monitor and evaluate various types of global marketing initiatives.
• Also worked with the business to identify sensitive and regulated information used in a campaign. Implemented modeling, metadata and naming standards along with Enterprise data development standards. Developed information for standard Campaign Lifecycle, Prospect Lifecycle and Campaign Efficacy in ePiphany. Developed semantic layer to assist in identification of a data integration strategy. Other subject areas include License management and market segmentation.
• Worked with MS data design team in construction of the MS Data Development Lifecycle and a standard Meta model to support the canonical models. Developed initial multidimensional models for customer, partner and product scoring. Integrated newly developed components with existing EDW Subject areas for Sales and Finance. Demonstrated data integration from ePiphany and Siebel CRM. Developed Data profiling and statistics reports / analysis using SQL Server Reporting Services (SSRS) and SQL Server Analytical Services (SSAS) This model will be matured to support global relationship management with customers, partners, vendors and internal MS staff. Work performed in ERWin 7.2.3, Target environment was identified as MSSQL Server 2005/2008.

Confidential, Sacramento, CA

Data Warehouse Architect / Modeler /Project Manager

Responsibilities:

• Assessment and redesign of a clinical data warehouse 4 Tb Claims, Billing, Lab and pharmacy subject areas. Provided Senior IT management with an assessment of opportunities to improve overall data management activities along with improved security, performance and information quality. Piloted an MDM assessment (Initiate) and POC. Developed cross walk and mapping from current data sets to HL-7 V2 RIMS data structures.
• Developed project plan and resource estimates for phase 2 of the implementation project. Logical (3NF) Data Modeling in PowerDesigner. SQL Server 2005 environment, Cognos BI and Informatica ETL. Diagnosed performance problems with Netezza Querries eventually identifying poor data structures imported from legacy model and inappropriate distribution key. Developed system performance and utilization reports using SQL Server Reporting Services (SSRS)

Confidential, Minneapolis, MN

EDW / EBI Architect / Data Specialist

Responsibilities:

• Lead Data Architect for the Best Buy Enterprise Business Intelligence (EBI) Retail Analytic and reporting services implementing 15 retail KPI metrics. Worked with various business unit SMEs to develop detailed requirements for the KPIs as well as the various roles and organizational hierarchies required for accessing the associated reports. Teradata based system supporting 70+ Tb of retail, customer, HR, vendor, product, G/L and budget data. 15 multidimensional hierarchies used to populate Business Objects XI R2 universes. Supports 880 stores domestically with daily performance reports, on demand and custom analytics. Integrates multi-channel customer information (CDI) and scoring services. Led team of 6 data and system architects.
• Responsible for Project Assurance in data architecture domains. Established standards for data architecture and governance for cross organizational integration. Responsible for technical design for multiple projects including Tax Audit, Integrated Customer Management (Reward Zone/Services) model, Enterprise and Retail Reporting. Integrated Datastage ETL and Data Quality services to standardize customer, vendor and employee content. Developed Data Retention and Archive strategy to support compliance, e-discovery and information audits. Upgrade of Business Objects from v6 to XI-R2. Developed internal reports to support data architecture team for reporting to managers on data development statistics, quality, performance etc.
• Developed data integration and centralization plan in support of the MDM strategy. Also developed Security, Access and authority model for BOXIR2 to support both vertical (organizational hierarchy) as well as horizontal (product grouping) hierarchy. Prototyded KPI Dashboards with Excellcius. Logical and Physical data modeling in Power Designer v.14. Converted universe sourcing form Oracle 10g to Teradata.

Confidential, Denver, CO

Data Warehouse Architect / MDM Strategist

Responsibilities:

• Lead Architect for design for the credit card processing division. Responsible for the design and implementation of the DW and DM supporting merchant reporting and analytics.
• The environment continuously acquires transaction records from over 85,000 merchants including exclusive processing for Marriot, Starwood and Hilton hotel chains, United, American and Northwest Airlines. .
• Process supports up to 30M daily transactions. Created the internal audit process for PCI Compliance. Developed infrastructure requirements and multidimensional data models to support aggregate and summary information for marketing analytics. Ensured data quality through matching of transactions with payments identifying and alerting on orphaned transactions.
• Developed Master Data Model (MDM) for Product/Services/Pricing and Charges. Standardized data and base data entities. Developed work flow processes for acquisition, cleansing, and loading of data, service requests for information by merchants and management, along with overall analytics. Developed ODS for monitoring continuous operational performance and merchant charge adjudication. Merchant data integration with Firstlogic and D&B. Process Transitioned ETL services from Ab Initio to Datastage and Qualitystage. Data Modeling in PowerDesigner v.13. Developed data governance processes for compliance and archival services. System developed on an HP cluster running HPUX and Oracle 10g.

Confidential, Bloomfield, CT

Data Architect / Modeler / Project Manager

Responsibilities:

• Lead Data Architect and Project Manager for team of 6 data architects and modelers developing an integrated Healthcare Insurance Product Repository integrating product catalog, eligibility rules and pricing.
• Supports individual and small group policy development. Responsible for requirements gathering, development of process models, Logical (3NF) and Physical Data models. Integrated cross organization information through authoritative Data Stewards. Developed cross platform sourcing strategy involving DB2 Mainframe, Mid Tier UDB and SQL Server data sources. Product repository acts as a one stop shop for all product, benefit and services data. Consolidates content replicated across 4 major systems supporting 18,000 corporate entities and 12 million members.
• Developed work flow for small group registration to integrate with large group policy management process. Ensured proper relationship between provider payment request and payment adjudication processes. Developed data mapping strategy to integrate external and internal data sources (HL-7 V2 coded) with internal data structures. Developed sourcing strategy and scheduling using Datastage along with ETL exception management (recovery and restart) along with operational event notification. Developed “sun setting” strategy for legacy source systems. Developed meta modeling strategy and extensions to the Standard Erwin Metamodel. Developed data integration strategy for third party and TPA online enrollment systems. Developed replication strategy based on MQ services and Q Replication for low latency transaction propagation.
• Modeling performed in ERWin with Model Mart. Process modeling with BPWin. Data Flux for data cleansing. Metadata strategy using SuperGlue as a data research front end for developers and analysts.

Confidential, Seattle, WA

Enterprise Data Architect

Responsibilities:

• Provided data architecture and Information Audits to support to the BASEL II implementation planning team. Identified affected information assets, systems and processes.
• Developed data integration strategies by subject areas and meta model to support data quality and data standardization with Datastage and Qualitystage. Supervised ETL development staff. Detailed data lineage for end to end data transparency. Performed data profiling to identify data at rest variability.
• Platforms included IBM Mainframe and mid tier environments. Process modeling with Rational and data modeling with ERWIN. Use of Rochade to reconcile multiple source system discrepancies and standardize data structures. Various source system evaluated including Oracle 10g and DB2 ZOS.

Confidential, Colorado Springs, Co

Data Warehouse Architect / Data Modeler

Responsibilities:

• Provided data architecture services and created a Corporate Information Factory Framework to support an international Child Relief Agency sponsoring nearly one million children world wide
• Assisted in the identification and acquisition of ASP based CRM product (Siebel) to support sponsorship and contribution management. Developed work flow management for accepting credit and debit transactions from sponsors for daily authorization and GL entry.
• Constructed preliminary Data Structures (OLAP Cubes) in support of analytical and BI environment. Developed Logical (3NF) and Physical data models in PowerDesigner. SQLServer 2005 with DTS and SSRS.

Confidential, Seattle, WA

Compliance Data Architect

Responsibilities:

• Developed data governance policies related claims information management to resolve HIPAA compliance issues.
• Developed audit trails based on Information Lifecycle Management principles. Developed data retention architecture including retention rules engine, audit repository, audit reporting, and data disposal services.
• Developed strategies to reduce data redundancy and duplication. ETL integration and data quality services built around Datastage and Qualitystage. Oracle 10g with Oracle Financial Applications under 11i.

Confidential, Sacramento CA

Data Architect

Responsibilities:

• Lead data architect for the Asset Management Integration Project. Responsibilities included development of roadmap to integrate Oracle and SQL Server information assets across 5 distinct applications.
• Provided best practices assessment for shared data assets. Identification of improved modeling tools and processes. Project integrated physical data models from RESD, Maximo and SIS.
• Developed an asset location data model to tie an asset to physical and administrative location. This activity was the pilot for the development of a enterprise asset management and project tracking information Master Data Model (MDM) for a shared budget forecasting and resource allocation.
• Integration and data quality services provided through datastage and qualitystage. Mixed environment including MS-SQL Server, DB2 Mid Tier.

Confidential, Sacramento CA

Data Architect

Responsibilities:

• The Franchise Tax Board ( Confidential ) is responsible for all tax collections from partnerships and corporations for the state. This engagement developed a strategy to turn the existing Confidential data warehouse into an enterprise available data warehouse supporting individual as well as corporate filers.
• The focus is to determine how to scale the current resources and infrastructure to this new purpose. Developed metadata management strategy, data integration (Datastage), Profiling (Profilestage) and standardization practices for analytical infrastructure.
• Source of Record identification and integration, Governance related to filings data access SOP. Introduced and performed POC with Oracle Warehouse Builder supporting cross filing and entity investigations. Mixed environment of DB2, Oracle 19 and SQL Server. Various tools to profile and statistically validate sources.

Confidential, Broomfield, CO

Data Architect

Responsibilities:

• Corporate Express is the largest B to B office products supplier in the US. Engagement centered on development of a roadmap to support development of a Business Intelligence infrastructure. Worked with various business units to evaluate impact of data integration and planned changes to the information management processes.
• Focused on integration strategies to support customer data integration (CDI) and development of a standard product catalog and pricing model (MDM). The roadmap integrated processes around the clients existing Ab Initio ETL services and Cognos BI tools. Initial design for metadata repository and data stewardship process. The project deliverable was the road map for integrating various customer and product information used by 33 business divisions plus corporate users.
• System responsible for global tracking of customers, vendors and distribution. Also reviewed the impact of new activities and data requirements on the existing 2.2 Tb Oracle 10g Data Warehouse running on a SUN F-15000

Confidential, Bloomfield CT

Data Management Architect / Solutions Architect/ Project Assurance

Responsibilities:

• Engagement centered on performance improvement strategies / redesign for corporate 3.6 Tb data warehouse with 22 source systems and supporting 17 data marts used by over 22,000 users.
• Source data systems included Trizeto Facets and RIMS. The independent feeds were combined to create a shared claim, billing and payment view. Developed architectural alternatives associated with ETL strategies (Datastage) including design of an ODS and a high availability replication mart for 24/7 access.
• Developed star schema redesign for several supported marts. Developed de-normalized data structures using ERWin to support improved load speeds. Responsible Project Assurance for all data domains. Developed standardized table strategy. Developed audit process for monthly load performance measurement. System based on IBM 390 Mainframe with DB2 v7. Product Review and selection for Point in Time copy process. Evaluated / POC IBM Warehouse manager to replace / compliment ETI and CA7. Design improvements for operational and technical metadata repository.
• Development of self serve reporting model for HIPPA compliance related reporting services. Developed initial sourcing strategy and ETL process based on DataStage to populate OLAP reporting services. Developed exception management, data recovery along with back out and restart process.

Confidential, Denver CA

Data Architect / Data Modeler / Project Manager

Responsibilities:

• Responsible for the development of 1.7 Tb Data Warehouse. Developed Datamart supporting GSA reporting services for a large financial organizations credit card processing division supported high availability ad-hoc reporting. Project Manager for Team of 5 including
• ETL developers and development DBAs. Migrated data from IBM Mainframe to IBM P690 (AIX / DB2-UDB 7.2 EEE) using Ascential Datastage. Responsible for Data Quality and integration.
• Responsible for the Star schema data model (ERWin). Designed OLTP processes for real time extract, account change data capture and targeted transaction monitoring to ensure consistency between online services and Offline Analytical (OLAP) Services.
• Developed ODS to support month to date charges for card holders. Developed custom metadata repository and metadata research tool. Supervised DataStage and MetaStage implementation. Developed table strategy for hierarchical organization (MDM) relevant to various governmental branches.
• Developed ETL source to target mappings. Use Case Modeling with Casewise. Generation of UML both by hand and by tool. Provided requirements for system design based on JAD sessions populating a Zachman Framework.
• Model designs based on Kimball Methodology. Provided project Management and leadership for team of 12. Provided initial design and project plans for Corporate EDR and Enterprise Meta data repository. IBM Warehouse Manager to organize and manage mainframe extracts and transformations. Supervised 1 modeler, two ETL developers, one dba and one reports (Web Focus and Hyperion) developer.

Confidential

Data Architect / Data Modeler / Project Manager

Responsibilities:

• Engagement / Project Manager responsible for migrating proof of concept ANSI - 41 Wireless Technical Data Record (TDR) ODS and Data Mart in use by 500+ Customer Care operators.
• The system acquires 1 - 5 million wireless TDR per hour through an Ab Initio ETL process. The records are extracted as part of an OLTP and stored in an Oracle 8i data mart. The records are then accessed through a web browser interface by the end user. My effort was to standardize and optimize the original data model into a snow flake / star schema model, review and validate the online transactional processes (OLTP) feeding the TDR, improve overall data stability (quality, exception management and timing) and transfer the ETL and data components to the Alltel technical support services.
• Following completion of the Customer Care Data Mart, developed additions to TeraData Data Warehouse data model to support customer care status feed to support OLAP reporting services.
• Development of Usecase object models (Casewiae) and UML. Responsible for Project plan, resources and reporting to senior management. ETL with Ab Initio. Data / Process Modeling with Rational. RDBMS Oracle 9i. Direct responsibility for 3 ETL developers, 1DBA and 2 data modelers.