Edward Perez

■ Developed a new revenue analytics model in Looker for audience-based targeting that automated the revenue process while providing real-time data visualizations to executive leaders. Built a series of dashboards that provided insights into revenue risks, prospects, and forecasting for over $250 million of data-driven linear revenue. ■ Designed a new process for data-driven linear pricing that removed human touchpoints and reduced the level of effort by a factor of 4. This new process also provided first-time visibility into analytics using Looker around time to task, workload, and timeline. ■ Built a customer retention data model to provide sales opportunities around linear audience-based targeting, highlighting advertisers that churned away to other products or competitors. This Looker dashboard highlighted millions in lost revenue and sales opportunities. ■ Implemented a new pacing model for data-driven linear that provided real-time analytics around deal performance while automating the process. Developed new methods to trap and account for common problems with deal structure and performance that eliminated the need for constant support. ■ Developed and implemented SQL query templates on Snowflake data clean rooms to allow data visibility to customers while not sharing Personal Identifiable Information (PII) and complying with GDPR and CCPA regulations.

■ Designed, managed, and developed a Six Sigma methodology-based service level management and process improvement application that saved over $100,000 in penalties and over $4 million in annual licensing costs. This Java-based application, which leveraged SAS, was built to provide near real-time access and visibility for 800 of its top revenue accounts for service levels, key process indicators, and client satisfaction. Designed the application to feature automated sophisticated analysis and data visualizations such as control charting, process capability, fishbone diagrams, alerting, and root cause analysis. ■ Recruited, trained, and mentored an international team of Business Analysts, Data Scientists, and Senior Web Architects to handle development, implementations, transitions, configuration, and support for company-wide service level management, client satisfaction, and process improvement business functions. ■ Led the development of an SAS application called SETLA (Survey ETL Application) that saved the company above $1.5 million yearly in fees and licensing costs. Designed to process data from internal and external sources to determine statistical sample sizes, push the data to the appropriate survey solution, and create data visualizations. Analytics and health information produced an average 20% response rate, while the industry average was 8%. ■ A key contributor to senior leadership's weekly performance reviews of analytics, data visualizations, and customer satisfaction that showed poor performance and/or revenue risks. Developed new processes or technical solutions to remove revenue risks.

■ Managed designing an automated process improvement system for Six Sigma projects. The application was designed to keep projects measured and in statistical process control even after the project was completed via custom-developed data visualizations and dashboards. ■ Implemented projects and key measurements into the application using various ETL methods. Developed various SQL scripting techniques to automate and normalize data. ■ Tested initial design of application for production readiness. Led the team on application needs, bug fixes, and change requests. ■ Migrated the application and knowledge transfer of the core team of developers over to international off-shore resources for SDLC.

■ Defined desktop management strategy for GE Capital Corporate, including over 1,300 devices. Created and maintained over 100 Microsoft SMS packages and scripts, automating all installations within the environment. ■ Led server reduction project to reduce four servers from Microsoft SMS architecture and increase capacity, performance, and scalability. ■ Identified, developed, and implemented image management strategy and standards to reduce support time and costs. ■ Analyzed defective device problems and introduced a centralized virus definition strategy. Achieved 100% accuracy and device participation within four weeks.

■ Team lead for GE's Oracle Human Resources worldwide support desk managing HR, Payroll Interface, Compensation Planning, and Self-Service. ■ Hired and trained additional consultants to provide worldwide support and SDLC support for GE's Oracle Human Resources implementation. ■ Provided 24/7 support and configuration management of security, key flex fields, descriptive flex fields, value sets, and quick codes. ■ Developed graphical reporting dashboard in Business Objects to communicate volumes, service level performance, and root cause analysis. ■ Developed an automated data dictionary to document and aid transition managers in mapping in new data and business units into Oracle Human Resources.