SUMMARY:

• Confidential is a consulting enterprise/solution/data architect, and university instructor with diverse IT experience in the private and public sectors. His primary areas of expertise are in information systems data and solution architectures with extensive experience in enterprise architecture solutions, development and integration, data warehousing/business intelligence, and data architecture/modeling. Confidential understands business issues, is proficient in translating complex business requirements into working systems, and has excellent skills in working with business users, management, and technical personnel.

TECHNICAL SKILLS:

SOFTWARE: Databases: MS SQL Server 2005/2008/2012, Hadoop, SSIS, SSRS, DTS, SYBASE ASE 12.5/15, ORACLE 8i/9g/10g/11g, DB2 UDB 5.0/6.1,MS - Access, T-SQL, PL/SQL, SQL-Backtrack, Teleran, Informatica PowerMart, Informatica PowerCenterModeling, Architecture, Project Management: ERwin, PowerDesigner, ER/Studio, Sparx Enterprise Architect, UML, MDA, IBM System Architect, ModelRight, MS Project, FEAF, Zachman, TOGAF, Agile, Scrum, Rational Unified Process (RUP), Confidential ( Confidential ), HL7, HIPPA 4010, HIPPA, ICD-9, ICD-10, HEDIS

Languages: C#, C, C++, Java, J2EE, Visual Basic, Visual C++, SQL

Other: MicroStrategy, Brio, Business Objects, Cognos, DBArtisian, Trizetto Facets Extended Enterprise 4.X/5.X, TriZetto Clinical Care Advantage 4.6, ICD-9, ICD-10, HIPAA 4010 transactions, HIPAA 5010 transactions, NASCO, McKesson CCMS, Xcelys / Diamond

GENERAL: Big Data, Service Oriented Architecture, SOA, Web Services, Sarbanes-Oxley, Enterprise Architecture, Systems Architect, Project Management, DBA, Data Architect, Data Modeler, Energy, Insurance, Transportation, Financial Services, Banking, Consumer Products,, Judicial, Legal, Data Quality, Data Warehouse Assessment, Master Data Management, MDM, Healthcare, HIPPA 4010, HIPAA 5010,ICD-9,ICD-10

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee

Responsibilities:

• Developed and teaches courses on Agile Project Management, Program Management / Multiple Project Prioritization, and Advanced Topics in Project Management.

Solution/Data Architect (Consultant)

Confidential, Chicago, IL

Responsibilities:

• Development of architecture and specifications for Data Lake (Big Data) project moving and analyzing Facets-based Medicaid claim and member data between HCSC and third-party processors. Project was scoped and designed to include Hadoop, Hive, Greenplum, JSON and binary files, and schema-on-read architecture. Models and supporting documentation developed and rendered utilizing Sparx Enterprise Architect Version 11.0.

Data Architect (Consultant)

Confidential, Schenectady NY

Responsibilities:

• Developed conceptual and logical data models for health insurer’s major business intelligence initiative. Conceptual model covered entire BI subject areas including member, claim, medical management, business operations, sales, and underwriting. The logical model is a 3rd Normal Form data model encompassing the Member, Group, Provider, and Party subject areas at the entity and attribute level. Models were produced in Visio (conceptual) and CA ERWin (logical and logical/physical) with MS SQL Server 2012 as the target database.

Enterprise Data Architect (Consultant)

Confidential, Rochester, Minnesota

Responsibilities:

• Developed data architecture and conceptual/physical 3NF and dimensional data models focusing on medical and disease management and support/administration of wellness programs run by Mayo's Global Business Systems unit. Models were conceived and developed from numerous sources and systems of record utilizing Sybase PowerDesigner 16.1 and implemented on Microsoft SQL Server 2008 databases utilizing SSMS and SSIS tools.

Enterprise Data Architect (Consultant)

Confidential, Columbus OH

Responsibilities:

• Development of conceptual/physical data models and ETL specifications for operational data store (3rd Normal Form) and enterprise data warehouse (dimensional models) for healthcare care management division using Sybase PowerDesigner 15 and ModelRight 4.0 for deployment in Microsoft SQL Server 2008 environment. Extensive use of SSIS and SSRS to develop and validate models that include payer, provider, and medical management (case, utilization, and disease management).

Enterprise Architect (Consultant)

Confidential, Eagan MN

Responsibilities:

• Development of conceptual and logical system designs for Teradata data warehouse and Informatica ETL implementations of claim and data, including integration to existing reporting systems and file/information flows to third-party vendors such as McKesson and Prime Therapeutics. Analyzed existing business documentation, collaborated with project manager on requirements, schedule and dates, and developed conceptual and logical system designs using the Sparx Enterprise Architecture toolset.

ETL Development Team Lead /Project Manager (Consultant)

Confidential, New York / HealthNow New York, Buffalo, NY

Responsibilities:

• Led Informatica development team on HEDIS and Pay for Performance business intelligence project, including project management and technical functions. Performed mapping and code reviews, conducted daily team stand-up (status) meetings and reported results to management, and handled interface and mapping issues between business intelligence analysts and ETL development team.

Enterprise Data Architect

Confidential, Detroit, MI

Responsibilities:

• Lead data architect on clinical and claim information data warehouse including 3NF operational data store (ODS) and star schema data mart/enterprise data warehouse (EDW). Subject matter and entities include claim, provider, member, case management, plan, and groups from Xcelys/Diamond and Facets claim systems. Developed canonical, logical, and physical models of ODS and EDW and worked with database administrators to implement the physical model. Drafted and published data dictionaries, source-to-target maps between source->ODS and ODS->EDW, and model equivalence to detailed business requirements. Used ERWin 8.0 and PowerDesigner 15.3 to design, develop, and publish models and DDL code for implementation. Operating environment is Oracle 11g with IBM DataStage for ETL and Cognos for reporting functionality.

Enterprise Data Architect (Consultant)

Confidential, Frederick, MD

Responsibilities:

• Data Architect for HIPAA conversion project for Axiom’s managed care organization client. Developed conceptual / physical data models and data dictionaries for specific HIPAA 5010 transactions (270, 271, 834, 835, 837i, 837p) using Sybase PowerDesigner V15.3. Integrated data models into overall solution architecture and developed conceptual/logical data models for reporting and data mining applications.

Enterprise Data Architect (Consultant)

Confidential, Rochester, Minnesota

Responsibilities:

• Developed conceptual (canonical), logical, entity/relationship data models for medical management (utilization, case management, authorization, codesets) in Sybase PowerDesigner and Visio. Also developed business terms and data dictionaries for the models.
• Developed conceptual data model for ICD-10 / HIPPA 4010/5010 conversion project
• Developed comprehensive data integration architecture for CIP project to transition initial release to fully-developed architecture including services/SOA, ETL source-to-target mappings from systems of record, operational data stores (ODS) and reporting data systems, and real-time data interfaces to/from multiple environments
• Developed mappings and high-level interfaces between Confidential operational systems and TriZetto Clinical Care Advantage (CCA) Version 4.6

Data and Services Architect (Consultant)

Confidential, Rochester, Minnesota

Responsibilities:

• Developed comprehensive logical and physical data models to support clinical and medical applications, including XML-based interoperability standards (HL7, Medbiquitus). LDMs and PDMs unified databases and sources across all AskMayoExpert applications and data sources.
• Developed data dictionaries for all physical data models.
• Developed detailed data flow diagrams for external and internal data models.
• Developed ETL data transformation specifications and mappings for non-ELS data sources.
• Developed target data architectures for reporting, analytic, and business intelligence functions from internal and external data sources.
• Designed service-oriented architecture (SOA) for applications to utilize database through services. Specified service interfaces (web and database-specific).
• Worked closely with Confidential Business Analysts to define and model various institution-specific concepts, such as Credential, Competence & Competency, Role and Permission, and Event.
• Performed detailed reviews of conceptual business information and data models applicable to the institution, including clinical and business-based models.
• Developed data architecture guiding principles and workgroup-based data and database change management controls.
• Environment is Oracle 10g, PowerDesigner, UML, Oracle SQL Developer, ClearCase

Enterprise & Data Architect (Consultant)

Confidential, Beaverton, Oregon

Responsibilities:

• Produced conceptual and functional/detailed models of the system and data architecture
• Produced conceptual, logical, and physical data models of front and middle-tier databases
• Re-architected existing provider databases to make them available to the enterprise, rather than to a few applications. Established and modeled domains for providers, facilities, coverage groups, plans, and line-of-businesses from multiple sources including proprietary databases and the TriZetto Facets Extended Enterprise 4.31 database.
• Re-architected web services and other SOA components within the system architecture
• Introduced Master Data Management (MDM) concepts to the organization, including the creation of data standards and founding of a data stewardship group comprised of business and IT managers Developed and coordinated source-to-target mapping of data for new enterprise database based on past practice and direction from data stewardship decisions. Developed detailed solution architecture for data extraction from source systems (Trizetto Facets Extended Enterprise 4.31 and proprietary sources) utilizing Microsoft BizTalk 2006 R2, including adapter and pipeline design/specifications, XML documents, orchestration and coordination strategies, and implementation of business rules via BizTalk Business Rules Engine (BRE) into the data transformation/rationalization sub-systems. Designed and developed alternative source data extraction processes and methods utilizing SQL Server Integration Services (SSIS) under Microsoft SQL Server 2008 and 2005.

Enterprise & Business Intelligence Architect (Consultant)

Confidential, State of Oregon, Salem, Oregon

Responsibilities:

• Performed a detailed data warehouse assessment and recommendations on the legacy Oregon Judicial Data Warehouse system, which encompasses statewide civil, criminal, and juvenile case data. Led team that performed a detailed data quality audit of the Oregon Judicial Data Warehouse with respect to the design of a new data warehouse that supports person-based as well as case-based analysis. Provided project manager with detailed work breakdown structures and time estimates for the data warehouse and data quality assessments.
• Developed business processes, criteria, and initial data models for new judicial data warehouse that supports judicial and courthouse management analytics. Data models and message protocols developed are based on the Confidential ( Confidential ).

Principal Consultant - Business Intelligence Practice

Confidential, Portland, Oregon

Responsibilities:

• Project manager and system architect on enterprise SOA project. Developed and designed approach to enterprise data abstraction layer & System of Record architecture based on SOA principles and web services. Developed work breakdown structure templates for project management workflow of data architects and database designers.
• Developed requirements and architecture for a solution to replace a broken energy trade audit system that was causing OMB Circular A-123/Sarbanes-Oxley and FERC compliance issues. Led small team on agile project to implement the solution in C#, .NET, and SQL Server 2000/2005. Developed and led project team (as project manager and lead contributor) on near-real-time hydropower optimization project that produces $3 million in additional revenue per year
• Developed system and data architectures/data models and implemented interfaces between energy trading floor deals and transmission scheduling system. Led 5-person project team. Prepared enterprise architecture and data flow documents to support federal enterprise architecture (FEAF) initiative. Provided roadmap linking FEAF documentation to Zachman and TOGAF enterprise architecture frameworks.