SUMMARY

• 15+ years in SW Development and database applications Data analysis, profiling, integration and quality Defining data strategy, sourcing, modeling, integration and architecture Facilitating requirements, development teams, delivery and stakeholders. Providing framework, stewardship, governance and management; Standards for data and processes; Solution structures, sourcing, integration, security and retention
• DW and Mart modeling with ERWIN Advanced SQL Application Integration, Process Data Flows, ETL Source to Target Data Mapping, Test Automation Agile team leadership, SCRUM. Proven enterprise results
• Demonstrated communications and collaboration skills with teams and stakeholders.

Lead Data Modeler

Confidential, Columbus, OH

Responsibilities:

• Recommended Snowflake web based scalable database for new cloud-based enterprise warehouse platform. Flattened semi-strutured data in JSON and XML formats for Snowflake ingestion and parsing.
• Coached Data Analytics team on DataVault 2.0 strengths and weaknesses for cloud based warehouse foundation. Designed and delivered invoice-based data extract for pricing optimization vendor. Evaluated and recommended warehouse automation solutions Attunity and Wherescape

Lead Data Architect

Confidential, Minneapolis, MN

Responsibilities:

• Led design of integrated enterprise data layer at Confidential client. Interviewed and staffed data architecture team. Supported HealthEdge cloud-based claims adjudication and all related data interfaces for transactional and reporting platforms.

Lead Data Architect

Confidential, Wayzata MN

Responsibilities:

• Led business, systems and data analysis and design at HealthPartners client supporting fast paced .NET and Java application team implementing Test Automation frameworks. Created Oracle 12c entities and integrated data models spanning enrollment and medical claim data with more than 3,000 attributes.

Healthcare Data Architect

Confidential, Minneapolis MN

Responsibilities:

• Multiple new sources. Designed and Implemented Enterprise level Financial ($40M impact) Data Integration Project on time. Primary architect for the new HealthEdge Individual and Family Business initiative, resulting in 1 billion in new revenue. Reverse Engineered undocumented OLTP, Logical / Physical modeling for a new ODS and staging platform, and the integration and enhancement of multiple dimensional
• Data Marts. Source data profiling, source-to-target mappings, model reviews, capacity planning, impact analysis. A second major initiative was to integrate a PBM Pharmacy Benefit Management system for CVS claims, leveraging the new ODS and staging areas. Environment is ERwin, Oracle 11g and Exadata, Informatica, Agile / SCRUM. Took complete ownership of subject areas, interfacing with product managers
• DBAs, Reporting teams, and leading the technical and QA resources for deliverables. Mentored Oracle 11g and 12g and SQL Server DBAs, BI architects, and DW architects in best practices and DW solutioning. Coached users, architects and developers on efficient Oracle SQL against very large database objects. Investigated MarkLogic NOSQL data integration and led big data technology proof of concept technology assessment for data lake. Led enterprise team implementation of data masking and subsetting to protect PHI data.

Technical Architect

Confidential, Durham, NC

Responsibilities:

• Managed $1M budget, without on-site supervision, 10% travel. Documented formal business requirements and resulting technical system requirements including reporting and measurement through sixteen platform releases, to unanimous peer review approval. Mentored Oracle 8, 9i, and 10g DBAs and data modelers in enterprise ticketing Data Warehous
• Directed design and maintenance of DW presentation layer object naming, definition, and revision. Reverse-engineered data models of legacy ticketing and provisioning systems for enterprise planning. Created an enterprise view of ticketing data to decrease the risk of fines and to improve data security. Oracle

Tier 5 System Engineer

Confidential, Basking Ridge NJ

Responsibilities:

• Designed BI server applications and reviewed system and technical designs with developers. 10% travel. Led interdepartmental team negotiating helpdesk roles and responsibilities. Planned, designed, and implemented Cognos server installation, cube design and development
• Conducted critical incident bridges with global senior management and development leads. Resolved production query and quality issues, through SQL analysis of diverse databases, tuning and coaching. Collaborated with key vendor partners developing SOW including measures and negotiated cost.

Area Operations Manager

Confidential, Houston TX

Responsibilities:

• Supervised 8 supervisors, 8 clerks, and 111 union technicians in switching, facilities, and outside plant. Managed $7.5M budget, $550M capital assets in 38 buildings, without on-site supervision, 70% travel. Managed T3 and T4 facilities and private line provisioning, and supported $25M network sales. Transformed distributed engineering team into high performing
• Collaborative, customer-focused team Led national interdepartmental Quality team which reduced nodal services ordering intervals 30%. Managed 30% management and occupational force reductions..

Finance System Development Manager

Confidential, Alpharetta GA

Responsibilities:

• Staffed new team of 4 second level managers and 12 business and system analysts. Built new online financial system, implementing my financial architectural recommendations. Managed a $3M budget., without on-site supervision, 50% travel. Mediated interdepartmental claims policy in rapid high visibility financial claims system development. Met all system development objectives against tight timeframes and changing requirements
• Represented enterprise regulatory department as subject matter expert