Brett Mclaughlin Email & Phone Number

Allen, Tx, Us

Chicago, Illinois, Us

Norwalk, Connecticut, Us

• ESTABLISHED COMPANY-WIDE SUBSCRIPTION REPORTING. Developed a fully automated, daily updated, forward-looking representation of Datto’s $450M in monthly recurring subscription revenue, across five invoicing systems. It interprets complex contract terms, pending deals, transfers, free months, trials, dynamic usage, retroactive deal changes, and many unique billing models. This data set is considered the single “Source of Truth” for all of Datto’s internal and external financial reporting.• AUTOMATED BOOKINGS. Developed an automated process to detect changes to customer subscriptions and compute the change in ARR appropriately for even the most complicated deals. This system allowed a team of three analysts to handle over 3x the number of subscriptions, while slashing errors and improving transparency.• AUTOMATED 606 REVENUE RECOGNITION. Developed a fully automated monthly process to recognize revenue, compliant with the 606 Accounting Standard Code. This slashed the work of several accountants from weeks per month to fewer than three hours per month, with considerably improved accuracy.• CREATED AND MAINTAINED A “CLEAN” SALESFORCE LIST OF ACCOUNTS. Deduplicated and merged 460K accounts across six disparate invoicing and CRM systems, reduced to fewer than 280K accounts for load into Salesforce. Then, developed and maintained an automated monthly process for reliably detecting and mitigating duplicates, even under tricky circumstances like company renames, mergers and acquisitions. • MIGRATED FOUR BILLING SYSTEMS INTO NETSUITE. Solely responsible for re-articulating customer subscriptions from four billing systems (two implementations of Zuora, and two custom invoicing systems) to be loaded into NetSuite. Far more than a simple contract migration, this involved expressing new forms of pricing, discounting, ordering, and provisioning: All in ways radically different, yet 100% revenue neutral, for all customers.

Cambridge, Ma, Us

• STANDARDIZED DEAL VALUATION. Nicknamed “Drive” (the Deal, Revenue and Invoicing Valuation Engine), this system predicts, in real time, the Revenue and Invoicing value of new or modified deals (the terms of which can be extremely complex and inter-linked with usage), based upon specific contract terms and forecasted internet traffic patterns. Akamai uses DRIVE to approve new deals, to pay Sales Rep commissions, and to measure Product Manager productivity.• STANDARDIZED SALES TERRITORY INVESTMENT. Developed a tool (“LP Investor”) used by Senior Management to optimize Akamai’s sales investments. This system uses a Linear Programming model to guide investment in Akamai’s 48 Sales Territories, in a manner that maximizes total ROI while honoring more than twenty operational considerations per territory. These considerations include average rep tenure, account penetration, market saturation, and Max/Min spending thresholds per Territory, Geography and Business Unit. • STANDARDIZED SALES NEGOTIATIONS. Developed a tool (“Comparables Generator”), to help salespeople easily identify the best products, deal terms and prices to propose to customers. Reps can enter any known deal or account details (from a list of thirty-five characteristics, including geography, industry, total spend, types of traffic served), and optionally adjust the relative importance of each. A scoring algorithm then compares this customer to every active customer, finds the most similar deals, and uses that data to make context-specific deal recommendations.

Cambridge, Ma, Us

• SIMPLIFIED PRODUCT CATALOG. Developed a massively simplified Akamai Product Catalog, slashing total products for sale by a factor of ten, while also simplifying and consolidating configuration options. This formed the basis for further simplify Akamai’s pricing structure, and finally to standardize price points. This initiative greatly streamlined product sales, to allow Akamai’s channel sales to accelerate growth.

Cambridge, Ma, Us

• AUTOMATED COGS ALLOCATIONS. Developed a tool (“Cogs 2.0”) for collecting and reporting upon the cost of Akamai’s extensive server network. It applies complex depreciation and usage rules to Akamai’s 200K+ servers, and subsequently allocates indirect costs based upon product, traffic, and account details. The result is a fair, Finance-blessed, and widely-used view of per-account and per-product costs.• AUTOMATED FORECASTED REVENUE. Developed “the Robot”, Akamai’s Revenue Forecasting system, it produces the revenue forecast announced each quarter to Wall Street analysts. This system forecasts internet traffic for every Akamai client, identifying client-specific trending and seasonality. It then runs these forecasts through our Invoicing system, to generate a hyper-detailed simulation of the upcoming quarter. It has been in use for more than ten years.• STANDARDIZED DEAL DESK PRICING APPROVAL. Developed a system for Akamai’s Deal Desk to properly determine mathematical price curves, based upon a variety of product and deal characteristics. This let Deal Desk members quickly and consistently approve special pricing situations.

Morrisville, Nc, Us

• AUTOMATED ORDER TRACKING. Developed Lenovo’s Global Order Status system, an application to handle all of Lenovo’s order reporting for internal business users, external partners, and major customers.• AUTOMATED APPLICATION TRACKING. Developed a data model and reporting tool for Lenovo to track and report upon over five thousand IBM and Lenovo business applications. This was a key part of Lenovo’s strategy to fully separate its business activities from IBM's and to migrate Lenovo to its own long-term IT platform.

Boston, Ma, Us

• DEFINED ENTERPRISE DATA GLOSSARY. Developed a colorful and engaging handbook of M|C’s entire business and data nomenclature and relationships (e.g., Product, Account, Event, Stage, Track, etc). This taxonomy was based upon extensive interviews with senior level management and key operational experts, and was published and distributed throughout the organization. • ESTABLISHED ENTERPRISE-WIDE REPORTING. Built “SLX-Report”, M|C’s Communications enterprise-wide sales reporting system. This reporting system provides up-to-the-minute sales reporting across the entire organization, using the unified business nomenclature. It was integrated into the company's operations management system, automatically notifying operations project leaders and standardizing sales commissions policy.

Burlington, Ma, Us

• Developed and implemented Prospector, a global Business Intelligence system that merges business activity from seven sales offices and six manufacturing plants in the United States, Belgium, Canada, Denmark, France, Germany, Japan, Russia and the United Kingdom.• Prospector allows upper management to see total company sales, on an up-to-the-moment basis, in any currency used within the organization. It also provides tight coordination between sales offices and manufacturing plants, to quickly route sales to the optimal manufacturing plant. This routing process uses a sophisticated algorithm that assesses the customer’s desired delivery date, current plant utilization levels, the specific items ordered, plant/customer proximity, and even country-specific customs issues.• Prospector’s global implementation involved designing over-arching data flow diagrams (illustrating the entire lifecycle of all data flowing into the company, through validation / normalization / aggregation, and into the data warehouse); full network topologies (illustrating every machine, connection, application, protocol and operating system); logical and physical data models; and ETL documentation standards used by on-site warehousing teams in each country.

Boston, Massachusetts, Us

• AUTOMATED NUCLEAR MATERIAL TRACKING. Developed “Prospector,” a global Business Intelligence system that merges business activity from seven sales office, six manufacturing plants, and nine countries (United States, Belgium, Canada, Denmark, France, Germany, Japan, Russia and the United Kingdom).• This system allows upper management to see total company sales, on an up-to-the-moment basis, in any currency used within the organization. It also provides tight coordination between sales offices and manufacturing plants, to quickly route sales to the optimal manufacturing plant. This routing process uses a sophisticated algorithm that assesses the customer’s desired delivery date, current plant utilization levels, the specific items ordered, plant/customer proximity, and even country-specific customs issues.• Its global implementation involved designing over-arching data flow diagrams (illustrating the entire lifecycle of all data flowing into the company, through validation, normalization, aggregation, and into the data warehouse); full network topologies (illustrating every machine, connection, application, protocol and operating system); logical and physical data models; and ETL documentation standards used by on-site warehousing teams in each country.

Us

• Oversaw Palm Computing’s effort to design and implement a hybrid Oracle/MySQL data warehouse to store all of Palm’s web logs, application logs, and wireless user information. This involved the creation of countless PL/SQL ETL scripts to clean, normalize and aggregate data from disparate sources, and load this data into a single, fully-normalized data warehouse. • Designed a reporting data warehouse schema to effectively balance management’s demand for speedy reports, with the necessity for reasonable daily back-end processing performance.

Cambridge, Ma, Us

• Solely responsible for overseeing the redesign of the back end of Akamai Reporter 1.9. Reporter is Akamai’s customer-facing reporting system, which allows customers such as Yahoo!, CNN, Apple and Microsoft to generate performance reports about their website and streaming activity. • Led a team of five engineers in the development and maintenance of Akamai Problem Solver, Akamai’s online, customer-facing troubleshooting knowledge base. Performed the Oracle installation, all physical and logical database design, and oversaw all front-end development. • Worked with a team of two consultants and a project manager to develop Ask Akamai, Akamai’s document management system, which allows ad-hoc searches of Akamai’s document base, along with proper workflow validation (i.e., managers can request to approve all documents submitted by their employees). Performed all database design & installation, web page development and hardware procurement.

Austin, Texas, Us

• Proposed, designed and developed Oracle Express Query Statistics, a 3-tier reporting application for Oracle customers to monitor the performance of Oracle Express data warehouses. This tool gathered statistics in Oracle Express, inserted them into one of six supported RDBMS’s, and allowed customers to generate reports through a query-by-example user interface. Solely responsible for all facets of design and development of this application, from its inception through two subsequent releases, which included testing & optimization for seven different relational database platforms. • Developed a tool to dynamically translate complex Oracle DDL, DCL and DML SQL statements into formats readable by six other relational database platforms.

Burlington, Massachusetts, Us

• Worked on a small development team to design, develop and implement a data warehouse and reporting system. This warehouse was a combination of relational and multi-dimensional databases and was used to store information on a wide range of statistics and properties of pharmaceutical products.

Mba, Business Administration And Management, General

Ba, Finance

Graduate Course In Applied Probability

Education record