
This is software (AWS) generated transcription and it is not perfect.
So I have done my bachelors of engineering in information technology. So I, um, a B from Mumbai University And then what, like to start with after high school? I was more inclined towards i d. So instead of going to high school and, like, you know, doing 11th and 12th I was like, Okay, let's try the Brahma and, you know, let's get the basics right if I really want to go that way. And I did my three years of diploma and after that you have the second year admission to the decrees and degree colleges in. That's how I was able to get my path in the engineering string once. I think I would definitely say the college played an important role in, you know, morning me and giving me opportunities and, uh, you know, building that competition because I feel like if I wouldn't have pushed myself, uh, I wouldn't have reached this stage. So definitely, uh, Michael, my college was cages home. I am, which is in Mumbai. And, uh so I did my three years off diploma, and then I did my three years of bachelor's degree and I got campus recruited in accent sure. Um, when I got recruited, Nexen. Sure. I was excited that okay, I have a job. And, like, you know, when you're in that Asia, like, Okay, on campus, recruited, you don't have, Do you know, so job and stuff, and you don't have to just wait. Um, but then, um, it was 20 13 and I think they were few. Like my condition's going on where it was not a good year from I t and stuff. So it was good to have a job, at least on Ben when I joined Accent. Sure, I was given. So it's like day providers that Okay, you are. You would be trained on specific clicking, no stream. And I was, uh, lucky enough that I was trained in recipe. So my training, which was three months training waas on SMP basis. So that's just a stream off ASAP. And then what? I did that in Hyderabad. I completed my training, and then I got my first project, which was in Mumbai. So I came back to Mumbai, and, uh, my team was working with Do Bond. So accent sure is a service based company where they have the clients and one of the plant was DuPont's, its chemical and resources client, which was a US based client again, and our team was handling there. Information lifecycle management part off DuPont. So accession was late. Accenture's waas My team. I was responsible for handling all the data archiving related stuff for the point. So I learned so many things there. It was definitely agreed experience to learn. How did not archiving is, you know, takes place at the back end and recipes. They use huge software. And it was definitely a good learning curve there to understand all the modules and to get a hands on experience. So, uh, yeah, I worked there for, like, three years loan so many radios, things. And after a point, I realized that, you know, Okay, now completed almost 1/2 years and Accenture. But if I want to go ahead in my career or, you know, go up the ladder sometime in my career, I definitely have to get out of my comfort zone or push myself to some better things and, you know, kinda short. So you got to do things. Um, So I decided to, you know, take the next crucial step of my career to do the master's degree. Um, my family wanted me to do the massive tick. Yes, and as I'm done with the back politically, but I, for one, wanted to have some experience and some exposure in, you know, in the practical water. So that it I know what's out there, what's out there in the market. And, um, the experience did help gather that. And I knew where I stand and you know what I need to improve. So that was definitely helpful. And, uh, once I, uh, I had to. So it was one thing to decide that. Okay, We need to do a master's degree and another thing to you know, when your international student have to do, like Jr Ito fill all kind of thing, and then you have to manage your job. So yeah, definitely there, Waas. Ah, you know that I was difficult, but I was able to do that. And, um but I was I give my Jerry toefel or kind of thing sent out, admits, and, God admit from university or future where I really like the course. Um, I feel like that the curriculum gate would give me equal. Unfortunately to, uh, you know, focus on the aspect, which I really like, Like data warehousing, data mining, B I So those weather things which I really liked, And I feel like, you know, that's the stream which I should be exploding my career in. So that's why I opted university off Yuta. And then I joined university off. Yura, Um, I completed my masters degree in 1.5 year. And, um um I think in my last time said Mr I in my phone semester I was working as ah ta with the Professor Whitaker. Well, and, uh, I think the entire journey and, uh and he was my mentor again for my captain products. So he's great. Eso hay was so supportive and yeah, he would guide you with whatever problems you have. And he is definitely a great resource, So yeah, I graduated. Meanwhile, in my master's degree, I knew that I just don't meet amasses Dickie. But I also need experience. So because when you come here, I feel like the country where he says 20 It's like, Okay, how much us experience do you have or you know, uh, I did I realize that, you know, having that 1/2 years of accent, your experience was not bad. Beneficial to get another job. Um, And then so I completed. I think I joined my image ized in 2016. The force em It's true. I was rigorously applying for my internships. Um, and then in my second semester, that's, uh, the spring semester, which starts in January. I did not get anything. I do not have a t a r d or anything. And yes, that was definitely Oh, you know. Oh, very low going that you leave your job, you leave your family out there and you come here, and then it's difficult to come and study when you have, you know that. Okay, The end of the month in India used to get us some off, like, you know, some in your account anywhere you get used to it. And then when you come here all of a sudden you're just spending money and you're not earning anything and you're learning and you're just studying and it's it's hard to get back to study after, like that 2.5 years of experience it was it was difficult, but I feel like OK, that is just an investment towards what? What I have in the future. So I was trying to, you know, look at the positive side of her than I kept on just applying. And sometimes it's more off getting, you know, just keep the persistent persistence, help me. So I just would just keep applying for the internships. And, um, I think in the mark in the month of March, I got my spring internship, so there was Ah, Mountain America Credit Union, which is one of the Virgin is here. So I got a marketing data analyst intern position there, and then I joined a Mountain America credit union. I learned it was like I learned how marketing teams work. What are the main things they focus on or how the financial sides off marketing. You know what? The KP eyes in those those scenarios and what data really matter and reporting for them and all kinds of stuff. So I learned I was able to do hands on experience on the tableau and sequel and all kinds off, you know, reporting as well as data analysis software. So, um, I think that was that was my first internship, and then, uh, in the month of June, I was I got another. Unfortunately, which Waas, uh, in Overstock. So this it Overstock is, you know, like Amazon or eBay off Salt Lake City. So it's like a retail company. Me. So I got a data analyst intern there. Um, again, that company was a different domain. So my mantra America was financial domain, and then this was retail domain, so it was like a different domain. But I got to understand that. Okay, how did not data analyst IHS Or, like, data Analytics and B I Things work in different sector. So, um yeah, so that was another good opportunity. And then I did my internship there till August. Um then I came back to India for my, uh, for a month or so for a break, because that was duration. I think we got holiday. So on that time I approached doctor, we grow Teoh, you know, for a research assistant d a position and he was kind enough to offer me one. So I worked with him for around, uh uh, you know, for two months and I hit him with his course data mining, and I was working as a teaching assistant there. So, um yeah, and after that I got another internship opportunity, which was again from a cobia solution. So there's a form here for a political solution who got me as a business intelligence analyst. And so I thought, you know, just browsing or like just having that experience of the I would be definitely beneficial for me. So I did that internship and I graduated in December 2017. Um, for Blake from my December 2017 to my generally 29th I was supposed to wait for having my visa permissions because I was recently graduated and I need to have my E d card to start my job. And, um, I was looking for jobs, and the internship did offer me a full time job. But I for some reason, I wanted to push myself and see what are the fortunate for me out there. And then I was able to get Intermountain Healthcare where I'm today. So it's, uh, healthcare. You can say toe healthcare. Anyone who cares a hospital and they have their research domain. So we have office off research where they do all kinds of clinical trials, and they have research studies. They have government grands on which, like they would do drugs related study. They would dio, um e you know, all all kinds of clinical trials. Basically. So I was I interviewed, and I got an unfortunately toe work better the data analyst. So So on January 29 2018 I joined in the Markham, and it's being, like, 2.5 years now and there. And, um, it's definitely a great company to work for, even for the you know, the current scenario, which is like Kobe, it's and I use There's so much to learn, and our team is consistently working on the stuff to help out clinical trials give data build applications so that we can communicate to the patient remotely. And I think it's It's one thing to do work, and it's another thing to have that satisfaction that okay, you're getting something out off it. So it's like you're giving back to the community, so it feels good to making an impact. Why you are doing what you are doing. So I would suggest the other than you know, um, fortunate enough to that I'm working in a sector where I'm having the opportunity to work and deliver and like making back. So, yeah, that's my journey to the date.
That's a great question. So the like the day to day work? I would say I work on various applications, so my team is responsible for administrating bunch of applications, so we have. So if you go, we work on clinical trial management system, so it's city and mess. Basically, what it does is you can consider or imagine it as an information system off clinical trials. So right from when a person would get enjoyed in a clinical study. So okay, let me explain a bit here. So when you when you think about clinical trials, it's like their research studies going on and people So the hospital coordinators would so say, for instance, you are at the hospital and you wanted to get your, you know, easy g or you're there to see especially Dr. While you're waiting in the lobby, there would be coordinators who would come to you and say that. Okay, we have this research study going on, and, you know, if you participate in this research study, we would Why? You know, your blood draw, you're the lab would take more blood from you, and that would help in the research study. So the department will rise to work is cardiovascular department cardiovascular research. So when people used to wait for their appointments to their doctors, they would wait and then the coordinators would talk to them and be like, OK, are you interested in joining the CV study? And then it's like they won't benefit off it. Anything but the sample, like the blood sample which our team gets there would be research on that they would be. Do you need the Cosmas and all kinds of stuff derived from that blood? And they would do be any sequencing, Gino type being and all kinds off clinical things, which would happen on that data, and that data would be used for the research. That's how research work. So in my day to day life, it's like, OK, we get that data, we get that sample so one part off my job helps to manage the laboratory. So, um, the laboratory information management system, which I administrators progeny so it think of it as a collection off all the examples. So think of it as a software which manages all the dailies, plasmas, puffy coats, all kinds of tubes. So from the time a coordinator would draw the blood to the time it goes to the freezer. All the workflow happens in that software, and I'm supposed to manage it, and I'm supposed to make those workflow. If there's a new study coming in, create that workflow depending on the study protocol, um, to make sure that the data is getting saved. But in the back end of that software correctly, if a research, if a researcher wants the data extracted from the top it, they would know nothing about what's going on in the back in. So it's me who would get that data the way they want it. So be it for any typical poster forbade for any grand submission or read for any, you can stay research like American Heart Association. So they have a new, you know, new studies going on each year and the present. Their studies. They present their results. They they have, like papers, resource papers. So for that they need data, and due to do those resource related analysis, they need data. So I'm the person who would connect them to the laboratory. Um, you know, so to explain better, each individual gets a unique identity fire and each individual would have a profile, right? I mean, they would be diabetic or they would have some disease. So they create Ah, Data said, which has, you know, spent There's a thick criteria, so they would say Okay. And get me a list of patients who got there, you know, cardiovascular related diseases after this date, or they have had their cholesterol level, this and this and they have had these in this procedures. If they have had angioplasty, whatever. So they would give those criteria to me. I'm supposed to quit that software, create the eat it of you and give them those patient data and, you know, held them in analysis. And then they would Sometimes if they're doing a paper, they would let me do analysis on had, you know, a few models and they would see the cases, the controls, and they would help me with the you know, the data will help them understanding the, you know, the amount off. So they're like, OK, this is so for example, these are two types off. So the two types of population how ostensibly thing impacts this worst of this? So it's more off analysis thing. So yeah, so I'm the one who would give them the data. Who would help them with an analysis? That's the laboratory part. And then other part which I work on is, as I mentioned, the clinical trial management system. So that is the you can say end to end connection off entering the data in the system. So clinical trial management system captures everything. So from the time the coordinator would contact the patient, the patient will get drawer in the city and mess the data. So the way it works is there is the EMR system. So that is Elektronik Medical records. So there's a connection between the Syria Miss and EMR. So consider I am to give Ah, you know, very easy to understand. Example I'm a patient. I go to hospital. Ah, coordinated approaches me and say, Is that okay? This is a study. Would you mind or would you be interested in enrolling for that? I would be like Oh, yeah, sure. Why not? And then I would consent that Okay, I give fuel the permission. That okay, I would be willing to and roll. And then once I do that, they would draw my blood. Um, when the drama bled, the thing goes to laboratory. So everything goes to the laboratory information management system. But the second part, too. That operation is that the coordinator is supposed to enter that information that e consent. So healthcare information is very critical. And it's very important the for the patient to get the consent and for the organization to document that that okay, I'm using their data with their consent. And this is the document. This is the consent, which is a provider, and so they need to file it for each patient and city in minutes would let them do that so the coordinators would go back to their desk, open CMS or the clinical trial management system. They would enter that. Okay, they would pull that study. So consider CMS, like city, Miss would have tons of studies for different sets of department oncology, women and newborn cardiovascular research. All kinds off departments would have their studies. Yesterday. They would select their study. They would end rotation. In that study, they would upload all kinds of documentation. Once that is done, they're supposed to keep track off whatever is done on that patients. So we have conflagrations in CTM is where they would be like they would have visit. It's OK, How many times that the patient coming? How many times did we you know, did procedures? Because when it is a research study, they have their own money and they're like, Grant's research grandes who'd be so the patient necessarily. So, for example, the recent study needs the patient to get an X ray. Okay, so they want me to get a next through. I'm not paying from my pocket grade because I'm participating in the resource that either the so study will pay it and be like, OK, you do. The X ray will take care of the charges so that building off what to charge to the patient and what to charge to the you know, the research sponsor is managed in seedy MSO Syria. Mayes gives a control off, you know, building it gives the control off who did? Um so it's like there are so many coordinators reaching up to the like, the patients we need to track. Okay. How many patients are we tracking? How many patients have been enrolled in the study again in a research study. There are so many things where patient may not be always may not always follow a lake, fulfill all the criteria. So if I need a patient to fulfill three criterias, and if it does not fulfill one off it, then he does not get screened. They go screen field. So we need status takes or that data to be gathered in the system where it says Okay, how many? How many of the patients in the study of Screen Field versus how many were screened? And so all that my new level data or like building those system are like building the patient? And worse, is building the research coordinator or like research sponsor? So it's a huge violation if if there's a charge which the study was supposed to pay, and if we charge that to the patient, if the patient sues us, that's a big mishap. So we need to make sure that you know all those configurations are, you know, correctly done for each study and all the data gets tracked in an agent of you in the back. And so I managed all the considerations on the front end right from, you know, doing study configurations, connecting it to the electronic medical records on the back, and, um, and making sure that all data data which they entered is a good data. It's not like bad data are going inside, so we have a couple of validations going on. Um, so that's the main part. And when it comes to edit a blue, I work on creating reports. So I, uh I have sequel Quit is running in background, which would get connected to tableau and which would get refreshed. So, for example, to give the best example, I have a covert dashboard which currently the entire organization is looking at. So, basically, that dashboard is connected to the eat it of doing the back. And, um and that tracks how many covert related clinical trials are going on in tomorrow. How many patients are endured? You know how many antibody test things are going on? Um, what so usually when we get a trial, we have that. Okay. We need to enroll 50 patients 100 patients, 10 patients, eso, you know, how close are we to that target? How are we supposed Teoh reach more patient or you know, in this scenario, in the situation where you cannot necessarily contact a patient face to face. What are the things we can develop where we could, you know, they were remote consent? All those things are managed by my team, and I handled that. Then there's another piece of software which we administer, which is, you can say electronic data capture. So it's called E T V C. In you know, aberration is electronic data capture. So it's called Red Cap. So it's research Elektronik data capture. That's the red cap. So that's basically a database where all the information regarding documentation and eso consider it as a survey oriented database. So it's like, See, we give like, Google forms and you'll get data. So read Camp is for research where you know it's compliant with all the healthcare or all the health care related restrictions. So that's Red Cap. So I administered red camp, and sometimes it's like you have tons of data or tons of studies in director, but you don't have a way to officially handed the data. So I have. I have been involved in projects where I would you use all tricks when I would grab the data from Red Cap, and I would connect that to tableau when I have that life connection going in, where my data, wherever the coordinators entered that data or whenever a patient would take a survey, um, the data would dedicate flow to my tablet dashboard. When I do that, I also sometimes use our script to get the data from Red Cam, because sometimes there's omen data manipulations and, um, data calculations that I feel that it's easy to do in art. So I grabbed the data using our I would create our shiny dashboards, and I would just deployed and stuff, you know, doing caballo dashboard there you dare basis and great caf where you know they would be migrated to different phases. And when we do migrations, it's it's already manual. I would not. I would say it's not that easy to get all the documents from one project one other, so I would use our script to, you know, grab data from or fights from one project, one other. So I just tried to make things easier for my team because they do not know all these things, like our tablets are drinks are sequel. They're not They're more clinical oriented folks, so they know everything, related the medical stuff, which those things are completely Jagan's for me. But I am trying to learn them. So I heard them make their job easier so that if if you know there are 50,000 patients in a study, and if they go on, you know, downloaded from one study uploaded on the study, if there is not a good way that I just read the script and that does the migration and tours if you know that's how I try and help and make their job easy. So, um yeah, so there are some, like, so seediness. Red camp progeny are some major software's between administer, and I use my data analytics. You can see expertise by integrating or creating dashboards, which are used by the high leaderships, like trying quit dashboards for them. I make sure that we don't have Intel Agency your bit update. Um, I make sure that, uh, I have things or scripturally in the background, which makes or like which automates thing. And I try and automate and, you know, make life easier for them. So yeah, and did I miss any part of the question. Ah, week level cards, Time spent on travel and looking. Yeah. Um, so weekly. It's like 40 hours a week of which I work. So the my officers not that far away from my home, So usually it would take me around, like, 15 20 minutes. Um, I I'm still trying to re part off. You know, I'm still trying to meet in my Indian habits off trying to go by public transport are not buying a car yet. I feel like Okay, let's contribution to the pollution. Whatever. I know that doesn't impact more, but I feel that it's close by, and I I still travel by public transport, and it doesn't take me more than 20 minutes to reach there on. I feel like I walk like after getting down from the public transport, so it helps me and get my step count. So yeah, so, for travel, I would say it doesn't take me more than 30 to 40 minutes to reach there. I go to two offices. One is the Marais office. And when is the eldest hospital which is in the downtown? So the downtown once takes me a bit eso it takes me 45 to 15 minutes one way. So if I'm going to that office, it takes me a while. Um, but yeah, but if I leave my home around like a 30 are reached their body like nice 9 30 in and I have 9 30 to 5. And I think what work wise, the people here I work with, they're there to kind enough that they are just They do not like. They know that I you know, I do my job. So they're not like, Oh, no, you have to come here like a night and you cannot go by like until it's five. It's not that thing about If you're getting your work done, then there's no, like, hard and fast rule that okay, you have to, like time in late clock in and clock out. It's not like that. It's more like, Okay, Even if you're coming at my authority, how fast are you getting a job done and biggest. It's like I don't think Andre Ricks People here usually go out. They would have learned they would take an are off like lunch break. I don't take that. I just eat mileage on my desk. So I think I kind of compensate there. So, um so, yeah, I just leave at five and it's pretty fit, flexible. And if there's something which I know that it's supposed to be delivered tomorrow, then I make sure that even after coming home, I have it done. Like if I'm getting pulled into some other work while I'm working today. And if I know there's something do tomorrow, I make sure after coming home that it's done so that I'm not, you know, late for my deliverables. So it's more so. I would definitely say there is some kind off flexibility there, but I don't know, you know, take undue advantage of that, then, Uh, yeah, it's 40 ours, and I would say sometimes to do to, especially in the current scenario where we have so many clinical going me and being. Sometimes I enter pioneers they. But since we are stuck at home, I thought, Why not work and, you know, use the ours when I probably need them, So they give the flexibility to, uh, you know, the work on the PTO and bang that ours and use them later. So that way it Z. I think fertility definitely helps me to put in more. So I feel like if I would have been restricted and to like, Okay, you have to come at night and leave at five. I would not have worked after coming home. But now that I have the flexibility that OK, you know, we just need the job done. I feel like it's my duty to do it no matter when. So even if I'm coming home and if I have something I am supposed to deliver that so young daughters, that's that's how I think it's eight hours a day. So that's how my week, uh, weekly eyes are.
I mentioned this before, but yet to under it precisely the main Softwares which we currently administered. Like where the administrator is the research electronic data captured. That is, right, cap, which is more for Elektronik data capture or, like electronics online data. As you can. Think off the another TULIS clinical trial management system, which is CMAs. Um, the other software which I work more on is sequel developer because, you know, I am responsible for every house for city and mass as well as the normal data warehouse. So it's like the Intermountain has There you are their house, and they're and we have this information system like clinical trial management system. We have a date of the person things to, uh, you know, use both the date of the houses, um, do queries and, you know, dude extractions. And I think, yeah, to put through the adult requests. So, to the funny part is, I also use access database, which is I know it's very rare nowadays for the organizations to use access Microsoft Access Service, but are so are DNE. Labs like CBD in the lab, which uses the laboratory information management system has more than 30,000. The an example. So it's like we have they feel for more than 30,000 folks. And that data was so that's the legacy data captured since 19. So we have huge data, and that time we did not have, like, this laboratory information management system, which is like progeny. We did not have that. So they they startle grabbing that data electronically in access to cater. So all the legs steely, all the legacy samples and all the legacy data is an access database. So whenever I have Teoh, you know quickly something legacy data related things or some patient, which is to old, I sometimes use access. So that's another where I used to help me and to deploy them on tablets over and giving folks access to it. So I definitely just have no more to do all kind off reporting, um, to connect the data from my all kinds of different leaders. Stores are like all the data sources to my tableau. Um, I sometimes use our script like our programming, Um, or sometimes they use all tricks which acted the mediator from my data source to my dashboard. Or sometimes it's all tricks I use just for automating something. So, for example, there is a report to give destroy example. There's this email report which goes on a weekly basis, where one of my colleagues, she goes into the city and mess and exports excuse exports. The data from CMS and, um she makes you want manipulation. So in order to make her job easier, I have created all tricks were which would grab the data from that stadium is and do that which would do medications in all tricks and which word just trigger out emails off, like with that data as an attachment to a couple of folks. Um, so that way and we can schedule that work from If you have use all tricks, he would know that there's a way to schedule the workforce so have scheduled it to run on Janet like 6 a.m. daily. So that would grab the data, do the manipulation just reading that email to all the folks who needed. So we are. All tricks is used where when I need to connect to Softwares of data source on a dashboard or I need to do any automation or data manipulation, it's really up to me. If I'd prefer our or great, I just use whichever I feel like I would be more efficient. So yeah, apart from that, um, I think that that's all, I think. Yeah. And normal. Like Excel files, like, you know, doing analysis, Excel reporting. There there are fuel Excel reports, which are still, you know, people still like Exelon. They don't cry like complicated or like, fancy dashboards like tableaus. So for doors, Yeah, there are few excelled reports, which I are excellent macros and manipulations going on on Excel files, which I still do. So, yeah, I think that that would cover all the Softwares and towards which every year