Meeting Title: US x BF | Standup Date: 2025-07-16 Meeting participants: Amber Lin, Demilade Agboola, Caio Velasco


WEBVTT

1 00:00:23.330 00:00:24.710 Amber Lin: Oh!

2 00:00:29.620 00:00:30.580 Demilade Agboola: How are you?

3 00:00:32.905 00:00:34.050 Amber Lin: Cp.

4 00:00:40.390 00:00:42.049 Demilade Agboola: At 7, 30 for you, right.

5 00:00:43.172 00:00:49.999 Amber Lin: Yes, and I left my sweet bed 1 min ago.

6 00:00:50.190 00:00:50.890 Amber Lin: So

7 00:00:55.240 00:01:05.550 Amber Lin: okay, no, I don’t know where Kyle is. I know he had a working session early.

8 00:01:10.120 00:01:11.459 Amber Lin: All right.

9 00:01:14.660 00:01:16.030 Amber Lin: Hi Kyle.

10 00:01:18.980 00:01:20.050 Caio Velasco: Hello! Hello!

11 00:01:21.650 00:01:23.509 Caio Velasco: I was happily trying to work with

12 00:01:24.510 00:01:27.450 Caio Velasco: some tables here that they forgot. Sorry.

13 00:01:28.763 00:01:29.970 Amber Lin: No worries.

14 00:01:30.420 00:01:35.249 Amber Lin: Okay, can we update the tickets?

15 00:01:42.725 00:01:49.869 Amber Lin: Okay, so are these, have you reviewed these? Can we close them.

16 00:01:52.150 00:01:58.470 Demilade Agboola: Yes, the Pr. Has been approved. I don’t think Emily has merged it so that will be the delay in that.

17 00:01:58.970 00:02:09.320 Amber Lin: Hmm, okay, so is it in? Is it in internal review, in client review, or still in Pr.

18 00:02:10.020 00:02:11.339 Demilade Agboola: Are still in Pr.

19 00:02:11.570 00:02:12.380 Amber Lin: Okay.

20 00:02:16.478 00:02:20.470 Amber Lin: any of these that needs to be updated.

21 00:02:24.138 00:02:30.700 Demilade Agboola: So the look of your math should be in progress. I know we did

22 00:02:30.950 00:02:39.360 Demilade Agboola: so like we did do a built for that yesterday. For validation with Felipe.

23 00:02:39.868 00:02:49.829 Demilade Agboola: but, like the numbers are still changing. I just had a session with, and I like he would like us to modify some of the numbers

24 00:02:50.594 00:02:58.030 Demilade Agboola: and actually, it’s just queuing some things. And we realized that, for instance, the fact that, like

25 00:02:58.410 00:03:06.229 Demilade Agboola: someone else, ordered a different item. That was not a floral item counts as a like. It counts as

26 00:03:06.910 00:03:12.790 Demilade Agboola: orders that were not budgeted for against the inventory, even though they were not floral items that were used to replace it.

27 00:03:13.510 00:03:18.590 Demilade Agboola: So we just need to handle that. So, for instance, if someone had to buy a rose and then got another rose

28 00:03:19.438 00:03:34.559 Demilade Agboola: but this time, instead of getting the rose alone, they got the rose with something else, like maybe, like tea or chocolate. The chocolates will make it count against which which should obviously not factor in into those kind of counts.

29 00:03:35.072 00:03:40.369 Demilade Agboola: So just being able to tweak. Those is like that’s kind of where we are at in terms of that. Yeah.

30 00:03:40.370 00:03:50.229 Amber Lin: Okay, yesterday I took. I know you guys had a meeting Monday and Tuesday. Did you just have a meeting today as well?

31 00:03:51.480 00:03:52.160 Amber Lin: Hopefully.

32 00:03:52.160 00:03:54.114 Demilade Agboola: Yes, I had a meeting with.

33 00:03:54.440 00:04:00.439 Amber Lin: Oh, okay, I try to create tickets from that.

34 00:04:02.930 00:04:06.120 Amber Lin: Is, are these valid tickets.

35 00:04:08.564 00:04:14.070 Demilade Agboola: Largely. I I have moved one from backlog to done. I’m kind of going through them.

36 00:04:16.279 00:04:19.089 Amber Lin: I mean, we can look at them today in grooming.

37 00:04:20.370 00:04:30.050 Demilade Agboola: Yeah, I’ll I’ll I don’t think I’ll fully be in grooming like I like hop in for like the 1st 15 min, so I don’t know if I’ll fully be in there.

38 00:04:31.880 00:04:39.410 Amber Lin: Oh, okay, I don’t know if we can do grooming if you guys are not here.

39 00:04:42.680 00:04:43.840 Demilade Agboola: Let’s see.

40 00:04:43.840 00:04:46.010 Amber Lin: Yeah, move. It to a different date.

41 00:04:47.130 00:04:48.280 Demilade Agboola: Okay, that works too.

42 00:04:48.820 00:04:49.700 Amber Lin: Hmm.

43 00:04:49.880 00:04:50.890 Demilade Agboola: That works.

44 00:04:52.245 00:04:54.510 Amber Lin: When does that?

45 00:04:55.160 00:04:57.140 Amber Lin: When would that be?

46 00:04:59.450 00:05:04.020 Demilade Agboola: Tomorrow works like, Oh, man.

47 00:05:05.280 00:05:13.689 Demilade Agboola: I know Kyle doesn’t work like he works EU hours, although said later today, much later works for me as well. But yeah, tomorrow works. Mine is fine.

48 00:05:15.010 00:05:16.020 Amber Lin: Okay.

49 00:05:17.549 00:05:18.459 Amber Lin: Hmm.

50 00:05:19.850 00:05:21.050 Demilade Agboola: Well.

51 00:05:21.480 00:05:23.340 Amber Lin: Tomorrow.

52 00:05:26.200 00:05:29.920 Amber Lin: After the meeting with Zack.

53 00:05:34.890 00:05:36.279 Demilade Agboola: That’s not exciting.

54 00:05:37.070 00:05:41.280 Amber Lin: I know Kyle might be out. It might be a little late.

55 00:05:41.850 00:05:42.780 Amber Lin: Yeah, tomorrow.

56 00:05:42.780 00:05:45.759 Caio Velasco: Room at this time I already had a lot of things.

57 00:05:47.670 00:05:51.870 Caio Velasco: but I mean, how how practically do you need me in the grooming.

58 00:05:53.360 00:06:08.855 Amber Lin: Well, it’s it’s nice that we can all be there and then understand what’s going on. I do want to groom in. Well, the new stuff for inventory.

59 00:06:09.530 00:06:20.050 Amber Lin: and then, like there’s some for revenue that we can groom, and then there’s still stuff left over for

60 00:06:20.613 00:06:24.750 Amber Lin: red shift and looker that we should also look through.

61 00:06:26.330 00:06:33.737 Caio Velasco: Yeah. Well, I I’d be happy to join, if well, if I can, given the time, time, zone, and everything. But honestly

62 00:06:34.820 00:06:44.799 Caio Velasco: grooming, revenue, or anything else theoretically would happen if, on my side, if I had knowledge on what to do. But since it’s more like learning

63 00:06:45.020 00:06:47.450 Caio Velasco: on the fly or along the didn’t you?

64 00:06:47.450 00:06:52.200 Caio Velasco: For me? I don’t. I cannot really add like so far. For example, Hi!

65 00:06:52.200 00:06:52.650 Amber Lin: Okay.

66 00:06:52.650 00:06:56.409 Caio Velasco: I understand now, more or less like the audit tickets. But in the beginning

67 00:06:56.620 00:07:00.879 Caio Velasco: I didn’t. So sometimes I wonder, like, yeah, if I’m not needed. It’s okay.

68 00:07:01.592 00:07:05.379 Caio Velasco: Because I don’t have much to add, to be honest and to to those things.

69 00:07:06.062 00:07:08.790 Amber Lin: Okay, I think

70 00:07:09.220 00:07:21.511 Amber Lin: we probably would put off grooming revenue then and then we can i can work with them a lot of group to groom inventory, and then for

71 00:07:22.620 00:07:26.440 Amber Lin: we can look at the redshift and looker one that’s remaining.

72 00:07:27.380 00:07:27.970 Caio Velasco: Cool.

73 00:07:28.370 00:07:37.368 Amber Lin: Okay. I think that those I would probably need your help. Cause there’s no point in me grooming them, because I really don’t know what’s going on.

74 00:07:38.225 00:07:50.319 Amber Lin: I guess today we can make a we can do a short one, maybe like 30 min. We’ll look at looker and stuff, and tomorrow. I guess the melody we can look at inventory together.

75 00:07:51.870 00:07:53.370 Demilade Agboola: Okay, that sounds good.

76 00:07:53.370 00:07:53.789 Amber Lin: Okay.

77 00:07:55.799 00:08:02.630 Amber Lin: do we manage to get a review from Felipe, or we do. We already know generally what he says.

78 00:08:03.700 00:08:07.400 Demilade Agboola: Oh, no, actually, yes, that’s it. On my note. I’ll send him a message now.

79 00:08:08.910 00:08:16.290 Amber Lin: Awesome snapshots to analyze non-optimal order. Allocation!

80 00:08:16.660 00:08:20.500 Amber Lin: Is that something? Still, something we want to do? This sprint.

81 00:08:22.061 00:08:27.410 Demilade Agboola: Yes, but it’s lower priority. To be honest, it’s like literally low priority.

82 00:08:28.240 00:08:29.205 Demilade Agboola: So

83 00:08:31.080 00:08:35.479 Demilade Agboola: yeah, I’m not. I’m not too. I mean, I can still do it. It’s literally crazy snapshots, but.

84 00:08:35.750 00:08:36.330 Amber Lin: Hmm.

85 00:08:36.580 00:08:38.049 Demilade Agboola: Literally. Yeah, that’s fine.

86 00:08:38.059 00:08:49.869 Amber Lin: Yeah, I yeah. I was wondering because I that’s why I wanted to look at Felipe’s tickets, cause if there’s something more important there, I will swap that out. So that’s the reason I wanted to look at inventory.

87 00:08:53.219 00:09:04.329 Amber Lin: yeah. Well, honestly, today we’ll try and use 15 min. Put Felipe’s tickets in order, and then use the other 15 min. Look at look at Redshift, and tomorrow we can do the rest.

88 00:09:04.609 00:09:06.799 Amber Lin: What about revenue.

89 00:09:08.568 00:09:22.439 Caio Velasco: So I don’t have like a any update for for it. To be honest, I talked to Emily today, so she clarified a few things of at the end of the day we she was just guiding me through. How? What is like a

90 00:09:22.600 00:09:33.702 Caio Velasco: the flow of an order? For example, I didn’t even know that at the end of the day the everything that comes from Oms. This is also a bit for them. It’s actually just

91 00:09:34.340 00:09:41.880 Caio Velasco: an enhancement of what is happening in shopify. So shopify is the source for everything, and then dash

92 00:09:42.798 00:09:49.259 Caio Velasco: kind of ad delivery information. So I wish I had known this since since the 1st time.

93 00:09:49.510 00:09:51.279 Caio Velasco: because this is like super core

94 00:09:51.925 00:10:00.939 Caio Velasco: and and then because of those things, I started to wonder like if we are building fact orders or anything down the line?

95 00:10:01.436 00:10:18.560 Caio Velasco: Why can’t we only just connect straight to shopify native tables? And or if we connect to dash, if we can, if we if we do that, is it possible to get just what was changes or well, I had some ideas like I was also gonna

96 00:10:18.740 00:10:22.090 Caio Velasco: talk to them later about it. But I didn’t message him yet.

97 00:10:22.679 00:10:29.870 Caio Velasco: But yeah, I had some new ideas. So I improved in those things, but given everything that she told me.

98 00:10:30.360 00:10:35.290 Caio Velasco: yeah, I will have to sit with them another for a few minutes, maybe today or tomorrow.

99 00:10:35.942 00:10:44.039 Caio Velasco: To understand like a a deliverable. Because I yeah, discovery was good. But now I think I need more clear ideas of deliverables.

100 00:10:44.410 00:10:51.960 Amber Lin: Okay, that’s that’s great. I mean, that’s all I wanted to for the stand up. Do you guys want to use this room to talk about it?

101 00:10:52.690 00:10:55.349 Caio Velasco: Oh, yeah, we can, if they can. Yeah.

102 00:10:55.920 00:10:57.740 Amber Lin: We have 18 min left.

103 00:10:58.710 00:10:59.480 Caio Velasco: Perfect.

104 00:11:04.073 00:11:09.409 Demilade Agboola: Sure I have to hop soon, though, but sure.

105 00:11:09.410 00:11:16.990 Amber Lin: Yeah. Our Eden meeting is in like 17 min from now. So I I think we would have some time.

106 00:11:17.930 00:11:30.010 Caio Velasco: Or even amber. If you want do you want to go over the lucre or redshift things like for grooming? Because I’m not sure, like we just, we’re just continuing the finishing, the

107 00:11:30.370 00:11:34.369 Caio Velasco: the how to say the deprecation right? I don’t know what else is.

108 00:11:34.370 00:11:44.260 Amber Lin: So there’s still some found like stuff they wanna do say, adding freshness checks like

109 00:11:44.770 00:11:58.940 Amber Lin: adding sort or disk keys to large tables, making a dev prod schema separation like we’ll we’ll look at it today in grooming. We probably still have, like some time there. I want you guys can talk about

110 00:12:00.180 00:12:02.050 Amber Lin: the revenue stuff.

111 00:12:02.260 00:12:03.110 Amber Lin: Yeah.

112 00:12:04.140 00:12:07.067 Caio Velasco: Okay, okay. So

113 00:12:08.430 00:12:13.790 Caio Velasco: so basically, going back to what we discussed, I think yesterday or 2 days ago.

114 00:12:17.700 00:12:32.830 Caio Velasco: so I think, well, I I was doing that discovery that I showed you with some important tables. So you know, building stage orders, building stage of orders, also taking a look in in line items like staging line items, tables.

115 00:12:34.410 00:12:41.279 Caio Velasco: and everything comes from from oms and everything, and all Oms stuff is being ingested by evil.

116 00:12:41.390 00:12:43.000 Caio Velasco: and, as I understood

117 00:12:43.726 00:12:54.939 Caio Velasco: the or the flow of an order is basically, something is purchased in orders placed in shopify. So the all the information is there. However, they don’t have the

118 00:12:54.960 00:13:19.900 Caio Velasco: fulfillment, information and delivery information. So that’s why they pull, push this into dash and dash at those things, and also apparently also changes things. So updates, or maybe deletes because of something like a redelivery or whatever is happening. So everything it’s affecting the order at the end of the day that was back in shopify. So I understand why it would be.

119 00:13:20.200 00:13:29.869 Caio Velasco: We have kind of 2 sources, let’s say one. So one sources orders in shopify with some information, and then the other one was whatever was added, or change it

120 00:13:29.980 00:13:32.310 Caio Velasco: in in dash.

121 00:13:33.410 00:13:41.849 Caio Velasco: Given that those things seems to be the source like 2 big sources. Can’t we just build the fact orders on top of those? And

122 00:13:41.980 00:13:44.940 Caio Velasco: I mean, just look for whatever we need

123 00:13:45.080 00:13:48.619 Caio Velasco: in the whole complexity of their models.

124 00:13:48.970 00:13:54.086 Caio Velasco: So then I would stop doing the all the discovery that I’m doing

125 00:13:54.630 00:14:07.020 Caio Velasco: which is kind of endless, although I learn a lot and folks a bit more in like building effect, or the table that would be bringing an order, and everything that happens into that order

126 00:14:07.130 00:14:11.469 Caio Velasco: in terms of shopify and dash? Does that make any sense.

127 00:14:13.520 00:14:20.369 Demilade Agboola: Yeah, it does. And that’s part of what I was saying. We should do from the very beginning, in the sense that, like, we’re building the product orders. Yes.

128 00:14:20.480 00:14:30.179 Demilade Agboola: but we need to also understand what’s going on in, how things happen like, how are they calculating order, totals and refunds and discounts. And how do they like

129 00:14:30.540 00:14:36.090 Demilade Agboola: handle old system versus a new system? And how do we then ensure that what we build

130 00:14:36.560 00:14:39.110 Demilade Agboola: accommodate all the different logics that exist.

131 00:14:39.450 00:14:42.409 Demilade Agboola: They’ll alternate the year like we will

132 00:14:42.620 00:14:45.019 Demilade Agboola: just simplify all they are doing.

133 00:14:45.500 00:14:49.989 Demilade Agboola: but we will do it in a way that is cleaner and more efficient than what they currently have.

134 00:14:52.170 00:14:54.729 Caio Velasco: Okay, okay, perfect. And when I was

135 00:14:54.860 00:14:56.980 Caio Velasco: sorry, where were you talking to?

136 00:14:57.670 00:14:58.340 Demilade Agboola: Oh no!

137 00:14:59.229 00:15:23.680 Caio Velasco: Okay, and when I was talking about this with Emily, she also mentioned I I can re-watch the video, but I don’t remember, she also mentioned some things about like, yeah, a migration or changing dash to shopify transactions, or whatever whatever whatever any of those changes will that affect what I’m doing, because if what I’m doing at the end of the day is gonna change, then there’s no point.

138 00:15:26.730 00:15:38.940 Demilade Agboola: I don’t think there’s any future migration. I think any migration she was referring to. I might be wrong, but I think any migration she was referring to was the past migration. So on the 11th of November last or 6th of November last year.

139 00:15:39.200 00:15:48.279 Demilade Agboola: they made a migration and things before that migration. At least you have some things right now which is kind of why I shared the whole thing about trying to understand what’s going on.

140 00:15:49.270 00:15:58.809 Caio Velasco: Okay, okay, okay, so from this out auditing tickets that I have.

141 00:15:59.140 00:16:09.329 Caio Velasco: can I say that if I have some knowledge about each of those parts. For example, yeah, I kind of know which table discounts are coming from, and more or less what they do

142 00:16:09.480 00:16:16.080 Caio Velasco: same for loyalty points same for whatever transactions is that sufficient to close out the ticket.

143 00:16:18.359 00:16:44.750 Demilade Agboola: Yes, but also not just like understanding where it’s coming from, understanding what’s going on. Understanding like what the like, I said, the free migration, logic, understanding how different things interact with each other, understanding why, there’s a certain logic for certain things that’s like what the audit is about, so that you can like understand what happens from in just John all the way. So when history dashboard, and how it’s calculated in that form, so that once you have an understanding of the different things. And

144 00:16:44.990 00:16:47.849 Demilade Agboola: oh, this is before migration. Who’s after migration

145 00:16:47.950 00:16:57.100 Demilade Agboola: when it’s subscription. But it’s a successful script. Subscription discounts come differently. Things like that. Once you understand the logic, the business logic, then the audit is done.

146 00:16:58.410 00:17:05.790 Caio Velasco: Okay, okay? And amber, she’s yeah. Still there. When is the when

147 00:17:06.020 00:17:09.908 Caio Velasco: cycle sprints? Because I’m always confused about the time?

148 00:17:10.599 00:17:19.089 Caio Velasco: what is the idea for the audit? Is it to end next Monday, or is it? Just give me an an overview, please, if you can.

149 00:17:19.663 00:17:29.009 Amber Lin: I I know we. When we planned this sprint we said we wanted to finish the audit by end of this sprint, so that would be next Monday.

150 00:17:29.660 00:17:34.280 Caio Velasco: Next month. Okay, okay, so cool. So I’ll try my best to

151 00:17:34.540 00:17:39.589 Caio Velasco: go over all those models. That was that I was showing to them in our call.

152 00:17:40.195 00:17:44.819 Caio Velasco: That gives me an understanding of it, at least a 1st layer.

153 00:17:45.040 00:17:49.440 Caio Velasco: Then, as I see, the next step are is the modeling step.

154 00:17:49.680 00:17:51.260 Caio Velasco: And then.

155 00:17:52.310 00:17:59.600 Caio Velasco: maybe, while we could at some point also work in in grooming or or anything like that, it’s maybe

156 00:18:00.600 00:18:05.609 Caio Velasco: at least with them, a lot that has more experience than me. Like, help me view.

157 00:18:05.810 00:18:17.099 Caio Velasco: define like deliverables for the modern impact, then think, but probably think will start to make more sense in terms of okay, we are building effect orders. And here we want information from

158 00:18:17.420 00:18:25.040 Caio Velasco: price quantity whatever, like a subscription or something like. But layer layer by layer. Right? Like, let’s say

159 00:18:25.240 00:18:33.579 Caio Velasco: we would define that like I would take 2, 3 days, or 3 sport story points for each. I think this would be something that I would be more comfortable with

160 00:18:34.140 00:18:39.039 Caio Velasco: other than just, you know, going on so much on, on.

161 00:18:39.290 00:18:45.940 Caio Velasco: on their own redshift and everything, and didn’t even know about everything I’m just for shopify. Those things should be cleared in the 1st place.

162 00:18:46.130 00:18:50.090 Caio Velasco: So yeah, so this is just me trying to be a bit more direct.

163 00:18:50.200 00:18:51.200 Caio Velasco: And

164 00:18:51.450 00:19:02.310 Caio Velasco: and for for the modeling part, maybe we can think of like small milestones or deliverables that would guide me, because it’s also difficult for me to

165 00:19:02.620 00:19:03.569 Caio Velasco: try to

166 00:19:04.020 00:19:11.020 Caio Velasco: even define my own work because I’m not a senior, or even a tech lead, or anything like that, or I haven’t gone through this process before.

167 00:19:11.724 00:19:17.570 Caio Velasco: So yeah. But but I mean we are making progress, and I am happy with what I’m learning.

168 00:19:17.680 00:19:21.379 Caio Velasco: But for, let’s say, after Monday. That would be important.

169 00:19:22.550 00:19:29.239 Amber Lin: Hmm, okay, sounds good. I know that a lot of had to hop. I think that’s a

170 00:19:29.350 00:19:34.969 Amber Lin: did you get what you need for for deliverables? Or do you need another time from him?

171 00:19:35.750 00:20:01.730 Caio Velasco: So I think, for I understand what he said. I think it’s just basically continue the work that I’ve been doing, that I showed him about like I have to go model by model and and be with the next one that consumes the previous one to understand like, okay, discounts come from here whatever whatever. This takes time, because I am the day oriented, and and I cannot go to the next step is the 1st step. It’s it’s wrong. It makes no sense for me.

172 00:20:02.172 00:20:08.419 Caio Velasco: So it takes time. But at the end my experience says that I can deliver something that works at least

173 00:20:09.272 00:20:20.240 Caio Velasco: takes time. So yeah, maybe from, as you said, for Monday seems to be okay for me, at least for this 1st layer of auditioning. I won’t have, like a deliverable other than just my, all, my.

174 00:20:20.360 00:20:22.862 Amber Lin: The queries that I built to do this work.

175 00:20:24.170 00:20:28.599 Caio Velasco: I hope that’s not a problem, because I don’t see any other deliverable concretely.

176 00:20:28.600 00:20:56.649 Amber Lin: Yeah, I like, I I didn’t really know what was the best result to give from an audit. I wanted them audit to help with that. But I mean, if that’s if we still are not very sure on what deliverables will help build the next phase. We can say, ask a wish, or ask Utam if he are, wants to review the the plan, because

177 00:20:56.660 00:21:16.679 Amber Lin: we can include that in the technical delivery document of saying like, oh, this is what we thought would be the deliverables. And then during tomorrow’s session, they’ll be like actually, you might also want this, and you may not need that, so maybe we can add it to the document, and tomorrow we’ll be able to get some comments and get some clarity.

178 00:21:17.480 00:21:22.970 Caio Velasco: Okay, cool. Now, that sounds good to be. And today about the grooming session, is this still gonna happen.

179 00:21:23.780 00:21:44.420 Amber Lin: Yeah, it’s it’s difficult. I can’t join like I we knew on the last moment. So probably it will just go for like 15 min sorry 15 to 30 min, like when he’s there. We’ll do the inventory, and then we can do a bit of the

180 00:21:44.730 00:21:56.479 Amber Lin: redshift and looker stuff mostly just want to show you what we have there. And you guys can tell me, hey, should we still do that? Do we? Do we want that at all. Mostly just for that.

181 00:21:57.620 00:22:02.979 Caio Velasco: Okay, okay, cool. So I can be there for this 31st minutes. No problem.

182 00:22:02.980 00:22:04.849 Amber Lin: Okay. Sounds good.

183 00:22:04.850 00:22:06.480 Caio Velasco: Cool, cool, perfect. Thank you.

184 00:22:06.690 00:22:08.090 Amber Lin: Alright. Thank you.

185 00:22:08.580 00:22:09.280 Caio Velasco: Bye-bye.