Ahsan (ahsan@shield-legal.com)
2024-07-15 12:06:53

Hey Aidan, qq. Have you been able to get pg admin to connect yet?

deleted-U072JS2NHRQ
2024-07-15 12:14:54

Hey, yeah I'm able to connect to it

deleted-U072JS2NHRQ
2024-07-15 12:15:12

sorry for late response i didn't realize you messaged

Ahsan (ahsan@shield-legal.com)
2024-07-15 12:15:52

I am having a bit of an issue connecting, mind if I pop over to your desk to see how you connected it?

deleted-U072JS2NHRQ
2024-07-15 12:16:11

yeah come on over! do you know where i sit

deleted-U072JS2NHRQ
2024-07-15 12:20:05

This might help a little bit:

image.png
deleted-U072JS2NHRQ
2024-07-15 12:21:42

that's how Ryan gave me the login info, so the big long scribbled out thing was the password, but you only have to fill out: Host name/address - which is the long hyperlink lookin thing Port is port and maintenance database is tip_master username is dbmasteruser

I THINK that's how they're supposed to be logged in

Ahsan (ahsan@shield-legal.com)
2024-07-15 12:22:39

Where do you sit?

deleted-U072JS2NHRQ
2024-07-15 12:23:33

Do you know where Brittany Barnett sits? I sit like near Nick McFadden, but in the corner opposite of the white board

deleted-U072JS2NHRQ
2024-11-08 15:29:16
image.png
👍:skin_tone_4: Ahsan
deleted-U072JS2NHRQ
2024-11-08 15:29:40

https://www.loopnet.com/Listing/5170-Badura-Ave-Las-Vegas-NV/33111465/

LoopNet
5170 Badura Ave, Las Vegas, NV 89118 | LoopNet
5170 Badura Ave, Las Vegas, NV 89118. This space can be viewed on LoopNet. Las Vegas Digital Exchange Campus, located off of I-215, is
Original URL: https://www.loopnet.com/Listing/5170-Badura-Ave-Las-Vegas-NV/33111465/
deleted-U072JS2NHRQ
2024-12-20 13:30:35

So EVEN IF my script was running overnight, I should be fine, right?

I can't remember if I ran the script that finished this morning when I came in this morning, or if I ran it prior to leaving yesterday and it ran overnight?

Ahsan (ahsan@shield-legal.com)
2024-12-20 13:33:26

de[ends on the amount of data but I think you should be fine. if LR breaks from a simple pull like this their system is trash and you are being scapegoated imo

Ahsan (ahsan@shield-legal.com)
2024-12-20 13:33:37

why what are they saying now?

deleted-U072JS2NHRQ
2024-12-20 13:35:54

nothing, I'm just having to put together a list of what I did this week and what scripts I ran and I can't remember if I ran the script for all these leads today, or if I started it yesterday prior to leaving so that it'd run outside of business hours.

but yeah, the thing is that I 100% feel like I'm being scapegoated cuz too many things don't make sense and aren't matching up. so when making this list of what endpoints, scripts, etc that I ran throughout the week I want to put all this info in there

Ahsan (ahsan@shield-legal.com)
2024-12-20 13:42:20

Hmmm yes that sounds weird. Be careful. It would not surprise me if they want to pin this on someone and not put it back on L:R

deleted-U072JS2NHRQ
2024-12-20 13:55:07

yeah, I'm trying to write all the inconsistencies in the 'what scripts did I run' document I'm putting together

deleted-U072JS2NHRQ
2025-01-03 12:28:19

can you run me through how you're planning on doing the bigquery tables when you get a chance? like are you planning on making different tables for each campaign/casetype?

deleted-U072JS2NHRQ
2025-02-13 13:55:56

that nosy pudgy flat headed fuck

deleted-U072JS2NHRQ
2025-02-13 13:56:22

if he causes trouble for me for giving you access i'm slashing his tires

deleted-U072JS2NHRQ
2025-02-13 13:56:29

i don't trust him

Ahsan (ahsan@shield-legal.com)
2025-02-13 13:56:44

Yea he likes to gate keep permissions

deleted-U072JS2NHRQ
2025-02-13 13:57:22

yeah which makes no sense, stopping you from doing your job so that he can take the credit lol

Ahsan (ahsan@shield-legal.com)
2025-02-13 13:58:45

Yea I just keep my head down and survive, tenure and title help when trying to find a new place

deleted-U072JS2NHRQ
2025-02-13 14:05:33

yep, same, hoping for his demise

Ahsan (ahsan@shield-legal.com)
2025-02-13 14:05:54

Did they finally change your title?

deleted-U072JS2NHRQ
2025-02-13 14:06:39

yeah, but they changed it to "Account Data Specialist" lol which is kind of in-line with what they want to pay me

deleted-U072JS2NHRQ
2025-02-13 14:06:52

shelly said the title determines the pay from the national title database or some shit

Ahsan (ahsan@shield-legal.com)
2025-02-13 14:07:28

She used the dunbar db? yea they shafted you hard. That DB is always a few years behind with market titles and pay

deleted-U072JS2NHRQ
2025-02-13 14:07:51

yeah, well thats our HR department lol just useless through and through

deleted-U072JS2NHRQ
2025-02-13 14:08:30

i can't wait to get out of here, but i want to learn more before I look for another job or else I can't fake it till i make it lol i need more knowledge about db administration and other things first, so i'm just biding my time and taking courses till then

Ahsan (ahsan@shield-legal.com)
2025-02-13 14:11:41

If you like the GCP stack, look into google certs for admin. Admin make 100k+

deleted-U072JS2NHRQ
2025-02-13 14:18:03

i kinda hate the gcp stack honestly, i'm more well-versed in the microsoft stuff, which is why i'm trying to just gather knowledge about this shit while im here to add it to resume and stuff

Ahsan (ahsan@shield-legal.com)
2025-02-13 14:48:57

It translate well enough. Both stacks are fairly disjointed so same miseries for the most part.

Ahsan (ahsan@shield-legal.com)
2025-02-20 16:36:55

Darryl pulled through and got us the all leads piped into DLs system. They create a record for a single doc or source. So a lead can have 5 records. We will need to maybe reconcile this first and then compare to our own DB. Darryl says he gave this hit to Dustin already so we can check against Dustins count to make sure we are not too far off base.

DiCello Levitt Master Client List .csv
👍:skin_tone_3: deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2025-03-04 10:57:01

Just in case, all the columns we need are: Account Name Case type Email Mailing St DOB Phone Email LawRuler Lead DL Case ID

deleted-U072JS2NHRQ
2025-03-20 11:56:59

@Ahsan the medical records update excel sheet you shared is blank

deleted-U072JS2NHRQ
2025-03-20 11:57:03

just a heads up

Ahsan (ahsan@shield-legal.com)
2025-03-20 12:01:13

hmmm looking into it

deleted-U072JS2NHRQ
2025-03-20 12:01:35

ok, thank you!

deleted-U072JS2NHRQ
2025-03-26 15:03:04

i literally forgot everything you told me except for subqueries being bad for readability

deleted-U072JS2NHRQ
2025-03-26 15:03:41

what did you say again? the goal is to get the lead id of the intake and the lead id of the secondary on the same table, but I can't figure out how to do that without making like a whole view specifically for intakes, and one specifically for secondaries

Ahsan (ahsan@shield-legal.com)
2025-03-26 15:29:33

I would write the write like this :

contact id, casetype name, case type num, pii.....
from table xxxx
Ahsan (ahsan@shield-legal.com)
2025-03-26 15:31:15

you may need to do a left join so join a is the table with contact id and either case type number or case name

deleted-U072JS2NHRQ
2025-03-26 15:32:56

oh I was able to do it, I didn't know I could re-join the same table again with a different alias and use it to get the secondaries that way

Ahsan (ahsan@shield-legal.com)
2025-03-26 15:35:48

yea self joins are a common workaround

Ahsan (ahsan@shield-legal.com)
2025-03-26 15:36:03

or making it as a cte to rejoin on, self join would be more for a subquery

deleted-U072JS2NHRQ
2025-03-26 15:39:06

ohhhh, gotcha gotcha, thank you!

deleted-U072JS2NHRQ
2025-03-27 11:33:27

so dustins code isn't pulling everything into bigquery like it should

deleted-U072JS2NHRQ
2025-03-27 11:33:56

there's something that's in bigquery as Signed e-Sign IN PROCESS and in LawRuler it hasn't been in IN PROCESS status since the 7th

Ahsan (ahsan@shield-legal.com)
2025-03-27 11:53:48

hmmm that is weird. I dont have access to the code that does the dump to BQ. But maybe raise the issue in #C087F02FKRU and tag him with Brittney. This gets people actually using the channel and gets visibility its not reporting

👍:skin_tone_3: deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2025-04-02 12:21:43

@Ahsan who would I reach out to in order to hard code more of these flatirons matches? you or dustin?

Ahsan (ahsan@shield-legal.com)
2025-04-02 12:28:32

Either

👍:skin_tone_3: deleted-U072JS2NHRQ
Ahsan (ahsan@shield-legal.com)
2025-04-02 12:28:49

Be at the office by 11, been battling the morning

😂 deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2025-04-02 15:34:25

i got the job description for the business intelligence analyst job

🚀 Ahsan
deleted-U072JS2NHRQ
2025-04-02 15:38:46

so this is the job description but i thought cam didn't like analyst? lol that's confusing

image.png
Ahsan (ahsan@shield-legal.com)
2025-04-02 15:39:35

When they hired for engineering they called the role as a senior engineer, No one got the senior title

Ahsan (ahsan@shield-legal.com)
2025-04-02 15:40:25

It may just be a fake out. James was suppose to get a title change when he moved to the tip side, they did not change his title and essentially shafted him

deleted-U072JS2NHRQ
2025-04-02 15:41:57

ahhhh gotcha, gotcha yeah they might just be giving it to the recruiter like that and then giving them a different title once they're in there, which is fucked

Ahsan (ahsan@shield-legal.com)
2025-04-02 15:42:23

Yea probably

deleted-U072JS2NHRQ
2025-04-02 15:42:38

the only thing I don't know about the job is the pay

deleted-U072JS2NHRQ
2025-04-02 15:42:58

I know you were the one that was going to be this position, did they ever share with you what the pay range would be?

Ahsan (ahsan@shield-legal.com)
2025-04-02 15:45:52

No I wasnt to be in the role but just do it in the interim, probably low 30 - 40 on the high end

Ahsan (ahsan@shield-legal.com)
2025-04-02 18:04:17

Check Corey website. The flatirons ba job was posted there with a range of 110-130

deleted-U072JS2NHRQ
2025-04-03 07:56:54

Is it this one?

deleted-U072JS2NHRQ
2025-04-03 07:57:09
IMG_3668
Ahsan (ahsan@shield-legal.com)
2025-04-03 09:20:00

Yup

👍:skin_tone_3: deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2025-04-03 10:38:15

what was the program you were saying at UNLV that's 10 months? what's it called again?

Ahsan (ahsan@shield-legal.com)
2025-04-03 10:41:05

Business analyst

Ahsan (ahsan@shield-legal.com)
2025-04-03 10:41:40

https://continuingeducation.unlv.edu/business-analytics

continuingeducation.unlv.edu
Online Business Analytics Science Certificate Program | UNLV Continuing Education
Become a business analyst — master essential skills in just 10 weeks through the online Business Analytics certificate offered by UNLV Continuing Education, in collaboration with Ziplines Education.
Original URL: https://continuingeducation.unlv.edu/business-analytics
Ahsan (ahsan@shield-legal.com)
2025-04-03 12:52:11
config.json
👍:skin_tone_3: deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2025-04-07 12:56:47

im checking jp's report now

deleted-U072JS2NHRQ
2025-04-07 13:03:06

do you run financials every day or just on Mondays @Ahsan?

Ahsan (ahsan@shield-legal.com)
2025-04-07 13:04:11

everyday

👍:skin_tone_3: deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2025-04-07 13:13:08

@Ahsan so it's missing the Valifornia Juvenile Hall Abuse tab in the new medical record tracker

deleted-U072JS2NHRQ
2025-04-07 13:13:12

California**

Ahsan (ahsan@shield-legal.com)
2025-04-07 13:14:10

Ahh I see, also noticed NJ juv did not have week numbers. I will mkae the NJ fix and check the ca juv stuff and re run the report.

👍:skin_tone_3: deleted-U072JS2NHRQ
Ahsan (ahsan@shield-legal.com)
2025-04-07 13:26:50

yea it was an issue for the financials template. Everything is good now.

deleted-U072JS2NHRQ
2025-04-07 16:13:20

what's the name of the 'Title Database' thing that we were talking about before with Shellie and the titles?

Ahsan (ahsan@shield-legal.com)
2025-04-07 16:28:49

naics table

👍:skin_tone_3: deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2025-04-14 13:59:05

did you drop the news yet

deleted-U072JS2NHRQ
2025-04-14 13:59:17

i saw him over near Alicia's old desk on the phone talking about stuff earlier

Ahsan (ahsan@shield-legal.com)
2025-04-14 14:02:01

yea but I think the call was for other stuff. Told them I am likely moving to cali so I could casually wfh and or burn pto to push my employment dates into march. Also gave them the option to stay on as a contractor

deleted-U072JS2NHRQ
2025-04-14 14:02:38

whatd he say

Ahsan (ahsan@shield-legal.com)
2025-04-14 14:02:57

pretty much put it on cam to make a decision and he is usually slow, going to casually mention to start bringing you/esteban/edward in for FL stuff incase cam says no. This should be alot of back and forth for like a month maybe

Ahsan (ahsan@shield-legal.com)
2025-04-14 14:03:36

This also lets them see how you guys would fit in the cave so they dont have to do an outside hires/ lose tribal knowledge on this shit

deleted-U072JS2NHRQ
2025-04-14 14:04:01

yeah, but i kinda like my cubicle lol

deleted-U072JS2NHRQ
2025-04-14 14:04:05

the cave smells funky

Ahsan (ahsan@shield-legal.com)
2025-04-14 14:04:25

with david quitting friday, jackson likely will go back to sobo, 2 of you guys come to the cave so ward gets happy brittney's team loses head count

Ahsan (ahsan@shield-legal.com)
2025-04-14 14:05:08

the fighting will be over edward but the fl stuff can be a dash board that mcfadden sounds down with so I know I at least can make a hard push for you.

Ahsan (ahsan@shield-legal.com)
2025-04-14 14:06:06

it smells because dustin's diabetes causing him to smell a bit due to the insulation pump, as long as you have 2 feet you dont smell it unless your senses are wolverine like

deleted-U072JS2NHRQ
2025-04-14 14:26:23

Kessler is quitting?!

deleted-U072JS2NHRQ
2025-04-14 14:27:27

And well, looks like I’m going to bring some cologne to spray in Dustin’s no chinned lopsided face

Ahsan (ahsan@shield-legal.com)
2025-04-14 14:30:58

Kessler already quit last friday

deleted-U072JS2NHRQ
2025-04-14 14:31:08

oh shit, yeah i didn't notice that

deleted-U072JS2NHRQ
2025-04-14 14:31:09

that's WILD

deleted-U072JS2NHRQ
2025-04-14 14:31:21

i mean he was the only thing holding the intake side together basically lol

Ahsan (ahsan@shield-legal.com)
2025-04-14 15:03:55

at least the dialer side

deleted-U072JS2NHRQ
2025-04-22 12:01:36

@Ahsan do any of your guys scripts use this :

image.png
deleted-U072JS2NHRQ
2025-04-22 12:01:41

it's in the flatirons benchmark

Ahsan (ahsan@shield-legal.com)
2025-04-22 12:41:53

this is our config that does the match for casetype

config.json
👍:skin_tone_3: deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2025-04-22 12:42:10

perfect, thank you!

deleted-U072JS2NHRQ
2025-04-23 12:45:44

how do we get JP to send the childrens profile for NEC?

deleted-U072JS2NHRQ
2025-04-23 12:45:49

do we just email him?

deleted-U072JS2NHRQ
2025-04-23 12:45:52

yall email him?

Ahsan (ahsan@shield-legal.com)
2025-04-23 12:46:35

We have darryl update stuff in dl system and then it appears in the next run I think

deleted-U072JS2NHRQ
2025-04-23 12:47:58

so basically, the parents NEC accounts are still being sent in JP's medical records, we need the childrens records to match them to, or we end up with 2-3 duplicates

Ahsan (ahsan@shield-legal.com)
2025-04-23 12:49:08

Hmmm, probably ping darryl in the fl channel and ask him to tell this to JP or have brittney/mcfadden send the email. IDK how JP is pulling the report but I know he is not pulling from salesforce directly

👍:skin_tone_3: deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2025-04-23 16:25:54

I have a question, didn't brittany put some other cases in the flatirons? I feel like she put Paraquat LegaFi DL Flatirons, Paraquat DL ML, and some other random case type in the benchmark report, right? I'm re-creating the benchmark report with 3 new case types but I feel like she added 3 other cases to it but i forget

Ahsan (ahsan@shield-legal.com)
2025-04-23 16:32:50

I think so, the code splits the benchmark into a meadow, legafi, flatirons

deleted-U072JS2NHRQ
2025-04-23 16:44:41

oh gotcha, i found all 3 of them and added them, we're golden now, thank you!

👍:skin_tone_4: Ahsan
deleted-U072JS2NHRQ
2025-04-25 11:20:19

@Ahsan lemme know when you can show me how to run the Flatirons code that edward runs cuz i'll probably have to end up doing it if I get this job since Edward turned down the job

Ahsan (ahsan@shield-legal.com)
2025-04-25 11:25:49

Yea I can show you next week. I will probably call out Monday but for sure Tuesday. It shouldn’t take 10 minutes to give you the walk through

Ahsan (ahsan@shield-legal.com)
2025-04-25 11:26:09

In the middle of documenting each block.

deleted-U072JS2NHRQ
2025-04-25 11:30:31

oh ok, actually nevermind, edward did take the job so he's going to be the one doing it

Ahsan (ahsan@shield-legal.com)
2025-04-25 11:37:07

I will still give you the run through so you understand how the code base works especially if you are the one that has to end up updating the config file for hard code matching

deleted-U072JS2NHRQ
2025-04-25 11:37:23

okay deal, that sounds good 🫡 thank you!

Ahsan (ahsan@shield-legal.com)
2025-04-25 11:43:43

Np, I imagine they will split the workload of flatirons eventually on you and Edward.

deleted-U072JS2NHRQ
2025-04-25 12:01:18

I mean he’s getting paid more so he’s gonna do more of it lol

Ahsan (ahsan@shield-legal.com)
2025-04-25 12:03:01

Yea but we are slowly automating it. So ideally to only manual input is the hard matching, and validating the financials

deleted-U072JS2NHRQ
2025-04-25 12:04:13

yeah, i doubt I'm gonna take it though, how they're describing it is that it's a glorified customer service rep lol and for like 60-70k, which I could get easily in this dept where I'm at

Ahsan (ahsan@shield-legal.com)
2025-04-25 12:05:04

If they give the title it’s worth it but otherwise not so much.

deleted-U072JS2NHRQ
2025-04-25 12:05:42

yeah, they said the title would be something like Case Audit Analyst or some shit

deleted-U072JS2NHRQ
2025-04-25 12:06:09

but I mean, i'll just aim for integrations next, edward said he's scared of the test that there might be for integrations going forward after they hired the last batch of guys

Ahsan (ahsan@shield-legal.com)
2025-04-25 12:06:21

Wtf? Why does this place not use normal titles

deleted-U072JS2NHRQ
2025-04-25 12:06:30

LITERALLY lol

deleted-U072JS2NHRQ
2025-04-25 12:06:42

Case Audit Analyst? what the fuck does that even MEAN lol

Ahsan (ahsan@shield-legal.com)
2025-04-25 12:07:10

Well a technical round makes sense but I am sure Dustin will make it stupidly annoying rather than something that is more like the day to day

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

yeah, cuz we all know Dustin is a twat

Ahsan (ahsan@shield-legal.com)
2025-04-25 12:12:51

Also he never hired any of us. He will want to build a team that is his image. We all made it work because of all the re org. Otherwise it was a complete mess. I had 3 bosses within 6 months

😂 deleted-U072JS2NHRQ
Ahsan (ahsan@shield-legal.com)
2025-04-25 12:13:01

That is chaotic and toxic af

deleted-U072JS2NHRQ
2025-04-25 12:26:25

yeah, this whole place is, I'm 100% applying at other places and leaving this bitch

deleted-U072JS2NHRQ
2025-04-25 12:27:02

the ONLY thing I'm worried about is using chatgpt with python, I want to get away from it and try and do it from scratch but I'm having trouble on how/where to start with it. I don't need chatGPT with SQL so I'm good with that

Ahsan (ahsan@shield-legal.com)
2025-04-25 12:35:24

Go on leetcode. These are the type of technical questions you can expect in interviews. Once you start clearing them by understanding the solution you will naturally develop the intuition needed to solve them in white board interview rounds

❤️ deleted-U072JS2NHRQ
deleted-U072JS2NHRQ
2025-04-25 12:59:26

thank you! I'll give that a try!

deleted-U072JS2NHRQ
2025-04-25 12:59:35

i got the 1st four hours here to do not a damn thing so I can do that lol

Ahsan (ahsan@shield-legal.com)
2025-04-25 13:03:04

Honestly that would be the best use of time. 2 months of solid grinding and I think will be solid for most l3/l2 roles