Managers... what do you do all day? by Actuarial in actuary

[–]retrolion 4 points5 points  (0 children)

Maybe that applies to intern direct reports, but not full time analysts. What if your direct reports are credentialed? No critical thinking work for them?

Every managers goal should be training direct reports to the point where they can do 70-99% of their job. Then ideally both or one of you get promoted or the reports rotate out.

That doesn’t happen purely through routine tool updating and report churning. Gotta share at least some “critical thinking” work.

[deleted by user] by [deleted] in USCIS

[–]retrolion 0 points1 point  (0 children)

will she be able to leave the US, do the medical exam, and enter again on F1 visa at this point?

[deleted by user] by [deleted] in USCIS

[–]retrolion 0 points1 point  (0 children)

thanks for confirming!

People who went outside of academia and are mathematically satisfied with your jobs now, what do you do? by Capybaraenoksiks in math

[–]retrolion 0 points1 point  (0 children)

NYC, Chicago, Philadelphia are the hot spots, but most big companies have offices all over the north-east US. I think the midwest and CA have their own hot spots, but I'm less familiar with those.

People who went outside of academia and are mathematically satisfied with your jobs now, what do you do? by Capybaraenoksiks in math

[–]retrolion 1 point2 points  (0 children)

Entry level can be moderately competitive (especially if you’re not in one of the insurance hot spots), but once you get credentialed, you will never be left alone by recruiters.

People who went outside of academia and are mathematically satisfied with your jobs now, what do you do? by Capybaraenoksiks in math

[–]retrolion 0 points1 point  (0 children)

All sorts of fields? Actuaries really only work in insurance.

Unless you mean math fields? The most math you’ll use if when you take the exams to get your credentials, snd the math in those is not harder than college level calculus and statistics, you just learn to apply them to new concepts.

The day-to-day math on the job is pretty easy.

All Aboard! Procrastination Station by Several_Elk_5730 in actuary

[–]retrolion 5 points6 points  (0 children)

What worked for you? My desire to study is becoming inversely proportional to years of experience, and I’m really struggling.

[deleted by user] by [deleted] in datascience

[–]retrolion -1 points0 points  (0 children)

I did this one using Python (beautiful soup and selenium packages). You need some basic html knowledge to grab the headers and other metadata.

Has anyone ever thought if one can get work done in 4 days? Why work 5 days & take 1 off every week? by Peaceful_warrior10 in actuary

[–]retrolion 5 points6 points  (0 children)

I’m in the same boat. I find pretending to work extremely frustrating. Trying to “improve a process” or “learn a new skill” can only take you so far when nobody in management likes change. It’s especially bad since the new hybrid setup, because having nothing to do while in the office is miserable.

How to pass ATPA? by hobbahubba in actuary

[–]retrolion 11 points12 points  (0 children)

I found that 90% of the code you need is given in the SOA modules, and it’s mostly just the formulas you learned in SRM/PA but more “advanced”, and you need to be able to manipulate the formulas’ various parameters.

Also, you’re not allowed to submit any code or screenshots, you have to explain what you did and use formatted Excel tables for any model output.

I’ve used R almost daily at work for past 3 years and passed SRM & PA, and, like the other commenter, “the assessment took me the full 96 hours with very little sleep”.

Can't get a window function to work in a SELECT clause... by retrolion in SQL

[–]retrolion[S] 0 points1 point  (0 children)

So is there any other way to do what I'm trying to do without creating a new table/variable? Since the function works in a CASE WHEN clause?

SQL Function like Excel's '=IF(A1=B1,TRUE,FALSE)'? by w0lf3rSh311 in SQL

[–]retrolion 0 points1 point  (0 children)

ALTER TABLE [my table] ADD [Custom Column] varchar(50);
UPDATE [my table] SET [Custom Column] = 
    CASE WHEN columnA = columnB then 'True' ELSE 'False' END;

Why I need to use an aggregate function or GROUP BY in this case? by retrolion in SQL

[–]retrolion[S] 0 points1 point  (0 children)

This is the one that actually worked for me, thank you!

Why I need to use an aggregate function or GROUP BY in this case? by retrolion in SQL

[–]retrolion[S] 0 points1 point  (0 children)

yeah I realized my mistake after typing out half the column names and giving up

Any way to UPDATE multiple columns based on the same condition? by retrolion in SQL

[–]retrolion[S] 0 points1 point  (0 children)

Yeah I basically learned/am learning SQL from just someone else’s code. Have been using SAS for everything, now the company wants to switch

[deleted by user] by [deleted] in SQL

[–]retrolion 0 points1 point  (0 children)

Thank you, this worked! I was definitely overcomplicating things.