Will W Wagner

Senior Business Intelligence Architect @Yahoo

Playa Vista, CA, US

Senior Business Systems Analytics Architect, Enterprise Application Products Sep 2016 – Jun 2024 Architect and implement a data warehousing strategy that integrates Oracle Financials ERP modules such as Accounts Receivable (AR), Accounts Payable (AP), Cash Management, Fixed Assets, Procurement, Inventory Management, and other pertinent data sources. Manage ETL development initiatives, leveraging DataStage and Oracle Financials to enhance data workflows and boost the reliability of business analytics tools. Spearheaded the creation of specialized financial and customer experience reports and dashboards, employing HTML, CSS, and JavaScript for select advanced analytics visualizations. Utilized Distribution Services for efficient report dissemination, ensuring timely delivery of insights to stakeholders. Innovated with automated solutions for report distribution via Google Drive, enhancing the accessibility and management of business intelligence data. Developed a Confluence SaaS-based BI User Portal, enhancing real-time user interaction with a suite of operational tools and custom scripting. Implemented a Python-based monitoring system for automated email alerts, promoting server uptime and system reliability. Implemented JavaScript toggles in the UI, using a Google Drive file for script settings storage, enabling quick activation and deactivation of BI reporting automation without the need for a database. Composed Python scripts for data manipulation and server health monitoring, enabling immediate notifications and operational tag updates for clear communication during system outages.