2019-04-01 Meeting notes

Abe

• Dynamic Ratecard

Current state: quarterly import of rates…

• Phase 1: produce the 3 data inputs for manual ratecard output generation

  • Locate 3 data inputs on Looker

    • Revenue: Julia is working on it, last minute requirement

    • Impressions: in SSRS; abe asking corevalue about Looker field with error

    • Utilization: in corevalue's Venue Sellout Summary with Order Drilldown (demo'd Friday)

• Phase 2: automate the ratecard output generation

  • Help jawad

• Looker project work: customer success Churn Rate finalization, awaiting user review

• Looker enhancements / cleanup work, standardization

• Service Desk Tickets:

  • Looker administration

  • Jira administration

  • Tickets for reports, mostly the elevator health logs for the NOC

Stacey

Off next week! Enjoy~

• CRM to Netsuite Data; preparing mapping for upload for sandbox tables

  • Go-Live: TBD

    • Testing to be completed

    • Charlie is afraid of timing to have it update so his service doesn’t get stuck

    • currently loading sandbox with real data to test with; will determine go-live date after

    • NetSuite datamodel is

• Weekly data upload: vistar, campsite

• Service Desk Items that are not as high priority as CRM to NetSuite, may be pushed to next week

• Working on loading data from CRM to Sandbox, turning out to be a greater effort than initially expected

Julia

• Boostr

  • Contract signed with Pablo to do API for first 60% of the project;

  • Remaining 40% to be signed once requirements are better documented

  • API In Progress with Pablo

• Looking for month-to-month revenue on PC (for Dynamic Rate Card phase 1)

JIRA:

Break/Fix: requests come in through Service Desk
Day-to-day: Operational Maintenance
Projects: Business Management Systems [Harris Hwang]; Revenue [Alice Gogh]; Product [Alice Gogh]

Frank

WFH halfday monday

• AWS: took 15 minutes to do what would take a week of tickets/backandforth in Rackspace

  • built in DR / backups, managed, automatic upgrades

  • SQL 2017, Win 2019 (< $200 for both vs $800 for backups alone at rackspace)

  • SQL Express instance

  • Vision is to start migrating everything to AWS

• Talend

  • ETL (extract transfer load)

  • to replace jitterbit

  • free for a certain number of developers

  • code is in bitbucket

• Corevalue’s two major projects with Frank will be done in AWS:

  • API integration

  • Geckoboard

Karen

• Mapping NetSuite Fields for API

  • Rubicon, then Vistar, then HiveStack

• Amazon Web Services (AWS) instance for API Integration Project & staging db

  • setting up AWS shedules for cost savings

  • Index tuning, check db’s

Out Tues-Thurs for AWS architecture training in Boston!

Andrea

• FiveTran - kicked out of netsuite…

  • passwords updated! we good

• Skype Business Meetings - Wally to approve

• AvidExchange looking to get Admin Credentials

  • NetSuite partner to generate cheques

  • ACH (automated clearing house?)

• Helped abe out with Lookre saved search fields (locating fields to make available in Looker)

• Holding off on Telecom projects because of server names

• 2 factor authentication; sent Julia a drafted proposal, April 8th cutoff

• Helpdesk tickets

Wally

At Rackspace Tues / Wed

OOO next week: Working from home early next week, then going to LA office for Win 10 upgrades