Meeting Title: US x BF | Standup Date: 2025-07-29 Meeting participants: Caio Velasco, Emily Giant, Amber Lin
WEBVTT
1 00:02:56.250 ⇒ 00:02:57.450 Amber Lin: Hello!
2 00:02:58.200 ⇒ 00:02:58.850 Caio Velasco: Hello!
3 00:02:59.390 ⇒ 00:03:02.130 Amber Lin: My Internet was not very good.
4 00:03:03.150 ⇒ 00:03:03.640 Caio Velasco: No worries.
5 00:03:05.970 ⇒ 00:03:10.019 Amber Lin: Oh, Emily is rare to your hair. Down.
6 00:03:10.860 ⇒ 00:03:12.466 Emily Giant: Yes, I
7 00:03:13.380 ⇒ 00:03:21.929 Emily Giant: It’s a wild day mostly to remind me that I need to go to a stylist and have them fix it. I look like I was incarcerated and.
8 00:03:21.930 ⇒ 00:03:22.410 Amber Lin: That.
9 00:03:22.410 ⇒ 00:03:25.969 Emily Giant: Able to get my hair done for months, because it’s like.
10 00:03:26.236 ⇒ 00:03:26.610 Amber Lin: It’s like
11 00:03:30.980 ⇒ 00:03:32.787 Amber Lin: it looks pretty cool.
12 00:03:33.240 ⇒ 00:03:42.590 Emily Giant: Thanks. Thanks. I don’t know if my life, because it looks decidedly not cool in person. It looks.
13 00:03:51.180 ⇒ 00:03:55.886 Amber Lin: And let’s see.
14 00:04:01.470 ⇒ 00:04:02.240 Amber Lin: hmm!
15 00:04:03.020 ⇒ 00:04:04.199 Amber Lin: It’s not loading.
16 00:04:20.930 ⇒ 00:04:22.140 Amber Lin: This one.
17 00:04:22.580 ⇒ 00:04:23.930 Amber Lin: Oh.
18 00:04:31.470 ⇒ 00:04:38.366 Amber Lin: which one would this! What what project would this fall under? I saw that there was a new
19 00:04:39.200 ⇒ 00:04:40.210 Amber Lin: I could.
20 00:04:41.690 ⇒ 00:04:51.750 Emily Giant: I threw that in there because I wasn’t sure if it was marketing or revenue. But I think actually, after yesterday it’s gonna be revenue, and it doesn’t necessarily need to be me.
21 00:04:52.460 ⇒ 00:05:01.630 Emily Giant: It is definitely like a request for specific buckets, for discounts promos, etc.
22 00:05:04.090 ⇒ 00:05:05.610 Amber Lin: I see?
23 00:05:10.970 ⇒ 00:05:12.360 Amber Lin: Alright.
24 00:06:03.170 ⇒ 00:06:04.020 Amber Lin: Okay.
25 00:06:04.720 ⇒ 00:06:08.239 Amber Lin: Think all of it should be in the current cycle.
26 00:06:09.183 ⇒ 00:06:10.810 Amber Lin: Let’s see.
27 00:06:11.590 ⇒ 00:06:13.570 Amber Lin: Month revenue
28 00:06:17.170 ⇒ 00:06:18.750 Amber Lin: blanket.
29 00:06:27.110 ⇒ 00:06:28.240 Amber Lin: Okay?
30 00:06:30.370 ⇒ 00:06:34.449 Amber Lin: Is this something we should do in this cycle.
31 00:06:38.391 ⇒ 00:06:41.339 Amber Lin: The categorization that we just looked at.
32 00:06:44.500 ⇒ 00:07:11.720 Emily Giant: So in the ticket there should be a link. I don’t know if it was included, because that’s my automated thing that pulls it over when I click the button. Yes, it is okay. So the promo code categories. It looks like they’re already listed. So it will be like once, promos and discounts. Once those models are updated, then this is like another logic layer to put on top of it. So I don’t think it needs to be done. This cycle.
33 00:07:13.551 ⇒ 00:07:20.379 Amber Lin: You’re closer to that work. But I think we’ll have to do more foundational stuff. This cycle
34 00:07:22.320 ⇒ 00:07:25.320 Amber Lin: I see. Okay, so I’ll move it to.
35 00:07:25.610 ⇒ 00:07:27.569 Amber Lin: I’ll move it to the next one.
36 00:07:40.200 ⇒ 00:07:41.050 Amber Lin: Okay.
37 00:07:54.610 ⇒ 00:07:55.800 Amber Lin: Alright.
38 00:07:58.010 ⇒ 00:08:01.109 Amber Lin: What about? Oh, this is for inventory.
39 00:08:04.680 ⇒ 00:08:07.399 Amber Lin: What’s the status on these tickets?
40 00:08:10.180 ⇒ 00:08:15.350 Emily Giant: Okay? So the add on committed and committed inventory, and the
41 00:08:17.910 ⇒ 00:08:18.570 Amber Lin: Hmm.
42 00:08:18.980 ⇒ 00:08:22.579 Emily Giant: Create. So that one, us 2, 1, 9.
43 00:08:23.450 ⇒ 00:08:27.990 Emily Giant: And where’s the one about forced upgrades?
44 00:08:28.740 ⇒ 00:08:37.359 Emily Giant: So Alex and I are pairing today? He has released the new field for forced upgrades, which was the blocker on
45 00:08:37.510 ⇒ 00:08:39.966 Emily Giant: completing that piece. So
46 00:08:40.710 ⇒ 00:08:54.830 Emily Giant: I I need to tag. I need to tag Alex in the ticket because he’s gonna update it here, but that is now unblocked which will unblock the other 2. So those should be like back on track to be finished, probably by end of day tomorrow.
47 00:08:55.532 ⇒ 00:09:02.580 Emily Giant: And then fix historical inventory adjustments. That one is like 70% done.
48 00:09:03.320 ⇒ 00:09:04.950 Emily Giant: The staging models equipment.
49 00:09:04.950 ⇒ 00:09:08.560 Amber Lin: Call this one? Or has this not been reviewed yet.
50 00:09:09.250 ⇒ 00:09:12.920 Emily Giant: The in add, uncommitted and committed fields.
51 00:09:13.200 ⇒ 00:09:13.830 Amber Lin: Hmm.
52 00:09:14.976 ⇒ 00:09:23.453 Emily Giant: I think I will confirm. Today I feel like that’s done. I’ve just hidden it in Looker.
53 00:09:24.920 ⇒ 00:09:29.480 Emily Giant: so it just needs to be validated with like Felipe, and then but that one.
54 00:09:29.480 ⇒ 00:09:29.800 Amber Lin: Okay.
55 00:09:29.800 ⇒ 00:09:33.830 Emily Giant: In review, not in progress.
56 00:09:37.680 ⇒ 00:09:38.840 Amber Lin: Alright.
57 00:09:42.160 ⇒ 00:09:47.760 Amber Lin: So 2 locations has been here, and the
58 00:09:51.780 ⇒ 00:09:54.600 Amber Lin: so this, we said, was unblogged.
59 00:09:55.890 ⇒ 00:10:03.110 Emily Giant: That one will be fixed with the hopefully, with the release of the inventory model misalignment. I
60 00:10:05.150 ⇒ 00:10:08.350 Emily Giant: it shouldn’t be. It should be 2 separate tickets. But
61 00:10:09.020 ⇒ 00:10:12.640 Emily Giant: It’s not blocked. No, it’s just.
62 00:10:13.750 ⇒ 00:10:19.619 Emily Giant: That the product tables were not working because of how
63 00:10:20.550 ⇒ 00:10:38.570 Emily Giant: product joins were working in component data which, if you traced it back, it was because of the legacy models and old logic. So it all became like very snowballed so it should technically be fixed with us. Dash 2, 4, 4,
64 00:10:39.560 ⇒ 00:10:46.500 Emily Giant: because that should fix the misalignment between parent and peace products.
65 00:10:46.780 ⇒ 00:10:49.000 Emily Giant: which was what was causing this.
66 00:10:52.520 ⇒ 00:10:53.480 Amber Lin: Okay.
67 00:11:03.780 ⇒ 00:11:06.660 Amber Lin: hi on that.
68 00:11:07.102 ⇒ 00:11:08.430 Amber Lin: What is the.
69 00:11:08.795 ⇒ 00:11:11.980 Emily Giant: Is that end of week, I hope? When is the due date.
70 00:11:15.438 ⇒ 00:11:20.110 Amber Lin: August. So next month, and this.
71 00:11:20.800 ⇒ 00:11:22.029 Emily Giant: That one’s fine.
72 00:11:22.460 ⇒ 00:11:22.990 Amber Lin: Okay.
73 00:11:30.290 ⇒ 00:11:31.600 Amber Lin: we need to.
74 00:11:31.600 ⇒ 00:11:38.950 Emily Giant: The Associated Oil should be in stakeholder review or in yeah, stakeholder review.
75 00:11:46.360 ⇒ 00:11:47.570 Amber Lin: Okay. Great.
76 00:11:53.220 ⇒ 00:11:58.840 Amber Lin: Hi Kyle. Yesterday we had requests.
77 00:12:01.090 ⇒ 00:12:12.480 Caio Velasco: Yeah, I talked to him like not long ago, 2 min ago. And he gave me like a 1st overview of the document. And what we have to do for each part.
78 00:12:12.660 ⇒ 00:12:16.159 Caio Velasco: He still has to go through some things and get back to me.
79 00:12:16.970 ⇒ 00:12:19.129 Caio Velasco: But I have some ideas for it, and
80 00:12:19.340 ⇒ 00:12:26.561 Caio Velasco: this will take, he told me, like 2 days to start, because he has to get back to me with some things.
81 00:12:27.200 ⇒ 00:12:31.069 Caio Velasco: and I don’t know. Maybe the expectation for this is
82 00:12:31.190 ⇒ 00:12:43.369 Caio Velasco: somehow next week to have like a 1st version for all the points like Number 4. There’s also a bit of 5, I think part of 6 part of 7
83 00:12:43.949 ⇒ 00:13:02.479 Caio Velasco: and those can be turned into tickets as well. So I think I expect to start tomorrow because I was working on the cost estimate, although you told me to just spend an hour, I had to do some digging and also, since many of the ingestion pipelines we turned off
84 00:13:04.180 ⇒ 00:13:08.610 Caio Velasco: but since we turned off them like a few months ago, I don’t have access to
85 00:13:09.172 ⇒ 00:13:17.939 Caio Velasco: how many rows were being jested, so I had to go into redshift and do a lot of queries for all the tables associated with those pipelines which are schemas.
86 00:13:18.608 ⇒ 00:13:28.410 Caio Velasco: Then it took me a bit a bit longer, but I have a an idea, and I have a tab, a new tab on the on the spreadsheet, so I’ll I’ll update the tickets
87 00:13:28.750 ⇒ 00:13:29.889 Caio Velasco: as soon as I can.
88 00:13:30.350 ⇒ 00:13:31.640 Amber Lin: Okay, awesome.
89 00:13:32.703 ⇒ 00:13:40.580 Amber Lin: When you do cost estimates. Did you include also the engineering time? Like a rough estimate.
90 00:13:43.220 ⇒ 00:13:48.470 Caio Velasco: An estimate of engineering time. But how is that related?
91 00:13:51.180 ⇒ 00:13:52.620 Amber Lin: Because this is a customer.
92 00:13:53.080 ⇒ 00:13:58.080 Caio Velasco: Is the cost estimate for open stems, or for, or is it a savings estimate.
93 00:14:00.832 ⇒ 00:14:06.049 Amber Lin: I think in general, just how it benefits us.
94 00:14:08.270 ⇒ 00:14:12.812 Caio Velasco: Okay, okay, I can. I can. I can check if it if it can fit both. Yeah.
95 00:14:14.980 ⇒ 00:14:37.960 Amber Lin: Yeah, I think it. I think an easier way if you want to. I don’t think we need a very precise estimate. If you want to put the table that you created, which is very detailed. If you put that maybe into chat gpt, and then say, we turned off this many redshift tables out of this many things, and then maybe estimate the engineering time saved like I think that would that would do.
96 00:14:38.899 ⇒ 00:14:42.090 Caio Velasco: So this is, it’s good that you mentioned this, because
97 00:14:42.240 ⇒ 00:14:52.160 Caio Velasco: this is 2 separate things like ingestion pipe pipelines that were separate, that were turned off on Eve when speech is different from.
98 00:14:52.540 ⇒ 00:14:58.560 Caio Velasco: The deprecation of work we did in redshift with all those 2,000, let’s say tables.
99 00:14:59.444 ⇒ 00:15:04.680 Caio Velasco: Those are 2 separate things. Is it for both, or for just the former.
100 00:15:06.244 ⇒ 00:15:11.540 Amber Lin: How long would it take you to do both? If it takes a long time? I can do it.
101 00:15:15.420 ⇒ 00:15:21.610 Caio Velasco: For the second one. Well, if I think here, I’ll have to probably understand how much storage
102 00:15:21.890 ⇒ 00:15:31.910 Caio Velasco: space that was taking before it was deleted, and how ratchet sees it, and what is their plan? I how they pay ratchet? I’ll have to do something
103 00:15:32.250 ⇒ 00:15:33.389 Caio Velasco: for that.
104 00:15:35.510 ⇒ 00:15:49.129 Amber Lin: Okay, I can do the I can do the engineering hours. And can you put what you found out for the ingestion tables here. I don’t think I was. I would be able to find that out.
105 00:15:49.680 ⇒ 00:15:50.810 Caio Velasco: Yeah, yeah.
106 00:15:50.810 ⇒ 00:15:52.359 Amber Lin: That information like.
107 00:15:53.940 ⇒ 00:15:54.380 Caio Velasco: 4, 4.
108 00:15:54.380 ⇒ 00:15:54.850 Amber Lin: Okay.
109 00:15:55.219 ⇒ 00:16:05.940 Caio Velasco: I can finish this part of the ingestion, and then I also can do the other part for the deprecation. Let’s say the tables and views. Deprecation in redshi.
110 00:16:07.005 ⇒ 00:16:17.680 Amber Lin: It’s okay. I can do the rest. If you, as long as you can give me the ingestion pipeline and point me to. I can go finish it off.
111 00:16:18.670 ⇒ 00:16:20.469 Amber Lin: I have some more time today.
112 00:16:21.230 ⇒ 00:16:24.749 Caio Velasco: Okay, so you mean what? Exactly.
113 00:16:25.270 ⇒ 00:16:27.200 Amber Lin: Whatever you found out.
114 00:16:28.180 ⇒ 00:16:28.999 Caio Velasco: Okay. Okay.
115 00:16:29.170 ⇒ 00:16:30.050 Amber Lin: Yeah, cool.
116 00:16:30.050 ⇒ 00:16:34.009 Amber Lin: Just update the ticket, and I’ll I can take over.
117 00:16:34.550 ⇒ 00:16:35.160 Caio Velasco: Okay.
118 00:16:37.000 ⇒ 00:16:47.160 Amber Lin: Yeah, sounds good cause I I think your knowledge is more important in making the diagram or making the revenue technical design document, because I cannot do that.
119 00:16:47.450 ⇒ 00:16:49.869 Amber Lin: so we’ll need your help here.
120 00:16:50.510 ⇒ 00:16:51.580 Caio Velasco: Okay. Cool.
121 00:16:53.110 ⇒ 00:16:54.010 Amber Lin: Yeah,
122 00:16:55.130 ⇒ 00:17:05.350 Amber Lin: can you look at these 2 tickets? Because I think we’re not doing modeling? Yet. So this document would be a bit more important.
123 00:17:05.619 ⇒ 00:17:14.960 Amber Lin: So which one wants a quick fake jam of how revenue models fit into into each other. And also the section 4,
124 00:17:16.500 ⇒ 00:17:21.140 Amber Lin: yeah, yeah, no, it’s on my radar oops.
125 00:17:22.030 ⇒ 00:17:33.632 Caio Velasco: No, it’s on my radar. I will. I’ll check it. I probably have to go through starting from the beginning of the document. I don’t know what comes first, st because I believe there’s a logic one after the other.
126 00:17:34.822 ⇒ 00:17:44.289 Caio Velasco: But I’ll see, because it’s as I mentioned. It’s not only those 2. There are 4 things, I think, like a number 6 and 7 as well, and then you have to see what is priority.
127 00:17:46.570 ⇒ 00:17:47.500 Amber Lin: Okay. Okay.
128 00:17:49.330 ⇒ 00:17:51.300 Caio Velasco: The main moments over there. Yeah.
129 00:17:53.530 ⇒ 00:17:59.007 Amber Lin: Okay. If you see it, feel free to create a ticket for yourself so we can track
130 00:17:59.470 ⇒ 00:18:13.824 Amber Lin: track your work. And we are. I do want to review the document with Zach or Alex sometime this week, Thursday or Friday, so ideally we can get this
131 00:18:15.180 ⇒ 00:18:17.540 Amber Lin: East on the end of Wednesday.
132 00:18:18.690 ⇒ 00:18:21.120 Amber Lin: because we already have these knowledge base.
133 00:18:25.030 ⇒ 00:18:27.670 Amber Lin: Is that a reasonable timeline for you.
134 00:18:28.802 ⇒ 00:18:34.319 Caio Velasco: If I have clear understanding of what is being asked. Yes.
135 00:18:34.790 ⇒ 00:18:45.290 Caio Velasco: because revenue model, how they flow to each other, the current ones. We are basically asking the lineage between beginning and end, which is a lot
136 00:18:45.994 ⇒ 00:18:48.720 Caio Velasco: because of the complexity of the
137 00:18:49.040 ⇒ 00:19:00.210 Caio Velasco: of the of all the models. So we have to be clearing what exactly needs to be there. Maybe that’s the most important ones like I had my spreadsheet, like the those stage models.
138 00:19:00.560 ⇒ 00:19:09.649 Caio Velasco: their sources, and then how they flow into, which is basically the spreadsheet can. If that’s what you mean by that, it can turn my spreadsheet into
139 00:19:09.760 ⇒ 00:19:12.470 Caio Velasco: a feed jam.
140 00:19:12.960 ⇒ 00:19:14.290 Caio Velasco: Obviously, diagno.
141 00:19:15.040 ⇒ 00:19:18.099 Caio Velasco: Does that make sense? Yeah, that’s could be like 2 h.
142 00:19:18.100 ⇒ 00:19:19.870 Amber Lin: That’s what we need.
143 00:19:20.380 ⇒ 00:19:22.159 Caio Velasco: Okay, okay, cool. That makes sense.
144 00:19:22.160 ⇒ 00:19:26.820 Amber Lin: Always clarify with Utah because he he like.
145 00:19:27.070 ⇒ 00:19:28.809 Amber Lin: It’s more than I do.
146 00:19:29.860 ⇒ 00:19:30.530 Caio Velasco: Okay.
147 00:19:31.580 ⇒ 00:19:32.160 Amber Lin: Yeah.
148 00:19:32.490 ⇒ 00:19:42.920 Amber Lin: yeah. And this is the 2, 4, 2 is just your audit. I I thought you put it in there. Maybe it wasn’t in the right section, so we don’t didn’t see it. I’m not sure.
149 00:19:44.760 ⇒ 00:19:45.350 Caio Velasco: And.
150 00:19:45.350 ⇒ 00:19:47.069 Amber Lin: You might have to check with him.
151 00:19:47.760 ⇒ 00:19:48.769 Caio Velasco: Okay. I’ll check.
152 00:19:48.770 ⇒ 00:19:50.620 Amber Lin: We’ll find out if there’s other.
153 00:19:51.070 ⇒ 00:19:58.780 Amber Lin: Okay. Sounds good, I’ll say from hmm.
154 00:20:05.270 ⇒ 00:20:07.879 Amber Lin: I think that’s mostly it.
155 00:20:08.440 ⇒ 00:20:24.309 Amber Lin: for for this few days it’s just mostly work on the teeth related to this document, so I don’t. I think we’ll be able to. We should be able to complete this since there’s not nothing, nothing else.
156 00:20:24.540 ⇒ 00:20:25.660 Amber Lin: Philly.
157 00:20:26.000 ⇒ 00:20:28.210 Amber Lin: Okay.
158 00:20:40.400 ⇒ 00:20:50.580 Amber Lin: okay, yeah. I checked the document. Those are only those are the only requests Witham has. So has for you specifically. So I think we’ll be fine.
159 00:20:51.050 ⇒ 00:20:53.200 Amber Lin: Gonna say, Wednesday.
160 00:20:53.440 ⇒ 00:20:55.650 Amber Lin: Alright, I think that’s everything.
161 00:20:56.710 ⇒ 00:20:57.400 Caio Velasco: All right.
162 00:20:59.360 ⇒ 00:20:59.980 Amber Lin: Yeah.
163 00:21:01.900 ⇒ 00:21:02.750 Emily Giant: See everyone.
164 00:21:02.750 ⇒ 00:21:03.699 Amber Lin: Thanks. Everyone.
165 00:21:04.800 ⇒ 00:21:05.400 Caio Velasco: Okay.
166 00:21:05.400 ⇒ 00:21:08.320 Amber Lin: Yeah, see? You bye.