deleted-U072JS2NHRQ
2024-10-28 14:26:08

Hey @Nicholas McFadden, do you think it'd be a BAD idea to message Cameron and ask him what he uses the most on the dashboard? like which cells does he look at the most, or what he wants out of the dash the most? or should I wait to do that till I have more of it up and running

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-10-28 14:49:56

Let’s build it out as is and then we can talk with him

👍:skin_tone_3: deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2024-10-28 14:50:26

sounds good, thank you! :thehorns::skintone_3:

deleted-U072JS2NHRQ
2024-10-29 13:40:05

Hey @Nicholas McFadden, when you have time, can you come swing by? I finished MOST of the formulas, but I wanna check-in on certain things

deleted-U072JS2NHRQ
2024-10-31 11:19:18

Word document fine for spelling the whole 'fix' out for them?

deleted-U072JS2NHRQ
2024-11-01 14:17:04

So I'll have 600 for your team to do for now 700 are camp lejeune and i'd rather us figure those out cuz camp lejeune is fucked and then the remaining 500 are for the abuse cases, but they have non-flatirons and flatirons mixed into the secondary case type so we'll have to do more steps to get the correct leads for these.

Total of 1800, which ISNT bad

👍 Nicholas McFadden
deleted-U072JS2NHRQ
2024-11-04 15:54:36

Hey @Nicholas McFadden Today's been WILD, but anyways, the Camp Lejeunes we don't have to worry about because we haven't sent any of the complaints to dicello yet because they haven't requested them. The only thing we have left to look at are the abuse cases, which I should have by tomorrow!

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-11-05 11:36:56

Hey let me know when you guys complete the updates so I can pull and run my report today

deleted-U072JS2NHRQ
2024-11-05 11:39:41

Hey Nick I called out today, BUT we should be good with the abuse cases as well, their Secondary Interview - Completed is the same as Secondary Interview - Sent

deleted-U072JS2NHRQ
2024-11-05 11:41:18

So whatever the date is for ‘interview completed’ should be the same date for ‘interview created and verified/sent to firm’ does that make sense?

They use ‘Secondary Interview - Completed’ for when the interview is input into the firms software

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-11-05 11:41:42

Ok thanks

deleted-U072JS2NHRQ
2024-11-05 12:40:17

Lemme know if it looks funky, it should be good but if it doesn’t then lemme know and I’ll investigate more tonight/tomorrow when I’m in

deleted-U072JS2NHRQ
2024-11-06 13:30:07

I'm adding you to the chat where I told everyone what the tab was used for JUST in case

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-11-06 13:49:20

I thought you went and talked with Anthony and team

deleted-U072JS2NHRQ
2024-11-06 14:06:31

I did though! but I guess no one thought that having it in the all tab would send it to all the firms, and then the firms thinking that it being blank would be bad 😭 BUT I found a workaround (at least for the date fields) , I can show you when I see you next, but I'm putting the dates in the "Key Dates" tab in the Lead ID's that we can track out of

deleted-U072JS2NHRQ
2024-11-06 14:07:23

I couldn't put it in specific case types, because the Abuse Case Types will run into the same issues, that tab will send to firms that don't have tracking and they'll be like 'what is this'

deleted-U072JS2NHRQ
2024-11-07 13:07:35

Hey @Nicholas McFadden, is there a way to take the data from a python dataframe and upload it directly into BigQuery? do you happen to know?

deleted-U072JS2NHRQ
2024-11-07 13:09:44

I found a way to accurately get those dates that we have, but instead of pasting them into the google sheet benchmark, wouldn't it be easier if we're able to upload that data into bigquery? that's the end goal, at least.

for now, I can make the code paste into the benchmark google sheet, so that's still working while I'm building the dashboard. but I will need the BigQuery G-Sheets table to pull another tab eventually so that we have the secondary information

deleted-U072JS2NHRQ
2024-11-11 15:14:24

Hey @Nicholas McFadden, when you guys get into the new office, can we connect on this benchmark thing? I had a couple questions to ask you, but it can wait till you're settled into the new office - I'm working on backfilling all the CSP Only fields into the Key Dates for all the flatirons cases rn

deleted-U072JS2NHRQ
2024-11-21 11:01:05

@Nicholas McFadden i found out what's basically stopping me and edward from accessing our gmail accounts through Pythong for scripts. I'm trying to make an 'Intake gets to Final and it creates Secondary' script, but I can't get the gmail authentication up and going, but I think I found how to fix it, I just want you to like show you first before I touch anything lol

👀 Nicholas McFadden
deleted-U072JS2NHRQ
2024-12-05 15:37:30

I'm putting the Contact ID in the Lead ID Vitals, so we'll be able to pull it like any other field, I'm going to go back and retroactively add them all, idk if that'll help you guys but just as a heads up

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-12-05 16:23:09

OK thanks for the heads up. Are you applying this to all campaigns?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2024-12-05 16:23:32

Also, have you notified everyone else?

deleted-U072JS2NHRQ
2024-12-05 16:27:21

Yep! And I let Ward and Anthony know so I think we’re golden, it’s only in the Vitals so they shouldn’t touch it too much

👍 Nicholas McFadden
deleted-U072JS2NHRQ
2024-12-05 16:27:32

As in intake shouldn’t touch it too much

deleted-U072JS2NHRQ
2024-12-17 12:06:10

do you happen to know if we're able to get five9 api information? I know it's way soon, but I wanted to see if I'm able to get the API access to find things.

deleted-U072JS2NHRQ
2025-03-28 10:29:28

If you get any word that the posting is up, can you let me know plz? @Nicholas McFadden I wanna check it out

👍 Nicholas McFadden
deleted-U072JS2NHRQ
2025-04-02 12:12:49

@Nicholas McFadden do you happen to have the job posting for the flatirons position that's being posted or given to Cory/Corey? or do you have contact information for Cory so that I can reach out to them? From my knowledge, they don't post the jobs, they just have the recruiters reach out to individuals, but I haven't seen the job description to know if I want to apply to it.

deleted-U072JS2NHRQ
2025-04-03 14:52:13

@Nicholas McFadden we still meeting up today? if you're busy we can always try for tomorrow

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-03 15:15:32

Hey sorry just gonna run to the restroom and then I’ll grab you

👍:skin_tone_3: deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2025-04-04 07:56:36

Here is my resume, and the paraquat reformatter and auditor as an example of my code

Project Manager - Business Analyst 25.docx
PAQ_reformat_and_audit.py
deleted-U072JS2NHRQ
2025-04-16 10:56:27

@Nicholas McFadden have you heard about anything about the flatirons BA position? with the seating move, it makes it sound like the person/flatirons group is gonna start on monday

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-16 11:21:50

Im interviewing externals this week but I would guess that they won’t start monday tho. Maybe for the other flatiron roles but just had the first BI interview yesterday

deleted-U072JS2NHRQ
2025-04-16 11:23:16

ohhhh gotcha gotcha, do you know when you guys plan to interview internals or if there's even gonna be an interview for internals for the BI position?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-16 11:24:32

I don’t think I need to interview you guys but maybe you’ll need to interview with Cam and Flatirons

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-16 11:24:42

I’ll let yall know

deleted-U072JS2NHRQ
2025-04-16 11:24:52

okay, sounds good, thank you!

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-16 11:26:20

Also if not for that role would you be interested in moving to integrations?

deleted-U072JS2NHRQ
2025-04-16 11:27:11

oh, ABsolutely , 100000000000000000000000%

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-16 11:27:32

👍:skintone3:

deleted-U072JS2NHRQ
2025-04-16 11:27:48

Thank you! i appreciate you helping me out/giving me guidance on all this stuff

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-16 11:27:54

Might need a backfill

deleted-U072JS2NHRQ
2025-04-16 11:28:47

say less, i been gunning for that type of job since i started lol

deleted-U072JS2NHRQ
2025-04-18 12:59:36

@Nicholas McFadden would you possibly be able to send me the code that you use for the hair relaxer authorization documents? I'm going to try and adapt that to the firefighting foam or paraquat ones (i forget which one has the auths) for brittany

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-22 00:26:39

He sorry I missed this, lets get together tomorrow and go over it.

👍:skin_tone_3: deleted-U072JS2NHRQ
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-22 00:27:11

Also, sorry but can you send me your resume again. I can't seem to find it.

deleted-U072JS2NHRQ
2025-04-22 07:55:50

No worries! sounds good! and here's my resume:

Project Manager - Business Analyst 25.docx
deleted-U072JS2NHRQ
2025-04-23 10:40:40

@Nicholas McFadden can we meet up today before the interview today? I wanna bounce a couple things off you

👍 Nicholas McFadden
deleted-U072JS2NHRQ
2025-04-24 13:08:30

sorry @Nicholas McFadden i was in the bathroom but i heard you were looking for me?

deleted-U072JS2NHRQ
2025-04-25 11:50:32

@Nicholas McFadden

Flatirons Responsibilities.docx
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-25 11:50:57

Thank you!

deleted-U072JS2NHRQ
2025-04-25 11:58:33

do you know if the role I would get would be hourly? I need to know more about the role that I'm going into, because I don't know anything about it and things are changing daily. It SEEMS like a glorified customer service rep, but I'd be salary, working 40-50 hours a week, and probably 60-70k/yr which is not something I want. Do you have any more information on it? or can we chat about it if you don't wanna write it all out?

deleted-U072JS2NHRQ
2025-04-29 10:36:35

I need access to your calendar so I can put something on there for later today for the HR documents script, whenever you get a chance, no rush 🙂

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-29 10:40:48

11 or 1:30?

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-04-29 10:40:58

I’ll have to figure out the calendar later

👍:skin_tone_3: deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2025-04-29 10:41:07

11 works fine

deleted-U072JS2NHRQ
2025-05-05 12:50:29

what would be the alleged start date for the role? assuming that the signing and the dollar amount of all of this gets sorted out this week @Nicholas McFadden

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-05-09 10:51:42

Hey you are going to use Cams office for your interview. Just go find Joe, he might be in there

😲 deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2025-05-09 10:52:19

okay, i'll try and find him real quick

deleted-U072JS2NHRQ
2025-05-09 11:00:25

Just to update you, I found joe and I'm heading to Cam's room around 9:20 to get all the stuff set up

deleted-U072JS2NHRQ
2025-05-09 11:54:53

We're golden, it went super good! 😎

deleted-U072JS2NHRQ
2025-05-12 13:21:15

@Nicholas McFadden do we know when I sign anything? or nothing as of yet?

Also, just a heads up, I have to leave today at 12:30 for a dr's appointment - i don't know if I should be letting you know or not, I already let brittany know 🤷‍♂️:skintone3: idk what's going on man, I just work here lol

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-05-12 13:49:57

Hey don't stress, just let it come when it comes. They are on their own schedule but I am sure it all should be fine. In the interim you are still Brittany's employee. I would appreciate your help on things but still run everything by her.

🫡 deleted-U072JS2NHRQ
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-05-12 13:50:49

If there is every any conflict just let me know and we can work something out.

👍:skin_tone_3: deleted-U072JS2NHRQ
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-05-12 13:51:46

I would guess it will be another week before they get you an update

deleted-U072JS2NHRQ
2025-05-12 14:01:31

sounds good and that's not bad, okay! I was just wondering, thanks for a timeline i know it's not 100% set in stone, but knowing some sort of estimate is nice, thank you

deleted-U072JS2NHRQ
2025-05-30 08:04:44

@Nicholas McFadden is this something I'm supposed to accept? I remember an email chain about Dicello and them setting up a Jira ticketing system, is this part of it?

image.png
Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-05-30 09:54:10

Yes

👍:skin_tone_3: deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2025-07-09 13:10:27

hi @Nicholas McFadden am i just dead in the water in regards to this position, or is just flatirons taking months to get back to us about it - if the roles no longer there, that's fine, i'm just curious I just want to kinda know where I am right now cuz i'm in this weird limbo right now

deleted-U072JS2NHRQ
2025-07-09 13:10:40

if it's still in the works, even better and I can wait still I don't mind

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-07-15 06:48:30

I really don’t know. I’ve asked multiple times

Nicholas McFadden (nickmcfadden@shield-legal.com)
2025-07-15 06:49:09

I think it will happen but doesn’t seem to be priority. I’ll have another convo with him when I return