Taco Bell Business Intelligence

Will Wagner

Costa Mesa, CA *****

310-***-**** ************@*****.*** Professional Profile GitHub OBJECTIVE

Seeking to leverage my expertise in Business Intelligence, Data Science, and Software Engineering, utilizing advanced algorithms and process improvement automation to innovate and drive success in a dynamic tech environment.

SKILLS

Data Integration & Business Intelligence:

● Extensive expertise in complex multi-source ETL, Data Warehousing, and Business Intelligence technologies, with a strong focus on designing and implementing algorithms to optimize data integration and analytics.

● Proficient in architecting, developing, and deploying BI solutions, specializing in both real-time reporting against transactional data for immediate insights and batch processing utilizing Data Warehouses for historical analysis.

● Skilled in creating dynamic enterprise dashboards and reporting systems to cater to varied business needs and data timeliness requirements.

● Certified MicroStrategy Engineer (MCE), adept with MicroStrategy product suite across Windows and Linux (RHEL) environments for comprehensive reporting solutions.

● Oracle Cloud Infrastructure 2024 Generative AI Certified Professional, skilled in Large Language Models

(LLMs), Retrieval-Augmented Generation, Semantic Search, Vector database, and LangChain, with proficiency in OCI Generative AI Service.

● Experienced with Looker, Looker Studio, and Google BigQuery for advanced data analytics and visualization.

Database Management:

● Proficient with a variety of databases, including DB2, MS SQL Server, MySQL, Oracle, and PostgreSQL, for comprehensive data analysis and reporting.

Project Management & Operational Tools:

● Employ JIRA, Salesforce CRM, and ServiceNow to streamline project management processes, enhancing team agility and project delivery effectiveness. Integrate version control best practices with tools such as GitHub to bolster collaborative development and ensure codebase integrity. Big Data & Analytics Tools:

● Acquired foundational knowledge through educational pursuits in Big Data technologies, with a focus on GCP platforms such as BigQuery, AutoML, and VertexAI, complemented by practical experience with Hadoop and Apache Drill.

● Proficiency in utilizing analytics and visualization tools like MicroStrategy, Looker, Tableau, and Business Objects to derive actionable insights.

Programming & Scripting:

● Utilize Python, shell, and MicroStrategy Command Manager for automation scripts, leveraging JavaScript to enhance dashboard functionality.

Business Acumen & Interpersonal Skills:

● A high-technology professional with a broad range of experience in engineering and business across various sectors including pharmaceuticals, apparel, health insurance, internet advertising, marketing, and finance.

● Passion for solving complex technical and business challenges through collaborative team efforts and a love for working alongside talented individuals from diverse backgrounds. EXPERIENCE

INWGR - Intelligent Network of World-Generative Resources, Costa Mesa, CA Founder & Chief Architect / Software Developer

July 2024 – Present

● Founded and currently leading INWGR, a forward-thinking initiative dedicated to creating AI agents that act as digital twins for humans, automating a wide range of tasks. My role involves setting strategic goals for both short-term and long-term AI development, with a focus on innovation and practical applications. This work is deeply aligned with my passion for advancing AI technology, and I am always eager to apply my expertise to new, collaborative opportunities that drive meaningful impact. Verizon Media / Yahoo! Inc., Playa Vista, CA

Senior Business Systems Analytics Architect, Enterprise Application Products Sep 2016 – Jun 2024

● Migrated MicroStrategy reports to Looker on GCP for teams transitioning from on-prem MicroStrategy to Looker, leveraging LookML and Looker API for data visualization and analytics.

● 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.

● Streamlined the MicroStrategy user creation process with ServiceNow, integrating approval workflows and automating profile setups, while also establishing a manager-based hierarchy access system, ensuring managers have secure visibility into their own expense data and that of their subordinates.

● Automated the retrieval and integration of data feeds from Concur SAP into the reporting system, enhancing data availability for refined reporting and analytics. Yahoo! Inc., Burbank, CA

Senior Business Intelligence Engineer/Architect - Data Analytics and Engineering Jun 2015 – Sep 2016

● Spearheaded the StatsLite business intelligence platform's creation, significantly boosting ad placement tactics for top publishers. With the Creative Strategist (CS) guiding the charge, we heightened search visibility and refined ad displays, using clickstream analytics to bolster campaign performance. Our Ad Optimization Strategists (AOS) and Account Managers (AM) collaborated, applying key metrics like click-through rates and engagement times to deliver Yahoo's sales team actionable insights into user behavior. This integrated approach led to smarter, data-driven decisions, redefining advertising success.

● Refined the management of Insertion Order (IO) ad campaign budgets, defined by customers for designated advertising periods, by designing and implementing algorithms that ensure the efficient allocation of funds. Our approach leveraged algorithms to analyze close to real-time performance data and user engagement trends, guaranteeing that customers' advertising budgets were optimally utilized throughout their campaigns. This strategic oversight not only maximized return on investment but also significantly improved the relevance and effectiveness of ads for end-users.

● The strategic tools and actionable insights generated by the StatsLite platform empowered us to customize ad campaigns with unmatched precision. This initiative resulted in a remarkable uplift in user engagement and a notable boost in the success rates of advertising campaigns, showcasing the unparalleled benefits of data-driven strategies in the evolving landscape of digital marketing.

● Designed an innovative, cross-platform ad marketplace with sophisticated audience targeting, utilizing JavaScript and HTML5 to deliver seamless experiences on a variety of devices.

● Championed big data initiatives, integrating Hive and Apache Drill with Hadoop ecosystems to provide deep analytics insights, setting new standards for data exploration and utilization.

● Devised strategic performance dashboards, upholding campaign fidelity and partner agreement adherence, directly contributing to trusted business relationships.

● Delivered outstanding support and enhancements for a large-scale analytics platform, enabling data-centric strategic growth and optimizing business processes for over 1000 end-users globally. Worked on MicroStrategy SDK enhancements enforcing business rules and displaying data availability at MicroStrategy web interface (Web SDK and dashboard plugins utilizing HTML, CSS & JavaScript). MG Research, Inc., Glendale, CA

Senior Business Intelligence Architect / Consultant Feb 2015 – Jun 2015

● Developed a SaaS model to support Healthcare Analytics. Motion Picture Industry (MPI) Pension & Health Plans, Studio City, CA Business Intelligence Architect/Developer

Sep 2011 – Feb 2015

● Developed and oversaw Microsoft SQL Server data warehouses for renowned studios including Sony Pictures Studios, NBCUniversal, Paramount Pictures, 20th Century Fox, Warner Bros. Entertainment, The Walt Disney Studios, CBS, and others, impacting health and pension plans of over 110K members.

● Revolutionized claims processing by innovatively using MicroStrategy as a robust claims assignment and distribution system, significantly streamlining operations and enhancing both efficiency and accuracy.

● Created advanced analytical models and interactive dashboards, equipping executives with critical insights for participant eligibility and claims management.

● Engineered and refined ETL processes for data consolidation, enhancing the data warehouse integrity and supporting comprehensive analytics for strategic decision-making.

● Identified and preempted fraudulent activities through sophisticated analytics, strengthening system trustworthiness.

● Worked collaboratively with analysts and stakeholders to convert complex requirements into customized BI solutions, providing decision-support tools and improving user engagement.

● Automated and optimized SQL-based data retrieval, significantly expediting the availability of actionable intelligence for key business indicators.

Pacific Sunwear of California, Inc. (PACSUN), Anaheim, CA Senior BI Engineer/Architect

Oct 2005 – Sep 2011

● Oversaw BI operations, optimizing ETL and database management, while maintaining MicroStrategy platforms to ensure ongoing operational excellence.

● Collaborated with stakeholders to create tailored reporting systems, maximizing resource utilization and optimizing database performance.

● Led the development and implementation of Market Basket analysis within the CRM framework to identify key product affinities, significantly influencing inventory management and personalized marketing strategies.

● Automated complex reporting mechanisms, partnering with the Finance team to streamline financial data workflows.

● Managed the integration of nationwide store and online customer data into the data warehouse, implementing a rolling update process that ensured reporting accuracy across various time zones and supported real-time insights into customer behavior and loyalty program performance.

● Developed comprehensive MicroStrategy-driven initiatives for promotions, pricing, and vendor compliance, bolstering business processes.

● Maintained data integrity through strategic data warehousing techniques, such as Slow Changing Dimensions, during product lifecycle changes.

● Crafted reusable SQL scripts and FTP tools to accelerate data processing and ETL efficiency. Senior Programmer/Analyst

Sep 2004 – Oct 2005

● Successfully spearheaded key system upgrades and custom module development for warehouse management, improving operational workflows.

● Pioneered a quality control module keyed to vendor performance, enhancing product intake efficiency.

● Streamlined the returns process with a user-friendly Return to Vendor module, promoting transparency and efficiency.

● Deployed database auditing tools that provided vital change tracking and data integrity within the logistics infrastructure.

Bausch Health Companies Inc. (formerly Valeant Pharmaceuticals International, Inc., originally ICN Pharmaceuticals, Inc.), Costa Mesa, CA

Senior Programmer/Analyst

Jun 1998 – Aug 2004

● Led the migration and modernization of enterprise resource planning (ERP) systems, streamlining operations for the Biomedical division's divestiture.

● Innovated automated document management solutions, enhancing distribution and reporting efficiencies, and significantly reducing manual workload.

● Implemented database integration and automated data exchange protocols to optimize global supply chain and export compliance procedures.

● Pioneered the development of a flexible e-commerce back-end infrastructure, adapting to diverse sales platforms and improving order fulfillment cycles.

● Advocated for and implemented an enterprise-wide analytics and business intelligence platform, advancing data-driven decision-making capabilities. EDUCATION

● Oracle University, Oracle Cloud Infrastructure 2024 Generative AI Certified Professional 2024

● Cockroach University, Introduction to Distributed SQL and CockroachDB 2024

● Machine Learning by Stanford University, Coursera (Andrew Ng) May 2016 – Aug 2016

● Big Data Technologies, MAPR Academy Apr 2015 – Sep 2015

● MicroStrategy Training, MicroStrategy University Feb 2006 – Aug 2009

● LUG Conference and Training, IBM Jun 2006

● Computer Science, Santa Monica College Sep 1994 – Dec 1997

● MS Degree, Mechanical and Civil Engineering, Moscow Civil Engineering University Sep 1984 – Jun 1989

Contact this candidate