Jack Gustafson Email & Phone Number

Los Angeles Metropolitan Area

Providing consulting services for Data Warehousing, Analytics, Business Intelligence, AI, Machine Learning, Data Architecture and Data Engineering.

Los Angeles, California, United States

• Enabled critical insights into enterprise performance metrics through the development of strategic dashboards.
• Identified and monetized new data opportunities, contributing to enhanced Audience Measurement and advertising performance metrics.
• Improved Sales Ops efficiency by quickly integrating Intelligent Call Management data, resulting in approximately $1 million monthly operational savings.
• Led a backend development team handling large data warehouse projects totaling 100TB using Teradata, Oracle, Siebel Analytics, Cognos, GoldenGate, and Informatica.
• Provided architectural guidance and data modeling expertise for databases exceeding 100 terabytes.
• Led a data platform migration to Snowflake/Databricks, resulting in $10 million in annual operational cost savings.

El Segundo, CA

• Enhanced Marketing Data warehouse, providing insights to the daily sales/activations for Internet and TV subscriptions. The environment was Teradata / Vertica / SQL Server / Power BI / Tableau.
• Expertly architected process that provided identity/address matches between multiple billing systems.
• Expertly provided analytics that halted billing migration, directly resulting in a $4 million positive impact on churn.
• Facilitated seamless data integration during the DIRECTV and AT&T merger, enhancing system compatibility and operational continuity.

El Segundo, CA

• Saved the company over $300,000 in consulting fees by creating an efficient write-off allocation model for Finance.
• Enabled the company to save more than $10 million annually by implementing real-time data feeds to Teradata, facilitating immediate business responses to critical events.
• Provided technical direction and data modeling expertise for the management of 100+ Terabyte databases, ensuring robust and scalable data architecture.
• Contributed to the reduction of churn and enhancement of sales through strategic oversight of the Active Data Warehouse, benefiting multiple enterprise operations.
• Streamlined analytical processes across Marketing, Customer Care, and other key departments, driving improved operational efficiency and decision-making.
• Executed the conversion of a 2-terabyte Oracle Data Warehouse to Teradata, facilitating the aggregation of 100 terabytes of consolidated data including billing transactions, calls, work orders, sales orders, viewership.

Greater Los Angeles Area

• Managed projects related to all functions of Data Warehousing.
• Provided technical direction and leadership regarding Data Warehouse Architecture.
• Supervised, managed and directed DBA team.
• Created methodology for Data Warehousing in Universal Music Group.
• Modeled data for Category Management Data Warehouse.

Walt Disney Internet Group

• Data Warehouse Architect (SQL Server 2000, Informatica, MS/DTS, Erwin).
• Modeled data warehouse to support the CRM systems (Epiphany).

• General Responsibilities:
• Install and implemented Email software with artificial intelligent knowledge base for automatic replies.
• Consult call center management teams on the maintenance of the expert system to intelligently route emails either to call center agents or auto reply to the customers.
• Lead internal projects as needed.Specific Accomplishments:
• Programmed Java Servlet to send email from a web form. The servlet allows fully parameterized forms for easy installation and use at any site.
• Created Data Dictionary for the application database. This allowed our customers and new consultants to learn the schema and write reports or extracts from the application database.

• General Responsibilities:
• Design and develop Data Warehouses for customers in retail, financial and healthcare industries.
• Consult on multiple aspects of Decision Support Systems including data acquisition, transformation, loading, SQL query tuning, database segmentation, planning and deployment. Specific Accomplishments:
• Led the project to create a data warehouse at Workers Compensation Fund of Utah. Also designed and implemented a Star Schema data warehouse. This included data that tracked customer claims.
• Led the project for the Pegasus Systems data mart to track hotel bookings from a hotel clearinghouse system.
• Programmed extraction SQL and shell scripts for a monthly financial report at Amazon.com. The program sped up the time for creating the report from 20 days to 1 day. The queries looked at all history and all.