2019-09-23 Meeting notes

Karen

• CRM to NetSuite

  • Stored proc review, including notes regarding what can be taken off line / deleted.

• Creating action plan to move AWS objects from the AWS root account to an organizational unit.

• Cloud Migration Project (Building Server Service)

  • RFQ sent out to 4 companies (Corevalue, EagleDream, Edison Interactive, Andy Gaskell (Independent Contractor from CTO Teammate))

    • Timeline:

      • RFP Responses due to Captivate: 9/25/19

      • RFP Presentations to Captivate: week of 9/30

      • Captivate selects partner: week of 10/7

      • Project kickoff: week of 10/14

      • Project completion: 3/31/19

        • EagleDream not able to meet deadline for RFP response

• Hivestack - new field for PMP traffic partner

  • Loaded to NetSuite? / Frank is waiting for a response from pablo

• Jenkins Server - patched, documented

Abe

• Looker issue with configuring models need to submit a ticket on our + Corevalue’s behalf

• Continued migration of code to Lookerdev → Lookerstaging

• Continued development of metrics with Will and Matt

  • Refine / finalize: Reale Estate revenue reporting

  • Develop / requirements analysis: operations

    • Project metrics (almost done?) = job

    • Backlog

  • requirement elicitation: Customer Success - multipurpose initiative quota

  • churn? I have an old WIP

• Tested Jenkins Patching - scary at first, but passed after instance restarted

Roshan

• Jenkins Server is Patched Successfully, confirmed with Abe.
  and Also Documented the process.

• Reviewing IT Sandbox.

• Resizing CIDR Block from /16 to /24

Stacey

• WFH Tomorrow (Tuesday)

• CRM to NetSuite:

  • Cases in Producton

  • Meeting with Finance and RES today to discuss their needs

  • Continue with reviewing Errors from Loading into Production

  • Format data forms

  • DU Cab field

• Vistar/Campsite Weekly Report

  • documented! - local for now

  • can it be automated: no not yet, had the discussion with vistar, they don’t have an api and they will not make one.

    • Stacey wants to put it in Looker once she has some time freed up so she can push the data to snowflake weekly and hav ethe report be ready

• Orphan IDs Report in Looker

• Any other Ops projects that come up

Tom

• Working with Karen on reviewing stored procedures

• SVP Opportunities Roll Up with Impressions (Kate R)

• Completed Server Name requests report by Matt S

• Screen Center report (Ad End Date has to be added in, currently Null) (Kate M)

  • currently have a problem with the data:
    changed the system so that when they add new screencenter data they will have an end date from when the ad is supposed to end. previously there was no end date so there are a lot of nulls. it messes up the query.
    

• Lat Long Report Needs columns added (Damien)

Andrea

• Final review of active users in SB1; schedule refresh; Data API to do testing

  • SB1 - refresh of production; data only (minor changes) = Dev Account

  • SB2 - CRM Migration (only project outstanding)

• BSD Tickets - found the “Related Knowledge Base Articles”

  • Didn't find a suitable article? Search knowledge base or create an article link

• Approved CV project to proceed with NV/NVC/Site improvements

  • Phase 2; part 1

  • Core Value BA

  • Working on high level Phase 2 overview (originated on BMS board)

• NetSuite Licenses - Process/ownership

• Tipalti - Validation Errors - Caused by:

  • Captivate Market = Class

  • Cost Center = Department

  • Site = Site (building address)

• PO Workflow - Post Deployment changes/updates/end user feedback