We provide IT Staff Augmentation Services!

Enterprise Data Architect Resume

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

Hire Now