Data Architect Resume Profile

.EXPERIENCE

Confidential

VP Solutions Architecture and Strategy

Solution architecture for BI, master data, big data, data warehouse and analytic solutions.
Draft and implement processes to gather functional and data requirements, design considerations and integration rules. This includes project scoping, project planning, resource allocation, data sourcing, report requirements, analytic requirements and business intelligence capabilities.
Implement strategy for data integration, analytics, and ETL development.
Leverage Infosense Information Management DI and BI Factory Methodologies.
Identify appropriate data quality strategies and production rollout processes.
Instrumental in leading multiple Data Integration and Analytics projects for the largest health insurer in the state of Tennessee, including the build out of the Teradata semantic layer for the Clinical Data warehouse.

Confidential

Sr. Data Architect

Lead architect implementing multiple Data Warehouses and BI applications on numerous customer engagements in the Oil and Gas, Utilities and Manufacturing industries.
Responsible for data requirements, data models, ETL design development, BI metadata layer and BI dashboard and report development.
Subject areas included production, supply chain, financials, operations, timesheets, orders, work orders, purchase orders.
Principle solution architect for the Rolta Oneview: Business Intelligence application. Responsible for designing an industry standard data warehouse model for manufacturing and process industries.
Developed prebuilt ETL packages and pre-built BI dashboards, KPI scorecards and reports.

Confidential

Consultant

Served as lead ETL developer on fraud detection claims data warehouse.
Implemented standards for ETL development as well as best practices for writing and tuning queries against very large data sets.

Confidential

Lead Etl Architect

Lead ETL development using a combination of Informatica and PL/SQL.
Created Master Person Index, used to identify an individual across disparate source systems.

Confidential

Consultant

Data architect, ETL and BI developer on various projects. Implemented training program for consultants on best practices for dimensional modeling.

Confidential

Data Architect

Responsible for requirements gathering and scoping.
Built Enterprise data model for the clinical.
Mentoring developers in best practices for data integration ETL/PLSQL .
Implemented MDM for master person and master customer.
Tuning - Performing evaluations on complex queries. Including analyzing explain plans and making changes to the physical database model to improve query performance.
Analyzing existing warehouse to identify issues and provide recommendations to reduce loss of data, improve query performance through improved physical database design as well as query rewrites and resolve Data Quality issues.

Confidential

Sr. IS Analyst

Responsible for requirements gathering, data source profiling, data modeling logical and physical and data mapping.
ETL Development using Cognos Decision Stream and PL/SQL.
Report and Dashboard development in Cognos.

Confidential

Business Analyst