TECHNICAL SKILLS

PROJECT MANAGEMENT: MS Project, Six - Sigma, ClearCase/SCCS/RCS CM, Yourdon/Demarco

BUSINESS MODELING: UML, Rational Rose, Visio, … Yourdon / DeMarco

DESKTOP PRODUCTIVITY: MS Office (Word, Excel, Project, PowerPoint, Access)

WEB DEVELOPMENT: ASP, Cold Fusion, Perl

N-TIER WEB INTEGRATION: Web Logic & ATG Dynamo N-tier App Servers

AUTOMATION: AutoSys & ESP, MQ-Series, SCADA, Real-Time

DATABASE PLATFORMS: Oracle, Sybase, SQL Server, DB2/UDB, Informix, RedBrick, FoxBASE

DATABASE ADMIN/DEV TOOLS: S-Designer, Erwin, DB Artisan, TOAD

DATABASE DEVELOPMENT TOOLS: T-SQL, PLSQL, ISQL, DB2 Connect, DB Gateway Tools

OPERATING SYSTEMS: Sun UNIX, HP-UNIX, AIX, LINUX, POSIX, MS Win 3.x - 2008

UNIX SCRIPTING/ CODING: Sh/csh/ksh, sed/awk/grep, C language, Perl.

NETWORK UTILITY: TCP/IP, NFS, DNS, FTP, Wftp, Powershell

REPORTING: Business Objects, Crystal Reports, SQR, SSRS

ETL TOOLS: Informatica, BO, DB2export, SQLloader, bcp, SSIS, & Low level coding for huge data sets

DEVELOPMENT: First half of career in development.

PROFESSIONAL EXPERIENCE

Confidential

Enterprise Data Architect

Responsibilities:

• Go to guy for Production Issue Resolution and Development Team Support for efficient design to forward business continuity.
• Full mature automation of large - scale data transfers enabling years of work gifting to another state with ½ days configuration.
• Parameter and environment-file driven, simple configuration for error reporting, fully documented for transfer.
• Data Architect Rapid Onboarding Documents to guarantee Knowledge Transfer, Environment Setup, and Position Duties:
• “Data Architect Getting Started” (DA Overall Knowledge Transfer Document.)
• “UNIX Environments Putty Setup” (Jump start the unaccustomed to being fully productive in minutes not days.)
• “Erwin Knowledge Transfer” (Data Modeling tools usage, development interaction, and application of standards.)
• Comprehensive Delivery Means: “iTrace and Rational ClearQuest usage, approval, and deployment procedures.
• “Data Refresh Knowledge Transfer” with Overview of Purpose End-To-End Processing Instructions..
• “Domain Integration for Work Efficiency” (Network proxy methods for connectivity in a Multi-Domain shop.)
• “ModelMart Subject Area Table Listing” (Identifies naming standards applied to tables across all subject Areas.)
• Produce “Problem Recommendation - Data Release Downgrading” (Identify and Eliminate recurring failures.)
• Produce “Proposal for Rapid Applications Deployment Methods”: Consistent Speed to Market with lower resource needs.
• Solutions across OHMITS account - Simplified Business Understandings yield often missed efficiencies and fault tolerance.
• Stabilize, Simplify, Automate and Document Extensive Data Refresh Processing to eliminate issues from this critical process.
• Privacy Data De-Identification: simplified cumbersome 2 week process, to less than 2 hours: Simplify, Automate, Document.
• Data Engineer Candidate Interviewing and Selection

Confidential

Enterprise Data Architect

Responsibilities:

• Create "Current State", and “Data Roadmap” Documents soon after start Date
• IT Candidate Interviewing and Selection
• Monitoring Alert Response for Root Cause discovery, Including auto-trace & lock/block checking
• Table Driven: Store Deployment, DWH Store Additions, and Store Specific and Common Data Deployment
• Comprehensive review and improvement of ETL data assembly to insure of data integrity data with high performance.
• Gain understanding of undocumented BI system DOMO and document all delivery means for ongoing success.
• SQL Server Assessment/ Remediation: rapid review and remediation of an environment in stress to successful when pressed
• Automation of several difficult recurring manual data loading to simplify and eliminate issues, and guarantee rapid success
• Extensive comprehensive documentation on all scripted automation means to eliminate the very need for my very position.
• Stabilize/Simplify Automate New Store DB creation from-scratch: 2-3 min. consistent success
• (Southern Indiana Merger Feb2017: 11 new stores generated 2 minutes per store without a single issue day 1.)

Confidential

Enterprise Data Architect

Responsibilities:

• Strategy team, technically backing the CIO: defining purpose, intent and structure to meet business objectives
• Architect means of adapting environment to enable business efficiencies, fault tolerance, continuity & recovery.
• Engage in Solutions Analysis/Delivery on critical business objectives; Rapid Delivery of new business functionality
• System Re-Engineering: Medical Claims Re-pricing Systems to provide “Best-Savings” 10% increase in savings on $1B/yr
• End-to-End Automation of manually run, time-sensitive Reclaim Business unit, with sizable revenue results first use
• Consolidate/unify processing, ease maintenance, system scalability, and rapid new-client onboarding
• P&T Resource: root cause discovery and resolution for systems with high-resource-consumption and locking/blocking issues.
• Go-to guy for rapid automation, solutions for complex processing, big data delivery needs, and tough integration tasks
• Data Scientist heading up Analytics for Company on Executive KPI Dashboard & Work Comp Claim Cost Containment
• 24x7 DW for Confidential RX reporting; optimization of Confidential Reporting Queries. SSIS & SSRS

Confidential

Enterprise Data Architect

Responsibilities:

• Engage in Solutions Analysis/Delivery on critical business objectives; Rapid Delivery of new business functionality Accurate Cost Projection: Alignment and value-add to claims data allowing cost reduction and accurate estimating Year Of Account tracking to allow for accurate risk sector profitability studies for proper alignment of new business
• Bridge-building with all business unit leaders and rapidly add value to inspire confidence and trust in IT capabilities
• Production of Decision Support BI Data Warehouse from highly fragmented data -> owner’s 20-year dream delivered
• Eligibility Data Corruption Minimized & Eliminated while tuning complex processing to 2% of accepted runtimes
• Assemble and cleanse data from highly fragmented objectified legacy databases; coordinate accurate use in new system
• Act as Enterprise Data Architect Defining Overall enterprise architecture to sponsor a stable rapid development environment as well as development forward planning of DB design, Problem Avoidance/Solving and Tuning.SSIS & SSRS
• EDI Process troubleshooting and automated State Analysis; automated B2B data transfer, and dashboard monitoring
• Claims Cost Estimating and Case Management - . International catastrophe email alerts tuned from 24 hours to 7 seconds