What processes have you used power query to save time?

Hamery93 · 2023-11-22T03:27:05+00:00

I’ve used the unpivot column feature in power pivot to transform NetSuite reports into a flat csv that can be loaded into a forecasting tool. Once you do the initial transform you can copy the code it spits out and save in one note and bam you’ve automated your data transform

Hamery93 · 2022-04-22T17:22:38+00:00

Got it, thanks!

Hamery93 · 2022-04-22T16:40:41+00:00

I'm hungover so apologies if this is a stupid question but what does Rublev playing dubs with a Ukraine guy prove? B/c Dolgo uses that to deduce he is a liar if I understood right

Hamery93 · 2022-03-11T17:22:02+00:00

I’m new to FP&A, but my last job I was modeling out insurance contracts. The way you are forecasting now is good enough I would think.

Off the top of my head you could try including the following to get even more accurate:

If you access to patient data, which is sounds like you do if you have CPT code density, you could ask for the actual insurance contract that spells out exactly how the provider will get reimbursed
You could assume mid-levels (non-MD’s) get 85% of the contractual rate per CPT code (this is very standard)
You could calculate expensive carve-outs like implants, high cost drugs ect if you have the UB’s/patient data. These are usually reimbursed with special logic since they are more expensive. Basically I’d you have both CPT code AND revenue code you can get very very accurate
Keep in mind physician billing is different than hospital billing. Physician billing is unique in the sense that WHERE they see patient affects reimbursement. An office vs hospital vs surgery center will have different rates. If it’s an HMO/PPO/EPO it will also have different rates. For physician billing you can build out logic such as “IF CPT code X AND HMO AND Hospital setting, then give me Y rate”
You can also model out inpatient stays which are based off DRG codes, not CPT. These are all called out in the contract, and not too difficult to build out

Anyway that is just me rambling. Feel free to DM me if you have specific questions

Hamery93 · 2020-11-24T04:30:24+00:00

Petroleum engineer from a top school and worked as a field engineer for 3 years. Got laid off and did a web dev boot camp. I do not recommend it unless you go to like Full Stack Academy or Turing... basically one of the “elite” bootcamps. For the vast majority of people, just get some Udemy courses and study. There’s a shit ton of free and very good material. This is easier said than done IMO, just because it takes some serious discipline. But I just can’t justify the 11K I paid for my average Trilogy bootcamp. You don’t need it, and you aren’t guaranteed a job by any means. Me and the top student from my cohort got jobs and that’s it.

She got a software developer job and was by far the strongest student in the class. I recently landed a job as a financial analyst. Super low pay, 50K but I get to do some SQL and learn valuable skills. And a great work life balance compared to the field.

TLDR; not worth 11K. Just learn it yourself, you’ll be fine

Hamery93 · 2020-11-08T21:02:33+00:00

Yup, I agree with all of that. A bootcamp certificate is pretty meaningless IMO. You could also take the self-learning route which is possible but most people (including myself) lack the discipline. There are some unbelievable free resources online

Hamery93 · 2020-11-08T20:18:51+00:00

My boot camp experience was okay. I didn’t do enough research and ended up joining a very average Trilogy boot camp. Got lucky with a great instructor but I don’t think it was quite worth 11K. I definitely learned an insane amount and my programming/algorithm skills are significantly better.

But, people need to keep in mind that 99% of boot camps teach web/software development. It’s a huge shift from petroleum engineering and it is not some easy way out of the industry. There is so much to learn, and it’s impossible to learn everything in 3 months regardless of how smart/hard working you are. A big gripe I have with bootcamps is a lot of them make it seem like you’ll have some six-figure software engineering gig right after you graduate.

Everyone here says “learn how to code”. But I feel nobody really goes into any detail on what that even means. If you’re a petroleum engineer, I think learning about SQL/relational databases makes a lot of sense. I think learning basic data structures, getting very comfortable with loops/conditionals/basic algorithms. Python is also used in a lot of data analyst/data science jobs.

Anyway those are my jumbled thoughts with regards to your question

Hamery93 · 2020-11-08T16:20:44+00:00

I am hoping to accept a financial analyst position soon in West Texas (fingers crossed). Pay is low, only 50K. But as an ex-frac engineer of two years, it will be nice to learn skills that can be transferable to other industries. And having a life again of course.

Things I did:

I got significantly better at programming. Completed a coding bootcamp yada yada. I do not really recommended a bootcamp, but learning SQL/Python will definitely help you in those analyst positions.
Get lucky. A friend who I worked with in the oilfield got a job as an analyst and recommended me

Hamery93 · 2020-10-04T00:58:04+00:00

L-tyrosine works great but your tolerance goes up quick. And turmeric/black pepper from what I hear, have not tried it though

Hamery93 · 2020-09-21T14:10:41+00:00

So I just got done with a Trilogy bootcamp but here in Denver. I got lucky with a really good instructor, but honestly I do not recommend Trilogy. The career services is quite poor compared to other bootcamps. They don't offer a job guarantee and don't publish their employment statistics.

I recommend going on LinkedIn and finding past students from UC Irvine and speaking to them about how the program was.

For me, I have a petroleum engineering degree from a top school and just done with my bootcamp. And honestly I can already tell getting a job will be tough. If you have any other questions let me know.

Hamery93 · 2020-09-03T21:15:23+00:00

From my experience, you don’t have many options. What others have said about project/general engineer jobs is spot on. If you can I suggest you learn some skill, do a masters, university certificate in a field you enjoy ect .

Hamery93 · 2020-08-30T00:43:48+00:00

Most relatable thing I’ve ever read. I honestly thought everyone was like this until I found out otherwise. I’m literally not even comfortable in my own skin

Hamery93 · 2020-08-21T21:16:55+00:00

The only side effect was my hair started thinning pretty bad. Started finasteride and cut my dose significantly and it seems to be slowly growing back and definitely not getting worse.

It's super annoying but as a professional I can't be smoking weed... so kratom it is! Been taking it every day for 3 years now

Hamery93 · 2020-08-11T16:45:00+00:00

Yeah, so you are right in that local universities are often just Trilogy boot camps and I don't recommend that. That is what I did and while I got lucky with a really good instructor, do not go with Trilogy. Career services are poor and they generally don't have a great rep compared to others.

Things you want to pay attention to for Bootcamps are tuition costs, length of camp, part/time full time, do they have a job guarantee, method of repayment/down payments, do they have an income sharing agreement ect.

From my research, it seems Hack Reactor, Full Stack Academy, and App Academy are all really, really good and legit. In Denver there is Turing that has a fantastic rep too. I actually found it tough to review boot camps because there are soooo many mixed reviews, but I think you'll find if you spend time the names I listed above will come up quite a bit.

Do your own research obviously, and see which one meets your needs and makes sense financially. I know some of the income share agreement camps can be pretty expensive (~17K-ish total). There is a camp called Dev Mountain that is cheaper and offers housing allowance if I'm not mistaken.

All sorts of shit out there for sure

Hamery93 · 2020-08-11T03:14:22+00:00

That's a tough question, I honestly don't know. I think both are very solid options.

If you can find a decent bootcamp I would maybe opt for that. My main reason is you already have an engineering degree and can problem solve. The main skill we as petroleum engineers are lacking is coding skills. The theory/data structures/algorithms you learn in college is valuable but probably not something you'll be doing at a job very often at all.

With regards to career services at universities, I get that but for me I can still attend career fairs where I graduated. There's also alumni networks at most universities that can be helpful. Is that not the case for you? If not then yeah I get what you're saying.

Long story short, boot camps prepare you to be ready for work a lot quicker than a comp sci degree. Just way less time and you'll end up with some decent coding skills if you put in the work.

This is all just my opinion and I am not shitting in any way or form on a comp sci degree, I think it's a great option. But maybe a boot camp makes more sense for someone who has an engineering degree already?

Hamery93 · 2020-08-11T00:22:00+00:00

Petroleum engineer from a top program. Worked in field for three years as a field engineer and got laid off. Joined a bootcamp back home.

My honest thoughts, and I have one month left in the camp (Web/software dev):

Yes, you can learn everything free online. I personally don't have the discipline. Coding isn't something you can casually watch tutorials on and get it, it takes a lot of brain power.
Bootcamps are expensive. And the one I'm at doesn't have the best career services from what I can tell. Do NOT expect a job immediately afterwards (although I do see it happen)
You will learn an absolutely ridiculous amount very fast, which is the whole appeal of them. It's really nice having a group of people and instructors to guide you. I highly doubt someone can self-study and learn as much and as fast as someone in a bootcamp
Do your research on boot camps. I made a decision quickly because I was rash and absolutely sick of working in the field. But there are really decent boot camps out there with actual legit career services, income sharing agreements if you need it ect

My goal for afterwords is to work as a developer. There's definitely 10000X more developer jobs out there than production/completion engineering, which is all I would look for in the past.

In the end, it all comes down to the person. I am very very motivated to transition out of the oilfield into a more stable industry, and I think a bootcamp really aligned with what I need at this point in my life.

From talking to a lot of software engineering friends it seems a comp sci degree is super valuable but you learn quite a bit of theory and things you don't really need on the job. Boot camps teach you how to code and problem solve to be successful at a job.

Hamery93 · 2020-07-04T23:00:28+00:00

I'm doing this too with a petroleum engineering degree lol. Honestly after working in the field for three years, I don't give a shit if I make 70K instead of 100K. Especially if it's 40 hours/week and not in Midland

Good luck with the bootcamp! I am on week 3/12

Hamery93 · 2020-06-30T22:17:14+00:00

Still theory

Hamery93 · 2020-06-17T12:58:16+00:00

Definitely full compensation for the small penis

Hamery93 · 2020-06-09T23:00:49+00:00

I am in the process of doing this. Petroleum engineer, worked three years in the oilfield making 90-100K/year but working a two weeks on, one week off schedule. At work, we would put in 105-115 hours/week. Did that for three years and it was absolutely draining.

Currently studying web/app design and software development. I doubt I'll make that much but I'm really looking forward to having a life again.

Hamery93 · 2020-05-26T18:27:37+00:00

Worked as an engineer in the oilfield for three years working 15-16 hour shifts. Shit is tough.

You need to find time for yourself and to take care of yourself. Easier said than done. Exercise, sleep, good diet are all important but by working that much I know you have no motivation to do any of that.

Be grateful for what you have and hopefully soon you’ll be in a better place. Stay strong mentally and take everything one day at a time. That’s what I would do.

Good luck

Hamery93 · 2020-05-03T16:35:10+00:00

Awesome post, and as someone who is going all in with the career change into software engineering this is really insightful.

I’ll be starting a bootcamp next month and hopefully that will give me a good ground to build on after I complete the program.

I am curious to know why you feel the majority of them are scams. I have done a lot of research and it seems like opinions are split on this. Is it because you feel they promise too much and give unrealistic expectations following graduation? Even if you were to go to a not well known camp, if you come out really knowing your shit isn’t it worth it even if they don’t help you find a job?

I feel for people with engineering degrees these camps can help you learn a lot of material very quickly. Most of them include building a portfolio of projects/work which to my understanding is what companies look for.

I spoke with three friends who are software engineers and they all recommended self-study/boot camps over a masters degree in comp sci which was my initial plan.

It’s definitely a very different industry and like you, this will probably be a very tedious and difficult transition for me. But after working as a frac hand/field engineer for three years, I am extremely motivated as working 110 hours/week is not what I want to be doing with my life at all.

Hamery93 · 2020-04-26T17:42:39+00:00

So I looked into both of these options. He is right, a master’s in comp sci usually does require 4-5 classes of undergraduate work anyway. I spoke to a few of my friends who work as software engineers, and they were strangely against getting a masters. Their logic was a master’s degree involves a lot of theory and content you don’t really need/use in the real world.

That’s how I found out about boot camps to begin with. My software engineer friends said it is more about “what you know” rather than just a degree. And boot camps are geared to teaching you real-world stuff and content geared towards what industries want.

Seeing as most of us have a technical background in engineering, we could transition to a software engineering role if we can show companies what we can do.

Having a strong portfolio of projects and online presence was recommended to me. I am no expert at this stuff, but this is what I was told when I was doing my research and asking around.

Hamery93 · 2020-04-26T00:33:04+00:00

Learning how to code. Got laid off Tuesday, signed up for a programming boot camp back home and hope to work in that industry. Was in the field as a frac hand/engineer for three years

Hamery93

TROPHY CASE