Establish a new statewide enterprise architecture practice focused on delivering value and aligning IT strategy with Business objectives and outcomes. Lead and manage a team of architects providing EA services across state agencies.

Established a formal Enterprise Architecture practice as the Chief Enterprise Architect. Lead a team of Architects across all architecture domains with the goal of aligning Information Technology to business goals. Develop IT strategy and guidance for use in high-level decision-making. Assist the State of Iowa with developing an Artificial Intelligence framework.

Manage and lead the Data Team responsible for the security, performance, availability and administration of Intoxalock's Enterprise Data Platforms, data warehousing, data integrations, reporting, and analytics. Develop, advocate, and implement Data Management Strategy. Create multi-year Data Team Roadmaps. Suggest and implement positive change by advocating organizational structure changes, new data roles, and skills necessary to support future data growth and analytics needs. Develop vision for future state modern data stack. Create training materials and standards for development, source control, and production deployments.

•Create enterprise standards and architecture for data development and data initiatives•Communicate and promote Data Architecture within Business and IT departments•Ensure data focused projects align with Enterprise Architecture and Business goals•Participate in the Information Governance Committee’s activities and decision making•Participate in Architecture Reviews•Create and communicate the Master Data Management Strategy for the enterprise•Team Lead role--Manage Data Developer Intern--Train and mentor junior Data Developers--Scrum Master for daily stand-ups--Conduct code reviews for data development efforts•Major Project Accomplishments--Lead Data Architect for the new Enterprise Data Warehouse project--Create change management and data governance policies and procedures, with input from Business, Internal Audit, and IT stakeholders, for the new Qlik Sense Enterprise data analytics platform

Provide consulting and development services to Financial, State Government, and small business in the following areas: Data Warehousing and ETL development, Database Architecture, SQL Server technologies, and Server Virtualization.

•Provide Database Administration support and consulting•Advise on the creation of database standards for the bank and produce relevant documentation•Provide mentoring and guidance for new Database Developers in regards to SQL Server, ETL processes, and bank IT processes•Work with business users to resolve MS Access and Excel issues•Project Work--Lead bank wide SQL Server 2008 R2 upgrade project-----Architect plan for upgrading bank’s SQL Server 2000/2005/2008 servers that support data warehouse, 3rd party application, internal web application, and reporting functionality-----Implement steps to upgrade SQL Server engine, SQL Server Integration Services and SQL Server Reporting Services-----Assist DBA's in converting DTS packages to SSIS-----Design physical database architecture to work with NetApp SnapManager--Collateral Management System replacement-----Design data model for new Securities Interface database and Securities Reporting database-----Help design ETL process in SSIS to import Securities information-----Assist developers by creating queries and stored procedures for web site interface-----Create SQL Server Reporting Services reports-----Develop and implement ETL process in SSIS to load new CMS data warehouse tables-----Performance tune queries, stored procedures, views and other 3rd party database applications-----Assist in bug fixing and conduct performance troubleshooting of Response Analytics Rules Engine software-----Assist in design and troubleshooting of SSIS ETL with Response Analytics Rules Engine software--Products/Rates database to support public web service and reporting needs-----Provide guidance and validation for logical database design in regards to Products Interface database and Products Reporting database-----Design and implement ETL process between Interface and Reporting•Give direction to Database Developer resources to help complete project work

•Implement database backup strategy to comply with database retention policy•Implement database maintenance plans to ensure database integrity and the rebuilding of indexes •Create SQL Server 2008/2008 R2 development and testing environments•Create SQL Server Reporting Services 2008 R2 instances for production and development environments•Architect and implement plan for upgrading production website database schema for new releases--Determine differences in current production database and next release schema--Determine data cleansing methods to fix issues with bad data--Write, test, and run T-SQL scripts to bring database schema and data in line with newest release•Create SQL queries for various financial and statistical reporting•Assist software developers with writing SQL queries and designing table schemas•Create indexes based on query usage to increase performance•Create guidelines for developers working in the production database project•Setup alerts for failed jobs and troubleshoot as necessary•Monitor SQL Server logs, cpu usage, and disk utilization•Allocate SQL Server resources and install SQL Server Analysis Services for future data warehousing project•Make recommendations to improve reliability and performance of SQL Server environments•Systems Architecture and Administration tasks--Perform administrative duties for VMware ESX 4 server--Architect and implement migration of virtual environment from VMware ESX 4 server to Microsoft Hyper-V--Install and configure Windows Server 2008 R2 on physical and virtual servers--Help perform IIS administration duties for production web farm--Participate in the planning of company Disaster Recovery Plan and clustered Hyper-V virtual environment--Perform Windows domain administrator duties

• Data Integration, Data Architecture, and SQL Server consulting for Federal Home Loan Bank of Des Moines• SQL Server 2008 Data Mart and ETL development for Great America Leasing Corporation• Oracle Data Integration and Data Warehousing development for Dice• Consulting and development for Iowa Department of Natural Resources’ various ASP.NET web applications• Architect/develop/test/deploy complex ASP.NET web applications as part of the Custom Software Solutions team• DotNetNuke installation, administration, and custom module development (C#)• Perform Database Administration for Alliance’s internal SQL Server environments • Perform Web Administrator for Alliance’s web servers running IIS 6 on Windows Server 2003

•Architect and administer infrastructure to support an enterprise level document management system for 200+ users•Help facilitate the technology aspects of company relocation•Plan and implement all upgrades/patches for the document management system and the supporting infrastructure•Specify, purchase, and deploy server and desktop systems within budget•Create backup strategy for corporate network•Perform role of Network/Windows Systems Administrator•Perform role of SQL Server Database Administrator•Participate in the analysis and review of new VOIP system•Research new viable technologies for the company

•Design, code, modify and test software written in Java (JSP) and C# (.NET) to interface with the company’s document management system (Worksite MP)•Debug legacy code•Perform role of SQL Server Database Administrator•Perform role of Network/Windows Systems Administrator•Create installation packages for all distributed software with Installshield Devstudio•Create relevant system and user documentation•Provide Tier 2 product support•Setup VPN solutions for corporate network

•Research ownership and subsidiary structures of various companies•Research and track various characteristics of targeted Mutual Funds•Revise company training documents and procedures used to train new employees