Meeting Title: US x BF | Grooming Date: 2025-06-18 Meeting participants: Uttam Kumaran, Emily Giant, Amber Lin, Demilade Agboola


WEBVTT

1 00:00:22.480 00:00:23.800 Emily Giant: How’s it going.

2 00:00:23.800 00:00:25.630 Uttam Kumaran: Hey? Good! How are you?

3 00:00:26.240 00:00:28.779 Emily Giant: Good. I’m tired, but good.

4 00:00:28.780 00:00:30.309 Uttam Kumaran: Okay. Good. Good.

5 00:00:32.009 00:00:33.479 Emily Giant: Yeah, we had like.

6 00:00:34.719 00:00:41.089 Emily Giant: I don’t know. Everything broke this week. As it does, you know, when I’m trying to do other things but

7 00:00:41.289 00:00:45.159 Emily Giant: demo lot, it was super helpful. And I think we’re almost there.

8 00:00:45.739 00:00:48.829 Emily Giant: So yeah, getting there.

9 00:00:57.600 00:00:58.910 Amber Lin: Hello!

10 00:00:59.440 00:01:00.590 Emily Giant: Hello! Again.

11 00:01:00.720 00:01:02.699 Amber Lin: Hello! Again. Nice to see you.

12 00:01:03.500 00:01:06.895 Emily Giant: Sorry. Goodness! Good to see you too.

13 00:01:09.250 00:01:11.019 Amber Lin: Are you on out on the porch.

14 00:01:11.310 00:01:12.060 Emily Giant: Yeah.

15 00:01:12.060 00:01:13.660 Amber Lin: Oh! Lovely!

16 00:01:13.660 00:01:18.030 Emily Giant: Oh, it’s nice! It was thunderstorming during our last, and now it’s that like.

17 00:01:18.030 00:01:18.420 Amber Lin: No.

18 00:01:18.420 00:01:19.770 Emily Giant: Storm.

19 00:01:19.850 00:01:20.930 Emily Giant: Wow!

20 00:01:20.930 00:01:24.307 Emily Giant: 90% humidity yet. But like getting there.

21 00:01:24.980 00:01:31.420 Emily Giant: Yeah, our neighbors, I think they got chickens, because I’m hearing some pretty interesting chat.

22 00:01:33.490 00:01:37.240 Amber Lin: I don’t know. Maybe they wanna make some chicken sounds. You never know who is.

23 00:01:37.842 00:01:42.125 Emily Giant: That would be best case. Scenario.

24 00:01:45.007 00:01:58.912 Amber Lin: So before the screaming session, me and Dumlotte met to tentatively assign all the assignees, and also the due dates and estimates to all of this. So in this meeting, mostly just want to confirm

25 00:01:59.830 00:02:12.979 Amber Lin: If there’s any objections to the say, the estimates or the assignments, and then we can adjust, based on everybody’s feedback. I think Kyle is feeling a little bit under the weather today.

26 00:02:13.510 00:02:20.180 Amber Lin: so when I get a chance with him, I’ll go check with if he’s okay with his tickets. But

27 00:02:20.830 00:02:29.159 Amber Lin: overall I’m looking at here, and so we have a few

28 00:02:29.620 00:02:37.849 Amber Lin: ad hoc tickets. That’s mostly Emily is going to be you. So we have the revenue reporting and the flow chart.

29 00:02:38.750 00:02:44.380 Amber Lin: And then we have inventory which demolan is gonna do most most of the modeling.

30 00:02:45.020 00:02:46.230 Amber Lin: And then

31 00:02:46.731 00:02:53.380 Amber Lin: we have this adding, we just talked about this earlier of adding it to the mart models.

32 00:02:53.710 00:02:54.310 Emily Giant: Hmm.

33 00:02:54.580 00:03:05.179 Amber Lin: And then for revenue, all of these needs a bit more to be more broken down because it’s so dependent on

34 00:03:05.580 00:03:14.769 Amber Lin: this one. So demo out in this cycle will investigate more and then map out the rebuild plan which will help us

35 00:03:14.930 00:03:21.160 Amber Lin: flesh out these ticket more. But these are the sub areas of the revenue rebuilds

36 00:03:21.640 00:03:27.779 Amber Lin: that we know of, and we distributed them between demalade and Kyle.

37 00:03:27.940 00:03:40.822 Amber Lin: So next cycle Kyle won’t be really doing much of inventory refractors, but he will be able to catch up to speed on the revenue side. And

38 00:03:41.920 00:03:48.860 Amber Lin: yeah. So him and Damalade will split the effort on the revenue side, and then there’s finishing up

39 00:03:49.060 00:03:53.940 Amber Lin: a few a few tickets in looker and redshift.

40 00:03:54.390 00:04:11.569 Amber Lin: So that’s the plan for next cycle in total, we have 44 points. I estimate there’s still gonna be, say, at least 5 points coming in. Probably mostly on you, Emily, more, maybe more on the ad hoc stuff that come up

41 00:04:11.740 00:04:13.730 Amber Lin: probably will have

42 00:04:14.390 00:04:24.919 Amber Lin: like a point or 2 rolling over from the previous cycle. So I think we’re gonna end up around 50, and I looked at the distribution here, I think this is

43 00:04:25.030 00:04:29.920 Amber Lin: this is, this is pretty good. Ideally, I would like them a lot to have like

44 00:04:30.680 00:04:45.320 Amber Lin: a few less points just because ad hoc tasks usually lands on him. But I think for Kyle, having 4 14 points is good because he has to ramp up to all of the modeling work on the revenue side.

45 00:04:45.730 00:04:48.230 Amber Lin: opening the grounds for any questions.

46 00:04:54.919 00:04:59.459 Uttam Kumaran: Yeah, I guess my only question was, gonna be about like, is there any expected Rollover from the sprint.

47 00:05:00.110 00:05:04.309 Amber Lin: Yes, I expect this sprint.

48 00:05:04.430 00:05:12.599 Amber Lin: Then, while I said, these are all on track, so that should be good. I would say the only one that will roll over is probably

49 00:05:13.170 00:05:15.759 Amber Lin: maybe, for Kyle’s tasks.

50 00:05:15.980 00:05:17.010 Amber Lin: So

51 00:05:18.020 00:05:37.150 Amber Lin: the cost estimate, which is a very small task, maybe flagging these ones by accuracy which is dependent on rating them. And Colin Emily has been working really hard on that. So, but don’t think that will be on track to finish, because Thursday is a holiday, so it

52 00:05:37.780 00:05:42.689 Amber Lin: probably will be in progress, but not completely done.

53 00:05:43.260 00:05:48.279 Amber Lin: But here we have a where is it?

54 00:05:48.750 00:05:52.380 Amber Lin: Have a similar ticket. I think

55 00:05:52.520 00:05:55.500 Amber Lin: I talk with them a lot, and we can’t really

56 00:05:56.020 00:06:02.569 Amber Lin: do any rebuilds yet we can only flag them to be rebuilt. So actually, this is quite similar

57 00:06:04.284 00:06:06.460 Amber Lin: to this ticket.

58 00:06:06.930 00:06:09.590 Amber Lin: So I think that’s where it’s gonna be rolled over.

59 00:06:13.110 00:06:13.700 Uttam Kumaran: Okay.

60 00:06:13.700 00:06:14.330 Amber Lin: Yeah.

61 00:06:15.230 00:06:24.830 Uttam Kumaran: Okay, cool. Yeah, I think, I’m looking forward to like what Kyle is gonna do for some of these core models. And then I think the only thing, Emily, to flag is

62 00:06:25.353 00:06:50.470 Uttam Kumaran: I’m gonna probably I’m gonna try to present like a stopgap solution for 2 things for one sort of the polytomic like Cron problem, and then we’re we’re working on implementing like a new data observability tool. For, like several of our clients. It just basically helps us catch

63 00:06:50.957 00:07:10.592 Uttam Kumaran: some really critical anomalies, and changes to like core marts, models, for example, like we make a Pr and like the rows triple or like a sum goes negative or a value is completely null. So we’re I’m gonna have a demo to kind of show you and the team.

64 00:07:11.998 00:07:27.020 Uttam Kumaran: by the end of this cycle. And then I think, I just want to kind of share with you. I think my recommendation is most likely to be just to turn it on, for, like the one or 2 tables that are super crucial, so that we can set alerts. There. But that’s probably

65 00:07:27.420 00:07:29.520 Uttam Kumaran: the only 2 things on my end.

66 00:07:31.210 00:07:41.100 Uttam Kumaran: And then my, I guess my last question is, gonna be about actually like executing the the deprecations.

67 00:07:43.330 00:07:44.679 Uttam Kumaran: If that’s in.

68 00:07:45.090 00:07:50.460 Uttam Kumaran: Yeah, basically, I think I think we have this one. And I don’t know if we have other deprecations that

69 00:07:51.030 00:07:54.459 Uttam Kumaran: we can also start to just like, continue to execute after the audit.

70 00:08:02.140 00:08:03.789 Emily Giant: Is that a question for me.

71 00:08:04.040 00:08:13.870 Uttam Kumaran: Yes, I guess, or for everybody here. I guess this question is like we’ve done. We’ve done some of the audits, I guess. What is the plan to actually now turn some of that off, or or start to delete some of those.

72 00:08:14.040 00:08:19.400 Amber Lin: I see. I believe we’ve already turned off some of the unused dashboards.

73 00:08:20.403 00:08:26.970 Amber Lin: Just checking, checking here for looker.

74 00:08:28.810 00:08:33.985 Amber Lin: I think we’re we’ve already turned off some of the unused looker dashboards and notified the stakeholders.

75 00:08:34.559 00:08:39.970 Amber Lin: We now need to turn off the red strip tables that’s not used by

76 00:08:40.850 00:08:54.710 Amber Lin: Dvt, and we already turn off the completely unused ones. So this is, we’re on track to do a further step of those ones who’s not supported. We’re not supporting any models. You’re gonna turn that off

77 00:08:54.830 00:08:56.116 Amber Lin: and then

78 00:08:56.760 00:09:00.090 Uttam Kumaran: So for the for the deprecate, unused looker. Dashboards.

79 00:09:00.460 00:09:05.099 Uttam Kumaran: Like, did we actually do like? Are those deleted? Yet, Emily, or like, Okay.

80 00:09:05.100 00:09:08.200 Emily Giant: The audit is done. That was my.

81 00:09:08.200 00:09:08.540 Amber Lin: Brisket.

82 00:09:08.670 00:09:16.920 Emily Giant: The deprecation step. So this one, like, what is the acceptance criteria? On this? I may have prematurely marked it as done

83 00:09:17.509 00:09:23.349 Emily Giant: final dashboards. Okay. So we still need to do the final dashboards. No, that’s done.

84 00:09:23.600 00:09:26.849 Uttam Kumaran: Well, it looks like this is sort of the deprecation plan.

85 00:09:26.850 00:09:27.810 Emily Giant: Yeah, and this.

86 00:09:27.810 00:09:29.710 Uttam Kumaran: We need a step to actually then

87 00:09:29.830 00:09:35.430 Uttam Kumaran: do the turning off. So maybe let’s just rename this to like deprecation plan

88 00:09:36.655 00:09:43.539 Uttam Kumaran: like, I don’t want to use the word deprecate, because that implies that it’s that happened. That’s an action. So this is just the plan.

89 00:09:43.660 00:09:51.740 Uttam Kumaran: Yeah. And then we need one to actually go execute the deprecation. This one I really wanted. I want to do with like a couple of us

90 00:09:52.320 00:09:57.780 Uttam Kumaran: on a call. So we can really double check. And because, Emily, if, if like, we make a mistake, it’s

91 00:09:58.170 00:10:00.280 Uttam Kumaran: you’re gonna get paying. So I just wanna really like.

92 00:10:00.280 00:10:00.740 Amber Lin: She knew.

93 00:10:00.740 00:10:02.260 Uttam Kumaran: Saying how to best do this.

94 00:10:02.480 00:10:09.690 Amber Lin: Would you want to do this in a meeting with the stakeholders? We have a meeting with them next Thursday, on the 26.th

95 00:10:10.560 00:10:17.499 Uttam Kumaran: I mean, we could just at least we could take a part of that meeting to just present our list of the things we’re gonna fill, and and then

96 00:10:17.840 00:10:20.500 Uttam Kumaran: then they can help play defensive stuff.

97 00:10:20.500 00:10:21.030 Amber Lin: Hmm.

98 00:10:21.900 00:10:22.240 Uttam Kumaran: Yeah.

99 00:10:22.240 00:10:31.410 Amber Lin: Yeah. So we have. On the 26.th Next week we have a meeting with all the stakeholders. Some of them are out of office.

100 00:10:31.830 00:10:32.460 Amber Lin: but.

101 00:10:32.460 00:10:33.010 Uttam Kumaran: Okay.

102 00:10:33.590 00:10:35.569 Amber Lin: We have Jesse.

103 00:10:35.990 00:10:37.859 Amber Lin: Okay, Felipe.

104 00:10:38.120 00:10:39.900 Uttam Kumaran: Okay, so we’ll that seems good.

105 00:10:39.900 00:10:46.660 Amber Lin: That meeting. Let me make a ticket for the next cycle. We’ll say we’re gonna do that in the.

106 00:10:46.660 00:10:53.879 Uttam Kumaran: Yeah, this would be a huge win, because that that basically puts us at like one month like in this. So the 1st 2 cycles. We

107 00:10:54.290 00:11:00.089 Uttam Kumaran: we took care of almost all of the inject, the like lagging ingestion sources.

108 00:11:00.190 00:11:06.010 Uttam Kumaran: all of the sort of unused looker. And then the last piece is like clearing out. Dbt.

109 00:11:06.200 00:11:12.219 Uttam Kumaran: so like, that’s that was our 1st big sort of milestone. Try to get to. So it’d be great to hit that.

110 00:11:12.900 00:11:19.010 Amber Lin: Right. So I’m gonna say, I’m gonna assign it to

111 00:11:19.230 00:11:24.679 Amber Lin: Emily. I’m gonna say, due date 28.

112 00:11:25.730 00:11:26.500 Amber Lin: Oh.

113 00:11:30.010 00:11:32.860 Amber Lin: okay, great.

114 00:11:32.970 00:11:36.710 Amber Lin: So we’ll do that say it’s

115 00:11:40.040 00:11:48.750 Amber Lin: once great, and for the ingestion tables I just want to confirm, we’ve actually turned them off right.

116 00:11:50.163 00:11:58.329 Demilade Agboola: Yes, I will confirm. I believe he has said he hadn’t were the ones that were still like.

117 00:11:58.790 00:12:00.440 Demilade Agboola: There were question marks about.

118 00:12:03.640 00:12:15.390 Amber Lin: Guess we can say finalize for bread shift like finalized vacation for redshift.

119 00:12:15.720 00:12:21.039 Uttam Kumaran: And amber. Can you maybe schedule a meeting with me and Kyle or like.

120 00:12:21.830 00:12:22.340 Amber Lin: Or.

121 00:12:22.340 00:12:29.500 Uttam Kumaran: Or we could just talk about the redshift. Dbt deprecation. I think he’s made enough progress. I just want to review everything.

122 00:12:29.500 00:12:30.100 Amber Lin: Hmm.

123 00:12:30.320 00:12:33.209 Uttam Kumaran: And I think I can unblock him. He had a couple of questions today.

124 00:12:36.024 00:12:38.640 Amber Lin: okay, let me see.

125 00:12:42.040 00:12:47.969 Amber Lin: he’s a little bit under the weather. Today, I don’t know, if you can meet today. But we can see for this week.

126 00:12:48.510 00:12:52.809 Amber Lin: You can ask them about Friday or next week, but I just want to review.

127 00:12:53.730 00:12:56.110 Uttam Kumaran: Everything. He’s made a lot of progress.

128 00:12:56.348 00:12:58.490 Amber Lin: Well, you have a 1 on one with him.

129 00:13:01.080 00:13:03.080 Uttam Kumaran: That’s unrelated to this project, though.

130 00:13:04.230 00:13:07.809 Amber Lin: Okay. I don’t know if he can make it, because he has this working session.

131 00:13:07.810 00:13:10.710 Uttam Kumaran: We could coordinate this later. We don’t have to do okay, install.

132 00:13:10.980 00:13:11.670 Amber Lin: Okay.

133 00:13:11.900 00:13:13.759 Amber Lin: I’m I’m gonna put a hold.

134 00:13:15.960 00:13:16.510 Uttam Kumaran: Okay.

135 00:13:17.370 00:13:19.950 Amber Lin: Urban sense review.

136 00:13:28.160 00:13:32.559 Amber Lin: Okay, just a hold. You guys can figure that out.

137 00:13:35.250 00:13:35.950 Amber Lin: Yeah.

138 00:13:37.000 00:13:42.840 Amber Lin: So let’s let’s think about what we have. I guess by the end of this cycle

139 00:13:43.550 00:13:45.480 Amber Lin: we’ll be able to.

140 00:13:45.890 00:13:57.359 Amber Lin: If these are. These are on track, we’ll be pretty much done with all the inventory refractors. Except for we’re gonna where is it?

141 00:13:57.660 00:14:13.600 Amber Lin: We’re gonna just add, like a few small adjustments and actually put it into the to replace the current models. So this cycle will be main all the main rebuilds, and then next cycle we’ll just clean it up for the last few things.

142 00:14:14.290 00:14:21.029 Amber Lin: I’m not sure what that what that one was, and then for revenue.

143 00:14:21.470 00:14:29.429 Amber Lin: we’re gonna this is mainly for auditing and knowing what’s going on, knowing what the requirements from the different stakeholders is.

144 00:14:29.730 00:14:42.270 Amber Lin: and then next site, like the the cycle after the next one will start to really go into the rebuilds and that will take that will take some time, but hopefully, next cycle, we’re gonna finish up

145 00:14:42.530 00:14:52.369 Amber Lin: the main deprecations in looker and red ship, which will be, which will be very big, and then we’ll just do these ad hoc tasks as it goes.

146 00:14:54.260 00:14:58.880 Amber Lin: Okay, any other comments?

147 00:15:00.179 00:15:05.719 Amber Lin: I think this should be. It should be a good allocation, because they’re looking at

148 00:15:05.850 00:15:12.440 Amber Lin: this cycle demalade had around 24 points Kyle had around 20,

149 00:15:12.580 00:15:20.950 Amber Lin: and that was after we got additional tasks that came in. And also, I think this cycle was a little bit crammed.

150 00:15:21.280 00:15:26.750 Amber Lin: So I think that new point allocations should be better here.

151 00:15:30.560 00:15:35.499 Amber Lin: Okay, anything else, that’s all. From my side.

152 00:15:37.070 00:15:38.090 Emily Giant: I don’t think so.

153 00:15:38.090 00:15:45.630 Amber Lin: Okay, I’ll need to talk to Kyle about what he thinks about his tickets. But we can also talk about it. During Kickoff.

154 00:15:45.890 00:15:57.089 Uttam Kumaran: Yeah, I guess my, I was gonna ask Emily, I haven’t chatted with Zack or Alex like, is it? That should we just continue to send updates like I wanted to maybe get them an update of like, how the next

155 00:15:57.290 00:16:07.570 Uttam Kumaran: sprints looking and what we’re hoping to finish up this sprint like, should we? Should I send an email, or should we just continue just to talk in slack or like? Should I try to call them.

156 00:16:08.697 00:16:10.739 Emily Giant: That’s on vacation. So you’re not gonna reach him.

157 00:16:10.740 00:16:12.050 Uttam Kumaran: Oh, okay. Okay. I didn’t know.

158 00:16:12.050 00:16:15.009 Emily Giant: I would send an email.

159 00:16:15.210 00:16:16.720 Amber Lin: Okay. Cool.

160 00:16:16.970 00:16:20.770 Uttam Kumaran: Okay, so amber. Maybe we can just send us. I know you. I think you might have sent one

161 00:16:20.880 00:16:27.770 Uttam Kumaran: last week, or you’re planning one. Well, let’s just send an email saying what we’re planning for next sprint points and stuff like that objective.

162 00:16:27.770 00:16:28.230 Amber Lin: Okay. Yeah.

163 00:16:28.445 00:16:32.319 Uttam Kumaran: Just so they’re like, cause I know we’re all talking in slack, and it can get lost. So.

164 00:16:32.320 00:16:37.479 Amber Lin: Yeah, totally. I’ll do that. I’m just gonna make one for myself.

165 00:16:45.170 00:16:52.849 Amber Lin: Do you want to book a meeting with Alex and Zack weekly or bi-weekly.

166 00:16:54.293 00:17:00.520 Uttam Kumaran: I mean I I’m hoping that they come to this and like the retro. So I don’t think we need another one.

167 00:17:02.630 00:17:07.030 Uttam Kumaran: Like I would. Just I think I’m gonna try. Do you know, when Zack’s back, Emily.

168 00:17:07.240 00:17:08.359 Emily Giant: I think. Monday.

169 00:17:08.670 00:17:11.810 Uttam Kumaran: Okay. So then I think I’ll try to get a hold of him.

170 00:17:11.940 00:17:13.250 Uttam Kumaran: Okay, next week.

171 00:17:13.500 00:17:17.579 Amber Lin: And we’ll ask if he can join Tuesday’s kickoff.

172 00:17:17.589 00:17:28.919 Uttam Kumaran: Yeah, if we can catch them, catch them a kickoffs and retro and grooming, or at least one of them. Then that’s fine, and then I’ll I usually will find a way to catch up with everyone once a month, so.

173 00:17:28.920 00:17:37.470 Amber Lin: Okay, that’s good. And I think now that our rooming kickoff sessions are shorter, it will be easier for them to join as well.

174 00:17:38.450 00:17:39.490 Emily Giant: Yeah. Totally.

175 00:17:39.490 00:17:40.830 Amber Lin: Yeah, okay.

176 00:17:42.680 00:17:43.440 Emily Giant: All right.

177 00:17:43.690 00:17:44.200 Amber Lin: Okay.

178 00:17:44.200 00:17:44.770 Uttam Kumaran: Okay.

179 00:17:45.550 00:17:46.350 Amber Lin: Alrighty!

180 00:17:46.610 00:17:47.290 Amber Lin: Alright! Thank you.

181 00:17:47.910 00:17:49.130 Demilade Agboola: Everyone, bye.

182 00:17:49.130 00:17:49.650 Uttam Kumaran: Bye.

183 00:17:49.650 00:17:50.810 Amber Lin: Bye.