William Otto Email & Phone Number

Bad Homburg, Frankfurt, De

Solutions Architect and IT/Financial Analyst working with Financial, Accounting and IT teams to provide on-demand KPI reporting to stakeholders, troubleshooting of current and new solutions, and ad-hoc problem solving. Providing financial analysis and designing new solutions for reporting to 90+ locations around the country• Created staging and production environments that allowed for new analysis of KPIs without downtime or daily lag. • Developed, implemented, and managed Azura’s first BI reporting environment through PowerBI for single source metrics.• Supported and developed processes and procedures across multiple teams including; Sales, Operations, FP&A, IT, and Accounting.

Ch

Examined and documented of US monthly and quarterly financial reporting.• Created staging environments that allowed for new analysis of Key Performance Indicators (KPIs).• Automated over 30 reports, saving over 250 hours of labor per month.• Performed ad-hoc data calls for internal executives, external partners, and regulatory officers.• Performed data asset on integration team for $29B merger, streamlining multiple data systems for all North America Claims reporting.• Designed and built system for tracking payment authority across claims and notification to customers.• Assisted the audit team with claims Sarbanes-Oxley Act (SOX) compliance.

Identified changing landscapes and proactively created reports for the future needs of executive users.• Provided metric reporting and efficiency analysis for greater than $30M per year marketing effort.• Implemented a business intelligence reporting environment with less than two-minute runtime for over 200 reports.• Created and streamlined call center system reporting to produce an impactful and integrated business environment. • Performed as Data asset on a team that closed >$2B of bond sales.

Paoli, Pennsylvania, Us

Managed internal IT systems for this 80 Employee, 3500+ customer, $10B+ asset protection security firmPerformed network diagramming, maintenance, troubleshooting and future planningBuilt/Repurposed servers in efficient and redundant configurationsProjects included: Migrating e-mail system from MS Exchange to Google Apps (80 users, >75gb of data)Implementing an intranet websiteWorking with developers to create a customer dashboard for monitoring client businessesTroubleshooting various internal client, server and network problemsMaintaining a 24/7/365 uptime commitment as required by UL Regulations

Boston, Ma, Us

Managed workflows for internal auditing and accounting. Selected to participate in GE Information Management Leadership Rotational Program• Planned and performed a discovery and migration for an obsolete data environment.• Implemented new shop floor technology critical for shipping and receiving functions, payroll and quality tracking.• Analyzed and selected business intelligence software, and planned migration to the new application.• Created server test environments and hosted global training sessions on new software.• Reconciled overall revenue and expense accounts globally across three finance systems.• Trained/Tested internal accounting for global and holding companies.• Interacted and worked with people in over 10 countries and across the US whileperforming discovery of over 70 sites worldwide.