Meeting Title: Data Service Standup Date: 2026-01-14 Meeting participants: Awaish Kumar, Ashwini Sharma, Mustafa Raja, Elizah Joy, Uttam Kumaran
WEBVTT
1 00:00:52.260 ⇒ 00:00:53.290 Ashwini Sharma: Hey, awake.
2 00:00:55.310 ⇒ 00:00:56.470 Awaish Kumar: Hello?
3 00:00:57.060 ⇒ 00:00:57.880 Ashwini Sharma: Hello.
4 00:01:01.550 ⇒ 00:01:03.070 Awaish Kumar: Hi, Mustavo.
5 00:01:03.360 ⇒ 00:01:04.280 Mustafa Raja: Hey, how are you?
6 00:01:08.020 ⇒ 00:01:10.189 Awaish Kumar: So, how’s the day going?
7 00:01:11.020 ⇒ 00:01:12.800 Mustafa Raja: Yeah, pretty good.
8 00:01:13.900 ⇒ 00:01:14.250 Awaish Kumar: Okay.
9 00:01:14.250 ⇒ 00:01:21.039 Mustafa Raja: I’ve started, starting my day a little earlier, around 3, Pakistan time.
10 00:01:21.690 ⇒ 00:01:23.830 Mustafa Raja: Yeah, so it’s a lot, a lot better now.
11 00:01:27.430 ⇒ 00:01:28.120 Awaish Kumar: Okay.
12 00:01:28.750 ⇒ 00:01:30.790 Awaish Kumar: So you work until, like…
13 00:01:31.640 ⇒ 00:01:35.420 Mustafa Raja: So, from 3… from 3 to 3.30.
14 00:01:38.820 ⇒ 00:01:41.640 Mustafa Raja: Yeah, and I take breaks in between.
15 00:01:42.850 ⇒ 00:01:43.560 Awaish Kumar: Okay.
16 00:01:44.020 ⇒ 00:01:50.470 Mustafa Raja: Yeah, it’s not like I work 12 hours. I’m up 12 hours, and I take breaks in between.
17 00:01:51.080 ⇒ 00:01:51.880 Awaish Kumar: Okay.
18 00:01:56.980 ⇒ 00:01:59.590 Awaish Kumar: Let’s see if Utob is joining.
19 00:02:06.360 ⇒ 00:02:13.099 Ashwini Sharma: So, are you, are you guys, stay up till 5, GMT, normally? Sorry, 5, EST?
20 00:02:14.800 ⇒ 00:02:21.190 Mustafa Raja: I believe I, I’m up till 4.30, Central Time.
21 00:02:21.490 ⇒ 00:02:23.720 Mustafa Raja: So, 4.30 Utam’s time.
22 00:02:24.360 ⇒ 00:02:31.219 Ashwini Sharma: Oh, okay, 4.30 Okam’s time is, almost… 650, I think? Esc?
23 00:02:31.220 ⇒ 00:02:34.460 Mustafa Raja: I don’t know that.
24 00:02:36.100 ⇒ 00:02:38.809 Ashwini Sharma: Utam is in, what, Texas, right?
25 00:02:38.810 ⇒ 00:02:40.860 Mustafa Raja: Utam is in Central Time.
26 00:02:41.990 ⇒ 00:02:43.500 Mustafa Raja: Yeah, indexes.
27 00:02:45.430 ⇒ 00:02:47.239 Ashwini Sharma: That’s half an hour.
28 00:02:47.680 ⇒ 00:02:50.250 Ashwini Sharma: Not half an hour, but it’s, 12.
29 00:02:52.260 ⇒ 00:02:54.859 Ashwini Sharma: 12 hours and 30 minutes ahead of us.
30 00:02:58.210 ⇒ 00:03:03.410 Ashwini Sharma: No, 11 hours behind us, not 11 hours. 11.30 behind us, yeah.
31 00:03:03.410 ⇒ 00:03:07.569 Mustafa Raja: Yeah. Yeah, 11.30 behind you, and 11 hours behind us.
32 00:03:07.660 ⇒ 00:03:08.969 Ashwini Sharma: Okay. In a leash.
33 00:03:14.690 ⇒ 00:03:15.320 Awaish Kumar: Okay.
34 00:03:19.070 ⇒ 00:03:20.720 Ashwini Sharma: So what do you do during the daytime?
35 00:03:22.930 ⇒ 00:03:23.570 Mustafa Raja: Me?
36 00:03:23.980 ⇒ 00:03:24.720 Ashwini Sharma: Sleep?
37 00:03:25.510 ⇒ 00:03:44.929 Mustafa Raja: Oh, so I actually… I wake up around 12, 12 my time, so I’ll be sleeping, from, like, 4, 4 a.m. to 12, you know? And then I wake up at 12, and then I start working at 3.
38 00:03:45.250 ⇒ 00:03:47.040 Ashwini Sharma: Oh, okay, cool.
39 00:03:47.040 ⇒ 00:03:47.430 Mustafa Raja: Yeah.
40 00:03:47.940 ⇒ 00:03:49.940 Mustafa Raja: How does your schedule look like?
41 00:03:50.130 ⇒ 00:03:57.600 Ashwini Sharma: Oh, mine is, I laugh at around 2 or 2.30 my time, maximum I go up till 3.
42 00:03:58.150 ⇒ 00:04:01.700 Ashwini Sharma: That’s, 430 EST,
43 00:04:02.150 ⇒ 00:04:09.969 Ashwini Sharma: And then I wake up at 7, if it is a good day, I get to wake up at 8, so… Oh, you wake up early.
44 00:04:10.690 ⇒ 00:04:14.449 Ashwini Sharma: Oh, yeah, yeah, I have kids, right? So, basically, they go to school and…
45 00:04:14.790 ⇒ 00:04:15.560 Mustafa Raja: Huh.
46 00:04:15.560 ⇒ 00:04:21.300 Ashwini Sharma: It’s always a… It’s always a waterfront in the morning to send them to school.
47 00:04:21.440 ⇒ 00:04:23.259 Mustafa Raja: Yeah, I can understand.
48 00:04:24.260 ⇒ 00:04:26.720 Mustafa Raja: We all were like that.
49 00:04:26.720 ⇒ 00:04:29.069 Awaish Kumar: Yeah.
50 00:04:29.070 ⇒ 00:04:30.279 Ashwini Sharma: Let’s start here.
51 00:04:30.280 ⇒ 00:04:35.080 Awaish Kumar: Let’s get back to the work, yeah.
52 00:04:35.800 ⇒ 00:04:39.649 Awaish Kumar: Let me open my linear.
53 00:04:40.460 ⇒ 00:04:43.869 Awaish Kumar: So, yeah, if we can start with default.
54 00:04:44.000 ⇒ 00:04:53.829 Awaish Kumar: For default, We discussed, as of, yesterday, we discussed to deliver the architecture diagram and the,
55 00:04:54.010 ⇒ 00:04:56.950 Awaish Kumar: Salesforce Data Founding and the ETL plan.
56 00:04:58.810 ⇒ 00:04:59.780 Mustafa Raja: Also, the game chart.
57 00:04:59.780 ⇒ 00:05:02.150 Awaish Kumar: Kind of, it was… yeah, but it was kind of…
58 00:05:02.360 ⇒ 00:05:05.700 Awaish Kumar: We wanted to do some of it by the end of last week.
59 00:05:06.200 ⇒ 00:05:12.670 Awaish Kumar: like, for example, ETL plant. So, it is taking a bit longer than I think,
60 00:05:12.670 ⇒ 00:05:26.029 Mustafa Raja: No, no, I think the ETL plan, is, what’s it called? Is planned for this week, right? So, Demilhade has, with…
61 00:05:27.620 ⇒ 00:05:30.410 Awaish Kumar: 3 weeks, and I think, yeah, if I remember.
62 00:05:30.410 ⇒ 00:05:33.410 Mustafa Raja: This… this was… I believe… sorry?
63 00:05:34.560 ⇒ 00:05:41.420 Awaish Kumar: Yeah, if I remember correctly, we just discussed that last week, but it’s in this week, so I’m just,
64 00:05:41.790 ⇒ 00:05:45.819 Awaish Kumar: Saying that, maybe, like, we can just close this out by the end of this week.
65 00:05:46.580 ⇒ 00:06:08.890 Mustafa Raja: Yeah, we are planning to close this by end of this week. The reason it’s taken this long is, we, Demilade was still figuring out all of the data sources that we would need, to sort of fulfill all of the stakeholders’ needs. And, we have met, sort of all of the stakeholders.
66 00:06:08.890 ⇒ 00:06:20.720 Mustafa Raja: Now, and, we sort of have a definitive, table for all of the, sources that we need, right? So, yeah, so,
67 00:06:20.750 ⇒ 00:06:29.039 Mustafa Raja: I believe we will be sending out a document, that Demilade is preparing, for their legal team.
68 00:06:29.180 ⇒ 00:06:33.890 Mustafa Raja: Yeah, that’s pretty much it for the ETL plan.
69 00:06:34.000 ⇒ 00:06:35.130 Awaish Kumar: Basically, what…
70 00:06:35.230 ⇒ 00:06:46.079 Awaish Kumar: what I want to, like, kind of as an EP, like, what I want to hear more is, like, are we on track, or if something is getting delayed, like, let’s, like, surface that
71 00:06:46.220 ⇒ 00:06:53.910 Awaish Kumar: to the… And also, if it… if everything is going well, then yeah, we can just give the update.
72 00:06:53.910 ⇒ 00:06:59.950 Mustafa Raja: Yeah, I believe, yeah, I believe this, this for now is, all on schedule.
73 00:06:59.950 ⇒ 00:07:10.700 Awaish Kumar: Okay. Yeah. Okay. So, by the end of this week, we are planning an ETL plan, and then the, like, Gantt chart, and the data architecture diagram, as the main deliverables.
74 00:07:11.180 ⇒ 00:07:11.820 Mustafa Raja: Yeah.
75 00:07:12.620 ⇒ 00:07:24.750 Awaish Kumar: Okay, good. And then, like, yeah, as Demi’s out today, so you might have to do some CSO work, I think, maybe sending updates in the client channel, or whatever he was doing.
76 00:07:25.110 ⇒ 00:07:38.029 Awaish Kumar: And I also see a meeting between Damilardi and Lauren, and, like, it’s just between them two, so I’m not sure if you want to join that, or if you want to, like.
77 00:07:38.030 ⇒ 00:07:46.789 Mustafa Raja: Like, till the… Yeah. So… Yeah, so regarding that, Demilade has asked me to, take that over.
78 00:07:47.230 ⇒ 00:07:47.880 Awaish Kumar: Okay.
79 00:07:48.420 ⇒ 00:07:53.299 Mustafa Raja: So, I will be taking, I will be,
80 00:07:53.480 ⇒ 00:07:56.230 Mustafa Raja: Joining that meeting and leading that meeting now.
81 00:07:56.330 ⇒ 00:07:57.680 Awaish Kumar: Okay.
82 00:07:58.040 ⇒ 00:08:07.650 Mustafa Raja: Yeah, this is the main goal for that meeting, is just to understand if she’s a technical stakeholder, or a business stakeholder, and her needs from us.
83 00:08:07.870 ⇒ 00:08:08.550 Awaish Kumar: Okay.
84 00:08:09.780 ⇒ 00:08:19.449 Awaish Kumar: Okay, and yeah, then there are some, there’s a comment from Dami on Slack, maybe if you, if you can ticket those out, if there is anything,
85 00:08:19.740 ⇒ 00:08:20.980 Awaish Kumar: Which is not here.
86 00:08:22.310 ⇒ 00:08:23.740 Mustafa Raja: Sorry, sorry, could you say that again?
87 00:08:25.010 ⇒ 00:08:29.670 Awaish Kumar: There’s a message in Slack channel from Demi, like, from yesterday, I think.
88 00:08:30.460 ⇒ 00:08:32.869 Mustafa Raja: In the, in the external one.
89 00:08:34.539 ⇒ 00:08:35.289 Awaish Kumar: Continue.
90 00:08:35.599 ⇒ 00:08:37.309 Awaish Kumar: It’s internal.
91 00:08:37.309 ⇒ 00:08:38.619 Mustafa Raja: Oh, okay, okay, yeah.
92 00:08:38.619 ⇒ 00:08:41.779 Awaish Kumar: Yeah, I think, I think that’s, that’s well taken care of.
93 00:08:46.820 ⇒ 00:08:47.470 Awaish Kumar: Okay.
94 00:08:47.870 ⇒ 00:08:56.210 Awaish Kumar: So… Yeah, so, like, so what is the ATL plan creation?
95 00:08:56.390 ⇒ 00:08:58.810 Awaish Kumar: I’m not sure if there’s anything else.
96 00:08:59.430 ⇒ 00:09:00.280 Awaish Kumar: Okay.
97 00:09:00.480 ⇒ 00:09:01.909 Awaish Kumar: Then we are good here.
98 00:09:02.270 ⇒ 00:09:06.940 Awaish Kumar: Then for APC, we didn’t get the service accounts yet, right?
99 00:09:07.560 ⇒ 00:09:12.329 Mustafa Raja: Oh, no, we did get that. so yesterday, with,
100 00:09:12.440 ⇒ 00:09:25.890 Mustafa Raja: emailed Tim, and we were able to get proper access, read and write access to BigQuery, and I was able to test that out, and so the issue with the service account is resolved.
101 00:09:26.850 ⇒ 00:09:28.809 Awaish Kumar: So, we have the service account key.
102 00:09:29.100 ⇒ 00:09:30.780 Mustafa Raja: Yeah. Yeah.
103 00:09:30.780 ⇒ 00:09:31.200 Awaish Kumar: Yay.
104 00:09:31.200 ⇒ 00:09:33.749 Mustafa Raja: For BigQuery, we do that. We do have that.
105 00:09:34.060 ⇒ 00:09:39.190 Awaish Kumar: So, what are the next steps? I… I don’t see… this board?
106 00:09:39.190 ⇒ 00:09:53.299 Mustafa Raja: Yeah, so this, we can, we can take a look at, what’s it called, the cancel for that, but the next steps would be to, you know, add that to the, dbt repo that we created earlier.
107 00:09:53.470 ⇒ 00:10:07.820 Mustafa Raja: And also, I believe we, we have received some, files in, Google Drive that we want to ingest into BigQuery, so these two tasks.
108 00:10:09.200 ⇒ 00:10:09.930 Awaish Kumar: Okay.
109 00:10:10.610 ⇒ 00:10:12.160 Awaish Kumar: So…
110 00:10:12.160 ⇒ 00:10:15.239 Uttam Kumaran: We confirmed we got all the access yesterday, right?
111 00:10:15.610 ⇒ 00:10:19.630 Mustafa Raja: We have the read and write access for BigQuery.
112 00:10:22.060 ⇒ 00:10:23.030 Uttam Kumaran: Okay, okay.
113 00:10:23.030 ⇒ 00:10:30.220 Awaish Kumar: We have received the service account key, and now we are discussing how to ingest the files that Amber was requesting to ingest.
114 00:10:30.390 ⇒ 00:10:35.640 Awaish Kumar: And then, maybe let’s also create some tickets here from GetChart.
115 00:10:36.080 ⇒ 00:10:36.700 Mustafa Raja: Yeah.
116 00:10:39.250 ⇒ 00:10:42.879 Awaish Kumar: Okay, then we don’t have anything on upper stems…
117 00:10:43.240 ⇒ 00:10:46.180 Awaish Kumar: Yeah, then we can move on to Element.
118 00:10:46.980 ⇒ 00:10:47.740 Awaish Kumar: Boom.
119 00:10:49.000 ⇒ 00:10:53.229 Awaish Kumar: So, as of yesterday, we have some planned
120 00:10:53.360 ⇒ 00:10:56.519 Awaish Kumar: For retail analysis, which is in review.
121 00:10:58.480 ⇒ 00:11:04.689 Awaish Kumar: And then I ingested the wholesale data, like, another sheet which we got from medicine.
122 00:11:05.020 ⇒ 00:11:07.200 Awaish Kumar: That’s in Snowflake.
123 00:11:07.650 ⇒ 00:11:11.680 Awaish Kumar: Yeah, I will be… yeah, I will be working on…
124 00:11:11.870 ⇒ 00:11:17.210 Awaish Kumar: Now finalizing the cake table, which we are targeting for wholesale.
125 00:11:19.020 ⇒ 00:11:20.959 Awaish Kumar: That’s for me.
126 00:11:21.160 ⇒ 00:11:25.570 Awaish Kumar: And, yeah, Utam, if you want to give any updates.
127 00:11:27.200 ⇒ 00:11:29.000 Uttam Kumaran: Yeah, so…
128 00:11:29.330 ⇒ 00:11:36.209 Uttam Kumaran: On Element, yeah, I think we had a… we had a nice state yesterday. I think we have clarity on the next steps for…
129 00:11:36.360 ⇒ 00:11:41.629 Uttam Kumaran: wholesale, so I guess my question, Awash, is, like, is… are we…
130 00:11:41.890 ⇒ 00:11:44.270 Uttam Kumaran: I’m planning on executing that this week.
131 00:11:45.110 ⇒ 00:11:46.639 Awaish Kumar: Yes, like,
132 00:11:46.640 ⇒ 00:11:47.190 Uttam Kumaran: Okay.
133 00:11:47.190 ⇒ 00:11:51.930 Awaish Kumar: Today, basically, yesterday I spent a lot of my time on Hydra.
134 00:11:52.110 ⇒ 00:11:59.610 Awaish Kumar: And I ingested the… all the, like, the data for Whole Shell, which is, like, we got a new sheet that’s also ingested.
135 00:11:59.730 ⇒ 00:12:03.610 Awaish Kumar: I just now have to, like… Enjoying the data in.
136 00:12:03.740 ⇒ 00:12:05.359 Awaish Kumar: And come up with some table.
137 00:12:06.140 ⇒ 00:12:06.790 Uttam Kumaran: Okay.
138 00:12:07.240 ⇒ 00:12:07.870 Awaish Kumar: Okay.
139 00:12:08.930 ⇒ 00:12:14.220 Uttam Kumaran: Okay, cool, so then that’s, I think, for, and then we’re… we’re gonna review the…
140 00:12:14.400 ⇒ 00:12:18.009 Uttam Kumaran: We’re reviewing the retail analysis for.
141 00:12:19.420 ⇒ 00:12:21.439 Awaish Kumar: For Element 2, as well.
142 00:12:22.700 ⇒ 00:12:26.930 Uttam Kumaran: And so, yeah, I mean, I feel pretty good there.
143 00:12:27.260 ⇒ 00:12:29.260 Uttam Kumaran: I’m gonna send out… yeah, go ahead.
144 00:12:29.500 ⇒ 00:12:33.050 Awaish Kumar: Do we have any, like, updates on Omni trial, or…
145 00:12:33.610 ⇒ 00:12:38.330 Uttam Kumaran: Yeah, I was gonna ask, like, I wonder if we should just wait… Okay. Like…
146 00:12:38.470 ⇒ 00:12:42.160 Uttam Kumaran: Yeah, I thought about it yesterday, and I was like.
147 00:12:42.370 ⇒ 00:12:44.390 Uttam Kumaran: There’s just too many things going on.
148 00:12:44.560 ⇒ 00:12:50.669 Uttam Kumaran: So I don’t want us to take on too much. We have slated to, like, do the Omni work next month.
149 00:12:50.840 ⇒ 00:12:55.530 Uttam Kumaran: So let’s just go ahead and, like… Crush the stuff for wholesale.
150 00:12:55.800 ⇒ 00:12:58.950 Uttam Kumaran: And then we’ll get to it when we get to it, you know?
151 00:12:59.650 ⇒ 00:13:00.390 Awaish Kumar: Okay.
152 00:13:02.620 ⇒ 00:13:09.059 Awaish Kumar: And, yeah, I have, like, this… Should I just ask Carlos?
153 00:13:09.980 ⇒ 00:13:14.350 Awaish Kumar: for that, or should we wait, right? Like, because this is going to take time.
154 00:13:14.470 ⇒ 00:13:18.309 Awaish Kumar: for polyatomic to build, right? It’s not going to be in general.
155 00:13:21.910 ⇒ 00:13:24.469 Awaish Kumar: Yeah, I would just ping Carlos again.
156 00:13:24.640 ⇒ 00:13:32.200 Uttam Kumaran: Just to conf… just to… but yeah, I would… well, one, let’s make sure that our source table is up to date.
157 00:13:32.410 ⇒ 00:13:41.699 Uttam Kumaran: And then we can indicate… we can just… let’s just, yeah, we can start to make… send it to Shivani and say, like, hey, we’re still waiting on these accesses. Are we good to reach out?
158 00:13:42.970 ⇒ 00:13:43.640 Awaish Kumar: Okay.
159 00:13:44.280 ⇒ 00:13:56.110 Uttam Kumaran: Yeah, so if you wanna… if you want to, like, kind of, finish up the sources, I can take a look and review and make sure, and then we can send it to Shivani and say, like, we’re still waiting on these, how do we wanna… how do we want to proceed?
160 00:13:56.880 ⇒ 00:13:58.309 Awaish Kumar: Okay, we’ll do that.
161 00:13:58.780 ⇒ 00:14:02.130 Awaish Kumar: Today, also at the…
162 00:14:02.430 ⇒ 00:14:05.630 Awaish Kumar: Apart from that, they’re not CTA.
163 00:14:05.870 ⇒ 00:14:09.860 Awaish Kumar: So, I saw your updates, Ashwani. It was more like you…
164 00:14:10.030 ⇒ 00:14:11.869 Awaish Kumar: Drew came up with some report.
165 00:14:12.590 ⇒ 00:14:13.290 Awaish Kumar: Yeah.
166 00:14:13.290 ⇒ 00:14:17.840 Ashwini Sharma: So, right, I think today we have some internal meeting with CTE.
167 00:14:18.740 ⇒ 00:14:22.800 Uttam Kumaran: Yes, so yeah, me and you will be kind of reviewing Ashwini,
168 00:14:23.000 ⇒ 00:14:25.650 Uttam Kumaran: Plan for this month and next month, and we’ll be working.
169 00:14:25.970 ⇒ 00:14:26.610 Ashwini Sharma: Okay.
170 00:14:26.950 ⇒ 00:14:31.540 Ashwini Sharma: Yeah. When is our meeting with CTA? It’s only on Friday, right?
171 00:14:32.210 ⇒ 00:14:32.940 Uttam Kumaran: Yes.
172 00:14:34.800 ⇒ 00:14:40.410 Ashwini Sharma: Okay, I’ll ping this guy, Kyle, today, and… And get his inputs,
173 00:14:41.700 ⇒ 00:14:44.910 Ashwini Sharma: Last time, before they went on that…
174 00:14:45.070 ⇒ 00:14:50.950 Ashwini Sharma: CES thing, there was one particular work item that he was identifying, he would… he would have
175 00:14:51.360 ⇒ 00:14:53.779 Ashwini Sharma: You know, explain the existing,
176 00:14:54.620 ⇒ 00:15:05.550 Ashwini Sharma: data modeling structure that they have out of multiple different sources, and we’re trying to create some… some kind of report, right? So, one of the reports was the engagement report, which,
177 00:15:05.760 ⇒ 00:15:12.970 Ashwini Sharma: or at least has been identified. But, looking at the data structure, I think the report will change, the data models will change.
178 00:15:13.190 ⇒ 00:15:16.419 Ashwini Sharma: That’s why I have not created any code for that.
179 00:15:17.730 ⇒ 00:15:24.020 Uttam Kumaran: Okay, so that’s your first… so you said, like, there’s good progress on the engagement report.
180 00:15:24.770 ⇒ 00:15:25.090 Ashwini Sharma: I couldn’.
181 00:15:25.090 ⇒ 00:15:26.460 Uttam Kumaran: On the member engaged, yeah.
182 00:15:26.670 ⇒ 00:15:37.599 Ashwini Sharma: Yeah, I could get whatever numbers that is shown, like, Catherine has shared a PDF with me, right, and PDF has some numbers, so I could get those numbers from the data, but the data is really messed up.
183 00:15:37.920 ⇒ 00:15:40.569 Ashwini Sharma: And okay. Yeah.
184 00:15:40.860 ⇒ 00:15:43.679 Ashwini Sharma: So, it’s only partial report.
185 00:15:43.920 ⇒ 00:15:45.240 Ashwini Sharma: And,
186 00:15:45.420 ⇒ 00:15:58.850 Ashwini Sharma: like, the way it works is not a production-grade system right now, so we’ll have to finalize on how we are going to bring the data into Snowflake, as well as… after that, we can do a proper modeling on top of that.
187 00:15:59.500 ⇒ 00:16:10.679 Uttam Kumaran: So, if I could just say it back, I’m gonna say progress on member engagement report, we’re able to replicate the figures that Catherine shared, however, the raw data is messy, so we need a discussion on how to…
188 00:16:11.080 ⇒ 00:16:12.999 Uttam Kumaran: Get a direct feed of that.
189 00:16:13.360 ⇒ 00:16:14.780 Ashwini Sharma: Yes, right.
190 00:16:15.430 ⇒ 00:16:17.400 Uttam Kumaran: Okay, and then I’m just gonna…
191 00:16:17.400 ⇒ 00:16:25.069 Ashwini Sharma: It’s not, yeah, it’s not the entire member engagement report that she prepared, right? It’s only a subset of that.
192 00:16:26.170 ⇒ 00:16:26.680 Ashwini Sharma: And so…
193 00:16:26.680 ⇒ 00:16:29.989 Uttam Kumaran: Okay, so I’ll say, do you know which subset?
194 00:16:30.450 ⇒ 00:16:37.560 Ashwini Sharma: I can give you inputs on which subset. It is mainly on attendance and registrations and, e-bills, something.
195 00:16:37.690 ⇒ 00:16:43.419 Ashwini Sharma: yeah, and others needed more, more datasets, which she didn’t upload.
196 00:16:46.450 ⇒ 00:16:49.509 Uttam Kumaran: So I’m gonna put, at, suite.
197 00:16:49.630 ⇒ 00:16:57.489 Uttam Kumaran: to share specific subsets that we can replicate. However, raw data is a bit messy, data’s currently derived, so…
198 00:16:57.870 ⇒ 00:17:03.109 Uttam Kumaran: asks… We have to identify the proper pipeline and just data.
199 00:17:03.220 ⇒ 00:17:06.870 Uttam Kumaran: It’s actual source into Snowflake. That’s not remembers data?
200 00:17:07.530 ⇒ 00:17:08.680 Ashwini Sharma: It…
201 00:17:08.890 ⇒ 00:17:19.089 Ashwini Sharma: it looks like remembers Data Only, but it, probably… I don’t know, maybe, maybe not, because she has extracted it out of, you know, multiple sources, and…
202 00:17:19.210 ⇒ 00:17:20.700 Ashwini Sharma: Posted into S3.
203 00:17:20.950 ⇒ 00:17:25.119 Ashwini Sharma: And the data extracts are not consistent across different years, right?
204 00:17:25.450 ⇒ 00:17:30.840 Ashwini Sharma: So for 2004, there is one set of data, 2005, a different data set.
205 00:17:33.680 ⇒ 00:17:35.439 Uttam Kumaran: And then I’m gonna ask Kyle…
206 00:17:35.670 ⇒ 00:17:42.569 Uttam Kumaran: So, Kyle, there was a report request from December that you wanted our help on. Did we know the name of that?
207 00:17:43.450 ⇒ 00:17:47.819 Ashwini Sharma: I… I don’t know the name, it was a Power BI report, right?
208 00:17:49.660 ⇒ 00:17:51.759 Uttam Kumaran: Okay, yeah, okay. So there’s a…
209 00:17:52.730 ⇒ 00:17:54.420 Ashwini Sharma: I’ll ping him today.
210 00:17:55.260 ⇒ 00:17:56.919 Uttam Kumaran: I’ll send a note, I’ll send a note right now.
211 00:17:59.090 ⇒ 00:17:59.770 Awaish Kumar: Okay.
212 00:18:00.220 ⇒ 00:18:02.090 Uttam Kumaran: Okay, thanks, that’s great.
213 00:18:03.800 ⇒ 00:18:11.059 Awaish Kumar: So, like, apart from that report, like, are we trying to come up with some plan for each year or anything here?
214 00:18:11.630 ⇒ 00:18:15.430 Uttam Kumaran: Yeah, we already do have a plan, we just haven’t been able to…
215 00:18:15.890 ⇒ 00:18:21.920 Uttam Kumaran: do anything for a few weeks, because they were out, and then Catherine has been out, so…
216 00:18:22.180 ⇒ 00:18:24.359 Uttam Kumaran: Yeah, we have a plan, so we’re…
217 00:18:24.360 ⇒ 00:18:24.830 Ashwini Sharma: Yeah.
218 00:18:24.830 ⇒ 00:18:29.170 Uttam Kumaran: Polyatomic is working on some ETL into Snowflake for them.
219 00:18:30.510 ⇒ 00:18:34.339 Awaish Kumar: Okay, then I think this board needs to be cleaned up a little bit.
220 00:18:34.800 ⇒ 00:18:37.959 Uttam Kumaran: Yeah, so that’s what we’re meeting… we’re meeting today to… yeah.
221 00:18:39.480 ⇒ 00:18:41.470 Uttam Kumaran: But I appreciate it, yeah, we’ll clean that up.
222 00:18:42.840 ⇒ 00:18:48.799 Awaish Kumar: Okay, yeah, we can move on to next, hydra, so…
223 00:18:49.040 ⇒ 00:18:54.009 Awaish Kumar: I… yeah, I need to ticket a few things here, but, like, I just spent, kind of.
224 00:18:54.450 ⇒ 00:18:57.439 Awaish Kumar: Around, like, maybe 3-4 hours here.
225 00:18:57.630 ⇒ 00:19:04.060 Awaish Kumar: Meeting with her, and figuring out a few stuff, and implementing a few things for her on the data modeling side.
226 00:19:05.180 ⇒ 00:19:11.070 Awaish Kumar: For analysis side, she needed some help, but I… I just said we are working on SOW for that right now.
227 00:19:11.680 ⇒ 00:19:12.270 Uttam Kumaran: Okay.
228 00:19:12.490 ⇒ 00:19:25.529 Uttam Kumaran: Yeah, so, like, I would just push… I’m gonna… I’m gonna bring it up again today. If you want to come to our strategy meeting after this, you’re more than welcome to, but I’m… I… I basically want us to get that out today.
229 00:19:26.530 ⇒ 00:19:27.230 Awaish Kumar: Okay.
230 00:19:28.630 ⇒ 00:19:32.639 Awaish Kumar: Okay, yeah, I… I can join.
231 00:19:33.170 ⇒ 00:19:34.319 Awaish Kumar: That… okay.
232 00:19:36.940 ⇒ 00:19:44.630 Awaish Kumar: Then we have Magic Spoon, which is… On the Magic Spoons.
233 00:19:46.140 ⇒ 00:19:51.090 Awaish Kumar: I think we have this audit, right, that we were working, otherwise we are blocked on that access.
234 00:19:51.090 ⇒ 00:19:56.599 Ashwini Sharma: Yeah, so I worked on the audit yesterday, after loading the new set of data.
235 00:19:56.750 ⇒ 00:20:06.659 Ashwini Sharma: And turns out that they had loaded that particular data a few weeks earlier, so they… it has data from August onwards only. And
236 00:20:06.870 ⇒ 00:20:15.080 Ashwini Sharma: the data that I have is for December, 26 onwards, right? And… and bust.
237 00:20:15.260 ⇒ 00:20:21.000 Ashwini Sharma: December 26th and past, and that data set does not match. So, yesterday, Michael said that.
238 00:20:21.110 ⇒ 00:20:27.759 Ashwini Sharma: you will be loading data from the platform, and that data is what we’ll have to QA with data from Spins.
239 00:20:28.150 ⇒ 00:20:30.500 Ashwini Sharma: So I’m waiting for him to do that.
240 00:20:30.620 ⇒ 00:20:35.150 Ashwini Sharma: In the meantime, I have created a different ticket for myself, which is…
241 00:20:35.350 ⇒ 00:20:45.119 Ashwini Sharma: creating a dbt model which aggregates the weekly data that we have from SPINs into, 4-week, 12-week, 24, and 52-week aggregations.
242 00:20:45.270 ⇒ 00:20:53.930 Ashwini Sharma: So for every week of data we have, I’ll create an aggregated model, and then that model will be used to do the QA against the production data.
243 00:20:57.460 ⇒ 00:20:58.280 Awaish Kumar: Okay.
244 00:20:59.080 ⇒ 00:21:08.190 Awaish Kumar: So, this is basically… So, like, like, are we on track in terms of…
245 00:21:08.190 ⇒ 00:21:08.720 Ashwini Sharma: Yep.
246 00:21:08.720 ⇒ 00:21:11.650 Awaish Kumar: We’re on track in terms of, yeah, this thing.
247 00:21:11.650 ⇒ 00:21:21.480 Ashwini Sharma: So, I mean, in track, we are kind of blocked on the client, mainly because, like, they have not provided certain things that they should be providing.
248 00:21:21.730 ⇒ 00:21:27.590 Ashwini Sharma: For example, like, Demilada is not able to do dbt optimization because there’s no cloud dbt access.
249 00:21:27.740 ⇒ 00:21:33.140 Ashwini Sharma: I’m not able to deploy the code to Prefect, because again, the owner access is missing.
250 00:21:33.690 ⇒ 00:21:38.049 Ashwini Sharma: And I’m not able to do a QA, because they have not loaded the platform data into the system.
251 00:21:38.050 ⇒ 00:21:38.770 Awaish Kumar: Okay.
252 00:21:38.770 ⇒ 00:21:39.610 Ashwini Sharma: So that’s…
253 00:21:40.690 ⇒ 00:21:47.249 Awaish Kumar: Yeah, but we have the… like, the… what we have done, and where we are blocked, kind of. We have all the.
254 00:21:47.250 ⇒ 00:21:50.600 Ashwini Sharma: Yeah, I think it’s clearly identified, we have mentioned it to them.
255 00:21:51.090 ⇒ 00:21:57.780 Awaish Kumar: Okay, yeah, great. Okay, thank you, everyone. I think that’s it from my side.
256 00:21:58.340 ⇒ 00:22:01.220 Awaish Kumar: Is there anything someone wants to share?
257 00:22:01.890 ⇒ 00:22:13.229 Uttam Kumaran: Yeah, I guess my, Demolade is out today, so I just want to make sure that, Mustafa, like, you’re able to cover on the clients where Demi is the…
258 00:22:13.590 ⇒ 00:22:23.999 Uttam Kumaran: CSO. If you have any questions on that, maybe let’s… we can discuss some engagement planners. Kind of our goal is that, like, if the CSO is out, like, the EP can basically play backup.
259 00:22:24.100 ⇒ 00:22:37.120 Uttam Kumaran: So, I’m hopeful that, like, yeah, if Demi isn’t able to come back later, that you’re able to sort of send the message out to default on progress. And then similarly, Ashwini, on, on any of your
260 00:22:37.240 ⇒ 00:22:43.729 Uttam Kumaran: you know, stuff you’re working with Demi on, you’re able to send out, like, the daily note, basically, would be… would be great.
261 00:22:44.040 ⇒ 00:22:45.859 Ashwini Sharma: Yeah, I’ll do that. It’s, it’s.
262 00:22:45.860 ⇒ 00:22:46.540 Uttam Kumaran: Yes, who?
263 00:22:46.540 ⇒ 00:22:47.180 Ashwini Sharma: filtered.
264 00:22:47.620 ⇒ 00:22:52.369 Awaish Kumar: Yeah, we already discussed, like, in the beginning, with Mustafa, we’ll be joining a meeting.
265 00:22:52.690 ⇒ 00:22:58.140 Awaish Kumar: with default, which is scheduled with the WRD right now.
266 00:22:58.460 ⇒ 00:23:01.520 Awaish Kumar: And, we’ll be sharing those Slack updates as well.
267 00:23:03.480 ⇒ 00:23:03.920 Uttam Kumaran: Okay.
268 00:23:03.920 ⇒ 00:23:09.019 Mustafa Raja: Yeah, so, so in an hour, I have a meeting with Laura.
269 00:23:09.240 ⇒ 00:23:18.950 Mustafa Raja: Who’s filling in for Deanna. So, I’ll just be understanding, her requirements and, possibly updating the Gantt chart.
270 00:23:19.060 ⇒ 00:23:22.230 Mustafa Raja: Based on holiday and requirements.
271 00:23:26.880 ⇒ 00:23:27.460 Uttam Kumaran: Okay.
272 00:23:30.980 ⇒ 00:23:31.650 Awaish Kumar: Yep.
273 00:23:32.360 ⇒ 00:23:33.240 Mustafa Raja: Thank you.
274 00:23:34.410 ⇒ 00:23:35.589 Uttam Kumaran: Okay, thanks everyone.
275 00:23:35.960 ⇒ 00:23:36.400 Awaish Kumar: Right.
276 00:23:36.400 ⇒ 00:23:37.210 Mustafa Raja: Bye.