Meeting Title: Brainforge x Element Onboarding Sync Date: 2026-05-12 Meeting participants: Awaish Kumar, Nikhil Balasaheb


WEBVTT

1 00:00:06.390 00:00:08.270 Awaish Kumar: Hi, Nikil, how are you?

2 00:00:10.500 00:00:13.480 Nikhil Balasaheb: Hey, Havish, I’m really good. How about you?

3 00:00:14.500 00:00:16.519 Awaish Kumar: I’m good as well.

4 00:00:17.110 00:00:19.799 Awaish Kumar: Yeah, welcome to Benforge.

5 00:00:20.520 00:00:22.010 Nikhil Balasaheb: Yeah, thank you. Thanks.

6 00:00:22.450 00:00:23.590 Awaish Kumar: How’s it been your day?

7 00:00:24.870 00:00:32.000 Nikhil Balasaheb: It’s doing all good, yeah. It’s the second day, as I mentioned, first day, mostly spent on the…

8 00:00:32.200 00:00:35.430 Nikhil Balasaheb: Setting up the accounts and all that sort of stuff, yeah.

9 00:00:36.570 00:00:41.919 Awaish Kumar: Okay, so you have access to, Git… GitHub?

10 00:00:44.100 00:00:45.250 Awaish Kumar: Brain Forge.

11 00:00:46.760 00:00:50.780 Awaish Kumar: organization, and then OnePass, Google Drive, everything.

12 00:00:53.480 00:01:02.339 Nikhil Balasaheb: Yeah, so got access to GitHub, Brainforce platform, and then the other, invites that I received in email.

13 00:01:03.110 00:01:06.000 Awaish Kumar: Do you have access to 1Pass? Have you set up…

14 00:01:06.000 00:01:07.339 Nikhil Balasaheb: Yeah, yeah, I do, I do.

15 00:01:07.340 00:01:07.930 Awaish Kumar: Okay.

16 00:01:08.550 00:01:11.270 Awaish Kumar: And then, what else do you need?

17 00:01:12.190 00:01:17.219 Awaish Kumar: Okay, and you have the cutsar, and the… As well, right?

18 00:01:18.250 00:01:26.749 Nikhil Balasaheb: Yeah, I saw this repository, and then the skills in that one, so I have a cloud, my personal cloud, so…

19 00:01:27.140 00:01:37.340 Nikhil Balasaheb: Can I continue using that one? I believe the skills, someone already created, links for the cursor skills, you know, so…

20 00:01:37.650 00:01:39.760 Nikhil Balasaheb: That should work, Avlia.

21 00:01:40.770 00:01:41.560 Awaish Kumar: Okay.

22 00:01:42.640 00:01:45.319 Awaish Kumar: Yeah, I think so. You can use that.

23 00:01:45.510 00:01:50.960 Awaish Kumar: So, like, what you are using for… For, like, development.

24 00:01:52.160 00:01:53.100 Nikhil Balasaheb: So, go start.

25 00:01:53.780 00:01:56.809 Awaish Kumar: I mean, what are you using for development?

26 00:01:57.800 00:01:59.709 Nikhil Balasaheb: Vs Code and Cloud Code.

27 00:02:00.430 00:02:01.770 Awaish Kumar: Okay, you have Cloud Code.

28 00:02:01.940 00:02:02.600 Nikhil Balasaheb: Yeah.

29 00:02:03.460 00:02:04.330 Awaish Kumar: Okay.

30 00:02:07.180 00:02:14.370 Awaish Kumar: Okay, so… Yeah, you can use that as long as you can apply the skills and all.

31 00:02:16.530 00:02:22.030 Nikhil Balasaheb: So, cursor, are we on the Pro Plus plan or Ultra Plan?

32 00:02:22.350 00:02:24.459 Nikhil Balasaheb: Or it’s, business teams.

33 00:02:25.560 00:02:29.889 Awaish Kumar: Yeah, I… I haven’t actually looked at that, what primarily around.

34 00:02:31.020 00:02:32.950 Awaish Kumar: I can look at it right now.

35 00:02:33.240 00:02:38.189 Awaish Kumar: But the… okay, yeah, the thing is, right now, what I want to make sure is that you are…

36 00:02:38.380 00:02:39.380 Awaish Kumar: Set up.

37 00:02:39.780 00:02:43.020 Awaish Kumar: In terms of, whatever you need.

38 00:02:43.220 00:02:51.170 Awaish Kumar: Tools, and the… The access to repositories.

39 00:02:51.740 00:02:55.750 Awaish Kumar: And one pass. Yeah, we are on a team plan.

40 00:02:57.820 00:03:00.590 Nikhil Balasaheb: Yeah, it’s a team’s $40 plan, okay.

41 00:03:01.240 00:03:01.830 Awaish Kumar: Okay.

42 00:03:02.640 00:03:04.909 Awaish Kumar: No, yeah, so…

43 00:03:07.020 00:03:13.680 Awaish Kumar: So, yeah, what I was… what I’m thinking is now, we want to assign, you for the week on a…

44 00:03:13.830 00:03:16.480 Awaish Kumar: on a client called, Rink Element.

45 00:03:20.560 00:03:24.089 Awaish Kumar: So, for that, I want to give you access to the repository.

46 00:03:26.530 00:03:28.640 Nikhil Balasaheb: Which client are you talking about?

47 00:03:29.360 00:03:30.490 Awaish Kumar: Drink Element.

48 00:03:32.520 00:03:35.100 Nikhil Balasaheb: Brink. Sorry, I didn’t get that.

49 00:03:35.920 00:03:37.670 Awaish Kumar: Yeah, yeah, drink element.

50 00:03:38.140 00:03:40.350 Nikhil Balasaheb: Drink element, okay, got it, okay.

51 00:03:40.520 00:03:44.700 Awaish Kumar: So a client name, so normally we call it just element, and

52 00:03:45.570 00:03:51.240 Awaish Kumar: We, right now, in our repository, we just have two things, dbt project.

53 00:03:51.580 00:03:55.419 Awaish Kumar: And the Omni project. Omni is a BI tool.

54 00:03:55.650 00:04:02.150 Awaish Kumar: So… I’m just, adding you to the report. Can you, send me the handle, GitHub handle?

55 00:04:03.720 00:04:05.200 Nikhil Balasaheb: Yeah, sure, it’s.

56 00:04:24.260 00:04:25.390 Awaish Kumar: I’m sure.

57 00:04:50.120 00:04:51.659 Awaish Kumar: Could you share the handle?

58 00:04:52.940 00:04:54.629 Nikhil Balasaheb: Yeah, it’s in the Slack.

59 00:04:57.270 00:04:58.880 Nikhil Balasaheb: I sent you in Slack.

60 00:05:07.830 00:05:08.900 Awaish Kumar: Okay,

61 00:05:12.820 00:05:19.090 Awaish Kumar: Okay, Nikhil, you… I see… Three different profiles with this handle.

62 00:05:20.860 00:05:24.920 Nikhil Balasaheb: Sorry, which one can you show me? Share the screen, and…

63 00:05:29.600 00:05:30.840 Awaish Kumar: Yes, it is wrong.

64 00:05:35.110 00:05:36.380 Nikhil Balasaheb: I think the first one.

65 00:05:39.870 00:05:40.840 Awaish Kumar: This one?

66 00:05:41.160 00:05:42.010 Awaish Kumar: Okay.

67 00:05:43.640 00:05:44.629 Awaish Kumar: Are you sure?

68 00:05:44.860 00:05:48.059 Nikhil Balasaheb: Yeah, that’s, nikhil hyphen, yeah.

69 00:05:48.790 00:05:51.750 Awaish Kumar: Read, file, maintained.

70 00:05:52.470 00:05:53.260 Awaish Kumar: Okay.

71 00:05:56.410 00:05:59.269 Awaish Kumar: So… Now you are on this…

72 00:05:59.630 00:06:02.809 Awaish Kumar: Repository, let me know if you can accept the invite.

73 00:06:03.540 00:06:16.260 Awaish Kumar: And I can brief you about our… Workflow, and all the… Like, knowledge docs we have.

74 00:06:16.990 00:06:22.259 Awaish Kumar: For this client. So you can just, like, study about the client, and…

75 00:06:22.920 00:06:28.030 Awaish Kumar: What different sorts, like, the systems we have, and the tools we have.

76 00:06:28.490 00:06:31.980 Awaish Kumar: And their team structure, the kind of data we are working with.

77 00:06:32.340 00:06:33.220 Awaish Kumar: Okay.

78 00:06:36.380 00:06:41.460 Awaish Kumar: So for that, what you can do is the… and, and…

79 00:06:41.980 00:06:47.470 Awaish Kumar: If you go to the drive from your email, Winfo, Gmail.

80 00:06:50.180 00:06:54.039 Awaish Kumar: If you go to the shared drives, do you have access to this?

81 00:06:54.370 00:06:56.210 Awaish Kumar: She arrives…

82 00:06:57.880 00:07:01.850 Nikhil Balasaheb: Still Share… no, I don’t have access to Shadrive.

83 00:07:03.670 00:07:05.420 Awaish Kumar: Okay, you can ask Rico.

84 00:07:05.700 00:07:07.810 Awaish Kumar: To give you access?

85 00:07:09.160 00:07:11.839 Awaish Kumar: To this drive, or at least.

86 00:07:12.150 00:07:14.700 Nikhil Balasaheb: You… can you not give it from here, no?

87 00:07:15.800 00:07:17.919 Awaish Kumar: I don’t think so, I don’t have one.

88 00:07:18.450 00:07:19.639 Nikhil Balasaheb: Yeah, bless him.

89 00:07:23.410 00:07:28.130 Awaish Kumar: Yeah, so, yeah, Rico is our, kind of, access management person.

90 00:07:28.590 00:07:35.970 Awaish Kumar: Here, so… for every access… needs for any tools, you just have to ask him.

91 00:07:36.900 00:07:42.130 Awaish Kumar: Normally we just have access to GitHub repositories, as an admin.

92 00:07:43.430 00:07:45.799 Awaish Kumar: For… so far this, like, we…

93 00:07:45.930 00:07:57.309 Awaish Kumar: You need access to this folder, at least. If they… if he can share the full drive, that’s fine, otherwise you will need access to this drive, and in this drive, you can find multiple…

94 00:07:57.560 00:07:58.760 Awaish Kumar: Documents?

95 00:07:59.670 00:08:02.760 Awaish Kumar: memos we created for… for the Brain Forge.

96 00:08:02.970 00:08:06.390 Awaish Kumar: And this folder is actually shared with client.

97 00:08:08.300 00:08:20.160 Awaish Kumar: So whatever is in there is actually documents from us, or documents from client. They are, like, shared with the client, so… so whenever we want to share anything with the client, we put it in here.

98 00:08:20.980 00:08:26.440 Awaish Kumar: But if it is something about the client, but we don’t have to share it with the client, then it ends up being here.

99 00:08:29.070 00:08:38.380 Awaish Kumar: So, and most of it also lives in our GitHub called Brainforce Platform. You already, I think, just mentioned that.

100 00:08:39.760 00:08:43.570 Awaish Kumar: So, in this repository, called BrainForge Platform.

101 00:08:43.860 00:08:48.040 Awaish Kumar: Basically, we manage all the knowledge base regarding the clients.

102 00:08:50.080 00:08:54.409 Awaish Kumar: So, most of those docs we create on Drive is for, like.

103 00:08:55.470 00:09:02.190 Awaish Kumar: If we want to share something with sales, or if we want to share something with client, we normally have to create them docs, but otherwise.

104 00:09:02.530 00:09:07.040 Awaish Kumar: We just go in here, in the knowledge base, and the clients.

105 00:09:08.330 00:09:17.420 Awaish Kumar: And we just have all the files here as our… Markdown files.

106 00:09:17.760 00:09:19.190 Awaish Kumar: Whatever.

107 00:09:19.340 00:09:22.709 Awaish Kumar: So, so that our knowledge base lives lives in one place.

108 00:09:22.870 00:09:25.969 Awaish Kumar: After that, if you want to use any…

109 00:09:28.270 00:09:34.859 Awaish Kumar: If you want to have, like, know about anything, any context, if… yeah, we just use this to actually…

110 00:09:35.110 00:09:44.959 Awaish Kumar: if you want to learn anything about client. So now you are ramping up on the client, you can actually use this. You can actually clone and ask, like, questions about the client.

111 00:09:44.990 00:09:56.169 Awaish Kumar: what data they deal with, what kind of client it is, what source systems they have, so it should be able to answer everything you want to know about a client. And the GBT project, and…

112 00:09:56.210 00:09:58.270 Awaish Kumar: All the structure regarding that.

113 00:09:58.990 00:10:05.639 Awaish Kumar: I also have transcripts, so it has all the transcripts about our… our meetings with the client.

114 00:10:07.510 00:10:18.510 Awaish Kumar: So whatever meetings we have with the client, like, anyone from our team has with the client, it ends up being, being in a transcript, and it ends up here.

115 00:10:18.690 00:10:31.539 Awaish Kumar: So that we also remember, so, like, next time you can ask, like, what was… what we discussed in this meeting, what were the asks, what are new tickets we can build, so you can actually just use this for the…

116 00:10:31.960 00:10:36.779 Awaish Kumar: So it’s kind of, we use pretty heavily the Inforge platform.

117 00:10:36.920 00:10:42.100 Awaish Kumar: This is the repository that manages knowledge base, but that also powers the

118 00:10:42.240 00:10:44.609 Awaish Kumar: Platform you saw, like this one?

119 00:10:46.660 00:10:49.199 Awaish Kumar: This platform is powered by this repository.

120 00:10:50.350 00:10:54.020 Awaish Kumar: And the transcripts on the meeting we saw are just here.

121 00:10:56.000 00:10:58.430 Awaish Kumar: And, apart from that…

122 00:11:01.530 00:11:03.969 Awaish Kumar: Yeah, apart from that, you are…

123 00:11:04.310 00:11:06.520 Awaish Kumar: You have access to linear as well, right?

124 00:11:09.920 00:11:11.459 Awaish Kumar: Do you have access to linear?

125 00:11:11.710 00:11:12.840 Nikhil Balasaheb: Yeah, yeah, I do, yeah.

126 00:11:13.530 00:11:17.040 Awaish Kumar: At the… you are able to see the element client?

127 00:11:17.370 00:11:18.230 Awaish Kumar: R.

128 00:11:21.960 00:11:24.800 Nikhil Balasaheb: Don’t see these things, no.

129 00:11:26.480 00:11:29.120 Awaish Kumar: Okay, let me play this, see.

130 00:11:30.360 00:11:31.500 Awaish Kumar: I can add.

131 00:11:36.600 00:11:38.730 Awaish Kumar: Suname, killed…

132 00:11:39.680 00:11:43.730 Nikhil Balasaheb: I see, only… default, yeah.

133 00:11:44.860 00:11:46.409 Awaish Kumar: I just added you here.

134 00:11:50.290 00:11:53.039 Awaish Kumar: I just added you as a member here, Nikhil.

135 00:11:53.160 00:11:53.890 Nikhil Balasaheb: Huh?

136 00:11:54.280 00:12:00.120 Awaish Kumar: You should be able to see the… Element, generally.

137 00:12:00.880 00:12:02.789 Awaish Kumar: Oh, sorry, the team on the linear?

138 00:12:05.790 00:12:06.550 Nikhil Balasaheb: Let me check.

139 00:12:06.980 00:12:08.550 Nikhil Balasaheb: Yeah, I can see it now.

140 00:12:08.850 00:12:09.490 Awaish Kumar: Okay.

141 00:12:09.610 00:12:16.970 Awaish Kumar: So, basically, once, what I want is just… Get familiarized yourself.

142 00:12:18.820 00:12:20.679 Awaish Kumar: With everything on this…

143 00:12:22.240 00:12:28.830 Awaish Kumar: client. So you can just look at some of the tickets, data modeling tickets that are assigned to me, or

144 00:12:29.110 00:12:30.830 Awaish Kumar: Harutamor Ashuni.

145 00:12:31.010 00:12:42.320 Awaish Kumar: And then you can also look at some of the… Basically… Ask questions in the platform.

146 00:12:42.570 00:12:50.820 Awaish Kumar: Regarding client, and then, look at the platform. The last thing that I want to show you is in this drive.

147 00:12:51.310 00:12:54.160 Awaish Kumar: I… we… we manage a kind of a…

148 00:12:54.300 00:13:00.849 Awaish Kumar: Two things as our main, like, data… Platform assets.

149 00:13:03.320 00:13:06.420 Awaish Kumar: One is architectural diagram that we want to maintain.

150 00:13:06.860 00:13:09.870 Awaish Kumar: From the client, that… what system we have built.

151 00:13:10.100 00:13:12.150 Awaish Kumar: And then second thing is,

152 00:13:13.710 00:13:20.100 Awaish Kumar: this document. It’s kind of a… I want to have it as a source of truth, for each client.

153 00:13:20.780 00:13:28.499 Awaish Kumar: So we might… so what… what happens here is that you have… Hmm… Information about the client.

154 00:13:29.920 00:13:36.399 Awaish Kumar: It’s about what different… channels they are, it’s… This is just some, some…

155 00:13:36.880 00:13:50.150 Awaish Kumar: Sheets are created by the team members for their… if they are, like, wanting to find definitions about things about the client, like… so this channels is not a standard sheet for each client, it’s just limited to this one.

156 00:13:50.320 00:13:53.809 Awaish Kumar: So someone wanted to standardize what channel means.

157 00:13:54.240 00:13:56.140 Awaish Kumar: And what are different partners?

158 00:13:56.730 00:13:57.570 Nikhil Balasaheb: And then…

159 00:13:58.110 00:14:01.860 Awaish Kumar: But then the standard one is, like, for example, data tools.

160 00:14:01.990 00:14:07.920 Awaish Kumar: So these are the… Tools that we are… that are being used for this client right now.

161 00:14:08.140 00:14:11.029 Awaish Kumar: Does that mean,

162 00:14:11.320 00:14:17.419 Awaish Kumar: We are using it, or if they are using it for the data work, then we… they are basically mentioned here.

163 00:14:18.010 00:14:20.190 Awaish Kumar: And then we have data sources.

164 00:14:20.490 00:14:26.420 Awaish Kumar: So this series, like, maintains the source of truth for all the data source systems they have.

165 00:14:27.070 00:14:35.270 Awaish Kumar: And what is the status of those, like, in terms of moving them into warehouse? I’m building the reporting on top of it.

166 00:14:35.480 00:14:43.200 Awaish Kumar: So we have… like, the source system, for a few of them, we already

167 00:14:43.760 00:14:53.320 Awaish Kumar: migrated the data to warehouse, we have the modeling on top of it, but some of it is still… we need to bring them in, so it’s ongoing work.

168 00:14:54.280 00:15:00.460 Awaish Kumar: It’s a bit, like, might be, like, producer…

169 00:15:00.570 00:15:15.949 Awaish Kumar: stale data… stale information, because, like, we’ll put it as we… as it comes in the meetings, and then sometimes you’ll lose track and… and miss, but for example, Snapchat ad, they’re not anymore adding any…

170 00:15:16.070 00:15:25.589 Awaish Kumar: running any campaigns on the Snapchat, so this is kind of a still row, we can just delete. But mainly, this is the source of truth for all our source systems, and they’re…

171 00:15:25.810 00:15:27.960 Awaish Kumar: in, like, the ETL process.

172 00:15:28.120 00:15:33.070 Awaish Kumar: Then, this is metrics sheet, so this is a source of truth for mainly for…

173 00:15:33.280 00:15:40.790 Awaish Kumar: the BI into people, so they see what different, metrics we have.

174 00:15:41.560 00:15:44.280 Awaish Kumar: What are their names in the DVD mugs?

175 00:15:44.590 00:15:46.189 Awaish Kumar: What kind of data?

176 00:15:47.050 00:15:52.219 Awaish Kumar: Like, it comes… like, we use for this… for calculate… calculating this metric.

177 00:15:52.330 00:15:58.380 Awaish Kumar: what is the definition? What is the formula? So it’s kind of a source of truth for our BI layer.

178 00:15:59.900 00:16:04.090 Awaish Kumar: And then we have, like, list of stakeholders.

179 00:16:04.260 00:16:10.250 Awaish Kumar: across, like, the Marine Forge and… And the client.

180 00:16:11.680 00:16:16.999 Awaish Kumar: They have different teams, so it’s just, like, information about the team.

181 00:16:17.930 00:16:25.370 Awaish Kumar: And then the… some sheets are just edited by the… our team for the understanding, like this one, or this one is…

182 00:16:26.050 00:16:30.470 Awaish Kumar: headed by… Analyst team to actually run their

183 00:16:30.600 00:16:34.889 Awaish Kumar: Supply chain data, discovery with the client, and figure out what

184 00:16:35.650 00:16:38.220 Awaish Kumar: Who the stakeholders are, what they are working with.

185 00:16:38.900 00:16:42.780 Awaish Kumar: Google Sheets, they’re using right now, so that we can…

186 00:16:43.520 00:16:49.149 Awaish Kumar: grab all those metrics. All the metrics that client is using right now, by…

187 00:16:51.660 00:16:57.320 Awaish Kumar: By ingesting data manually, or putting sheets together, or…

188 00:16:57.460 00:17:02.570 Awaish Kumar: So we can actually come up with the similar KPIs, but more in an automated way.

189 00:17:03.000 00:17:11.370 Awaish Kumar: So that’s it. So this is a… for Element, you need this one, actually, to get… familiarize yourself with all the systems Element is using.

190 00:17:11.660 00:17:17.870 Awaish Kumar: And then, on the first platform, as I mentioned, you have all the resources, so docs, and Google Sheets to…

191 00:17:18.069 00:17:21.290 Awaish Kumar: Also, learn more about the client, what data they have.

192 00:17:21.710 00:17:24.590 Awaish Kumar: And then the… the linear port.

193 00:17:24.780 00:17:29.589 Awaish Kumar: So, I will, start assigning some tickets to you after that.

194 00:17:31.310 00:17:39.049 Awaish Kumar: So you can actually… start walking, for the… for the spine. That’s…

195 00:17:41.520 00:17:52.529 Awaish Kumar: That’s it, but there are a few more things that you will learn, like, in the tools section. Let me know what I’ll, like… you obviously need access to all these things, so we just have to…

196 00:17:53.230 00:17:59.419 Awaish Kumar: include you, for all this. I don’t think you have received the access for that.

197 00:17:59.530 00:18:02.629 Awaish Kumar: On the Snowflake, I’m going to create an account for you.

198 00:18:05.660 00:18:13.689 Awaish Kumar: or maybe invite you through email, but then dbt is just open source. We run through GitHub Actions right now.

199 00:18:14.040 00:18:18.880 Awaish Kumar: Then for… There are some Google Sheets, for each.

200 00:18:21.570 00:18:24.599 Awaish Kumar: Manual reporting we are doing right now for Zoom?

201 00:18:27.430 00:18:28.840 Awaish Kumar: The… for the client.

202 00:18:29.210 00:18:33.999 Awaish Kumar: And then… Also, like, you need access to…

203 00:18:34.520 00:18:41.219 Awaish Kumar: Omni, so I will make sure that you have access to all these things. Until then, before that, like, you can just…

204 00:18:42.170 00:18:47.340 Awaish Kumar: Look at the code, and the transcripts, and the platform, and the…

205 00:18:47.860 00:18:55.360 Awaish Kumar: And this Google Sheet in the linear, and in the meantime, I will make sure that you get access to all these tools.

206 00:18:55.630 00:19:03.519 Awaish Kumar: And the one more thing that I wanted to say is, yeah, you can also maybe… for element, actually, you can also go here.

207 00:19:04.100 00:19:06.870 Awaish Kumar: In the observability crides.

208 00:19:08.870 00:19:13.709 Awaish Kumar: So, for element, we have some of the things mentioned here as well.

209 00:19:14.130 00:19:26.160 Awaish Kumar: multiple Slack channels, we have multiple docs, so this is what I was referring to. So, this is our data platform documentation that I was just showing. You can just click here and get the link from here.

210 00:19:27.080 00:19:34.540 Awaish Kumar: This is… this is our manual reporting sheets that our team… analyst team, is actually maintaining.

211 00:19:34.740 00:19:38.810 Awaish Kumar: For the client right now. So, for example, if I click on this one.

212 00:19:39.730 00:19:43.629 Awaish Kumar: This is for wholesale, so they are, like, kind of a CPG business.

213 00:19:43.750 00:19:48.939 Awaish Kumar: And they have multiple channels of selling their drink, like, through e-commerce.

214 00:19:49.100 00:19:52.000 Awaish Kumar: through retailers like Walmart and,

215 00:19:52.120 00:19:56.179 Awaish Kumar: Target, and then through wholesale partners they have.

216 00:19:57.710 00:20:04.680 Awaish Kumar: And this is a sheet for manual reporting for the wholesale that analyst team is maintaining right now, but we are trying to move it to Omni.

217 00:20:04.830 00:20:06.320 Awaish Kumar: which is a BI tool.

218 00:20:06.690 00:20:13.370 Awaish Kumar: But, like, so we are still maintaining it, so it’s, like, active work here going on.

219 00:20:15.710 00:20:19.960 Awaish Kumar: Yeah, that’s pretty much it for the client, if you have any other questions for me.

220 00:20:21.020 00:20:28.160 Nikhil Balasaheb: Okay, so if we go back to linear and see what are the open tickets for this client.

221 00:20:28.690 00:20:36.429 Nikhil Balasaheb: Also, just wanted to understand, like, where are we currently with this client, you know? Like, since how long we are in…

222 00:20:36.630 00:20:37.380 Awaish Kumar: Excuse me.

223 00:20:37.380 00:20:40.829 Nikhil Balasaheb: What has been done, what needs to be done after this?

224 00:20:41.290 00:20:46.979 Awaish Kumar: Okay, so he has… we have been with the client for, like, I can say at least 3 months, maybe?

225 00:20:47.810 00:20:53.550 Awaish Kumar: from… Maybe, yeah, yeah.

226 00:20:53.940 00:21:00.539 Awaish Kumar: 3-4 months, we are with the client, and we have been, able to deliver on our wholesale reporting.

227 00:21:01.230 00:21:09.960 Awaish Kumar: We are able to do our retail reporting, so… for the… Actually, it, let’s…

228 00:21:11.730 00:21:13.720 Awaish Kumar: Let’s look at… go from here.

229 00:21:13.980 00:21:16.979 Awaish Kumar: So from here, so we can see…

230 00:21:19.660 00:21:25.479 Awaish Kumar: These are different milestones based on, I don’t know how they are… Created based on the…

231 00:21:31.060 00:21:36.760 Awaish Kumar: Or work with the… Let’s go back, yeah.

232 00:21:38.990 00:21:40.420 Awaish Kumar: Supply chain.

233 00:21:40.710 00:21:44.730 Awaish Kumar: So basically, these are the tickets for, for example, for wholesale, right?

234 00:21:45.370 00:21:51.969 Awaish Kumar: so, not… Maybe not all the tickets are,

235 00:21:52.750 00:22:00.659 Awaish Kumar: Kind of up-to-date, but, like, for wholesale, what we are doing is… Mostly, we have delivered the…

236 00:22:00.810 00:22:10.540 Awaish Kumar: Reporting and ingesting part, but now we have the tickets coming up as incremental, like, requests for improving, for adding new features.

237 00:22:10.810 00:22:15.489 Awaish Kumar: So I just, got a Slack message, I have to create a ticket here for that.

238 00:22:16.080 00:22:20.280 Awaish Kumar: And then this one is mainly the in-progress thing, so immersion is a…

239 00:22:22.310 00:22:30.749 Nikhil Balasaheb: So, like, if, like, as you mentioned, like, you could assign me tickets, so what could be that one here?

240 00:22:33.580 00:22:38.930 Awaish Kumar: Yeah, mainly it will be, data modeling for e-commerce metrics.

241 00:22:40.630 00:23:00.439 Awaish Kumar: So, right now, it’s called, Amazon, Sync, so it’s… it was blog in JSON, but it’s done right now, so I’ve just completed that part. So, next one is, modeling Amazon, and, and we already have Shopify data model, so what we will be doing is creating the next,

242 00:23:00.590 00:23:10.579 Awaish Kumar: eCom modeling, eCommart, which will basically have data from Amazon, data from Shopify, and create a unified, like, tables that have

243 00:23:10.960 00:23:14.060 Awaish Kumar: They have data from both. So…

244 00:23:14.870 00:23:19.640 Awaish Kumar: Like, creating effect orders, effect order items, creating dim tables.

245 00:23:20.310 00:23:39.070 Awaish Kumar: And then, basically, that will… those will be unified, not specific to any source, but generally for e-commerce, so it will have Shopify, Amazon for now, Walmart is blocker… is blocked. So, like, we haven’t ingested the data right now, so it’s kind of blocked off me.

246 00:23:39.270 00:23:40.779 Awaish Kumar: We’ll be working on that.

247 00:23:41.050 00:23:46.859 Awaish Kumar: So this is the… E-commerce, kind of,

248 00:23:48.580 00:24:04.449 Awaish Kumar: ticket, but it’s… it doesn’t have much of the information here. So what… where you will find the information for the e-commerce is, like, in the Slack channel, if you search for e-commerce metrics sheet or something, so… or maybe ask Jasmine. She has the, like,

249 00:24:05.690 00:24:10.609 Awaish Kumar: Or you can say the specs for the dashboard, like, what you want to build in the dashboard.

250 00:24:11.040 00:24:13.649 Awaish Kumar: So basically, we would use that to figure out, like.

251 00:24:14.100 00:24:18.510 Awaish Kumar: So once… one… one is our gut, or our own gut, like, what…

252 00:24:19.140 00:24:25.069 Awaish Kumar: fields should be there, and tables, and what tables should be there. Also, you can obviously, using AI, you can

253 00:24:25.300 00:24:38.419 Awaish Kumar: figure out, some of those things. But then, specifically for this client, what metrics… metrics needs to be calculated are available in a Google Sheet. I don’t have a link here right now, but it’s in the Slack channel.

254 00:24:38.570 00:24:46.039 Awaish Kumar: Using that, you will exactly know what they are coming from. So we just need to support those metrics.

255 00:24:47.800 00:24:48.460 Nikhil Balasaheb: Okay.

256 00:24:50.030 00:25:00.400 Awaish Kumar: Oh… Yeah, so this is the… Main thing, apart from that,

257 00:25:01.000 00:25:10.229 Awaish Kumar: it needs to have… like, there are a few tickets that are just blocked right now. So, like, as I was talking, immersion follow-up is… Utam is following up on immersion.

258 00:25:10.710 00:25:12.460 Awaish Kumar: It’s one of the stores.

259 00:25:12.640 00:25:16.900 Awaish Kumar: He’s also following up on a… muffin data,

260 00:25:17.360 00:25:24.109 Awaish Kumar: kind of platform. But, for ingesting, like, retail data.

261 00:25:24.250 00:25:33.770 Awaish Kumar: But that’s also kind of a block right now, just in a conversation, so we don’t have to actually do anything there. It’s just some email threads here and there.

262 00:25:34.260 00:25:36.399 Awaish Kumar: Right now, the only focus is,

263 00:25:39.040 00:25:44.770 Awaish Kumar: wholesale and supply chain modeling. For the supply chain modeling,

264 00:25:45.240 00:25:50.589 Awaish Kumar: So, some info data is coming in, and I don’t see any tickets here for the…

265 00:25:50.930 00:25:56.860 Awaish Kumar: Ashwini, but there should be something, and we just need to manually assign them to you.

266 00:25:57.090 00:25:58.150 Awaish Kumar: Boom.

267 00:25:59.170 00:26:02.779 Awaish Kumar: I think we will be dividing it between you and me.

268 00:26:03.360 00:26:09.899 Awaish Kumar: So, we have two different, supply chains and Amazon as work streams, so…

269 00:26:10.970 00:26:14.139 Awaish Kumar: Either I will create some tickets for supply chain for you.

270 00:26:14.670 00:26:19.149 Awaish Kumar: And, I will work on e-commerce, or it will be vice versa, whatever.

271 00:26:19.300 00:26:22.879 Awaish Kumar: But I need to figure out what the status is on supply chain.

272 00:26:23.490 00:26:41.559 Awaish Kumar: Right now with Taishuni, so yeah. Stay tuned, I will just get back to you on that piece, what you will be working on, but just familiarize yourself for the… for now, like, what this is, and then if you want to take over… take something, then, like, e-commerce modeling, I’m pretty sure that it just needs to be

273 00:26:41.940 00:26:54.820 Awaish Kumar: start, like, there’s already some models. If you look at the, like, GitHub repo, I’ve already worked on that, like, creating models. But the problem… there is some problem, right? I can’t,

274 00:26:55.160 00:26:58.639 Awaish Kumar: from Amazon, I didn’t have the data.

275 00:26:59.140 00:27:05.029 Awaish Kumar: ingested all the… we have some historical backfills, we have data coming from some ingestion tool.

276 00:27:05.050 00:27:20.510 Awaish Kumar: And then those data that is coming from ingestion tool does have missing, like, financial information. That is coming from another table called financial events, so it’s just scattered. So we need to rework on that modeling piece to actually

277 00:27:20.540 00:27:23.580 Awaish Kumar: Fill in all the missing pieces together.

278 00:27:26.250 00:27:27.040 Nikhil Balasaheb: Okay.

279 00:27:27.040 00:27:30.549 Awaish Kumar: At that point, if you want to, like, sync again, and…

280 00:27:30.660 00:27:38.499 Awaish Kumar: and ask anything, I’m, like, happy to share, but, like, Maybe I can… Give you one example.

281 00:27:39.340 00:27:48.190 Awaish Kumar: For the element, model… Mars. So, basically, using e-commerce folder here, and you will see some of the

282 00:27:48.460 00:27:51.200 Awaish Kumar: tables that I already tried to create.

283 00:27:51.330 00:27:55.930 Awaish Kumar: But it doesn’t work, it doesn’t have, like, it has data.

284 00:27:57.780 00:28:00.010 Awaish Kumar: For Shopify, it will be fine.

285 00:28:00.310 00:28:04.989 Awaish Kumar: But for the Amazon part, it is bringing data from Amazon orders, which has some

286 00:28:05.530 00:28:13.219 Awaish Kumar: Some data available, but, like, it does not have, you see, the… Most important information, like,

287 00:28:15.530 00:28:17.750 Awaish Kumar: For example, all these fields are null…

288 00:28:19.930 00:28:21.099 Nikhil Balasaheb: Not available there.

289 00:28:21.100 00:28:27.269 Awaish Kumar: Yeah, so not available in this, like, all the amount information is null, so it’s not something…

290 00:28:27.420 00:28:28.419 Awaish Kumar: Thank you, Derek.

291 00:28:28.640 00:28:33.260 Awaish Kumar: expected. So, customer IDs will… So it’s just like,

292 00:28:33.850 00:28:36.279 Awaish Kumar: You can say it’s just a placeholder, kind of,

293 00:28:36.870 00:28:41.800 Awaish Kumar: model. We need to really fill it in with all the information.

294 00:28:41.980 00:28:48.689 Awaish Kumar: So we have some in Snowflake. Once you get the access to Snowflake, you will be able to see what data there is.

295 00:28:48.850 00:28:53.220 Awaish Kumar: And you will be able to… also look at…

296 00:28:53.580 00:29:00.590 Awaish Kumar: what I’m talking about, like, so we are building this data in through, Polytomic, which is an ingestion tool.

297 00:29:00.710 00:29:08.860 Awaish Kumar: It’s not bringing it in the correct format. So, there is another table also coming in through Polytomic, but…

298 00:29:09.070 00:29:11.160 Awaish Kumar: It’s called Financial Limits.

299 00:29:11.280 00:29:21.179 Awaish Kumar: And there is some information regarding financials, is there. So we’ll bring it in from there, then for historical.

300 00:29:21.470 00:29:23.090 Awaish Kumar: data,

301 00:29:23.520 00:29:32.659 Awaish Kumar: we might not have all the data available through Polytopic, so for that, I just ran a manual, like, export kind of thing.

302 00:29:32.810 00:29:36.710 Awaish Kumar: So now we have all these, order items available.

303 00:29:36.850 00:29:39.689 Awaish Kumar: Via manual export or disable.

304 00:29:39.840 00:29:40.830 Awaish Kumar: And…

305 00:29:41.600 00:29:53.360 Awaish Kumar: for the historical ones, if we… for the… where we don’t have data from Polyta, we will bring it from that historical table. That’s it. So this is the actual modeling piece for the e-commerce.

306 00:29:54.580 00:29:55.200 Nikhil Balasaheb: Okay.

307 00:29:55.830 00:30:00.490 Awaish Kumar: Also, if you want, I can give you access right away for the snowflake.

308 00:30:04.240 00:30:09.069 Awaish Kumar: So you’re good to actually… You are correct.

309 00:30:15.090 00:30:22.469 Awaish Kumar: users… Can I invite you through email? What is your work email?

310 00:30:24.770 00:30:26.880 Nikhil Balasaheb: It’s, yeah, I’m gonna need it from there.

311 00:30:34.990 00:30:36.470 Awaish Kumar: Michael, okay.

312 00:30:37.090 00:30:40.290 Awaish Kumar: I can… Make you a golden admit.

313 00:30:45.420 00:30:51.719 Nikhil Balasaheb: And how do we manage, like, object creation and all that stuff? Is it through UI, or do we have Terraform?

314 00:30:51.720 00:30:58.250 Awaish Kumar: Yeah, we don’t have yet, yeah, but yeah, that’s one piece we also want to work after.

315 00:30:58.720 00:31:01.250 Awaish Kumar: After you ramp up on the client.

316 00:31:01.760 00:31:09.789 Awaish Kumar: We want to use, basically, we want to choose DataForm to actually Do that, object creation.

317 00:31:12.900 00:31:16.190 Awaish Kumar: Mainly for, like, this access control, right?

318 00:31:21.420 00:31:22.380 Awaish Kumar: Aww.

319 00:31:23.580 00:31:29.890 Awaish Kumar: And also, I have another client where I… I’m looking to do the exact same thing right now. We have a…

320 00:31:30.480 00:31:34.770 Awaish Kumar: a client where we use Google BigQuery, Aww.

321 00:31:35.100 00:31:39.530 Awaish Kumar: That’s… And, like, yeah, and then we don’t…

322 00:31:40.770 00:31:45.079 Awaish Kumar: And, like, the access control is being managed in the UI, so…

323 00:31:45.280 00:31:49.369 Awaish Kumar: we might want to also adopt their using Terraform.

324 00:31:53.580 00:31:58.810 Awaish Kumar: Okay, so yeah, you can, like, after you’re done with e-com modeling, like,

325 00:31:58.960 00:32:01.310 Awaish Kumar: We can have a ticket for…

326 00:32:01.630 00:32:08.539 Awaish Kumar: For that, for this client, and if everything looks good, we can apply the same logic on other clients as well.

327 00:32:09.680 00:32:10.610 Awaish Kumar: Okay.

328 00:32:13.710 00:32:16.829 Awaish Kumar: Okay, is there anything else you want to ask, or anything?

329 00:32:16.990 00:32:19.879 Nikhil Balasaheb: Do you have any daily stand-up or anything for this client?

330 00:32:21.310 00:32:30.279 Awaish Kumar: We don’t have a daily stand-up, but we do have a stand-up, like, it’s twice a week, which is, like, between broad team.

331 00:32:31.840 00:32:41.299 Awaish Kumar: to, like, the client team, and I think they will add you to the stand-up. So we don’t have today, but they will add you on the stand-up.

332 00:32:41.430 00:32:42.390 Awaish Kumar: for that.

333 00:32:42.800 00:32:48.550 Awaish Kumar: And apart from that… And for the client, we also have client meetings, but

334 00:32:49.480 00:32:51.190 Awaish Kumar: I’m not sure, like,

335 00:32:51.830 00:32:58.170 Awaish Kumar: Like, the CSO team has a lot of meetings with the client for the, like, client management.

336 00:32:58.760 00:33:04.010 Awaish Kumar: But we are not involved in all of the… all of those meetings. We might be invited in…

337 00:33:04.150 00:33:07.050 Awaish Kumar: In some stated update meetings, or something like that.

338 00:33:07.460 00:33:10.939 Nikhil Balasaheb: Okay, and this stand-up, at what time they are, usually?

339 00:33:11.750 00:33:14.399 Awaish Kumar: Like, I don’t know, it’s…

340 00:33:15.010 00:33:19.110 Awaish Kumar: I don’t know where I know, but it’s like… Excellent.

341 00:33:19.270 00:33:24.680 Awaish Kumar: Round, 2… 2.30 p.m. EST.

342 00:33:25.000 00:33:34.710 Nikhil Balasaheb: Okay, okay, sounds good. Because, you know, like, my local time, 5 to 4.30 to 7, and that’s, like, 11.30 to 2.

343 00:33:34.850 00:33:35.929 Nikhil Balasaheb: Eastern time?

344 00:33:36.240 00:33:42.189 Nikhil Balasaheb: I need to step out, you know, like, I need to pick my wife and all that stuff. I can put the blocker…

345 00:33:42.670 00:33:51.070 Nikhil Balasaheb: On that one, if that works. Other than that, like, I will be available whole my morning, afternoon, and late evening as well, you know?

346 00:33:51.430 00:33:53.910 Awaish Kumar: Okay, what time you will be…

347 00:33:54.800 00:33:58.540 Awaish Kumar: available, for example, what time you’re overlapping with EST.

348 00:34:00.270 00:34:03.669 Nikhil Balasaheb: EST, I can do 8 to 11.30.

349 00:34:04.960 00:34:06.550 Awaish Kumar: 8pm to 11.30.

350 00:34:06.550 00:34:09.969 Nikhil Balasaheb: 8 a.m. to 11.30am?

351 00:34:10.170 00:34:12.090 Awaish Kumar: Okay, the Eastern time, okay.

352 00:34:12.380 00:34:23.800 Nikhil Balasaheb: Yeah, and then, 11.30 to 2, you know, like, I need to step out, I will be away from keyboard, and then 2PM to, like, whenever, like, needed, you know, no issue.

353 00:34:25.310 00:34:28.730 Nikhil Balasaheb: And also, before 8 AM also, like, that…

354 00:34:29.150 00:34:33.380 Nikhil Balasaheb: that’s afternoon for me, I will be starting my day before that, you know, so…

355 00:34:35.190 00:34:41.800 Nikhil Balasaheb: Like, you can consider my whole day, like, whatever needed. Just, like, 2 hours, I will be stepping out.

356 00:34:45.620 00:34:50.310 Awaish Kumar: Okay, I think it’s fine as long as you are…

357 00:34:51.139 00:34:59.639 Awaish Kumar: like, keeping up with your communication with your team members. Like, I might… I might be meeting with you maybe once… once a day, or maybe…

358 00:35:00.230 00:35:06.060 Awaish Kumar: Even, like, once we have the… all the tickets, you know everything you might not need, like, my…

359 00:35:06.350 00:35:11.359 Awaish Kumar: Like, me, at every place. But then you have to… but you will need, like, analyst teams.

360 00:35:11.540 00:35:17.360 Awaish Kumar: And the collaboration, because they will ask you questions regarding modeling, dbt, And we just have to…

361 00:35:17.760 00:35:20.810 Awaish Kumar: answer. Maybe in Slack, but just have to answer.

362 00:35:20.810 00:35:22.430 Nikhil Balasaheb: Sorry, who, who did you say?

363 00:35:22.950 00:35:24.519 Awaish Kumar: The analyst team, the…

364 00:35:25.000 00:35:39.629 Nikhil Balasaheb: Okay, yeah. Okay. No worries, yeah, put the, away from keyboard on my calendar, so it will be visible for everyone, and then my working hours as well. So, what time do you, usually work, like, in EST?

365 00:35:39.840 00:35:43.809 Awaish Kumar: It’s… for me, it’s the same, like, I work,

366 00:35:45.470 00:35:51.930 Awaish Kumar: Eastern, like, full-time in the USD zone, but then, yeah, sometime in the mornings, but yeah, it’s…

367 00:35:53.520 00:35:56.200 Awaish Kumar: So, kind of, I’m also available.

368 00:35:56.450 00:35:57.590 Awaish Kumar: all day.

369 00:35:58.050 00:36:03.850 Awaish Kumar: But main hours that I’m working is I’m just aligning myself with Eastern Time Zone, because…

370 00:36:03.990 00:36:06.350 Awaish Kumar: It’s really hard right now.

371 00:36:07.840 00:36:08.390 Nikhil Balasaheb: -

372 00:36:08.770 00:36:16.249 Awaish Kumar: To manage without being active, because, like, everybody, most majority of our team is in the US.

373 00:36:16.580 00:36:20.900 Awaish Kumar: And, like, you get all the pings, in that time frame.

374 00:36:21.460 00:36:24.359 Awaish Kumar: I noticed. And if…

375 00:36:24.540 00:36:34.909 Awaish Kumar: And if I reply in the morning, then they will reply again on the next day, and then, like, it’ll just be one day of delay without doing anything. Just answering a simple question.

376 00:36:36.180 00:36:45.670 Nikhil Balasaheb: No, it’s like, late night is fine for me, you know, that’s not an issue, so I can stay on it, just like this evening time, you know, like, 2 hours, so that’s crucial.

377 00:36:45.670 00:36:55.049 Awaish Kumar: Yeah, that’s fine, that’s fine. As I mentioned, as long as you are answering the questions, maybe, like, your team members know, like, you are answering…

378 00:36:55.950 00:37:00.169 Awaish Kumar: Before 30, you’re answering after 2 AM, like, if, like, in the…

379 00:37:00.630 00:37:06.719 Awaish Kumar: With the team, you are… you are, like, embedded in, and you’re answering their questions, and…

380 00:37:07.070 00:37:14.889 Awaish Kumar: and carries, and that’s it, right? We have to just manage our… how we…

381 00:37:15.000 00:37:21.979 Awaish Kumar: keep our relationship with the team, but that’s all is needed, because it’s just like, you have… we have to deliver some work, that’s all.

382 00:37:23.760 00:37:33.960 Awaish Kumar: Apart from that, it’s flexible, right? As long as you are delivering the work, and you are showcasing to the team that, okay, this is done, how is… this is how you can use it.

383 00:37:34.240 00:37:35.780 Awaish Kumar: So, yeah, that’s all.

384 00:37:36.750 00:37:38.399 Nikhil Balasaheb: Yeah, yeah, definitely, yeah.

385 00:37:39.410 00:37:49.599 Nikhil Balasaheb: So, what will be my, objective for this, first, week, you know? Like, what are we trying to, deliver, so that, like.

386 00:37:49.710 00:37:50.230 Nikhil Balasaheb: Black.

387 00:37:50.420 00:37:53.279 Awaish Kumar: How do you ramp up on this client? This is the only…

388 00:37:53.970 00:37:56.860 Awaish Kumar: Only client that you will be assigned this week.

389 00:37:57.590 00:38:00.900 Awaish Kumar: After that, we might get, like, involved in more clients.

390 00:38:01.460 00:38:09.169 Awaish Kumar: But for this week, the objective is that you’ll learn as much as for this client, start, like, creating PRs.

391 00:38:10.520 00:38:15.210 Awaish Kumar: So the eco bottling is a big, big chunk, like, maybe, for example, I have…

392 00:38:15.460 00:38:20.160 Awaish Kumar: I create a small… I have a ticket for… a very small ticket.

393 00:38:20.310 00:38:28.060 Awaish Kumar: And then maybe I expect you to, like, start creating the…

394 00:38:29.450 00:38:42.390 Awaish Kumar: tickets, like, the PRs and everything, that’s all. So, I… maybe even if we are not done with, like, fully econ polling and the validation, because using AI, obviously, you can

395 00:38:42.480 00:38:50.730 Awaish Kumar: you can create all those models in a few hours, but the main thing is only the QA part, where you review and actually make sure that

396 00:38:51.210 00:38:57.460 Awaish Kumar: That the modeling that is done is correct, and it has all the data, and there’s nothing… no missing pieces.

397 00:38:57.920 00:38:58.910 Awaish Kumar: So…

398 00:38:59.080 00:39:12.360 Awaish Kumar: That might still take some time, but for the small task, maybe you… okay, I’m… in this week, if you are able to create at least one or two peers, and you understand the full flow of the client and their data systems and things, that’s all.

399 00:39:13.230 00:39:14.439 Nikhil Balasaheb: Yep, that’s awesome.

400 00:39:15.380 00:39:22.810 Awaish Kumar: Yeah, one more thing. Also, like, if you… you’re already familiar with Terraform, so yeah, that is one ticket we can also work on this week.

401 00:39:23.380 00:39:25.439 Nikhil Balasaheb: Yep, sounds good, sounds good.

402 00:39:28.400 00:39:33.330 Awaish Kumar: Apart from that, if you have any questions, just let me know, I’m available on Slack.

403 00:39:33.920 00:39:37.870 Awaish Kumar: And, yeah, good luck.

404 00:39:38.470 00:39:39.020 Nikhil Balasaheb: Yeah.

405 00:39:39.260 00:39:40.589 Nikhil Balasaheb: Thanks, Ms, Osh.

406 00:39:41.400 00:39:42.050 Awaish Kumar: Thank you.

407 00:39:42.630 00:39:43.480 Nikhil Balasaheb: Bless you.

408 00:39:45.310 00:39:45.860 Awaish Kumar: Right.