Joseph Ziegenhorn

About Joseph Ziegenhorn

Experienced Business Analyst with a demonstrated history of working in the information…

Experience

1. Business Systems Manager

   GoEngineer

   Dec 2022 — Present · Buffalo Grove, IL, US

   Manages the business strategy related to NetSuite CRM/Financials, PowerBI Business Intelligence, Azure Data Warehousing, AI powered efficiency improvements, and ETL connectivity. Leads team with skills in Business Intelligence, Project Management, Data Engineering and Business System Administration.Scaling through technology: After 3 years, increased the amount of customers supported by 2.5x with the same headcount. Manages team handling:400+ support cases per month. 800+ Active System UsersERP/CRM Data Governance company wide.100+ Cross functional projects per year.50+ Active PowerBI Analytics tools.50+ ODS under governance.50+ Running data automations in a centralized data warehouse with 4 active business system backups.Results:Order submission: automation, data validation, and governance results in lowest in industry rejection rate of orders. Sales data: commissions and sales enablement data quality improved from ~12% defect rate to ~2% defect rate. Prescriptive defect detection analytics launched and continuous improvement framework established. Customer data: Business critical data defect rate reduced from 18% to 3.2%. Prescriptive defect detection analytics deployed. Product launch metrics: Developed BI to simulate missed opportunity and pin point performance/strategic adoption training opportunities. Enabled focused management for strategic adoption. Cyclical analytics to CRM relationships: Feeds advanced analytics back to CRM as digestible fields. Enables account level insights as a part of customer population. Focuses customer success on evolving purchasing patterns. Adaptive data validation: Benchmarks loaded and related to evolving data. Proactive detection of data anomalies. Sales Pipeline: 1:1 sales to pipeline data sources. Imaging to normalize pipeline business intelligence and see direct relationship to resulting sales. Normalizes sales rep patterns to give forecast.

Education

• Elmhurst University

  Bachelor's Degree, Interdisciplinary Communications

  2008 — 2012

Skills

• Customer Centric Solutions
• Business Process Improvement
• Microsoft Office
• Team Building
• Operations Research
• Microsoft Word
• Team Leadership
• Operative Dashboard
• Sql
• Process Engineering
• Solution Development
• Customer Support
• Escalation Resolution
• Marketing Strategy
• Third Party Billing
• Operational Cost Analysis
• Accounts Receivable
• Project Management
• Technical Leadership
• Rhetorical Analysis
• Strategic Planning
• Organizational Development
• Excel Dashboards
• Strategic Communications
• Sap
• Account Management
• Business Modeling
• Logistics Management
• Accounts Payable
• Public Relations
• Microsoft Excel
• Technical Writing
• Operational Planning
• Interpersonal Leadership
• Customer Service
• Custom Reporting Solutions
• Operations Management
• Data Analysis
• Business Intelligence
• Employee Training