Donny Houck
Johnstown,OH
Summary
Over twenty years of experience as a Business and IT professional in multiple industries including Health Care, Banking, Retail/Direct Sell, Supply Chain, Non-Profit Association and Insurance Excellent communicator with strong analytical and technical skills Results oriented professional with business and technical experience Motivated team player capable of managing multiple projects, deliverables and timelines Technical knowledge includes, Salesforce, Fonteva, Veruna/Amplo, WordPress, Gravity Forms, PHP, DocuSign, Microsoft Windows and UNIX/LINUX Operating Systems, SharePoint, Data Warehouse, MicroStrategy, Tableau Desktop/Tableau Server, Business Objects, SQL Server and Oracle Database, Hadoop, SSRS, SQL and SQL Server Management Studio, SQOL, Microsoft Office Suite, Microsoft Access, Visio and Project as well as advanced hardware, software and network configuration, maintenance and support
Overview
22
22
years of professional experience
Work History
Salesforce Administrator
OHIO INSURANCE AGENTS ASSOCIATION
03.2018 - 01.2026
- Platform customization and automation using Flow to meet business needs and reduce manual entry
- Software and Platform integration, API, and external system integration
- Build, maintain and customization of page layouts and fields to meet business needs, including relationships between objects
- Custom and ad-hoc reporting, dashboard creation and distribution
- Environment security, user and license management using Profiles, Roles and Sharing models
- Collaborated with cross-functional teams to gather requirements and implement system enhancements
- Training, documentation and user guides
- Data migration, management and data integrity through imports, exports and manipulation with Data Loader, Workbench, Dataloader.io
- Resolved technical issues promptly and effectively, providing exceptional support to Salesforce users across the organization.
Technology Liaison
OHIO INSURANCE AGENTS ASSOCIATION
10.2021 - Current
- Manage and maintain relationship and contracts with technology partners, including MSP and vendors
- Hardware and software support
- Environment configuration
- Website development and integration with existing systems
Client Experience Manager – IAMETRIC
OHIO INSURANCE AGENTS ASSOCIATION
03.2020 - 10.2021
- Lead online demonstration of website products, data entry
- Create and maintain Business Requirement Documents and Functional Spec document base on end user feedback
- Develop online solutions to provide seamless data collection for analysis and reporting
- Build and enhance complex SQL queries for data analysis, trending and metrics
Sr. Data Analyst
OHIO INSURANCE AGENTS ASSOCIATION
03.2018 - 03.2020
- Process Automation and digitization
- Modify existing, legacy process to move towards automation and digitization to allow real time data capture
- Develop online/website data capture tools and API functions (C# and PHP) to eliminate paper applications
- Include derivation and business rules to eliminate manual entry and pre-population of available data to improve efficiency and end user experience
- Partner to build data model and data warehouse to replace legacy data storage methods, integrate systems into a common shared platform
- Gather user requirements and evaluate technology solutions to meet business needs
- Develop SQL queries for daily, monthly, quarterly, year end and ad-hoc reporting
IT Data Analyst – Omni Channel
EXPRESS
02.2016 - 03.2018
- Data Mining, Historical Customer Purchase Trending
- Customer Profile Segmentation for personalized advertising campaign via direct (print) and digital (email) marketing
- Transaction level data mining of buying patterns, frequency and tendencies to develop Executive dashboards, reports and data visualizations
- Data validation of source and Thirty-Party systems for consistency and accuracy
- Requirement gathering from business partners to develop, update and maintain reporting
- Development of data marts and extracts for repetitive and automated reporting via Tableau
- Creating Tableau reports and visualizations for analysis, trend discovery and KPI dashboards
Senior Data Mining Analyst – Inventory Planning & Merchandise Control
Thirty-One Gifts
03.2015 - 01.2016
- Data Mining, Historical Trending and Analysis, Inventory Control and planning
- Gathered requirements from business partners for daily, weekly and monthly reporting via MicoStrategy and ad hoc SQL queries
- Data mining to identify customer buying patterns and apply data modeling for sales forecasting and planning
- Detailed sales analysis to pinpoint frequency of purchase trends and monthly sales hindsight
- Audits of inventory and sales systems to ensure item configuration accuracy
- Real time and previous day inventory accuracy reporting
- Designed and optimized advanced data queries
- Department and Team SharePoint administrator, following best practices for file, report and information sharing across multiple users, teams and departments with appropriate security and access levels
Senior Data Business Analyst – Operations
Thirty-One Gifts
12.2010 - 03.2015
- Reporting, Metrics, Trending and Analysis
- Developed daily, weekly, monthly, quarterly and yearly reporting to provide a detailed and high level view of historical and current Operations performance
- Defined Key Performance Indicator metrics for current cost analysis and historical trending
- Performed analysis of historical data to identify trends and identify actionable recommendations to improve business processes
- Designed and optimized reports to support Business defined metrics from various source data, including SQL Server databases, MicroStrategy and MS Excel for Supply Chain Analysis
- Data mining and detailed analysis of performance and productivity data to identify areas for improvement and process streamlining
- Partnered with business and technology teams for ad hoc reporting, data mining and analysis of metrics through SQL queries
- Designed and optimized advanced data queries
- Identification of historical and current trends to aid in capacity and inventory planning and deployment and facility layouts
- Post system implementation reconciliation through SQL queries to validate data, system updates and handshakes as well as report validation
Business Analyst – Global Finance Operations-Finance Reference Data
JPMorgan Chase
12.2006 - 12.2010
- Fully supported all areas of the Software Development Lifecycle through requirements gathering, conducting and leading formal requirements gathering sessions and offsite with several Lines of Businesses to document business needs and formal requirements
- Defining parameters and requirements to enable the takedown and decommissioning of legacy finance applications across core dimensions within Finance Reference Data and implement a more streamlined application and process
- Completing detailed analysis of applications, attributes, workflows, data, inputs/outputs, users and reports
- Developed roadmap to outline takedown sequence, business requirement document, detailed workflow and technical requirement document
- Partnering with business and technology partners to facilitate during Design and Implementation
- Acted as liaison between clients, business and technology – communicating successfully between all groups to ensure accurate testing
Production Engineer Retail Consumer Banking
JPMorgan Chase
06.2005 - 12.2006
- Proactively identifies and monitor high-profile production issues that impact the Retail line-of-business.
- Assessing business impacts, managing technical bridge calls and ensuring all necessary resources are engaged in order to mitigate and resolve issues within the time-to-repair goals
- Research and report business impacts, root cause and resolution details to the Retail Management Team
- Providing Incident and Problem Management Support to ensure visibility to the Retail Line of Business on issues from start to finish
- Exports and queries from PASE Lotus Notes, Peregrine SLQ and MS Access databases to provide data and ad hoc reports
- Additional projects and research for the continued development and improvement of Retail Production Assurance
Technical Specialist Nuclear Pharmacy Services
Cardinal Health
02.2004 - 06.2005
- Worked and managed in a team environment, providing technical leadership and advanced troubleshooting as a Subject Matter Expert
- Handling escalated issues and providing feedback to senior management and development teams related to common issues
- Liaison to Application Development for advanced issues
- Created custom built queries and reports - via Business Objects, Crystal Reports and SQL for trending and analysis reporting
- Creating Trending and Analysis reports for use by Management to identify problem areas and provided suggestions for improvement
- Provided End User business requirements and assisted Application Development with creation of technical requirements
- Facilitated root cause analysis and provided resolution analysis of known and newly identified issues
- Conducted ongoing analysis of current environment for possible areas of improvement
Nuclear Pharmacy Services Help Desk Integration/Migration Project Team
Cardinal Health
10.2003 - 02.2004
- Integral role managing project resources, timelines and deliverables as part of a 16 week knowledge transfer of a Nuclear Pharmacy Help Desk
- Outlined and executed a detailed project plan to transfer knowledge, procedures and processes to ensure a seamless transition to end users and clients
- Aided in the integration and set up of a new IT environment into a pre-existing Client and Customer Support Center
- Creation of documentation, including technical documents to support in the training of new support analysts, process and procedure documents and additional business documents
- Liaison between senior management and project team, conducting status meetings to update major stakeholders on progress and possible obstacles as well as provided proposed solutions
Education
Bachelor of Science - Computer and Information Science / Computer and Science Engineering
The Ohio State University
Columbus, OH01.2001
Masters - Business Administration
The University of Phoenix Online Campus
01.2022
Bachelor of Science - Business Management
The University of Phoenix Online Campus
01.2012
Skills
- Salesforce
- Fonteva Association Management System (AMS)
- Veruna/Amplo Agency Management System (AMS)
- WordPress
- Gravity Forms
- PHP
- DocuSign
- SharePoint
- Tableau Desktop & Server
- SQL Server, SSRS, SSMS
- Microsoft Office Suite & Microsoft Access
- Visio
- Project
Timeline
Technology Liaison
OHIO INSURANCE AGENTS ASSOCIATION
10.2021 - Current
Client Experience Manager – IAMETRIC
OHIO INSURANCE AGENTS ASSOCIATION
03.2020 - 10.2021
Salesforce Administrator
OHIO INSURANCE AGENTS ASSOCIATION
03.2018 - 01.2026
Sr. Data Analyst
OHIO INSURANCE AGENTS ASSOCIATION
03.2018 - 03.2020
IT Data Analyst – Omni Channel
EXPRESS
02.2016 - 03.2018
Senior Data Mining Analyst – Inventory Planning & Merchandise Control
Thirty-One Gifts
03.2015 - 01.2016
Senior Data Business Analyst – Operations
Thirty-One Gifts
12.2010 - 03.2015
Business Analyst – Global Finance Operations-Finance Reference Data
JPMorgan Chase
12.2006 - 12.2010
Production Engineer Retail Consumer Banking
JPMorgan Chase
06.2005 - 12.2006
Technical Specialist Nuclear Pharmacy Services
Cardinal Health
02.2004 - 06.2005
Nuclear Pharmacy Services Help Desk Integration/Migration Project Team
Cardinal Health
10.2003 - 02.2004
Masters - Business Administration
The University of Phoenix Online Campus
Bachelor of Science - Business Management
The University of Phoenix Online Campus
Bachelor of Science - Computer and Information Science / Computer and Science Engineering
The Ohio State University