SUMMARY:

• Broad range of industry experience - including Health Care, Insurance, Higher Education, and Manufacturing
• In-depth experience with enterprise software solutions involving complex, multi-year, iterative efforts
• Demonstrated ability to quickly understand complex business environments, with solutions at various levels of maturity and integration
• Demonstrated ability to build and lead diverse teams, with varying levels of technical skill and business background - both direct reports and matrix teams
• Extensive experience setting / achieving progressive goals, using strong negotiating and consensus-building skills
• Expert level ability to build efficient, integrated data solutions - both operational and analytical
• Use of proven techniques to improve the consistency, quality and integration of business process and information
• Translation of architectural principals into tangible benefits and efficiencies
• A collaborative, people-focused lead that seeks to motivate and mentor others

TECHNICAL SKILLS:

• Data Governance principals
• DMBOK principles (Data Management Book of Knowledge)
• Master Data Management
• Reference Data Management
• Metadata Management
• Expert-level database design for both operational and Business Intelligence solutions
• Development with or selection of multiple Business Intelligence platforms, including: SAP / Business Objects: Data Integrator (ETL)
• Business Objects Universes (Semantic Layer / Ad Hoc Query environment)
• Crystal Reports
• Microsoft SQL Server
• Integration Services (ETL)
• Analysis Services (OLAP services)
• Reporting Services
• Power Pivot / Excel Services (Ad Hoc Query tools)
• Informatica (ETL)
• IBM (Cognos)
• Working Experience with multiple database platforms, including:IBMB2, Microsoft SQL Server, Oracle
• Proficiency with Structured Query Language (SQL) for data profiling and analysis
• Data modeling tool suites, including:ERWin, Embarcadero (Idera)
• Solution Development Lifecycle principles
• Working knowledge of TOGAF and Zachman frameworks
• Exposure to ITIL and COBIT frameworks
• Configuration Management principals and best practices
• Waterfall, Agile/SCRUM, and hybrid delivery methodologies

PROFESSIONAL EXPERIENCE:

Director, Data Warehouse and Reporting

Confidential, Brentwood, TN

Responsibilities:

• Development of data warehouse solutions, including operational data stores and dimensional models
• Construction of Microsoft SQL Server Analysis Services (SSAS) cubes, both tabular and multi-dimensional
• Development of report assets using SQL Server Reporting Services (SSRS) and Tableau
• Execution of project work to extend and enhance data warehouse solutions, including re-architecture/re-engineering efforts optimizing performance, maintainability and scalability
• Delivery of support and solutions via Kanban methodologies and Agile/SCRUM frameworks (respectively)

Data Manager

Confidential, Pekin, IL

• Establishment of a Data Governance initiative
• Creation and management of short- and long-term strategies / technical roadmaps
• Development of data standards and their application across functional teams (Business Architecture, Solutions Engineering, Quality Assurance, etc.)
• Build and optimize integrations between functional silos and disparate systems
• Support and development of compliance reporting, as well as internal and external reports
• Selection of technology and database platforms supporting operational systems, business intelligence, data modeling, metadata, and ETL
• Program management for Conversion and Business Intelligence tracks of Pekin’s new policy system rollout - a mission-critical, five-year effort
• Delivery of both operational and analytical data solutions, including the Data Warehouse
• Creation of job family and performance/training plans for multiple data professional roles, including Database Administrator, Data Architect, Data Analyst and Data Developers

Enterprise Data Architect

Confidential, Pekin, IL

Responsibilities:

• Created a data warehouse strategy, staffed resulting project
• Trained and mentored warehouse development staff on techniques such as ETL (Extract, Transform, and Load) development and dimensional design
• Designed overall warehouse architecture using a hybrid Inmon / Kimball approach
• Selected and deployed warehouse development tools and platforms
• Developed reports using a variety of tools and techniques
• Worked with Enterprise Architect to define and design data components of Pekin’s Enterprise Architecture
• Defined and maintained data standards for development and architecture

Data Designer

Confidential, Bloomington, IL

• Founding member of the Data Design Advisory Group, a department level-team responsible for setting strategic and tactical direction for the Data Design (Data Modeling) practice at State Farm. This group is also responsible for continuous improvement efforts related to design and architecture.
• Lead role in training and staff development efforts, design tool assessments, and process enhancements.
• Supported future state design of Property and Casualty system via mapping data from legacy systems for data conversion and sync.
• Database design for Client System re-write, based on IBM’s WebSphere Customer Center. Involved new functionality as well as redesign of existing processes and data structures, using iterative development methods.
• Team Lead for Customer System reference values and metadata management.
• Various database design assignments for the creation / enhancement of agent marketing materials and prospect list systems.

Data Designer

Confidential

• Data Design for State Farm’s Enterprise Claims System re-write. Design included implementation of new functionality and enhancement of multiple vendor-supplied products. Subject areas included core system design (claims, participants, cause of loss, subrogation, etc.), and rules engine database for claims payment
• Claims System team assignment entailed peer reviews of the team’s designs, coordination of resource assignments across multiple projects, mentorship, and model configuration / release processes.
• Enhancement of a vendor-supplied resource tracking system for State Farm’s testing organization.

Data Analyst / Requirements Analyst

Confidential

• Gathered, analyzed and summarized business and technical requirements for the University’s new Enterprise Data Warehouse.
• Created and maintained data movement specifications, source to target mappings, and accompanying transformation logic.
• Data movement development using the Informatica product suite and an ETL (Extract, Transform, Load) approach.
• Assisted with design of multiple data solutions Recruiting/Admissions, Student, Financial Aid, and Employee Benefits analytic data marts. Designed Financial Aid analytic data mart.
• Development of data movement test cases and supporting SQL code. Development of SQL to test data integrity and quality.

Configuration and Peripherals Coordinator

Confidential, Chicago, IL

• Reduced testing lead times for new peripheral and firmware testing.
• Worked with vendors to improve quality tracking and lead time for hardware components / assemblies, such as currency collectors / validators.
• Coordinated testing processes and monitored jurisdictional approval for new peripherals / firmware.
• Implemented process improvement related to Engineering Changes and Corrective Action Requests, resulting in a 30% decrease in review and approval lead times. Designed supporting databases.
• Quality assurance lead for Bill of Material / Engineering Change data processing.
• Maintained Bills of Material for all product lines.
• Maintained Configuration Management software and associated business rules and logic for production of Bills of Material.
• Departmental trainer for Configuration Management Department.